JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.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
6F9671SDSoftware Update Detail Table
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F0006MCBusiness Unit Master
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F76AUI46WFCERG A/R -Work File - ARG - 03B - 76A
3F4211SDSales Order Detail File
4F4101IMItem Master
5F0101ABAddress Book Master
6F0911GLAccount Ledger
7F4102IBItem Branch File
8F03B11RPCustomer Ledger
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4311PDPurchase Order Detail File
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File

335 columns | Print definition?812 | UOM | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0018Sales/Use/V.A.T. Tax File28TDUOMUnit 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
TOP31: Shop Floor Control
18F3102Production Cost25IGUOMUnit of Measure as InputStringUDC20
19F3102SPurge - Production Cost25IGUOMUnit of Measure as InputStringUDC20
20F3109Line/Item Relationship Master6IPUOMUnit of Measure as InputStringUDC20
21F31091Schedule Quantity Detail11IQUOMUnit of Measure as InputStringUDC20
22F31091SSchedule Quantity Detail Purge11IQUOMUnit of Measure as InputStringUDC20
23F3112Work Order Routing52WLUOMUnit of Measure as InputStringUDC20
24F31122Work Order Time Transactions30WTUOMUnit of Measure as InputStringUDC20
25F31122SPurge Work Order Time Transactions30WTUOMUnit of Measure as InputStringUDC20
26F31122Z1Work Order Time Transactions Unedited Transaction Table44SZUOMUnit of Measure as InputStringUDC20
27F3112SPurge Shop Floor Control Routing Instructions52WLUOMUnit of Measure as InputStringUDC20
28F3112Z1Outbound Work Order Routings64SZUOMUnit of Measure as InputStringUDC20
29F3114Rate Schedule Transaction File9IQUOMUnit of Measure as InputStringUDC20
30F3115Net Change Transaction table12NCUOMUnit of Measure as InputStringUDC20
31F31UI002User Index - Variances17IGUOMUnit of Measure as InputStringUDC20
32F31UI006Line Scheduling Workbench - Work File15LSUOMUnit of Measure as InputStringUDC20
33F4801SPurge - Work Order Master file68WAUOMUnit of Measure as InputStringUDC20
34F4801Z1Outbound Work Order Header87SYUOMUnit of Measure as InputStringUDC20
TOP31B: Blend Management
35F31B052Equipment Assignments23EAUOMUnit of Measure as InputStringUDC20
36F31B053Consumable Assignments28CAUOMUnit of Measure as InputStringUDC20
37F31B99Decant Detail9DDUOMUnit of Measure as InputStringUDC20
TOP31P: Engineer To Order
38F31P11Project Quote Detail26QPUOMUnit of Measure as InputStringUDC20
TOP32: Configuration Management
39F3215Configurator Component Table8CCUOMUnit of Measure as InputStringUDC20
40F32159Configurator Component History Table8CHUOMUnit of Measure as InputStringUDC20
41F3296TConfigurator Level Sequence File Table11KAUOMUnit of Measure as InputStringUDC20
TOP33: Capacity Planning
42F33UI001Shop Floor Control Routing Instructions21WLUOMUnit of Measure as InputStringUDC20
TOP37: Quality Management
43F37900Certificate of Analysis (COA) Extract77TRUOMUnit of Measure as InputStringUDC20
44F40318Preference Profile - Quality Management9QCUOMUnit of Measure as InputStringUDC20
TOP38: Agreement Management
45F38011Agreement Quantities11DFUOMUnit of Measure as InputStringUDC20
46F38012Product Source/Destination Master14DPUOMUnit of Measure as InputStringUDC20
47F38014Agreement Formulas and Factors5DRUOMUnit of Measure as InputStringUDC20
48F38111Agreements Transaction Ledger34DZUOMUnit of Measure as InputStringUDC20
49F38112Agreements Committed Quantities15DXUOMUnit of Measure as InputStringUDC20
TOP39: Advanced Stock Valuation
50F39041Valuation Category Master4VCUOMUnit of Measure as InputStringUDC20
51F39061Valuation Period Table9SOUOMUnit of Measure as InputStringUDC20
52F390619Historical Valuation Period Detail Table9SOUOMUnit of Measure as InputStringUDC20
53F39062Valuation Layers Table12STUOMUnit of Measure as InputStringUDC20
54F39063Period Additional Quantity Table9SUUOMUnit of Measure as InputStringUDC20
55F390639Historical Additional Quantity Table9SUUOMUnit of Measure as InputStringUDC20
56F39064Valuation Document Summary Table9DSUOMUnit of Measure as InputStringUDC20
57F390649Historical Valuation Document Summary Table9DSUOMUnit of Measure as InputStringUDC20
58F39121WAdditional Quantity Work File7AQUOMUnit of Measure as InputStringUDC20
TOP40: Inventory/OP Base
59F3002Bill of Material Master File16IXUOMUnit of Measure as InputStringUDC20
60F3003Routing Master File18IRUOMUnit of Measure as InputStringUDC20
61F3011Bill of Materials Change File16IZUOMUnit of Measure as InputStringUDC20
62F3013ECO Parts List Detail13CYUOMUnit of Measure as InputStringUDC20
63F30UI002Bill of Material Structure Analysis Work File10IXUOMUnit of Measure as InputStringUDC20
64F30UI004Bill of Material Update Work File16WFUOMUnit of Measure as InputStringUDC20
65F40051Return Material Authorization31RDUOMUnit of Measure as InputStringUDC20
66F4011ZBatch Receiver File - Order Details80SZUOMUnit of Measure as InputStringUDC20
67F4012ZWWF - Destination Quantity28SPUOMUnit of Measure as InputStringUDC20
68F4013ZKit Components Batch File14KSUOMUnit of Measure as InputStringUDC20
69F4015Order Templates8OTUOMUnit of Measure as InputStringUDC20
70F40300RPreference Resolution History - Master9PMUOMUnit of Measure as InputStringUDC20
71F40301Preference Profile - Payment Terms9PTUOMUnit of Measure as InputStringUDC20
72F40301RPreference Resolution Ledger - Payment Terms11PTUOMUnit of Measure as InputStringUDC20
73F40302Preference Profile - Unit of Measure9PUUOMUnit of Measure as InputStringUDC20
74F40302RPreference Resolution Ledger - Pricing Unit Of Measure11PUUOMUnit of Measure as InputStringUDC20
75F40303Preference Profile - Revenue Cost Center9RVUOMUnit of Measure as InputStringUDC20
76F40303RPreference Resolution Ledger - Revenue Business Unit11RVUOMUnit of Measure as InputStringUDC20
77F40304Preference Profile - End Use9PEUOMUnit of Measure as InputStringUDC20
78F40304RPreference Resolution Ledger - End Use11PEUOMUnit of Measure as InputStringUDC20
79F40305Preference Profile - Print Messages9RMUOMUnit of Measure as InputStringUDC20
80F40305RPreference Resolution Ledger - Print Messages11RMUOMUnit of Measure as InputStringUDC20
81F40306Preference Profile - Inventory Sourcing9SRUOMUnit of Measure as InputStringUDC20
82F40307Preference Profile - Product Allocations9LAUOMUnit of Measure as InputStringUDC20
83F40308Preference Profile - Grade and Potency9GSUOMUnit of Measure as InputStringUDC20
84F40308RPreference Resolution Ledger - Grade and Potency11GSUOMUnit of Measure as InputStringUDC20
85F40309Preference Profile - Delivery Date9DYUOMUnit of Measure as InputStringUDC20
86F40309RPreference Resolution Ledger - Delivery Date11DYUOMUnit of Measure as InputStringUDC20
87F40310Preference Profile - Line of Business9LBUOMUnit of Measure as InputStringUDC20
88F40310RPreference Resolution Ledger - Line Of Business11LBUOMUnit of Measure as InputStringUDC20
89F40311Preference Profile - Price Code 19P1UOMUnit of Measure as InputStringUDC20
90F40311RPreference Resolution Ledger - User Defined Price Code #111P1UOMUnit of Measure as InputStringUDC20
91F40312Preference Profile - Price Code 29P2UOMUnit of Measure as InputStringUDC20
92F40312RPreference Resolution Ledger - User Defined Price Code #211P2UOMUnit of Measure as InputStringUDC20
93F40313Preference Profile - Price Code 39P3UOMUnit of Measure as InputStringUDC20
94F40313RPreference Resolution Ledger - User Defined Price Code #311P3UOMUnit of Measure as InputStringUDC20
95F40314Preference Profile - Price Adjustment Schedule9PJUOMUnit of Measure as InputStringUDC20
96F40314RPreference Resolution Ledger - Price Adjustment Schedule11PJUOMUnit of Measure as InputStringUDC20
97F40315Preference Profile - Invoice Cycling9PIUOMUnit of Measure as InputStringUDC20
98F40315RPreference Resolution Ledger - Invoice Cycle11PIUOMUnit of Measure as InputStringUDC20
99F40316Preference Profile - Order Preparation9OPUOMUnit of Measure as InputStringUDC20
100F40316RPreference Resolution Ledger - Order Preparation Days11OPUOMUnit of Measure as InputStringUDC20
101F40318RPreference Resolution Ledger - Quality Management11QCUOMUnit of Measure as InputStringUDC20
102F40320Preference Profile - Multi Shipping/Receiving Locations9LPUOMUnit of Measure as InputStringUDC20
103F40320RPreference Resolution Ledger - Multi ShiP/Rec Locations10LPUOMUnit of Measure as InputStringUDC20
104F40329Preference Profile - Document Distribution9DDUOMUnit of Measure as InputStringUDC20
105F40330Preference Profile - Document Set9DGUOMUnit of Measure as InputStringUDC20
106F40331Preference Profile - Options and Equipment9OEUOMUnit of Measure as InputStringUDC20
107F40332Preference Profile - Customer Freight9CFUOMUnit of Measure as InputStringUDC20
108F40333Preference Profile - Carrier9CAUOMUnit of Measure as InputStringUDC20
109F40334Preference Profile - Mode of Transport9MTUOMUnit of Measure as InputStringUDC20
110F40338Preference Profile - Payment Terms (Branch)9PTUOMUnit of Measure as InputStringUDC20
111F40338RPreference Resolution Ledger - Payment Terms (Branch)11PTUOMUnit of Measure as InputStringUDC20
112F40339Preference Profile - Product Allocations (Branch)9LAUOMUnit of Measure as InputStringUDC20
113F40341Preference Profile - Next Order Status9NSUOMUnit of Measure as InputStringUDC20
114F40341RPreference Resolution Ledger - Next Order Status11NSUOMUnit of Measure as InputStringUDC20
115F40344Preference Profile - Sales Commission9SAUOMUnit of Measure as InputStringUDC20
116F40344RPreference Resolution Ledger - Sales Commission11SAUOMUnit of Measure as InputStringUDC20
117F40345Preference Profile - Customer Currency9CRUOMUnit of Measure as InputStringUDC20
118F40345RPreference Resolution Ledger - Customer Currency11CRUOMUnit of Measure as InputStringUDC20
119F40347Preference Profile - Pricing UOM (Branch)9RIUOMUnit of Measure as InputStringUDC20
120F40347RPreference Resolution Ledger - Pricing UOM (Branch)11RIUOMUnit of Measure as InputStringUDC20
121F40349Preference Profile - Revenue Business Unit (Branch)9RVUOMUnit of Measure as InputStringUDC20
122F40349RPreference Resolution Ledger - Revenue Bus Unit (Branch)11RVUOMUnit of Measure as InputStringUDC20
123F40350Preference Profiles - Conatiner Deposit/Rental9OQUOMUnit of Measure as InputStringUDC20
124F40P01Promotion Header File13PHUOMUnit of Measure as InputStringUDC20
125F40P011Promotion Deal Detail File14PDUOMUnit of Measure as InputStringUDC20
126F40UI002Supplier History Rebuild -workfile8UTUOMUnit of Measure as InputStringUDC20
127F40UI17Allocation Work File19ZGUOMUnit of Measure as InputStringUDC20
128F40UI74Price Adjustment History Work File22AWUOMUnit of Measure as InputStringUDC20
129F4106Item Base Price File13BPUOMUnit of Measure as InputStringUDC20
130F4211Z1Sales Order Detail Unedited Transaction File77SZUOMUnit of Measure as InputStringUDC20
131F43800Summary Voucher Match13PRUOMUnit of Measure as InputStringUDC20
TOP40G: Grower Management
132F40G032Harvest Estimate Freeze Detail17FDUOMUnit of Measure as InputStringUDC20
133F40G103EUR - Intended Use Distribution12IUUOMUnit of Measure as InputStringUDC20
134F40G150Crush and Purchase Report Details32CPUOMUnit of Measure as InputStringUDC20
TOP40R: Demand Scheduling
135F40R11Demand Detail18DDUOMUnit of Measure as InputStringUDC20
136F40R13Demand Packaging6DPUOMUnit of Measure as InputStringUDC20
137F40R30WFDemand Work File19DSUOMUnit of Measure as InputStringUDC20
138F40R41Demand History23DIUOMUnit of Measure as InputStringUDC20
139F47173EDI Demand Scheduling Detail23ESUOMUnit of Measure as InputStringUDC20
140F471731EDI Demand Packaging17EPUOMUnit of Measure as InputStringUDC20
141F47UI002ASN Extract Packaging Work File37SPUOMUnit of Measure as InputStringUDC20
TOP41: Inventory Management
142F41131Stranded Hard Commitments Table20IUUOMUnit of Measure as InputStringUDC20
143F4141Z1F4141 Cycle Count Unedited Transaction Table34SZUOMUnit of Measure as InputStringUDC20
144F4160Tag Inventory File19ITUOMUnit of Measure as InputStringUDC20
TOP42: Sales Management
145F4074Price Adjustment Ledger File16ALUOMUnit of Measure as InputStringUDC20
146F4211Sales Order Detail File64SDUOMUnit of Measure as InputStringUDC20
147F42119Sales Order History File64SDUOMUnit of Measure as InputStringUDC20
148F42199S.O. Detail Ledger File64SLUOMUnit of Measure as InputStringUDC20
149F42565Invoice Print File21IWUOMUnit of Measure as InputStringUDC20
150F4290Delivery Note History19SEUOMUnit of Measure as InputStringUDC20
151F42UI11SO Detail Cache File (MBF)52ZDUOMUnit of Measure as InputStringUDC20
152F42UI12Sales Order Detail Cache 2 (MBF)74ZDUOMUnit of Measure as InputStringUDC20
153F42UI130Commitment Work File14ZCUOMUnit of Measure as InputStringUDC20
154F42UI521Pick Slips Detail File60S9UOMUnit of Measure as InputStringUDC20
155F42UI800Sales Detail Work File - Sales Update51SDUOMUnit of Measure as InputStringUDC20
TOP42B: Sales Order Entry
156F42216WFPending Blanket Release Work File - F42216WF9PBUOMUnit of Measure as InputStringUDC20
157F42420Audit Log Transaction18ALUOMUnit of Measure as InputStringUDC20
158F42440Customer Segment Items5CSUOMUnit of Measure as InputStringUDC20
159F42UI440Customer Segment Items - Work File5CSUOMUnit of Measure as InputStringUDC20
TOP43: Procurement
160F41061Supplier Price/Catalog File14CBUOMUnit of Measure as InputStringUDC20
161F43080Approvals Fields Constants67PDUOMUnit of Measure as InputStringUDC20
162F43092Purchase Order Receipt Routing File20PXUOMUnit of Measure as InputStringUDC20
163F43092ZReceipt Routing Work File12PVUOMUnit of Measure as InputStringUDC20
164F43092Z1Receipt Routing Unedited Transaction Table33SZUOMUnit of Measure as InputStringUDC20
165F43099Receipt Routing Ledger File7POUOMUnit of Measure as InputStringUDC20
166F4311Purchase Order Detail File60PDUOMUnit of Measure as InputStringUDC20
167F4311ZPurchase Order Generator File64PWUOMUnit of Measure as InputStringUDC20
168F4311Z1Purchase Order Detail Unedited Transaction Table73SZUOMUnit of Measure as InputStringUDC20
169F43121Purchase Order Receiver File65PRUOMUnit of Measure as InputStringUDC20
170F43121ZReceiver workfile61PWUOMUnit of Measure as InputStringUDC20
171F43121Z1Receipts Unedited Transaction Table82SZUOMUnit of Measure as InputStringUDC20
172F4314ZVoucher Match Selection File165PNUOMUnit of Measure as InputStringUDC20
173F43199P.O. Detail Ledger File - Flexible Version60OLUOMUnit of Measure as InputStringUDC20
174F4340Purchase Rebate Master File8RDUOMUnit of Measure as InputStringUDC20
175F4343Purchase Rebate History16RHUOMUnit of Measure as InputStringUDC20
176F43632ZOpen Purchase Order by Item Work File19OIUOMUnit of Measure as InputStringUDC20
177F43E09F43E09 - Approvals Activity Table26AAUOMUnit of Measure as InputStringUDC20
178F43UI50DPO Print Detail Work File11PWUOMUnit of Measure as InputStringUDC20
TOP43C: Contracts
179F43C10Contract Block13CBUOMUnit of Measure as InputStringUDC20
180F43C11Contract Detail14CDUOMUnit of Measure as InputStringUDC20
TOP43E: Requisition Self Service
181F43E11Requisition Detail24RDUOMUnit of Measure as InputStringUDC20
182F43E121eRequisition Receiver file23ERUOMUnit of Measure as InputStringUDC20
183F43E20Shopping Cart Detail9SCUOMUnit of Measure as InputStringUDC20
184F43E20WFeReq - Shopping Cart Work File16SWUOMUnit of Measure as InputStringUDC20
TOP43Q: Strategic Sourcing
185F43Q11Event Detail20EDUOMUnit of Measure as InputStringUDC20
186F43Q20Event Header Bid Questions9EHUOMUnit of Measure as InputStringUDC20
187F43Q21Event Detail Bid Questions10EDUOMUnit of Measure as InputStringUDC20
188F43Q51Analyze Event Detail11EDUOMUnit of Measure as InputStringUDC20
189F43Q60Bid Questions10BQUOMUnit of Measure as InputStringUDC20
190F43Q62Bid Question Price Component6BCUOMUnit of Measure as InputStringUDC20
TOP43S: Supplier Self Service
191F4313POFLIP25PFUOMUnit of Measure as InputStringUDC20
TOP44H: Homebuilder Management
192F44H602Takeoff Master File15TOUOMUnit of Measure as InputStringUDC20
193F44H602HTakeoff History File16THUOMUnit of Measure as InputStringUDC20
194F44H602WTake Off Summary Workfile17TSUOMUnit of Measure as InputStringUDC20
195F44H611Bid Details46BDUOMUnit of Measure as InputStringUDC20
196F44H611WBid Details Work File50BWUOMUnit of Measure as InputStringUDC20
197F44H711Lot Start Workfile53SWUOMUnit of Measure as InputStringUDC20
198F44H711PAfter Start Purchasing22TPUOMUnit of Measure as InputStringUDC20
199F44H711ZHB Lot Start Unedited Transaction File66SZUOMUnit of Measure as InputStringUDC20
200F44H71W1Lot Start Generation Workfile53GWUOMUnit of Measure as InputStringUDC20
201F44H73W1Lot Start - P.O. / Committment Generation Work File34CGUOMUnit of Measure as InputStringUDC20
TOP45: Advanced Pricing
202F4072Price Adjustment Detail10ADUOMUnit of Measure as InputStringUDC20
203F4072WPrice Adjustment Detail Work File10ADUOMUnit of Measure as InputStringUDC20
204F4073Free Goods Master File7FGUOMUnit of Measure as InputStringUDC20
205F4075Price Variable Table3VBUOMUnit of Measure as InputStringUDC20
206F4077Rebate Thresholds11RTUOMUnit of Measure as InputStringUDC20
207F4078Rebate Transaction Summary13RHUOMUnit of Measure as InputStringUDC20
208F4079Rebate Transaction Detail17SVUOMUnit of Measure as InputStringUDC20
209F4511WPricing Structure View48APUOMUnit of Measure as InputStringUDC20
210F4550Basket Master Header3BHUOMUnit of Measure as InputStringUDC20
211F4551Basket Master Detail8BDUOMUnit of Measure as InputStringUDC20
212F45521Price List Detail11PDUOMUnit of Measure as InputStringUDC20
213F45522Price List Level-Break Pattern5PLUOMUnit of Measure as InputStringUDC20
214F45715Adjustment Balances29ABUOMUnit of Measure as InputStringUDC20
215F4572Z1Live Promotions Interface - Inbound / Outbound28LPUOMUnit of Measure as InputStringUDC20
216F4572ZPPurge Live Promotions Interface28PGUOMUnit of Measure as InputStringUDC20
217F4573Free Goods Reference File8RFUOMUnit of Measure as InputStringUDC20
218F4574Key Reference Table17KRUOMUnit of Measure as InputStringUDC20
219F4575Ship and Debit History21AHUOMUnit of Measure as InputStringUDC20
220F4575TMPShip and Debit History - Temp Table21AHUOMUnit of Measure as InputStringUDC20
221F4576Ship and Debit Claims48ACUOMUnit of Measure as InputStringUDC20
222F4576TMPShip and Debit Claims- Temp Table48ACUOMUnit of Measure as InputStringUDC20
223F4576Z1Ship and Debit Claims Unedited Transaction Table61Z1UOMUnit of Measure as InputStringUDC20
TOP46: Warehouse Management
224F4142Warehouse Count Transactions38CTUOMUnit of Measure as InputStringUDC20
225F4600Warehouse Requests26R1UOMUnit of Measure as InputStringUDC20
226F4600PUWarehouse Requests - Purged26R1UOMUnit of Measure as InputStringUDC20
227F46011Item Unit Of Measure Definition4IQUOMUnit of Measure as InputStringUDC20
228F46011TItem Unit Of Measure Definition Tag File4IQUOMUnit of Measure as InputStringUDC20
229F46012Fixed Locations4ISUOMUnit of Measure as InputStringUDC20
230F46013Carton Recommendation Rules4EQUOMUnit of Measure as InputStringUDC20
231F460131Standard Pack Recommendation Rules6SPUOMUnit of Measure as InputStringUDC20
232F46015Replenishment Information by Random Rule10RRUOMUnit of Measure as InputStringUDC20
233F46024Location Capacity5LCUOMUnit of Measure as InputStringUDC20
234F46025Maximum Putaway Quantity by Zone4MQUOMUnit of Measure as InputStringUDC20
235F46095Movement Instructions7ETUOMUnit of Measure as InputStringUDC20
236F46096Unit Of Measure Groups2OUUOMUnit of Measure as InputStringUDC20
237F46130Putaway Reservations16R3UOMUnit of Measure as InputStringUDC20
238F46130PUPutaway Reservations - Purged16R3UOMUnit of Measure as InputStringUDC20
239F4615Carton Recommendations8CRUOMUnit of Measure as InputStringUDC20
240F4620Carton Detail Information6CDUOMUnit of Measure as InputStringUDC20
241F46200Bulk Pick Requests8BRUOMUnit of Measure as InputStringUDC20
242F46200PUBulk Pick Requests - Purged8BRUOMUnit of Measure as InputStringUDC20
243F46UI15Carton Recommendations - Work File8RCUOMUnit of Measure as InputStringUDC20
244F4942Z1Work File for F494228SYUOMUnit of Measure as InputStringUDC20
TOP46L: License Plating
245F46L42License Plate Cycle and Tag Count16CCUOMUnit of Measure as InputStringUDC20
246F46L99License Plate History38LMUOMUnit of Measure as InputStringUDC20
247F46LUI01Assign/Remove Items To LP Work File18WFUOMUnit of Measure as InputStringUDC20
248F46LUI02Work Table for Manual Build UOM Structure5LPUOMUnit of Measure as InputStringUDC20
TOP47: Electronic Commerce
249F47012EDI Purchase Order Detail - Inbound81SZUOMUnit of Measure as InputStringUDC20
250F47017EDI Purchase Order Detail - Outbound74SZUOMUnit of Measure as InputStringUDC20
251F47022EDI P.O. Acknowledgment Detail - Inbound74SZUOMUnit of Measure as InputStringUDC20
252F47027EDI P.O. Acknowledgment Detail - Outbound81SZUOMUnit of Measure as InputStringUDC20
253F47032EDI Shipping Notice Detail - Inbound57SZUOMUnit of Measure as InputStringUDC20
254F47037EDI Shipping Notice Detail - Outbound78SZUOMUnit of Measure as InputStringUDC20
255F470371EDI Shipping Notice Detail - Outbound88SZUOMUnit of Measure as InputStringUDC20
256F470372EDI ASN Demand Scheduling Detail22AIUOMUnit of Measure as InputStringUDC20
257F470375EDI ASN Packaging Detail22AKUOMUnit of Measure as InputStringUDC20
258F47042EDI Invoice Detail - Inbound58SZUOMUnit of Measure as InputStringUDC20
259F47047EDI Invoice Detail (Sales) - Outbound81SZUOMUnit of Measure as InputStringUDC20
260F47062EDI Planning Schedule Detail - Inbound21MYUOMUnit of Measure as InputStringUDC20
261F47067EDI Planning Schedule Detail - Outbound21MYUOMUnit of Measure as InputStringUDC20
262F47072EDI Receiving Advice Detail - Inbound75SZUOMUnit of Measure as InputStringUDC20
263F47077EDI Receiving Advice Detail - Outbound75SZUOMUnit of Measure as InputStringUDC20
264F47082EDI Price Sales Catalog Detail - Inbound68FYUOMUnit of Measure as InputStringUDC20
265F47092EDI Request for Quote Detail - Inbound81SZUOMUnit of Measure as InputStringUDC20
266F47097EDI Request for Quote Detail - Outbound74SZUOMUnit of Measure as InputStringUDC20
267F47102EDI Response to RFQ Detail - Inbound74SZUOMUnit of Measure as InputStringUDC20
268F47107EDI Response to RFQ Detail - Outbound81SZUOMUnit of Measure as InputStringUDC20
269F47132EDI Purchase Order Change Detail - Inbound82SZUOMUnit of Measure as InputStringUDC20
270F47137EDI Purchase Order Change Detail - Outbound75SZUOMUnit of Measure as InputStringUDC20
271F47142EDI P.O. Change Acknowledgment Detail - Inbound76SZUOMUnit of Measure as InputStringUDC20
272F47147EDI P.O. Change Acknowledgment Detail - Outbound83SZUOMUnit of Measure as InputStringUDC20
273F47157EDI Shipping Schedule Detail - Outbound80SZUOMUnit of Measure as InputStringUDC20
274F47191EDI Acknowledgement Header42AHUOMUnit of Measure as InputStringUDC20
275F47UI001ASN Extract Work File36SZUOMUnit of Measure as InputStringUDC20
TOP48: Work Order Processing
276F4801Work Order Master File68WAUOMUnit of Measure as InputStringUDC20
277F48UI001X4801 Master Business Function Workfile71WAUOMUnit of Measure as InputStringUDC20
TOP49: Transportation Management
278F49110Transportation Bill of Lading Workfile41BWUOMUnit of Measure as InputStringUDC20
279F4942Shipment Detail13ISUOMUnit of Measure as InputStringUDC20
280F4945Shipment Charges22SCUOMUnit of Measure as InputStringUDC20
281F4962Load Compartments12TEUOMUnit of Measure as InputStringUDC20
282F49621Load Compartment Detail26TDUOMUnit of Measure as InputStringUDC20
283F49634Load In-Transit Confirmed Quantities Detail11QDUOMUnit of Measure as InputStringUDC20
284F4981Freight Audit History30FHUOMUnit of Measure as InputStringUDC20
TOP55: Reserved for Clients
285F74H1051Invoicing Workfile - New11IWUOMUnit of Measure as InputStringUDC20
TOP74: EMEA Localization
286F74093Workfile for Printing IVA Summary - Italy27HCUOMUnit of Measure as InputStringUDC20
287F7420033Sales Document Line (Print Info) - COMM - 4211PIUOMUnit of Measure as InputStringUDC20
288F744102Intrastat Commodity Code Additional Information4IBUOMUnit of Measure as InputStringUDC20
TOP74R: CIS
289F74R5110F1201 Tag File - RUS - 12 - 74R15TFUOMUnit of Measure as InputStringUDC20
TOP75T: Taiwan
290F75T005GUI/VAT Transaction Detail - 75T8TDUOMUnit of Measure as InputStringUDC20
291F75T0059GUI/VAT Transaction Detail History - 75T8TDUOMUnit of Measure as InputStringUDC20
292F75T005PGUI/VAT Transaction Detail POS - 75T8TDUOMUnit of Measure as InputStringUDC20
293F75T005ZGUI/VAT Transaction Detail - Work - 75T14ZDUOMUnit of Measure as InputStringUDC20
TOP76A: Argentina
294F76A13Taxes - Tax Values - ARG - 0010TVUOMUnit of Measure as InputStringUDC20
295F76A18Taxes - Tax Amounts by Sales Order Line - ARG - 0018TOUOMUnit of Measure as InputStringUDC20
296F76A18PTaxes - Tax Amounts by Sales Order Line Purge - ARG - - 76A18TOUOMUnit of Measure as InputStringUDC20
297F76A19Taxes - Tax Amounts by Invoice Suffix AGR16TIUOMUnit of Measure as InputStringUDC20
298F76A19PTaxes - Tax Amounts by Invoice Suffix Purge ARG - 03B - 76A16TIUOMUnit of Measure as InputStringUDC20
299F76A19Z1Taxes - Tax Amounts by Invoice Suffix - Batch Entry A - 03B34VKUOMUnit of Measure as InputStringUDC20
300F76A8230Percentages by state / agreement Gross Income - ARG - - 76A12C1UOMUnit of Measure as InputStringUDC20
301F76AUI18Taxes - Tax amount by order line - Work File - ARG - 4212WFUOMUnit of Measure as InputStringUDC20
302F76AUI24Taxes Work File - ARG - 0015TIUOMUnit of Measure as InputStringUDC20
TOP76B: Brazil - Reporting System Only
303F76111BNota Fiscal - Detail (Fiscal Books) - 4211QUUOMUnit of Measure as InputStringUDC20
304F76111BTConversion table for CFOP 5 digits - F76111B - 4211TAUOMUnit of Measure as InputStringUDC20
305F7611BNota Fiscal Detail - Brazil33FDUOMUnit of Measure as InputStringUDC20
306F761BAAS Fiscal file book37FBUOMUnit of Measure as InputStringUDC20
307F76B3010Work Table for Item/Part List - 305IPUOMUnit of Measure as InputStringUDC20
308F76B31Nota Fiscal Detail/Table for Goods - IN68 - 4216IMUOMUnit of Measure as InputStringUDC20
309F76B411DIN86-Work Table for Merchandise Nota Fiscal Issued by - 4217CDUOMUnit of Measure as InputStringUDC20
310F76B411EIN86-Work Table for Merchandise NF Issued by Supplier - 4117SDUOMUnit of Measure as InputStringUDC20
311F76B51Inventory Records Table - IN68 - 427RIUOMUnit of Measure as InputStringUDC20
TOP76H: Chile
312F76H3B34Sales Document Line (Print Info) - CHI - 03B - 76H8PIUOMUnit of Measure as InputStringUDC20
313F76H3B38Shipment Guide Line (Print Info) - CHI - 03B - 76H8PIUOMUnit of Measure as InputStringUDC20
TOP89: Conversion Programs
314F40344ATemporay Preference Profile - Sales Commission9SAUOMUnit of Measure as InputStringUDC20
315F4072TEMPrice Adjustment Detail - Temp for Upgrade12ADUOMUnit of Measure as InputStringUDC20
316F43199ATemp F43199 for ERP 9.0 Upgrade60OLUOMUnit of Measure as InputStringUDC20
TOPD3N: dcLINK (data collection) - DSI
317FD3N161PPallet Tracking Table 417PHUOMUnit of Measure as InputStringUDC20
318FD3N4950dcLINK Delivery Confirmation Work File12DCUOMUnit of Measure as InputStringUDC20
319FD3N913TranPrint - Default Labels - Table10DLUOMUnit of Measure as InputStringUDC20
TOPF30L: DFM Line Design
320FF30L002DFM Bill of Material Master12DHUOMUnit of Measure as InputStringUDC20
321FF30L930DFM Routings17LRUOMUnit of Measure as InputStringUDC20
TOPF31: Lean Transactions
322FF31010Production Master File24EHUOMUnit of Measure as InputStringUDC20
323FF31011TransactionID Master File12EHUOMUnit of Measure as InputStringUDC20
324FF31011SPurge - TransactionID Master File12ERUOMUnit of Measure as InputStringUDC20
325FF31111Lean Transaction Parts List14PLUOMUnit of Measure as InputStringUDC20
326FF31111SPurge - Lean Transaction Parts List14PRUOMUnit of Measure as InputStringUDC20
327FF31112Routing Transaction Table67EHUOMUnit of Measure as InputStringUDC20
328FF31112SPurge - Routing Transaction Table67ETUOMUnit of Measure as InputStringUDC20
329FF31113Lean Transaction Labor Detail28LDUOMUnit of Measure as InputStringUDC20
330FF31113SPurge - Lean Transaction Labor Detail28LRUOMUnit of Measure as InputStringUDC20
331FF31200Production Costs20PCUOMUnit of Measure as InputStringUDC20
TOPF31K: DFM Kanban Management
332FF31K11DFM Kanban Parent Items7PIUOMUnit of Measure as InputStringUDC20
333FF31K20DFM Kanban Component8KCUOMUnit of Measure as InputStringUDC20
TOPH98: Internet
334F98616Printer Definition11PTUOMUnit of Measure as InputStringUDC20
335F986162Paper 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