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 tables920 | 74U

74U: United Kingdom Localizations
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F74U006TPC221Business Unit Tag - 15Files74: EMEA LocalizationBusiness Data
2920F74U0100CC281CIS System Constants - 04Constants Files74: EMEA LocalizationBusiness Data
3920F74U0101SC121CIS Company Constants - 04Constants Files74: EMEA LocalizationBusiness Data
4920F74U0102VC121Tax Payment Voucher Constants - 04Constants Files74: EMEA LocalizationBusiness Data
5920F74U0105DI213CIS Document Information - 04Master Files74: EMEA LocalizationBusiness Data
6920F74U0110SD204CIS Subcontractor Documents - 04Extra Features Files74: EMEA LocalizationBusiness Data
7920F74U0111CC92CIS Company Constants 2007 Update - UK - 04Files74U: United Kingdom Localizations
8920F74U0112SC81CIS System Constants 2007 Update - UK - 04Files74U: United Kingdom Localizations
9920F74U0116TF324F0411 CIS Tag Table - 04Master Files74: EMEA LocalizationBusiness Data
10920F74U0118VH253Payment Voucher Status History - 04History Files74: EMEA LocalizationBusiness Data
11920F74U0120MV111CiS Supp F0411 Tag File - UK - 04Files74U: United Kingdom Localizations
12920F74U0121MP111CIS PO Transaction Tag File - UK - 04Files74U: United Kingdom Localizations
13920F74U012TPJ152Tenant EP Class Tag - 15Files74: EMEA LocalizationBusiness Data
14920F74U01BTP3293Lease Master Tag File - 15Files74: EMEA LocalizationBusiness Data
15920F74U0201P1421Property Company Constants - 15Files74: EMEA LocalizationBusiness Data
16920F74U0202P2192Bank Base Rates (EPM) - 15Files74: EMEA LocalizationBusiness Data
17920F74U0205P8437Payment Profile - 15Files74: EMEA LocalizationBusiness Data
18920F74U0208PB141Bill Pattern Mapping - 15Files74: EMEA LocalizationBusiness Data
19920F74U0209PF131EPM - Status Code Table - 15Files74: EMEA LocalizationBusiness Data
20920F74U0212P8322Accounting Billing Profile - 15Files74: EMEA LocalizationBusiness Data
21920F74U0213PW332Weekly Accounting Profile - 15Files74: EMEA LocalizationBusiness Data
22920F74U02BTP6293Recurring Billing Tag - 15Files74: EMEA LocalizationBusiness Data
23920F74U03BTPF211Lease Master Alternative UOM Tag File - 15Files74: EMEA LocalizationBusiness Data
24920F74U0401SA481SPC - Constants - UK - 43Files74U: United Kingdom Localizations
25920F74U0402SB151CIS - Supp Constants - UK - 04Files74U: United Kingdom Localizations
26920F74U0405CH521SPC Certificate Holding Table - UK - 43Files74U: United Kingdom Localizations
27920F74U0408LR243SPC Lower Level Retention - UK - 43Files74U: United Kingdom Localizations
28920F74U0409LM243SPC Lower Level MCD - UK - 43Files74U: United Kingdom Localizations
29920F74U0412AC322Application Commitment Workfile - UK - 43Files74U: United Kingdom Localizations
30920F74U0414CC322Certificate Commitment Workfile - UK - 43Files74U: United Kingdom Localizations
31920F74U0416PC322Purchase Order Commitment Workfile - UK - 43Files74U: United Kingdom Localizations
32920F74U0420SE994SPC - Application Master - UK - 43Master Files74U: United Kingdom Localizations
33920F74U0421IO121Application Approval Invoice OverridesFiles74U: United Kingdom Localizations
34920F74U0422AC194SPC Application/Certificate Cross Reference File - UK - 43Files74U: United Kingdom Localizations
35920F74U0424PL424SPC Subcontractor Payment Liability - UK - 43Files74U: United Kingdom Localizations
36920F74U0425SF1044SPC - Certificate Master - UK - 43Master Files74U: United Kingdom Localizations
37920F74U0427LR42SOP5 Levy / Rate Table - UK - 43Files74U: United Kingdom Localizations
38920F74U0429CR131SPL Cross Reference Table - UK - 43Files74U: United Kingdom Localizations
39920F74U0430SG151Authenticated Receipts Letter Text - UK - 43Files74U: United Kingdom Localizations
40920F74U0431LL163SPC ATR Late Letter Generation - UK - 43Files74U: United Kingdom Localizations
41920F74U0445RN221SPC Accounts Payable Match Doc Detail Tag File - UK - 43Files74U: United Kingdom Localizations
42920F74U0450SP251CIS Special Payee Rules - UK - 04Files74U: United Kingdom Localizations
43920F74U0451SC151Sub-contractor/Special Payee Cross Reference - UK - 04Files74U: United Kingdom Localizations
44920F74U0452SP151Special Payee Definitions - UK - 04Files74U: United Kingdom Localizations
45920F74U071TPD211Property Unit Tag - 15Files74: EMEA LocalizationBusiness Data
46920F74U203AP4291Billing Pattern - Periodic - 15Files74: EMEA LocalizationBusiness Data
47920F74U203BP5161Billing Pattern - Weekly - 15Files74: EMEA LocalizationBusiness Data
48920F74U207AP9221Payment Profile Status History - 15Files74: EMEA LocalizationBusiness Data
49920F74U207BPA241Periodic Accounting Profile Status History - 15Files74: EMEA LocalizationBusiness Data
50920F74U207CPH251Weekly Accounting Profile Status History - 15Files74: EMEA LocalizationBusiness Data
51920F74U210WPL92Global Generation Currency Work Table - 15Files74: EMEA LocalizationBusiness Data
52920F74U25BTPK211Interest Tag Table - 15Files74: EMEA LocalizationBusiness Data
53920F74U4010SI112HMRC Subontractor Information - UK - 04Files74U: United Kingdom Localizations
54920F74U4015IR82AB - HMRC Information Relation - UK - 04Files74U: United Kingdom Localizations
55920F74U4020VS101Subcontrator Verification Status - UK -04Files74U: United Kingdom Localizations
56920F74U4030VD151CIS Withholding Verification Detail - UK - 04Files74U: United Kingdom Localizations
57920F74U4051HM243Header - CIS Monthly Return - UK - 04Files74U: United Kingdom Localizations
58920F74U4052SM241Subcontractor Detail - CIS Monthly Return - UK - 04Files74U: United Kingdom Localizations
59920F74U4053DM191Subcontractor Documents Detail - CIS Monthly Return - UK- 04Files74U: United Kingdom Localizations
60920F74U420APA222SPC Application Amount Drill Down - UK - 43Files74U: United Kingdom Localizations
61920F74U421AAH132SPC Application Approval History - UK - 43Files74U: United Kingdom Localizations
62920F74U421BAD92Application Approval Delegates - UK - 43Files74U: United Kingdom Localizations
63920F74U424APL315SPC Subcontractor Accrual Data - UK - 43Files74U: United Kingdom Localizations
64920F74U424WWF305SPC Subcontractor Accrual Workfile - UK - 43Files74U: United Kingdom Localizations
65920F74U4311PT111EPM - Purchase Order Tag File - 74UFiles74: EMEA LocalizationBusiness Data
66920F74U4312SC292SPC - Purchase Order Additional Information - UK - 43Extra Features Files74U: United Kingdom Localizations
67920F74U4314SD172SPC - Purchase Order Retention - UK - 43Extra Features Files74U: United Kingdom Localizations
68920F74U4316SC452SPC - Purchase Order Line Additional Information - UK - 43Extra Features Files74U: United Kingdom Localizations
69920F74U4318SD182SPC - Purchase Order Line Retention - UK - 43Extra Features Files74U: United Kingdom Localizations
70920F74U4319CS181SPC Cumulative Labour Material Split - UK - 43Files74U: United Kingdom Localizations
71920F74U4320TV101Requisition Template Qestions - UK - 43Files74U: United Kingdom Localizations
72920F74U4321RA221Requisition Template Answers - UK - 43Files74U: United Kingdom Localizations
73920F74UCW01CW21CIS Voucher Entry Workfile - UK - 04Files74U: United Kingdom Localizations
74920F74UCW02CV61CIS Voucher Entry Workfile 2 - UK - 04Files74U: United Kingdom Localizations
75920F74UCW03VM162CIS Voucher Match Workfile - UK - 04Files74U: United Kingdom Localizations
76920F74UUI51HM243Header - XML Work File CIS Monthly Return - UK - 04Files74U: United Kingdom Localizations
77920F74UUI52SM241Subcontractor Detail - XML WF CIS Monthly Return - UK - 04Files74U: United Kingdom Localizations