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

61 columns | Print definition?920 | FSCID

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOPF30L: DFM Line Design
1FF30L002DFM Bill of Material Master62DHFSCIDScenario IDNumericGeneric Edit150
2FF30L005DFM Task Master4TMFSCIDScenario IDNumericGeneric Edit150
3FF30L010Scenario Master1SCFSCIDScenario IDNumericGeneric Edit150
4FF30L011Line Design Control Parameters1LDFSCIDScenario IDNumericGeneric Edit150
5FF30L012Kanban Control Parameters1KBFSCIDScenario IDNumericGeneric Edit150
6FF30L013Default User Scenario2DSFSCIDScenario IDNumericGeneric Edit150
7FF30L014Branch/Plant Master2BPFSCIDScenario IDNumericGeneric Edit150
8FF30L015Resource Master2REFSCIDScenario IDNumericGeneric Edit150
9FF30L016Default User Branch/Plant2DBFSCIDScenario IDNumericGeneric Edit150
10FF30L017DFM Work Center Master1WMFSCIDScenario IDNumericGeneric Edit150
11FF30L101Mixed Model Family Master2FMFSCIDScenario IDNumericGeneric Edit150
12FF30L102Mixed Model Family Items4FDFSCIDScenario IDNumericGeneric Edit150
13FF30L110Standard Sequence Of Events5SSFSCIDScenario IDNumericGeneric Edit150
14FF30L115Sequence Of Events10SEFSCIDScenario IDNumericGeneric Edit150
15FF30L116Components Consumed7CCFSCIDScenario IDNumericGeneric Edit150
16FF30L117DFM Event Summary Table2ESFSCIDScenario IDNumericGeneric Edit150
17FF30L201Volume Design Master2VMFSCIDScenario IDNumericGeneric Edit150
18FF30L202Volume By Family3VFFSCIDScenario IDNumericGeneric Edit150
19FF30L203Volume By Family By Part5FPFSCIDScenario IDNumericGeneric Edit150
20FF30L301DFM Customer Master2CMFSCIDScenario IDNumericGeneric Edit150
21FF30L401DFM Supplier Master2SMFSCIDScenario IDNumericGeneric Edit150
22FF30L501DFM Item Definition Master1IBFSCIDScenario IDNumericGeneric Edit150
23FF30L512DFM Item Units of Measure Conversion Factors3UMFSCIDScenario IDNumericGeneric Edit150
24FF30L601DFM Employee Master2EMFSCIDScenario IDNumericGeneric Edit150
25FF30L701DFM Process Master12PMFSCIDScenario IDNumericGeneric Edit150
26FF30L702Path Master5PHFSCIDScenario IDNumericGeneric Edit150
27FF30L703Process Path Relationship14PPFSCIDScenario IDNumericGeneric Edit150
28FF30L707Path Links12PLFSCIDScenario IDNumericGeneric Edit150
29FF30L708Product Synchronization Results4PSFSCIDScenario IDNumericGeneric Edit150
30FF30L801Sales Order Master4SDFSCIDScenario IDNumericGeneric Edit150
31FF30L901Process Map Header Table2PHFSCIDScenario IDNumericGeneric Edit150
32FF30L902Process Map Detail Table2PDFSCIDScenario IDNumericGeneric Edit150
33FF30L904Process Map Work Content Table2WCFSCIDScenario IDNumericGeneric Edit150
34FF30L905Cell Master4CMFSCIDScenario IDNumericGeneric Edit150
35FF30L910Mixed Model Line Design Header3LHFSCIDScenario IDNumericGeneric Edit150
36FF30L911Mixed Model Line Design Detail4LDFSCIDScenario IDNumericGeneric Edit150
37FF30L912Line Master4LMFSCIDScenario IDNumericGeneric Edit150
38FF30L920Total Product Cycle Time Header4CHFSCIDScenario IDNumericGeneric Edit150
39FF30L921Total Product Cycle Time Detail5CLFSCIDScenario IDNumericGeneric Edit150
40FF30L930DFM Routings1LRFSCIDScenario IDNumericGeneric Edit150
41FF30L950DFM Operation Definition Header8ODFSCIDScenario IDNumericGeneric Edit150
42FF30L951DFM Operation Definition Detail7OMFSCIDScenario IDNumericGeneric Edit150
43FF30L990DFM Data Move Configuration Header3MHFSCIDScenario IDNumericGeneric Edit150
44FF30L991DFM Data Move Configuration Detail18MDFSCIDScenario IDNumericGeneric Edit150
TOPF31K: DFM Kanban Management
45FF31K10DFM Kanban Flow Capacity1FCFSCIDScenario IDNumericGeneric Edit150
46FF31K11DFM Kanban Parent Items1PIFSCIDScenario IDNumericGeneric Edit150
47FF31K20DFM Kanban Component1KCFSCIDScenario IDNumericGeneric Edit150
48FF31K21DFM Kanban Component Pull Chain1CPFSCIDScenario IDNumericGeneric Edit150
49FF31K22DFM Kanban Component Pull Sequence1PSFSCIDScenario IDNumericGeneric Edit150
50FF31K25DFM Kanban Master -- TEMP1KMFSCIDScenario IDNumericGeneric Edit150
51FF31K30DFM Kanban Master1KMFSCIDScenario IDNumericGeneric Edit150
52FF31K41DFM Kanban Pull Chain1PCFSCIDScenario IDNumericGeneric Edit150
53FF31K42DFM Kanban Location1LCFSCIDScenario IDNumericGeneric Edit150
54FF31K50DFM Kanban Constants1DFFSCIDScenario IDNumericGeneric Edit150
55FF31K51DFM Kanban Resize Filter1RFFSCIDScenario IDNumericGeneric Edit150
TOPF34R: DFM Resource Management
56FF34R010Resource Design Master7RMFSCIDScenario IDNumericGeneric Edit150
57FF34R011Resource Calendar Master3RCFSCIDScenario IDNumericGeneric Edit150
58FF34R012Resource Simulation Master8RSFSCIDScenario IDNumericGeneric Edit150
TOPF34S: DFM Production Sequencing
59FF34S001Sequence Detail1SQFSCIDScenario IDNumericGeneric Edit150
60FF34S002Daily Plan2DPFSCIDScenario IDNumericGeneric Edit150
61FF34S003DFM Planning Parameters1PPFSCIDScenario IDNumericGeneric Edit150