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

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

45 tables920 | 75C

75C: China
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F0018CNCT152China - Transmitted vouchers to JinSui - 04Transaction Files75: ASEAN LocalizationBusiness Data
2920F75C001CR293Chinese GUI cross reference fileTransaction Files75C: China
3920F75C002EA212Electronic Accounting BookFiles75C: China
4920F75C003RI121Report Format DefinitionFiles75C: China
5920F75C003TRT121Report Format Definition Tag file - ChinaFiles75C: China
6920F75C004RN101Report Item - Natural Account MappingFiles75C: China
7920F75C005RF91Report Item - Formula MappingFiles75C: China
8920F75C006NA111Natural Account Structure Set UpFiles75C: China
9920F75C007CA181China - Chart of Accounts Set UpFiles75C: China
10920F75C008EM241Employee Record Information - ChinaFiles75C: China
11920F75C009BI171GL Basic Information - ChinaFiles75C: China
12920F75C010UR161Subsidiary Info Setup - ChinaFiles75C: China
13920F75C010WAA471AP & AR XML Workfile - China -75CFiles75C: China
14920F75C011UV401Account - Subsidiary Cross Reference - China - 75CFiles75C: China
15920F75C012AB141Address Book Additional Information - ChinaFiles75C: China
16920F75C013DE171Dynamic XML Element Name - CHINA - 00Files75C: China
17920F75C014BA211AP/AR Balances - ChinaFiles75C: China
18920F75C015CF361Cash Flow Data - ChinaFiles75C: China
19920F75C01Z2FF21GUI Jinsui return flat file - China - 03BBatch Input Files75: ASEAN LocalizationBusiness Data
20920F75C030AB121Additional Bank Information - CHINA - 75CFiles75C: China
21920F75C04Z1CT41China A/P tax interface to JinSui - 04Transaction Files75: ASEAN LocalizationBusiness Data
22920F75C091CL101Account master - Tag file - China LocalizationFiles75C: China
23920F75C09Z1FF41GUI cancel printing invoice-Jinsui - China - 03BPC Download/Batch Edit Files75: ASEAN LocalizationBusiness Data
24920F75C201MM181Modification Methods Information - CHINAFiles75C: China
25920F75C202DA202Asset Disposal Amounts - CHINAFiles75C: China
26920F75C203FA151Fixed Assets Card Usage Information - CHINAFiles75C: China
27920F75C204AH211Asset Master History File - CHINAFiles75C: China
28920F75C4106IB152Chinese Free Goods VAT base price - F75C4106 - 41Master Files75: ASEAN LocalizationBusiness Data
29920F75C4203FC152Chinese VAT on Free Goods Cross Reference - China - 42Files75: ASEAN LocalizationBusiness Data
30920F75C501CE121Payroll Category and Payroll Elements - CHINAFiles75C: China
31920F75C502PP161Payroll Periods - CHINAFiles75C: China
32920F75C503EP171Employee Payroll - CHINAFiles75C: China
33920F75C504PC141Payroll Category - CHINAFiles75C: China
34920F75C505PE121Payroll Elements - CHINAFiles75C: China
35920F75C902SB781Subsidiary Balances File - ChinaFiles75C: China
36920F75C910CF171China Reports Balance -CNAO V2Files75C: China
37920F75C911DN192CNAO - E1 Document Number mapping - ChinaFiles75C: China
38920F75C911AAL181Account Ledger Processing Info- China - 09Files75C: China
39920F75C912TS431Transaction-wise Subsidiary Info - China - 09Files75C: China
40920F75CDXMDX131Dynamic XML Output GeneratorFiles75C: China
41920F75CUI04WF91China CNAO V2 Fixed Asset XML Work File - CHINAFiles75C: China
42920F75CUI05MP551AP & AR Multiple Period XML Workfile - China -75CFiles75C: China
43920F75CUI1CF241China Financial Report Work File - 10Files75: ASEAN Localization
44920F75CUI2CF91China Financial Report Staging Work File - 10Files75: ASEAN Localization
45920F75CUI3CW231Financial Reporting Work FIleFiles75C: China