JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.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
6F9671SDSoftware Update Detail Table
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F0006MCBusiness Unit Master
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F76AUI46WFCERG A/R -Work File - ARG - 03B - 76A
3F4211SDSales Order Detail File
4F4101IMItem Master
5F0101ABAddress Book Master
6F0911GLAccount Ledger
7F4102IBItem Branch File
8F03B11RPCustomer Ledger
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0006MCBusiness Unit Master
5F0411RPAccounts Payable Ledger
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

142 columns | Print definition?910 | 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 Header24RYBCRCCurrency Code - BaseStringGeneric Edit30
9F03B13PReceipts Header Purge File24RYBCRCCurrency Code - BaseStringGeneric Edit30
10F03B13Z2F03B13 Interoperability Table37SYBCRCCurrency Code - BaseStringGeneric Edit30
11F03B14Receipts Detail31RZBCRCCurrency 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 Remittance27RDBCRCCurrency 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 Upload160VLBCRCCurrency 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 - Detail46KIBCRCCurrency Code - BaseStringGeneric Edit30
31F09UI005Tax Offsets User Index42GLBCRCCurrency Code - BaseStringGeneric Edit30
TOP09: General Accounting
32F0911PPurge - Account Ledger124GLBCRCCurrency Code - BaseStringGeneric Edit30
33F0911RWF - Account Ledger 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 Control46NRBCRCCurrency 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
TOP70: Multi-National Products - obsolete-do not reuse
103F702018Taxes by Sales Order Line - COMM - 4213TABCRCCurrency Code - BaseStringGeneric Edit30
104F704001Payment WH Info TEMP - COMM - 0451PTBCRCCurrency Code - BaseStringGeneric Edit30
105F704002Payment WH Info - COMM - 0450PFBCRCCurrency Code - BaseStringGeneric Edit30
106F704002PPayment WH Info Purge - COMM - 0450PFBCRCCurrency Code - BaseStringGeneric Edit30
107F704003Payment Done - Accum - COMM - 0414PDBCRCCurrency Code - BaseStringGeneric Edit30
TOP74: EMEA Localization
108F74093Worktable for Printing IVA Summary - Italy67HCBCRCCurrency Code - BaseStringGeneric Edit30
109F74900Foreign Receivables and Payables - EMEA38RPBCRCCurrency Code - BaseStringGeneric Edit30
TOP74H: Hungary
110F74H910JE VAT Differences - HUN - 0918VDBCRCCurrency Code - BaseStringGeneric Edit30
TOP74R: CIS
111F74R311Prepayment Detail Tax File - RUS - 03B20DEBCRCCurrency Code - BaseStringGeneric Edit30
TOP74S: Spain
112F74S79Model 347 - Record Type 2 - Spain Tag File10TQBCRCCurrency Code - BaseStringGeneric Edit30
TOP75C: China - Reporting System Only
113F75C010WAP & AR XML Workfile - China -75C13AABCRCCurrency Code - BaseStringGeneric Edit30
114F75C014AP/AR Balances - China8BABCRCCurrency Code - BaseStringGeneric Edit30
TOP75I: India
115F75I611TCS Prepayment Transaction File - IND-03B28TTBCRCCurrency Code - BaseStringGeneric Edit30
116F75I732Service Tax A/R File Additional Info - IND - 03B10STBCRCCurrency Code - BaseStringGeneric Edit30
117F75I742Service Tax A/P File Additional Info - IND - 0411STBCRCCurrency Code - BaseStringGeneric Edit30
TOP75T: Taiwan
118F75T004GUI/VAT Transaction Header - 75T19THBCRCCurrency Code - BaseStringGeneric Edit30
119F75T0049GUI/VAT Transaction Header History - 75T19THBCRCCurrency Code - BaseStringGeneric Edit30
120F75T004PGUI/VAT Transaction Header POS - 75T18THBCRCCurrency Code - BaseStringGeneric Edit30
121F75T004ZGUI/VAT Transaction Header - Work - 75T17ZHBCRCCurrency Code - BaseStringGeneric Edit30
122F75T005GUI/VAT Transaction Detail - 75T15TDBCRCCurrency Code - BaseStringGeneric Edit30
123F75T0059GUI/VAT Transaction Detail History - 75T15TDBCRCCurrency Code - BaseStringGeneric Edit30
124F75T005PGUI/VAT Transaction Detail POS - 75T15TDBCRCCurrency Code - BaseStringGeneric Edit30
125F75T005TGUI/VAT Transaction Detail Temp - 75T15TDBCRCCurrency Code - BaseStringGeneric Edit30
126F75T005ZGUI/VAT Transaction Detail - Work - 75T22ZDBCRCCurrency Code - BaseStringGeneric Edit30
TOP76A: Argentina
127F76AUI82Draft - Drafts Work File - ARG - 03B - 03B40WFBCRCCurrency Code - BaseStringGeneric Edit30
128F76AUI83Draft - Application Drafts - Invoices Work File - ARG - 76A18WFBCRCCurrency Code - BaseStringGeneric Edit30
TOP76B: Brazil - Reporting System Only
129F76B401DIRF WorkTable - BRA - 76B8DIBCRCCurrency Code - BaseStringGeneric Edit30
TOP76C: Colombia
130F76C031AA/R Customer ledger As Of - F76C031A - COL - 0431RPBCRCCurrency Code - BaseStringGeneric Edit30
131F76C034AA/R Check Detail file As Of - COL - 03B29RZBCRCCurrency Code - BaseStringGeneric Edit30
TOP76M: Mexico
132F76M0314Receipt Detail Tag File - Mexico19MABCRCCurrency Code - BaseStringGeneric Edit30
133F76M0414F0414 - Payment Detail Tag File - Mexico19RTBCRCCurrency Code - BaseStringGeneric Edit30
134F76M311AR Soft Rounding VAT - Mexico11MBBCRCCurrency Code - BaseStringGeneric Edit30
135F76M411Soft Rounding VAT Calculation10RSBCRCCurrency Code - BaseStringGeneric Edit30
136F76M930AR VAT on Gain/loss MEX - 76M22APBCRCCurrency Code - BaseStringGeneric Edit30
137F76M940AP VAT on Gain/loss - MEX - 76M13APBCRCCurrency Code - BaseStringGeneric Edit30
138F76M990GL VAT on Gain/loss MEX - 76M28GLBCRCCurrency Code - BaseStringGeneric Edit30
TOP79A: Greenhouse Gas Accounting
139F79A11GHG Ledger51GRBCRCCurrency Code - BaseStringGeneric Edit30
140F79A11Z1GHG Ledger - Batch File59GLBCRCCurrency Code - BaseStringGeneric Edit30
141F79A12GHG Ledger Audit52GRBCRCCurrency Code - BaseStringGeneric Edit30
142F79AU11GHG Ledger Work Table55GRBCRCCurrency Code - BaseStringGeneric Edit30