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

160 columns | Print definition?920 | 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
6F03B117Revenue Recognition GL Info59RLBCRCCurrency Code - BaseStringGeneric Edit30
7F03B119Revenue Recognition GL Info Audit57RNBCRCCurrency Code - BaseStringGeneric Edit30
8F03B11PCustomer Ledger Purge File31RPBCRCCurrency Code - BaseStringGeneric Edit30
9F03B11SWCustomer Ledger Summary Work Table6CSBCRCCurrency Code - BaseStringGeneric Edit30
10F03B11Z2F03B11 Interoperability Table44SYBCRCCurrency Code - BaseStringGeneric Edit30
11F03B13Receipts Header24RYBCRCCurrency Code - BaseStringGeneric Edit30
12F03B13PReceipts Header Purge File24RYBCRCCurrency Code - BaseStringGeneric Edit30
13F03B13Z2F03B13 Interoperability Table37SYBCRCCurrency Code - BaseStringGeneric Edit30
14F03B14Receipts Detail31RZBCRCCurrency Code - BaseStringGeneric Edit30
15F03B14PReceipts Detail Purge File31RZBCRCCurrency Code - BaseStringGeneric Edit30
16F03B14Z2F03B14 Interoperability Table44SZBCRCCurrency Code - BaseStringGeneric Edit30
17F03B21A/R Notification History Detail19ZSBCRCCurrency Code - BaseStringGeneric Edit30
18F03B22A/R Fee Journal History13RSBCRCCurrency Code - BaseStringGeneric Edit30
19F03B23A/R Fee Journal History Detail12RTBCRCCurrency Code - BaseStringGeneric Edit30
20F03B40A/R Deduction Management28RBBCRCCurrency Code - BaseStringGeneric Edit30
21F03B41A/R Deduction Activity11RCBCRCCurrency Code - BaseStringGeneric Edit30
22F03B575Auto Debit Invoice Select and Build34RDBCRCCurrency Code - BaseStringGeneric Edit30
23F03B672Draft Remittance27RDBCRCCurrency Code - BaseStringGeneric Edit30
TOP04: Accounts Payable
24F0411Accounts Payable Ledger113RPBCRCCurrency Code - BaseStringGeneric Edit30
25F0411AWF - 'As Of' Accounts Payable Ledger113RPBCRCCurrency Code - BaseStringGeneric Edit30
26F0411PPurge - Accounts Payable Ledger113RPBCRCCurrency Code - BaseStringGeneric Edit30
27F0411SWSupplier Ledger Summary Work Table6SSBCRCCurrency Code - BaseStringGeneric Edit30
28F0411Z1Voucher Transactions - Batch Upload160VLBCRCCurrency Code - BaseStringGeneric Edit30
29F0411Z3F0411 Interoperability Table167SZBCRCCurrency Code - BaseStringGeneric Edit30
30F0414Accounts Payable Matching Document Detail36RNBCRCCurrency Code - BaseStringGeneric Edit30
31F0414AWF - 'As Of' Accounts Payable Payment Detail38RNBCRCCurrency Code - BaseStringGeneric Edit30
32F0414PPurge - Accounts Payable Matching Document Detail36RNBCRCCurrency Code - BaseStringGeneric Edit30
33F0414Z1F0414 Interoperability Table56SZBCRCCurrency Code - BaseStringGeneric Edit30
34F04573A/P Payment Processing - Detail46KIBCRCCurrency Code - BaseStringGeneric Edit30
35F09UI005Tax Offsets User Index42GLBCRCCurrency Code - BaseStringGeneric Edit30
TOP09: General Accounting
36F0911PPurge - Account Ledger124GLBCRCCurrency Code - BaseStringGeneric Edit30
37F0911RWF - Account Ledger Reconciliation59GLBCRCCurrency Code - BaseStringGeneric Edit30
38F0911Z1Journal Entry Transactions - Batch File175VNBCRCCurrency Code - BaseStringGeneric Edit30
39F0911Z4F0911 Interoperability Table155SZBCRCCurrency Code - BaseStringGeneric Edit30
40F09521Cash Type Rules12FRBCRCCurrency Code - BaseStringGeneric Edit30
41F09522Cash Forecast Data5FDBCRCCurrency Code - BaseStringGeneric Edit30
42F09UI017Cash Forecast Detail9FWBCRCCurrency Code - BaseStringGeneric Edit30
TOP15: Real Estate Management
43F151991G/L Transaction A/R Application Work File20NBBCRCCurrency Code - BaseStringGeneric Edit30
44F15199WG/L Transaction Summarization Work File12NBBCRCCurrency Code - BaseStringGeneric Edit30
45F1540BSales Report Control46NRBCRCCurrency Code - BaseStringGeneric Edit30
46F1542Projected Sales42OJBCRCCurrency Code - BaseStringGeneric Edit30
TOP15L: Adv Real Estate Forecasting
47F15L301AREF Projected Sales43PSBCRCCurrency Code - BaseStringGeneric Edit30
TOP40: Inventory/OP Base
48F4001ZBatch Receiver File - Order Headings136SYBCRCCurrency Code - BaseStringGeneric Edit30
49F4201Z1Sales Order Header Unedited Transaction File124SYBCRCCurrency Code - BaseStringGeneric Edit30
50F4211Z1Sales Order Detail Unedited Transaction File245SZBCRCCurrency Code - BaseStringGeneric Edit30
51F43800Summary Voucher Match18PRBCRCCurrency Code - BaseStringGeneric Edit30
TOP42: Sales Management
52F4201Sales Order Header File112SHBCRCCurrency Code - BaseStringGeneric Edit30
53F42019Sales Order Header History File112SHBCRCCurrency Code - BaseStringGeneric Edit30
54F4211Sales Order Detail File232SDBCRCCurrency Code - BaseStringGeneric Edit30
55F42119Sales Order History File232SDBCRCCurrency Code - BaseStringGeneric Edit30
56F42199S.O. Detail Ledger File232SLBCRCCurrency Code - BaseStringGeneric Edit30
57F42UI01SO Header Cache File (MBF)150ZHBCRCCurrency Code - BaseStringGeneric Edit30
58F42UI12Sales Order Detail Cache 2 (MBF)88ZDBCRCCurrency Code - BaseStringGeneric Edit30
59F47027TTag for F47027 - EDI P.O. Acknowledgment Detail - Outbound2UZBCRCCurrency Code - BaseStringGeneric Edit30
60F47047TTag for F47047- EDI Invoice Detail (Sales) - Outbound2UZBCRCCurrency Code - BaseStringGeneric Edit30
61F47107TTag for F47107- EDI Response to RFQ Detail - Outbound2UZBCRCCurrency Code - BaseStringGeneric Edit30
62F47147TTag F47147 - EDI P.O. Change Acknowledgment Detail-Outbound2UZBCRCCurrency Code - BaseStringGeneric Edit30
TOP42B: Sales Order Entry
63F4011ZTBatch Receiver File - Order Details Tag25UZBCRCCurrency Code - BaseStringGeneric Edit30
64F47012TEDI Purchase Order Detail Tag - Inbound25UZBCRCCurrency Code - BaseStringGeneric Edit30
65F47092TEDI Request for Quote Detail Tag - Inbound25UZBCRCCurrency Code - BaseStringGeneric Edit30
66F47132TEDI Purchase Order Change Detail Tag - Inbound25UZBCRCCurrency Code - BaseStringGeneric Edit30
TOP42I: Outbound Inventory Management
67F42I015Outbound Inventory Agreement Transaction File46OIBCRCCurrency Code - BaseStringGeneric Edit30
TOP43: Procurement
68F4301Purchase Order Header88PHBCRCCurrency Code - BaseStringGeneric Edit30
69F4301Z1Purchase Order Header Unedited Transaction Table105SYBCRCCurrency Code - BaseStringGeneric Edit30
70F4311Purchase Order Detail File206PDBCRCCurrency Code - BaseStringGeneric Edit30
71F4311Z1Purchase Order Detail Unedited Transaction Table226SZBCRCCurrency Code - BaseStringGeneric Edit30
72F43121Purchase Order Receiver File106PRBCRCCurrency Code - BaseStringGeneric Edit30
73F43121ZReceiver workfile164PWBCRCCurrency Code - BaseStringGeneric Edit30
74F43121Z1Receipts Unedited Transaction Table196SZBCRCCurrency Code - BaseStringGeneric Edit30
75F43199P.O. Detail Ledger File - Flexible Version207OLBCRCCurrency Code - BaseStringGeneric Edit30
76F4322Purchasing Tolerance Rules14PZBCRCCurrency Code - BaseStringGeneric Edit30
TOP45: Advanced Pricing
77F4576Ship and Debit Claims28ACBCRCCurrency Code - BaseStringGeneric Edit30
78F4576TMPShip and Debit Claims- Temp Table28ACBCRCCurrency Code - BaseStringGeneric Edit30
79F4576Z1Ship and Debit Claims Unedited Transaction Table41Z1BCRCCurrency Code - BaseStringGeneric Edit30
TOP47: Electronic Commerce
80F47011EDI Purchase Order Header - Inbound124SYBCRCCurrency Code - BaseStringGeneric Edit30
81F47016EDI Purchase Order Header - Outbound108SYBCRCCurrency Code - BaseStringGeneric Edit30
82F47017EDI Purchase Order Detail - Outbound217SZBCRCCurrency Code - BaseStringGeneric Edit30
83F47021EDI P.O. Acknowledgment Header - Inbound108SYBCRCCurrency Code - BaseStringGeneric Edit30
84F47022EDI P.O. Acknowledgment Detail - Inbound217SZBCRCCurrency Code - BaseStringGeneric Edit30
85F47026EDI P.O. Acknowledgment Header - Outbound117SYBCRCCurrency Code - BaseStringGeneric Edit30
86F47031EDI Shipping Notice Header - Inbound102SYBCRCCurrency Code - BaseStringGeneric Edit30
87F47032TEDI Shipping Notice Detail- Inbound Tag4SZBCRCCurrency Code - BaseStringGeneric Edit30
88F47036EDI Shipping Notice Header - Outbound40SYBCRCCurrency Code - BaseStringGeneric Edit30
89F470371EDI Shipping Notice Detail - Outbound99SZBCRCCurrency Code - BaseStringGeneric Edit30
90F47046EDI Invoice Header (Sales) - Outbound105SYBCRCCurrency Code - BaseStringGeneric Edit30
91F47071EDI Receiving Advice Header - Inbound101SYBCRCCurrency Code - BaseStringGeneric Edit30
92F47072EDI Receiving Advice Detail - Inbound205SZBCRCCurrency Code - BaseStringGeneric Edit30
93F47076EDI Receiving Advice Header - Outbound101SYBCRCCurrency Code - BaseStringGeneric Edit30
94F47077EDI Receiving Advice Detail - Outbound205SZBCRCCurrency Code - BaseStringGeneric Edit30
95F47091EDI Request for Quote Header - Inbound124SYBCRCCurrency Code - BaseStringGeneric Edit30
96F47096EDI Request for Quote Header - Outbound109SYBCRCCurrency Code - BaseStringGeneric Edit30
97F47097EDI Request for Quote Detail - Outbound217SZBCRCCurrency Code - BaseStringGeneric Edit30
98F47101EDI Response to RFQ Header - Inbound109SYBCRCCurrency Code - BaseStringGeneric Edit30
99F47102EDI Response to RFQ Detail - Inbound217SZBCRCCurrency Code - BaseStringGeneric Edit30
100F47106EDI Response to RFQ Header - Outbound121SYBCRCCurrency Code - BaseStringGeneric Edit30
101F47131EDI Purchase Order Change Header - Inbound121SYBCRCCurrency Code - BaseStringGeneric Edit30
102F47136EDI Purchase Order Change Header - Outbound108SYBCRCCurrency Code - BaseStringGeneric Edit30
103F47141EDI P.O. Change Acknowledgment Header - Inbound109SYBCRCCurrency Code - BaseStringGeneric Edit30
104F47142EDI P.O. Change Acknowledgment Detail - Inbound219SZBCRCCurrency Code - BaseStringGeneric Edit30
105F47146EDI P.O. Change Acknowledgment Header - Outbound122SYBCRCCurrency Code - BaseStringGeneric Edit30
106F47156EDI Shipping Schedule Header - Outbound86SYBCRCCurrency Code - BaseStringGeneric Edit30
107F47157EDI Shipping Schedule Detail - Outbound88SZBCRCCurrency Code - BaseStringGeneric Edit30
TOP51X: In-Memory Project Management
108F51X0911Account Ledger Worktable11ALBCRCCurrency Code - BaseStringGeneric Edit30
TOP54R: Rental Management
109F54R099Rental Contract Header Ledger76HLBCRCCurrency Code - BaseStringGeneric Edit30
110F54R10Rental Contract Header74CHBCRCCurrency Code - BaseStringGeneric Edit30
111F54R11Rental Contract Detail117CDBCRCCurrency Code - BaseStringGeneric Edit30
112F54R199Rental Contract Detail Ledger113DLBCRCCurrency Code - BaseStringGeneric Edit30
TOP70: Multi-National Products
113F7001100Localizations Additional Fields AB - 0154LABCRCCurrency Code - BaseStringGeneric Edit30
114F7003B11Localizations Additional Fields Customer Ledger - 0157LABCRCCurrency Code - BaseStringGeneric Edit30
115F700411Localizations Additional Fields Accounts Payable Ledger - 0458LABCRCCurrency Code - BaseStringGeneric Edit30
116F702018Taxes by Sales Order Line - COMM - 4213TABCRCCurrency Code - BaseStringGeneric Edit30
117F704001Payment WH Info TEMP - COMM - 0451PTBCRCCurrency Code - BaseStringGeneric Edit30
118F704002Payment WH Info - COMM - 0450PFBCRCCurrency Code - BaseStringGeneric Edit30
119F704002PPayment WH Info Purge - COMM - 0450PFBCRCCurrency Code - BaseStringGeneric Edit30
120F704003Payment Done - Accum - COMM - 0414PDBCRCCurrency Code - BaseStringGeneric Edit30
121F704008Localizations Additional Fields Tax Area - 0453LABCRCCurrency Code - BaseStringGeneric Edit30
122F704101ALocalizations Additional Fields Item Master - 0154LABCRCCurrency Code - BaseStringGeneric Edit30
123F704201Localizations Additional Fields Sales Order - 0156LABCRCCurrency Code - BaseStringGeneric Edit30
TOP74: EMEA Localization
124F74093Worktable for Printing IVA Summary - Italy67HCBCRCCurrency Code - BaseStringGeneric Edit30
125F74900Foreign Receivables and Payables - EMEA38RPBCRCCurrency Code - BaseStringGeneric Edit30
TOP74H: Hungary
126F74H910JE VAT Differences - HUN - 0918VDBCRCCurrency Code - BaseStringGeneric Edit30
TOP74R: Russia
127F74R311Prepayment Detail Tax File - RUS - 03B20DEBCRCCurrency Code - BaseStringGeneric Edit30
TOP74S: Spain
128F74S79Model 347 - Record Type 2 - Spain Tag File10TQBCRCCurrency Code - BaseStringGeneric Edit30
TOP75C: China
129F75C010WAP & AR XML Workfile - China -75C13AABCRCCurrency Code - BaseStringGeneric Edit30
130F75C014AP/AR Balances - China8BABCRCCurrency Code - BaseStringGeneric Edit30
TOP75I: India
131F75I611TCS Prepayment Transaction File - IND-03B28TTBCRCCurrency Code - BaseStringGeneric Edit30
132F75I732Service Tax A/R File Additional Info - IND - 03B10STBCRCCurrency Code - BaseStringGeneric Edit30
133F75I742Service Tax A/P File Additional Info - IND - 0411STBCRCCurrency Code - BaseStringGeneric Edit30
TOP75T: Taiwan
134F75T004GUI/VAT Transaction Header - 75T19THBCRCCurrency Code - BaseStringGeneric Edit30
135F75T0049GUI/VAT Transaction Header History - 75T19THBCRCCurrency Code - BaseStringGeneric Edit30
136F75T004PGUI/VAT Transaction Header POS - 75T18THBCRCCurrency Code - BaseStringGeneric Edit30
137F75T004ZGUI/VAT Transaction Header - Work - 75T17ZHBCRCCurrency Code - BaseStringGeneric Edit30
138F75T005GUI/VAT Transaction Detail - 75T15TDBCRCCurrency Code - BaseStringGeneric Edit30
139F75T0059GUI/VAT Transaction Detail History - 75T15TDBCRCCurrency Code - BaseStringGeneric Edit30
140F75T005PGUI/VAT Transaction Detail POS - 75T15TDBCRCCurrency Code - BaseStringGeneric Edit30
141F75T005TGUI/VAT Transaction Detail Temp - 75T15TDBCRCCurrency Code - BaseStringGeneric Edit30
142F75T005ZGUI/VAT Transaction Detail - Work - 75T22ZDBCRCCurrency Code - BaseStringGeneric Edit30
TOP76A: Argentina
143F76A40Withholding Certificates Legal Number - 76A13WCBCRCCurrency Code - BaseStringGeneric Edit30
144F76A55Withholding Certificates Legal Number History Files - 76A8HWBCRCCurrency Code - BaseStringGeneric Edit30
145F76AUI82Draft - Drafts Work File - ARG - 03B - 03B40WFBCRCCurrency Code - BaseStringGeneric Edit30
146F76AUI83Draft - Application Drafts - Invoices Work File - ARG - 76A18WFBCRCCurrency Code - BaseStringGeneric Edit30
TOP76B: Brazil
147F76B401DIRF WorkTable - BRA - 76B8DIBCRCCurrency Code - BaseStringGeneric Edit30
TOP76C: Colombia
148F76C031AA/R Customer ledger As Of - F76C031A - COL - 0431RPBCRCCurrency Code - BaseStringGeneric Edit30
149F76C034AA/R Check Detail file As Of - COL - 03B29RZBCRCCurrency Code - BaseStringGeneric Edit30
TOP76M: Mexico
150F76M0314Receipt Detail Tag File - Mexico19MABCRCCurrency Code - BaseStringGeneric Edit30
151F76M0414F0414 - Payment Detail Tag File - Mexico19RTBCRCCurrency Code - BaseStringGeneric Edit30
152F76M311AR Soft Rounding VAT - Mexico11MBBCRCCurrency Code - BaseStringGeneric Edit30
153F76M411Soft Rounding VAT Calculation10RSBCRCCurrency Code - BaseStringGeneric Edit30
154F76M930AR VAT on Gain/loss MEX - 76M22APBCRCCurrency Code - BaseStringGeneric Edit30
155F76M940AP VAT on Gain/loss - MEX - 76M13APBCRCCurrency Code - BaseStringGeneric Edit30
156F76M990GL VAT on Gain/loss MEX - 76M28GLBCRCCurrency Code - BaseStringGeneric Edit30
TOP79A: Greenhouse Gas Accounting
157F79A11GHG Ledger51GRBCRCCurrency Code - BaseStringGeneric Edit30
158F79A11Z1GHG Ledger - Batch File59GLBCRCCurrency Code - BaseStringGeneric Edit30
159F79A12GHG Ledger Audit52GRBCRCCurrency Code - BaseStringGeneric Edit30
160F79AU11GHG Ledger Work Table55GRBCRCCurrency Code - BaseStringGeneric Edit30