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
7F0902GBAccount Balances
8F42119SDSales Order History File
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

83 tables920 | 09

09: General Accounting
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F0050AMA491Structure Definition FileExtra Features Files09: General AccountingBusiness Data
2920F0901GM8415Account MasterMaster Files09: General AccountingBusiness Data
3920F0901CGM211Account Category CodesFiles09: General Accounting
4920F0901DLK32Account Master - Alternate DescriptionExtra Features Files09: General AccountingBusiness Data
5920F0902BGB822Account Balances - 52 Period AccountingExtra Features Files09: General AccountingBusiness Data
6920F0902PGB561Purge - Account BalancesPurge Files09: General AccountingBusiness Data
7920F0902Z1GB461Account Balances - Batch FileBatch Input Files09: General AccountingBusiness Data
8920F0907GY112Chart of Accounts FormatConstants Files09: General AccountingBusiness Data
9920F0909AC62Chart of Accounts - Reference FileExtra Features Files09: General AccountingBusiness Data
10920F0911PGL1411Purge - Account LedgerPurge Files09: General AccountingBusiness Data
11920F0911RGL896WF - Account Ledger ReconciliationRegular Work Files09: General AccountingBusiness Data
12920F0911R1GL91Account Reconciliations Header - OneWorld ONLYRegular Work Files09: General AccountingBusiness Data
13920F0911SWGS91Account Ledger Summary Work TableFiles09: General Accounting
14920F0911Z1VN1934Journal Entry Transactions - Batch FileBatch Input Files09: General AccountingBusiness Data
15920F0911Z4SZ1681F0911 Interoperability TableBatch Input Files09: General AccountingBusiness Data
16920F0912RJ531Cost Allocations/Flex BudgetingExtra Features Files09: General AccountingBusiness Data
17920F09123VN653Advanced Variable NumeratorFiles09: General Accounting
18920F09123ABO101Advanced Variable Numerator Busines Unit OverrideFiles09: General Accounting
19920F0912ARI623Index Computation Entry FileExtra Features Files09: General AccountingBusiness Data
20920F0912BR#591Variable Allocation FileExtra Features Files09: General AccountingBusiness Data
21920F0916GH191Bank Statement HeaderExtra Features Files09: General AccountingBusiness Data
22920F0917GD555Bank Statement DetailExtra Features Files09: General AccountingBusiness Data
23920F09218LS161Online Consolidations Set-up FileExtra Features Files09: General AccountingBusiness Data
24920F092181LR112Online Consolidation Detail FileExtra Features Files09: General AccountingBusiness Data
25920F09300FR1085OVFS Report TableFiles09: General Accounting
26920F09301FS322Submitted One View Financial Statements TableFiles09: General Accounting
27920F09302OC231OVFS ConstantsFiles09: General Accounting
28920F09305GR81OVFS Row Definition Grouping Elements TableFiles09: General AccountingBusiness Data
29920F09310RS651OVFS Row Definition Setup TableFiles09: General Accounting
30920F09320CS341OVFS Column Definition Setup TableFiles09: General Accounting
31920F09330RT654OVFS Statement Definition Setup TableFiles09: General Accounting
32920F09340VS441OVFS Statement Version Setup TableFiles09: General Accounting
33920F09350WRW293OVFS Row Definition Work TableFiles09: General Accounting
34920F09360WCL144OVFS Column List Work TableFiles09: General Accounting
35920F09370WBW483OVFS Balance Work TableFiles09: General Accounting
36920F09380WCB183OVFS Column Balance Work TableFiles09: General Accounting
37920F09505GN51WF - Bank File of Cleared Checks.Regular Work Files09: General AccountingBusiness Data
38920F095051GN11Bank File OF Cleared Checks - Flat File OneWorldONLYRegular Work Files09: General AccountingBusiness Data
39920F09521FR523Cash Type RulesFiles09: General Accounting
40920F09522FD366Cash Forecast DataFiles09: General Accounting
41920F09523FS166Cash Forecast Reporting StructuresFiles09: General Accounting
42920F09525FB52Cash Forecast Bank AccountsFiles09: General Accounting
43920F09610SG383Electronic Bank Statement Staging HeaderFiles09: General Accounting
44920F09611BG253Electronic Bank Statement Staging DetailFiles09: General Accounting
45920F09616GN264Auto Bank Statement HeaderFiles09: General Accounting
46920F09617GM544Auto Bank Statement DetailFiles09: General Accounting
47920F09621GS111Bank Account Cross ReferenceFiles09: General Accounting
48920F09622TT121Transaction Type Cross ReferenceFiles09: General Accounting
49920F09626GR301Auto Reconciliation Rules SetupFiles09: General Accounting
50920F09627GG91Auto Reconciliation Group SetupFiles09: General Accounting
51920F09628GA131Auto Bank Statement Account SetupFiles09: General Accounting
52920F097021WTA202Account Ledger to Account Master Work TableFiles09: General Accounting
53920F097031WAB311Account Balance to Account Master Work TableFiles09: General Accounting
54920F097041WAB102Accounts to Business Units Work TableFiles09: General Accounting
55920F09706WNB81Batch and Company Within Batch Out of Balance Work TableFiles09: General Accounting
56920F09UI004R#191Variable Numerator Allocations work file"T" Work Files09: General AccountingBusiness Data
57920F09UI007GL191Match Bank Tape to Recon File - ONE WORLD ONLY"T" Work Files09: General AccountingBusiness Data
58920F09UI008GM111Global Business Unit Change"T" Work Files09: General AccountingBusiness Data
59920F09UI009GB691Trial Balance Generic Work File - OneWorld ONLY"T" Work Files09: General AccountingBusiness Data
60920F09UI010WF124WorkFile for R097011"T" Work Files09: General AccountingBusiness Data
61920F09UI013GL51Company by Batch Out of Balance"T" Work Files09: General AccountingBusiness Data
62920F09UI014GB112Annual Close Work TableWork Files09: General AccountingBusiness Data
63920F09UI015GL1042Indexed Computations Multi-Tiered EntriesWork Files09: General AccountingBusiness Data
64920F09UI016GW212Account Balance Compare ExceptionsWork Files09: General Accounting
65920F09UI017FW441Cash Forecast DetailFiles09: General Accounting
66920F09UI123VW321Advanced Variable Numerator WorktableFiles09: General Accounting
67920F09UI124PG91Advanced Variable Numerator Pool Grouping WorktableFiles09: General Accounting
68920F09UI618NB445Auto Bank Statement Process Work TableFiles09: General Accounting
69920F11151CE165Currency Cross Rates Calculation MasterExtra Features Files09: General AccountingBusiness Data
70920F48S80SD123Segment DefinitionFiles09: General Accounting
71920F48S81CM111Burden Computation MethodFiles09: General Accounting
72920F48S82BR193Burden Base RulesFiles09: General Accounting
73920F48S83PD132Pool DefinitionFiles09: General Accounting
74920F48S84PG113Pool Grouping CodesFiles09: General Accounting
75920F48S85RT132Burden RatesFiles09: General Accounting
76920F52G02BS513Burdening Summarized LedgerFiles09: General Accounting
77920F52G11BD555Burdening Detail LedgerFiles09: General Accounting
78920F52G11WFBW541Temporary Burdened Detail Ledger WorkfileWork Files09: General Accounting
79920F52G31WFRB161Reburdening Transactions WorkfileFiles09: General Accounting
80920F52G32WPG41Pool Grouping Selection WorkfileWork Files09: General Accounting
81920F52G60BW375Burden Rate Calculations WorkfileFiles09: General Accounting
82920F70UI001WA302Work File for G/L by Cat. Code LocalizationWork Files09: General AccountingBusiness Data
83920F740911WA282Work File for G/L Report by Category Code LocalizationWork Files09: General AccountingBusiness Data