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
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
9F42119SDSales Order History File
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

129 columns | Print definition?812 | 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
7F03B11Z1Invoice Transactions - Batch File88VJOKCODocument Company (Original Order)StringGeneric Edit50
8F03B11Z2F03B11 Interoperability Table85SYOKCODocument Company (Original Order)StringGeneric Edit50
9F03B14A/R Check Detail File82RZOKCODocument 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
TOP04: Accounts Payable
14F0411Accounts Payable Ledger56RPOKCODocument Company (Original Order)StringGeneric Edit50
15F0411AWF - As Of - Accounts Payable Ledger56RPOKCODocument Company (Original Order)StringGeneric Edit50
16F0411PPurge - Accounts Payable Ledger56RPOKCODocument Company (Original Order)StringGeneric Edit50
17F0411Z1Voucher Transactions - Batch File74VLOKCODocument Company (Original Order)StringGeneric Edit50
18F0411Z3F0411 Interoperability Table79SZOKCODocument Company (Original Order)StringGeneric Edit50
TOP09: General Accounting
19F0911PPurge - Account Ledger46GLOKCODocument Company (Original Order)StringGeneric Edit50
20F0911Z1Journal Entry Transactions - Batch File63VNOKCODocument Company (Original Order)StringGeneric Edit50
21F0911Z4F0911 Interoperability Table68SZOKCODocument Company (Original Order)StringGeneric Edit50
22F09UI015Indexed Computations Multi-Tiered Entries46GLOKCODocument Company (Original Order)StringGeneric Edit50
TOP12: Fixed Assets
23F1217Equipment Master Extension22WROKCODocument Company (Original Order)StringGeneric Edit50
24F1217PEquipment Master Extension Purge Table22WROKCODocument Company (Original Order)StringGeneric Edit50
25F1217Z1Unedited Equipment Tag Transactions35WROKCODocument Company (Original Order)StringGeneric Edit50
26F1217Z2Unedited Equipment Tag Transactions35WROKCODocument Company (Original Order)StringGeneric Edit50
TOP15: Property Management
27F1511Tenant/Lease Billings Detail87NJOKCODocument Company (Original Order)StringGeneric Edit50
28F1511BTenant/Lease Billings Detail Master82NJOKCODocument Company (Original Order)StringGeneric Edit50
29F1511HTenant/Lease Billings Detail History86N#OKCODocument Company (Original Order)StringGeneric Edit50
30F1511HBTenant/Lease Billings Detail History81NCOKCODocument Company (Original Order)StringGeneric Edit50
TOP17C: Call Management
31F1755Customer Call Master83ZAOKCODocument Company (Original Order)StringGeneric Edit50
TOP40: Inventory/OP Base
32F4001ZBatch Receiver File - Order Headings30SYOKCODocument Company (Original Order)StringGeneric Edit50
33F40051Return Material Authorization25RDOKCODocument Company (Original Order)StringGeneric Edit50
34F4011ZBatch Receiver File - Order Details21SZOKCODocument Company (Original Order)StringGeneric Edit50
35F4012ZWWF - Destination Quantity6SPOKCODocument Company (Original Order)StringGeneric Edit50
36F4201Z1Sales Order Header Unedited Transaction File20SYOKCODocument Company (Original Order)StringGeneric Edit50
37F4211Z1Sales Order Detail Unedited Transaction File21SZOKCODocument Company (Original Order)StringGeneric Edit50
TOP42: Sales Management
38F4201Sales Order Header File7SHOKCODocument Company (Original Order)StringGeneric Edit50
39F42019Sales Order Header History File7SHOKCODocument Company (Original Order)StringGeneric Edit50
40F4211Sales Order Detail File8SDOKCODocument Company (Original Order)StringGeneric Edit50
41F42119Sales Order History File8SDOKCODocument Company (Original Order)StringGeneric Edit50
42F42199S.O. Detail Ledger File8SLOKCODocument Company (Original Order)StringGeneric Edit50
43F42800G1Sales Update G Batch Detail Workfile84DGOKCODocument Company (Original Order)StringGeneric Edit50
44F42UI01SO Header Cache File (MBF)12ZHOKCODocument Company (Original Order)StringGeneric Edit50
45F42UI11SO Detail Cache File (MBF)12ZDOKCODocument Company (Original Order)StringGeneric Edit50
46F42UI521Pick Slips Detail File8S9OKCODocument Company (Original Order)StringGeneric Edit50
TOP43: Procurement
47F4301Purchase Order Header6PHOKCODocument Company (Original Order)StringGeneric Edit50
48F4301ZPO Header Work File10PAOKCODocument Company (Original Order)StringGeneric Edit50
49F4301Z1Purchase Order Header Unedited Transaction Table19SYOKCODocument Company (Original Order)StringGeneric Edit50
50F43080Approvals Fields Constants18PDOKCODocument Company (Original Order)StringGeneric Edit50
51F4311Purchase Order Detail File8PDOKCODocument Company (Original Order)StringGeneric Edit50
52F4311ZPurchase Order Generator File12PWOKCODocument Company (Original Order)StringGeneric Edit50
53F4311Z1Purchase Order Detail Unedited Transaction Table21SZOKCODocument Company (Original Order)StringGeneric Edit50
54F43199P.O. Detail Ledger File - Flexible Version8OLOKCODocument Company (Original Order)StringGeneric Edit50
55F4332Multiple Requisition File7P2OKCODocument Company (Original Order)StringGeneric Edit50
56F43UI50DPO Print Detail Work File21PWOKCODocument Company (Original Order)StringGeneric Edit50
TOP44H: Homebuilder Management
57F44H611WBid Details Work File7BWOKCODocument Company (Original Order)StringGeneric Edit50
58F44H711Lot Start Workfile20SWOKCODocument Company (Original Order)StringGeneric Edit50
59F44H711PAfter Start Purchasing25TPOKCODocument Company (Original Order)StringGeneric Edit50
60F44H711ZHB Lot Start Unedited Transaction File33SZOKCODocument Company (Original Order)StringGeneric Edit50
61F44H71W1Lot Start Generation Workfile20GWOKCODocument Company (Original Order)StringGeneric Edit50
62F44H73W1Lot Start - P.O. / Committment Generation Work File22CGOKCODocument Company (Original Order)StringGeneric Edit50
TOP45: Advanced Pricing
63F4576Z1Ship and Debit Claims Unedited Transaction Table126Z1OKCODocument Company (Original Order)StringGeneric Edit50
TOP47: Electronic Commerce
64F47011EDI Purchase Order Header - Inbound25SYOKCODocument Company (Original Order)StringGeneric Edit50
65F47012EDI Purchase Order Detail - Inbound22SZOKCODocument Company (Original Order)StringGeneric Edit50
66F47016EDI Purchase Order Header - Outbound21SYOKCODocument Company (Original Order)StringGeneric Edit50
67F47017EDI Purchase Order Detail - Outbound22SZOKCODocument Company (Original Order)StringGeneric Edit50
68F47021EDI P.O. Acknowledgment Header - Inbound21SYOKCODocument Company (Original Order)StringGeneric Edit50
69F47022EDI P.O. Acknowledgment Detail - Inbound22SZOKCODocument Company (Original Order)StringGeneric Edit50
70F47026EDI P.O. Acknowledgment Header - Outbound22SYOKCODocument Company (Original Order)StringGeneric Edit50
71F47027EDI P.O. Acknowledgment Detail - Outbound22SZOKCODocument Company (Original Order)StringGeneric Edit50
72F47031EDI Shipping Notice Header - Inbound22SYOKCODocument Company (Original Order)StringGeneric Edit50
73F47032EDI Shipping Notice Detail - Inbound25SZOKCODocument Company (Original Order)StringGeneric Edit50
74F47037EDI Shipping Notice Detail - Outbound25SZOKCODocument Company (Original Order)StringGeneric Edit50
75F470371EDI Shipping Notice Detail - Outbound25SZOKCODocument Company (Original Order)StringGeneric Edit50
76F47046EDI Invoice Header (Sales) - Outbound22SYOKCODocument Company (Original Order)StringGeneric Edit50
77F47047EDI Invoice Detail (Sales) - Outbound22SZOKCODocument Company (Original Order)StringGeneric Edit50
78F47057EDI Payment Order Remittance Advice - Outbound46D3OKCODocument Company (Original Order)StringGeneric Edit50
79F47057WEDI Payment Order Remittance Advice - Work46D3OKCODocument Company (Original Order)StringGeneric Edit50
80F47071EDI Receiving Advice Header - Inbound22SYOKCODocument Company (Original Order)StringGeneric Edit50
81F47072EDI Receiving Advice Detail - Inbound23SZOKCODocument Company (Original Order)StringGeneric Edit50
82F47076EDI Receiving Advice Header - Outbound22SYOKCODocument Company (Original Order)StringGeneric Edit50
83F47077EDI Receiving Advice Detail - Outbound23SZOKCODocument Company (Original Order)StringGeneric Edit50
84F47091EDI Request for Quote Header - Inbound25SYOKCODocument Company (Original Order)StringGeneric Edit50
85F47092EDI Request for Quote Detail - Inbound22SZOKCODocument Company (Original Order)StringGeneric Edit50
86F47096EDI Request for Quote Header - Outbound21SYOKCODocument Company (Original Order)StringGeneric Edit50
87F47097EDI Request for Quote Detail - Outbound22SZOKCODocument Company (Original Order)StringGeneric Edit50
88F47101EDI Response to RFQ Header - Inbound21SYOKCODocument Company (Original Order)StringGeneric Edit50
89F47102EDI Response to RFQ Detail - Inbound22SZOKCODocument Company (Original Order)StringGeneric Edit50
90F47106EDI Response to RFQ Header - Outbound22SYOKCODocument Company (Original Order)StringGeneric Edit50
91F47107EDI Response to RFQ Detail - Outbound22SZOKCODocument Company (Original Order)StringGeneric Edit50
92F47131EDI Purchase Order Change Header - Inbound22SYOKCODocument Company (Original Order)StringGeneric Edit50
93F47132EDI Purchase Order Change Detail - Inbound23SZOKCODocument Company (Original Order)StringGeneric Edit50
94F47136EDI Purchase Order Change Header - Outbound21SYOKCODocument Company (Original Order)StringGeneric Edit50
95F47137EDI Purchase Order Change Detail - Outbound23SZOKCODocument Company (Original Order)StringGeneric Edit50
96F47141EDI P.O. Change Acknowledgment Header - Inbound22SYOKCODocument Company (Original Order)StringGeneric Edit50
97F47142EDI P.O. Change Acknowledgment Detail - Inbound24SZOKCODocument Company (Original Order)StringGeneric Edit50
98F47146EDI P.O. Change Acknowledgment Header - Outbound23SYOKCODocument Company (Original Order)StringGeneric Edit50
99F47147EDI P.O. Change Acknowledgment Detail - Outbound24SZOKCODocument Company (Original Order)StringGeneric Edit50
100F47156EDI Shipping Schedule Header - Outbound22SYOKCODocument Company (Original Order)StringGeneric Edit50
101F47157EDI Shipping Schedule Detail - Outbound22SZOKCODocument Company (Original Order)StringGeneric Edit50
TOP48S: Service Billing
102F4812Billing Detail Workfile24WDOKCODocument Company (Original Order)StringGeneric Edit50
103F4812HBilling Workfile - History24WDOKCODocument Company (Original Order)StringGeneric Edit50
104F4812HSBilling Workfile History Purged Save24WDOKCODocument Company (Original Order)StringGeneric Edit50
105F48SUI01Billing Detail Print Workfile24WDOKCODocument Company (Original Order)StringGeneric Edit50
TOP49: Transportation Management
106F4981Freight Audit History44FHOKCODocument Company (Original Order)StringGeneric Edit50
TOP55: Reserved for Clients
107F55IF421Sales Order per BO8SDOKCODocument Company (Original Order)StringGeneric Edit50
108F55IF425Sales Order per BO - 20058SDOKCODocument Company (Original Order)StringGeneric Edit50
109F55IFP03Checking Credit Note Number WF5WFOKCODocument Company (Original Order)StringGeneric Edit50
110F55W0100Correction Invoice Print - WF19SDOKCODocument Company (Original Order)StringGeneric Edit50
111F74H1051Invoicing Workfile - New32IWOKCODocument Company (Original Order)StringGeneric Edit50
112F74P0710Credit Order History8PLOKCODocument Company (Original Order)StringGeneric Edit50
113F59H0220CRM Case Tag File - Proposals3CCOKCODocument Company (Original Order)StringGeneric Edit50
TOP74: EMEA Localization
114F7430015Invoices Related to AR DN/CN - COMM - 03B4DROKCODocument Company (Original Order)StringGeneric Edit50
TOP75T: Taiwan
115F75T004ZGUI/VAT Transaction Header - Work - 75T3ZHOKCODocument Company (Original Order)StringGeneric Edit50
116F75T005ZGUI/VAT Transaction Detail - Work - 75T3ZDOKCODocument Company (Original Order)StringGeneric Edit50
TOP76A: Argentina
117F76A81A/P Payment Control Group File - ARG - 04 - 76A25C5OKCODocument Company (Original Order)StringGeneric Edit50
118F76A82A/P Payment Control Group File - ARG - 04 - 76A36C6OKCODocument Company (Original Order)StringGeneric Edit50
TOP76C: Colombia
119F76C031AA/R Customer ledger As Of - F76C031A - COL - 0471RPOKCODocument Company (Original Order)StringGeneric Edit50
120F76C034AA/R Check Detail file As Of - COL - 76C83RZOKCODocument Company (Original Order)StringGeneric Edit50
TOP76H: Chile
121F76H3B15NC/ND - Invoice Related - CHI - 03B - 76H4IROKCODocument Company (Original Order)StringGeneric Edit50
122F76H3B20Invoices not Printed - CHI - 03B - 76H12ADOKCODocument Company (Original Order)StringGeneric Edit50
123F76HUI31Document Related Work File - CHI - 42 - 76H6DROKCODocument Company (Original Order)StringGeneric Edit50
TOP76M: Mexico
124F76M0314Receipt Detail Tag File - Mexico11MAOKCODocument Company (Original Order)StringGeneric Edit50
125F76M0414F0414 - Payment Detail Tag File - Mexico12RTOKCODocument Company (Original Order)StringGeneric Edit50
TOP76P: Peru
126F76P411TPeru AP Tag File - PER - 04 - 76P23T4OKCODocument Company (Original Order)StringGeneric Edit50
127F76P480SPOT Voucher Information - PER - 04 - 76P4SVOKCODocument Company (Original Order)StringGeneric Edit50
TOP76V: Venezuela
128F76V4015Vouchers Related to Credit/Debit Notes - VEN - 044CDOKCODocument Company (Original Order)StringGeneric Edit50
TOP89: Conversion Programs
129F43199ATemp F43199 for ERP 9.0 Upgrade8OLOKCODocument Company (Original Order)StringGeneric Edit50