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
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
9F42119SDSales Order History File
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

118 tables920 | 00

00: Foundation Environment
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F0000194SY51Generic Interface Table for B0000194Files09: General AccountingBusiness Data
2920F0002NN311Next Numbers - AutomaticConstants Files09: General AccountingControl Tables
3920F00021NL101Next Numbers by Company/Fiscal Year - AutomaticConstants Files09: General AccountingControl Tables
4920F00022UK21Unique Key File - Next Available Unique KeyConstants Files41: Inventory ManagementBusiness Data
5920F00023DN245Distributed Next Number TableMaster Files90CA: CRM FoundationSystem Tables
6920F0006MC1527Business Unit MasterMaster Files09: General AccountingBusiness Data
7920F0006DLJ72Business Unit Alternate Description MasterExtra Features Files09: General AccountingBusiness Data
8920F0006DZ1SZ261Business Unit Alternate Description Z fileExtra Features Files09: General AccountingBusiness Data
9920F0006SMC1571Date Effective Business Unit MasterExtra Features Files09: General AccountingBusiness Data
10920F0006S1SH81Business Unit Snapshot HeaderExtra Features Files09: General AccountingBusiness Data
11920F0006Z1SZ1611Cost Center Unedited Transaction TableBatch Input Files05A: PeopleSoft HR & PR FoundationBusiness Data
12920F0006Z2SZ1651Business Unit Master Z FileMaster Files09: General AccountingBusiness Data
13920F0007CZ433Workday CalendarExtra Features Files30: Product Data ManagementBusiness Data
14920F0008CD252Date Fiscal PatternsConstants Files09: General AccountingBusiness Data
15920F00085DS181Daylight Savings RulesConstants FilesH91: Design ToolsSystem Tables
16920F0008BCD631Date Fiscal Patterns - 52 Period AccountingConstants Files09: General AccountingBusiness Data
17920F0009GC661General ConstantsConstants Files09: General AccountingBusiness Data
18920F00090T1221Supplemental Database SetupConstants Files41: Inventory ManagementBusiness Data
19920F00090DT581Supplemental Database Language PreferencesTransaction Files41: Inventory ManagementBusiness Data
20920F00091T2341Supplemental Database Data TypesTransaction Files41: Inventory ManagementBusiness Data
21920F00092T3305Supplemental DataTransaction Files41: Inventory ManagementBusiness Data
22920F00093FM122Flash MessagesExtra Features Files17: Customer Service ManagementBusiness Data
23920F00094T1101CTI PropertiesExtra Features Files09: General AccountingBusiness Data
24920F00095A173Business Object ReservationExtra Features Files42: Sales Management
25920F00096M0371Default Media Object Category by TableExtra Features Files42: Sales ManagementBusiness Data
26920F00098ED91Enable Distributed Next NumnerFiles90CA: CRM FoundationBusiness Data
27920F0010CC655Company ConstantsConstants Files09: General AccountingBusiness Data
28920F00101CC82Company by Country - 00Files00: Foundation Environment
29920F0010TCC121Company Constants Tag TableFiles09: General Accounting
30920F0010ZSZ841Company Constants Z FileConstants Files09: General AccountingBusiness Data
31920F0011IC241Batch Control RecordsExtra Features Files09: General AccountingBusiness Data
32920F0011WIC51F0011W - WF - Batch To DetailFiles09: General Accounting
33920F0012KG202Automatic Accounting Instructions MasterConstants Files09: General AccountingBusiness Data
34920F0012DLJ81AAI Alternate Description MasterExtra Features Files09: General AccountingBusiness Data
35920F0013CV101Currency CodesExtra Features Files09: General AccountingBusiness Data
36920F0014PN161Payment TermsConstants Files03B: Enhanced Accounts ReceivableBusiness Data
37920F00141L353Advanced Payment TermsConstants Files03B: Enhanced Accounts ReceivableBusiness Data
38920F00142L4231Due Date RulesConstants Files03B: Enhanced Accounts ReceivableBusiness Data
39920F00143L561Due Date Rules Day RangeConstants Files03B: Enhanced Accounts ReceivableBusiness Data
40920F00144L663Installment Payment TermsConstants Files03B: Enhanced Accounts ReceivableBusiness Data
41920F00147L8161Multitiered Payment TermsConstants Files03B: Enhanced Accounts ReceivableBusiness Data
42920F0018TD686TaxesExtra Features Files09: General AccountingBusiness Data
43920F00189TG202WF - Tax ReconciliationRegular Work Files09: General AccountingBusiness Data
44920F0018RED272Tax Reconciliation RepositoryFiles09: General Accounting
45920F0019CG61Generic Message/Rate TypesExtra Features Files48: Work Order ProcessingBusiness Data
46920F00191CE61Generic Message/RatesExtra Features Files48: Work Order ProcessingBusiness Data
47920F00192CF51General Message DetailExtra Features Files48: Work Order ProcessingBusiness Data
48920F0022VA111Tax RulesConstants Files04: Accounts PayableBusiness Data
49920F0024UG22Batch Approval / Post Security FileExtra Features Files09: General AccountingBusiness Data
50920F0025LH282Ledger Type Master FileConstants Files09: General AccountingBusiness Data
51920F0026CL181Job Cost ConstantsConstants Files51: Job CostingBusiness Data
52920F0028TE101Sales Tax Work File by Taxing AuthorityRegular Work Files09: General AccountingBusiness Data
53920F0029TF141Sales Tax Work File by Taxing Authority and DocumentRegular Work Files09: General AccountingBusiness Data
54920F0030AY346Bank Transit MasterMaster Files04: Accounts PayableBusiness Data
55920F0030TAZ91Bank Account X12 InformationSecondary Master Files04: Accounts PayableBusiness Data
56920F0031AV71Bank Transit Master Tag TableFiles00: Foundation Environment
57920F0039GN282Generated Documents DefinitionExtra Features Files42: Sales ManagementBusiness Data
58920F0039MGH121Generated Document Media Object HistoryHistory Files42: Sales ManagementBusiness Data
59920F0040Z1ZB122Error Message Log TableBatch Input Files42B: Sales Order EntryBusiness Data
60920F0041Z1ZF114Transaction Control FileBatch Input Files42B: Sales Order EntryBusiness Data
61920F004201PT723Prepayment Transaction TableTransaction Files42: Sales ManagementBusiness Data
62920F00421RS153Column RelationshipsFiles09: General AccountingBusiness Data
63920F00422RB155Data RelationshipsFiles09: General AccountingBusiness Data
64920F00422AVR104Value Relationships - Work TableFiles09: General Accounting
65920F00424AC91Relationship ColumnsFiles09: General AccountingBusiness Data
66920F0045ER212Services Error RecoveryFiles34A: Advanced Planning & Scheduling
67920F0046PL102Processing LogTransaction Files09: General AccountingBusiness Data
68920F0047DE152Data Export ControlTransaction Files09: General AccountingBusiness Data
69920F0048CM135Code Mappings MasterTransaction Files00: Foundation EnvironmentBusiness Data
70920F0049CA152Business Function Call Abstraction RegisterFiles34A: Advanced Planning & Scheduling
71920F0050MA124Organization Structure Master FileExtra Features Files09: General AccountingBusiness Data
72920F00690M191Cost Center Types of DataExtra Features Files41: Inventory ManagementBusiness Data
73920F00692M281Cost Center Supplemental Data CodesExtra Features Files41: Inventory ManagementBusiness Data
74920F00693M361Cost Center Supplemental Data TextExtra Features Files41: Inventory ManagementBusiness Data
75920F0070CK121Country Constants Master FileConstants Files09: General AccountingBusiness Data
76920F007021WTB171Transactions to Batch Headers Work TableFiles00: Foundation Environment
77920F007032WOB71Batches Out Of Balance Work TableFiles09: General Accounting
78920F0075CC115Credit Card InformationFiles09E: Expense ReimbursmentBusiness Data
79920F0080S251Supplemental Data Type Security FileExtra Features Files41: Inventory ManagementBusiness Data
80920F0085YN31Audit Record Y/N File - EuroConstants Files09: General AccountingBusiness Data
81920F0087EU72Conversion Constants File for EuroExtra Features Files09: General AccountingBusiness Data
82920F0095IT51Integration TimestampFiles00: Foundation Environment
83920F00UI391GW161Generated Document Work TableWork Files42: Sales ManagementBusiness Data
84920F00UI392GW151Text Substitution Work TableWork Files42: Sales ManagementBusiness Data
85920F00UI393GW131Bookmark Work TableWork Files42: Sales ManagementBusiness Data
86920F01RS01WTH61PCFGTV Header Public DataWork FilesH95: Object and Environment Tech
87920F01RS11WTD491PCFGTV Detail Public DataWork FilesH95: Object and Environment Tech
88920F01RS12WTR41PCFGTV Role Public DataFilesH95: Object and Environment Tech
89920F01RS13WTA141PCFGTV By Role Public DataFilesH95: Object and Environment Tech
90920F03B470PG72Pay When Paid Group HeaderExtra Features Files03B: Enhanced Accounts ReceivableBusiness Data
91920F0401Z1VO951Supplier Master - Batch UploadBatch Input Files01: Address BookBusiness Data
92920F0901WOWO21Account Master Search Word OccurrenceExtra Features Files09: General AccountingBusiness Data
93920F0901WSWS43Account - Word SearchExtra Features Files09: General AccountingBusiness Data
94920F0902GB569Account BalancesBalance Files09: General AccountingBusiness Data
95920F0911GL14124Account LedgerTransaction Files09: General AccountingBusiness Data
96920F09190C9104Inter/Intra Company Account RelationshipsFiles11: Multi CurrencyBusiness Data
97920F097001WCB71Companies Out of Balance Work TableFiles09: General Accounting
98920F15019NL291Billing Frequency MasterMaster Files15: Real Estate ManagementBusiness Data
99920F17001CS611Service/Warranty Constants Table - F17001Constants Files17C: Call ManagementBusiness Data
100920F4008TA352Tax AreasExtra Features Files04: Accounts PayableBusiness Data
101920F40081EU272Alternate Tax Rate/Area DefinitionFiles00: Foundation Environment
102920F40082AC82Alternate Tax Area by Country - 00Files00: Foundation Environment
103920F4096FA211Sales Flex AccountingMaster Files42: Sales ManagementBusiness Data
104920F4303MPM262Log ModelsExtra Features Files43: ProcurementBusiness Data
105920F5192JC111Inquiry ColumnsConstants Files43: ProcurementBusiness Data
106920F5192DJC61Supplier Analysis Alternate Language DescriptionExtra Features Files43: ProcurementBusiness Data
107920F5193JD71Inquiry FormatsConstants Files43: ProcurementBusiness Data
108920F5194JE51Inquiry PathsConstants Files43: ProcurementBusiness Data
109920F5301DI436Change Request Master TableMaster Files53: Change ManagementBusiness Data
110920F744008TA91Tax areas - Tag Table EMEA - Spain / ItalyMaster Files04: Accounts PayableBusiness Data
111920F800010TD172Time DimensionMaster Files00: Foundation EnvironmentBusiness Data
112920F80D306HD141Action DefinitionFiles80D: Plant Manager Dashboard
113920F80D307HD111Metric Action Cross ReferenceFiles80D: Plant Manager Dashboard
114920F80D309MS121Metric Series Cross RefFiles80D: Plant Manager Dashboard
115920F80D310AL131Alert DefinitionFiles80D: Plant Manager Dashboard
116920F80D312AS121Alert SubscriptionFiles80D: Plant Manager Dashboard
117920F80D321MG121UI Metric Group DefinitionFiles80D: Plant Manager Dashboard
118920F80D322MD171UI Metric Group DetailFiles80D: Plant Manager Dashboard