JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.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
6F4102IBItem Branch File
7F0411RPAccounts Payable Ledger
8F41021LIItem Location File
9F0006MCBusiness Unit Master
10F03012AICustomer Master by Line of Business

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F4311PDPurchase Order Detail File
8F03B11RPCustomer Ledger
9F0411RPAccounts Payable Ledger
10F07831YBEmployee State/Local Control Table

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4211SDSales Order Detail File
4F4311PDPurchase Order Detail File
5F0411RPAccounts Payable Ledger
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F03012AICustomer Master by Line of Business
9F42119SDSales Order History File
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

63 tables920 | 41

41: Inventory Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F400391DE91Document Type Exclusion RulesFiles41: Inventory Management
2920F410014T7843Template MasterMaster Files41: Inventory ManagementBusiness Data
3920F410014DT8191Template Master - Alternative DescriptionFiles41: Inventory ManagementBusiness Data
4920F41001T1CI81Inventory Constants Tag FileConstants Files41: Inventory ManagementBusiness Data
5920F41006IK21Transaction Type Document Family FileExtra Features Files41: Inventory ManagementBusiness Data
6920F41008S0342Matrix DetailFiles41: Inventory ManagementBusiness Data
7920F41008DS0202Matrix Detail Alternate LanguageFiles41: Inventory ManagementBusiness Data
8920F41009T9443Child Item Combination TableFiles41: Inventory ManagementBusiness Data
9920F4101IM2098Item MasterMaster Files41: Inventory ManagementBusiness Data
10920F41013UN142Unique Product NumberFiles41: Inventory Management
11920F4101AIM1361Item FileSecondary Master Files41: Inventory ManagementBusiness Data
12920F4101BIM551Item Master Bulk DataSecondary Master Files41: Inventory ManagementBusiness Data
13920F4101CIM391Item Category CodesSecondary Master Files41: Inventory ManagementBusiness Data
14920F4101DIM136Item Master - Alternative DescriptionMaster Files41: Inventory ManagementBusiness Data
15920F4101FIM291Item Customer Service DataSecondary Master Files41: Inventory ManagementBusiness Data
16920F4101GIB201Item Branch QuantitiesSecondary Master Files41: Inventory ManagementBusiness Data
17920F4101HIH83Item Hierarchy (Web)Extra Features Files42B: Sales Order EntryBusiness Data
18920F4101HDIH41Item Hierarchy - Alternate DescriptionExtra Features Files42B: Sales Order EntryBusiness Data
19920F4101MIM811Item Manufacturing DataSecondary Master Files41: Inventory ManagementBusiness Data
20920F4101PIM281Item Master PackagingSecondary Master Files41: Inventory ManagementBusiness Data
21920F4101SIM311Item Master Shipping DataSecondary Master Files41: Inventory ManagementBusiness Data
22920F4101WIM351Item Profile DataSecondary Master Files41: Inventory ManagementBusiness Data
23920F4101Z1SZ2621F4101 Item Master Unedited Transaction TableMaster Files41: Inventory ManagementBusiness Data
24920F4101Z1ASZ1201F4101 Detail Item Master Unedited TransactionTransaction Files41: Inventory ManagementBusiness Data
25920F4102IB17613Item Branch FileSecondary Master Files41: Inventory ManagementBusiness Data
26920F41021LI547Item Location FileBalance Files41: Inventory ManagementBusiness Data
27920F410211PC82Project Commitment Detail TableFiles41: Inventory ManagementBusiness Data
28920F41021ALI51Item Location File - Temporary UpgradeFiles41: Inventory Management
29920F41021TLT231Item Location Tag FileFiles41: Inventory Management
30920F41021WFLW582F41021 Transaction WorkfileBalance Files41: Inventory ManagementBusiness Data
31920F41021Z1SZ711Item Location Unedited Transaction FileMaster Files41: Inventory ManagementBusiness Data
32920F41023IL121Item Location Definition TableMaster Files41: Inventory ManagementBusiness Data
33920F41025CS232Consignment Sites (FUTURE)Files41: Inventory Management
34920F4105CO257Item Cost FileMaster Files41: Inventory ManagementBusiness Data
35920F41051CH112Average Cost Work fileMaster Files41: Inventory ManagementBusiness Data
36920F4105Z1SZ391Unedited Transaction Table - Item CostTransaction Files41: Inventory ManagementBusiness Data
37920F41081LS141Allowed Lot StatusFiles41: Inventory Management
38920F41090T1212Item Supplemental Data TypesConstants Files41: Inventory ManagementBusiness Data
39920F41092T2164Item Supplemental Data Base User Defined CodesTransaction Files41: Inventory ManagementBusiness Data
40920F41095T544User Sequence PreferenceExtra Features Files41: Inventory ManagementBusiness Data
41920F4111IL7213Item Ledger FileTransaction Files41: Inventory ManagementBusiness Data
42920F41113I8271Lot LedgerFiles41: Inventory ManagementBusiness Data
43920F41131IU271Stranded Hard Commitments TableFiles41: Inventory ManagementBusiness Data
44920F4115IH1851Item HistoryHistory Files41: Inventory ManagementBusiness Data
45920F4118CN442Container Deposit FileMaster Files41: Inventory ManagementBusiness Data
46920F41181CM527Container Transaction FileTransaction Files41: Inventory ManagementBusiness Data
47920F41182CS81Container SerialFiles41: Inventory ManagementBusiness Data
48920F41185CT211Container Reconciliation FileBatch Input Files41: Inventory ManagementBusiness Data
49920F41291ZIG331Landed Cost Cache TableFiles41: Inventory ManagementBusiness Data
50920F4130MH241Consignment Master Header (FUTURE)Files41: Inventory Management
51920F4131MD232Consignment Master Detail (FUTURE)Files41: Inventory Management
52920F4132UH342Usage Header (FUTURE)Files41: Inventory Management
53920F4133UD494Usage Detail (FUTURE)Files41: Inventory Management
54920F4140PI112Cycle Count Header FileExtra Features Files41: Inventory ManagementBusiness Data
55920F4141PJ344Cycle Count Transaction FileExtra Features Files41: Inventory ManagementBusiness Data
56920F4141TPC303Cycle Count Transaction Tag FileFiles41: Inventory Management
57920F4141Z1SZ491F4141 Cycle Count Unedited Transaction TableMaster Files41: Inventory ManagementBusiness Data
58920F4160IT315Tag Inventory FileExtra Features Files41: Inventory ManagementBusiness Data
59920F41829IW21Item Word Search TableFiles41: Inventory ManagementBusiness Data
60920F4190IG21Item GroupsFiles41: Inventory ManagementBusiness Data
61920F41UI001IT2482Inventory Transactions Detail File"T" Work Files41: Inventory ManagementBusiness Data
62920F41UI002TI241Inventory Transactions Batch File"T" Work Files41: Inventory ManagementBusiness Data
63920F41UI003AA102ABC Analysis Detail - Work File"T" Work Files41: Inventory ManagementBusiness Data