JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides | 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
10F07831YBEmployee State/Local Control Table

812: Top 10 requests

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

101 tables812 | 00

00: Foundation Environment
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F0000194SY51Generic Interface Table for B0000194Files00: Foundation EnvironmentNo
2812F0002NN311Next Numbers - AutomaticConstants Files00: Foundation EnvironmentControl Tables
3812F00021NL101Next Numbers by Company/Fiscal Year - AutomaticConstants Files00: Foundation EnvironmentControl Tables
4812F00022UK21Unique Key File - Next Available Unique KeyConstants Files41: Inventory ManagementAS400 Coexistence Tables
5812F00023DN245Distributed Next Number TableMaster Files42: Sales ManagementNo
6812F0006MC1205Business Unit MasterMaster Files00: Foundation EnvironmentAS400 Coexistence Tables
7812F0006DLJ71Business Unit Alternate Description MasterExtra Features Files00: Foundation EnvironmentAS400 Coexistence Tables
8812F0006SMC1251Date Effective Business Unit MasterExtra Features Files00: Foundation EnvironmentNo
9812F0006S1SH81Business Unit Snapshot HeaderExtra Features Files00: Foundation EnvironmentNo
10812F0006Z1SZ1361Cost Center Unedited Transaction TableBatch Input Files00: Foundation EnvironmentNo
11812F0007CZ433Work Day CalendarExtra Features Files30: Product Data ManagementAS400 Coexistence Tables
12812F0008CD252Date Fiscal PatternsConstants Files00: Foundation EnvironmentAS400 Coexistence Tables
13812F00085DS181Daylight Savings RulesConstants FilesH91: Design ToolsSystem Tables
14812F0008BCD631Date Fiscal Patterns - 52 Period AccountingConstants Files00: Foundation EnvironmentAS400 Coexistence Tables
15812F0009GC651General ConstantsConstants Files00: Foundation EnvironmentAS400 Coexistence Tables
16812F00090T1221Supplemental Database SetupConstants Files41: Inventory ManagementAS400 Coexistence Tables
17812F00090DT581Supplemental Database Language PreferencesTransaction Files41: Inventory ManagementAS400 Coexistence Tables
18812F00091T2341Supplemental Database Data TypesTransaction Files41: Inventory ManagementAS400 Coexistence Tables
19812F00092T3305Supplemental DataTransaction Files41: Inventory ManagementAS400 Coexistence Tables
20812F00093FM122Flash MessagesExtra Features Files00: Foundation EnvironmentNo
21812F00094T1101CTI PropertiesExtra Features Files00: Foundation EnvironmentNo
22812F00095A173Business Object ReservationExtra Features Files00: Foundation EnvironmentNo
23812F00096M0371Default Media Object Category by TableExtra Features Files42: Sales ManagementNo
24812F00098ED91Enable Distributed Next NumnerFiles42: Sales ManagementNo
25812F0010CC654Company ConstantsConstants Files00: Foundation EnvironmentAS400 Coexistence Tables
26812F0011IC241Batch Control RecordsExtra Features Files00: Foundation EnvironmentAS400 Coexistence Tables
27812F0011WIC51F0011W - WF - Batch To DetailFiles09: General Accounting
28812F0012KG202Automatic Accounting Instructions MasterConstants Files00: Foundation EnvironmentAS400 Coexistence Tables
29812F0012DLJ81AAI Alternate Description MasterExtra Features Files00: Foundation EnvironmentAS400 Coexistence Tables
30812F0013CV101Currency CodesExtra Features Files00: Foundation EnvironmentAS400 Coexistence Tables
31812F0014PN161Payment TermsConstants Files03B: Enhanced Accounts ReceivableAS400 Coexistence Tables
32812F00141L353Advanced Payment TermsConstants Files03B: Enhanced Accounts ReceivableAS400 Coexistence Tables
33812F00142L4231Due Date RulesConstants Files03B: Enhanced Accounts ReceivableAS400 Coexistence Tables
34812F00143L561Due Date Rules Day RangeConstants Files03B: Enhanced Accounts ReceivableAS400 Coexistence Tables
35812F00144L663Installment Payment TermsConstants Files03B: Enhanced Accounts ReceivableAS400 Coexistence Tables
36812F00147L8161Multi-Tiered Payment TermsConstants Files03B: Enhanced Accounts ReceivableNo
37812F00151T161Currency Exchange Rates (F0015 Header)Extra Features Files11: Multi CurrencyAS400 Coexistence Tables
38812F00171NC41Interoperability-Net Change TableFiles00: Foundation EnvironmentNo
39812F0018TD685Sales/Use/V.A.T. Tax FileExtra Features Files00: Foundation EnvironmentAS400 Coexistence Tables
40812F00189TG202WF - Tax ReconciliationRegular Work Files00: Foundation EnvironmentAS400 Coexistence Tables
41812F0018RED272Tax Reconciliation RepositoryFiles09: General Accounting
42812F0019CG61Generic Message/Rate TypesExtra Features Files48: Work Order ProcessingAS400 Coexistence Tables
43812F00191CE61Generic Message/RatesExtra Features Files48: Work Order ProcessingAS400 Coexistence Tables
44812F00192CF51General Message DetailExtra Features Files48: Work Order ProcessingAS400 Coexistence Tables
45812F0022VA111Tax RulesConstants Files00: Foundation EnvironmentAS400 Coexistence Tables
46812F0024UG22Batch Approval / Post Security FileExtra Features Files00: Foundation EnvironmentAS400 Coexistence Tables
47812F0025LH282Ledger Type Master FileConstants Files00: Foundation EnvironmentAS400 Coexistence Tables
48812F0026CL181Job Cost ConstantsConstants Files51: Job CostingAS400 Coexistence Tables
49812F0028TE101Sales Tax Work File by Taxing AuthorityRegular Work Files00: Foundation EnvironmentAS400 Coexistence Tables
50812F0029TF141Sales Tax Work File by Taxing Authority and DocumentRegular Work Files00: Foundation EnvironmentAS400 Coexistence Tables
51812F0030AY345Bank Transit Number Master FileMaster Files04: Accounts PayableAS400 Coexistence Tables
52812F0030TAZ91Bank Account X12 InformationSecondary Master Files04: Accounts PayableAS400 Coexistence Tables
53812F0039GN282Generated Documents DefinitionExtra Features Files42: Sales ManagementNo
54812F0039MGH121Generated Document Media Object HistoryHistory Files42: Sales ManagementNo
55812F0040Z1ZB122Error Message Log TableBatch Input Files42B: Sales Order EntryNo
56812F0041Z1ZF114Transaction Control FileBatch Input Files42B: Sales Order EntryNo
57812F004201PT723Prepayment Transaction TableTransaction Files42: Sales ManagementNo
58812F0045ERServices Error RecoveryFiles34A: Advanced Planning & Scheduling
59812F0046PL102Processing LogTransaction Files00: Foundation EnvironmentAS400 Coexistence Tables
60812F0047DE152Data Export ControlTransaction Files00: Foundation EnvironmentAS400 Coexistence Tables
61812F0048CM135Code Mappings MasterTransaction Files00: Foundation EnvironmentAS400 Coexistence Tables
62812F0050MA124Organization Structure Master FileExtra Features Files00: Foundation EnvironmentAS400 Coexistence Tables
63812F00690M191Cost Center Types of DataExtra Features Files41: Inventory ManagementAS400 Coexistence Tables
64812F00692M281Cost Center Supplemental Data CodesExtra Features Files41: Inventory ManagementAS400 Coexistence Tables
65812F00693M361Cost Center Supplemental Data TextExtra Features Files41: Inventory ManagementAS400 Coexistence Tables
66812F0070CK121Country Constants Master FileConstants Files00: Foundation EnvironmentAS400 Coexistence Tables
67812F007101TA201Text Processor HeaderTransaction Files00: Foundation EnvironmentNo
68812F007111TB142Text Processor Detail TableTransaction Files00: Foundation EnvironmentNo
69812F0075CC115Credit Card InformationFiles09E: Expense ReimbursmentNo
70812F0080S251Supplemental Data Type Security FileExtra Features Files41: Inventory ManagementAS400 Coexistence Tables
71812F0085YN31Audit Record Y/N File - EuroConstants Files00: Foundation EnvironmentAS400 Coexistence Tables
72812F0087EU72Conversion Constants File for EuroExtra Features Files00: Foundation EnvironmentAS400 Coexistence Tables
73812F00UI391GW161Generated Document Work TableWork Files42: Sales ManagementNo
74812F00UI392GW151Text Substitution Work TableWork Files42: Sales ManagementNo
75812F00UI393GW131Bookmark Work TableWork Files42: Sales ManagementNo
76812F01RS01WTH61PCFGTV Header Public DataWork FilesH95: Tech Resources/Applications
77812F01RS11WTD491PCFGTV Detail Public DataWork FilesH95: Tech Resources/Applications
78812F01RS12WTR41PCFGTV Role Public DataFilesH95: Tech Resources/Applications
79812F01RS13WTA141PCFGTV By Role Public DataFilesH95: Tech Resources/Applications
80812F03B470PG72Pay When Paid Group HeaderExtra Features Files03B: Enhanced Accounts ReceivableInternal Table
81812F0401Z1VO941Supplier Master - Batch FileBatch Input Files01: Address BookNo
82812F0901TGM61Account Master Tag FileMaster Files09: General AccountingNo
83812F0901WOWO21Account Master Search Word OccurrenceExtra Features Files00: Foundation EnvironmentNo
84812F0901WSWS43Account - Word SearchExtra Features Files00: Foundation EnvironmentNo
85812F0902GB569Account BalancesBalance Files09: General AccountingAS400 Coexistence Tables
86812F0911GL13425Account LedgerTransaction Files09: General AccountingAS400 Coexistence Tables
87812F0911TGL261Account Ledger Tag FileTransaction Files09: General AccountingNo
88812F09190C9104Inter/Intra Company Account RelationshipsFiles11: Multi CurrencyBusiness Data
89812F1501NE723Tenant/Lease MasterMaster Files15: Property ManagementAS400 Coexistence Tables
90812F15019NL291Billing Frequency MasterMaster Files15: Property ManagementNo
91812F17001CS611Customer Service Constants Table - F17001Constants Files17C: Call ManagementNo
92812F4008TA352Tax AreasExtra Features Files00: Foundation EnvironmentAS400 Coexistence Tables
93812F4096FA211Sales Flex AccountingMaster Files42: Sales ManagementAS400 Coexistence Tables
94812F4303PK283Log MasterTransaction Files43: ProcurementAS400 Coexistence Tables
95812F4303MPM262Log ModelsExtra Features Files43: ProcurementNo
96812F49090CZ422Work Day CalendarExtra Features Files00: Foundation EnvironmentAS400 Coexistence Tables
97812F5192JC111Inquiry ColumnsConstants Files43: ProcurementAS400 Coexistence Tables
98812F5192DJC61Supplier Analysis Alternate Language DescriptionExtra Features Files43: ProcurementAS400 Coexistence Tables
99812F5193JD71Inquiry FormatsConstants Files43: ProcurementAS400 Coexistence Tables
100812F5194JE51Inquiry PathsConstants Files43: ProcurementAS400 Coexistence Tables
101812F5301DI436Change Request Master TableMaster Files53: Change ManagementAS400 Coexistence Tables