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

36 tables812 | 74U

74U: United Kingdom Localizations
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F74U006TPC221Business Unit Tag - 15Files74: EMEA LocalizationBusiness Data
2812F74U0100CC281CIS System ConstantsConstants Files04: Accounts PayableNo
3812F74U0101SC121CIS Company ConstantsConstants Files04: Accounts PayableNo
4812F74U0102VC121Tax Payment Voucher ConstantsConstants Files04: Accounts PayableNo
5812F74U0105DI213CIS Document InformationMaster Files04: Accounts PayableNo
6812F74U0110SD204CIS Subcontractor DocumentsExtra Features Files04: Accounts PayableNo
7812F74U0111CC92CIS Company Constants 2007 Update - UK - 04Files74U: United Kingdom Localizations
8812F74U0112SC81CIS System Constants 2007 Update - UK - 04Files74U: United Kingdom Localizations
9812F74U0116TF324F0411 CIS Tag FileMaster Files04: Accounts PayableNo
10812F74U0118VH253Payment Voucher Status HistoryHistory Files04: Accounts PayableNo
11812F74U012TPJ152Tenant EP Class Tag - 15Files74: EMEA LocalizationBusiness Data
12812F74U01BTP3293Lease Master Tag File - 15Files74: EMEA LocalizationBusiness Data
13812F74U0201P1421Property Company Constants - 15Files74: EMEA LocalizationBusiness Data
14812F74U0202P2191Bank Base Rates (EPM) - 15Files74: EMEA LocalizationBusiness Data
15812F74U0205P8436Payment Profile - 15Files74: EMEA LocalizationBusiness Data
16812F74U0208PB141Bill Pattern Mapping - 15Files74: EMEA LocalizationBusiness Data
17812F74U0209PF131EPM - Status Code Table - 15Files74: EMEA LocalizationBusiness Data
18812F74U0212P8322Accounting Billing Profile - 15Files74: EMEA LocalizationBusiness Data
19812F74U0213PW332Weekly Accounting Profile - 15Files74: EMEA LocalizationBusiness Data
20812F74U02BTP6293Recurring Billing Tag - 15Files74: EMEA LocalizationBusiness Data
21812F74U03BTPF211Lease Master Alternative UOM Tag File - 15Files74: EMEA LocalizationBusiness Data
22812F74U071TPD211Property Unit Tag - 15Files74: EMEA LocalizationBusiness Data
23812F74U203AP4291Billing Pattern - Periodic - 15Files74: EMEA LocalizationBusiness Data
24812F74U203BP5161Billing Pattern - Weekly - 15Files74: EMEA LocalizationBusiness Data
25812F74U207AP9221Payment Profile Status History - 15Files74: EMEA LocalizationBusiness Data
26812F74U207BPA241Periodic Accounting Profile Status History - 15Files74: EMEA LocalizationBusiness Data
27812F74U207CPH251Weekly Accounting Profile Status History - 15Files74: EMEA LocalizationBusiness Data
28812F74U210WPL92Global Generation Currency Work Table - 15Files74: EMEA LocalizationBusiness Data
29812F74U25BTPK211Interest Tag Table - 15Files74: EMEA LocalizationBusiness Data
30812F74U4010SI112HMRC Subontractor Information - UK - 04Files74U: United Kingdom Localizations
31812F74U4015IR82AB - HMRC Information Relation - UK - 04Files74U: United Kingdom Localizations
32812F74U4020VS101Subcontrator Verification Status - UK -04Files74U: United Kingdom Localizations
33812F74U4051HM243Header - CIS Monthly Return - UK - 04Files74U: United Kingdom Localizations
34812F74U4052SM241Subcontractor Detail - CIS Monthly Return - UK - 04Files74U: United Kingdom Localizations
35812F74U4053DM191Subcontractor Documents Detail - CIS Monthly Return - UK- 04Files74U: United Kingdom Localizations
36812F74U4311PT111EPM - Purchase Order Tag File - 74UFiles74: EMEA LocalizationBusiness Data