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
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

77 tables910 | 74U

74U: United Kingdom Localizations
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F74U006TPC221Business Unit Tag - 15Files74: EMEA LocalizationBusiness Data
2910F74U0100CC281CIS System Constants - 04Constants Files74: EMEA LocalizationBusiness Data
3910F74U0101SC121CIS Company Constants - 04Constants Files74: EMEA LocalizationBusiness Data
4910F74U0102VC121Tax Payment Voucher Constants - 04Constants Files74: EMEA LocalizationBusiness Data
5910F74U0105DI213CIS Document Information - 04Master Files74: EMEA LocalizationBusiness Data
6910F74U0110SD204CIS Subcontractor Documents - 04Extra Features Files74: EMEA LocalizationBusiness Data
7910F74U0111CC92CIS Company Constants 2007 Update - UK - 04Files74U: United Kingdom Localizations
8910F74U0112SC81CIS System Constants 2007 Update - UK - 04Files74U: United Kingdom Localizations
9910F74U0116TF324F0411 CIS Tag Table - 04Master Files74: EMEA LocalizationBusiness Data
10910F74U0118VH253Payment Voucher Status History - 04History Files74: EMEA LocalizationBusiness Data
11910F74U0120MV111CiS Supp F0411 Tag File - UK - 04Files74U: United Kingdom Localizations
12910F74U0121MP111CIS PO Transaction Tag File - UK - 04Files74U: United Kingdom Localizations
13910F74U012TPJ152Tenant EP Class Tag - 15Files74: EMEA LocalizationBusiness Data
14910F74U01BTP3293Lease Master Tag File - 15Files74: EMEA LocalizationBusiness Data
15910F74U0201P1421Property Company Constants - 15Files74: EMEA LocalizationBusiness Data
16910F74U0202P2192Bank Base Rates (EPM) - 15Files74: EMEA LocalizationBusiness Data
17910F74U0205P8437Payment Profile - 15Files74: EMEA LocalizationBusiness Data
18910F74U0208PB141Bill Pattern Mapping - 15Files74: EMEA LocalizationBusiness Data
19910F74U0209PF131EPM - Status Code Table - 15Files74: EMEA LocalizationBusiness Data
20910F74U0212P8322Accounting Billing Profile - 15Files74: EMEA LocalizationBusiness Data
21910F74U0213PW332Weekly Accounting Profile - 15Files74: EMEA LocalizationBusiness Data
22910F74U02BTP6293Recurring Billing Tag - 15Files74: EMEA LocalizationBusiness Data
23910F74U03BTPF211Lease Master Alternative UOM Tag File - 15Files74: EMEA LocalizationBusiness Data
24910F74U0401SA481SPC - Constants - UK - 43Files74U: United Kingdom Localizations
25910F74U0402SB151CIS - Supp Constants - UK - 04Files74U: United Kingdom Localizations
26910F74U0405CH521SPC Certificate Holding Table - UK - 43Files74U: United Kingdom Localizations
27910F74U0408LR243SPC Lower Level Retention - UK - 43Files74U: United Kingdom Localizations
28910F74U0409LM243SPC Lower Level MCD - UK - 43Files74U: United Kingdom Localizations
29910F74U0412AC322Application Commitment Workfile - UK - 43Files74U: United Kingdom Localizations
30910F74U0414CC322Certificate Commitment Workfile - UK - 43Files74U: United Kingdom Localizations
31910F74U0416PC322Purchase Order Commitment Workfile - UK - 43Files74U: United Kingdom Localizations
32910F74U0420SE994SPC - Application Master - UK - 43Master Files74U: United Kingdom Localizations
33910F74U0421IO121Application Approval Invoice OverridesFiles74U: United Kingdom Localizations
34910F74U0422AC194SPC Application/Certificate Cross Reference File - UK - 43Files74U: United Kingdom Localizations
35910F74U0424PL424SPC Subcontractor Payment Liability - UK - 43Files74U: United Kingdom Localizations
36910F74U0425SF1044SPC - Certificate Master - UK - 43Master Files74U: United Kingdom Localizations
37910F74U0427LR42SOP5 Levy / Rate Table - UK - 43Files74U: United Kingdom Localizations
38910F74U0429CR131SPL Cross Reference Table - UK - 43Files74U: United Kingdom Localizations
39910F74U0430SG151Authenticated Receipts Letter Text - UK - 43Files74U: United Kingdom Localizations
40910F74U0431LL163SPC ATR Late Letter Generation - UK - 43Files74U: United Kingdom Localizations
41910F74U0445RN221SPC Accounts Payable Match Doc Detail Tag File - UK - 43Files74U: United Kingdom Localizations
42910F74U0450SP251CIS Special Payee Rules - UK - 04Files74U: United Kingdom Localizations
43910F74U0451SC151Sub-contractor/Special Payee Cross Reference - UK - 04Files74U: United Kingdom Localizations
44910F74U0452SP151Special Payee Definitions - UK - 04Files74U: United Kingdom Localizations
45910F74U071TPD211Property Unit Tag - 15Files74: EMEA LocalizationBusiness Data
46910F74U203AP4291Billing Pattern - Periodic - 15Files74: EMEA LocalizationBusiness Data
47910F74U203BP5161Billing Pattern - Weekly - 15Files74: EMEA LocalizationBusiness Data
48910F74U207AP9221Payment Profile Status History - 15Files74: EMEA LocalizationBusiness Data
49910F74U207BPA241Periodic Accounting Profile Status History - 15Files74: EMEA LocalizationBusiness Data
50910F74U207CPH251Weekly Accounting Profile Status History - 15Files74: EMEA LocalizationBusiness Data
51910F74U210WPL92Global Generation Currency Work Table - 15Files74: EMEA LocalizationBusiness Data
52910F74U25BTPK211Interest Tag Table - 15Files74: EMEA LocalizationBusiness Data
53910F74U4010SI112HMRC Subontractor Information - UK - 04Files74U: United Kingdom Localizations
54910F74U4015IR82AB - HMRC Information Relation - UK - 04Files74U: United Kingdom Localizations
55910F74U4020VS101Subcontrator Verification Status - UK -04Files74U: United Kingdom Localizations
56910F74U4030VD151CIS Withholding Verification Detail - UK - 04Files74U: United Kingdom Localizations
57910F74U4051HM243Header - CIS Monthly Return - UK - 04Files74U: United Kingdom Localizations
58910F74U4052SM241Subcontractor Detail - CIS Monthly Return - UK - 04Files74U: United Kingdom Localizations
59910F74U4053DM191Subcontractor Documents Detail - CIS Monthly Return - UK- 04Files74U: United Kingdom Localizations
60910F74U420APA222SPC Application Amount Drill Down - UK - 43Files74U: United Kingdom Localizations
61910F74U421AAH132SPC Application Approval History - UK - 43Files74U: United Kingdom Localizations
62910F74U421BAD92Application Approval Delegates - UK - 43Files74U: United Kingdom Localizations
63910F74U424APL315SPC Subcontractor Accrual Data - UK - 43Files74U: United Kingdom Localizations
64910F74U424WWF305SPC Subcontractor Accrual Workfile - UK - 43Files74U: United Kingdom Localizations
65910F74U4311PT111EPM - Purchase Order Tag File - 74UFiles74: EMEA LocalizationBusiness Data
66910F74U4312SC292SPC - Purchase Order Additional Information - UK - 43Extra Features Files74U: United Kingdom Localizations
67910F74U4314SD172SPC - Purchase Order Retention - UK - 43Extra Features Files74U: United Kingdom Localizations
68910F74U4316SC452SPC - Purchase Order Line Additional Information - UK - 43Extra Features Files74U: United Kingdom Localizations
69910F74U4318SD182SPC - Purchase Order Line Retention - UK - 43Extra Features Files74U: United Kingdom Localizations
70910F74U4319CS181SPC Cumulative Labour Material Split - UK - 43Files74U: United Kingdom Localizations
71910F74U4320TV101Requisition Template Qestions - UK - 43Files74U: United Kingdom Localizations
72910F74U4321RA221Requisition Template Answers - UK - 43Files74U: United Kingdom Localizations
73910F74UCW01CW21CIS Voucher Entry Workfile - UK - 04Files74U: United Kingdom Localizations
74910F74UCW02CV61CIS Voucher Entry Workfile 2 - UK - 04Files74U: United Kingdom Localizations
75910F74UCW03VM162CIS Voucher Match Workfile - UK - 04Files74U: United Kingdom Localizations
76910F74UUI51HM243Header - XML Work File CIS Monthly Return - UK - 04Files74U: United Kingdom Localizations
77910F74UUI52SM241Subcontractor Detail - XML WF CIS Monthly Return - UK - 04Files74U: United Kingdom Localizations