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
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

52 tables812 | 09

09: General Accounting
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F0050AMA491Structure Definition FileExtra Features Files09: General AccountingAS400 Coexistence Tables
2812F0901GM8214Account MasterMaster Files09: General AccountingAS400 Coexistence Tables
3812F0901CGM211Account Category CodesFiles09: General Accounting
4812F0901DLK31Account Master - Alternate DescriptionExtra Features Files09: General AccountingAS400 Coexistence Tables
5812F0902BGB822Account Balances - 52 Period AccountingExtra Features Files09: General AccountingAS400 Coexistence Tables
6812F0902PGB561Purge - Account BalancesPurge Files09: General AccountingAS400 Coexistence Tables
7812F0902Z1GB461Account Balances - Batch FileBatch Input Files09: General AccountingNo
8812F0907GY112Chart of Accounts FormatConstants Files09: General AccountingAS400 Coexistence Tables
9812F0909AC62Chart of Accounts - Reference FileExtra Features Files09: General AccountingNo
10812F0911PGL1341Purge - Account LedgerPurge Files09: General AccountingAS400 Coexistence Tables
11812F0911RGL762WF - Acct Ledger File for ReconciliationRegular Work Files09: General AccountingAS400 Coexistence Tables
12812F0911R1GL91Account Reconciliations Header - OneWorld ONLYRegular Work Files09: General AccountingNo
13812F0911Z1VN1864Journal Entry Transactions - Batch FileBatch Input Files09: General AccountingAS400 Coexistence Tables
14812F0911Z1TVN231Journal Entry Transactions - Batch Tag FileBatch Input Files09: General AccountingNo
15812F0911Z4SZ1611F0911 Interoperability TableBatch Input Files09: General AccountingNo
16812F0912RJ531Cost Allocations/Flex BudgetingExtra Features Files09: General AccountingAS400 Coexistence Tables
17812F0912ARI623Index Computation Entry FileExtra Features Files09: General AccountingAS400 Coexistence Tables
18812F0912BR#591Variable Allocation FileExtra Features Files09: General AccountingAS400 Coexistence Tables
19812F0916GH191Bank Statement HeaderExtra Features Files09: General AccountingAS400 Coexistence Tables
20812F0917GD555Bank Statement DetailExtra Features Files09: General AccountingAS400 Coexistence Tables
21812F0917SGD51Bank Statement Detail ExtensionExtra Features Files09: General AccountingNo
22812F09218LS161Online Consolidations Set-up FileExtra Features Files09: General AccountingAS400 Coexistence Tables
23812F092181LR112Online Consolidation Detail FileExtra Features Files09: General AccountingAS400 Coexistence Tables
24812F09505GN51WF - Bank File of Cleared Checks.Regular Work Files09: General AccountingAS400 Coexistence Tables
25812F095051GN11Bank File OF Cleared Checks - Flat File OneWorldONLYRegular Work Files09: General AccountingNo
26812F09521FR523Cash Type RulesFiles09: General Accounting
27812F09522FD366Cash Forecast DataFiles09: General Accounting
28812F09523FS166Cash Forecast Reporting StructuresFiles09: General Accounting
29812F09525FB52Cash Forecast Bank AccountsFiles09: General Accounting
30812F09610SG383Electronic Bank Statement Staging HeaderFiles09: General Accounting
31812F09611BG253Electronic Bank Statement Staging DetailFiles09: General Accounting
32812F09616GN264Auto Bank Statement HeaderFiles09: General Accounting
33812F09617GM544Auto Bank Statement DetailFiles09: General Accounting
34812F09621GS111Bank Account Cross ReferenceFiles09: General Accounting
35812F09622TT121Transaction Type Cross ReferenceFiles09: General Accounting
36812F09626GR301Auto Reconciliation Rules SetupFiles09: General Accounting
37812F09627GG91Auto Reconciliation Group SetupFiles09: General Accounting
38812F09628GA131Auto Bank Statement Account SetupFiles09: General Accounting
39812F09UI004R#191Variable Numerator Allocations work file"T" Work Files09: General AccountingNo
40812F09UI007GL191Match Bank Tape to Recon File - ONE WORLD ONLY"T" Work Files09: General AccountingNo
41812F09UI008GM111Global Business Unit Change"T" Work Files09: General AccountingNo
42812F09UI009GB691Trial Balance Generic Work File - OneWorld ONLY"T" Work Files09: General AccountingNo
43812F09UI010WF124WorkFile for R097011"T" Work Files09: General AccountingNo
44812F09UI013GL51Company by Batch Out of Balance"T" Work Files09: General AccountingNo
45812F09UI014GB112Annual Close Work TableWork Files09: General AccountingNo
46812F09UI015GL1042Indexed Computations Multi-Tiered EntriesWork Files09: General AccountingNo
47812F09UI016GW212Account Balance Compare ExceptionsWork Files09: General Accounting
48812F09UI017FW441Cash Forecast DetailFiles09: General Accounting
49812F09UI618NB445Auto Bank Statement Process Work TableFiles09: General Accounting
50812F11151CE165Currency Cross Rates Calculation MasterExtra Features Files09: General AccountingAS400 Coexistence Tables
51812F70UI001WA302Work File for G/L by Cat. Code LocalizationWork Files09: General AccountingNo
52812F740911WA282Work File for G/L Report by Category Code LocalizationWork Files09: General AccountingNo