JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

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

JDE Ref icon of database logic symbolJDE TABLESv3Made in Britain

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

920: Top 10 requests

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

910: Top 10 requests

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

812: Top 10 requests

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

202 columns | Print definition?812 | ICU

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0011Batch Control Records2ICICUBatch NumberNumericGeneric Edit80
2F0011WF0011W - WF - Batch To Detail2ICICUBatch NumberNumericGeneric Edit80
3F0018Sales/Use/V.A.T. Tax File50TDICUBatch NumberNumericGeneric Edit80
4F0911Account Ledger8GLICUBatch NumberNumericGeneric Edit80
TOP03: Accounts Receivable
5F0311Accounts Receivable Ledger17RPICUBatch NumberNumericGeneric Edit80
6F0312A/R Batch Cash Application2RUICUBatch NumberNumericGeneric Edit80
TOP03B: Enhanced Accounts Receivable
7F03B11Customer Ledger9RPICUBatch NumberNumericGeneric Edit80
8F03B112Invoice Revisions17RWICUBatch NumberNumericGeneric Edit80
9F03B112PInvoice Revisions Purge File17RWICUBatch NumberNumericGeneric Edit80
10F03B11PCustomer Ledger Purge File9RPICUBatch NumberNumericGeneric Edit80
11F03B11Z1Invoice Transactions - Batch File27VJICUBatch NumberNumericGeneric Edit80
12F03B11Z2F03B11 Interoperability Table22SYICUBatch NumberNumericGeneric Edit80
13F03B13Receipts Header File19RYICUBatch NumberNumericGeneric Edit80
14F03B13PReceipts Header Purge File19RYICUBatch NumberNumericGeneric Edit80
15F03B13Z1Electronic Receipts Input5RUICUBatch NumberNumericGeneric Edit80
16F03B13Z2F03B13 Interoperability Table32SYICUBatch NumberNumericGeneric Edit80
17F03B14A/R Check Detail File20RZICUBatch NumberNumericGeneric Edit80
18F03B14PReceipts Detail Purge File20RZICUBatch NumberNumericGeneric Edit80
19F03B14Z2F03B14 Interoperability Table33SZICUBatch NumberNumericGeneric Edit80
20F03B571Auto Debit Batch Control7RCICUBatch NumberNumericGeneric Edit80
21F03B575Auto Debit Invoice Select and Build12RDICUBatch NumberNumericGeneric Edit80
22F03B672Draft Remittance Work File - One World Only22RDICUBatch NumberNumericGeneric Edit80
23F03BUI05Auto Receipts Batch Workfile4R5ICUBatch NumberNumericGeneric Edit80
24F09UI011Receipt Prepost Work File5GLICUBatch NumberNumericGeneric Edit80
TOP04: Accounts Payable
25F0411Accounts Payable Ledger19RPICUBatch NumberNumericGeneric Edit80
26F0411AWF - As Of - Accounts Payable Ledger19RPICUBatch NumberNumericGeneric Edit80
27F0411PPurge - Accounts Payable Ledger19RPICUBatch NumberNumericGeneric Edit80
28F0411Z1Voucher Transactions - Batch File37VLICUBatch NumberNumericGeneric Edit80
29F0411Z3F0411 Interoperability Table41SZICUBatch NumberNumericGeneric Edit80
30F0413Accounts Payable - Matching Document8RMICUBatch NumberNumericGeneric Edit80
31F0413AWF - As Of - Accounts Payable Payment Register8RMICUBatch NumberNumericGeneric Edit80
32F0413PPurge - Accounts Payable Matching Documents8RMICUBatch NumberNumericGeneric Edit80
33F0413Z1F0413 Interoperability Table22SYICUBatch NumberNumericGeneric Edit80
34F09UI005Tax Offsets User Index5GLICUBatch NumberNumericGeneric Edit80
35F09UI006Tax (F0018) Replica50TDICUBatch NumberNumericGeneric Edit80
TOP05T: Time Entry
36F06116Employee Transaction Detail File93YTICUBatch NumberNumericGeneric Edit80
37F06116Z1Employee Transactions - Batch File107VLICUBatch NumberNumericGeneric Edit80
38F06241Burden Distribution File18J#ICUBatch NumberNumericGeneric Edit80
39F06278Retro Timecard Detail File93YTICUBatch NumberNumericGeneric Edit80
40F063951Payroll Journal (Compressed) File35GLICUBatch NumberNumericGeneric Edit80
41F069136Tip Disbursement22JEICUBatch NumberNumericGeneric Edit80
TOP06: Payroll (old) - Obsolete-do not reuse
42F06210Payroll Cycle Parameters47YDICUBatch NumberNumericGeneric Edit80
TOP07: Payroll
43F05290WF - Payroll Journal (Detail)35JRICUBatch NumberNumericGeneric Edit80
44F06053Interim Check Parameters File27YWICUBatch NumberNumericGeneric Edit80
45F06156Pay Check History Summary18YUICUBatch NumberNumericGeneric Edit80
46F06270Retro Processing Parameter56JPICUBatch NumberNumericGeneric Edit80
47F06350IWF - Paycheck (Interims)48Y4ICUBatch NumberNumericGeneric Edit80
48F06490Payroll/Accounts Payable Ledger Detail2JRICUBatch NumberNumericGeneric Edit80
49F06491Payroll/Accounts Payable Ledger Detail2J6ICUBatch NumberNumericGeneric Edit80
50F06492Payroll - Accounts Payable Control2JCICUBatch NumberNumericGeneric Edit80
51F07210Pay Cycle Parameters File67YDICUBatch NumberNumericGeneric Edit80
52F074001New Hire Reporting Workfile - OneWorld Only105NHICUBatch NumberNumericGeneric Edit80
53F07490Payroll - Accounts Payable Detail (One World)2JRICUBatch NumberNumericGeneric Edit80
54F07491Payroll - Accounts Payable Summary File2J6ICUBatch NumberNumericGeneric Edit80
55F07492Payroll - Accounts Payable Control File2JCICUBatch NumberNumericGeneric Edit80
TOP08B: Benefits Administration
56F08371Reimbursement Spending Account Claims File32B6ICUBatch NumberNumericGeneric Edit80
TOP09: General Accounting
57F0911PPurge - Account Ledger8GLICUBatch NumberNumericGeneric Edit80
58F0911RWF - Acct Ledger File for Reconciliation8GLICUBatch NumberNumericGeneric Edit80
59F0911Z1Journal Entry Transactions - Batch File25VNICUBatch NumberNumericGeneric Edit80
60F0911Z4F0911 Interoperability Table30SZICUBatch NumberNumericGeneric Edit80
61F0916Bank Statement Header15GHICUBatch NumberNumericGeneric Edit80
62F09616Auto Bank Statement Header14GNICUBatch NumberNumericGeneric Edit80
63F09UI004Variable Numerator Allocations work file1R#ICUBatch NumberNumericGeneric Edit80
64F09UI007Match Bank Tape to Recon File - ONE WORLD ONLY12GLICUBatch NumberNumericGeneric Edit80
65F09UI013Company by Batch Out of Balance2GLICUBatch NumberNumericGeneric Edit80
66F09UI015Indexed Computations Multi-Tiered Entries8GLICUBatch NumberNumericGeneric Edit80
67F09UI618Auto Bank Statement Process Work Table19NBICUBatch NumberNumericGeneric Edit80
68F70UI001Work File for G/L by Cat. Code Localization21WAICUBatch NumberNumericGeneric Edit80
69F740911Work File for G/L Report by Category Code Localization25WAICUBatch NumberNumericGeneric Edit80
TOP11C: Cash Basis
70F11CUI01A/R Cash Basis Work File2CBICUBatch NumberNumericGeneric Edit80
71F11CUI02A/P Cash Basis Work File2CBICUBatch NumberNumericGeneric Edit80
TOP13: Plant/Equipment Management
72F1304Equipment Location Billing3FNICUBatch NumberNumericGeneric Edit80
TOP15: Property Management
73F1502WABRent Increase Amounts1NFICUBatch NumberNumericGeneric Edit80
74F1502WBEstimated EP Recurring Billing Work File (OneWorld)1N4ICUBatch NumberNumericGeneric Edit80
75F1505HRevenue Fee Generation History1OKICUBatch NumberNumericGeneric Edit80
76F1505HBRevenue Fee Generation History1OKICUBatch NumberNumericGeneric Edit80
77F1511Tenant/Lease Billings Detail2NJICUBatch NumberNumericGeneric Edit80
78F15110BExpense Participation Class Account1OBICUBatch NumberNumericGeneric Edit80
79F1511BTenant/Lease Billings Detail Master2NJICUBatch NumberNumericGeneric Edit80
80F1511B1Billings Detail Batch Summary3NWICUBatch NumberNumericGeneric Edit80
81F1511HTenant/Lease Billings Detail History2N#ICUBatch NumberNumericGeneric Edit80
82F1511HBTenant/Lease Billings Detail History2NCICUBatch NumberNumericGeneric Edit80
83F1513FASB 13 Lease Control File6O3ICUBatch NumberNumericGeneric Edit80
84F1513BFASB 13 Lease Control File6O3ICUBatch NumberNumericGeneric Edit80
85F151991G/L Transaction A/R Application Work File1NBICUBatch NumberNumericGeneric Edit80
86F15199WG/L Transaction Summarization Work File1NBICUBatch NumberNumericGeneric Edit80
87F1532BExpense Participation Audit File5NTICUBatch NumberNumericGeneric Edit80
88F1538WF - Expence Participation Register5NZICUBatch NumberNumericGeneric Edit80
89F1538BEP Billing Register Work File6NZICUBatch NumberNumericGeneric Edit80
90F1540Sales Report Control File11NRICUBatch NumberNumericGeneric Edit80
91F1540BSales Report Control File21NRICUBatch NumberNumericGeneric Edit80
92F1548Escalation Billing Register5N1ICUBatch NumberNumericGeneric Edit80
93F1548BEscalation Billing Register6N1ICUBatch NumberNumericGeneric Edit80
TOP18: Resource Scheduling
94F186205Temp Cached Employees1TCICUBatch NumberNumericGeneric Edit80
95F186602Labor Rules Tag File101TFICUBatch NumberNumericGeneric Edit80
TOP31: Shop Floor Control
96F3106W.O. Cross Reference File5SDICUBatch NumberNumericGeneric Edit80
97F3108Summarized WO Cross-Reference3SJICUBatch NumberNumericGeneric Edit80
98F31122Work Order Time Transactions15WTICUBatch NumberNumericGeneric Edit80
99F31122SPurge Work Order Time Transactions15WTICUBatch NumberNumericGeneric Edit80
100F31122Z1Work Order Time Transactions Unedited Transaction Table28SZICUBatch NumberNumericGeneric Edit80
101F31UI804Exception Report Work FIle14WRICUBatch NumberNumericGeneric Edit80
TOP38: Agreement Management
102F38111Agreements Transaction Ledger56DZICUBatch NumberNumericGeneric Edit80
TOP39: Advanced Stock Valuation
103F3910G/L Adjustment Table17SCICUBatch NumberNumericGeneric Edit80
TOP41: Inventory Management
104F4111Item Ledger File26ILICUBatch NumberNumericGeneric Edit80
105F41UI001Inventory Transactions Detail File10ITICUBatch NumberNumericGeneric Edit80
TOP41B: Bulk Stock Management
106F41511Bulk Product Transaction File12PAICUBatch NumberNumericGeneric Edit80
TOP42: Sales Management
107F42800GSales Update G Batch Workfile3SGICUBatch NumberNumericGeneric Edit80
TOP43: Procurement
108F43092ZReceipt Routing Work File16PVICUBatch NumberNumericGeneric Edit80
TOP43S: Supplier Self Service
109F4313POFLIP23PFICUBatch NumberNumericGeneric Edit80
TOP45: Advanced Pricing
110F4575Ship and Debit History41AHICUBatch NumberNumericGeneric Edit80
111F4575TMPShip and Debit History - Temp Table41AHICUBatch NumberNumericGeneric Edit80
112F4576Ship and Debit Claims54ACICUBatch NumberNumericGeneric Edit80
113F4576TMPShip and Debit Claims- Temp Table54ACICUBatch NumberNumericGeneric Edit80
114F4576Z1Ship and Debit Claims Unedited Transaction Table85Z1ICUBatch NumberNumericGeneric Edit80
TOP47: Electronic Commerce
115F47056EDI Payment Order Header - Outbound15D1ICUBatch NumberNumericGeneric Edit80
116F470561EDI Payment Order Bank N and A - Outbound9D2ICUBatch NumberNumericGeneric Edit80
117F470561WEDI Payment Order Bank N and A - Work9D2ICUBatch NumberNumericGeneric Edit80
118F470562EDI Payment Order Vendor N and A - Outbound9D4ICUBatch NumberNumericGeneric Edit80
119F470562WEDI Payment Order Vendor N and A - Work9D4ICUBatch NumberNumericGeneric Edit80
120F470563EDI Payment Order Payee N and A - Outbound9D5ICUBatch NumberNumericGeneric Edit80
121F470563WEDI Payment Order Payee N and A - Work9D5ICUBatch NumberNumericGeneric Edit80
122F47056WEDI Payment Order Header - Work15D1ICUBatch NumberNumericGeneric Edit80
123F47057EDI Payment Order Remittance Advice - Outbound15D3ICUBatch NumberNumericGeneric Edit80
124F47057WEDI Payment Order Remittance Advice - Work15D3ICUBatch NumberNumericGeneric Edit80
125F47112EDI Lockbox Header - Transaction24Z2ICUBatch NumberNumericGeneric Edit80
126F47113EDI Lockbox/Payment Detail - Batch27Z3ICUBatch NumberNumericGeneric Edit80
127F47122EDI Product Activity Data Detail - Inbound54MJICUBatch NumberNumericGeneric Edit80
128F47127EDI Product Activity Data Detail - Outbound54MJICUBatch NumberNumericGeneric Edit80
TOP48S: Service Billing
129F48011Service Billing Batch Control1WGICUBatch NumberNumericGeneric Edit80
130F4812Billing Detail Workfile123WDICUBatch NumberNumericGeneric Edit80
131F4812GRetro Adjustment Workfile13WDICUBatch NumberNumericGeneric Edit80
132F4812HBilling Workfile - History123WDICUBatch NumberNumericGeneric Edit80
133F4812HSBilling Workfile History Purged Save123WDICUBatch NumberNumericGeneric Edit80
134F4822Invoice Summary Work File27W4ICUBatch NumberNumericGeneric Edit80
135F48221Service Billing Retention Release Cross Reference File1WHICUBatch NumberNumericGeneric Edit80
136F48229Delete Invoices Audit Table4W8ICUBatch NumberNumericGeneric Edit80
137F4823Voucher Summary25W0ICUBatch NumberNumericGeneric Edit80
138F48S002Draft and Final Cross Reference Work File1WMICUBatch NumberNumericGeneric Edit80
139F48S411CSB Pay When Paid Table16BZICUBatch NumberNumericGeneric Edit80
140F48S910Billing Detail Journal File1W2ICUBatch NumberNumericGeneric Edit80
141F48S911Compressed Journal File1W3ICUBatch NumberNumericGeneric Edit80
142F48S912G/L Link File2W6ICUBatch NumberNumericGeneric Edit80
143F48SUI01Billing Detail Print Workfile123WDICUBatch NumberNumericGeneric Edit80
TOP49: Transportation Management
144F49631Load In-transit Ledger22TOICUBatch NumberNumericGeneric Edit80
TOP51: Job Costing
145F51911Draw Reporting Master15GKICUBatch NumberNumericGeneric Edit80
TOP52: Contract Billing
146F5201Contract Master File4G4ICUBatch NumberNumericGeneric Edit80
147F5216Milestone/Progress Billing Information24A6ICUBatch NumberNumericGeneric Edit80
148F52161Mileston/Progress Billing Line Cross Reference Details11A7ICUBatch NumberNumericGeneric Edit80
149F5280WContract Revenue Summary Work File32GYICUBatch NumberNumericGeneric Edit80
TOP55: Reserved for Clients
150F55ARAP1ARandAP TEMP TABLE15ARICUBatch NumberNumericGeneric Edit80
151F55IF311As Of93RPICUBatch NumberNumericGeneric Edit80
152F55IFSCHCust / Supp Balance Workfile - Copia estesa di F7441225RPICUBatch NumberNumericGeneric Edit80
153F59BO001Cash Journal Master File9CJICUBatch NumberNumericGeneric Edit80
154F59PO001Cash Journal Master File9CJICUBatch NumberNumericGeneric Edit80
155F74T101Check History Table11CHICUBatch NumberNumericGeneric Edit80
156F74U0141ACM - Application / Certificate Master34ACICUBatch NumberNumericGeneric Edit80
157F74T550General Ledger Work File - Turkish21DKICUBatch NumberNumericGeneric Edit80
158F59BN01Garanti Bankasi Cek/Senet Entegrasyon Tablosu35BNICUBatch NumberNumericGeneric Edit80
TOP74: EMEA Localization
159F74030HADutch-Next Batch Number and Sequence Number2STICUBatch NumberNumericGeneric Edit80
160F74093Workfile for Printing IVA Summary - Italy49HCICUBatch NumberNumericGeneric Edit80
161F74900Foreign Receivables and Payables - EMEA15RPICUBatch NumberNumericGeneric Edit80
162F74S55Expenses and Exchange Rate for Payments - Spain6Q5ICUBatch NumberNumericGeneric Edit80
TOP74P: Poland
163F74P9100Cash Desk Transaction - POL - 74P14CDICUBatch NumberNumericGeneric Edit80
TOP74R: CIS
164F74R0011Batch Tag File - RUS - 09 - 74R2ICICUBatch NumberNumericGeneric Edit80
165F74R0100Petty Cash Transactions - RUS - 00 - 74R15PCICUBatch NumberNumericGeneric Edit80
166F74R9011Correspondence Rules - RUS -09 - 74R17CRICUBatch NumberNumericGeneric Edit80
TOP74Y: Italy - Reporting System Only
167F743B14ISuspended IVA Generation - Receipt/Rebate Control-Italy7TIICUBatch NumberNumericGeneric Edit80
TOP75A: Australia - Reporting System Only
168F75A0010Australian Employee Termination Details82A0ICUBatch NumberNumericGeneric Edit80
169F75A0140Australian Group Certificates4ZGICUBatch NumberNumericGeneric Edit80
170F75A0145Group Certificate ATO file build work file1ZZICUBatch NumberNumericGeneric Edit80
TOP75C: China - Reporting System Only
171F75C4203Chinese VAT on Free Goods Cross Reference - China9FCICUBatch NumberNumericGeneric Edit80
TOP76A: Argentina
172F76A392Calculated costs header - 76A6C2ICUBatch NumberNumericGeneric Edit80
173F76A41CERG G/L - Lot Detail - ARG - 09 - - 091LDICUBatch NumberNumericGeneric Edit80
174F76A4111Item Ledger Tag File - ARG - 76A3ILICUBatch NumberNumericGeneric Edit80
175F76AUI81Draft - Invoices Work File - ARG - 03B - 76A24WFICUBatch NumberNumericGeneric Edit80
176F76AUI82Draft - Drafts Work File - ARG - 03B - 03B27WFICUBatch NumberNumericGeneric Edit80
177F76AUI83Draft - Application Drafts - Invoices Work File - ARG - 76A36WFICUBatch NumberNumericGeneric Edit80
TOP76B: Brazil - Reporting System Only
178F76B10Account Ledger - IN68 - 0919ARICUBatch NumberNumericGeneric Edit80
179F76B20Account Payable and Receivable Table - IN68 - 03B15PRICUBatch NumberNumericGeneric Edit80
180F76B8602IN86-Work Table for Suppliers and Customers - 0415PRICUBatch NumberNumericGeneric Edit80
181F76B911IN86-Work Table for Journal Entries - 0911BDICUBatch NumberNumericGeneric Edit80
TOP76C: Colombia
182F76C031AA/R Customer ledger As Of - F76C031A - COL - 049RPICUBatch NumberNumericGeneric Edit80
183F76C034AA/R Check Detail file As Of - COL - 76C20RZICUBatch NumberNumericGeneric Edit80
184F76C575Work File Magnetic Media - COL - 041Q1ICUBatch NumberNumericGeneric Edit80
185F76C9415Workfile for Dialy Book - COL - 094LDICUBatch NumberNumericGeneric Edit80
186F76CT1Tributary Information - COL - 76C1TIICUBatch NumberNumericGeneric Edit80
187F76CT2Sales/Use/V.A.T. Tax File - COL - 76C8CTICUBatch NumberNumericGeneric Edit80
188F76CUI02Tax Detail - Work File - COL - 76C56TDICUBatch NumberNumericGeneric Edit80
189F76CUI04Tax Detail for Distribution - Work File - COL - 76C57TDICUBatch NumberNumericGeneric Edit80
TOP76E: Ecuador
190F76E0018Print Withholding Workfile - EC - 049TDICUBatch NumberNumericGeneric Edit80
191F76E4010Withholding Certificate Information - EC - 043CEICUBatch NumberNumericGeneric Edit80
192F76E4020Withholding Certificate Information w/ SRI - EC - 044CRICUBatch NumberNumericGeneric Edit80
TOP76H: Chile
193F76H6001Actual Cost Process Header - CHI - 41 - 76H23PHICUBatch NumberNumericGeneric Edit80
194F76H611Actual Item Ledger File - CHI - 41 - 76H27ALICUBatch NumberNumericGeneric Edit80
195F76H6201Replacement Cost Process Header - CHI - 4114RHICUBatch NumberNumericGeneric Edit80
196F76HUI32Workfile for R76H3B40 - CHI - 42 - 76H14WFICUBatch NumberNumericGeneric Edit80
TOP76M: Mexico
197F76M0314Receipt Detail Tag File - Mexico9MAICUBatch NumberNumericGeneric Edit80
198F76M0414F0414 - Payment Detail Tag File - Mexico7RTICUBatch NumberNumericGeneric Edit80
TOP89: Conversion Programs
199F05290TNeeded for upgrade from Xe to B91JRICUBatch NumberNumericGeneric Edit80
200F063951TNeeded for upgrade from Xe to B91GLICUBatch NumberNumericGeneric Edit80
TOPD3N: dcLINK (data collection) - DSI
201FD3N4116dcLINK Interface - Inventory Reclassification8IRICUBatch NumberNumericGeneric Edit80
TOPF31: Lean Transactions
202FF31201Cross Reference1CRICUBatch NumberNumericGeneric Edit80