JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

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

JDE Ref icon of database logic symbolJDE TABLESv3Made in Britain

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

920: Top 10 requests

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

910: Top 10 requests

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

812: Top 10 requests

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

163 columns | Print definition?812 | SFX

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0018RTax Reconciliation Repository7EDSFXDocument Pay ItemStringGeneric Edit30
2F0911Account Ledger41GLSFXDocument Pay ItemStringGeneric Edit30
TOP03: Accounts Receivable
3F0311Accounts Receivable Ledger5RPSFXDocument Pay ItemStringGeneric Edit30
4F0312A/R Batch Cash Application12RUSFXDocument Pay ItemStringGeneric Edit30
TOP03B: Enhanced Accounts Receivable
5F03B11Customer Ledger4RPSFXDocument Pay ItemStringGeneric Edit30
6F03B112Invoice Revisions4RWSFXDocument Pay ItemStringGeneric Edit30
7F03B112PInvoice Revisions Purge File4RWSFXDocument Pay ItemStringGeneric Edit30
8F03B11PCustomer Ledger Purge File4RPSFXDocument Pay ItemStringGeneric Edit30
9F03B11Z1Invoice Transactions - Batch File22VJSFXDocument Pay ItemStringGeneric Edit30
10F03B11Z2F03B11 Interoperability Table17SYSFXDocument Pay ItemStringGeneric Edit30
11F03B13Z1Electronic Receipts Input10RUSFXDocument Pay ItemStringGeneric Edit30
12F03B14A/R Check Detail File7RZSFXDocument Pay ItemStringGeneric Edit30
13F03B14PReceipts Detail Purge File7RZSFXDocument Pay ItemStringGeneric Edit30
14F03B14Z2F03B14 Interoperability Table20SZSFXDocument Pay ItemStringGeneric Edit30
15F03B21A/R Notification History Detail8ZSSFXDocument Pay ItemStringGeneric Edit30
16F03B22A/R Fee Journal History5RSSFXDocument Pay ItemStringGeneric Edit30
17F03B23A/R Fee Journal History Detail6RTSFXDocument Pay ItemStringGeneric Edit30
18F03B465A/R Netting Workfile6ROSFXDocument Pay ItemStringGeneric Edit30
19F03B575Auto Debit Invoice Select and Build7RDSFXDocument Pay ItemStringGeneric Edit30
TOP04: Accounts Payable
20F0411Accounts Payable Ledger4RPSFXDocument Pay ItemStringGeneric Edit30
21F0411AWF - As Of - Accounts Payable Ledger4RPSFXDocument Pay ItemStringGeneric Edit30
22F0411PPurge - Accounts Payable Ledger4RPSFXDocument Pay ItemStringGeneric Edit30
23F0411Z1Voucher Transactions - Batch File22VLSFXDocument Pay ItemStringGeneric Edit30
24F0411Z3F0411 Interoperability Table26SZSFXDocument Pay ItemStringGeneric Edit30
25F0414Accounts Payable Matching Document Detail7RNSFXDocument Pay ItemStringGeneric Edit30
26F0414AWF - As Of - Accounts Payable Payment Detail7RNSFXDocument Pay ItemStringGeneric Edit30
27F0414PPurge - Accounts Payable Matching Document Detail7RNSFXDocument Pay ItemStringGeneric Edit30
28F0414Z1F0414 Interoperability Table20SZSFXDocument Pay ItemStringGeneric Edit30
29F0450Payee Control File10PCSFXDocument Pay ItemStringGeneric Edit30
30F04573A/P Payment Processing - Detail File7KISFXDocument Pay ItemStringGeneric Edit30
TOP07: Payroll
31F06491Payroll/Accounts Payable Ledger Detail19J6SFXDocument Pay ItemStringGeneric Edit30
32F07491Payroll - Accounts Payable Summary File19J6SFXDocument Pay ItemStringGeneric Edit30
TOP09: General Accounting
33F0911PPurge - Account Ledger41GLSFXDocument Pay ItemStringGeneric Edit30
34F0911RWF - Acct Ledger File for Reconciliation38GLSFXDocument Pay ItemStringGeneric Edit30
35F0911Z1Journal Entry Transactions - Batch File58VNSFXDocument Pay ItemStringGeneric Edit30
36F0911Z4F0911 Interoperability Table63SZSFXDocument Pay ItemStringGeneric Edit30
37F0912Cost Allocations/Flex Budgeting25RJSFXDocument Pay ItemStringGeneric Edit30
38F0912AIndex Computation Entry File21RISFXDocument Pay ItemStringGeneric Edit30
39F0917Bank Statement Detail27GDSFXDocument Pay ItemStringGeneric Edit30
40F09617Auto Bank Statement Detail30GMSFXDocument Pay ItemStringGeneric Edit30
41F09UI015Indexed Computations Multi-Tiered Entries41GLSFXDocument Pay ItemStringGeneric Edit30
TOP15: Property Management
42F1511Tenant/Lease Billings Detail4NJSFXDocument Pay ItemStringGeneric Edit30
43F1511BTenant/Lease Billings Detail Master4NJSFXDocument Pay ItemStringGeneric Edit30
44F1511HTenant/Lease Billings Detail History4N#SFXDocument Pay ItemStringGeneric Edit30
45F1511HBTenant/Lease Billings Detail History4NCSFXDocument Pay ItemStringGeneric Edit30
46F151991G/L Transaction A/R Application Work File5NBSFXDocument Pay ItemStringGeneric Edit30
TOP40: Inventory/OP Base
47F40UI801Generic Error Table13ZBSFXDocument Pay ItemStringGeneric Edit30
TOP41: Inventory Management
48F4111Item Ledger File24ILSFXDocument Pay ItemStringGeneric Edit30
49F41UI001Inventory Transactions Detail File9ITSFXDocument Pay ItemStringGeneric Edit30
TOP42: Sales Management
50F42800G1Sales Update G Batch Detail Workfile30DGSFXDocument Pay ItemStringGeneric Edit30
TOP43: Procurement
51F4311ZPurchase Order Generator File202PWSFXDocument Pay ItemStringGeneric Edit30
52F43121Purchase Order Receiver File58PRSFXDocument Pay ItemStringGeneric Edit30
53F43121TPurchase Order Receiver Tag File10PRSFXDocument Pay ItemStringGeneric Edit30
54F43121Z1Receipts Unedited Transaction Table75SZSFXDocument Pay ItemStringGeneric Edit30
55F4314ZVoucher Match Selection File158PNSFXDocument Pay ItemStringGeneric Edit30
TOP43A: Purchase Order Receipt/Routing
56F43126Purchase Order Receiver Multiple Account25P4SFXDocument Pay ItemStringGeneric Edit30
57F43126TPurchase Order Receiver Multiple Account Tag File12P4SFXDocument Pay ItemStringGeneric Edit30
TOP45: Advanced Pricing
58F4576Ship and Debit Claims34ACSFXDocument Pay ItemStringGeneric Edit30
59F4576TMPShip and Debit Claims- Temp Table34ACSFXDocument Pay ItemStringGeneric Edit30
60F4576Z1Ship and Debit Claims Unedited Transaction Table47Z1SFXDocument Pay ItemStringGeneric Edit30
TOP47: Electronic Commerce
61F47057EDI Payment Order Remittance Advice - Outbound35D3SFXDocument Pay ItemStringGeneric Edit30
62F47057WEDI Payment Order Remittance Advice - Work35D3SFXDocument Pay ItemStringGeneric Edit30
63F47114EDI Lockbox/Payment Detail - Payment17Z4SFXDocument Pay ItemStringGeneric Edit30
64F47122EDI Product Activity Data Detail - Inbound52MJSFXDocument Pay ItemStringGeneric Edit30
65F47127EDI Product Activity Data Detail - Outbound52MJSFXDocument Pay ItemStringGeneric Edit30
TOP48S: Service Billing
66F4812Billing Detail Workfile130WDSFXDocument Pay ItemStringGeneric Edit30
67F4812GRetro Adjustment Workfile12WDSFXDocument Pay ItemStringGeneric Edit30
68F4812HBilling Workfile - History130WDSFXDocument Pay ItemStringGeneric Edit30
69F4812HSBilling Workfile History Purged Save130WDSFXDocument Pay ItemStringGeneric Edit30
70F4822Invoice Summary Work File31W4SFXDocument Pay ItemStringGeneric Edit30
71F48221Service Billing Retention Release Cross Reference File6WHSFXDocument Pay ItemStringGeneric Edit30
72F4823Voucher Summary29W0SFXDocument Pay ItemStringGeneric Edit30
73F48S411CSB Pay When Paid Table15BZSFXDocument Pay ItemStringGeneric Edit30
74F48S910Billing Detail Journal File14W2SFXDocument Pay ItemStringGeneric Edit30
75F48S912G/L Link File9W6SFXDocument Pay ItemStringGeneric Edit30
76F48SUI01Billing Detail Print Workfile130WDSFXDocument Pay ItemStringGeneric Edit30
TOP55: Reserved for Clients
77F55ARAP1ARandAP TEMP TABLE7ARSFXDocument Pay ItemStringGeneric Edit30
78F55IF311As Of6RPSFXDocument Pay ItemStringGeneric Edit30
79F55IFRTtabella esportazione5RTSFXDocument Pay ItemStringGeneric Edit30
80F55IFVALOutput File di R55IFVALOR24FASFXDocument Pay ItemStringGeneric Edit30
TOP74: EMEA Localization
81F7400006Processed Documents in Legal Applications - COMM - 004PDSFXDocument Pay ItemStringGeneric Edit30
82F7404573Detail Payment Instructions EXT. for German Payments7KISFXDocument Pay ItemStringGeneric Edit30
83F7430018Taxes by A/R Invoice Line - COMM - 03B4TISFXDocument Pay ItemStringGeneric Edit30
84F7430032Legal Document Detail (Print Info) - COMM - 03B10PISFXDocument Pay ItemStringGeneric Edit30
85F74411Withholding Tax Detail File-Italy4RSSFXDocument Pay ItemStringGeneric Edit30
86F74900Foreign Receivables and Payables - EMEA5RPSFXDocument Pay ItemStringGeneric Edit30
TOP74H: Hungary
87F74H1004VAT Declaration Detail4VDSFXDocument Pay ItemStringGeneric Edit30
TOP74P: Poland
88F74P03BWA/R Trial Balance - POL - 03B - 74P4P3SFXDocument Pay ItemStringGeneric Edit30
89F74P04WA/P Trial Balance Work Table - POL - 04 - 74P4P2SFXDocument Pay ItemStringGeneric Edit30
90F74P3B24Processed Documents in Finance Charge Processing - POL - 03B4PDSFXDocument Pay ItemStringGeneric Edit30
TOP74R: CIS
91F74R0018Russian Tax File - 74R8TDSFXDocument Pay ItemStringGeneric Edit30
92F74R0480Pay Item Differences - RUS - 04 - 74R4RPSFXDocument Pay ItemStringGeneric Edit30
93F74R3B14F03B14 Tag File - RUS - 03B - 74R8TFSFXDocument Pay ItemStringGeneric Edit30
94F74R4014F0414 Tag File - RUS - 04 - 74R7TFSFXDocument Pay ItemStringGeneric Edit30
TOP74U: United Kingdom Localizations
95F74U0116F0411 CIS Tag File4TFSFXDocument Pay ItemStringGeneric Edit30
96F74U0118Payment Voucher Status History4VHSFXDocument Pay ItemStringGeneric Edit30
97F74U0205Payment Profile - 1519P8SFXDocument Pay ItemStringGeneric Edit30
98F74U4053Subcontractor Documents Detail - CIS Monthly Return - UK- 046DMSFXDocument Pay ItemStringGeneric Edit30
TOP74W: Sweden - Reporting System Only
99F74W200A/P Payment Processing Sequence Numbers File - 74W7K0SFXDocument Pay ItemStringGeneric Edit30
100F74W203Debit Advice Invoice File - 74W17K3SFXDocument Pay ItemStringGeneric Edit30
TOP74Y: Italy - Reporting System Only
101F743B14ISuspended IVA Generation - Receipt/Rebate Control-Italy15TISFXDocument Pay ItemStringGeneric Edit30
TOP75A: Australia - Reporting System Only
102F75A0201Recipient Created Tax Invoice Tag File5TFSFXDocument Pay ItemStringGeneric Edit30
103F75A0202GST - RCTI Adjustment Print Control Table5RASFXDocument Pay ItemStringGeneric Edit30
104F75A200GST - Tax Invoice / Adjustment Note Tag file6TFSFXDocument Pay ItemStringGeneric Edit30
TOP75C: China - Reporting System Only
105F75C001Chinese GUI cross reference file6CRSFXDocument Pay ItemStringGeneric Edit30
TOP75J: Japan - Reporting System Only
106F750411Withholding Tax Detail Table - Japan4JXSFXDocument Pay ItemStringGeneric Edit30
TOP75T: Taiwan
107F75T005GUI/VAT Transaction Detail - 75T27TDSFXDocument Pay ItemStringGeneric Edit30
108F75T0059GUI/VAT Transaction Detail History - 75T27TDSFXDocument Pay ItemStringGeneric Edit30
109F75T005PGUI/VAT Transaction Detail POS - 75T27TDSFXDocument Pay ItemStringGeneric Edit30
110F75T005ZGUI/VAT Transaction Detail - Work - 75T33ZDSFXDocument Pay ItemStringGeneric Edit30
TOP76A: Argentina
111F760411AA/P Tag Ledger Tag File - ARG4B2SFXDocument Pay ItemStringGeneric Edit30
112F760414AA/P Payment Detail Tag File - ARG - 047V1SFXDocument Pay ItemStringGeneric Edit30
113F760473APCG Detail Information Tag File - ARG - 047E5SFXDocument Pay ItemStringGeneric Edit30
114F760499AContract Withholding - Advances - ARG -04 - 0410K8SFXDocument Pay ItemStringGeneric Edit30
115F76A19Taxes - Tax Amounts by Invoice Suffix AGR4TISFXDocument Pay ItemStringGeneric Edit30
116F76A19PTaxes - Tax Amounts by Invoice Suffix Purge ARG - 03B - 76A4TISFXDocument Pay ItemStringGeneric Edit30
117F76A19Z1Taxes - Tax Amounts by Invoice Suffix - Batch Entry A - 03B22VKSFXDocument Pay ItemStringGeneric Edit30
118F76A24Credit Invoice Information - Accounts Payable - ARG - - 76A4IESFXDocument Pay ItemStringGeneric Edit30
119F76A33Receipt Invoice - Audit Log AGR4X4SFXDocument Pay ItemStringGeneric Edit30
120F76A411PPurge A/P Tag Ledger Tag - ARG - 04 - 76A4B2SFXDocument Pay ItemStringGeneric Edit30
121F76A411QF76A411P Tag File Purge - ARG - 04 - 76A4B1SFXDocument Pay ItemStringGeneric Edit30
122F76A411TF760411A A/P Tag File - ARG - 04 - 76A4B1SFXDocument Pay ItemStringGeneric Edit30
123F76A414PPurge - A/P Payment Detail - ARG - 04 - 76A7V1SFXDocument Pay ItemStringGeneric Edit30
124F76A50Processed Documents in Legal Applications - ARG - 00 - 76A4A1SFXDocument Pay ItemStringGeneric Edit30
125F76A8017A/P Payment Detail Aditional Tag File RG 738 - ARG - 046TFSFXDocument Pay ItemStringGeneric Edit30
126F76A8500Tag File F03B14 - ARG - 03B - 76A7TFSFXDocument Pay ItemStringGeneric Edit30
127F76AUI04A/P Tag Legel Tax File - ARG - WF4WCSFXDocument Pay ItemStringGeneric Edit30
128F76AUI24Taxes Work File - ARG - 004TISFXDocument Pay ItemStringGeneric Edit30
129F76AUI51Credit Invoice - Create PGC Error and Wrn - ARG - 04 - 76A7IKSFXDocument Pay ItemStringGeneric Edit30
130F76AUI81Draft - Invoices Work File - ARG - 03B - 76A6WFSFXDocument Pay ItemStringGeneric Edit30
131F76AUI83Draft - Application Drafts - Invoices Work File - ARG - 76A7WFSFXDocument Pay ItemStringGeneric Edit30
132F76AUI89Work File to Generate ND/NC Gain/Loss - ARG - 03B - 76A8WFSFXDocument Pay ItemStringGeneric Edit30
TOP76B: Brazil - Reporting System Only
133F7603B1A/R Additional Information - Brazil4CISFXDocument Pay ItemStringGeneric Edit30
134F7603B1PArchive A/R Additional Information - Brazil - 03B4BPSFXDocument Pay ItemStringGeneric Edit30
135F76B0411Voucher Additional Information Brazil - 044VBSFXDocument Pay ItemStringGeneric Edit30
136F76B04BCVoucher Additional Information - Brazil - 044BCSFXDocument Pay ItemStringGeneric Edit30
137F76B20Account Payable and Receivable Table - IN68 - 03B10PRSFXDocument Pay ItemStringGeneric Edit30
138F76B410HINSS-Work Table for Services Third Party Inbound NF H - 4221SISFXDocument Pay ItemStringGeneric Edit30
139F76B473TF04573 Brazilian Temp WH File - BR - 047W3SFXDocument Pay ItemStringGeneric Edit30
140F76B8602IN86-Work Table for Suppliers and Customers - 0419PRSFXDocument Pay ItemStringGeneric Edit30
TOP76C: Colombia
141F76C031AA/R Customer ledger As Of - F76C031A - COL - 044RPSFXDocument Pay ItemStringGeneric Edit30
142F76C034AA/R Check Detail file As Of - COL - 76C7RZSFXDocument Pay ItemStringGeneric Edit30
143F76C0411A/P Tag File - COL - 76C4RPSFXDocument Pay ItemStringGeneric Edit30
144F76C311TA/R Tag File - Recycle Recurring - COL - 03B - 76C4RPSFXDocument Pay ItemStringGeneric Edit30
145F76C4011A/P Ledger Tag Table - COL - 044VCSFXDocument Pay ItemStringGeneric Edit30
146F76C575Work File Magnetic Media - COL - 049Q1SFXDocument Pay ItemStringGeneric Edit30
147F76CT1Tributary Information - COL - 76C9TISFXDocument Pay ItemStringGeneric Edit30
148F76CUI02Tax Detail - Work File - COL - 76C5TDSFXDocument Pay ItemStringGeneric Edit30
TOP76H: Chile
149F76H3B32Legal Document Detail (Print Info) - CHI - 03B - 76H10PISFXDocument Pay ItemStringGeneric Edit30
150F76H402Chilean A/P Doc Lines Print Mark - CHI - 04 - 76H6LPSFXDocument Pay ItemStringGeneric Edit30
151F76H611Actual Item Ledger File - CHI - 41 - 76H25ALSFXDocument Pay ItemStringGeneric Edit30
152F76HUI33Workfile for R76H3B40 - CHI - 42 - 76H7WFSFXDocument Pay ItemStringGeneric Edit30
TOP76M: Mexico
153F76M311AR Soft Rounding VAT - Mexico4MBSFXDocument Pay ItemStringGeneric Edit30
154F76M411Soft Rounding VAT Calculation4RSSFXDocument Pay ItemStringGeneric Edit30
TOP76P: Peru
155F76P411TPeru AP Tag File - PER - 04 - 76P4T4SFXDocument Pay ItemStringGeneric Edit30
156F76P414TF0414 Tag File - PER - 04 - 76P7P4SFXDocument Pay ItemStringGeneric Edit30
157F76P473TF04573 Tag File - PER - 04 - 76P7K3SFXDocument Pay ItemStringGeneric Edit30
158F76PUI45Workfile VAT Purchasing Ledger - PER - 04 - 76P7WFSFXDocument Pay ItemStringGeneric Edit30
TOP76V: Venezuela
159F76V0401Relation Invoice/Retention Code - VEN - 76V4RESFXDocument Pay ItemStringGeneric Edit30
160F76V4011A/P Ledger Tag File - VEN - 044TFSFXDocument Pay ItemStringGeneric Edit30
161F76V4581Withholding Historical File - VEN - 044HRSFXDocument Pay ItemStringGeneric Edit30
162F76V4582Wittholding Documents Temporal - VEN - 04 - 76V4DRSFXDocument Pay ItemStringGeneric Edit30
TOPD3N: dcLINK (data collection) - DSI
163FD3N911dcLINK Interface - Cache UCC128 Numbers - Table10UCSFXDocument Pay ItemStringGeneric Edit30