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
2F0101ABAddress Book Master
3F4311PDPurchase Order Detail File
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File

80 columns | Print definition?920 | EFFF

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP09: General Accounting
1F0050AStructure Definition File43MAEFFFEffective - From DateDateGeneric Edit60
TOP10: Financial Reporting
2F0050BBusiness Unit Structure Build File43MAEFFFEffective - From DateDateGeneric Edit60
3F10430AAccount Structure Definition21CGEFFFEffective - From DateDateGeneric Edit60
TOP12: Fixed Assets
4F1217Equipment Master Extension57WREFFFEffective - From DateDateGeneric Edit60
5F1217PEquipment Master Extension Purge Table57WREFFFEffective - From DateDateGeneric Edit60
6F1217Z1Unedited Equipment Tag Transactions61WREFFFEffective - From DateDateGeneric Edit60
7F1217Z2Unedited Equipment Tag Transactions61WREFFFEffective - From DateDateGeneric Edit60
TOP13: Plant/Equipment Management
8F13017Equipment Parts List17PLEFFFEffective - From DateDateGeneric Edit60
TOP16: Profit Management (EPS)
9F1610Cost Calculation Definitions63CDEFFFEffective - From DateDateGeneric Edit60
10F1642Rate Master Header File7RHEFFFEffective - From DateDateGeneric Edit60
TOP30: Product Data Management
11F3002Z1Bill of Material Transaction File31SZEFFFEffective - From DateDateGeneric Edit60
12F3003TRouting Tag File - not used in B9, obsolete in B106IREFFFEffective - From DateDateGeneric Edit60
13F3003Z1Routing Transactions File24SZEFFFEffective - From DateDateGeneric Edit60
14F30UI008Bill of Material Comparison Work File15IJEFFFEffective - From DateDateGeneric Edit60
15F30UI014BOM Header Work File for BI8BHEFFFEffective - From DateDateGeneric Edit60
16F30UI015BOM Item Fact Work File for BI12BDEFFFEffective - From DateDateGeneric Edit60
17F30UI016BOM Explosion Work File for BI19BEEFFFEffective - From DateDateGeneric Edit60
TOP31: Shop Floor Control
18F3109Line/Item Relationship Master10IPEFFFEffective - From DateDateGeneric Edit60
TOP32: Configuration Management
19F3281Rules Table Definition7RTEFFFEffective - From DateDateGeneric Edit60
20F3282Configured Item/Rules Table Cross Reference5RKEFFFEffective - From DateDateGeneric Edit60
21F32821Rules Table Value Definition6RLEFFFEffective - From DateDateGeneric Edit60
22F3283Rules Table Detail26RDEFFFEffective - From DateDateGeneric Edit60
23F3291Configured Item Segments6KWEFFFEffective - From DateDateGeneric Edit60
24F3292Cross Segment Editing Rules7KUEFFFEffective - From DateDateGeneric Edit60
25F32921Cross Segment Editing Rules - Values7KXEFFFEffective - From DateDateGeneric Edit60
26F32922Cross Segment Editing Rules - Range8KVEFFFEffective - From DateDateGeneric Edit60
27F3293Assembly Inclusions Rules34KYEFFFEffective - From DateDateGeneric Edit60
TOP33: Capacity Planning
28F3303Capacity Resource Profile11CTEFFFEffective - From DateDateGeneric Edit60
TOP34: Requirements Planning
29F3403Branch Relationships Master File9MPEFFFEffective - From DateDateGeneric Edit60
30F3404Co-Products Planning/Costing Table5PMEFFFEffective - From DateDateGeneric Edit60
31F43211Supplier Schedule Master File7SSEFFFEffective - From DateDateGeneric Edit60
TOP34A: Advanced Planning & Scheduling
32F34A120Routing Master Resource Table6N0EFFFEffective - From DateDateGeneric Edit60
33F34A180Routing Master Resource Set6RREFFFEffective - From DateDateGeneric Edit60
34F34A190Routing Master Resource and Set XRef6RDEFFFEffective - From DateDateGeneric Edit60
TOP34X: In-Memory Planning Advisor
35F34X310WPlanning Advisor BOM Component Detail Table31PDEFFFEffective - From DateDateGeneric Edit60
TOP36: Forecasting
36F34007Forecast Prices5FHEFFFEffective - From DateDateGeneric Edit60
TOP37: Quality Management
37F3701Test Definitions Master File6QAEFFFEffective - From DateDateGeneric Edit60
38F3702Specifications Definitions Master File4QSEFFFEffective - From DateDateGeneric Edit60
39F37021Specifications Detail File4QDEFFFEffective - From DateDateGeneric Edit60
40F3711Test Results41TREFFFEffective - From DateDateGeneric Edit60
41F3711Z1Test Results Unedited Transaction Table54SZEFFFEffective - From DateDateGeneric Edit60
42F37900Certificate of Analysis (COA) Extract41TREFFFEffective - From DateDateGeneric Edit60
43F40318Preference Profile - Quality Management14QCEFFFEffective - From DateDateGeneric Edit60
TOP40: Inventory/OP Base
44F3002Bill of Material Master File18IXEFFFEffective - From DateDateGeneric Edit60
45F3003Routing Master File11IREFFFEffective - From DateDateGeneric Edit60
46F3011Bill of Materials Change File18IZEFFFEffective - From DateDateGeneric Edit60
47F3013ECO Parts List Detail23CYEFFFEffective - From DateDateGeneric Edit60
48F3015Component Locator File4CQEFFFEffective - From DateDateGeneric Edit60
49F40318RPreference Resolution Ledger - Quality Management16QCEFFFEffective - From DateDateGeneric Edit60
TOP41: Inventory Management
50F4101AItem File7IMEFFFEffective - From DateDateGeneric Edit60
51F4101BItem Master Bulk Data7IMEFFFEffective - From DateDateGeneric Edit60
52F4101CItem Category Codes7IMEFFFEffective - From DateDateGeneric Edit60
53F4101FItem Customer Service Data7IMEFFFEffective - From DateDateGeneric Edit60
54F4101GItem Branch Quantities7IBEFFFEffective - From DateDateGeneric Edit60
55F4101MItem Manufacturing Data7IMEFFFEffective - From DateDateGeneric Edit60
56F4101PItem Master Packaging7IMEFFFEffective - From DateDateGeneric Edit60
57F4101SItem Master Shipping Data7IMEFFFEffective - From DateDateGeneric Edit60
58F4101WItem Profile Data7IMEFFFEffective - From DateDateGeneric Edit60
TOP43: Procurement
59F41291Item Cost Components17IGEFFFEffective - From DateDateGeneric Edit60
TOP44H: Homebuilder Management
60F4459Material Item Pricing (World)8JLEFFFEffective - From DateDateGeneric Edit60
61F4461Option Master (World)31JNEFFFEffective - From DateDateGeneric Edit60
62F44H603Material Item Pricing6MPEFFFEffective - From DateDateGeneric Edit60
63F44H604Vendor Assignment7VAEFFFEffective - From DateDateGeneric Edit60
64F44H604WVendor Assignment Workfile10VWEFFFEffective - From DateDateGeneric Edit60
65F44H604ZHB Vendor Assignment Unedited Transaction File20SZEFFFEffective - From DateDateGeneric Edit60
TOP74U: United Kingdom Localizations
66F74U420ASPC Application Amount Drill Down - UK - 4316PAEFFFEffective - From DateDateGeneric Edit60
67F74U421BApplication Approval Delegates - UK - 433ADEFFFEffective - From DateDateGeneric Edit60
TOP75I: India
68F75I791Item/Supplier Cost Components - IND - 43B18ISEFFFEffective - From DateDateGeneric Edit60
TOP75T: Taiwan
69F75T002GUI/VAT Number Register - 75T7NREFFFEffective - From DateDateGeneric Edit60
70F75T0029GUI/VAT Number Register History - 75T7NREFFFEffective - From DateDateGeneric Edit60
71F75T003GUI/VAT Number Segment - 75T10NSEFFFEffective - From DateDateGeneric Edit60
72F75T0039GUI/VAT Number Segment History - 75T10NSEFFFEffective - From DateDateGeneric Edit60
TOP76B: Brazil
73F76B0765Item Change Track - BRA - 76B2CTEFFFEffective - From DateDateGeneric Edit60
74F76B3010Work Table for Item/Part List - 3012IPEFFFEffective - From DateDateGeneric Edit60
TOP76H: Chile
75F76H6003Indirect Costs Selection EPS F1642 - CHI - 41 - 76H10I2EFFFEffective - From DateDateGeneric Edit60
TOP76V: Venezuela
76F76V4010Tributary Unit Setup - 04 - VE2ISEFFFEffective - From DateDateGeneric Edit60
77F76V410Tributary Unit Setup - VEN - 042TUEFFFEffective - From DateDateGeneric Edit60
TOPF30L: DFM Line Design
78FF30L002DFM Bill of Material Master14DHEFFFEffective - From DateDateGeneric Edit60
79FF30L930DFM Routings10LREFFFEffective - From DateDateGeneric Edit60
TOPH79: Translation Tools
80F7901Language Master6LMEFFFEffective - From DateDateGeneric Edit60