JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides |  920 VMs | 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
9F0006MCBusiness Unit Master
10F03012AICustomer Master by Line of Business

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
9F42119SDSales Order History File
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

397 columns | Print definition?910 | 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
24F3109Line/Item Relationship Master6IPUOMUnit of Measure as InputStringUDC20
25F31091Schedule Quantity Detail11IQUOMUnit of Measure as InputStringUDC20
26F31091SSchedule Quantity Detail Purge11IQUOMUnit of Measure as InputStringUDC20
27F3112Work Order Routing52WLUOMUnit of Measure as InputStringUDC20
28F31122Work Order Time Transactions30WTUOMUnit of Measure as InputStringUDC20
29F31122SPurge Work Order Time Transactions30WTUOMUnit of Measure as InputStringUDC20
30F31122Z1Work Order Time Transactions Unedited Transaction Table44SZUOMUnit of Measure as InputStringUDC20
31F3112SPurge Shop Floor Control Routing Instructions52WLUOMUnit of Measure as InputStringUDC20
32F3112Z1Outbound Work Order Routings64SZUOMUnit of Measure as InputStringUDC20
33F3114Rate Schedule Transaction File9IQUOMUnit of Measure as InputStringUDC20
34F3115Net Change Transaction table12NCUOMUnit of Measure as InputStringUDC20
35F31UI002User Index - Variances17IGUOMUnit of Measure as InputStringUDC20
36F31UI006Line Scheduling Workbench - Work File15LSUOMUnit of Measure as InputStringUDC20
TOP31B: Blend Management
37F31B052Equipment Assignments23EAUOMUnit of Measure as InputStringUDC20
38F31B053Consumable Assignments28CAUOMUnit of Measure as InputStringUDC20
39F31B99Decant Detail9DDUOMUnit of Measure as InputStringUDC20
TOP31P: Engineer To Order
40F31P11Project Quote Detail26QPUOMUnit of Measure as InputStringUDC20
TOP32: Configuration Management
41F3215Configurator Component Table8CCUOMUnit of Measure as InputStringUDC20
42F32159Configurator Component History Table8CHUOMUnit of Measure as InputStringUDC20
43F32GOPConfigurator GOP23GPUOMUnit of Measure as InputStringUDC20
TOP33: Capacity Planning
44F33UI001Shop Floor Control Routing Instructions21WLUOMUnit of Measure as InputStringUDC20
TOP37: Quality Management
45F37900Certificate of Analysis (COA) Extract77TRUOMUnit of Measure as InputStringUDC20
46F40318Preference Profile - Quality Management9QCUOMUnit of Measure as InputStringUDC20
TOP38: Agreement Management
47F38011Agreement Quantities11DFUOMUnit of Measure as InputStringUDC20
48F38012Product Source/Destination Master14DPUOMUnit of Measure as InputStringUDC20
49F38014Agreement Formulas and Factors5DRUOMUnit of Measure as InputStringUDC20
50F38111Agreements Transaction Ledger34DZUOMUnit of Measure as InputStringUDC20
51F38112Agreements Committed Quantities15DXUOMUnit of Measure as InputStringUDC20
TOP39: Advanced Stock Valuation
52F39041Valuation Category Master4VCUOMUnit of Measure as InputStringUDC20
53F39061Valuation Period Table9SOUOMUnit of Measure as InputStringUDC20
54F390619Historical Valuation Period Detail Table9SOUOMUnit of Measure as InputStringUDC20
55F39062Valuation Layers Table12STUOMUnit of Measure as InputStringUDC20
56F39063Period Additional Quantity Table9SUUOMUnit of Measure as InputStringUDC20
57F390639Historical Additional Quantity Table9SUUOMUnit of Measure as InputStringUDC20
58F39064Valuation Document Summary Table9DSUOMUnit of Measure as InputStringUDC20
59F390649Historical Valuation Document Summary Table9DSUOMUnit of Measure as InputStringUDC20
60F39121WAdditional Quantity Work File7AQUOMUnit of Measure as InputStringUDC20
TOP40: Inventory/OP Base
61F3002Bill of Material Master File16IXUOMUnit of Measure as InputStringUDC20
62F3003Routing Master File18IRUOMUnit of Measure as InputStringUDC20
63F3011Bill of Materials Change File16IZUOMUnit of Measure as InputStringUDC20
64F3013ECO Parts List Detail13CYUOMUnit of Measure as InputStringUDC20
65F30UI002Bill of Material Structure Analysis Work File10IXUOMUnit of Measure as InputStringUDC20
66F30UI004Bill of Material Update Work File16WFUOMUnit of Measure as InputStringUDC20
67F40051Return Material Authorization31RDUOMUnit of Measure as InputStringUDC20
68F4011ZBatch Receiver File - Order Details80SZUOMUnit of Measure as InputStringUDC20
69F4012ZWWF - Destination Quantity28SPUOMUnit of Measure as InputStringUDC20
70F4013ZKit Components Batch File14KSUOMUnit of Measure as InputStringUDC20
71F4015Order Templates8OTUOMUnit of Measure as InputStringUDC20
72F40300RPreference Resolution History - Master9PMUOMUnit of Measure as InputStringUDC20
73F40301Preference Profile - Payment Terms9PTUOMUnit of Measure as InputStringUDC20
74F40301RPreference Resolution Ledger - Payment Terms11PTUOMUnit of Measure as InputStringUDC20
75F40302Preference Profile - Unit of Measure9PUUOMUnit of Measure as InputStringUDC20
76F40302RPreference Resolution Ledger - Pricing Unit Of Measure11PUUOMUnit of Measure as InputStringUDC20
77F40303Preference Profile - Revenue Cost Center9RVUOMUnit of Measure as InputStringUDC20
78F40303RPreference Resolution Ledger - Revenue Business Unit11RVUOMUnit of Measure as InputStringUDC20
79F40304Preference Profile - End Use9PEUOMUnit of Measure as InputStringUDC20
80F40304RPreference Resolution Ledger - End Use11PEUOMUnit of Measure as InputStringUDC20
81F40305Preference Profile - Print Messages9RMUOMUnit of Measure as InputStringUDC20
82F40305RPreference Resolution Ledger - Print Messages11RMUOMUnit of Measure as InputStringUDC20
83F40306Preference Profile - Inventory Sourcing9SRUOMUnit of Measure as InputStringUDC20
84F40307Preference Profile - Product Allocations9LAUOMUnit of Measure as InputStringUDC20
85F40308Preference Profile - Grade and Potency9GSUOMUnit of Measure as InputStringUDC20
86F40308RPreference Resolution Ledger - Grade and Potency11GSUOMUnit of Measure as InputStringUDC20
87F40309Preference Profile - Delivery Date9DYUOMUnit of Measure as InputStringUDC20
88F40309RPreference Resolution Ledger - Delivery Date11DYUOMUnit of Measure as InputStringUDC20
89F40310Preference Profile - Line of Business9LBUOMUnit of Measure as InputStringUDC20
90F40310RPreference Resolution Ledger - Line Of Business11LBUOMUnit of Measure as InputStringUDC20
91F40311Preference Profile - Price Code 19P1UOMUnit of Measure as InputStringUDC20
92F40311RPreference Resolution Ledger - User Defined Price Code #111P1UOMUnit of Measure as InputStringUDC20
93F40312Preference Profile - Price Code 29P2UOMUnit of Measure as InputStringUDC20
94F40312RPreference Resolution Ledger - User Defined Price Code #211P2UOMUnit of Measure as InputStringUDC20
95F40313Preference Profile - Price Code 39P3UOMUnit of Measure as InputStringUDC20
96F40313RPreference Resolution Ledger - User Defined Price Code #311P3UOMUnit of Measure as InputStringUDC20
97F40314Preference Profile - Price Adjustment Schedule9PJUOMUnit of Measure as InputStringUDC20
98F40314RPreference Resolution Ledger - Price Adjustment Schedule11PJUOMUnit of Measure as InputStringUDC20
99F40315Preference Profile - Invoice Cycling9PIUOMUnit of Measure as InputStringUDC20
100F40315RPreference Resolution Ledger - Invoice Cycle11PIUOMUnit of Measure as InputStringUDC20
101F40316Preference Profile - Order Preparation9OPUOMUnit of Measure as InputStringUDC20
102F40316RPreference Resolution Ledger - Order Preparation Days11OPUOMUnit of Measure as InputStringUDC20
103F40318RPreference Resolution Ledger - Quality Management11QCUOMUnit of Measure as InputStringUDC20
104F40320Preference Profile - Multi Shipping/Receiving Locations9LPUOMUnit of Measure as InputStringUDC20
105F40320RPreference Resolution Ledger - Multi ShiP/Rec Locations10LPUOMUnit of Measure as InputStringUDC20
106F40329Preference Profile - Document Distribution9DDUOMUnit of Measure as InputStringUDC20
107F40330Preference Profile - Document Set9DGUOMUnit of Measure as InputStringUDC20
108F40331Preference Profile - Options and Equipment9OEUOMUnit of Measure as InputStringUDC20
109F40332Preference Profile - Customer Freight9CFUOMUnit of Measure as InputStringUDC20
110F40333Preference Profile - Carrier9CAUOMUnit of Measure as InputStringUDC20
111F40334Preference Profile - Mode of Transport9MTUOMUnit of Measure as InputStringUDC20
112F40338Preference Profile - Payment Terms (Branch)9PTUOMUnit of Measure as InputStringUDC20
113F40338RPreference Resolution Ledger - Payment Terms (Branch)11PTUOMUnit of Measure as InputStringUDC20
114F40339Preference Profile - Product Allocations (Branch)9LAUOMUnit of Measure as InputStringUDC20
115F40341Preference Profile - Next Order Status9NSUOMUnit of Measure as InputStringUDC20
116F40341RPreference Resolution Ledger - Next Order Status11NSUOMUnit of Measure as InputStringUDC20
117F40344Preference Profile - Sales Commission9SAUOMUnit of Measure as InputStringUDC20
118F40344RPreference Resolution Ledger - Sales Commission11SAUOMUnit of Measure as InputStringUDC20
119F40345Preference Profile - Customer Currency9CRUOMUnit of Measure as InputStringUDC20
120F40345RPreference Resolution Ledger - Customer Currency11CRUOMUnit of Measure as InputStringUDC20
121F40347Preference Profile - Pricing UOM (Branch)9RIUOMUnit of Measure as InputStringUDC20
122F40347RPreference Resolution Ledger - Pricing UOM (Branch)11RIUOMUnit of Measure as InputStringUDC20
123F40349Preference Profile - Revenue Business Unit (Branch)9RVUOMUnit of Measure as InputStringUDC20
124F40349RPreference Resolution Ledger - Revenue Bus Unit (Branch)11RVUOMUnit of Measure as InputStringUDC20
125F40350Preference Profiles - Conatiner Deposit/Rental9OQUOMUnit of Measure as InputStringUDC20
126F40P01Promotion Header File13PHUOMUnit of Measure as InputStringUDC20
127F40P011Promotion Deal Detail File14PDUOMUnit of Measure as InputStringUDC20
128F40UI002Supplier History Rebuild -workfile8UTUOMUnit of Measure as InputStringUDC20
129F40UI17Allocation Work File19ZGUOMUnit of Measure as InputStringUDC20
130F40UI74Price Adjustment History Work File22AWUOMUnit of Measure as InputStringUDC20
131F4106Item Base Price File13BPUOMUnit of Measure as InputStringUDC20
132F4211Z1Sales Order Detail Unedited Transaction File77SZUOMUnit of Measure as InputStringUDC20
133F43800Summary Voucher Match13PRUOMUnit of Measure as InputStringUDC20
TOP40G: Grower Management
134F40G032Harvest Estimate Freeze Detail17FDUOMUnit of Measure as InputStringUDC20
135F40G103EUR - Intended Use Distribution12IUUOMUnit of Measure as InputStringUDC20
136F40G150Crush and Purchase Report Details32CPUOMUnit of Measure as InputStringUDC20
137F40G95Pay On Proceeds Log File16PPUOMUnit of Measure as InputStringUDC20
TOP40R: Demand Scheduling
138F40R11Demand Detail18DDUOMUnit of Measure as InputStringUDC20
139F40R121CUM Required Quantities Detail Table6CRUOMUnit of Measure as InputStringUDC20
140F40R13Demand Packaging6DPUOMUnit of Measure as InputStringUDC20
141F40R30WFDemand Work File19DSUOMUnit of Measure as InputStringUDC20
142F40R41Demand History23DIUOMUnit of Measure as InputStringUDC20
143F47173EDI Demand Scheduling Detail23ESUOMUnit of Measure as InputStringUDC20
144F471731EDI Demand Packaging17EPUOMUnit of Measure as InputStringUDC20
145F47UI002ASN Extract Packaging Work File37SPUOMUnit of Measure as InputStringUDC20
TOP41: Inventory Management
146F41131Stranded Hard Commitments Table20IUUOMUnit of Measure as InputStringUDC20
147F4131Consignment Master Detail (FUTURE)10MDUOMUnit of Measure as InputStringUDC20
148F4133Usage Detail (FUTURE)10UDUOMUnit of Measure as InputStringUDC20
149F4141Z1F4141 Cycle Count Unedited Transaction Table34SZUOMUnit of Measure as InputStringUDC20
150F4160Tag Inventory File19ITUOMUnit of Measure as InputStringUDC20
TOP41F: Apparel Management
151FCW11Item Base Price File Work File12WPUOMUnit of Measure as InputStringUDC20
152FCW68Style Work Order Routings55WLUOMUnit of Measure as InputStringUDC20
153FCW71Supplier Price/Catalog File - Detail25CBUOMUnit of Measure as InputStringUDC20
TOP42: Sales Management
154F4074Price Adjustment Ledger File16ALUOMUnit of Measure as InputStringUDC20
155F420UI55Kit Balance Work File16UIUOMUnit of Measure as InputStringUDC20
156F4211Sales Order Detail File64SDUOMUnit of Measure as InputStringUDC20
157F42119Sales Order History File64SDUOMUnit of Measure as InputStringUDC20
158F42199S.O. Detail Ledger File64SLUOMUnit of Measure as InputStringUDC20
159F42565Invoice Print File21IWUOMUnit of Measure as InputStringUDC20
160F4290Delivery Note History19SEUOMUnit of Measure as InputStringUDC20
161F42UI11SO Detail Cache File (MBF)52ZDUOMUnit of Measure as InputStringUDC20
162F42UI12Sales Order Detail Cache 2 (MBF)74ZDUOMUnit of Measure as InputStringUDC20
163F42UI521Pick Slips Detail File60S9UOMUnit of Measure as InputStringUDC20
164F42UI800Sales Detail Work File - Sales Update51SDUOMUnit of Measure as InputStringUDC20
TOP42B: Sales Order Entry
165F42216WFPending Blanket Release Work File - F42216WF9PBUOMUnit of Measure as InputStringUDC20
166F42420Audit Log Transaction18ALUOMUnit of Measure as InputStringUDC20
167F42440Customer Segment Items5CSUOMUnit of Measure as InputStringUDC20
168F42UI440Customer Segment Items - Work File5CSUOMUnit of Measure as InputStringUDC20
TOP42W: Fulfillment Management
169F427UI01Release Fulfillment Work File15RFUOMUnit of Measure as InputStringUDC20
TOP43: Procurement
170F41061Supplier Price/Catalog File14CBUOMUnit of Measure as InputStringUDC20
171F43080Approvals Fields Constants67PDUOMUnit of Measure as InputStringUDC20
172F43092Purchase Order Receipt Routing File20PXUOMUnit of Measure as InputStringUDC20
173F43092ZReceipt Routing Work File12PVUOMUnit of Measure as InputStringUDC20
174F43092Z1Receipt Routing Unedited Transaction Table33SZUOMUnit of Measure as InputStringUDC20
175F43099Receipt Routing Ledger File7POUOMUnit of Measure as InputStringUDC20
176F4311Purchase Order Detail File60PDUOMUnit of Measure as InputStringUDC20
177F4311ZPurchase Order Generator File64PWUOMUnit of Measure as InputStringUDC20
178F4311Z1Purchase Order Detail Unedited Transaction Table73SZUOMUnit of Measure as InputStringUDC20
179F43121Purchase Order Receiver File65PRUOMUnit of Measure as InputStringUDC20
180F43121ZReceiver workfile61PWUOMUnit of Measure as InputStringUDC20
181F43121Z1Receipts Unedited Transaction Table82SZUOMUnit of Measure as InputStringUDC20
182F43147Freight Distribution Workfile28FDUOMUnit of Measure as InputStringUDC20
183F4314ZVoucher Match Selection File165PNUOMUnit of Measure as InputStringUDC20
184F43199P.O. Detail Ledger File - Flexible Version60OLUOMUnit of Measure as InputStringUDC20
185F4340Purchase Rebate Master File8RDUOMUnit of Measure as InputStringUDC20
186F4343Purchase Rebate History16RHUOMUnit of Measure as InputStringUDC20
187F43632ZOpen Purchase Order by Item Work File19OIUOMUnit of Measure as InputStringUDC20
188F43UI50DPO Print Detail Work File11PWUOMUnit of Measure as InputStringUDC20
TOP43C: Contracts
189F43C10Contract Block13CBUOMUnit of Measure as InputStringUDC20
190F43C100Contract Block Profile24BPUOMUnit of Measure as InputStringUDC20
191F43C11Contract Detail14CDUOMUnit of Measure as InputStringUDC20
192F43C110Contract Harvest Profile12DPUOMUnit of Measure as InputStringUDC20
TOP43E: Requisition Self Service
193F43E09F43E09 - Approvals Activity Table26AAUOMUnit of Measure as InputStringUDC20
194F43E11Requisition Detail24RDUOMUnit of Measure as InputStringUDC20
195F43E121eRequisition Receiver file23ERUOMUnit of Measure as InputStringUDC20
196F43E20Shopping Cart Detail9SCUOMUnit of Measure as InputStringUDC20
197F43E20WFeReq - Shopping Cart Work File15SWUOMUnit of Measure as InputStringUDC20
TOP43Q: Strategic Sourcing
198F43Q11Event Detail20EDUOMUnit of Measure as InputStringUDC20
199F43Q20Event Header Bid Questions9EHUOMUnit of Measure as InputStringUDC20
200F43Q21Event Detail Bid Questions10EDUOMUnit of Measure as InputStringUDC20
201F43Q51Analyze Event Detail11EDUOMUnit of Measure as InputStringUDC20
202F43Q60Bid Questions10BQUOMUnit of Measure as InputStringUDC20
203F43Q62Bid Question Price Component6BCUOMUnit of Measure as InputStringUDC20
TOP43S: Supplier Self Service
204F4313POFLIP25PFUOMUnit of Measure as InputStringUDC20
TOP44H: Homebuilder Management
205F44H602Takeoff Master File15TOUOMUnit of Measure as InputStringUDC20
206F44H602HTakeoff History File16THUOMUnit of Measure as InputStringUDC20
207F44H602WTake Off Summary Workfile17TSUOMUnit of Measure as InputStringUDC20
208F44H611Bid Details46BDUOMUnit of Measure as InputStringUDC20
209F44H611WBid Details Work File50BWUOMUnit of Measure as InputStringUDC20
210F44H711Lot Start Workfile53SWUOMUnit of Measure as InputStringUDC20
211F44H711PAfter Start Purchasing22TPUOMUnit of Measure as InputStringUDC20
212F44H711ZHB Lot Start Unedited Transaction File66SZUOMUnit of Measure as InputStringUDC20
213F44H71W1Lot Start Generation Workfile53GWUOMUnit of Measure as InputStringUDC20
214F44H73W1Lot Start - P.O. / Committment Generation Work File34CGUOMUnit of Measure as InputStringUDC20
TOP45: Advanced Pricing
215F4072Price Adjustment Detail10ADUOMUnit of Measure as InputStringUDC20
216F4072PPrice Adjustment Detail Purge11ADUOMUnit of Measure as InputStringUDC20
217F4072WPrice Adjustment Detail Work File10ADUOMUnit of Measure as InputStringUDC20
218F4073Free Goods Master File7FGUOMUnit of Measure as InputStringUDC20
219F4073PFree Goods Master File Purge8FGUOMUnit of Measure as InputStringUDC20
220F4075Price Variable Table3VBUOMUnit of Measure as InputStringUDC20
221F4077Rebate Thresholds11RTUOMUnit of Measure as InputStringUDC20
222F4077PRebate Thresholds Purge12RTUOMUnit of Measure as InputStringUDC20
223F4078Rebate Transaction Summary13RHUOMUnit of Measure as InputStringUDC20
224F4079Rebate Transaction Detail17SVUOMUnit of Measure as InputStringUDC20
225F4511WPricing Structure View48APUOMUnit of Measure as InputStringUDC20
226F4550Basket Master Header3BHUOMUnit of Measure as InputStringUDC20
227F4551Basket Master Detail8BDUOMUnit of Measure as InputStringUDC20
228F45521Price List Detail11PDUOMUnit of Measure as InputStringUDC20
229F45522Price List Level-Break Pattern5PLUOMUnit of Measure as InputStringUDC20
230F45715Adjustment Balances29ABUOMUnit of Measure as InputStringUDC20
231F4572Z1Live Promotions Interface - Inbound / Outbound28LPUOMUnit of Measure as InputStringUDC20
232F4572ZPPurge Live Promotions Interface28PGUOMUnit of Measure as InputStringUDC20
233F4573Free Goods Reference File8RFUOMUnit of Measure as InputStringUDC20
234F4574Key Reference Table17KRUOMUnit of Measure as InputStringUDC20
235F4575Ship and Debit History21AHUOMUnit of Measure as InputStringUDC20
236F4575TMPShip and Debit History - Temp Table21AHUOMUnit of Measure as InputStringUDC20
237F4576Ship and Debit Claims48ACUOMUnit of Measure as InputStringUDC20
238F4576TMPShip and Debit Claims- Temp Table48ACUOMUnit of Measure as InputStringUDC20
239F4576Z1Ship and Debit Claims Unedited Transaction Table61Z1UOMUnit of Measure as InputStringUDC20
TOP46: Warehouse Management
240F4142Warehouse Count Transactions38CTUOMUnit of Measure as InputStringUDC20
241F4600Warehouse Requests26R1UOMUnit of Measure as InputStringUDC20
242F4600PUWarehouse Requests - Purged26R1UOMUnit of Measure as InputStringUDC20
243F46011Item Unit Of Measure Definition4IQUOMUnit of Measure as InputStringUDC20
244F46012Fixed Locations4ISUOMUnit of Measure as InputStringUDC20
245F46013Carton Recommendation Rules4EQUOMUnit of Measure as InputStringUDC20
246F460131Standard Pack Recommendation Rules6SPUOMUnit of Measure as InputStringUDC20
247F46015Replenishment Information by Random Rule10RRUOMUnit of Measure as InputStringUDC20
248F46024Location Capacity5LCUOMUnit of Measure as InputStringUDC20
249F46025Maximum Putaway Quantity by Zone4MQUOMUnit of Measure as InputStringUDC20
250F46095Movement Instructions7ETUOMUnit of Measure as InputStringUDC20
251F46096Unit Of Measure Groups2OUUOMUnit of Measure as InputStringUDC20
252F46130Putaway Reservations16R3UOMUnit of Measure as InputStringUDC20
253F46130PUPutaway Reservations - Purged16R3UOMUnit of Measure as InputStringUDC20
254F4615Carton Recommendations8CRUOMUnit of Measure as InputStringUDC20
255F4620Carton Detail Information6CDUOMUnit of Measure as InputStringUDC20
256F46200Bulk Pick Requests8BRUOMUnit of Measure as InputStringUDC20
257F46200PUBulk Pick Requests - Purged8BRUOMUnit of Measure as InputStringUDC20
258F46UI15Carton Recommendations - Work File8RCUOMUnit of Measure as InputStringUDC20
259F4942Z1Work File for F494228SYUOMUnit of Measure as InputStringUDC20
TOP46L: License Plating
260F46L42License Plate Cycle and Tag Count16CCUOMUnit of Measure as InputStringUDC20
261F46L99License Plate History38LMUOMUnit of Measure as InputStringUDC20
262F46LUI01Assign/Remove Items To LP Work File18WFUOMUnit of Measure as InputStringUDC20
263F46LUI02Work Table for Manual Build UOM Structure5LPUOMUnit of Measure as InputStringUDC20
TOP47: Electronic Commerce
264F47012EDI Purchase Order Detail - Inbound81SZUOMUnit of Measure as InputStringUDC20
265F47017EDI Purchase Order Detail - Outbound74SZUOMUnit of Measure as InputStringUDC20
266F47022EDI P.O. Acknowledgment Detail - Inbound74SZUOMUnit of Measure as InputStringUDC20
267F47027EDI P.O. Acknowledgment Detail - Outbound81SZUOMUnit of Measure as InputStringUDC20
268F47032EDI Shipping Notice Detail - Inbound57SZUOMUnit of Measure as InputStringUDC20
269F47037EDI Shipping Notice Detail - Outbound78SZUOMUnit of Measure as InputStringUDC20
270F470371EDI Shipping Notice Detail - Outbound88SZUOMUnit of Measure as InputStringUDC20
271F470372EDI ASN Demand Scheduling Detail22AIUOMUnit of Measure as InputStringUDC20
272F470375EDI ASN Packaging Detail22AKUOMUnit of Measure as InputStringUDC20
273F47042EDI Invoice Detail - Inbound58SZUOMUnit of Measure as InputStringUDC20
274F47047EDI Invoice Detail (Sales) - Outbound81SZUOMUnit of Measure as InputStringUDC20
275F47062EDI Planning Schedule Detail - Inbound21MYUOMUnit of Measure as InputStringUDC20
276F47067EDI Planning Schedule Detail - Outbound21MYUOMUnit of Measure as InputStringUDC20
277F47072EDI Receiving Advice Detail - Inbound75SZUOMUnit of Measure as InputStringUDC20
278F47077EDI Receiving Advice Detail - Outbound75SZUOMUnit of Measure as InputStringUDC20
279F47082EDI Price Sales Catalog Detail - Inbound68FYUOMUnit of Measure as InputStringUDC20
280F47092EDI Request for Quote Detail - Inbound81SZUOMUnit of Measure as InputStringUDC20
281F47097EDI Request for Quote Detail - Outbound74SZUOMUnit of Measure as InputStringUDC20
282F47102EDI Response to RFQ Detail - Inbound74SZUOMUnit of Measure as InputStringUDC20
283F47107EDI Response to RFQ Detail - Outbound81SZUOMUnit of Measure as InputStringUDC20
284F47132EDI Purchase Order Change Detail - Inbound82SZUOMUnit of Measure as InputStringUDC20
285F47137EDI Purchase Order Change Detail - Outbound75SZUOMUnit of Measure as InputStringUDC20
286F47142EDI P.O. Change Acknowledgment Detail - Inbound76SZUOMUnit of Measure as InputStringUDC20
287F47147EDI P.O. Change Acknowledgment Detail - Outbound83SZUOMUnit of Measure as InputStringUDC20
288F47157EDI Shipping Schedule Detail - Outbound80SZUOMUnit of Measure as InputStringUDC20
289F47182EDI Consumption Detail (FUTURE)8EDUOMUnit of Measure as InputStringUDC20
290F47191EDI Acknowledgement Header42AHUOMUnit of Measure as InputStringUDC20
291F47UI001ASN Extract Work File36SZUOMUnit of Measure as InputStringUDC20
TOP48: Work Order Processing
292F4801Work Order Master File68WAUOMUnit of Measure as InputStringUDC20
293F4801SPurge - Work Order Master file68WAUOMUnit of Measure as InputStringUDC20
294F4801Z1Outbound Work Order Header87SYUOMUnit of Measure as InputStringUDC20
295F48UI001X4801 Master Business Function Workfile71WAUOMUnit of Measure as InputStringUDC20
TOP49: Transportation Management
296F49110Transportation Bill of Lading Workfile41BWUOMUnit of Measure as InputStringUDC20
297F4942Shipment Detail13ISUOMUnit of Measure as InputStringUDC20
298F4945Shipment Charges22SCUOMUnit of Measure as InputStringUDC20
299F4962Load Compartments12TEUOMUnit of Measure as InputStringUDC20
300F49621Load Compartment Detail26TDUOMUnit of Measure as InputStringUDC20
301F49634Load In-Transit Confirmed Quantities Detail11QDUOMUnit of Measure as InputStringUDC20
302F4981Freight Audit History30FHUOMUnit of Measure as InputStringUDC20
303F49T20Shipment Staging Table18SSUOMUnit of Measure as InputStringUDC20
TOP54HS: Health & Safety Incident Mgt
304F54HS02Incident People25S2UOMUnit of Measure as InputStringUDC20
305F54HS02MIncident People Change History28I2UOMUnit of Measure as InputStringUDC20
306F54HS08Incident Environmental Impact11S9UOMUnit of Measure as InputStringUDC20
307F54HS08MIncident Environmental Impact Change History14I9UOMUnit of Measure as InputStringUDC20
TOP55: Reserved for Clients
308F554077Custom Table for Free Items12RNUOMUnit of Measure as InputStringUDC20
309F55BC02AP55BC02 Bevet worktable6BEUOMUnit of Measure as InputStringUDC20
310F55BC03DLeltar tetelsor tabla7LDUOMUnit of Measure as InputStringUDC20
311F55BC04HKivét fej tábla4KFUOMUnit of Measure as InputStringUDC20
312F55EB071Pick Slip Unit Of Measure Summary2USUOMUnit of Measure as InputStringUDC20
313F55EB072Delivery Note Uom Summary3DSUOMUnit of Measure as InputStringUDC20
314F55FR001Storno Bolle19SBUOMUnit of Measure as InputStringUDC20
315F55IF421Sales Order per BO70SDUOMUnit of Measure as InputStringUDC20
316F55IF425Sales Order per BO - 200570SDUOMUnit of Measure as InputStringUDC20
317F55IFLOGhistorical log14HLUOMUnit of Measure as InputStringUDC20
318F55IFPRMPromozioni ordini di vendita6PRUOMUnit of Measure as InputStringUDC20
319F55IFSFVEstrazione del venduto per Sales Force Automation18FSUOMUnit of Measure as InputStringUDC20
320F55IFWPSWF per Warranty Process Summarization6PSUOMUnit of Measure as InputStringUDC20
321F55TR565TEMP TABLO4TMUOMUnit of Measure as InputStringUDC20
322F55W0100Correction Invoice Print - WF165SDUOMUnit of Measure as InputStringUDC20
323F74H1051Invoicing Workfile - New11IWUOMUnit of Measure as InputStringUDC20
TOP74: EMEA Localization
324F740018DData extraction ESL - 7422DEUOMUnit of Measure as InputStringUDC20
325F740018WData extraction ESL - Workfile - 7422DEUOMUnit of Measure as InputStringUDC20
326F74093Worktable for Printing IVA Summary - Italy27HCUOMUnit of Measure as InputStringUDC20
327F7420033Sales Document Line (Print Info) - COMM - 4211PIUOMUnit of Measure as InputStringUDC20
328F744102Intrastat Commodity Code Additional Information4IBUOMUnit of Measure as InputStringUDC20
TOP74R: CIS
329F74R3033Line additional info (Print Info) - RUS - 03B7DFUOMUnit of Measure as InputStringUDC20
330F74R3034Unit of Measure Relationship - RUS - 74R1UMUOMUnit of Measure as InputStringUDC20
331F74R5110F1201 Tag File - RUS - 12 - 74R15TFUOMUnit of Measure as InputStringUDC20
TOP75I: India
332F75I017Sales Order Tag File IND 4215SOUOMUnit of Measure as InputStringUDC20
333F75I309Personal Consumption - CENVAT setoff - IND - 4126CSUOMUnit of Measure as InputStringUDC20
334F75I346Excise - D3-Form Table18Q9UOMUnit of Measure as InputStringUDC20
335F75I3571Consignment - Work Orders12CWUOMUnit of Measure as InputStringUDC20
336F75I3573Consignment - Order Items12COUOMUnit of Measure as InputStringUDC20
337F75I3574Consignment - Issues/Receipts Transactions22CTUOMUnit of Measure as InputStringUDC20
338F75I3575Consignment - Work Order Part List Items - Balances7CPUOMUnit of Measure as InputStringUDC20
339F75I3576Stock Transfer - Work Orders14SWUOMUnit of Measure as InputStringUDC20
340F75I385RG23D Register - Issues - IND - 4212EDUOMUnit of Measure as InputStringUDC20
341F75I390Work With Excise Reports5ERUOMUnit of Measure as InputStringUDC20
342F75I3901Work With Consignment - IND -4314COUOMUnit of Measure as InputStringUDC20
343F75I395BER - 5 (2)7ERUOMUnit of Measure as InputStringUDC20
344F75I395TER - 5 (temp)7ERUOMUnit of Measure as InputStringUDC20
345F75I396BER-614SEUOMUnit of Measure as InputStringUDC20
346F75I396TER-6 Temp15SEUOMUnit of Measure as InputStringUDC20
347F75I397ER-6 Scrap4SCUOMUnit of Measure as InputStringUDC20
348F75I409Personal Consumption - VAT setoff - IND - 4119VSUOMUnit of Measure as InputStringUDC20
TOP75T: Taiwan
349F75T005GUI/VAT Transaction Detail - 75T10TDUOMUnit of Measure as InputStringUDC20
350F75T0059GUI/VAT Transaction Detail History - 75T10TDUOMUnit of Measure as InputStringUDC20
351F75T005PGUI/VAT Transaction Detail POS - 75T10TDUOMUnit of Measure as InputStringUDC20
352F75T005TGUI/VAT Transaction Detail Temp - 75T10TDUOMUnit of Measure as InputStringUDC20
353F75T005ZGUI/VAT Transaction Detail - Work - 75T17ZDUOMUnit of Measure as InputStringUDC20
354F75T42WWork file with union of F4211 and F4211923SWUOMUnit of Measure as InputStringUDC20
TOP76A: Argentina
355F76A13Taxes - Tax Values - ARG - 00 - 76A10TVUOMUnit of Measure as InputStringUDC20
356F76A18Taxes - Tax Amounts by Sales Order Line - ARG - 03B - 76A18TOUOMUnit of Measure as InputStringUDC20
357F76A18PTaxes - Tax Amounts by Sales Order Line Purge - ARG - - 76A18TOUOMUnit of Measure as InputStringUDC20
358F76A19Taxes - Tax Amounts by Invoice Suffix - ARG - 03B - 76A16TIUOMUnit of Measure as InputStringUDC20
359F76A19PTaxes - Tax Amounts by Invoice Suffix Purge ARG - 03B - 76A16TIUOMUnit of Measure as InputStringUDC20
360F76A19Z1Taxes - Tax Amounts by Invoice Suffix Batch Entry A - - 76A34VKUOMUnit of Measure as InputStringUDC20
361F76A8230Percentages by state / agreement Gross Income - ARG - - 76A12C1UOMUnit of Measure as InputStringUDC20
362F76AUI18Taxes - Tax amount by order line - Work File - ARG - - 76A12WFUOMUnit of Measure as InputStringUDC20
363F76AUI24Taxes Work File - ARG - 03B - 76A15TIUOMUnit of Measure as InputStringUDC20
TOP76B: Brazil - Reporting System Only
364F76111BNota Fiscal - Detail (Fiscal Books) - 4211QUUOMUnit of Measure as InputStringUDC20
365F76111BTConversion table for CFOP 5 digits - F76111B - 4211TAUOMUnit of Measure as InputStringUDC20
366F7611BNota Fiscal Detail - BRA - 4233FDUOMUnit of Measure as InputStringUDC20
367F761BAAS Fiscal file book - 0937FBUOMUnit of Measure as InputStringUDC20
368F76B0803UM Conversions - SPED Fiscal Brazilian Workfile6FCUOMUnit of Measure as InputStringUDC20
369F76B3010Work Table for Item/Part List - 305IPUOMUnit of Measure as InputStringUDC20
370F76B31Nota Fiscal Detail/Table for Goods - IN68 - 4216IMUOMUnit of Measure as InputStringUDC20
371F76B411DIN86-Work Table for Merchandise Nota Fiscal Issued by - 4217CDUOMUnit of Measure as InputStringUDC20
372F76B411EIN86-Work Table for Merchandise NF Issued by Supplier - 4117SDUOMUnit of Measure as InputStringUDC20
373F76B51Inventory Records Table - IN68 - 427RIUOMUnit of Measure as InputStringUDC20
TOP76H: Chile
374F76H3B34Sales Document Line (Print Info) - CHI - 03B - 76H8PIUOMUnit of Measure as InputStringUDC20
375F76H3B38Shipment Guide Line (Print Info) - CHI - 03B - 76H8PIUOMUnit of Measure as InputStringUDC20
TOP80D: Plant Manager Dashboard
376F80D010Sales Order Fact17SFUOMUnit 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        % PercentN
2        12Twelve PackN
3        ASAnnual Salary(rounded)xmult.N
4        ATAnnual Salary(truncated)xmult.N
5        BABar Absolute (Pressure)N
6        BCBagN
7        BGBar Gauge (Pressure)N
8        BKBucketN
9        BLBarrelsN
10        BTBottlesN
11        BUBushelN
12        BXBoxN
13        CACaseN
14        CCCubic CentimeterVN
15        CFHundred FeetN
16        CICubic InchesVN
17        CLCentilitersVN
18        CMCentimetersN
19        CNCanN
20        CRCartonN
21        CSHundred Square FeetN
22        CTCaratN
23        CWHundredweightWN
24        CYCubic YardVN
25        DCDecimetersN
26        DLDeciliterN
27        DRdrumsN
28        DWPenny Weight
29        DYDaysN
30        DZDozenN
31        EAEachN
32        FCCubic FeetVN
33        FFFeet/Inches/16thN
34        FOFluid OunceY
35        FTFeetN
36        G1100 GallonsN
37        GAGallonsVN
38        GMGramsWN
39        GPPotent GallonsVPN
40        GRGrossN
41        H1Half Hour CalculationsN
42        HAAverage Hourly RateN
43        HEHead CountN
44        HHHours X Hours WorkedN
45        HLHectoliterVN
46        HQHours per period (zero $)N
47        HRHourN
48        HTHectareN
49        HZHours x Hrs worked (zero $)N
50        ICCubic InchesVN
51        IGImperial GallonsVN
52        INInchesN
53        JTJointsN
54        KGKilogramsWN
55        KLKiloliter .N
56        KMKilometersN
57        KTKaratN
58        L3Pounds per square inchN
59        LBPoundsWN
60        LCCubic LitersVN
61        LFLinear FeetN
62        LGLogN
63        LPPotent LitersVPN
64        LSLump SumN
65        LTLitersVN
66        M3Cubic MetersVN
67        MFThousand FeetN
68        MGMilligramsWN
69        MHMan HourN
70        MIMilesN
71        MKMicrogramsWN
72        MLMilliliterVN
73        MMMillimeters .N
74        MNMinutesY
75        MOMonthsN
76        MPThousand PiecesN
77        MSThousand Square FeetN
78        MTMetersN
79        MWThousand PoundsWN
80        OPPotent OuncesPN
81        OTTroy OuncesN
82        OZOuncesWN
83        PCPiecesN
84        PDPadN
85        PLPalletN
86        PRPairN
87        PTPintVN
88        QTQuartVN
89        RDRental DepositN
90        RLRollN
91        RMReamN
92        RT$1000s of SalaryN
93        SCSquare CentimetersN
94        SESecondsY
95        SFSquare FeetN
96        SISquare InchesN
97        SKSkeinN
98        SLSleeveN
99        SMSquare MetersN
100        SPSpaces
101        SXSix PackN
102        SYSquare YardN
103        TKTankN
104        TLLong Ton (English)WN
105        TMMetric TonWN
106        TNTon (U.S.)WN
107        TSShort Ton (U.S.)WN
108        UNUnitsN
109        WKWeeksN
110        WUWeld UnitsN
111        XLExcess LifeN
112        YDYardsN
113        YRYearN
114        Z Set (3-PW)N