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
2F9671SDSoftware Update Detail Table
3F0101ABAddress Book Master
4F4101IMItem Master
5F0911GLAccount Ledger
6F4311PDPurchase Order Detail File
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F03012AICustomer Master by Line of Business
10F41021LIItem Location File

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
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F0411RPAccounts Payable Ledger
4F4311PDPurchase Order Detail File
5F4211SDSales Order Detail File
6F42119SDSales Order History File
7F0006MCBusiness Unit Master
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

27 columns | Print definition?812 | CBNK

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0030Bank Transit Number Master File3AYCBNKBank Account Number - CustomerStringGeneric Edit200
2F004201Prepayment Transaction Table30PTCBNKBank Account Number - CustomerStringGeneric Edit200
TOP03: Accounts Receivable
3F0312A/R Batch Cash Application35RUCBNKBank Account Number - CustomerStringGeneric Edit200
TOP03B: Enhanced Accounts Receivable
4F03B13Receipts Header File55RYCBNKBank Account Number - CustomerStringGeneric Edit200
5F03B13PReceipts Header Purge File55RYCBNKBank Account Number - CustomerStringGeneric Edit200
6F03B13Z1Electronic Receipts Input38RUCBNKBank Account Number - CustomerStringGeneric Edit200
7F03B13Z2F03B13 Interoperability Table68SYCBNKBank Account Number - CustomerStringGeneric Edit200
8F03B672Draft Remittance Work File - One World Only54RDCBNKBank Account Number - CustomerStringGeneric Edit200
TOP04: Accounts Payable
9F0413Accounts Payable - Matching Document18RMCBNKBank Account Number - CustomerStringGeneric Edit200
10F0413AWF - As Of - Accounts Payable Payment Register18RMCBNKBank Account Number - CustomerStringGeneric Edit200
11F0413PPurge - Accounts Payable Matching Documents18RMCBNKBank Account Number - CustomerStringGeneric Edit200
12F0413Z1F0413 Interoperability Table33SYCBNKBank Account Number - CustomerStringGeneric Edit200
13F04572A/P Payment Processing - Summary File22KKCBNKBank Account Number - CustomerStringGeneric Edit200
14F0474N1A/P Enterprise Info. - Sweden BGI/BGU1QBCBNKBank Account Number - CustomerStringGeneric Edit200
TOP09: General Accounting
15F0917Bank Statement Detail22GDCBNKBank Account Number - CustomerStringGeneric Edit200
TOP47: Electronic Commerce
16F470472EDI Invoice Expanded Detail (Sales)21S6CBNKBank Account Number - CustomerStringGeneric Edit200
17F470561EDI Payment Order Bank N and A - Outbound36D2CBNKBank Account Number - CustomerStringGeneric Edit200
18F470561WEDI Payment Order Bank N and A - Work36D2CBNKBank Account Number - CustomerStringGeneric Edit200
19F470562EDI Payment Order Vendor N and A - Outbound36D4CBNKBank Account Number - CustomerStringGeneric Edit200
20F470562WEDI Payment Order Vendor N and A - Work36D4CBNKBank Account Number - CustomerStringGeneric Edit200
21F470563EDI Payment Order Payee N and A - Outbound36D5CBNKBank Account Number - CustomerStringGeneric Edit200
22F470563WEDI Payment Order Payee N and A - Work36D5CBNKBank Account Number - CustomerStringGeneric Edit200
23F47113EDI Lockbox/Payment Detail - Batch18Z3CBNKBank Account Number - CustomerStringGeneric Edit200
TOP55: Reserved for Clients
24F7460Next Auto Debit Number4QLCBNKBank Account Number - CustomerStringGeneric Edit200
TOP74: EMEA Localization
25F74030GGermany-Bank Transit Number Master File Addtl Information3AYCBNKBank Account Number - CustomerStringGeneric Edit200
TOP76C: Colombia
26F76C572DIAN File Type 2 (a) - COL - 0411R2CBNKBank Account Number - CustomerStringGeneric Edit200
27F76C575Work File Magnetic Media - COL - 0435Q1CBNKBank Account Number - CustomerStringGeneric Edit200