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

812: Top 10 requests

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

45 columns | Print definition?910 | DMTJ

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP03: Accounts Receivable
1F0311Accounts Receivable Ledger10RPDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
2F0312A/R Batch Cash Application50RUDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
TOP03B: Enhanced Accounts Receivable
3F03B13Receipts Header5RYDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
4F03B13PReceipts Header Purge File5RYDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
5F03B13Z1Electronic Receipts Input27RUDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
6F03B13Z2F03B13 Interoperability Table18SYDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
7F03B14Receipts Detail10RZDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
8F03B14PReceipts Detail Purge File10RZDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
9F03B14Z2F03B14 Interoperability Table23SZDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
10F03B672Draft Remittance8RDDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
TOP04: Accounts Payable
11F0413Accounts Payable - Matching Document6RMDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
12F0413AWF - As Of Accounts Payable Payment Register6RMDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
13F0413PPurge - Accounts Payable Matching Documents6RMDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
14F0413Z1F0413 Interoperability Table20SYDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
TOP09: General Accounting
15F0917Bank Statement Detail30GDDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
16F09617Auto Bank Statement Detail36GMDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
TOP47: Electronic Commerce
17F47056EDI Payment Order Header - Outbound23D1DMTJDate - Matching Check or Item - JulianDateGeneric Edit60
18F47056WEDI Payment Order Header - Work23D1DMTJDate - Matching Check or Item - JulianDateGeneric Edit60
19F47057EDI Payment Order Remittance Advice - Outbound23D3DMTJDate - Matching Check or Item - JulianDateGeneric Edit60
20F47057WEDI Payment Order Remittance Advice - Work23D3DMTJDate - Matching Check or Item - JulianDateGeneric Edit60
21F47113EDI Lockbox/Payment Detail - Batch13Z3DMTJDate - Matching Check or Item - JulianDateGeneric Edit60
TOP70: Multi-National Products - obsolete-do not reuse
22F704001Payment WH Info TEMP - COMM - 0440PTDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
23F704002Payment WH Info - COMM - 0439PFDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
24F704002PPayment WH Info Purge - COMM - 0439PFDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
TOP74R: CIS
25F74R0018Russian Tax File - 74R67TDDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
26F74R311Prepayment Detail Tax File - RUS - 03B38DEDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
27F74RUI31VAT Sales Book Workfile - RUS - 03B19W1DMTJDate - Matching Check or Item - JulianDateGeneric Edit60
28F74RUI41VAT Purchase Book Workfile - RUS - 0416W1DMTJDate - Matching Check or Item - JulianDateGeneric Edit60
TOP74U: United Kingdom Localizations
29F74U4053Subcontractor Documents Detail - CIS Monthly Return - UK- 0412DMDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
TOP74Y: Italy - Reporting System Only
30F743B14ISuspended IVA Generation - Receipt/Rebate Control-Ita - 03B20TIDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
TOP75A: Australia - Reporting System Only
31F75A0220Payment Summary Workfile22PSDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
TOP75C: China - Reporting System Only
32F75C010WAP & AR XML Workfile - China -75C24AADMTJDate - Matching Check or Item - JulianDateGeneric Edit60
TOP75I: India
33F75I611TCS Prepayment Transaction File - IND-03B11TTDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
34F75IUI7Service Tax Credit Register - Work File - IND9WFDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
TOP75J: Japan - Reporting System Only
35F750411Withholding Tax Detail - Japan - 0414JXDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
TOP76A: Argentina
36F760472AF04572 Tag Table - ARG - 04 - 76A4K9DMTJDate - Matching Check or Item - JulianDateGeneric Edit60
37F760499AContract Withholding - Advances - ARG -04 - 76A3K8DMTJDate - Matching Check or Item - JulianDateGeneric Edit60
38F76A0444RG1547 Work File - ARG - 04 - 76A2WFDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
39F76A81A/P Payment Control Group File - ARG - 04 - 76A20C5DMTJDate - Matching Check or Item - JulianDateGeneric Edit60
40F76A8500Tag File F03B14 - ARG - 03B - 76A8TFDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
41F76AUI82Draft - Drafts Work File - ARG - 03B - 03B17WFDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
42F76AUI83Draft - Application Drafts - Invoices Work File - ARG - 76A27WFDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
43F76AUI89Work File to Generate ND/NC Gain/Loss - ARG - 03B - 76A19WFDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
TOP76C: Colombia
44F76C034AA/R Check Detail file As Of - COL - 03B10RZDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
TOP76P: Peru
45F76P472TF04572 Tag File - PER - 04 - 76P4K2DMTJDate - Matching Check or Item - JulianDateGeneric Edit60