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

422 columns | Print definition?812 | DCT | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F00021Next Numbers by Company/Fiscal Year - Automatic2NLDCTDocument TypeStringUDC20
2F00023Distributed Next Number Table5DNDCTDocument TypeStringUDC20
3F00098Enable Distributed Next Numner4EDDCTDocument TypeStringUDC20
4F0018RTax Reconciliation Repository2EDDCTDocument TypeStringUDC20
5F0911Account Ledger2GLDCTDocument TypeStringUDC20
6F0911TAccount Ledger Tag File1GLDCTDocument TypeStringUDC20
TOP03: Accounts Receivable
7F0311Accounts Receivable Ledger3RPDCTDocument TypeStringUDC20
8F0312A/R Batch Cash Application10RUDCTDocument TypeStringUDC20
TOP03B: Enhanced Accounts Receivable
9F03B11Customer Ledger2RPDCTDocument TypeStringUDC20
10F03B112Invoice Revisions2RWDCTDocument TypeStringUDC20
11F03B112PInvoice Revisions Purge File2RWDCTDocument TypeStringUDC20
12F03B11PCustomer Ledger Purge File2RPDCTDocument TypeStringUDC20
13F03B11Z1Invoice Transactions - Batch File20VJDCTDocument TypeStringUDC20
14F03B11Z2F03B11 Interoperability Table15SYDCTDocument TypeStringUDC20
15F03B13Z1Electronic Receipts Input8RUDCTDocument TypeStringUDC20
16F03B14A/R Check Detail File5RZDCTDocument TypeStringUDC20
17F03B14PReceipts Detail Purge File5RZDCTDocument TypeStringUDC20
18F03B14Z2F03B14 Interoperability Table18SZDCTDocument TypeStringUDC20
19F03B21A/R Notification History Detail6ZSDCTDocument TypeStringUDC20
20F03B22A/R Fee Journal History3RSDCTDocument TypeStringUDC20
21F03B23A/R Fee Journal History Detail4RTDCTDocument TypeStringUDC20
22F03B465A/R Netting Workfile4RODCTDocument TypeStringUDC20
23F03B575Auto Debit Invoice Select and Build5RDDCTDocument TypeStringUDC20
24F09UI011Receipt Prepost Work File2GLDCTDocument TypeStringUDC20
TOP04: Accounts Payable
25F0411Accounts Payable Ledger3RPDCTDocument TypeStringUDC20
26F0411AWF - As Of - Accounts Payable Ledger3RPDCTDocument TypeStringUDC20
27F0411PPurge - Accounts Payable Ledger3RPDCTDocument TypeStringUDC20
28F0411Z1Voucher Transactions - Batch File21VLDCTDocument TypeStringUDC20
29F0411Z3F0411 Interoperability Table25SZDCTDocument TypeStringUDC20
30F0414Accounts Payable Matching Document Detail5RNDCTDocument TypeStringUDC20
31F0414AWF - As Of - Accounts Payable Payment Detail5RNDCTDocument TypeStringUDC20
32F0414PPurge - Accounts Payable Matching Document Detail5RNDCTDocument TypeStringUDC20
33F0414Z1F0414 Interoperability Table18SZDCTDocument TypeStringUDC20
34F0450Payee Control File8PCDCTDocument TypeStringUDC20
35F04514WF - 1099 Combined Workfile (Merge of F045141 and F045143)22G1DCTDocument TypeStringUDC20
36F045141WF - 1099 G/L Workfile22G1DCTDocument TypeStringUDC20
37F045143WF - 1099 A/P WorkFile22G1DCTDocument TypeStringUDC20
38F04573A/P Payment Processing - Detail File6KIDCTDocument TypeStringUDC20
39F09UI005Tax Offsets User Index26GLDCTDocument TypeStringUDC20
TOP05T: Time Entry
40F06290Payroll Accounting Journal Work File3YRDCTDocument TypeStringUDC20
41F063951Payroll Journal (Compressed) File12GLDCTDocument TypeStringUDC20
TOP07: Payroll
42F05290WF - Payroll Journal (Detail)12JRDCTDocument TypeStringUDC20
TOP09: General Accounting
43F0911PPurge - Account Ledger2GLDCTDocument TypeStringUDC20
44F0911RWF - Acct Ledger File for Reconciliation2GLDCTDocument TypeStringUDC20
45F0911Z1Journal Entry Transactions - Batch File19VNDCTDocument TypeStringUDC20
46F0911Z4F0911 Interoperability Table24SZDCTDocument TypeStringUDC20
47F0912Cost Allocations/Flex Budgeting23RJDCTDocument TypeStringUDC20
48F0912AIndex Computation Entry File19RIDCTDocument TypeStringUDC20
49F0912BVariable Allocation File3R#DCTDocument TypeStringUDC20
50F0917Bank Statement Detail26GDDCTDocument TypeStringUDC20
51F09521Cash Type Rules13FRDCTDocument TypeStringUDC20
52F09617Auto Bank Statement Detail29GMDCTDocument TypeStringUDC20
53F09UI004Variable Numerator Allocations work file6R#DCTDocument TypeStringUDC20
54F09UI015Indexed Computations Multi-Tiered Entries2GLDCTDocument TypeStringUDC20
55F70UI001Work File for G/L by Cat. Code Localization5WADCTDocument TypeStringUDC20
56F740911Work File for G/L Report by Category Code Localization8WADCTDocument TypeStringUDC20
TOP12: Fixed Assets
57F12911ERPost G/L to FA Exceptions Work File1GLDCTDocument TypeStringUDC20
TOP13E: Equipment Cost Analysis
58F1385Equipment Analysis Rules7ERDCTDocument TypeStringUDC20
TOP15: Property Management
59F151991G/L Transaction A/R Application Work File3NBDCTDocument TypeStringUDC20
60F1532BExpense Participation Audit File1NTDCTDocument TypeStringUDC20
TOP17: Customer Service Management
61F1793CSMS Line Type Constants40LFDCTDocument TypeStringUDC20
62F3111Z2Warranty Claim/Supplier Recovery processing63WPDCTDocument TypeStringUDC20
63F3112Z2Warranty Claim/Supplier Recovery processing80WLDCTDocument TypeStringUDC20
64F4801TZ2Warranty Claim/Supplier Recovery processing130WQDCTDocument TypeStringUDC20
65F4801Z2Warranty Claim/Supplier Recovery processing113WSDCTDocument TypeStringUDC20
TOP17C: Call Management
66F17111Base Warranty Defaults8BCDCTDocument TypeStringUDC20
67F1755Customer Call Master85ZADCTDocument TypeStringUDC20
TOP31: Shop Floor Control
68F3105Work Order LSN2ISDCTDocument TypeStringUDC20
69F3105SPurge Work Order LSN2ISDCTDocument TypeStringUDC20
70F3106W.O. Cross Reference File3SDDCTDocument TypeStringUDC20
71F3111Work Order Parts List50WMDCTDocument TypeStringUDC20
72F3111SPurge - Shop Floor Parts List50WMDCTDocument TypeStringUDC20
73F3111Z1Outbound Work Order Parts List63SZDCTDocument TypeStringUDC20
74F3112Work Order Routing68WLDCTDocument TypeStringUDC20
75F31122Work Order Time Transactions16WTDCTDocument TypeStringUDC20
76F31122SPurge Work Order Time Transactions16WTDCTDocument TypeStringUDC20
77F31122Z1Work Order Time Transactions Unedited Transaction Table29SZDCTDocument TypeStringUDC20
78F3112SPurge Shop Floor Control Routing Instructions68WLDCTDocument TypeStringUDC20
79F3112Z1Outbound Work Order Routings80SZDCTDocument TypeStringUDC20
80F31UI802Accumulate Amounts by Account1WGDCTDocument TypeStringUDC20
81F31UI803Work File for Summarizing Journal Entries1SGDCTDocument TypeStringUDC20
82F31UI804Exception Report Work FIle4WRDCTDocument TypeStringUDC20
83F4801SPurge - Work Order Master file94WADCTDocument TypeStringUDC20
84F4801Z1Outbound Work Order Header113SYDCTDocument TypeStringUDC20
TOP31B: Blend Management
85F31B14WIM Constants22MCDCTDocument TypeStringUDC20
86F31B14TWIM Constants Tag Table2MCDCTDocument TypeStringUDC20
87F31B66Blend Transactions13BTDCTDocument TypeStringUDC20
88F31B73Base Operation Configuration.45BCDCTDocument TypeStringUDC20
89F31B75Operation Configuration81OCDCTDocument TypeStringUDC20
90F31BAAIBlend Automatic Accounting Instructions3BLDCTDocument TypeStringUDC20
TOP34: Requirements Planning
91F4321Supplier Schedule Master File22PBDCTDocument TypeStringUDC20
TOP37: Quality Management
92F3703Non-Conforming Material15QEDCTDocument TypeStringUDC20
TOP38: Agreement Management
93F38111Agreements Transaction Ledger14DZDCTDocument TypeStringUDC20
TOP39: Advanced Stock Valuation
94F39064Valuation Document Summary Table4DSDCTDocument TypeStringUDC20
95F390649Historical Valuation Document Summary Table4DSDCTDocument TypeStringUDC20
96F3910G/L Adjustment Table13SCDCTDocument TypeStringUDC20
97F39120Temporary Period Build File for Stock Valuation6TFDCTDocument TypeStringUDC20
98F39120WPeriod Detail Work File4TWDCTDocument TypeStringUDC20
TOP40: Inventory/OP Base
99F30UI006Lot Tracking Work File15ILDCTDocument TypeStringUDC20
100F40039Document Type Master1DTDCTDocument TypeStringUDC20
101F40051Return Material Authorization15RDDCTDocument TypeStringUDC20
102F4011ZBatch Receiver File - Order Details117SZDCTDocument TypeStringUDC20
103F4080Related Order Cross Reference Table14RODCTDocument TypeStringUDC20
104F4095Distribution/Manufacturing - AAI Values4MLDCTDocument TypeStringUDC20
105F40UI801Generic Error Table11ZBDCTDocument TypeStringUDC20
106F41112Item ASOF File1INDCTDocument TypeStringUDC20
107F4211Z1Sales Order Detail Unedited Transaction File111SZDCTDocument TypeStringUDC20
108F4217Shipment Reference Numbers7XIDCTDocument TypeStringUDC20
109F49190Document Definition File (Conversion from World File)2DSDCTDocument TypeStringUDC20
110F49211Sales Order Detail File - Tag File57UDDCTDocument TypeStringUDC20
111F49211Z1Sales Order Detail Tag Unedited Transaction File70S1DCTDocument TypeStringUDC20
112F49219Sales Order Detail - Tag History File57UDDCTDocument TypeStringUDC20
TOP41: Inventory Management
113F400391Document Type Exclusion Rules1DEDCTDocument TypeStringUDC20
114F41006Transaction Type Document Family File2IKDCTDocument TypeStringUDC20
115F4101AItem File6IMDCTDocument TypeStringUDC20
116F4101BItem Master Bulk Data6IMDCTDocument TypeStringUDC20
117F4101CItem Category Codes6IMDCTDocument TypeStringUDC20
118F4101FItem Customer Service Data6IMDCTDocument TypeStringUDC20
119F4101GItem Branch Quantities6IBDCTDocument TypeStringUDC20
120F4101MItem Manufacturing Data6IMDCTDocument TypeStringUDC20
121F4101PItem Master Packaging6IMDCTDocument TypeStringUDC20
122F4101SItem Master Shipping Data6IMDCTDocument TypeStringUDC20
123F4101WItem Profile Data6IMDCTDocument TypeStringUDC20
124F4101Z1F4101 Item Master Unedited Transaction Table195SZDCTDocument TypeStringUDC20
125F4101Z1AF4101 Detail Item Master Unedited Transaction115SZDCTDocument TypeStringUDC20
126F4111Item Ledger File23ILDCTDocument TypeStringUDC20
127F41131Stranded Hard Commitments Table14IUDCTDocument TypeStringUDC20
128F41UI001Inventory Transactions Detail File7ITDCTDocument TypeStringUDC20
TOP41B: Bulk Stock Management
129F41511Bulk Product Transaction File2PADCTDocument TypeStringUDC20
130F41512Gain/Loss Transactions File5PTDCTDocument TypeStringUDC20
TOP42: Sales Management
131F4211Sales Order Detail File98SDDCTDocument TypeStringUDC20
132F42119Sales Order History File98SDDCTDocument TypeStringUDC20
133F42199S.O. Detail Ledger File98SLDCTDocument TypeStringUDC20
134F42565Invoice Print File4IWDCTDocument TypeStringUDC20
135F42800GSales Update G Batch Workfile12SGDCTDocument TypeStringUDC20
136F42UI12Sales Order Detail Cache 2 (MBF)34ZDDCTDocument TypeStringUDC20
137F42UI800Sales Detail Work File - Sales Update9SDDCTDocument TypeStringUDC20
TOP42B: Sales Order Entry
138F49299S.O. Detail Tag Ledger File57UDDCTDocument TypeStringUDC20
TOP43: Procurement
139F4095TEMF4095 Temporary Table4MLDCTDocument TypeStringUDC20
140F43099Receipt Routing Ledger File26PODCTDocument TypeStringUDC20
141F43121Purchase Order Receiver File57PRDCTDocument TypeStringUDC20
142F43121TPurchase Order Receiver Tag File8PRDCTDocument TypeStringUDC20
143F43121Z1Receipts Unedited Transaction Table74SZDCTDocument TypeStringUDC20
144F4314ZVoucher Match Selection File157PNDCTDocument TypeStringUDC20
TOP43A: Purchase Order Receipt/Routing
145F43126Purchase Order Receiver Multiple Account23P4DCTDocument TypeStringUDC20
146F43126TPurchase Order Receiver Multiple Account Tag File10P4DCTDocument TypeStringUDC20
TOP43E: Requisition Self Service
147F43E121eRequisition Receiver file7ERDCTDocument TypeStringUDC20
TOP43S: Supplier Self Service
148F4313POFLIP21PFDCTDocument TypeStringUDC20
TOP44H: Homebuilder Management
149F44H711PAfter Start Purchasing2TPDCTDocument TypeStringUDC20
TOP45: Advanced Pricing
150F4576Ship and Debit Claims32ACDCTDocument TypeStringUDC20
151F4576TMPShip and Debit Claims- Temp Table32ACDCTDocument TypeStringUDC20
152F4576Z1Ship and Debit Claims Unedited Transaction Table45Z1DCTDocument TypeStringUDC20
TOP47: Electronic Commerce
153F47012EDI Purchase Order Detail - Inbound118SZDCTDocument TypeStringUDC20
154F47027EDI P.O. Acknowledgment Detail - Outbound118SZDCTDocument TypeStringUDC20
155F47037EDI Shipping Notice Detail - Outbound108SZDCTDocument TypeStringUDC20
156F470371EDI Shipping Notice Detail - Outbound124SZDCTDocument TypeStringUDC20
157F470461EDI Invoice Additional Header - Outbound11S3DCTDocument TypeStringUDC20
158F47047EDI Invoice Detail (Sales) - Outbound118SZDCTDocument TypeStringUDC20
159F470471EDI Invoice Additional Detail - Outbound11S4DCTDocument TypeStringUDC20
160F47057EDI Payment Order Remittance Advice - Outbound33D3DCTDocument TypeStringUDC20
161F47057WEDI Payment Order Remittance Advice - Work33D3DCTDocument TypeStringUDC20
162F47092EDI Request for Quote Detail - Inbound118SZDCTDocument TypeStringUDC20
163F471061EDI Response to RFQ Additional Header - Outbound11S3DCTDocument TypeStringUDC20
164F47107EDI Response to RFQ Detail - Outbound118SZDCTDocument TypeStringUDC20
165F471071EDI Response to RFQ Additional Detail - Outbound11S4DCTDocument TypeStringUDC20
166F47114EDI Lockbox/Payment Detail - Payment16Z4DCTDocument TypeStringUDC20
167F47122EDI Product Activity Data Detail - Inbound51MJDCTDocument TypeStringUDC20
168F47127EDI Product Activity Data Detail - Outbound51MJDCTDocument TypeStringUDC20
169F47132EDI Purchase Order Change Detail - Inbound119SZDCTDocument TypeStringUDC20
170F47147EDI P.O. Change Acknowledgment Detail - Outbound120SZDCTDocument TypeStringUDC20
TOP48: Work Order Processing
171F4801Work Order Master File94WADCTDocument TypeStringUDC20
172F4801STPurge - Work Order Master Tag File117WADCTDocument TypeStringUDC20
173F4801TWork Order Master Tag File117WADCTDocument TypeStringUDC20
174F4817Service Order Extension23SRDCTDocument TypeStringUDC20
175F48UI001X4801 Master Business Function Workfile97WADCTDocument TypeStringUDC20
TOP48S: Service Billing
176F4812Billing Detail Workfile1WDDCTDocument TypeStringUDC20
177F4812HBilling Workfile - History1WDDCTDocument TypeStringUDC20
178F4812HSBilling Workfile History Purged Save1WDDCTDocument TypeStringUDC20
179F48221Service Billing Retention Release Cross Reference File9WHDCTDocument TypeStringUDC20
180F48S001Draft and Final Invoice Document2WLDCTDocument TypeStringUDC20
181F48S002Draft and Final Cross Reference Work File6WMDCTDocument TypeStringUDC20
182F48S411CSB Pay When Paid Table10BZDCTDocument TypeStringUDC20
183F48S910Billing Detail Journal File12W2DCTDocument TypeStringUDC20
184F48S911Compressed Journal File7W3DCTDocument TypeStringUDC20
185F48S912G/L Link File7W6DCTDocument TypeStringUDC20
186F48SUI01Billing Detail Print Workfile1WDDCTDocument TypeStringUDC20
TOP49: Transportation Management
187F49110Transportation Bill of Lading Workfile26BWDCTDocument TypeStringUDC20
188F49130Shipment Document Workfile30BWDCTDocument TypeStringUDC20
189F49141Packing List Workfile12PWDCTDocument TypeStringUDC20
190F49160Document Next Number4NNDCTDocument TypeStringUDC20
191F49191Document Definition2DSDCTDocument TypeStringUDC20
192F49592Document Print Batch Document Header8DHDCTDocument TypeStringUDC20
193F49594Document Print - Document Detail17DIDCTDocument TypeStringUDC20
194F49595Document Print - Document Summary6DKDCTDocument TypeStringUDC20
195F49631Load In-transit Ledger2TODCTDocument TypeStringUDC20
196F49695Document Register4DRDCTDocument TypeStringUDC20
197F49696Document Register Detail4DJDCTDocument TypeStringUDC20
198F49697Document Register Summary4DNDCTDocument TypeStringUDC20
199F4981Freight Audit History47FHDCTDocument TypeStringUDC20
TOP51: Job Costing
200F51911Draw Reporting Master1GKDCTDocument TypeStringUDC20
201F51911EXDraw Explanation Table1GKDCTDocument TypeStringUDC20
TOP55: Reserved for Clients
202F74H1050Invoicing Workfile Header - New4IHDCTDocument TypeStringUDC20
203F74H1053Invoice Copies Log Table - New2ILDCTDocument TypeStringUDC20
204F74P0710Credit Order History6PLDCTDocument TypeStringUDC20
205F74Q0165WF do R74Q01653WFDCTDocument TypeStringUDC20
206F74Q0175WF dla R74Q01753WFDCTDocument TypeStringUDC20
207F74T531Customer Ledger Tranaction File11CTDCTDocument TypeStringUDC20
208F74T532Supplier Ledger Transaction File11SLDCTDocument TypeStringUDC20
209F74T550General Ledger Work File - Turkish17DKDCTDocument TypeStringUDC20
TOP74: EMEA Localization
210F0018TIntrastat Revision12TDDCTDocument TypeStringUDC20
211F7400003Legal Document Types / Document Types Relationship - COMM-002RLDCTDocument TypeStringUDC20
212F7400006Processed Documents in Legal Applications - COMM - 002PDDCTDocument TypeStringUDC20
213F7404573Detail Payment Instructions EXT. for German Payments6KIDCTDocument TypeStringUDC20
214F74091Class/Register Setup - Italy1HADCTDocument TypeStringUDC20
215F7420011Sales Order / Legal Document Relationship - COMM - 426SLDCTDocument TypeStringUDC20
216F7420015Invoices Related to Sales Order - COMM - 425SRDCTDocument TypeStringUDC20
217F7420033Sales Document Line (Print Info) - COMM - 422PIDCTDocument TypeStringUDC20
218F7420034Price Adjustment (Print Info) - COMM - 422PIDCTDocument TypeStringUDC20
219F7430010Legal Document Header - COMM - 03B2LDDCTDocument TypeStringUDC20
220F7430015Invoices Related to AR DN/CN - COMM - 03B2DRDCTDocument TypeStringUDC20
221F7430018Taxes by A/R Invoice Line - COMM - 03B2TIDCTDocument TypeStringUDC20
222F7430030Legal Document Header (Print Info) - COMM - 03B2PIDCTDocument TypeStringUDC20
223F7430031Legal Document Address (Print Info) - COMM - 03B2PIDCTDocument TypeStringUDC20
224F7430032Legal Document Detail (Print Info) - COMM - 03B2PIDCTDocument TypeStringUDC20
225F7430033A/R Document Line (Print Info) - COMM - 03B2PIDCTDocument TypeStringUDC20
226F7430034Legal Document Attachment (Print Info) - COMM - 03B2PIDCTDocument TypeStringUDC20
227F7430035Taxes by Legal Document Line - COMM - 03B2PIDCTDocument TypeStringUDC20
228F7430051Print Batch Detail - COMM - 03B6BDDCTDocument TypeStringUDC20
229F74411Withholding Tax Detail File-Italy2RSDCTDocument TypeStringUDC20
230F74412Customer / Supplier Balance Workfile (A/R and A/P)11RPDCTDocument TypeStringUDC20
231F74900Foreign Receivables and Payables - EMEA3RPDCTDocument TypeStringUDC20
TOP74B: Begium Localization
232F74B100Monthly VAT Table Belgium Localisations2BTDCTDocument TypeStringUDC20
TOP74H: Hungary
233F741201Accumulated Depreciation Asset Column Setup - HUN - 744CSDCTDocument TypeStringUDC20
234F74H1004VAT Declaration Detail3VDDCTDocument TypeStringUDC20
TOP74P: Poland
235F74P03BWA/R Trial Balance - POL - 03B - 74P2P3DCTDocument TypeStringUDC20
236F74P04WA/P Trial Balance Work Table - POL - 04 - 74P2P2DCTDocument TypeStringUDC20
237F74P3B24Processed Documents in Finance Charge Processing - POL - 03B2PDDCTDocument TypeStringUDC20
238F74P4010Poland AP Document Types - POL -04 - 74P1DTDCTDocument TypeStringUDC20
239F74P411HF0411 Header File - POL - 04 - 74P2P4DCTDocument TypeStringUDC20
240F74P9100Cash Desk Transaction - POL - 74P5CDDCTDocument TypeStringUDC20
TOP74R: CIS
241F74R0018Russian Tax File - 74R7TDDCTDocument TypeStringUDC20
242F74R0100Petty Cash Transactions - RUS - 00 - 74R6PCDCTDocument TypeStringUDC20
243F74R0480Pay Item Differences - RUS - 04 - 74R3RPDCTDocument TypeStringUDC20
244F74R3031Legal Document Address (Print Info) - RUS - 03B - 74R2PIDCTDocument TypeStringUDC20
245F74R3B14F03B14 Tag File - RUS - 03B - 74R6TFDCTDocument TypeStringUDC20
246F74R4014F0414 Tag File - RUS - 04 - 74R5TFDCTDocument TypeStringUDC20
247F74R4500Paymet Order Supplemental Data - RU - 04 - 74R3PODCTDocument TypeStringUDC20
248F74R9003Correspondence Method - RUS -09 - 74R3CMDCTDocument TypeStringUDC20
249F74R9004Correspondence Rules - RUS -09 - 74R3CRDCTDocument TypeStringUDC20
TOP74U: United Kingdom Localizations
250F74U0116F0411 CIS Tag File3TFDCTDocument TypeStringUDC20
251F74U0118Payment Voucher Status History3VHDCTDocument TypeStringUDC20
252F74U0205Payment Profile - 1518P8DCTDocument TypeStringUDC20
253F74U0212Accounting Billing Profile - 1519P8DCTDocument TypeStringUDC20
254F74U0213Weekly Accounting Profile - 1520PWDCTDocument TypeStringUDC20
255F74U4053Subcontractor Documents Detail - CIS Monthly Return - UK- 044DMDCTDocument TypeStringUDC20
TOP74W: Sweden - Reporting System Only
256F74W200A/P Payment Processing Sequence Numbers File - 74W5K0DCTDocument TypeStringUDC20
257F74W203Debit Advice Invoice File - 74W15K3DCTDocument TypeStringUDC20
TOP74Y: Italy - Reporting System Only
258F743B14ISuspended IVA Generation - Receipt/Rebate Control-Italy13TIDCTDocument TypeStringUDC20
TOP75A: Australia - Reporting System Only
259F75A0201Recipient Created Tax Invoice Tag File2TFDCTDocument TypeStringUDC20
260F75A0202GST - RCTI Adjustment Print Control Table2RADCTDocument TypeStringUDC20
261F75A200GST - Tax Invoice / Adjustment Note Tag file4TFDCTDocument TypeStringUDC20
TOP75C: China - Reporting System Only
262F75C001Chinese GUI cross reference file4CRDCTDocument TypeStringUDC20
263F75C4203Chinese VAT on Free Goods Cross Reference - China6FCDCTDocument TypeStringUDC20
TOP75J: Japan - Reporting System Only
264F750411Withholding Tax Detail Table - Japan2JXDCTDocument TypeStringUDC20
TOP75T: Taiwan
265F75T004GUI/VAT Transaction Header - 75T57THDCTDocument TypeStringUDC20
266F75T0049GUI/VAT Transaction Header History - 75T57THDCTDocument TypeStringUDC20
267F75T004PGUI/VAT Transaction Header POS - 75T57THDCTDocument TypeStringUDC20
268F75T004ZGUI/VAT Transaction Header - Work - 75T46ZHDCTDocument TypeStringUDC20
269F75T005GUI/VAT Transaction Detail - 75T25TDDCTDocument TypeStringUDC20
270F75T0059GUI/VAT Transaction Detail History - 75T25TDDCTDocument TypeStringUDC20
271F75T005PGUI/VAT Transaction Detail POS - 75T25TDDCTDocument TypeStringUDC20
272F75T005ZGUI/VAT Transaction Detail - Work - 75T31ZDDCTDocument TypeStringUDC20
TOP76A: Argentina
273F76002AJDE/D.G.I. Document Type Relation - ARG1JDDCTDocument TypeStringUDC20
274F760411AA/P Tag Ledger Tag File - ARG2B2DCTDocument TypeStringUDC20
275F760414AA/P Payment Detail Tag File - ARG - 046V1DCTDocument TypeStringUDC20
276F760473APCG Detail Information Tag File - ARG - 044E5DCTDocument TypeStringUDC20
277F7607AWithholding Exempt Percentage - ARG - 04 - 042V4DCTDocument TypeStringUDC20
278F76A0209Header and Footer Invoice/ShipmentNote History WF - ARG - 76A4HFDCTDocument TypeStringUDC20
279F76A020PHeader/Footer Inv./ShipmentNote History WF Purge - AR - 76A4HFDCTDocument TypeStringUDC20
280F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A4DLDCTDocument TypeStringUDC20
281F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A4DLDCTDocument TypeStringUDC20
282F76A08Credit Invoice Payments - ARG - 002CFDCTDocument TypeStringUDC20
283F76A09Invoice Total - ARG - 00 - 002TTDCTDocument TypeStringUDC20
284F76A09PInvoice Total Purge - ARG - 03B - 76A2TTDCTDocument TypeStringUDC20
285F76A18Taxes - Tax Amounts by Sales Order Line - ARG - 006TODCTDocument TypeStringUDC20
286F76A18PTaxes - Tax Amounts by Sales Order Line Purge - ARG - - 76A6TODCTDocument TypeStringUDC20
287F76A19Taxes - Tax Amounts by Invoice Suffix AGR2TIDCTDocument TypeStringUDC20
288F76A19PTaxes - Tax Amounts by Invoice Suffix Purge ARG - 03B - 76A2TIDCTDocument TypeStringUDC20
289F76A19Z1Taxes - Tax Amounts by Invoice Suffix - Batch Entry A - 03B20VKDCTDocument TypeStringUDC20
290F76A20Credit Invoice Constants - ARG - 03B - 76A10ICDCTDocument TypeStringUDC20
291F76A21Credit Invoice Header - F76A21 - ARG - 3B - 76A2IHDCTDocument TypeStringUDC20
292F76A21PCredit Invoice Header Purge - ARG - 03B - 76A2IHDCTDocument TypeStringUDC20
293F76A22Credit Invoice Detail - F76A22 - ARG - 03B - 76A2IDDCTDocument TypeStringUDC20
294F76A22PCredit Invoice Detail Purge - ARG - 03B - 76A2IDDCTDocument TypeStringUDC20
295F76A23Credit Invoice Withholdings - F76A23 - ARG - 03B - 76A2IWDCTDocument TypeStringUDC20
296F76A23PCredit Invoice Withholdings Purge - ARG - 03B - 76A2IWDCTDocument TypeStringUDC20
297F76A24Credit Invoice Information - Accounts Payable - ARG - - 76A1IEDCTDocument TypeStringUDC20
298F76A33Receipt Invoice - Audit Log AGR3X4DCTDocument TypeStringUDC20
299F76A392Calculated costs header - 76A7C2DCTDocument TypeStringUDC20
300F76A395AAI Document Type - Work in Progress Adjustment - 76A1AADCTDocument TypeStringUDC20
301F76A41CERG G/L - Lot Detail - ARG - 09 - - 093LDDCTDocument TypeStringUDC20
302F76A411HAP Header Tag File - ARG - 04 - 76A2B0DCTDocument TypeStringUDC20
303F76A411PPurge A/P Tag Ledger Tag - ARG - 04 - 76A2B2DCTDocument TypeStringUDC20
304F76A411QF76A411P Tag File Purge - ARG - 04 - 76A2B1DCTDocument TypeStringUDC20
305F76A411RVoucher Localization Purge Header File - ARG - 04 - 76A2B4DCTDocument TypeStringUDC20
306F76A411TF760411A A/P Tag File - ARG - 04 - 76A2B1DCTDocument TypeStringUDC20
307F76A414PPurge - A/P Payment Detail - ARG - 04 - 76A6V1DCTDocument TypeStringUDC20
308F76A50Processed Documents in Legal Applications - ARG - 00 - 76A2A1DCTDocument TypeStringUDC20
309F76A8015RG814 - Profit Withholding and Payment Order - ARG - 04 - 76A3PWDCTDocument TypeStringUDC20
310F76A8017A/P Payment Detail Aditional Tag File RG 738 - ARG - 043TFDCTDocument TypeStringUDC20
311F76A8020Gross Income Exempt Percentage - ARG - 04 - 76A2EPDCTDocument TypeStringUDC20
312F76A8081Company Relation RG 738/99 - ARG - 042CRDCTDocument TypeStringUDC20
313F76A81A/P Payment Control Group File - ARG - 04 - 76A4C5DCTDocument TypeStringUDC20
314F76A82A/P Payment Control Group File - ARG - 04 - 76A3C6DCTDocument TypeStringUDC20
315F76A8500Tag File F03B14 - ARG - 03B - 76A5TFDCTDocument TypeStringUDC20
316F76AUI04A/P Tag Legel Tax File - ARG - WF2WCDCTDocument TypeStringUDC20
317F76AUI20Header and Footer Invoice/ShipmentNote Workfile - ARG - - 004HFDCTDocument TypeStringUDC20
318F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 00 - 004DLDCTDocument TypeStringUDC20
319F76AUI22WF - Legal Reports Errors - ARG - 004WFDCTDocument TypeStringUDC20
320F76AUI23Taxes - Totals by Tax Code - ARG4TWDCTDocument TypeStringUDC20
321F76AUI24Taxes Work File - ARG - 002TIDCTDocument TypeStringUDC20
322F76AUI44CERG A/P - Work File - ARG - 04 - 045WFDCTDocument TypeStringUDC20
323F76AUI46CERG A/R -Work File - ARG - 03B - 03B5WFDCTDocument TypeStringUDC20
324F76AUI51Credit Invoice - Create PGC Error and Wrn - ARG - 04 - 76A4IKDCTDocument TypeStringUDC20
325F76AUI81Draft - Invoices Work File - ARG - 03B - 76A4WFDCTDocument TypeStringUDC20
326F76AUI83Draft - Application Drafts - Invoices Work File - ARG - 76A5WFDCTDocument TypeStringUDC20
327F76AUI88Work File Last Invoice Number by Month - ARG - 03B - 76A12LIDCTDocument TypeStringUDC20
328F76AUI89Work File to Generate ND/NC Gain/Loss - ARG - 03B - 76A6WFDCTDocument TypeStringUDC20
TOP76B: Brazil - Reporting System Only
329F7600BNota Fiscal Next Number Control - Brazil3NIDCTDocument TypeStringUDC20
330F7601BNota Fiscal Header - Brazil4FHDCTDocument TypeStringUDC20
331F7603B1A/R Additional Information - Brazil2CIDCTDocument TypeStringUDC20
332F7603B1PArchive A/R Additional Information - Brazil - 03B2BPDCTDocument TypeStringUDC20
333F76101BNota Fiscal - Header (Fiscal Books) - 426QXDCTDocument TypeStringUDC20
334F7611BNota Fiscal Detail - Brazil4FDDCTDocument TypeStringUDC20
335F76121BNota Fiscal Print Message Header - Brazil4FZDCTDocument TypeStringUDC20
336F7612BNota Fiscal Print Message - Brazil3FYDCTDocument TypeStringUDC20
337F761BAAS Fiscal file book4FBDCTDocument TypeStringUDC20
338F76B001Nota Fiscal Taxes Header - Brazil - 424THDCTDocument TypeStringUDC20
339F76B011Nota Fiscal Taxes Detail - Brazil - 424TDDCTDocument TypeStringUDC20
340F76B0411Voucher Additional Information Brazil - 043VBDCTDocument TypeStringUDC20
341F76B04BCVoucher Additional Information - Brazil - 043BCDCTDocument TypeStringUDC20
342F76B400AIN86-Work Table for Storage Control - 415SCDCTDocument TypeStringUDC20
343F76B4012Voucher Tax Processed File - BR - 042VPDCTDocument TypeStringUDC20
344F76B410CIN86-Work Table for Services Outbound Nota Fiscal Hea - 424SHDCTDocument TypeStringUDC20
345F76B410DIN86-Work Table for Merchandise Nota Fiscal Issued by - 424CHDCTDocument TypeStringUDC20
346F76B410EIN86-Work Table for Merchandise NF Issued by Supplier - 414SHDCTDocument TypeStringUDC20
347F76B410HINSS-Work Table for Services Third Party Inbound NF H - 424SIDCTDocument TypeStringUDC20
348F76B411APIS - COFINS and CSLL bellow minimum - BR - 042WMDCTDocument TypeStringUDC20
349F76B411CIN86-Work Table for Services Outbound Nota Fiscal Det - 424SDDCTDocument TypeStringUDC20
350F76B411DIN86-Work Table for Merchandise Nota Fiscal Issued by - 424CDDCTDocument TypeStringUDC20
351F76B411EIN86-Work Table for Merchandise NF Issued by Supplier - 414SDDCTDocument TypeStringUDC20
352F76B473TF04573 Brazilian Temp WH File - BR - 045W3DCTDocument TypeStringUDC20
353F76B8602IN86-Work Table for Suppliers and Customers - 0417PRDCTDocument TypeStringUDC20
354F76B911IN86-Work Table for Journal Entries - 0913BDDCTDocument TypeStringUDC20
355F76BUI01Install Process Workfile - BR - 043WFDCTDocument TypeStringUDC20
TOP76C: Colombia
356F76C031AA/R Customer ledger As Of - F76C031A - COL - 042RPDCTDocument TypeStringUDC20
357F76C034AA/R Check Detail file As Of - COL - 76C5RZDCTDocument TypeStringUDC20
358F76C0411A/P Tag File - COL - 76C3RPDCTDocument TypeStringUDC20
359F76C311TA/R Tag File - Recycle Recurring - COL - 03B - 76C2RPDCTDocument TypeStringUDC20
360F76C4011A/P Ledger Tag Table - COL - 043VCDCTDocument TypeStringUDC20
361F76C575Work File Magnetic Media - COL - 047Q1DCTDocument TypeStringUDC20
362F76C9415Workfile for Dialy Book - COL - 095LDDCTDocument TypeStringUDC20
363F76CT1Tributary Information - COL - 76C7TIDCTDocument TypeStringUDC20
364F76CUI02Tax Detail - Work File - COL - 76C3TDDCTDocument TypeStringUDC20
365F76CUI04Tax Detail for Distribution - Work File - COL - 76C3TDDCTDocument TypeStringUDC20
TOP76H: Chile
366F76H006Legal Document Type Relationship - CHI - 00 - 76H1LRDCTDocument TypeStringUDC20
367F76H211Sales Order / Legal Document Relationship - CHI - 42 - 76H6SLDCTDocument TypeStringUDC20
368F76H215NC/ND - Invoice Related - CHI - 42 - 76H5IRDCTDocument TypeStringUDC20
369F76H218Taxes by Sales Order Line - CHI - 42 - 76H6TDDCTDocument TypeStringUDC20
370F76H3B10Header Tag File F03B11 - CHI - 01 - 76H2RTDCTDocument TypeStringUDC20
371F76H3B15NC/ND - Invoice Related - CHI - 03B - 76H2IRDCTDocument TypeStringUDC20
372F76H3B31Legal Document Header (Print Info) - CHI - 03B - 76H2PIDCTDocument TypeStringUDC20
373F76H3B32Legal Document Detail (Print Info) - CHI - 03B - 76H2PIDCTDocument TypeStringUDC20
374F76H3B33Legal Document Tax (Print Info) - CHI - 03B - 76H2PIDCTDocument TypeStringUDC20
375F76H3B34Sales Document Line (Print Info) - CHI - 03B - 76H2PIDCTDocument TypeStringUDC20
376F76H3B35Price Adjustment (Print Info) - CHI - 03B - 76H2PIDCTDocument TypeStringUDC20
377F76H3B36Legal Document Attachment (Print Info) - CHI - 03B - 76H2PIDCTDocument TypeStringUDC20
378F76H3B37A/R Document Line (Print Info) - CHI - 03B - 76H2PIDCTDocument TypeStringUDC20
379F76H3B38Shipment Guide Line (Print Info) - CHI - 03B - 76H2PIDCTDocument TypeStringUDC20
380F76H3B40A/P Document Line (Print Info) - CHI - 042PIDCTDocument TypeStringUDC20
381F76H3B51Lot of Printing - Detail - CHI - 03B - 76H6LDDCTDocument TypeStringUDC20
382F76H401Documents Printed in A/P Legal Reports - CHI - 04 - 76H2DPDCTDocument TypeStringUDC20
383F76H402Chilean A/P Doc Lines Print Mark - CHI - 04 - 76H4LPDCTDocument TypeStringUDC20
384F76H6001Actual Cost Process Header - CHI - 41 - 76H19PHDCTDocument TypeStringUDC20
385F76H611Actual Item Ledger File - CHI - 41 - 76H24ALDCTDocument TypeStringUDC20
386F76H6112Actual Item ASOF File - CHI - 41 - 76H1ANDCTDocument TypeStringUDC20
387F76H6201Replacement Cost Process Header - CHI - 419RHDCTDocument TypeStringUDC20
388F76HUI31Document Related Work File - CHI - 42 - 76H4DRDCTDocument TypeStringUDC20
389F76HUI32Workfile for R76H3B40 - CHI - 42 - 76H5WFDCTDocument TypeStringUDC20
390F76HUI33Workfile for R76H3B40 - CHI - 42 - 76H5WFDCTDocument TypeStringUDC20
391F76HUI34Order Related Work File - CHI - 42 - 76H7ORDCTDocument TypeStringUDC20
392F76HUI52Document Selection Work File - CHI - 42 - 76H8DRDCTDocument TypeStringUDC20
TOP76M: Mexico
393F76M0314Receipt Detail Tag File - Mexico6MADCTDocument TypeStringUDC20
394F76M0414F0414 - Payment Detail Tag File - Mexico10RTDCTDocument TypeStringUDC20
395F76M311AR Soft Rounding VAT - Mexico2MBDCTDocument TypeStringUDC20
396F76M411Soft Rounding VAT Calculation3RSDCTDocument TypeStringUDC20
TOP76P: Peru
397F76P006Legal Document Type Relationship - PE - 00 - 76P1LRDCTDocument TypeStringUDC20
398F76P411TPeru AP Tag File - PER - 04 - 76P2T4DCTDocument TypeStringUDC20
399F76P414TF0414 Tag File - PER - 04 - 76P5P4DCTDocument TypeStringUDC20
400F76P473TF04573 Tag File - PER - 04 - 76P4K3DCTDocument TypeStringUDC20
401F76P480SPOT Voucher Information - PER - 04 - 76P2SVDCTDocument TypeStringUDC20
402F76P502Asset ledger set up - PER - 12 - 76P3ALDCTDocument TypeStringUDC20
403F76PUI45Workfile VAT Purchasing Ledger - PER - 04 - 76P5WFDCTDocument TypeStringUDC20
TOP76V: Venezuela
404F76V0401Relation Invoice/Retention Code - VEN - 76V3REDCTDocument TypeStringUDC20
405F76V4011A/P Ledger Tag File - VEN - 043TFDCTDocument TypeStringUDC20
406F76V4015Vouchers Related to Credit/Debit Notes - VEN - 042CDDCTDocument TypeStringUDC20
407F76V4581Withholding Historical File - VEN - 042HRDCTDocument TypeStringUDC20
408F76V4582Wittholding Documents Temporal - VEN - 04 - 76V2DRDCTDocument TypeStringUDC20
409F76V4583Withholdings I.S.L.R. Fee 2 - VEN - 046TDDCTDocument TypeStringUDC20
410F76VLO01Withholdings Temporal Table - VEN -04 - 76V2LODCTDocument TypeStringUDC20
411F76VLV02Temporal for receipts from F03B14 - VEN - 03B - 76V4CODCTDocument TypeStringUDC20
412F76VLVCFControl Invoice Number for Sales Register - VEN - 03B - 76V3CFDCTDocument TypeStringUDC20
413F76VTARTTemporal Table for Withholdings - VEN -04 - 76V9TRDCTDocument TypeStringUDC20
TOPD3N: dcLINK (data collection) - DSI
414FD3N161PPallet Tracking Table 41PHDCTDocument TypeStringUDC20
415FD3N4116dcLINK Interface - Inventory Reclassification32IRDCTDocument TypeStringUDC20
TOPF31: Lean Transactions
416FF31010Production Master File36EHDCTDocument TypeStringUDC20
417FF31011TransactionID Master File29EHDCTDocument TypeStringUDC20
418FF31011SPurge - TransactionID Master File29ERDCTDocument TypeStringUDC20
419FF31111Lean Transaction Parts List47PLDCTDocument TypeStringUDC20
420FF31111SPurge - Lean Transaction Parts List47PRDCTDocument TypeStringUDC20
421FF31113Lean Transaction Labor Detail17LDDCTDocument TypeStringUDC20
422FF31113SPurge - Lean Transaction Labor Detail17LRDCTDocument 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