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

is JDE Date
Home | 910 | 09
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
9F4111ILItem Ledger File
10F4311PDPurchase Order Detail File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0006MCBusiness Unit Master
5F0411RPAccounts Payable Ledger
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

66 tables910 | 09

09: General Accounting
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F0050AMA491Structure Definition FileExtra Features Files09: General AccountingBusiness Data
2910F0901GM8415Account MasterMaster Files09: General AccountingBusiness Data
3910F0901CGM211Account Category CodesFiles09: General Accounting
4910F0901DLK32Account Master - Alternate DescriptionExtra Features Files09: General AccountingBusiness Data
5910F0902BGB822Account Balances - 52 Period AccountingExtra Features Files09: General AccountingBusiness Data
6910F0902PGB561Purge - Account BalancesPurge Files09: General AccountingBusiness Data
7910F0902Z1GB461Account Balances - Batch FileBatch Input Files09: General AccountingBusiness Data
8910F0907GY112Chart of Accounts FormatConstants Files09: General AccountingBusiness Data
9910F0909AC62Chart of Accounts - Reference FileExtra Features Files09: General AccountingBusiness Data
10910F0911PGL1411Purge - Account LedgerPurge Files09: General AccountingBusiness Data
11910F0911RGL896WF - Account Ledger ReconciliationRegular Work Files09: General AccountingBusiness Data
12910F0911R1GL91Account Reconciliations Header - OneWorld ONLYRegular Work Files09: General AccountingBusiness Data
13910F0911Z1VN1934Journal Entry Transactions - Batch FileBatch Input Files09: General AccountingBusiness Data
14910F0911Z4SZ1681F0911 Interoperability TableBatch Input Files09: General AccountingBusiness Data
15910F0912RJ531Cost Allocations/Flex BudgetingExtra Features Files09: General AccountingBusiness Data
16910F09123VN653Advanced Variable NumeratorFiles09: General Accounting
17910F09123ABO101Advanced Variable Numerator Busines Unit OverrideFiles09: General Accounting
18910F0912ARI623Index Computation Entry FileExtra Features Files09: General AccountingBusiness Data
19910F0912BR#591Variable Allocation FileExtra Features Files09: General AccountingBusiness Data
20910F0916GH191Bank Statement HeaderExtra Features Files09: General AccountingBusiness Data
21910F0917GD555Bank Statement DetailExtra Features Files09: General AccountingBusiness Data
22910F09218LS161Online Consolidations Set-up FileExtra Features Files09: General AccountingBusiness Data
23910F092181LR112Online Consolidation Detail FileExtra Features Files09: General AccountingBusiness Data
24910F09505GN51WF - Bank File of Cleared Checks.Regular Work Files09: General AccountingBusiness Data
25910F095051GN11Bank File OF Cleared Checks - Flat File OneWorldONLYRegular Work Files09: General AccountingBusiness Data
26910F09521FR523Cash Type RulesFiles09: General Accounting
27910F09522FD366Cash Forecast DataFiles09: General Accounting
28910F09523FS166Cash Forecast Reporting StructuresFiles09: General Accounting
29910F09525FB52Cash Forecast Bank AccountsFiles09: General Accounting
30910F09610SG383Electronic Bank Statement Staging HeaderFiles09: General Accounting
31910F09611BG253Electronic Bank Statement Staging DetailFiles09: General Accounting
32910F09616GN264Auto Bank Statement HeaderFiles09: General Accounting
33910F09617GM544Auto Bank Statement DetailFiles09: General Accounting
34910F09621GS111Bank Account Cross ReferenceFiles09: General Accounting
35910F09622TT121Transaction Type Cross ReferenceFiles09: General Accounting
36910F09626GR301Auto Reconciliation Rules SetupFiles09: General Accounting
37910F09627GG91Auto Reconciliation Group SetupFiles09: General Accounting
38910F09628GA131Auto Bank Statement Account SetupFiles09: General Accounting
39910F09UI004R#191Variable Numerator Allocations work file"T" Work Files09: General AccountingBusiness Data
40910F09UI007GL191Match Bank Tape to Recon File - ONE WORLD ONLY"T" Work Files09: General AccountingBusiness Data
41910F09UI008GM111Global Business Unit Change"T" Work Files09: General AccountingBusiness Data
42910F09UI009GB691Trial Balance Generic Work File - OneWorld ONLY"T" Work Files09: General AccountingBusiness Data
43910F09UI010WF124WorkFile for R097011"T" Work Files09: General AccountingBusiness Data
44910F09UI013GL51Company by Batch Out of Balance"T" Work Files09: General AccountingBusiness Data
45910F09UI014GB112Annual Close Work TableWork Files09: General AccountingBusiness Data
46910F09UI015GL1042Indexed Computations Multi-Tiered EntriesWork Files09: General AccountingBusiness Data
47910F09UI016GW212Account Balance Compare ExceptionsWork Files09: General Accounting
48910F09UI017FW441Cash Forecast DetailFiles09: General Accounting
49910F09UI123VW321Advanced Variable Numerator WorktableFiles09: General Accounting
50910F09UI124PG91Advanced Variable Numerator Pool Grouping WorktableFiles09: General Accounting
51910F09UI618NB445Auto Bank Statement Process Work TableFiles09: General Accounting
52910F11151CE165Currency Cross Rates Calculation MasterExtra Features Files09: General AccountingBusiness Data
53910F48S80SD123Segment DefinitionFiles09: General Accounting
54910F48S81CM111Burden Computation MethodFiles09: General Accounting
55910F48S82BR193Burden Base RulesFiles09: General Accounting
56910F48S83PD132Pool DefinitionFiles09: General Accounting
57910F48S84PG113Pool Grouping CodesFiles09: General Accounting
58910F48S85RT132Burden RatesFiles09: General Accounting
59910F52G02BS513Burdening Summarized LedgerFiles09: General Accounting
60910F52G11BD555Burdening Detail LedgerFiles09: General Accounting
61910F52G11WFBW541Temporary Burdened Detail Ledger WorkfileWork Files09: General Accounting
62910F52G31WFRB161Reburdening Transactions WorkfileFiles09: General Accounting
63910F52G32WPG41Pool Grouping Selection WorkfileWork Files09: General Accounting
64910F52G60BW375Burden Rate Calculations WorkfileFiles09: General Accounting
65910F70UI001WA302Work File for G/L by Cat. Code LocalizationWork Files09: General AccountingBusiness Data
66910F740911WA282Work File for G/L Report by Category Code LocalizationWork Files09: General AccountingBusiness Data

All references to JDE, JD Edwards and Oracle logos are trademarks of Oracle Corporation USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the Oracle Corporation or any of its affiliates.
About :: Terms :: Privacy