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

110 tables910 | 00

00: Foundation Environment
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F0000194SY51Generic Interface Table for B0000194Files09: General AccountingBusiness Data
2910F0002NN311Next Numbers - AutomaticConstants Files09: General AccountingControl Tables
3910F00021NL101Next Numbers by Company/Fiscal Year - AutomaticConstants Files09: General AccountingControl Tables
4910F00022UK21Unique Key File - Next Available Unique KeyConstants Files41: Inventory ManagementBusiness Data
5910F00023DN245Distributed Next Number TableMaster Files90CA: CRM FoundationSystem Tables
6910F0006MC1527Business Unit MasterMaster Files09: General AccountingBusiness Data
7910F0006DLJ72Business Unit Alternate Description MasterExtra Features Files09: General AccountingBusiness Data
8910F0006SMC1571Date Effective Business Unit MasterExtra Features Files09: General AccountingBusiness Data
9910F0006S1SH81Business Unit Snapshot HeaderExtra Features Files09: General AccountingBusiness Data
10910F0006Z1SZ1611Cost Center Unedited Transaction TableBatch Input Files05A: OW HR & PR FoundationBusiness Data
11910F0007CZ433Workday CalendarExtra Features Files30: Product Data ManagementBusiness Data
12910F0008CD252Date Fiscal PatternsConstants Files09: General AccountingBusiness Data
13910F00085DS181Daylight Savings RulesConstants FilesH91: Design ToolsSystem Tables
14910F0008BCD631Date Fiscal Patterns - 52 Period AccountingConstants Files09: General AccountingBusiness Data
15910F0009GC661General ConstantsConstants Files09: General AccountingBusiness Data
16910F00090T1221Supplemental Database SetupConstants Files41: Inventory ManagementBusiness Data
17910F00090DT581Supplemental Database Language PreferencesTransaction Files41: Inventory ManagementBusiness Data
18910F00091T2341Supplemental Database Data TypesTransaction Files41: Inventory ManagementBusiness Data
19910F00092T3305Supplemental DataTransaction Files41: Inventory ManagementBusiness Data
20910F00093FM122Flash MessagesExtra Features Files17: Customer Service ManagementBusiness Data
21910F00094T1101CTI PropertiesExtra Features Files09: General AccountingBusiness Data
22910F00095A173Business Object ReservationExtra Features Files42: Sales Management
23910F00096M0371Default Media Object Category by TableExtra Features Files42: Sales ManagementBusiness Data
24910F00098ED91Enable Distributed Next NumnerFiles90CA: CRM FoundationBusiness Data
25910F0010CC655Company ConstantsConstants Files09: General AccountingBusiness Data
26910F0010TCC121Company Constants Tag TableFiles09: General Accounting
27910F0011IC241Batch Control RecordsExtra Features Files09: General AccountingBusiness Data
28910F0011WIC51F0011W - WF - Batch To DetailFiles09: General Accounting
29910F0012KG202Automatic Accounting Instructions MasterConstants Files09: General AccountingBusiness Data
30910F0012DLJ81AAI Alternate Description MasterExtra Features Files09: General AccountingBusiness Data
31910F0013CV101Currency CodesExtra Features Files09: General AccountingBusiness Data
32910F0014PN161Payment TermsConstants Files03B: Enhanced Accounts ReceivableBusiness Data
33910F00141L353Advanced Payment TermsConstants Files03B: Enhanced Accounts ReceivableBusiness Data
34910F00142L4231Due Date RulesConstants Files03B: Enhanced Accounts ReceivableBusiness Data
35910F00143L561Due Date Rules Day RangeConstants Files03B: Enhanced Accounts ReceivableBusiness Data
36910F00144L663Installment Payment TermsConstants Files03B: Enhanced Accounts ReceivableBusiness Data
37910F00147L8161Multitiered Payment TermsConstants Files03B: Enhanced Accounts ReceivableBusiness Data
38910F0018TD686TaxesExtra Features Files09: General AccountingBusiness Data
39910F00189TG202WF - Tax ReconciliationRegular Work Files09: General AccountingBusiness Data
40910F0018RED272Tax Reconciliation RepositoryFiles09: General Accounting
41910F0019CG61Generic Message/Rate TypesExtra Features Files48: Work Order ProcessingBusiness Data
42910F00191CE61Generic Message/RatesExtra Features Files48: Work Order ProcessingBusiness Data
43910F00192CF51General Message DetailExtra Features Files48: Work Order ProcessingBusiness Data
44910F0022VA111Tax RulesConstants Files04: Accounts PayableBusiness Data
45910F0024UG22Batch Approval / Post Security FileExtra Features Files09: General AccountingBusiness Data
46910F0025LH282Ledger Type Master FileConstants Files09: General AccountingBusiness Data
47910F0026CL181Job Cost ConstantsConstants Files51: Job CostingBusiness Data
48910F0028TE101Sales Tax Work File by Taxing AuthorityRegular Work Files09: General AccountingBusiness Data
49910F0029TF141Sales Tax Work File by Taxing Authority and DocumentRegular Work Files09: General AccountingBusiness Data
50910F0030AY346Bank Transit MasterMaster Files04: Accounts PayableBusiness Data
51910F0030TAZ91Bank Account X12 InformationSecondary Master Files04: Accounts PayableBusiness Data
52910F0031AV71Bank Transit Master Tag TableFiles00: Foundation Environment
53910F0039GN282Generated Documents DefinitionExtra Features Files42: Sales ManagementBusiness Data
54910F0039MGH121Generated Document Media Object HistoryHistory Files42: Sales ManagementBusiness Data
55910F0040Z1ZB122Error Message Log TableBatch Input Files42B: Sales Order EntryBusiness Data
56910F0041Z1ZF114Transaction Control FileBatch Input Files42B: Sales Order EntryBusiness Data
57910F004201PT723Prepayment Transaction TableTransaction Files42: Sales ManagementBusiness Data
58910F00421RS153Column RelationshipsFiles09: General AccountingBusiness Data
59910F00422RB155Data RelationshipsFiles09: General AccountingBusiness Data
60910F00422AVR104Value Relationships - Work TableFiles09: General Accounting
61910F00424AC91Relationship ColumnsFiles09: General AccountingBusiness Data
62910F0045ER212Services Error RecoveryFiles34A: Advanced Planning & Scheduling
63910F0046PL102Processing LogTransaction Files09: General AccountingBusiness Data
64910F0047DE152Data Export ControlTransaction Files09: General AccountingBusiness Data
65910F0048CM135Code Mappings MasterTransaction Files00: Foundation EnvironmentBusiness Data
66910F0049CA152Business Function Call Abstraction RegisterFiles34A: Advanced Planning & Scheduling
67910F0050MA124Organization Structure Master FileExtra Features Files09: General AccountingBusiness Data
68910F00690M191Cost Center Types of DataExtra Features Files41: Inventory ManagementBusiness Data
69910F00692M281Cost Center Supplemental Data CodesExtra Features Files41: Inventory ManagementBusiness Data
70910F00693M361Cost Center Supplemental Data TextExtra Features Files41: Inventory ManagementBusiness Data
71910F0070CK121Country Constants Master FileConstants Files09: General AccountingBusiness Data
72910F0075CC115Credit Card InformationFiles09E: Expense ReimbursmentBusiness Data
73910F0080S251Supplemental Data Type Security FileExtra Features Files41: Inventory ManagementBusiness Data
74910F0085YN31Audit Record Y/N File - EuroConstants Files09: General AccountingBusiness Data
75910F0087EU72Conversion Constants File for EuroExtra Features Files09: General AccountingBusiness Data
76910F0095IT51Integration TimestampFiles00: Foundation Environment
77910F00UI391GW161Generated Document Work TableWork Files42: Sales ManagementBusiness Data
78910F00UI392GW151Text Substitution Work TableWork Files42: Sales ManagementBusiness Data
79910F00UI393GW131Bookmark Work TableWork Files42: Sales ManagementBusiness Data
80910F01RS01WTH61PCFGTV Header Public DataWork FilesH95: Tech Resources/Applications
81910F01RS11WTD491PCFGTV Detail Public DataWork FilesH95: Tech Resources/Applications
82910F01RS12WTR41PCFGTV Role Public DataFilesH95: Tech Resources/Applications
83910F01RS13WTA141PCFGTV By Role Public DataFilesH95: Tech Resources/Applications
84910F03B470PG72Pay When Paid Group HeaderExtra Features Files03B: Enhanced Accounts ReceivableBusiness Data
85910F0401Z1VO951Supplier Master - Batch UploadBatch Input Files01: Address BookBusiness Data
86910F0901WOWO21Account Master Search Word OccurrenceExtra Features Files09: General AccountingBusiness Data
87910F0901WSWS43Account - Word SearchExtra Features Files09: General AccountingBusiness Data
88910F0902GB569Account BalancesBalance Files09: General AccountingBusiness Data
89910F0911GL14126Account LedgerTransaction Files09: General AccountingBusiness Data
90910F09190C9104Inter/Intra Company Account RelationshipsFiles11: Multi CurrencyBusiness Data
91910F15019NL291Billing Frequency MasterMaster Files15: Property ManagementBusiness Data
92910F17001CS611Service/Warranty Constants Table - F17001Constants Files17C: Call ManagementBusiness Data
93910F4008TA352Tax AreasExtra Features Files04: Accounts PayableBusiness Data
94910F4096FA211Sales Flex AccountingMaster Files42: Sales ManagementBusiness Data
95910F4303MPM262Log ModelsExtra Features Files43: ProcurementBusiness Data
96910F5192JC111Inquiry ColumnsConstants Files43: ProcurementBusiness Data
97910F5192DJC61Supplier Analysis Alternate Language DescriptionExtra Features Files43: ProcurementBusiness Data
98910F5193JD71Inquiry FormatsConstants Files43: ProcurementBusiness Data
99910F5194JE51Inquiry PathsConstants Files43: ProcurementBusiness Data
100910F5301DI436Change Request Master TableMaster Files53: Change ManagementBusiness Data
101910F744008TA91Tax areas - Tag Table EMEA - Spain / ItalyMaster Files04: Accounts PayableBusiness Data
102910F800010TD172Time DimensionMaster Files00: Foundation EnvironmentBusiness Data
103910F80D306HD141Action DefinitionFiles80D: Plant Manager Dashboard
104910F80D307HD111Metric Action Cross ReferenceFiles80D: Plant Manager Dashboard
105910F80D309MS121Metric Series Cross RefFiles80D: Plant Manager Dashboard
106910F80D310AL131Alert DefinitionFiles80D: Plant Manager Dashboard
107910F80D312AS121Alert SubscriptionFiles80D: Plant Manager Dashboard
108910F80D321MG121UI Metric Group DefinitionFiles80D: Plant Manager Dashboard
109910F80D322MD171UI Metric Group DetailFiles80D: Plant Manager Dashboard
110910F80D323GE111GroupID Email AddressFiles80D: Plant Manager Dashboard