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
9F4111ILItem Ledger File
10F4311PDPurchase Order Detail File

812: Top 10 requests

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

538 columns | Print definition?812 | DCTO | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0018Sales/Use/V.A.T. Tax File5TDDCTOOrder TypeStringUDC20
2F00189WF - Tax Reconciliation5TGDCTOOrder TypeStringUDC20
3F0029Sales Tax Work File by Taxing Authority and Document13TFDCTOOrder TypeStringUDC20
4F004201Prepayment Transaction Table2PTDCTOOrder TypeStringUDC20
5F0046Processing Log6PLDCTOOrder TypeStringUDC20
6F0047Data Export Control2DEDCTOOrder TypeStringUDC20
7F0911Account Ledger84GLDCTOOrder TypeStringUDC20
8F1501Tenant/Lease Master2NEDCTOOrder TypeStringUDC20
9F4096Sales Flex Accounting7FADCTOOrder TypeStringUDC20
10F4303Log Master2PKDCTOOrder TypeStringUDC20
TOP02: Electronic Mail
11F0113Message Log Ledger File23ZZDCTOOrder TypeStringUDC20
TOP03: Accounts Receivable
12F0311Accounts Receivable Ledger82RPDCTOOrder TypeStringUDC20
13F0312A/R Batch Cash Application43RUDCTOOrder TypeStringUDC20
TOP03B: Enhanced Accounts Receivable
14F03B11Customer Ledger78RPDCTOOrder TypeStringUDC20
15F03B11PCustomer Ledger Purge File78RPDCTOOrder TypeStringUDC20
16F03B11Z1Invoice Transactions - Batch File94VJDCTOOrder TypeStringUDC20
17F03B11Z2F03B11 Interoperability Table91SYDCTOOrder TypeStringUDC20
18F03B14A/R Check Detail File127RZDCTOOrder TypeStringUDC20
19F03B14PReceipts Detail Purge File127RZDCTOOrder TypeStringUDC20
20F03B14Z2F03B14 Interoperability Table138SZDCTOOrder TypeStringUDC20
21F03B575Auto Debit Invoice Select and Build87RDDCTOOrder TypeStringUDC20
TOP04: Accounts Payable
22F09UI006Tax (F0018) Replica5TDDCTOOrder TypeStringUDC20
TOP07: Payroll
23F0716701Employee Assignment T/E Template Information46EADCTOOrder TypeStringUDC20
24F0716709Employee Assignment T/E Template Info History46EADCTOOrder TypeStringUDC20
TOP09: General Accounting
25F0911PPurge - Account Ledger84GLDCTOOrder TypeStringUDC20
26F0911Z1Journal Entry Transactions - Batch File101VNDCTOOrder TypeStringUDC20
27F0911Z4F0911 Interoperability Table106SZDCTOOrder TypeStringUDC20
28F0917Bank Statement Detail32GDDCTOOrder TypeStringUDC20
29F09UI015Indexed Computations Multi-Tiered Entries84GLDCTOOrder TypeStringUDC20
TOP12: Fixed Assets
30F1217Equipment Master Extension6WRDCTOOrder TypeStringUDC20
31F1217PEquipment Master Extension Purge Table6WRDCTOOrder TypeStringUDC20
32F1217Z1Unedited Equipment Tag Transactions19WRDCTOOrder TypeStringUDC20
33F1217Z2Unedited Equipment Tag Transactions19WRDCTOOrder TypeStringUDC20
TOP13: Plant/Equipment Management
34F13411PM Projections13RXDCTOOrder TypeStringUDC20
35F1393Maintenance Rules24GODCTOOrder TypeStringUDC20
TOP13R: Resource Assignments
36F48311Resource Assignments3RADCTOOrder TypeStringUDC20
37F48311SPurge - Resource Assignments3RADCTOOrder TypeStringUDC20
TOP15: Property Management
38F15012Tenant E.P. Class Master2NSDCTOOrder TypeStringUDC20
39F15012BTenant E.P. Class Master3NSDCTOOrder TypeStringUDC20
40F15013Sales Overage Master2NODCTOOrder TypeStringUDC20
41F15013BSales Overage Master File16NODCTOOrder TypeStringUDC20
42F15014Product Scales Master2NPDCTOOrder TypeStringUDC20
43F15014BProduct Scales Master11NPDCTOOrder TypeStringUDC20
44F15015Minimum rent/recoveries Master2NQDCTOOrder TypeStringUDC20
45F15015BMin/Max Rents And Recoveries Master8NQDCTOOrder TypeStringUDC20
46F1501BLease Master Header File6NEDCTOOrder TypeStringUDC20
47F1511Tenant/Lease Billings Detail6NJDCTOOrder TypeStringUDC20
48F1511BTenant/Lease Billings Detail Master6NJDCTOOrder TypeStringUDC20
49F1511HTenant/Lease Billings Detail History6N#DCTOOrder TypeStringUDC20
50F1511HBTenant/Lease Billings Detail History6NCDCTOOrder TypeStringUDC20
51F1533Tenant Class Account Exclusions2NMDCTOOrder TypeStringUDC20
52F1533BTenant Account Exclusions3NMDCTOOrder TypeStringUDC20
53F1540Sales Report Control File2NRDCTOOrder TypeStringUDC20
54F1540BSales Report Control File19NRDCTOOrder TypeStringUDC20
TOP17: Customer Service Management
55F17113Assessor Defaults14ADDCTOOrder TypeStringUDC20
56F1720Contract Header2CHDCTOOrder TypeStringUDC20
57F1721Contract Detail2CDDCTOOrder TypeStringUDC20
58F1775Claim Temporary Table28TCDCTOOrder TypeStringUDC20
59F1793CSMS Line Type Constants7LFDCTOOrder TypeStringUDC20
60F1794Billing/Amort Control Master2NKDCTOOrder TypeStringUDC20
61F3111Z2Warranty Claim/Supplier Recovery processing15WPDCTOOrder TypeStringUDC20
62F3112Z2Warranty Claim/Supplier Recovery processing15WLDCTOOrder TypeStringUDC20
63F4801Z2Warranty Claim/Supplier Recovery processing14WSDCTOOrder TypeStringUDC20
TOP17C: Call Management
64F1713ECOs Applied to Equipment3EEDCTOOrder TypeStringUDC20
65F1731Installed Base Location History9LQDCTOOrder TypeStringUDC20
66F1751Call Status RulesTable1GSDCTOOrder TypeStringUDC20
67F1755Customer Call Master5ZADCTOOrder TypeStringUDC20
68F1757Task Master2ZADCTOOrder TypeStringUDC20
69F1759Call Required Fields2CLDCTOOrder TypeStringUDC20
70F1760Time Entry5ZBDCTOOrder TypeStringUDC20
71F48164Knowledge Base Detail6KBDCTOOrder TypeStringUDC20
72F48165Call/Order Knowledge Base2KXDCTOOrder TypeStringUDC20
TOP30: Product Data Management
73F3016Kanban Master7KMDCTOOrder TypeStringUDC20
TOP31: Shop Floor Control
74F3102Production Cost2IGDCTOOrder TypeStringUDC20
75F3102SPurge - Production Cost2IGDCTOOrder TypeStringUDC20
76F31091Schedule Quantity Detail7IQDCTOOrder TypeStringUDC20
77F31091SSchedule Quantity Detail Purge7IQDCTOOrder TypeStringUDC20
78F3111Work Order Parts List2WMDCTOOrder TypeStringUDC20
79F3111SPurge - Shop Floor Parts List2WMDCTOOrder TypeStringUDC20
80F3111Z1Outbound Work Order Parts List15SZDCTOOrder TypeStringUDC20
81F3112Work Order Routing2WLDCTOOrder TypeStringUDC20
82F31122Work Order Time Transactions3WTDCTOOrder TypeStringUDC20
83F31122SPurge Work Order Time Transactions3WTDCTOOrder TypeStringUDC20
84F31122Z1Work Order Time Transactions Unedited Transaction Table16SZDCTOOrder TypeStringUDC20
85F3112SPurge Shop Floor Control Routing Instructions2WLDCTOOrder TypeStringUDC20
86F3112Z1Outbound Work Order Routings15SZDCTOOrder TypeStringUDC20
87F3115Net Change Transaction table3NCDCTOOrder TypeStringUDC20
88F3118Shortage Maintenance Master File4WNDCTOOrder TypeStringUDC20
89F31UI006Line Scheduling Workbench - Work File6LSDCTOOrder TypeStringUDC20
90F31UI427Labor Variance User Index7W1DCTOOrder TypeStringUDC20
91F31UI804Exception Report Work FIle9WRDCTOOrder TypeStringUDC20
92F4801SPurge - Work Order Master file1WADCTOOrder TypeStringUDC20
93F4801Z1Outbound Work Order Header14SYDCTOOrder TypeStringUDC20
94F4802SPurge Work Order Instructions2WBDCTOOrder TypeStringUDC20
TOP31B: Blend Management
95F31B85Weigh Tag Master29WTDCTOOrder TypeStringUDC20
TOP31P: Engineer To Order
96F31P01Project Attributes7PADCTOOrder TypeStringUDC20
97F31P10Project Quote Header4PQDCTOOrder TypeStringUDC20
98F31P11Project Quote Detail4QPDCTOOrder TypeStringUDC20
99F31PUI01Scheduling Error Report6SEDCTOOrder TypeStringUDC20
TOP32: Configuration Management
100F3201Configurator Master Table4CMDCTOOrder TypeStringUDC20
101F32019Configurator Master History Table4CHDCTOOrder TypeStringUDC20
102F3214Configured Model Text2MTDCTOOrder TypeStringUDC20
103F3294Configured String History File10KZDCTOOrder TypeStringUDC20
104F32943Configured String History - OneWorld11KODCTOOrder TypeStringUDC20
105F3295Segment Value History File7KSDCTOOrder TypeStringUDC20
106F3296Configurator Level/Sequence File3KRDCTOOrder TypeStringUDC20
107F32961Configurator Cost/Price Adjustment File7KLDCTOOrder TypeStringUDC20
108F329611Configurator Detail Cost/Price Adjustment Table2KBDCTOOrder TypeStringUDC20
109F3296TConfigurator Level Sequence File Table2KADCTOOrder TypeStringUDC20
TOP33: Capacity Planning
110F3312Capacity Pegging11CWDCTOOrder TypeStringUDC20
111F33UI001Shop Floor Control Routing Instructions6WLDCTOOrder TypeStringUDC20
TOP34: Requirements Planning
112F34004Demand/Supply Inclusion Rules2MGDCTOOrder TypeStringUDC20
113F3411MPS/MRP/DRP Message File10MMDCTOOrder TypeStringUDC20
114F3412MPS/MRP/DRP Lower Level Requirements File9MWDCTOOrder TypeStringUDC20
115F3430Vendor Schedule Quantity File5MVDCTOOrder TypeStringUDC20
116F3435Vendor Schedule Commitment File4MCDCTOOrder TypeStringUDC20
117F3440Vendor Schedule History File4MHDCTOOrder TypeStringUDC20
118F3450Adhoc Vendor Schedule File15MADCTOOrder TypeStringUDC20
119F3460Forecast File12MFDCTOOrder TypeStringUDC20
120F34A10Numetrix Integration Constants44N0DCTOOrder TypeStringUDC20
121F4321Supplier Schedule Master File3PBDCTOOrder TypeStringUDC20
122F43213SRS Ship Dates3VPDCTOOrder TypeStringUDC20
123F4321TSupplier Schedule Master Tag File3PBDCTOOrder TypeStringUDC20
TOP34A: Advanced Planning & Scheduling
124F34A60Last Outbound Purchase Order/Transfer Order12OBDCTOOrder TypeStringUDC20
TOP36: Forecasting
125F3460Z1Forecast Unedited Transactions25FTDCTOOrder TypeStringUDC20
TOP37: Quality Management
126F3703Non-Conforming Material12QEDCTOOrder TypeStringUDC20
127F3711Test Results2TRDCTOOrder TypeStringUDC20
128F3711Z1Test Results Unedited Transaction Table15SZDCTOOrder TypeStringUDC20
129F37900Certificate of Analysis (COA) Extract2TRDCTOOrder TypeStringUDC20
TOP38: Agreement Management
130F38111Agreements Transaction Ledger19DZDCTOOrder TypeStringUDC20
131F38112Agreements Committed Quantities2DXDCTOOrder TypeStringUDC20
TOP39: Advanced Stock Valuation
132F39120Temporary Period Build File for Stock Valuation17TFDCTOOrder TypeStringUDC20
133F39120WPeriod Detail Work File13TWDCTOOrder TypeStringUDC20
TOP40: Inventory/OP Base
134F3013ECO Parts List Detail2CYDCTOOrder TypeStringUDC20
135F4001ZBatch Receiver File - Order Headings26SYDCTOOrder TypeStringUDC20
136F4001Z50Batch Receiver File - Order Headings Commissions2HCDCTOOrder TypeStringUDC20
137F40051Return Material Authorization19RDDCTOOrder TypeStringUDC20
138F4006Order Address Information2OADCTOOrder TypeStringUDC20
139F4011ZBatch Receiver File - Order Details16SZDCTOOrder TypeStringUDC20
140F4011Z60Batch Receiver File - Order Details Commissions2DCDCTOOrder TypeStringUDC20
141F4017Print Message Report Defaults4TVDCTOOrder TypeStringUDC20
142F40203Order Activity Rules1FSDCTOOrder TypeStringUDC20
143F40205Line Type Control Constants File24LFDCTOOrder TypeStringUDC20
144F40300RPreference Resolution History - Master4PMDCTOOrder TypeStringUDC20
145F40320Preference Profile - Multi Shipping/Receiving Locations19LPDCTOOrder TypeStringUDC20
146F40320RPreference Resolution Ledger - Multi ShiP/Rec Locations20LPDCTOOrder TypeStringUDC20
147F40330Preference Profile - Document Set16DGDCTOOrder TypeStringUDC20
148F40341Preference Profile - Next Order Status14NSDCTOOrder TypeStringUDC20
149F40341RPreference Resolution Ledger - Next Order Status16NSDCTOOrder TypeStringUDC20
150F40741Preference Adjustment History2PHDCTOOrder TypeStringUDC20
151F4080Related Order Cross Reference Table6RODCTOOrder TypeStringUDC20
152F4095Distribution/Manufacturing - AAI Values3MLDCTOOrder TypeStringUDC20
153F40UI00TTax Work File3PNDCTOOrder TypeStringUDC20
154F40UI16Preference Print Message Work File4DSDCTOOrder TypeStringUDC20
155F40UI17Allocation Work File5ZGDCTOOrder TypeStringUDC20
156F40UI74Price Adjustment History Work File8AWDCTOOrder TypeStringUDC20
157F40UI801Generic Error Table5ZBDCTOOrder TypeStringUDC20
158F4108Lot Master11IODCTOOrder TypeStringUDC20
159F4201Z1Sales Order Header Unedited Transaction File16SYDCTOOrder TypeStringUDC20
160F4209Held Orders7HODCTOOrder TypeStringUDC20
161F4211AUSales Order Detail Audit File2AUDCTOOrder TypeStringUDC20
162F4211DTSales Order Detail Date Tracking File2DTDCTOOrder TypeStringUDC20
163F4211Z1Sales Order Detail Unedited Transaction File16SZDCTOOrder TypeStringUDC20
164F4220Basic Serial Numbers14SWDCTOOrder TypeStringUDC20
165F4314Sales Order/Purchasing Text Detail Lines3JMDCTOOrder TypeStringUDC20
166F43800Summary Voucher Match3PRDCTOOrder TypeStringUDC20
167F49211Sales Order Detail File - Tag File2UDDCTOOrder TypeStringUDC20
168F49211Z1Sales Order Detail Tag Unedited Transaction File15S1DCTOOrder TypeStringUDC20
169F49219Sales Order Detail - Tag History File2UDDCTOOrder TypeStringUDC20
TOP40G: Grower Management
170F40G03Grower Harvest111GHDCTOOrder TypeStringUDC20
TOP40R: Demand Scheduling
171F40R30WFDemand Work File11DSDCTOOrder TypeStringUDC20
172F47UI002ASN Extract Packaging Work File26SPDCTOOrder TypeStringUDC20
TOP41: Inventory Management
173F41081Allowed Lot Status3LSDCTOOrder TypeStringUDC20
174F4111Item Ledger File29ILDCTOOrder TypeStringUDC20
175F41181Container Transaction File9CMDCTOOrder TypeStringUDC20
176F41291ZLanded Cost Cache Table4IGDCTOOrder TypeStringUDC20
177F41UI001Inventory Transactions Detail File40ITDCTOOrder TypeStringUDC20
178F41UI002Inventory Transactions Batch File21TIDCTOOrder TypeStringUDC20
TOP41B: Bulk Stock Management
179F41509Four-Point Analysis Maintenance File2PGDCTOOrder TypeStringUDC20
180F415091Four-Point Temperature Maintenance3PGDCTOOrder TypeStringUDC20
181F41511Bulk Product Transaction File6PADCTOOrder TypeStringUDC20
182F41512Gain/Loss Transactions File10PTDCTOOrder TypeStringUDC20
TOP42: Sales Management
183F4020Freight/Additional Charges Rate Information6ARDCTOOrder TypeStringUDC20
184F4074Price Adjustment Ledger File2ALDCTOOrder TypeStringUDC20
185F42004Commission Constants File8CMDCTOOrder TypeStringUDC20
186F42005Sales Commission File11SCDCTOOrder TypeStringUDC20
187F4201Sales Order Header File3SHDCTOOrder TypeStringUDC20
188F42019Sales Order Header History File3SHDCTOOrder TypeStringUDC20
189F4211Sales Order Detail File3SDDCTOOrder TypeStringUDC20
190F42119Sales Order History File3SDDCTOOrder TypeStringUDC20
191F42150Sales Order Header Commission Information2SHDCTOOrder TypeStringUDC20
192F4216SO Pack Confirm Detail2XDDCTOOrder TypeStringUDC20
193F42160Sales Order Detail Commission Information2SDDCTOOrder TypeStringUDC20
194F42160ATemp Table Sales Order Commission information2SDDCTOOrder TypeStringUDC20
195F42199S.O. Detail Ledger File3SLDCTOOrder TypeStringUDC20
196F4229Sales Summary History File1SSDCTOOrder TypeStringUDC20
197F42565Invoice Print File7IWDCTOOrder TypeStringUDC20
198F42800G1Sales Update G Batch Detail Workfile35DGDCTOOrder TypeStringUDC20
199F4290Delivery Note History7SEDCTOOrder TypeStringUDC20
200F42UI005Sales Commission File11SCDCTOOrder TypeStringUDC20
201F42UI01SO Header Cache File (MBF)8ZHDCTOOrder TypeStringUDC20
202F42UI11SO Detail Cache File (MBF)7ZDDCTOOrder TypeStringUDC20
203F42UI12Sales Order Detail Cache 2 (MBF)6ZDDCTOOrder TypeStringUDC20
204F42UI130Commitment Work File7ZCDCTOOrder TypeStringUDC20
205F42UI520Pick Slips Header File3S8DCTOOrder TypeStringUDC20
206F42UI521Pick Slips Detail File4S9DCTOOrder TypeStringUDC20
207F42UI800Sales Detail Work File - Sales Update5SDDCTOOrder TypeStringUDC20
208F47027TTag for F47027 - EDI P.O. Acknowledgment Detail - Outbound4UZDCTOOrder TypeStringUDC20
209F470371TTag for F470371- EDI shipping Notice Detail - Outbound14UZDCTOOrder TypeStringUDC20
210F47047TTag for F47047- EDI Invoice Detail (Sales) - Outbound4UZDCTOOrder TypeStringUDC20
211F47107TTag for F47107- EDI Response to RFQ Detail - Outbound4UZDCTOOrder TypeStringUDC20
212F47147TTag F47147 - EDI P.O. Change Acknowledgment Detail-Outbound4UZDCTOOrder TypeStringUDC20
TOP42B: Sales Order Entry
213F4011ZTBatch Receiver File - Order Details Tag17UZDCTOOrder TypeStringUDC20
214F4201URF4201 CRM User Reserved Tag File3SHDCTOOrder TypeStringUDC20
215F4211CZ1Sales Order Detail Unedited Transaction File - CRM11CZDCTOOrder TypeStringUDC20
216F4211URF4211 CRM User Reserved Tag File2URDCTOOrder TypeStringUDC20
217F4211URZF4211Z1 CRM User Reserved Tag File11URDCTOOrder TypeStringUDC20
218F42150Z1Header Commission Unedited Transaction File11S2DCTOOrder TypeStringUDC20
219F42160Z1Detail Commission Unedited Transaction File11S3DCTOOrder TypeStringUDC20
220F42216WFPending Blanket Release Work File - F42216WF3PBDCTOOrder TypeStringUDC20
221F42420Audit Log Transaction3ALDCTOOrder TypeStringUDC20
222F47012TEDI Purchase Order Detail Tag - Inbound17UZDCTOOrder TypeStringUDC20
223F47092TEDI Request for Quote Detail Tag - Inbound17UZDCTOOrder TypeStringUDC20
224F47132TEDI Purchase Order Change Detail Tag - Inbound17UZDCTOOrder TypeStringUDC20
225F49299S.O. Detail Tag Ledger File2UDDCTOOrder TypeStringUDC20
TOP43: Procurement
226F4095TEMF4095 Temporary Table3MLDCTOOrder TypeStringUDC20
227F41061Supplier Price/Catalog File11CBDCTOOrder TypeStringUDC20
228F43008Approval Levels1APDCTOOrder TypeStringUDC20
229F4301Purchase Order Header3PHDCTOOrder TypeStringUDC20
230F4301ZPO Header Work File7PADCTOOrder TypeStringUDC20
231F4301Z1Purchase Order Header Unedited Transaction Table16SYDCTOOrder TypeStringUDC20
232F4305Log Master4PLDCTOOrder TypeStringUDC20
233F43080Approvals Fields Constants1PDDCTOOrder TypeStringUDC20
234F43092Purchase Order Receipt Routing File3PXDCTOOrder TypeStringUDC20
235F43092ZReceipt Routing Work File7PVDCTOOrder TypeStringUDC20
236F43092Z1Receipt Routing Unedited Transaction Table16SZDCTOOrder TypeStringUDC20
237F43099Receipt Routing Ledger File3PODCTOOrder TypeStringUDC20
238F4311Purchase Order Detail File3PDDCTOOrder TypeStringUDC20
239F4311TPurchase Order Detail Tag File3PDDCTOOrder TypeStringUDC20
240F4311ZPurchase Order Generator File7PWDCTOOrder TypeStringUDC20
241F4311Z1Purchase Order Detail Unedited Transaction Table16SZDCTOOrder TypeStringUDC20
242F43121Purchase Order Receiver File5PRDCTOOrder TypeStringUDC20
243F43121TPurchase Order Receiver Tag File4PRDCTOOrder TypeStringUDC20
244F43121TBPurchase Order Receiver Tag Table4PRDCTOOrder TypeStringUDC20
245F43121ZReceiver workfile3PWDCTOOrder TypeStringUDC20
246F43121Z1Receipts Unedited Transaction Table22SZDCTOOrder TypeStringUDC20
247F4314ZVoucher Match Selection File104PNDCTOOrder TypeStringUDC20
248F4316Purchase Order Multiple Account File3P3DCTOOrder TypeStringUDC20
249F4316TPurchase Order Multiple Account Tag File3P3DCTOOrder TypeStringUDC20
250F4318Approval/Rejection Reasons3PYDCTOOrder TypeStringUDC20
251F43199P.O. Detail Ledger File - Flexible Version3OLDCTOOrder TypeStringUDC20
252F4330Supplier Selection File3P0DCTOOrder TypeStringUDC20
253F4331Quantity Breaks File2P1DCTOOrder TypeStringUDC20
254F4332Multiple Requisition File3P2DCTOOrder TypeStringUDC20
255F4333WFPurchase Order Dispatch Work File3PODCTOOrder TypeStringUDC20
256F4343Purchase Rebate History6RHDCTOOrder TypeStringUDC20
257F43632ZOpen Purchase Order by Item Work File6OIDCTOOrder TypeStringUDC20
258F43E09F43E09 - Approvals Activity Table4AADCTOOrder TypeStringUDC20
259F43UI50DPO Print Detail Work File4PWDCTOOrder TypeStringUDC20
260F43UI50HPO Print Header Work File3PADCTOOrder TypeStringUDC20
TOP43A: Purchase Order Receipt/Routing
261F43126Purchase Order Receiver Multiple Account4P4DCTOOrder TypeStringUDC20
262F43126TPurchase Order Receiver Multiple Account Tag File4P4DCTOOrder TypeStringUDC20
TOP43B: Voucher Match and Landed Cost
263F43146TVoucher Match Multiple Account Tag File3P5DCTOOrder TypeStringUDC20
TOP43E: Requisition Self Service
264F43E01Requisition Order Header3RHDCTOOrder TypeStringUDC20
265F43E11Requisition Detail3RDDCTOOrder TypeStringUDC20
266F43E121eRequisition Receiver file3ERDCTOOrder TypeStringUDC20
267F43E16Requisition Multiple Account File3P3DCTOOrder TypeStringUDC20
TOP43Q: Strategic Sourcing
268F43Q10Event Header2EHDCTOOrder TypeStringUDC20
269F43Q11Event Detail2EDDCTOOrder TypeStringUDC20
270F43Q15Event Currencies2ECDCTOOrder TypeStringUDC20
271F43Q20Event Header Bid Questions2EHDCTOOrder TypeStringUDC20
272F43Q201Event Header Bid Question List2EHDCTOOrder TypeStringUDC20
273F43Q21Event Detail Bid Questions2EDDCTOOrder TypeStringUDC20
274F43Q211Event Detail Bid Question List2EDDCTOOrder TypeStringUDC20
275F43Q212Event Detail Bid Question Price Component2PCDCTOOrder TypeStringUDC20
276F43Q213Event Detail Price Break2PBDCTOOrder TypeStringUDC20
277F43Q30Event Invited Bidders2EVDCTOOrder TypeStringUDC20
278F43Q40Response Header2RADCTOOrder TypeStringUDC20
279F43Q401Response Header Question2RCDCTOOrder TypeStringUDC20
280F43Q402Response Header Question List2RDDCTOOrder TypeStringUDC20
281F43Q403Bidder Response Decline2RIDCTOOrder TypeStringUDC20
282F43Q404Response Disallow2RJDCTOOrder TypeStringUDC20
283F43Q405Response Disallow Line2RKDCTOOrder TypeStringUDC20
284F43Q41Response Line2RBDCTOOrder TypeStringUDC20
285F43Q411Response Detail Question2REDCTOOrder TypeStringUDC20
286F43Q412Response Detail Question Price Break2RGDCTOOrder TypeStringUDC20
287F43Q413Response Detail Question Price Components2RHDCTOOrder TypeStringUDC20
288F43Q414Response Detail Question List2RLDCTOOrder TypeStringUDC20
289F43Q50Analyze Event Header2AVDCTOOrder TypeStringUDC20
290F43Q51Analyze Event Detail2EDDCTOOrder TypeStringUDC20
291F43Q92Adhoc Item Definition8AIDCTOOrder TypeStringUDC20
TOP43S: Supplier Self Service
292F43001Procurement Self-Service Transaction Log8SADCTOOrder TypeStringUDC20
293F4313POFLIP3PFDCTOOrder TypeStringUDC20
TOP44H: Homebuilder Management
294F4454Vendor Assignment (World)5JGDCTOOrder TypeStringUDC20
295F4455Vendor Assignment (Takeoffs) (World)7JHDCTOOrder TypeStringUDC20
296F44H001HomeBuilder Constants15HCDCTOOrder TypeStringUDC20
297F44H0011HomeBuilder Constants Lot Start Documents3LDDCTOOrder TypeStringUDC20
298F44H601Bid Header3BHDCTOOrder TypeStringUDC20
299F44H604Vendor Assignment12VADCTOOrder TypeStringUDC20
300F44H604WVendor Assignment Workfile14VWDCTOOrder TypeStringUDC20
301F44H604ZHB Vendor Assignment Unedited Transaction File25SZDCTOOrder TypeStringUDC20
302F44H611Bid Details3BDDCTOOrder TypeStringUDC20
303F44H611WBid Details Work File4BWDCTOOrder TypeStringUDC20
304F44H711Lot Start Workfile27SWDCTOOrder TypeStringUDC20
305F44H711ZHB Lot Start Unedited Transaction File39SZDCTOOrder TypeStringUDC20
306F44H71W1Lot Start Generation Workfile27GWDCTOOrder TypeStringUDC20
307F44H73W1Lot Start - P.O. / Committment Generation Work File12CGDCTOOrder TypeStringUDC20
TOP45: Advanced Pricing
308F4079Rebate Transaction Detail10SVDCTOOrder TypeStringUDC20
309F40UI84Orders Affected by Price Change (Work-file)3XRDCTOOrder TypeStringUDC20
310F45520Price List Header2PHDCTOOrder TypeStringUDC20
311F45521Price List Detail2PDDCTOOrder TypeStringUDC20
312F45522Price List Level-Break Pattern2PLDCTOOrder TypeStringUDC20
313F45523Price List Columns Group Pattern2PCDCTOOrder TypeStringUDC20
314F45524Price List Item Selection2PIDCTOOrder TypeStringUDC20
315F4573Free Goods Reference File2RFDCTOOrder TypeStringUDC20
316F4574Key Reference Table55KRDCTOOrder TypeStringUDC20
317F4575Ship and Debit History3AHDCTOOrder TypeStringUDC20
318F4575TMPShip and Debit History - Temp Table3AHDCTOOrder TypeStringUDC20
319F4576Ship and Debit Claims2ACDCTOOrder TypeStringUDC20
320F4576TMPShip and Debit Claims- Temp Table2ACDCTOOrder TypeStringUDC20
321F4576Z1Ship and Debit Claims Unedited Transaction Table15Z1DCTOOrder TypeStringUDC20
TOP46: Warehouse Management
322F4600Warehouse Requests7R1DCTOOrder TypeStringUDC20
323F4600PUWarehouse Requests - Purged7R1DCTOOrder TypeStringUDC20
324F4602Location Detail Information79IFDCTOOrder TypeStringUDC20
325F46092Order Groups3OZDCTOOrder TypeStringUDC20
326F4611Warehouse Suggestions13R2DCTOOrder TypeStringUDC20
327F4611PUWarehouse Suggestions - Purged13R2DCTOOrder TypeStringUDC20
328F4611Z1Unedited Suggestion Table26SZDCTOOrder TypeStringUDC20
329F46130Putaway Reservations3R3DCTOOrder TypeStringUDC20
330F46130PUPutaway Reservations - Purged3R3DCTOOrder TypeStringUDC20
331F4620Carton Detail Information8CDDCTOOrder TypeStringUDC20
332F46200Bulk Pick Requests10BRDCTOOrder TypeStringUDC20
333F46200PUBulk Pick Requests - Purged10BRDCTOOrder TypeStringUDC20
334F4942Z1Work File for F494215SYDCTOOrder TypeStringUDC20
TOP46L: License Plating
335F46L12License Plate Commitment3LCDCTOOrder TypeStringUDC20
336F46L99License Plate History12LMDCTOOrder TypeStringUDC20
337F46LUI01Assign/Remove Items To LP Work File26WFDCTOOrder TypeStringUDC20
TOP47: Electronic Commerce
338F47003EDI Discrepancy Report Work File11SXDCTOOrder TypeStringUDC20
339F47011EDI Purchase Order Header - Inbound21SYDCTOOrder TypeStringUDC20
340F4701150EDI Purchase Order Header Commission Inbound2PHDCTOOrder TypeStringUDC20
341F47012EDI Purchase Order Detail - Inbound17SZDCTOOrder TypeStringUDC20
342F4701260EDI Purchase Order Detail Commission Inbound2PDDCTOOrder TypeStringUDC20
343F47016EDI Purchase Order Header - Outbound18SYDCTOOrder TypeStringUDC20
344F470161EDI Purchase Order Additional Header - Outbound11S3DCTOOrder TypeStringUDC20
345F47017EDI Purchase Order Detail - Outbound17SZDCTOOrder TypeStringUDC20
346F470171EDI Purchase Order Additional Detail - Outbound11S4DCTOOrder TypeStringUDC20
347F47021EDI P.O. Acknowledgment Header - Inbound18SYDCTOOrder TypeStringUDC20
348F47022EDI P.O. Acknowledgment Detail - Inbound17SZDCTOOrder TypeStringUDC20
349F47026EDI P.O. Acknowledgment Header - Outbound18SYDCTOOrder TypeStringUDC20
350F47027EDI P.O. Acknowledgment Detail - Outbound17SZDCTOOrder TypeStringUDC20
351F47031EDI Shipping Notice Header - Inbound19SYDCTOOrder TypeStringUDC20
352F47032EDI Shipping Notice Detail - Inbound20SZDCTOOrder TypeStringUDC20
353F47037EDI Shipping Notice Detail - Outbound20SZDCTOOrder TypeStringUDC20
354F470371EDI Shipping Notice Detail - Outbound20SZDCTOOrder TypeStringUDC20
355F47041EDI Invoice Header - Inbound18SYDCTOOrder TypeStringUDC20
356F47042EDI Invoice Detail - Inbound19SZDCTOOrder TypeStringUDC20
357F47044EDI Invoice Summary - Inbound18SWDCTOOrder TypeStringUDC20
358F47046EDI Invoice Header (Sales) - Outbound18SYDCTOOrder TypeStringUDC20
359F470461EDI Invoice Additional Header - Outbound13S3DCTOOrder TypeStringUDC20
360F47047EDI Invoice Detail (Sales) - Outbound17SZDCTOOrder TypeStringUDC20
361F470471EDI Invoice Additional Detail - Outbound13S4DCTOOrder TypeStringUDC20
362F4706EDI Order Address Information11ZADCTOOrder TypeStringUDC20
363F47061EDI Planning Schedule Header - Inbound25MJDCTOOrder TypeStringUDC20
364F47066EDI Planning Schedule Header - Outbound25MJDCTOOrder TypeStringUDC20
365F47071EDI Receiving Advice Header - Inbound19SYDCTOOrder TypeStringUDC20
366F47072EDI Receiving Advice Detail - Inbound18SZDCTOOrder TypeStringUDC20
367F47076EDI Receiving Advice Header - Outbound19SYDCTOOrder TypeStringUDC20
368F47077EDI Receiving Advice Detail - Outbound18SZDCTOOrder TypeStringUDC20
369F47091EDI Request for Quote Header - Inbound21SYDCTOOrder TypeStringUDC20
370F4709150EDI Request for Quote Header Commission - Inbound2QHDCTOOrder TypeStringUDC20
371F47092EDI Request for Quote Detail - Inbound17SZDCTOOrder TypeStringUDC20
372F4709260EDI Request for Quote Detail Commission - Inbound2QDDCTOOrder TypeStringUDC20
373F47096EDI Request for Quote Header - Outbound18SYDCTOOrder TypeStringUDC20
374F47097EDI Request for Quote Detail - Outbound17SZDCTOOrder TypeStringUDC20
375F47098EDI RFQ Detail Quantity - Outbound9SZDCTOOrder TypeStringUDC20
376F47101EDI Response to RFQ Header - Inbound18SYDCTOOrder TypeStringUDC20
377F47102EDI Response to RFQ Detail - Inbound17SZDCTOOrder TypeStringUDC20
378F47103EDI Response to RFQ Detail Quantity - Inbound9SZDCTOOrder TypeStringUDC20
379F47106EDI Response to RFQ Header - Outbound18SYDCTOOrder TypeStringUDC20
380F471061EDI Response to RFQ Additional Header - Outbound13S3DCTOOrder TypeStringUDC20
381F47107EDI Response to RFQ Detail - Outbound17SZDCTOOrder TypeStringUDC20
382F471071EDI Response to RFQ Additional Detail - Outbound13S4DCTOOrder TypeStringUDC20
383F47114EDI Lockbox/Payment Detail - Payment26Z4DCTOOrder TypeStringUDC20
384F47122EDI Product Activity Data Detail - Inbound57MJDCTOOrder TypeStringUDC20
385F47127EDI Product Activity Data Detail - Outbound57MJDCTOOrder TypeStringUDC20
386F47131EDI Purchase Order Change Header - Inbound18SYDCTOOrder TypeStringUDC20
387F4713150EDI Purchase Order Change Header Commission - Inbound2CHDCTOOrder TypeStringUDC20
388F47132EDI Purchase Order Change Detail - Inbound18SZDCTOOrder TypeStringUDC20
389F4713260EDI Purchase Order Change Detail Commission - Inbound2PDDCTOOrder TypeStringUDC20
390F47136EDI Purchase Order Change Header - Outbound18SYDCTOOrder TypeStringUDC20
391F47137EDI Purchase Order Change Detail - Outbound18SZDCTOOrder TypeStringUDC20
392F4714EDI Order Text Lines - Header12ZTDCTOOrder TypeStringUDC20
393F47141EDI P.O. Change Acknowledgment Header - Inbound19SYDCTOOrder TypeStringUDC20
394F47142EDI P.O. Change Acknowledgment Detail - Inbound19SZDCTOOrder TypeStringUDC20
395F47146EDI P.O. Change Acknowledgment Header - Outbound19SYDCTOOrder TypeStringUDC20
396F47147EDI P.O. Change Acknowledgment Detail - Outbound19SZDCTOOrder TypeStringUDC20
397F4715EDI Order Text Lines - Detail12ZDDCTOOrder TypeStringUDC20
398F47156EDI Shipping Schedule Header - Outbound19SYDCTOOrder TypeStringUDC20
399F47157EDI Shipping Schedule Detail - Outbound17SZDCTOOrder TypeStringUDC20
400F47UI001ASN Extract Work File26SZDCTOOrder TypeStringUDC20
TOP48: Work Order Processing
401F4801Work Order Master File1WADCTOOrder TypeStringUDC20
402F4802Work Order Instructions File2WBDCTOOrder TypeStringUDC20
403F4802HWork Order Instructions File Header2WCDCTOOrder TypeStringUDC20
404F4808Order Routing Approval Master2CADCTOOrder TypeStringUDC20
405F4826W.O. Status Action Table1GEDCTOOrder TypeStringUDC20
406F4827Work Order Approval Routing1W5DCTOOrder TypeStringUDC20
407F48UI001X4801 Master Business Function Workfile4WADCTOOrder TypeStringUDC20
TOP48S: Service Billing
408F4812Billing Detail Workfile59WDDCTOOrder TypeStringUDC20
409F4812HBilling Workfile - History59WDDCTOOrder TypeStringUDC20
410F4812HSBilling Workfile History Purged Save59WDDCTOOrder TypeStringUDC20
411F4822Invoice Summary Work File2W4DCTOOrder TypeStringUDC20
412F48229Delete Invoices Audit Table6W8DCTOOrder TypeStringUDC20
413F4823Voucher Summary2W0DCTOOrder TypeStringUDC20
414F48520Invoice Summary Access7AEDCTOOrder TypeStringUDC20
415F48S58Invoice Print Version Cross Reference Table9F7DCTOOrder TypeStringUDC20
416F48S82Burden Base Rules8BRDCTOOrder TypeStringUDC20
417F48SUI01Billing Detail Print Workfile59WDDCTOOrder TypeStringUDC20
TOP49: Transportation Management
418F49110Transportation Bill of Lading Workfile36BWDCTOOrder TypeStringUDC20
419F49111Carton Detail Shipment Workfile8CDDCTOOrder TypeStringUDC20
420F49141Packing List Workfile26PWDCTOOrder TypeStringUDC20
421F4942Shipment Detail4ISDCTOOrder TypeStringUDC20
422F4944Shipment/Load Options and Equipment6OEDCTOOrder TypeStringUDC20
423F4945Shipment Charges26SCDCTOOrder TypeStringUDC20
424F49490Document Selection12TQDCTOOrder TypeStringUDC20
425F49594Document Print - Document Detail7DIDCTOOrder TypeStringUDC20
426F49621Load Compartment Detail4TDDCTOOrder TypeStringUDC20
427F49631Load In-transit Ledger24TODCTOOrder TypeStringUDC20
428F49634Load In-Transit Confirmed Quantities Detail3QDDCTOOrder TypeStringUDC20
429F49696Document Register Detail14DJDCTOOrder TypeStringUDC20
430F4981Freight Audit History39FHDCTOOrder TypeStringUDC20
TOP52: Contract Billing
431F5201Contract Master File2G4DCTOOrder TypeStringUDC20
432F5202Contract Billing Line Detail2G6DCTOOrder TypeStringUDC20
433F52034Contract Header Log Text2G9DCTOOrder TypeStringUDC20
434F5212T and M - Unit Price and Lumpsum Cross Reference Accounts2G5DCTOOrder TypeStringUDC20
435F5213Fee Billing Line Cross Reference Details2G3DCTOOrder TypeStringUDC20
436F5214Billing Line - Component Code Cross Reference Table2A4DCTOOrder TypeStringUDC20
437F5215Component Billing Line Cross Reference Details2A5DCTOOrder TypeStringUDC20
438F5216Milestone/Progress Billing Information2A6DCTOOrder TypeStringUDC20
439F52161Mileston/Progress Billing Line Cross Reference Details2A7DCTOOrder TypeStringUDC20
440F5280Contract Revenue Summary File2GWDCTOOrder TypeStringUDC20
441F5280WContract Revenue Summary Work File2GYDCTOOrder TypeStringUDC20
TOP53: Change Management
442F5302F5302 World Specs35DKDCTOOrder TypeStringUDC20
443F5311Change Request Details Table130DKDCTOOrder TypeStringUDC20
444F5311Z1Change Request Details Table Workfile135DKDCTOOrder TypeStringUDC20
445F5314Planned Change Order Master Table30D2DCTOOrder TypeStringUDC20
446F5315Change Order Master Table29D3DCTOOrder TypeStringUDC20
TOP55: Reserved for Clients
447F74H1009Intrastat - Small Transaction Work Table4ISDCTOOrder TypeStringUDC20
448F74H1051Invoicing Workfile - New5IWDCTOOrder TypeStringUDC20
449F74H1054Invoiced Order Lines - Work4IODCTOOrder TypeStringUDC20
450F74H1055Invoicing Selection Work Table3ISDCTOOrder TypeStringUDC20
451F74H1058Invoice Lines - SO Details5IODCTOOrder TypeStringUDC20
452F74P0710Credit Order History2PLDCTOOrder TypeStringUDC20
453F74U0141ACM - Application / Certificate Master3ACDCTOOrder TypeStringUDC20
454F74U0142ACM - Application / Certificate Status History3DHDCTOOrder TypeStringUDC20
TOP73: M & D complementary products
455F7307Quantum Non-Stock Product Categories1VXDCTOOrder TypeStringUDC20
TOP74: EMEA Localization
456F0018TIntrastat Revision3TDDCTOOrder TypeStringUDC20
457F7400007Business Unit / Doc Type Next Number - COMM - 002BDDCTOOrder TypeStringUDC20
458F740018Intrastat Revision Additional - CZE - 742AIDCTOOrder TypeStringUDC20
459F740018TTag File F0018 - EMEA - 742TFDCTOOrder TypeStringUDC20
460F74093Workfile for Printing IVA Summary - Italy5HCDCTOOrder TypeStringUDC20
461F7420011Sales Order / Legal Document Relationship - COMM - 422SLDCTOOrder TypeStringUDC20
462F7420015Invoices Related to Sales Order - COMM - 422SRDCTOOrder TypeStringUDC20
463F7420018Taxes by Sales Order Line - COMM - 422STDCTOOrder TypeStringUDC20
464F7430032Legal Document Detail (Print Info) - COMM - 03B7PIDCTOOrder TypeStringUDC20
TOP74U: United Kingdom Localizations
465F74U4311EPM - Purchase Order Tag File - 74U3PTDCTOOrder TypeStringUDC20
TOP75C: China - Reporting System Only
466F0018CNChina - Transmitted vouchers to JinSui2CTDCTOOrder TypeStringUDC20
467F75C001Chinese GUI cross reference file8CRDCTOOrder TypeStringUDC20
468F75C4203Chinese VAT on Free Goods Cross Reference - China2FCDCTOOrder TypeStringUDC20
TOP75T: Taiwan
469F75T004GUI/VAT Transaction Header - 75T60THDCTOOrder TypeStringUDC20
470F75T0049GUI/VAT Transaction Header History - 75T60THDCTOOrder TypeStringUDC20
471F75T004PGUI/VAT Transaction Header POS - 75T60THDCTOOrder TypeStringUDC20
472F75T004ZGUI/VAT Transaction Header - Work - 75T49ZHDCTOOrder TypeStringUDC20
473F75T005GUI/VAT Transaction Detail - 75T30TDDCTOOrder TypeStringUDC20
474F75T0059GUI/VAT Transaction Detail History - 75T30TDDCTOOrder TypeStringUDC20
475F75T005PGUI/VAT Transaction Detail POS - 75T30TDDCTOOrder TypeStringUDC20
476F75T005ZGUI/VAT Transaction Detail - Work - 75T35ZDDCTOOrder TypeStringUDC20
TOP76A: Argentina
477F76A0209Header and Footer Invoice/ShipmentNote History WF - ARG - 76A39HFDCTOOrder TypeStringUDC20
478F76A020PHeader/Footer Inv./ShipmentNote History WF Purge - AR - 76A39HFDCTOOrder TypeStringUDC20
479F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A45DLDCTOOrder TypeStringUDC20
480F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A45DLDCTOOrder TypeStringUDC20
481F76A09Invoice Total - ARG - 00 - 008TTDCTOOrder TypeStringUDC20
482F76A09PInvoice Total Purge - ARG - 03B - 76A8TTDCTOOrder TypeStringUDC20
483F76A18Taxes - Tax Amounts by Sales Order Line - ARG - 002TODCTOOrder TypeStringUDC20
484F76A18PTaxes - Tax Amounts by Sales Order Line Purge - ARG - - 76A2TODCTOOrder TypeStringUDC20
485F76A393Calculated costs detail - 76A15C3DCTOOrder TypeStringUDC20
486F76A395AAI Document Type - Work in Progress Adjustment - 76A2AADCTOOrder TypeStringUDC20
487F76AUI18Taxes - Tax amount by order line - Work File - ARG - 424WFDCTOOrder TypeStringUDC20
488F76AUI20Header and Footer Invoice/ShipmentNote Workfile - ARG - - 0039HFDCTOOrder TypeStringUDC20
489F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 00 - 0045DLDCTOOrder TypeStringUDC20
490F76AUI88Work File Last Invoice Number by Month - ARG - 03B - 76A10LIDCTOOrder TypeStringUDC20
TOP76B: Brazil - Reporting System Only
491F7611BNota Fiscal Detail - Brazil20FDDCTOOrder TypeStringUDC20
492F761BAAS Fiscal file book19FBDCTOOrder TypeStringUDC20
493F76421Sales Order Header Tag File - Brazil2SIDCTOOrder TypeStringUDC20
494F76422Sales Order Detail Tag File - Brazil2SJDCTOOrder TypeStringUDC20
495F76422UIWork File for temporary F76422 Records - Brazil2WFDCTOOrder TypeStringUDC20
496F76431Purchase Order Header Tag File - Brazil2PIDCTOOrder TypeStringUDC20
497F76432Purchase Order Detail Tag File - Brazil2PJDCTOOrder TypeStringUDC20
TOP76C: Colombia
498F76CT2Sales/Use/V.A.T. Tax File - COL - 76C9CTDCTOOrder TypeStringUDC20
499F76CUI04Tax Detail for Distribution - Work File - COL - 76C5TDDCTOOrder TypeStringUDC20
TOP76E: Ecuador
500F76E0018Print Withholding Workfile - EC - 044TDDCTOOrder TypeStringUDC20
501F76E4010Withholding Certificate Information - EC - 045CEDCTOOrder TypeStringUDC20
502F76E4020Withholding Certificate Information w/ SRI - EC - 042CRDCTOOrder TypeStringUDC20
TOP76H: Chile
503F76H211Sales Order / Legal Document Relationship - CHI - 42 - 76H2SLDCTOOrder TypeStringUDC20
504F76H215NC/ND - Invoice Related - CHI - 42 - 76H2IRDCTOOrder TypeStringUDC20
505F76H218Taxes by Sales Order Line - CHI - 42 - 76H2TDDCTOOrder TypeStringUDC20
506F76H3B32Legal Document Detail (Print Info) - CHI - 03B - 76H7PIDCTOOrder TypeStringUDC20
507F76H6006Order Type / Type W.O. Allowed for Actual Cost - CHI - 76H1WODCTOOrder TypeStringUDC20
508F76H611Actual Item Ledger File - CHI - 41 - 76H30ALDCTOOrder TypeStringUDC20
509F76HUI34Order Related Work File - CHI - 42 - 76H4ORDCTOOrder TypeStringUDC20
TOP89: Conversion Programs
510F4074TEMPrice Adjustment Ledger File - Temp for Upgrade2ALDCTOOrder TypeStringUDC20
511F42005ASales Commission File - Temporary11SCDCTOOrder TypeStringUDC20
512F42119ASales Order History File - temporary for upgrade (1)3SDDCTOOrder TypeStringUDC20
513F42119BSales Order History File - temporary for upgrade (2)3SDDCTOOrder TypeStringUDC20
514F4211ASales Order Detail File - temporary for upgrade (1)2SDDCTOOrder TypeStringUDC20
515F4211BSales Order Detail File - temporary for upgrade (2)3SDDCTOOrder TypeStringUDC20
516F42150AERP9.0 Update F42150 (Temp File)2SHDCTOOrder TypeStringUDC20
517F42199AS.O. Detail Ledger File - temporary for upgrade2SLDCTOOrder TypeStringUDC20
518F4311TATemp table for ERP 9.0 upgrade2PDDCTOOrder TypeStringUDC20
519F43121TAERP 9.0 temp F43121T for upgrade3PRDCTOOrder TypeStringUDC20
520F43199ATemp F43199 for ERP 9.0 Upgrade3OLDCTOOrder TypeStringUDC20
TOP90CG: CRM Case Management
521F90CG503Case Association Table6CADCTOOrder TypeStringUDC20
TOPD3N: dcLINK (data collection) - DSI
522FD3N0001dcLINK Xpress Check Out3ZZDCTOOrder TypeStringUDC20
523FD3N0016dcLINK Factivity Interface - Order Envelope Table4OEDCTOOrder TypeStringUDC20
524FD3N0200Employee Join/Leave Pattern History File7JLDCTOOrder TypeStringUDC20
525FD3N1611Pallet Tracking Table 27PDDCTOOrder TypeStringUDC20
526FD3N161PPallet Tracking Table 410PHDCTOOrder TypeStringUDC20
527FD3N421PPallet Tracking Table 35SHDCTOOrder TypeStringUDC20
528FD3N4950dcLINK Delivery Confirmation Work File6DCDCTOOrder TypeStringUDC20
529FD3N911dcLINK Interface - Cache UCC128 Numbers - Table13UCDCTOOrder TypeStringUDC20
TOPF30L: DFM Line Design
530FF30L801Sales Order Master3SDDCTOOrder TypeStringUDC20
TOPF31: Lean Transactions
531FF31010Production Master File13EHDCTOOrder TypeStringUDC20
532FF311114Related Purchase Orders for Lean Pay on Consumption Issues9PCDCTOOrder TypeStringUDC20
TOPF34S: DFM Production Sequencing
533FF34S002Daily Plan13DPDCTOOrder TypeStringUDC20
534FF34S01WDFM Plan Demand Work File7PDDCTOOrder TypeStringUDC20
TOPH90: ONEWORLD TOOLS
535F01131PPAT Message Control File30ZZDCTOOrder TypeStringUDC20
TOPH91: Design Tools
536F98TCDTLTable Conversion Detail2CDDCTOOrder TypeStringUDC20
537F98TCHDRTable Conversion Header2HDDCTOOrder TypeStringUDC20
TOPH95: Tech Resources/Applications
538F00166Media Object Categories21GTDCTOOrder TypeStringUDC20

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

TOPUDC 00 / DT (Document Type - All Documents) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1        $PSecurity WithholdingsY
2        $QGeneral SUSSY
3        % Percentage Journal EntryN
4        AJService Billing AdjustmentsY
5        ARAsset RevaluationY
6        ASAsset SplitN
7        ATAsset TransferN
8        BABilling AdjustmentsY
9        BFBalance Forward/SummarizeN
10        CACredit Note for AftercareN
11        CCCredit-Contract & Loyalty SuppN
12        CGLot Grade ChangeN
13        CPLot Potency ChangeN
14        CQCredit Note - Quarterly BonusN
15        CTCredit Note - Targeted BonusN
16        CWCredit Note for WarrantyN
17        DPDepreciation JournalN
18        DRJob Cost Draw SplitsY
19        EUService Billing RevenueY
20        EXCurrency Conversion OffsetsN
21        IQInventory Quantity OnlyY
22        IXRecalculate Average CostN
23        IZLot Hold/ReleaseN
24        JABudget or Cost AllocationN
25        JBJoint Interest BillingN
26        JCJob Cost % CompleteN
27        JDJIB Detail Owner EntriesN
28        JEJournal EntryN
29        JFJournals Brought ForwardN
30        JKA/P Redistribute PaymentsY
31        JMAR VAT RedistributionY
32        JPSubscription SalesN
33        JQSub. Sales Net LedgerN
34        JRSubscription Sales CommissionsN
35        JTAccrued Property TaxesN
36        JVA/P Redistribute PrepaymentsY
37        JXForeign Currency RevaluationN
38        JZCash Basis Journal EntryN
39        NPPartial NSFY
40        O Ordering Document TypesN
41        O4Purchase Order -TransportationN
42        OADo Not UseY
43        OBBlanket OrderN
44        OCConstruction Work OrderN
45        ODDirect Ship OrderN
46        OEDo Not Use--Exchange Rate Var.N
47        OIInteroperability Direct P.O.N
48        OKPurchase Intercompany OrderN
49        OMPurchase Order RMAN
50        OOOutside Operations
51        OPPurchase OrderN
52        OQPurchase Quote or BidN
53        OSSubcontractN
54        OURequisition Self ServiceY
55        OYEDI Purchase Order Quote
56        P1A/P DraftsN
57        P7Alternate Currency PaymentN
58        PACredit Note ReimbursementsN
59        PBBACS Electronic Funds TransferN
60        PEChange to Voucher AmountN
61        PGGain/Loss on Exchange RateN
62        PIPhysical InventoryN
63        PKAutomated CheckN
64        PLVoucher LoggingN
65        PMManual VoucherN
66        PNManual CheckN
67        POVoid CheckN
68        PRRecurring VoucherN
69        PTElectronic Funds TransferN
70        PWWithholding
71        PYPayment Order - EDI Only
72        R ReceivablesN
73        R1A/R DraftsN
74        R2Contract BillingN
75        R5DeductionY
76        R6RMA - Sales OrderY
77        R7Alternate Currency ReceiptN
78        RAAdjustmentN
79        RBChargebackN
80        RCCash ReceiptsN
81        REChange to Invoice AmountN
82        RFFinance ChargeN
83        RGGain/Loss on Exchange RateN
84        RKCash Receipts CheckN
85        ROReversing or Void EntryN
86        RQChargeback Amount CreatedN
87        RRRecurring InvoiceN
88        RSSpread AdjustmentsN
89        RUUnapplied CashN
90        RVNon-sufficient FundsN
91        RWBalance ForwardN
92        RYCash Receipts - EDI Only
93        SBBlanket Sales OrderN
94        SCActual Rate ScheduleN
95        SDDirect ShipN
96        SFFree GoodsN
97        SIInterbranch SalesN
98        SQSales QuoteN
99        SSDo Not Use--Summary RecordsN
100        SYEDI Sales Order QuoteN
101        SZEDI Sales OrderN
102        TMEnterprise Treasury ManagementY