JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides | Schema:
920 910 812
System  Table 
Column 
Searchbeta 

JDE Ref icon of database logic symbolJDE TABLESv3Made in Britain

SAPTables.Net - the webs number one SAP Tables Definition reference

920: Top 10 requests

TablePrefixDescription
1F4211SDSales Order Detail File
2F0101ABAddress Book Master
3F4101IMItem Master
4F0911GLAccount Ledger
5F4311PDPurchase Order Detail File
6F4102IBItem Branch File
7F0411RPAccounts Payable Ledger
8F41021LIItem Location File
9F03012AICustomer Master by Line of Business
10F0006MCBusiness Unit Master

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F4311PDPurchase Order Detail File
8F03B11RPCustomer Ledger
9F0411RPAccounts Payable Ledger
10F07831YBEmployee State/Local Control Table

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4211SDSales Order Detail File
4F4311PDPurchase Order Detail File
5F0411RPAccounts Payable Ledger
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F03012AICustomer Master by Line of Business
9F4801WAWork Order Master File
10F42119SDSales Order History File
PHPRef.com - the webs number one PHP Function reference tool

397 columns | Print definition?920 | UOM | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0018Taxes28TDUOMUnit of Measure as InputStringUDC20
2F4008Tax Areas23TAUOMUnit of Measure as InputStringUDC20
TOP04: Accounts Payable
3F09UI006Tax (F0018) Replica28TDUOMUnit of Measure as InputStringUDC20
TOP07: Payroll
4F0716701Employee Assignment T/E Template Information48EAUOMUnit of Measure as InputStringUDC20
5F0716709Employee Assignment T/E Template Info History48EAUOMUnit of Measure as InputStringUDC20
TOP16: Profit Management (EPS)
6F1630Driver Definitions8CDUOMUnit of Measure as InputStringUDC20
7F1632Driver Balances18CBUOMUnit of Measure as InputStringUDC20
8F1632Z1External Driver Balances-Interoperability Table40CYUOMUnit of Measure as InputStringUDC20
TOP17: Customer Service Management
9F3112Z2Warranty Claim/Supplier Recovery processing64WLUOMUnit of Measure as InputStringUDC20
10F4801Z2Warranty Claim/Supplier Recovery processing87WSUOMUnit of Measure as InputStringUDC20
TOP30: Product Data Management
11F300210Lean Multi Level Bill of Material Header6EHUOMUnit of Measure as InputStringUDC20
12F300211Lean Multi Level Bill of Material Detail20EDUOMUnit of Measure as InputStringUDC20
13F3002Z1Bill of Material Transaction File29SZUOMUnit of Measure as InputStringUDC20
14F300311Lean Multi-Level Routing Detail File16EHUOMUnit of Measure as InputStringUDC20
15F3003Z1Routing Transactions File31SZUOMUnit of Measure as InputStringUDC20
16F3016Kanban Master16KMUOMUnit of Measure as InputStringUDC20
17F30UI008Bill of Material Comparison Work File7IJUOMUnit of Measure as InputStringUDC20
18F30UI014BOM Header Work File for BI7BHUOMUnit of Measure as InputStringUDC20
19F30UI015BOM Item Fact Work File for BI6BDUOMUnit of Measure as InputStringUDC20
20F30UI016BOM Explosion Work File for BI5BEUOMUnit of Measure as InputStringUDC20
TOP30A: Product Costing
21F30UI012Work File for Parent Child12PCUOMUnit of Measure as InputStringUDC20
TOP31: Shop Floor Control
22F3102Production Cost25IGUOMUnit of Measure as InputStringUDC20
23F3102SPurge - Production Cost25IGUOMUnit of Measure as InputStringUDC20
24F3102WFProduction Cost Work File25IGUOMUnit of Measure as InputStringUDC20
25F3109Line/Item Relationship Master6IPUOMUnit of Measure as InputStringUDC20
26F31091Schedule Quantity Detail11IQUOMUnit of Measure as InputStringUDC20
27F31091SSchedule Quantity Detail Purge11IQUOMUnit of Measure as InputStringUDC20
28F3112Work Order Routing52WLUOMUnit of Measure as InputStringUDC20
29F31122Work Order Time Transactions30WTUOMUnit of Measure as InputStringUDC20
30F31122SPurge Work Order Time Transactions30WTUOMUnit of Measure as InputStringUDC20
31F31122Z1Work Order Time Transactions Unedited Transaction Table44SZUOMUnit of Measure as InputStringUDC20
32F3112SPurge Shop Floor Control Routing Instructions52WLUOMUnit of Measure as InputStringUDC20
33F3112Z1Outbound Work Order Routings64SZUOMUnit of Measure as InputStringUDC20
34F3114Rate Schedule Transaction File9IQUOMUnit of Measure as InputStringUDC20
35F3115Net Change Transaction table12NCUOMUnit of Measure as InputStringUDC20
36F31UI002User Index - Variances17IGUOMUnit of Measure as InputStringUDC20
37F31UI006Line Scheduling Workbench - Work File15LSUOMUnit of Measure as InputStringUDC20
TOP31A: Manufacturing Accounting
38F30UI003WIP Revaluation Work File14WRUOMUnit of Measure as InputStringUDC20
TOP31B: Blend Management
39F31B052Equipment Assignments23EAUOMUnit of Measure as InputStringUDC20
40F31B053Consumable Assignments28CAUOMUnit of Measure as InputStringUDC20
41F31B99Decant Detail9DDUOMUnit of Measure as InputStringUDC20
TOP31P: Engineer To Order
42F31P11Project Quote Detail26QPUOMUnit of Measure as InputStringUDC20
TOP32: Configuration Management
43F3215Configurator Component Table8CCUOMUnit of Measure as InputStringUDC20
44F32159Configurator Component History Table8CHUOMUnit of Measure as InputStringUDC20
45F32GOPConfigurator GOP23GPUOMUnit of Measure as InputStringUDC20
TOP33: Capacity Planning
46F33UI001Shop Floor Control Routing Instructions21WLUOMUnit of Measure as InputStringUDC20
TOP34X: In-Memory Planning Advisor
47F34X200WPlanning Details Supply/Demand Work Table18SDUOMUnit of Measure as InputStringUDC20
TOP37: Quality Management
48F37900Certificate of Analysis (COA) Extract77TRUOMUnit of Measure as InputStringUDC20
49F40318Preference Profile - Quality Management9QCUOMUnit of Measure as InputStringUDC20
TOP38: Agreement Management
50F38011Agreement Quantities11DFUOMUnit of Measure as InputStringUDC20
51F38012Product Source/Destination Master14DPUOMUnit of Measure as InputStringUDC20
52F38014Agreement Formulas and Factors5DRUOMUnit of Measure as InputStringUDC20
53F38111Agreements Transaction Ledger34DZUOMUnit of Measure as InputStringUDC20
54F38112Agreements Committed Quantities15DXUOMUnit of Measure as InputStringUDC20
TOP39: Advanced Stock Valuation
55F39041Valuation Category Master4VCUOMUnit of Measure as InputStringUDC20
56F39061Valuation Period Table9SOUOMUnit of Measure as InputStringUDC20
57F390619Historical Valuation Period Detail Table9SOUOMUnit of Measure as InputStringUDC20
58F39062Valuation Layers Table12STUOMUnit of Measure as InputStringUDC20
59F39063Period Additional Quantity Table9SUUOMUnit of Measure as InputStringUDC20
60F390639Historical Additional Quantity Table9SUUOMUnit of Measure as InputStringUDC20
61F39064Valuation Document Summary Table9DSUOMUnit of Measure as InputStringUDC20
62F390649Historical Valuation Document Summary Table9DSUOMUnit of Measure as InputStringUDC20
63F39121WAdditional Quantity Work File7AQUOMUnit of Measure as InputStringUDC20
TOP40: Inventory/OP Base
64F3002Bill of Material Master File16IXUOMUnit of Measure as InputStringUDC20
65F3003Routing Master File18IRUOMUnit of Measure as InputStringUDC20
66F3011Bill of Materials Change File16IZUOMUnit of Measure as InputStringUDC20
67F3013ECO Parts List Detail13CYUOMUnit of Measure as InputStringUDC20
68F30UI002Bill of Material Structure Analysis Work File10IXUOMUnit of Measure as InputStringUDC20
69F30UI004Bill of Material Update Work File16WFUOMUnit of Measure as InputStringUDC20
70F40051Return Material Authorization31RDUOMUnit of Measure as InputStringUDC20
71F4011ZBatch Receiver File - Order Details80SZUOMUnit of Measure as InputStringUDC20
72F4012ZWWF - Destination Quantity28SPUOMUnit of Measure as InputStringUDC20
73F4013ZKit Components Batch File14KSUOMUnit of Measure as InputStringUDC20
74F4015Order Templates8OTUOMUnit of Measure as InputStringUDC20
75F40300RPreference Resolution History - Master9PMUOMUnit of Measure as InputStringUDC20
76F40301Preference Profile - Payment Terms9PTUOMUnit of Measure as InputStringUDC20
77F40301RPreference Resolution Ledger - Payment Terms11PTUOMUnit of Measure as InputStringUDC20
78F40302Preference Profile - Unit of Measure9PUUOMUnit of Measure as InputStringUDC20
79F40302RPreference Resolution Ledger - Pricing Unit Of Measure11PUUOMUnit of Measure as InputStringUDC20
80F40303Preference Profile - Revenue Cost Center9RVUOMUnit of Measure as InputStringUDC20
81F40303RPreference Resolution Ledger - Revenue Business Unit11RVUOMUnit of Measure as InputStringUDC20
82F40304Preference Profile - End Use9PEUOMUnit of Measure as InputStringUDC20
83F40304RPreference Resolution Ledger - End Use11PEUOMUnit of Measure as InputStringUDC20
84F40305Preference Profile - Print Messages9RMUOMUnit of Measure as InputStringUDC20
85F40305RPreference Resolution Ledger - Print Messages11RMUOMUnit of Measure as InputStringUDC20
86F40306Preference Profile - Inventory Sourcing9SRUOMUnit of Measure as InputStringUDC20
87F40307Preference Profile - Product Allocations9LAUOMUnit of Measure as InputStringUDC20
88F40308Preference Profile - Grade and Potency9GSUOMUnit of Measure as InputStringUDC20
89F40308RPreference Resolution Ledger - Grade and Potency11GSUOMUnit of Measure as InputStringUDC20
90F40309Preference Profile - Delivery Date9DYUOMUnit of Measure as InputStringUDC20
91F40309RPreference Resolution Ledger - Delivery Date11DYUOMUnit of Measure as InputStringUDC20
92F40310Preference Profile - Line of Business9LBUOMUnit of Measure as InputStringUDC20
93F40310RPreference Resolution Ledger - Line Of Business11LBUOMUnit of Measure as InputStringUDC20
94F40311Preference Profile - Price Code 19P1UOMUnit of Measure as InputStringUDC20
95F40311RPreference Resolution Ledger - User Defined Price Code #111P1UOMUnit of Measure as InputStringUDC20
96F40312Preference Profile - Price Code 29P2UOMUnit of Measure as InputStringUDC20
97F40312RPreference Resolution Ledger - User Defined Price Code #211P2UOMUnit of Measure as InputStringUDC20
98F40313Preference Profile - Price Code 39P3UOMUnit of Measure as InputStringUDC20
99F40313RPreference Resolution Ledger - User Defined Price Code #311P3UOMUnit of Measure as InputStringUDC20
100F40314Preference Profile - Price Adjustment Schedule9PJUOMUnit of Measure as InputStringUDC20
101F40314RPreference Resolution Ledger - Price Adjustment Schedule11PJUOMUnit of Measure as InputStringUDC20
102F40315Preference Profile - Invoice Cycling9PIUOMUnit of Measure as InputStringUDC20
103F40315RPreference Resolution Ledger - Invoice Cycle11PIUOMUnit of Measure as InputStringUDC20
104F40316Preference Profile - Order Preparation9OPUOMUnit of Measure as InputStringUDC20
105F40316RPreference Resolution Ledger - Order Preparation Days11OPUOMUnit of Measure as InputStringUDC20
106F40318RPreference Resolution Ledger - Quality Management11QCUOMUnit of Measure as InputStringUDC20
107F40320Preference Profile - Multi Shipping/Receiving Locations9LPUOMUnit of Measure as InputStringUDC20
108F40320RPreference Resolution Ledger - Multi ShiP/Rec Locations10LPUOMUnit of Measure as InputStringUDC20
109F40329Preference Profile - Document Distribution9DDUOMUnit of Measure as InputStringUDC20
110F40330Preference Profile - Document Set9DGUOMUnit of Measure as InputStringUDC20
111F40331Preference Profile - Options and Equipment9OEUOMUnit of Measure as InputStringUDC20
112F40332Preference Profile - Customer Freight9CFUOMUnit of Measure as InputStringUDC20
113F40333Preference Profile - Carrier9CAUOMUnit of Measure as InputStringUDC20
114F40334Preference Profile - Mode of Transport9MTUOMUnit of Measure as InputStringUDC20
115F40338Preference Profile - Payment Terms (Branch)9PTUOMUnit of Measure as InputStringUDC20
116F40338RPreference Resolution Ledger - Payment Terms (Branch)11PTUOMUnit of Measure as InputStringUDC20
117F40339Preference Profile - Product Allocations (Branch)9LAUOMUnit of Measure as InputStringUDC20
118F40341Preference Profile - Next Order Status9NSUOMUnit of Measure as InputStringUDC20
119F40341RPreference Resolution Ledger - Next Order Status11NSUOMUnit of Measure as InputStringUDC20
120F40344Preference Profile - Sales Commission9SAUOMUnit of Measure as InputStringUDC20
121F40344RPreference Resolution Ledger - Sales Commission11SAUOMUnit of Measure as InputStringUDC20
122F40345Preference Profile - Customer Currency9CRUOMUnit of Measure as InputStringUDC20
123F40345RPreference Resolution Ledger - Customer Currency11CRUOMUnit of Measure as InputStringUDC20
124F40347Preference Profile - Pricing UOM (Branch)9RIUOMUnit of Measure as InputStringUDC20
125F40347RPreference Resolution Ledger - Pricing UOM (Branch)11RIUOMUnit of Measure as InputStringUDC20
126F40349Preference Profile - Revenue Business Unit (Branch)9RVUOMUnit of Measure as InputStringUDC20
127F40349RPreference Resolution Ledger - Revenue Bus Unit (Branch)11RVUOMUnit of Measure as InputStringUDC20
128F40350Preference Profiles - Conatiner Deposit/Rental9OQUOMUnit of Measure as InputStringUDC20
129F40P01Promotion Header File13PHUOMUnit of Measure as InputStringUDC20
130F40P011Promotion Deal Detail File14PDUOMUnit of Measure as InputStringUDC20
131F40UI002Supplier History Rebuild -workfile8UTUOMUnit of Measure as InputStringUDC20
132F40UI17Allocation Work File19ZGUOMUnit of Measure as InputStringUDC20
133F40UI74Price Adjustment History Work File22AWUOMUnit of Measure as InputStringUDC20
134F4106Item Base Price File13BPUOMUnit of Measure as InputStringUDC20
135F4211Z1Sales Order Detail Unedited Transaction File77SZUOMUnit of Measure as InputStringUDC20
136F43800Summary Voucher Match13PRUOMUnit of Measure as InputStringUDC20
TOP40G: Grower Management
137F40G032Harvest Estimate Freeze Detail17FDUOMUnit of Measure as InputStringUDC20
138F40G103EUR - Intended Use Distribution12IUUOMUnit of Measure as InputStringUDC20
139F40G150Crush and Purchase Report Details32CPUOMUnit of Measure as InputStringUDC20
140F40G95Pay On Proceeds Log File16PPUOMUnit of Measure as InputStringUDC20
TOP40R: Demand Scheduling
141F40R11Demand Detail18DDUOMUnit of Measure as InputStringUDC20
142F40R121CUM Required Quantities Detail Table6CRUOMUnit of Measure as InputStringUDC20
143F40R13Demand Packaging6DPUOMUnit of Measure as InputStringUDC20
144F40R30WFDemand Work File19DSUOMUnit of Measure as InputStringUDC20
145F40R41Demand History23DIUOMUnit of Measure as InputStringUDC20
146F47173EDI Demand Scheduling Detail23ESUOMUnit of Measure as InputStringUDC20
147F471731EDI Demand Packaging17EPUOMUnit of Measure as InputStringUDC20
148F47UI002ASN Extract Packaging Work File37SPUOMUnit of Measure as InputStringUDC20
TOP41: Inventory Management
149F41131Stranded Hard Commitments Table20IUUOMUnit of Measure as InputStringUDC20
150F4131Consignment Master Detail (FUTURE)10MDUOMUnit of Measure as InputStringUDC20
151F4133Usage Detail (FUTURE)10UDUOMUnit of Measure as InputStringUDC20
152F4141Z1F4141 Cycle Count Unedited Transaction Table34SZUOMUnit of Measure as InputStringUDC20
153F4160Tag Inventory File19ITUOMUnit of Measure as InputStringUDC20
TOP41F: Apparel Management
154FCW11Item Base Price File Work File12WPUOMUnit of Measure as InputStringUDC20
155FCW68Style Work Order Routings55WLUOMUnit of Measure as InputStringUDC20
156FCW71Supplier Price/Catalog File - Detail25CBUOMUnit of Measure as InputStringUDC20
TOP42: Sales Management
157F4074Price Adjustment Ledger File16ALUOMUnit of Measure as InputStringUDC20
158F420UI55Kit Balance Work File16UIUOMUnit of Measure as InputStringUDC20
159F4211Sales Order Detail File64SDUOMUnit of Measure as InputStringUDC20
160F42119Sales Order History File64SDUOMUnit of Measure as InputStringUDC20
161F42199S.O. Detail Ledger File64SLUOMUnit of Measure as InputStringUDC20
162F42565Invoice Print File21IWUOMUnit of Measure as InputStringUDC20
163F4290Delivery Note History19SEUOMUnit of Measure as InputStringUDC20
164F42UI11SO Detail Cache File (MBF)52ZDUOMUnit of Measure as InputStringUDC20
165F42UI12Sales Order Detail Cache 2 (MBF)74ZDUOMUnit of Measure as InputStringUDC20
166F42UI130Commitment Work File14ZCUOMUnit of Measure as InputStringUDC20
167F42UI521Pick Slips Detail File60S9UOMUnit of Measure as InputStringUDC20
168F42UI800Sales Detail Work File - Sales Update51SDUOMUnit of Measure as InputStringUDC20
TOP42B: Sales Order Entry
169F4211SWSales Order Detail Summary Work File6SSUOMUnit of Measure as InputStringUDC20
170F42216WFPending Blanket Release Work File - F42216WF9PBUOMUnit of Measure as InputStringUDC20
171F42420Audit Log Transaction18ALUOMUnit of Measure as InputStringUDC20
172F42440Customer Segment Items5CSUOMUnit of Measure as InputStringUDC20
173F42UI440Customer Segment Items - Work File5CSUOMUnit of Measure as InputStringUDC20
TOP42I: Outbound Inventory Management
174F42I011Outbound Inventory Agreement Details20OQUOMUnit of Measure as InputStringUDC20
175F42I03Outbound Order Consumption Report File17OIUOMUnit of Measure as InputStringUDC20
176F42I07Outbound Inventory Agreement Details Change History12OQUOMUnit of Measure as InputStringUDC20
TOP42W: Fulfilment Management
177F427UI01Release Fulfillment Work File15RFUOMUnit of Measure as InputStringUDC20
TOP42X: In-Memory Sales Advisor
178F42X010WLine Advisor Work File6USUOMUnit of Measure as InputStringUDC20
179F42X020WOrder Advisor Work File6XCUOMUnit of Measure as InputStringUDC20
180F42X040WOrder Upsell Item Group Totals Work File13GRUOMUnit of Measure as InputStringUDC20
181F42X041WOrder Upsell Item Group Opportunities WF8BRUOMUnit of Measure as InputStringUDC20
182F42X050WOrder Level Upsell Candidate Items8CIUOMUnit of Measure as InputStringUDC20
183F42X060WSupply Monitor Chart Work File21DCUOMUnit of Measure as InputStringUDC20
TOP43: Procurement
184F41061Supplier Price/Catalog File14CBUOMUnit of Measure as InputStringUDC20
185F43080Approvals Fields Constants67PDUOMUnit of Measure as InputStringUDC20
186F43092Purchase Order Receipt Routing File20PXUOMUnit of Measure as InputStringUDC20
187F43092ZReceipt Routing Work File12PVUOMUnit of Measure as InputStringUDC20
188F43092Z1Receipt Routing Unedited Transaction Table33SZUOMUnit of Measure as InputStringUDC20
189F43099Receipt Routing Ledger File7POUOMUnit of Measure as InputStringUDC20
190F4311Purchase Order Detail File60PDUOMUnit of Measure as InputStringUDC20
191F4311ZPurchase Order Generator File64PWUOMUnit of Measure as InputStringUDC20
192F4311Z1Purchase Order Detail Unedited Transaction Table73SZUOMUnit of Measure as InputStringUDC20
193F43121Purchase Order Receiver File65PRUOMUnit of Measure as InputStringUDC20
194F43121ZReceiver workfile61PWUOMUnit of Measure as InputStringUDC20
195F43121Z1Receipts Unedited Transaction Table82SZUOMUnit of Measure as InputStringUDC20
196F43147Freight Distribution Workfile28FDUOMUnit of Measure as InputStringUDC20
197F4314ZVoucher Match Selection File165PNUOMUnit of Measure as InputStringUDC20
198F43199P.O. Detail Ledger File - Flexible Version60OLUOMUnit of Measure as InputStringUDC20
199F4340Purchase Rebate Master File8RDUOMUnit of Measure as InputStringUDC20
200F4343Purchase Rebate History16RHUOMUnit of Measure as InputStringUDC20
201F43632ZOpen Purchase Order by Item Work File19OIUOMUnit of Measure as InputStringUDC20
202F43UI50DPO Print Detail Work File11PWUOMUnit of Measure as InputStringUDC20
TOP43C: Contracts
203F43C10Contract Block13CBUOMUnit of Measure as InputStringUDC20
204F43C100Contract Block Profile24BPUOMUnit of Measure as InputStringUDC20
205F43C11Contract Detail14CDUOMUnit of Measure as InputStringUDC20
206F43C110Contract Harvest Profile12DPUOMUnit of Measure as InputStringUDC20
TOP43E: Requisition Self Service
207F43E09F43E09 - Approvals Activity Table26AAUOMUnit of Measure as InputStringUDC20
208F43E11Requisition Detail24RDUOMUnit of Measure as InputStringUDC20
209F43E121eRequisition Receiver file23ERUOMUnit of Measure as InputStringUDC20
210F43E20Shopping Cart Detail9SCUOMUnit of Measure as InputStringUDC20
211F43E20WFeReq - Shopping Cart Work File15SWUOMUnit of Measure as InputStringUDC20
TOP43Q: Strategic Sourcing
212F43Q11Event Detail20EDUOMUnit of Measure as InputStringUDC20
213F43Q20Event Header Bid Questions9EHUOMUnit of Measure as InputStringUDC20
214F43Q21Event Detail Bid Questions10EDUOMUnit of Measure as InputStringUDC20
215F43Q51Analyze Event Detail11EDUOMUnit of Measure as InputStringUDC20
216F43Q60Bid Questions10BQUOMUnit of Measure as InputStringUDC20
217F43Q62Bid Question Price Component6BCUOMUnit of Measure as InputStringUDC20
TOP43S: JSSS/Supplier Self Service
218F4313POFLIP25PFUOMUnit of Measure as InputStringUDC20
TOP44H: Homebuilder Management
219F44H602Takeoff Master File15TOUOMUnit of Measure as InputStringUDC20
220F44H602HTakeoff History File16THUOMUnit of Measure as InputStringUDC20
221F44H602WTake Off Summary Workfile17TSUOMUnit of Measure as InputStringUDC20
222F44H611Bid Details46BDUOMUnit of Measure as InputStringUDC20
223F44H611WBid Details Work File50BWUOMUnit of Measure as InputStringUDC20
224F44H711Lot Start Workfile53SWUOMUnit of Measure as InputStringUDC20
225F44H711PAfter Start Purchasing22TPUOMUnit of Measure as InputStringUDC20
226F44H711ZHB Lot Start Unedited Transaction File66SZUOMUnit of Measure as InputStringUDC20
227F44H71W1Lot Start Generation Workfile53GWUOMUnit of Measure as InputStringUDC20
228F44H73W1Lot Start - P.O. / Committment Generation Work File34CGUOMUnit of Measure as InputStringUDC20
TOP45: Advanced Pricing
229F4072Price Adjustment Detail10ADUOMUnit of Measure as InputStringUDC20
230F4072PPrice Adjustment Detail Purge11ADUOMUnit of Measure as InputStringUDC20
231F4072WPrice Adjustment Detail Work File10ADUOMUnit of Measure as InputStringUDC20
232F4073Free Goods Master File7FGUOMUnit of Measure as InputStringUDC20
233F4073PFree Goods Master File Purge8FGUOMUnit of Measure as InputStringUDC20
234F4075Price Variable Table3VBUOMUnit of Measure as InputStringUDC20
235F4077Rebate Thresholds11RTUOMUnit of Measure as InputStringUDC20
236F4077PRebate Thresholds Purge12RTUOMUnit of Measure as InputStringUDC20
237F4078Rebate Transaction Summary13RHUOMUnit of Measure as InputStringUDC20
238F4079Rebate Transaction Detail17SVUOMUnit of Measure as InputStringUDC20
239F4511WPricing Structure View48APUOMUnit of Measure as InputStringUDC20
240F4550Basket Master Header3BHUOMUnit of Measure as InputStringUDC20
241F4551Basket Master Detail8BDUOMUnit of Measure as InputStringUDC20
242F45521Price List Detail11PDUOMUnit of Measure as InputStringUDC20
243F45522Price List Level-Break Pattern5PLUOMUnit of Measure as InputStringUDC20
244F45715Adjustment Balances29ABUOMUnit of Measure as InputStringUDC20
245F4572Z1Live Promotions Interface - Inbound / Outbound28LPUOMUnit of Measure as InputStringUDC20
246F4572ZPPurge Live Promotions Interface28PGUOMUnit of Measure as InputStringUDC20
247F4573Free Goods Reference File8RFUOMUnit of Measure as InputStringUDC20
248F4574Key Reference Table17KRUOMUnit of Measure as InputStringUDC20
249F4575Ship and Debit History21AHUOMUnit of Measure as InputStringUDC20
250F4575TMPShip and Debit History - Temp Table21AHUOMUnit of Measure as InputStringUDC20
251F4576Ship and Debit Claims48ACUOMUnit of Measure as InputStringUDC20
252F4576TMPShip and Debit Claims- Temp Table48ACUOMUnit of Measure as InputStringUDC20
253F4576Z1Ship and Debit Claims Unedited Transaction Table61Z1UOMUnit of Measure as InputStringUDC20
TOP46: Warehouse Management
254F4142Warehouse Count Transactions38CTUOMUnit of Measure as InputStringUDC20
255F4600Warehouse Requests26R1UOMUnit of Measure as InputStringUDC20
256F4600PUWarehouse Requests - Purged26R1UOMUnit of Measure as InputStringUDC20
257F46011Item Unit Of Measure Definition4IQUOMUnit of Measure as InputStringUDC20
258F46012Fixed Locations4ISUOMUnit of Measure as InputStringUDC20
259F46013Carton Recommendation Rules4EQUOMUnit of Measure as InputStringUDC20
260F460131Standard Pack Recommendation Rules6SPUOMUnit of Measure as InputStringUDC20
261F46015Replenishment Information by Random Rule10RRUOMUnit of Measure as InputStringUDC20
262F46024Location Capacity5LCUOMUnit of Measure as InputStringUDC20
263F46025Maximum Putaway Quantity by Zone4MQUOMUnit of Measure as InputStringUDC20
264F46095Movement Instructions7ETUOMUnit of Measure as InputStringUDC20
265F46096Unit Of Measure Groups2OUUOMUnit of Measure as InputStringUDC20
266F46130Putaway Reservations16R3UOMUnit of Measure as InputStringUDC20
267F46130PUPutaway Reservations - Purged16R3UOMUnit of Measure as InputStringUDC20
268F4615Carton Recommendations8CRUOMUnit of Measure as InputStringUDC20
269F4620Carton Detail Information6CDUOMUnit of Measure as InputStringUDC20
270F46200Bulk Pick Requests8BRUOMUnit of Measure as InputStringUDC20
271F46200PUBulk Pick Requests - Purged8BRUOMUnit of Measure as InputStringUDC20
272F46UI15Carton Recommendations - Work File8RCUOMUnit of Measure as InputStringUDC20
273F4942Z1Work File for F494228SYUOMUnit of Measure as InputStringUDC20
TOP46L: License Plating
274F46L42License Plate Cycle and Tag Count16CCUOMUnit of Measure as InputStringUDC20
275F46L99License Plate History38LMUOMUnit of Measure as InputStringUDC20
276F46LUI01Assign/Remove Items To LP Work File18WFUOMUnit of Measure as InputStringUDC20
277F46LUI02Work Table for Manual Build UOM Structure5LPUOMUnit of Measure as InputStringUDC20
TOP47: Electronic Commerce
278F47012EDI Purchase Order Detail - Inbound81SZUOMUnit of Measure as InputStringUDC20
279F47017EDI Purchase Order Detail - Outbound74SZUOMUnit of Measure as InputStringUDC20
280F47022EDI P.O. Acknowledgment Detail - Inbound74SZUOMUnit of Measure as InputStringUDC20
281F47027EDI P.O. Acknowledgment Detail - Outbound81SZUOMUnit of Measure as InputStringUDC20
282F47032EDI Shipping Notice Detail - Inbound57SZUOMUnit of Measure as InputStringUDC20
283F47037EDI Shipping Notice Detail - Outbound78SZUOMUnit of Measure as InputStringUDC20
284F470371EDI Shipping Notice Detail - Outbound88SZUOMUnit of Measure as InputStringUDC20
285F470372EDI ASN Demand Scheduling Detail22AIUOMUnit of Measure as InputStringUDC20
286F470375EDI ASN Packaging Detail22AKUOMUnit of Measure as InputStringUDC20
287F47042EDI Invoice Detail - Inbound58SZUOMUnit of Measure as InputStringUDC20
288F47047EDI Invoice Detail (Sales) - Outbound81SZUOMUnit of Measure as InputStringUDC20
289F47062EDI Planning Schedule Detail - Inbound21MYUOMUnit of Measure as InputStringUDC20
290F47067EDI Planning Schedule Detail - Outbound21MYUOMUnit of Measure as InputStringUDC20
291F47072EDI Receiving Advice Detail - Inbound75SZUOMUnit of Measure as InputStringUDC20
292F47077EDI Receiving Advice Detail - Outbound75SZUOMUnit of Measure as InputStringUDC20
293F47082EDI Price Sales Catalog Detail - Inbound68FYUOMUnit of Measure as InputStringUDC20
294F47092EDI Request for Quote Detail - Inbound81SZUOMUnit of Measure as InputStringUDC20
295F47097EDI Request for Quote Detail - Outbound74SZUOMUnit of Measure as InputStringUDC20
296F47102EDI Response to RFQ Detail - Inbound74SZUOMUnit of Measure as InputStringUDC20
297F47107EDI Response to RFQ Detail - Outbound81SZUOMUnit of Measure as InputStringUDC20
298F47132EDI Purchase Order Change Detail - Inbound82SZUOMUnit of Measure as InputStringUDC20
299F47137EDI Purchase Order Change Detail - Outbound75SZUOMUnit of Measure as InputStringUDC20
300F47142EDI P.O. Change Acknowledgment Detail - Inbound76SZUOMUnit of Measure as InputStringUDC20
301F47147EDI P.O. Change Acknowledgment Detail - Outbound83SZUOMUnit of Measure as InputStringUDC20
302F47157EDI Shipping Schedule Detail - Outbound80SZUOMUnit of Measure as InputStringUDC20
303F47182EDI Consumption Detail (FUTURE)8EDUOMUnit of Measure as InputStringUDC20
304F47191EDI Acknowledgement Header42AHUOMUnit of Measure as InputStringUDC20
305F47UI001ASN Extract Work File36SZUOMUnit of Measure as InputStringUDC20
TOP48: Work Order Processing
306F4801Work Order Master File68WAUOMUnit of Measure as InputStringUDC20
307F4801SPurge - Work Order Master file68WAUOMUnit of Measure as InputStringUDC20
308F4801Z1Outbound Work Order Header87SYUOMUnit of Measure as InputStringUDC20
309F48UI001X4801 Master Business Function Workfile71WAUOMUnit of Measure as InputStringUDC20
TOP49: Transportation Management
310F49110Transportation Bill of Lading Workfile41BWUOMUnit of Measure as InputStringUDC20
311F4942Shipment Detail13ISUOMUnit of Measure as InputStringUDC20
312F4945Shipment Charges22SCUOMUnit of Measure as InputStringUDC20
313F4962Load Compartments12TEUOMUnit of Measure as InputStringUDC20
314F49621Load Compartment Detail26TDUOMUnit of Measure as InputStringUDC20
315F49634Load In-Transit Confirmed Quantities Detail11QDUOMUnit of Measure as InputStringUDC20
316F4981Freight Audit History30FHUOMUnit of Measure as InputStringUDC20
317F49T20Shipment Staging Table18SSUOMUnit of Measure as InputStringUDC20
TOP54HS: Health & Safety Incident Mgt
318F54HS02Incident People26S2UOMUnit of Measure as InputStringUDC20
319F54HS02MIncident People Change History29I2UOMUnit of Measure as InputStringUDC20
320F54HS08Incident Environmental Impact11S9UOMUnit of Measure as InputStringUDC20
321F54HS08MIncident Environmental Impact Change History14I9UOMUnit of Measure as InputStringUDC20
TOP54R: Rental Management
322F54R11Rental Contract Detail19CDUOMUnit of Measure as InputStringUDC20
323F54R12Purchase Order Receiver Rentals File24RRUOMUnit of Measure as InputStringUDC20
324F54R199Rental Contract Detail Ledger15DLUOMUnit of Measure as InputStringUDC20
TOP74: EMEA Localization
325F740018DData extraction ESL - 7422DEUOMUnit of Measure as InputStringUDC20
326F740018WData extraction ESL - Workfile - 7422DEUOMUnit of Measure as InputStringUDC20
327F74093Worktable for Printing IVA Summary - Italy27HCUOMUnit of Measure as InputStringUDC20
328F7420033Sales Document Line (Print Info) - COMM - 4211PIUOMUnit of Measure as InputStringUDC20
329F744102Intrastat Commodity Code Additional Information4IBUOMUnit of Measure as InputStringUDC20
TOP74R: Russia
330F74R3033Line additional info (Print Info) - RUS - 03B7DFUOMUnit of Measure as InputStringUDC20
331F74R3034Unit of Measure Relationship - RUS - 74R1UMUOMUnit of Measure as InputStringUDC20
332F74R5110F1201 Tag File - RUS - 12 - 74R15TFUOMUnit of Measure as InputStringUDC20
TOP75I: India
333F75I017Sales Order Tag File IND 4215SOUOMUnit of Measure as InputStringUDC20
334F75I309Personal Consumption - CENVAT setoff - IND - 4126CSUOMUnit of Measure as InputStringUDC20
335F75I346Excise - D3-Form Table18Q9UOMUnit of Measure as InputStringUDC20
336F75I3571Consignment - Work Orders12CWUOMUnit of Measure as InputStringUDC20
337F75I3573Consignment - Order Items12COUOMUnit of Measure as InputStringUDC20
338F75I3574Consignment - Issues/Receipts Transactions22CTUOMUnit of Measure as InputStringUDC20
339F75I3575Consignment - Work Order Part List Items - Balances7CPUOMUnit of Measure as InputStringUDC20
340F75I3576Stock Transfer - Work Orders14SWUOMUnit of Measure as InputStringUDC20
341F75I385RG23D Register - Issues - IND - 4212EDUOMUnit of Measure as InputStringUDC20
342F75I390Work With Excise Reports5ERUOMUnit of Measure as InputStringUDC20
343F75I3901Work With Consignment - IND -4314COUOMUnit of Measure as InputStringUDC20
344F75I395BER - 5 (2)7ERUOMUnit of Measure as InputStringUDC20
345F75I395TER - 5 (temp)7ERUOMUnit of Measure as InputStringUDC20
346F75I396BER-614SEUOMUnit of Measure as InputStringUDC20
347F75I396TER-6 Temp15SEUOMUnit of Measure as InputStringUDC20
348F75I397ER-6 Scrap4SCUOMUnit of Measure as InputStringUDC20
349F75I409Personal Consumption - VAT setoff - IND - 4119VSUOMUnit of Measure as InputStringUDC20
TOP75T: Taiwan
350F75T005GUI/VAT Transaction Detail - 75T10TDUOMUnit of Measure as InputStringUDC20
351F75T0059GUI/VAT Transaction Detail History - 75T10TDUOMUnit of Measure as InputStringUDC20
352F75T005PGUI/VAT Transaction Detail POS - 75T10TDUOMUnit of Measure as InputStringUDC20
353F75T005TGUI/VAT Transaction Detail Temp - 75T10TDUOMUnit of Measure as InputStringUDC20
354F75T005ZGUI/VAT Transaction Detail - Work - 75T17ZDUOMUnit of Measure as InputStringUDC20
355F75T42WWork file with union of F4211 and F4211923SWUOMUnit of Measure as InputStringUDC20
TOP76A: Argentina
356F76A13Taxes - Tax Values - ARG - 00 - 76A10TVUOMUnit of Measure as InputStringUDC20
357F76A18Taxes - Tax Amounts by Sales Order Line - ARG - 03B - 76A18TOUOMUnit of Measure as InputStringUDC20
358F76A18PTaxes - Tax Amounts by Sales Order Line Purge - ARG - - 76A18TOUOMUnit of Measure as InputStringUDC20
359F76A19Taxes - Tax Amounts by Invoice Suffix - ARG - 03B - 76A16TIUOMUnit of Measure as InputStringUDC20
360F76A19PTaxes - Tax Amounts by Invoice Suffix Purge ARG - 03B - 76A16TIUOMUnit of Measure as InputStringUDC20
361F76A19Z1Taxes - Tax Amounts by Invoice Suffix Batch Entry A - - 76A34VKUOMUnit of Measure as InputStringUDC20
362F76A8230Percentages by state / agreement Gross Income - ARG - - 76A12C1UOMUnit of Measure as InputStringUDC20
363F76AUI18Taxes - Tax amount by order line - Work File - ARG - - 76A12WFUOMUnit of Measure as InputStringUDC20
364F76AUI24Taxes Work File - ARG - 03B - 76A15TIUOMUnit of Measure as InputStringUDC20
TOP76B: Brazil
365F76111BNota Fiscal - Detail (Fiscal Books) - 4211QUUOMUnit of Measure as InputStringUDC20
366F76111BTConversion table for CFOP 5 digits - F76111B - 4211TAUOMUnit of Measure as InputStringUDC20
367F7611BNota Fiscal Detail - BRA - 4233FDUOMUnit of Measure as InputStringUDC20
368F761BAAS Fiscal file book - 0937FBUOMUnit of Measure as InputStringUDC20
369F76B0803UM Conversions - SPED Fiscal Brazilian Workfile6FCUOMUnit of Measure as InputStringUDC20
370F76B3010Work Table for Item/Part List - 305IPUOMUnit of Measure as InputStringUDC20
371F76B31Nota Fiscal Detail/Table for Goods - IN68 - 4216IMUOMUnit of Measure as InputStringUDC20
372F76B411DIN86-Work Table for Merchandise Nota Fiscal Issued by - 4217CDUOMUnit of Measure as InputStringUDC20
373F76B411EIN86-Work Table for Merchandise NF Issued by Supplier - 4117SDUOMUnit of Measure as InputStringUDC20
374F76B51Inventory Records Table - IN68 - 427RIUOMUnit of Measure as InputStringUDC20
TOP76H: Chile
375F76H3B34Sales Document Line (Print Info) - CHI - 03B - 76H8PIUOMUnit of Measure as InputStringUDC20
376F76H3B38Shipment Guide Line (Print Info) - CHI - 03B - 76H8PIUOMUnit of Measure as InputStringUDC20
TOP89: Conversion Programs
377F3296TNeeded for upgrade from Xe and below11KAUOMUnit of Measure as InputStringUDC20
378F40344ATemporay Preference Profile - Sales Commission9SAUOMUnit of Measure as InputStringUDC20
379F4072TEMPrice Adjustment Detail - Temp for Upgrade12ADUOMUnit of Measure as InputStringUDC20
380F43199ATemp F43199 for ERP 9.0 Upgrade60OLUOMUnit of Measure as InputStringUDC20
381F46011TOBSOLETE - Item Unit Of Measure Definition Tag File4IQUOMUnit of Measure as InputStringUDC20
TOPF30L: DFM Line Design
382FF30L002DFM Bill of Material Master12DHUOMUnit of Measure as InputStringUDC20
383FF30L930DFM Routings17LRUOMUnit of Measure as InputStringUDC20
TOPF31: Lean Transactions
384FF31010Production Master File24EHUOMUnit of Measure as InputStringUDC20
385FF31011TransactionID Master File12EHUOMUnit of Measure as InputStringUDC20
386FF31011SPurge - TransactionID Master File12ERUOMUnit of Measure as InputStringUDC20
387FF31111Lean Transaction Parts List14PLUOMUnit of Measure as InputStringUDC20
388FF31111SPurge - Lean Transaction Parts List14PRUOMUnit of Measure as InputStringUDC20
389FF31112Routing Transaction Table67EHUOMUnit of Measure as InputStringUDC20
390FF31112SPurge - Routing Transaction Table67ETUOMUnit of Measure as InputStringUDC20
391FF31113Lean Transaction Labor Detail28LDUOMUnit of Measure as InputStringUDC20
392FF31113SPurge - Lean Transaction Labor Detail28LRUOMUnit of Measure as InputStringUDC20
393FF31200Production Costs20PCUOMUnit of Measure as InputStringUDC20
TOPF31K: DFM Kanban Management
394FF31K11DFM Kanban Parent Items7PIUOMUnit of Measure as InputStringUDC20
395FF31K20DFM Kanban Component8KCUOMUnit of Measure as InputStringUDC20
TOPH98: Internet
396F98616Printer Definition11PTUOMUnit of Measure as InputStringUDC20
397F986162Paper Definition4PDUOMUnit of Measure as InputStringUDC20

User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.

TOPUDC 00 / UM (Unit of Measure) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1 . Y
2        %Percent N
3        12Twelve Pack N
4        ACAcre N
5        ASAnnual Salary(rounded)xmult. N
6        ATAnnual Salary(truncated)xmult. N
7        BABar Absolute (Pressure) N
8        BCBag N
9        BGBar Gauge (Pressure) N
10        BKBucket N
11        BLBarrels N
12        BTBottles N
13        BUBushel N
14        BXBox N
15        CACase N
16        CCCubic CentimeterVN
17        CFHundred Feet N
18        CICubic InchesVN
19        CLCentilitersVN
20        CMCentimeters N
21        CNCan N
22        COContainer N
23        CRCarton N
24        CSHundred Square Feet N
25        CTCarat Y
26        CUCubic Meter Y
27        CWHundredweightWN
28        CYCubic YardVN
29        DCDecimeters N
30        DLDeciliter N
31        DRdrums N
32        DWPenny Weight
33        DYDays N
34        DZDozen N
35        EAEach N
36        FCCubic FeetVN
37        FFFeet/Inches/16th N
38        FOFluid Ounce Y
39        FTFeet N
40        G1100 Gallons N
41        GAGallonsVN
42        GJGiga Joule Y
43        GMGramsWN
44        GPPotent GallonsVPN
45        GRGross N
46        H1Half Hour Calculations N
47        HAAverage Hourly Rate N
48        HEHead Count N
49        HHHours X Hours Worked N
50        HLHectoliterVN
51        HQHours per period (zero $) N
52        HRHour N
53        HTHectare N
54        HZHours x Hrs worked (zero $) N
55        ICCubic InchesVN
56        IGImperial GallonsVN
57        INInches N
58        JTJoints N
59        KGKilogramsWN
60        KLKiloliter . N
61        KMKilometers N
62        KTKarat N
63        KWKilowatt Hour Y
64        L3Pounds per square inch N
65        LBPoundsWN
66        LCCubic LitersVN
67        LFLinear Feet N
68        LGLog N
69        LPPotent LitersVPN
70        LSLump Sum N
71        LTLitersVN
72        M3Cubic MetersVN
73        MFThousand Feet N
74        MGMilligramsWN
75        MHMan Hour N
76        MIMiles N
77        MKMicrogramsWN
78        MLMilliliterVN
79        MMMillimeters . N
80        MNMinutes Y
81        MOMonths N
82        MPThousand Pieces N
83        MSThousand Square Feet N
84        MTMeters N
85        MWThousand PoundsWN
86        OPPotent Ounces PN
87        OTTroy Ounces N
88        OZOuncesWN
89        PCPieces N
90        PDPad N
91        PKPackage N
92        PLPallet N
93        PRPair N
94        PTPintVN
95        QTQuartVN
96        RDRental Deposit N
97        RLRoll N
98        RMReam N
99        RT$1000s of Salary N
100        SCSquare Centimeters N
101        SESeconds Y
102        SFSquare Feet N
103        SISquare Inches N
104        SKSkein N
105        SLSleeve N
106        SMSquare Meters N
107        SPSpaces
108        STEaches N
109        SXSix Pack N
110        SYSquare Yard N
111        TKTank N
112        TLLong Ton (English)WN
113        TMMetric TonWN
114        TNTon (U.S.)WN
115        TSShort Ton (U.S.)WN
116        UNUnits N
117        WKWeeks N
118        WUWeld Units N
119        XLExcess Life N
120        YDYards N
121        YRYear N
122        ZSet (3-PW) N