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

124 columns | Print definition?812 | BCRC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0018RTax Reconciliation Repository16EDBCRCCurrency Code - BaseStringGeneric Edit30
2F0911Account Ledger124GLBCRCCurrency Code - BaseStringGeneric Edit30
TOP03B: Enhanced Accounts Receivable
3F03B11Customer Ledger31RPBCRCCurrency Code - BaseStringGeneric Edit30
4F03B112Invoice Revisions33RWBCRCCurrency Code - BaseStringGeneric Edit30
5F03B112PInvoice Revisions Purge File33RWBCRCCurrency Code - BaseStringGeneric Edit30
6F03B11PCustomer Ledger Purge File31RPBCRCCurrency Code - BaseStringGeneric Edit30
7F03B11Z2F03B11 Interoperability Table44SYBCRCCurrency Code - BaseStringGeneric Edit30
8F03B13Receipts Header File24RYBCRCCurrency Code - BaseStringGeneric Edit30
9F03B13PReceipts Header Purge File24RYBCRCCurrency Code - BaseStringGeneric Edit30
10F03B13Z2F03B13 Interoperability Table37SYBCRCCurrency Code - BaseStringGeneric Edit30
11F03B14A/R Check Detail File31RZBCRCCurrency Code - BaseStringGeneric Edit30
12F03B14PReceipts Detail Purge File31RZBCRCCurrency Code - BaseStringGeneric Edit30
13F03B14Z2F03B14 Interoperability Table44SZBCRCCurrency Code - BaseStringGeneric Edit30
14F03B21A/R Notification History Detail19ZSBCRCCurrency Code - BaseStringGeneric Edit30
15F03B22A/R Fee Journal History13RSBCRCCurrency Code - BaseStringGeneric Edit30
16F03B23A/R Fee Journal History Detail12RTBCRCCurrency Code - BaseStringGeneric Edit30
17F03B40A/R Deduction Management28RBBCRCCurrency Code - BaseStringGeneric Edit30
18F03B41A/R Deduction Activity11RCBCRCCurrency Code - BaseStringGeneric Edit30
19F03B575Auto Debit Invoice Select and Build34RDBCRCCurrency Code - BaseStringGeneric Edit30
20F03B672Draft Remittance Work File - One World Only27RDBCRCCurrency Code - BaseStringGeneric Edit30
TOP04: Accounts Payable
21F0411Accounts Payable Ledger113RPBCRCCurrency Code - BaseStringGeneric Edit30
22F0411AWF - As Of - Accounts Payable Ledger113RPBCRCCurrency Code - BaseStringGeneric Edit30
23F0411PPurge - Accounts Payable Ledger113RPBCRCCurrency Code - BaseStringGeneric Edit30
24F0411Z1Voucher Transactions - Batch File160VLBCRCCurrency Code - BaseStringGeneric Edit30
25F0411Z3F0411 Interoperability Table167SZBCRCCurrency Code - BaseStringGeneric Edit30
26F0414Accounts Payable Matching Document Detail36RNBCRCCurrency Code - BaseStringGeneric Edit30
27F0414AWF - As Of - Accounts Payable Payment Detail38RNBCRCCurrency Code - BaseStringGeneric Edit30
28F0414PPurge - Accounts Payable Matching Document Detail36RNBCRCCurrency Code - BaseStringGeneric Edit30
29F0414Z1F0414 Interoperability Table56SZBCRCCurrency Code - BaseStringGeneric Edit30
30F04573A/P Payment Processing - Detail File46KIBCRCCurrency Code - BaseStringGeneric Edit30
31F09UI005Tax Offsets User Index42GLBCRCCurrency Code - BaseStringGeneric Edit30
TOP09: General Accounting
32F0911PPurge - Account Ledger124GLBCRCCurrency Code - BaseStringGeneric Edit30
33F0911RWF - Acct Ledger File for Reconciliation59GLBCRCCurrency Code - BaseStringGeneric Edit30
34F0911Z1Journal Entry Transactions - Batch File175VNBCRCCurrency Code - BaseStringGeneric Edit30
35F0911Z4F0911 Interoperability Table155SZBCRCCurrency Code - BaseStringGeneric Edit30
36F09521Cash Type Rules12FRBCRCCurrency Code - BaseStringGeneric Edit30
37F09522Cash Forecast Data5FDBCRCCurrency Code - BaseStringGeneric Edit30
38F09UI017Cash Forecast Detail9FWBCRCCurrency Code - BaseStringGeneric Edit30
TOP15: Property Management
39F151991G/L Transaction A/R Application Work File20NBBCRCCurrency Code - BaseStringGeneric Edit30
40F15199WG/L Transaction Summarization Work File12NBBCRCCurrency Code - BaseStringGeneric Edit30
41F1540BSales Report Control File46NRBCRCCurrency Code - BaseStringGeneric Edit30
42F1542Projected Sales42OJBCRCCurrency Code - BaseStringGeneric Edit30
TOP15L: Adv Real Estate Forecasting
43F15L301AREF Projected Sales43PSBCRCCurrency Code - BaseStringGeneric Edit30
TOP40: Inventory/OP Base
44F4001ZBatch Receiver File - Order Headings136SYBCRCCurrency Code - BaseStringGeneric Edit30
45F4201Z1Sales Order Header Unedited Transaction File124SYBCRCCurrency Code - BaseStringGeneric Edit30
46F4211Z1Sales Order Detail Unedited Transaction File245SZBCRCCurrency Code - BaseStringGeneric Edit30
47F43800Summary Voucher Match18PRBCRCCurrency Code - BaseStringGeneric Edit30
TOP42: Sales Management
48F4201Sales Order Header File112SHBCRCCurrency Code - BaseStringGeneric Edit30
49F42019Sales Order Header History File112SHBCRCCurrency Code - BaseStringGeneric Edit30
50F4211Sales Order Detail File232SDBCRCCurrency Code - BaseStringGeneric Edit30
51F42119Sales Order History File232SDBCRCCurrency Code - BaseStringGeneric Edit30
52F42199S.O. Detail Ledger File232SLBCRCCurrency Code - BaseStringGeneric Edit30
53F42UI01SO Header Cache File (MBF)150ZHBCRCCurrency Code - BaseStringGeneric Edit30
54F42UI12Sales Order Detail Cache 2 (MBF)88ZDBCRCCurrency Code - BaseStringGeneric Edit30
55F47027TTag for F47027 - EDI P.O. Acknowledgment Detail - Outbound2UZBCRCCurrency Code - BaseStringGeneric Edit30
56F47047TTag for F47047- EDI Invoice Detail (Sales) - Outbound2UZBCRCCurrency Code - BaseStringGeneric Edit30
57F47107TTag for F47107- EDI Response to RFQ Detail - Outbound2UZBCRCCurrency Code - BaseStringGeneric Edit30
58F47147TTag F47147 - EDI P.O. Change Acknowledgment Detail-Outbound2UZBCRCCurrency Code - BaseStringGeneric Edit30
TOP42B: Sales Order Entry
59F4011ZTBatch Receiver File - Order Details Tag25UZBCRCCurrency Code - BaseStringGeneric Edit30
60F47012TEDI Purchase Order Detail Tag - Inbound25UZBCRCCurrency Code - BaseStringGeneric Edit30
61F47092TEDI Request for Quote Detail Tag - Inbound25UZBCRCCurrency Code - BaseStringGeneric Edit30
62F47132TEDI Purchase Order Change Detail Tag - Inbound25UZBCRCCurrency Code - BaseStringGeneric Edit30
TOP43: Procurement
63F4301Purchase Order Header88PHBCRCCurrency Code - BaseStringGeneric Edit30
64F4301Z1Purchase Order Header Unedited Transaction Table105SYBCRCCurrency Code - BaseStringGeneric Edit30
65F4311Purchase Order Detail File206PDBCRCCurrency Code - BaseStringGeneric Edit30
66F4311Z1Purchase Order Detail Unedited Transaction Table226SZBCRCCurrency Code - BaseStringGeneric Edit30
67F43121Purchase Order Receiver File106PRBCRCCurrency Code - BaseStringGeneric Edit30
68F43121ZReceiver workfile164PWBCRCCurrency Code - BaseStringGeneric Edit30
69F43121Z1Receipts Unedited Transaction Table196SZBCRCCurrency Code - BaseStringGeneric Edit30
70F43199P.O. Detail Ledger File - Flexible Version207OLBCRCCurrency Code - BaseStringGeneric Edit30
71F4322Purchasing Tolerance Rules14PZBCRCCurrency Code - BaseStringGeneric Edit30
TOP45: Advanced Pricing
72F4576Ship and Debit Claims28ACBCRCCurrency Code - BaseStringGeneric Edit30
73F4576TMPShip and Debit Claims- Temp Table28ACBCRCCurrency Code - BaseStringGeneric Edit30
74F4576Z1Ship and Debit Claims Unedited Transaction Table41Z1BCRCCurrency Code - BaseStringGeneric Edit30
TOP47: Electronic Commerce
75F47011EDI Purchase Order Header - Inbound124SYBCRCCurrency Code - BaseStringGeneric Edit30
76F47016EDI Purchase Order Header - Outbound108SYBCRCCurrency Code - BaseStringGeneric Edit30
77F47017EDI Purchase Order Detail - Outbound217SZBCRCCurrency Code - BaseStringGeneric Edit30
78F47021EDI P.O. Acknowledgment Header - Inbound108SYBCRCCurrency Code - BaseStringGeneric Edit30
79F47022EDI P.O. Acknowledgment Detail - Inbound217SZBCRCCurrency Code - BaseStringGeneric Edit30
80F47026EDI P.O. Acknowledgment Header - Outbound117SYBCRCCurrency Code - BaseStringGeneric Edit30
81F47031EDI Shipping Notice Header - Inbound102SYBCRCCurrency Code - BaseStringGeneric Edit30
82F47032TEDI Shipping Notice Detail- Inbound Tag4SZBCRCCurrency Code - BaseStringGeneric Edit30
83F47036EDI Shipping Notice Header - Outbound40SYBCRCCurrency Code - BaseStringGeneric Edit30
84F470371EDI Shipping Notice Detail - Outbound99SZBCRCCurrency Code - BaseStringGeneric Edit30
85F47046EDI Invoice Header (Sales) - Outbound105SYBCRCCurrency Code - BaseStringGeneric Edit30
86F47071EDI Receiving Advice Header - Inbound101SYBCRCCurrency Code - BaseStringGeneric Edit30
87F47072EDI Receiving Advice Detail - Inbound205SZBCRCCurrency Code - BaseStringGeneric Edit30
88F47076EDI Receiving Advice Header - Outbound101SYBCRCCurrency Code - BaseStringGeneric Edit30
89F47077EDI Receiving Advice Detail - Outbound205SZBCRCCurrency Code - BaseStringGeneric Edit30
90F47091EDI Request for Quote Header - Inbound124SYBCRCCurrency Code - BaseStringGeneric Edit30
91F47096EDI Request for Quote Header - Outbound109SYBCRCCurrency Code - BaseStringGeneric Edit30
92F47097EDI Request for Quote Detail - Outbound217SZBCRCCurrency Code - BaseStringGeneric Edit30
93F47101EDI Response to RFQ Header - Inbound109SYBCRCCurrency Code - BaseStringGeneric Edit30
94F47102EDI Response to RFQ Detail - Inbound217SZBCRCCurrency Code - BaseStringGeneric Edit30
95F47106EDI Response to RFQ Header - Outbound121SYBCRCCurrency Code - BaseStringGeneric Edit30
96F47131EDI Purchase Order Change Header - Inbound121SYBCRCCurrency Code - BaseStringGeneric Edit30
97F47136EDI Purchase Order Change Header - Outbound108SYBCRCCurrency Code - BaseStringGeneric Edit30
98F47141EDI P.O. Change Acknowledgment Header - Inbound109SYBCRCCurrency Code - BaseStringGeneric Edit30
99F47142EDI P.O. Change Acknowledgment Detail - Inbound219SZBCRCCurrency Code - BaseStringGeneric Edit30
100F47146EDI P.O. Change Acknowledgment Header - Outbound122SYBCRCCurrency Code - BaseStringGeneric Edit30
101F47156EDI Shipping Schedule Header - Outbound86SYBCRCCurrency Code - BaseStringGeneric Edit30
102F47157EDI Shipping Schedule Detail - Outbound88SZBCRCCurrency Code - BaseStringGeneric Edit30
TOP55: Reserved for Clients
103F55IF311As Of111RPBCRCCurrency Code - BaseStringGeneric Edit30
104F55IFLOGhistorical log19HLBCRCCurrency Code - BaseStringGeneric Edit30
105F55IFSFVEstrazione del venduto per Sales Force Automation23FSBCRCCurrency Code - BaseStringGeneric Edit30
106F55W0100Correction Invoice Print - WF1233SDBCRCCurrency Code - BaseStringGeneric Edit30
TOP74: EMEA Localization
107F74093Workfile for Printing IVA Summary - Italy67HCBCRCCurrency Code - BaseStringGeneric Edit30
108F74900Foreign Receivables and Payables - EMEA38RPBCRCCurrency Code - BaseStringGeneric Edit30
TOP75T: Taiwan
109F75T004GUI/VAT Transaction Header - 75T17THBCRCCurrency Code - BaseStringGeneric Edit30
110F75T0049GUI/VAT Transaction Header History - 75T17THBCRCCurrency Code - BaseStringGeneric Edit30
111F75T004PGUI/VAT Transaction Header POS - 75T17THBCRCCurrency Code - BaseStringGeneric Edit30
112F75T004ZGUI/VAT Transaction Header - Work - 75T15ZHBCRCCurrency Code - BaseStringGeneric Edit30
113F75T005GUI/VAT Transaction Detail - 75T13TDBCRCCurrency Code - BaseStringGeneric Edit30
114F75T0059GUI/VAT Transaction Detail History - 75T13TDBCRCCurrency Code - BaseStringGeneric Edit30
115F75T005PGUI/VAT Transaction Detail POS - 75T13TDBCRCCurrency Code - BaseStringGeneric Edit30
116F75T005ZGUI/VAT Transaction Detail - Work - 75T19ZDBCRCCurrency Code - BaseStringGeneric Edit30
TOP76A: Argentina
117F76AUI82Draft - Drafts Work File - ARG - 03B - 03B40WFBCRCCurrency Code - BaseStringGeneric Edit30
118F76AUI83Draft - Application Drafts - Invoices Work File - ARG - 76A18WFBCRCCurrency Code - BaseStringGeneric Edit30
TOP76C: Colombia
119F76C031AA/R Customer ledger As Of - F76C031A - COL - 0431RPBCRCCurrency Code - BaseStringGeneric Edit30
120F76C034AA/R Check Detail file As Of - COL - 76C29RZBCRCCurrency Code - BaseStringGeneric Edit30
TOP76M: Mexico
121F76M0314Receipt Detail Tag File - Mexico19MABCRCCurrency Code - BaseStringGeneric Edit30
122F76M0414F0414 - Payment Detail Tag File - Mexico19RTBCRCCurrency Code - BaseStringGeneric Edit30
123F76M311AR Soft Rounding VAT - Mexico11MBBCRCCurrency Code - BaseStringGeneric Edit30
124F76M411Soft Rounding VAT Calculation10RSBCRCCurrency Code - BaseStringGeneric Edit30