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

140 columns | Print definition?920 | OKCO

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0911Account Ledger46GLOKCODocument Company (Original Order)StringGeneric Edit50
TOP03: Accounts Receivable
2F0311Accounts Receivable Ledger136RPOKCODocument Company (Original Order)StringGeneric Edit50
TOP03B: Enhanced Accounts Receivable
3F03B11Customer Ledger72RPOKCODocument Company (Original Order)StringGeneric Edit50
4F03B112Invoice Revisions8RWOKCODocument Company (Original Order)StringGeneric Edit50
5F03B112PInvoice Revisions Purge File8RWOKCODocument Company (Original Order)StringGeneric Edit50
6F03B11PCustomer Ledger Purge File72RPOKCODocument Company (Original Order)StringGeneric Edit50
7F03B11Z1Batch Invoices88VJOKCODocument Company (Original Order)StringGeneric Edit50
8F03B11Z2F03B11 Interoperability Table85SYOKCODocument Company (Original Order)StringGeneric Edit50
9F03B14Receipts Detail82RZOKCODocument Company (Original Order)StringGeneric Edit50
10F03B14PReceipts Detail Purge File82RZOKCODocument Company (Original Order)StringGeneric Edit50
11F03B14Z2F03B14 Interoperability Table95SZOKCODocument Company (Original Order)StringGeneric Edit50
12F03B40A/R Deduction Management17RBOKCODocument Company (Original Order)StringGeneric Edit50
13F03B575Auto Debit Invoice Select and Build81RDOKCODocument Company (Original Order)StringGeneric Edit50
14F09UI011Receipt Prepost Work File49GLOKCODocument Company (Original Order)StringGeneric Edit50
TOP04: Accounts Payable
15F0411Accounts Payable Ledger56RPOKCODocument Company (Original Order)StringGeneric Edit50
16F0411AWF - 'As Of' Accounts Payable Ledger56RPOKCODocument Company (Original Order)StringGeneric Edit50
17F0411PPurge - Accounts Payable Ledger56RPOKCODocument Company (Original Order)StringGeneric Edit50
18F0411Z1Voucher Transactions - Batch Upload74VLOKCODocument Company (Original Order)StringGeneric Edit50
19F0411Z3F0411 Interoperability Table79SZOKCODocument Company (Original Order)StringGeneric Edit50
20F09UI005Tax Offsets User Index54GLOKCODocument Company (Original Order)StringGeneric Edit50
TOP09: General Accounting
21F0911PPurge - Account Ledger46GLOKCODocument Company (Original Order)StringGeneric Edit50
22F0911Z1Journal Entry Transactions - Batch File63VNOKCODocument Company (Original Order)StringGeneric Edit50
23F0911Z4F0911 Interoperability Table68SZOKCODocument Company (Original Order)StringGeneric Edit50
24F09UI015Indexed Computations Multi-Tiered Entries46GLOKCODocument Company (Original Order)StringGeneric Edit50
TOP12: Fixed Assets
25F1217Equipment Master Extension22WROKCODocument Company (Original Order)StringGeneric Edit50
26F1217PEquipment Master Extension Purge Table22WROKCODocument Company (Original Order)StringGeneric Edit50
27F1217Z1Unedited Equipment Tag Transactions35WROKCODocument Company (Original Order)StringGeneric Edit50
28F1217Z2Unedited Equipment Tag Transactions35WROKCODocument Company (Original Order)StringGeneric Edit50
TOP15: Real Estate Management
29F1511Tenant/Lease Billings Detail87NJOKCODocument Company (Original Order)StringGeneric Edit50
30F1511BLease Billings Master82NJOKCODocument Company (Original Order)StringGeneric Edit50
31F1511HTenant/Lease Billings Detail History86N#OKCODocument Company (Original Order)StringGeneric Edit50
32F1511HBLease Billings History81NCOKCODocument Company (Original Order)StringGeneric Edit50
TOP17C: Call Management
33F1755Case Master83ZAOKCODocument Company (Original Order)StringGeneric Edit50
TOP40: Inventory/OP Base
34F4001ZBatch Receiver File - Order Headings30SYOKCODocument Company (Original Order)StringGeneric Edit50
35F40051Return Material Authorization25RDOKCODocument Company (Original Order)StringGeneric Edit50
36F4011ZBatch Receiver File - Order Details21SZOKCODocument Company (Original Order)StringGeneric Edit50
37F4012ZWWF - Destination Quantity6SPOKCODocument Company (Original Order)StringGeneric Edit50
38F4201Z1Sales Order Header Unedited Transaction File20SYOKCODocument Company (Original Order)StringGeneric Edit50
39F4211Z1Sales Order Detail Unedited Transaction File21SZOKCODocument Company (Original Order)StringGeneric Edit50
TOP42: Sales Management
40F4201Sales Order Header File7SHOKCODocument Company (Original Order)StringGeneric Edit50
41F42019Sales Order Header History File7SHOKCODocument Company (Original Order)StringGeneric Edit50
42F4211Sales Order Detail File8SDOKCODocument Company (Original Order)StringGeneric Edit50
43F42119Sales Order History File8SDOKCODocument Company (Original Order)StringGeneric Edit50
44F42199S.O. Detail Ledger File8SLOKCODocument Company (Original Order)StringGeneric Edit50
45F42800G1Sales Update G Batch Detail Workfile84DGOKCODocument Company (Original Order)StringGeneric Edit50
46F42UI01SO Header Cache File (MBF)12ZHOKCODocument Company (Original Order)StringGeneric Edit50
47F42UI11SO Detail Cache File (MBF)12ZDOKCODocument Company (Original Order)StringGeneric Edit50
48F42UI521Pick Slips Detail File8S9OKCODocument Company (Original Order)StringGeneric Edit50
TOP43: Procurement
49F4301Purchase Order Header6PHOKCODocument Company (Original Order)StringGeneric Edit50
50F4301ZPO Header Work File10PAOKCODocument Company (Original Order)StringGeneric Edit50
51F4301Z1Purchase Order Header Unedited Transaction Table19SYOKCODocument Company (Original Order)StringGeneric Edit50
52F43080Approvals Fields Constants18PDOKCODocument Company (Original Order)StringGeneric Edit50
53F4311Purchase Order Detail File8PDOKCODocument Company (Original Order)StringGeneric Edit50
54F4311ZPurchase Order Generator File12PWOKCODocument Company (Original Order)StringGeneric Edit50
55F4311Z1Purchase Order Detail Unedited Transaction Table21SZOKCODocument Company (Original Order)StringGeneric Edit50
56F43199P.O. Detail Ledger File - Flexible Version8OLOKCODocument Company (Original Order)StringGeneric Edit50
57F4332Multiple Requisition File7P2OKCODocument Company (Original Order)StringGeneric Edit50
58F43UI50DPO Print Detail Work File21PWOKCODocument Company (Original Order)StringGeneric Edit50
TOP44H: Homebuilder Management
59F44H611WBid Details Work File7BWOKCODocument Company (Original Order)StringGeneric Edit50
60F44H711Lot Start Workfile20SWOKCODocument Company (Original Order)StringGeneric Edit50
61F44H711PAfter Start Purchasing25TPOKCODocument Company (Original Order)StringGeneric Edit50
62F44H711ZHB Lot Start Unedited Transaction File33SZOKCODocument Company (Original Order)StringGeneric Edit50
63F44H71W1Lot Start Generation Workfile20GWOKCODocument Company (Original Order)StringGeneric Edit50
64F44H73W1Lot Start - P.O. / Committment Generation Work File22CGOKCODocument Company (Original Order)StringGeneric Edit50
TOP45: Advanced Pricing
65F4576Z1Ship and Debit Claims Unedited Transaction Table126Z1OKCODocument Company (Original Order)StringGeneric Edit50
TOP47: Electronic Commerce
66F47011EDI Purchase Order Header - Inbound25SYOKCODocument Company (Original Order)StringGeneric Edit50
67F47012EDI Purchase Order Detail - Inbound22SZOKCODocument Company (Original Order)StringGeneric Edit50
68F47016EDI Purchase Order Header - Outbound21SYOKCODocument Company (Original Order)StringGeneric Edit50
69F47017EDI Purchase Order Detail - Outbound22SZOKCODocument Company (Original Order)StringGeneric Edit50
70F47021EDI P.O. Acknowledgment Header - Inbound21SYOKCODocument Company (Original Order)StringGeneric Edit50
71F47022EDI P.O. Acknowledgment Detail - Inbound22SZOKCODocument Company (Original Order)StringGeneric Edit50
72F47026EDI P.O. Acknowledgment Header - Outbound22SYOKCODocument Company (Original Order)StringGeneric Edit50
73F47027EDI P.O. Acknowledgment Detail - Outbound22SZOKCODocument Company (Original Order)StringGeneric Edit50
74F47031EDI Shipping Notice Header - Inbound22SYOKCODocument Company (Original Order)StringGeneric Edit50
75F47032EDI Shipping Notice Detail - Inbound25SZOKCODocument Company (Original Order)StringGeneric Edit50
76F47037EDI Shipping Notice Detail - Outbound25SZOKCODocument Company (Original Order)StringGeneric Edit50
77F470371EDI Shipping Notice Detail - Outbound25SZOKCODocument Company (Original Order)StringGeneric Edit50
78F47046EDI Invoice Header (Sales) - Outbound22SYOKCODocument Company (Original Order)StringGeneric Edit50
79F47047EDI Invoice Detail (Sales) - Outbound22SZOKCODocument Company (Original Order)StringGeneric Edit50
80F47057EDI Payment Order Remittance Advice - Outbound46D3OKCODocument Company (Original Order)StringGeneric Edit50
81F47057WEDI Payment Order Remittance Advice - Work46D3OKCODocument Company (Original Order)StringGeneric Edit50
82F47071EDI Receiving Advice Header - Inbound22SYOKCODocument Company (Original Order)StringGeneric Edit50
83F47072EDI Receiving Advice Detail - Inbound23SZOKCODocument Company (Original Order)StringGeneric Edit50
84F47076EDI Receiving Advice Header - Outbound22SYOKCODocument Company (Original Order)StringGeneric Edit50
85F47077EDI Receiving Advice Detail - Outbound23SZOKCODocument Company (Original Order)StringGeneric Edit50
86F47091EDI Request for Quote Header - Inbound25SYOKCODocument Company (Original Order)StringGeneric Edit50
87F47092EDI Request for Quote Detail - Inbound22SZOKCODocument Company (Original Order)StringGeneric Edit50
88F47096EDI Request for Quote Header - Outbound21SYOKCODocument Company (Original Order)StringGeneric Edit50
89F47097EDI Request for Quote Detail - Outbound22SZOKCODocument Company (Original Order)StringGeneric Edit50
90F47101EDI Response to RFQ Header - Inbound21SYOKCODocument Company (Original Order)StringGeneric Edit50
91F47102EDI Response to RFQ Detail - Inbound22SZOKCODocument Company (Original Order)StringGeneric Edit50
92F47106EDI Response to RFQ Header - Outbound22SYOKCODocument Company (Original Order)StringGeneric Edit50
93F47107EDI Response to RFQ Detail - Outbound22SZOKCODocument Company (Original Order)StringGeneric Edit50
94F47131EDI Purchase Order Change Header - Inbound22SYOKCODocument Company (Original Order)StringGeneric Edit50
95F47132EDI Purchase Order Change Detail - Inbound23SZOKCODocument Company (Original Order)StringGeneric Edit50
96F47136EDI Purchase Order Change Header - Outbound21SYOKCODocument Company (Original Order)StringGeneric Edit50
97F47137EDI Purchase Order Change Detail - Outbound23SZOKCODocument Company (Original Order)StringGeneric Edit50
98F47141EDI P.O. Change Acknowledgment Header - Inbound22SYOKCODocument Company (Original Order)StringGeneric Edit50
99F47142EDI P.O. Change Acknowledgment Detail - Inbound24SZOKCODocument Company (Original Order)StringGeneric Edit50
100F47146EDI P.O. Change Acknowledgment Header - Outbound23SYOKCODocument Company (Original Order)StringGeneric Edit50
101F47147EDI P.O. Change Acknowledgment Detail - Outbound24SZOKCODocument Company (Original Order)StringGeneric Edit50
102F47156EDI Shipping Schedule Header - Outbound22SYOKCODocument Company (Original Order)StringGeneric Edit50
103F47157EDI Shipping Schedule Detail - Outbound22SZOKCODocument Company (Original Order)StringGeneric Edit50
TOP48S: Service Billing
104F4812Billing Detail Workfile24WDOKCODocument Company (Original Order)StringGeneric Edit50
105F4812HBilling Workfile History24WDOKCODocument Company (Original Order)StringGeneric Edit50
106F4812HSBilling Workfile History Purged Save24WDOKCODocument Company (Original Order)StringGeneric Edit50
107F48SUI01Billing Detail Print Workfile24WDOKCODocument Company (Original Order)StringGeneric Edit50
TOP49: Transportation Management
108F4981Freight Audit History44FHOKCODocument Company (Original Order)StringGeneric Edit50
TOP70: Multi-National Products
109F704001Payment WH Info TEMP - COMM - 046PTOKCODocument Company (Original Order)StringGeneric Edit50
110F704002Payment WH Info - COMM - 045PFOKCODocument Company (Original Order)StringGeneric Edit50
111F704002PPayment WH Info Purge - COMM - 045PFOKCODocument Company (Original Order)StringGeneric Edit50
TOP74: EMEA Localization
112F7430015Invoices Related to AR DN/CN - COMM - 03B4DROKCODocument Company (Original Order)StringGeneric Edit50
TOP74H: Hungary
113F74H309Gains & Losses Unrealized Account ing - HUN - 03B4GLOKCODocument Company (Original Order)StringGeneric Edit50
114F74H409A/P Gains & Losses Unrealized Accounting - HUN - 044GLOKCODocument Company (Original Order)StringGeneric Edit50
TOP74R: Russia
115F74R0401Adjustment to Voucher - RUS - 04 - 74R2ADOKCODocument Company (Original Order)StringGeneric Edit50
116F74R0402Correction to Voucher - RUS - 04 - 74R4COOKCODocument Company (Original Order)StringGeneric Edit50
117F74R3037Adjustment Invoice Relationship in AR/SOP - RUS - 74R4AROKCODocument Company (Original Order)StringGeneric Edit50
TOP74Y: Italy
118F74Y015Yearly List Declaration - WF - IT - 0030YLOKCODocument Company (Original Order)StringGeneric Edit50
119F74Y018Intrastat Additional Info for Services - ITA - 0013IAOKCODocument Company (Original Order)StringGeneric Edit50
120F74Y171Contract Relations - IT - 0014CROKCODocument Company (Original Order)StringGeneric Edit50
121F74Y315Invoices Related to AR DN/CN - ITA - 03B5RIOKCODocument Company (Original Order)StringGeneric Edit50
122F74Y415Vouchers Related to AP DN/CN - ITA - 046RVOKCODocument Company (Original Order)StringGeneric Edit50
TOP75I: India
123F75I346Excise - D3-Form Table8Q9OKCODocument Company (Original Order)StringGeneric Edit50
124F75I411F0411 Tag File - IN - 0412TFOKCODocument Company (Original Order)StringGeneric Edit50
TOP75T: Taiwan
125F75T004ZGUI/VAT Transaction Header - Work - 75T3ZHOKCODocument Company (Original Order)StringGeneric Edit50
126F75T005ZGUI/VAT Transaction Detail - Work - 75T3ZDOKCODocument Company (Original Order)StringGeneric Edit50
TOP76A: Argentina
127F76A81A/P Payment Control Group File - ARG - 04 - 76A25C5OKCODocument Company (Original Order)StringGeneric Edit50
128F76A82A/P Payment Control Group File - ARG - 04 - 76A36C6OKCODocument Company (Original Order)StringGeneric Edit50
TOP76C: Colombia
129F76C031AA/R Customer ledger As Of - F76C031A - COL - 0471RPOKCODocument Company (Original Order)StringGeneric Edit50
130F76C034AA/R Check Detail file As Of - COL - 03B83RZOKCODocument Company (Original Order)StringGeneric Edit50
TOP76H: Chile
131F76H3B15NC/ND - Invoice Related - CHI - 03B - 76H4IROKCODocument Company (Original Order)StringGeneric Edit50
132F76H3B20Invoices not Printed - CHI - 03B - 76H12ADOKCODocument Company (Original Order)StringGeneric Edit50
133F76HUI31Document Related Work File - CHI - 42 - 76H6DROKCODocument Company (Original Order)StringGeneric Edit50
TOP76M: Mexico
134F76M0314Receipt Detail Tag File - Mexico11MAOKCODocument Company (Original Order)StringGeneric Edit50
135F76M0414F0414 - Payment Detail Tag File - Mexico12RTOKCODocument Company (Original Order)StringGeneric Edit50
136F76M990GL VAT on Gain/loss MEX - 76M21GLOKCODocument Company (Original Order)StringGeneric Edit50
TOP76P: Peru
137F76P411TPeru AP Tag File - PER - 04 - 76P23T4OKCODocument Company (Original Order)StringGeneric Edit50
138F76P480SPOT Voucher Information - PER - 04 - 76P4SVOKCODocument Company (Original Order)StringGeneric Edit50
TOP76V: Venezuela
139F76V4015Vouchers Related to Credit/Debit Notes - VEN - 044CDOKCODocument Company (Original Order)StringGeneric Edit50
TOP89: Conversion Programs
140F43199ATemp F43199 for ERP 9.0 Upgrade8OLOKCODocument Company (Original Order)StringGeneric Edit50