JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides | 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
9F03012AICustomer Master by Line of Business
10F0006MCBusiness Unit Master

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
9F4801WAWork Order Master File
10F42119SDSales Order History File
PHPRef.com - the webs number one PHP Function reference tool

63 tables910 | 41

41: Inventory Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F400391DE91Document Type Exclusion RulesFiles41: Inventory Management
2910F410014T7843Template MasterMaster Files41: Inventory ManagementBusiness Data
3910F410014DT8191Template Master - Alternative DescriptionFiles41: Inventory ManagementBusiness Data
4910F41001T1CI81Inventory Constants Tag FileConstants Files41: Inventory ManagementBusiness Data
5910F41006IK21Transaction Type Document Family FileExtra Features Files41: Inventory ManagementBusiness Data
6910F41008S0342Matrix DetailFiles41: Inventory ManagementBusiness Data
7910F41008DS0202Matrix Detail Alternate LanguageFiles41: Inventory ManagementBusiness Data
8910F41009T9443Child Item Combination TableFiles41: Inventory ManagementBusiness Data
9910F4101IM2098Item MasterMaster Files41: Inventory ManagementBusiness Data
10910F41013UN142Unique Product NumberFiles41: Inventory Management
11910F4101AIM1361Item FileSecondary Master Files41: Inventory ManagementBusiness Data
12910F4101BIM551Item Master Bulk DataSecondary Master Files41: Inventory ManagementBusiness Data
13910F4101CIM391Item Category CodesSecondary Master Files41: Inventory ManagementBusiness Data
14910F4101DIM136Item Master - Alternative DescriptionMaster Files41: Inventory ManagementBusiness Data
15910F4101FIM291Item Customer Service DataSecondary Master Files41: Inventory ManagementBusiness Data
16910F4101GIB201Item Branch QuantitiesSecondary Master Files41: Inventory ManagementBusiness Data
17910F4101HIH83Item Hierarchy (Web)Extra Features Files42B: Sales Order EntryBusiness Data
18910F4101HDIH41Item Hierarchy - Alternate DescriptionExtra Features Files42B: Sales Order EntryBusiness Data
19910F4101MIM811Item Manufacturing DataSecondary Master Files41: Inventory ManagementBusiness Data
20910F4101PIM281Item Master PackagingSecondary Master Files41: Inventory ManagementBusiness Data
21910F4101SIM311Item Master Shipping DataSecondary Master Files41: Inventory ManagementBusiness Data
22910F4101WIM351Item Profile DataSecondary Master Files41: Inventory ManagementBusiness Data
23910F4101Z1SZ2621F4101 Item Master Unedited Transaction TableMaster Files41: Inventory ManagementBusiness Data
24910F4101Z1ASZ1201F4101 Detail Item Master Unedited TransactionTransaction Files41: Inventory ManagementBusiness Data
25910F4102IB17611Item Branch FileSecondary Master Files41: Inventory ManagementBusiness Data
26910F41021LI547Item Location FileBalance Files41: Inventory ManagementBusiness Data
27910F410211PC82Project Commitment Detail TableFiles41: Inventory ManagementBusiness Data
28910F41021ALI51Item Location File - Temporary UpgradeFiles41: Inventory Management
29910F41021TLT231Item Location Tag FileFiles41: Inventory Management
30910F41021WFLW582F41021 Transaction WorkfileBalance Files41: Inventory ManagementBusiness Data
31910F41021Z1SZ711Item Location Unedited Transaction FileMaster Files41: Inventory ManagementBusiness Data
32910F41023IL121Item Location Definition TableMaster Files41: Inventory ManagementBusiness Data
33910F41025CS232Consignment Sites (FUTURE)Files41: Inventory Management
34910F4105CO257Item Cost FileMaster Files41: Inventory ManagementBusiness Data
35910F41051CH112Average Cost Work fileMaster Files41: Inventory ManagementBusiness Data
36910F4105Z1SZ391Unedited Transaction Table - Item CostTransaction Files41: Inventory ManagementBusiness Data
37910F41081LS141Allowed Lot StatusFiles41: Inventory Management
38910F41090T1212Item Supplemental Data TypesConstants Files41: Inventory ManagementBusiness Data
39910F41092T2164Item Supplemental Data Base User Defined CodesTransaction Files41: Inventory ManagementBusiness Data
40910F41095T544User Sequence PreferenceExtra Features Files41: Inventory ManagementBusiness Data
41910F4111IL7213Item Ledger FileTransaction Files41: Inventory ManagementBusiness Data
42910F41113I8271Lot LedgerFiles41: Inventory ManagementBusiness Data
43910F41131IU271Stranded Hard Commitments TableFiles41: Inventory ManagementBusiness Data
44910F4115IH1851Item HistoryHistory Files41: Inventory ManagementBusiness Data
45910F4118CN442Container Deposit FileMaster Files41: Inventory ManagementBusiness Data
46910F41181CM527Container Transaction FileTransaction Files41: Inventory ManagementBusiness Data
47910F41182CS81Container SerialFiles41: Inventory ManagementBusiness Data
48910F41185CT211Container Reconciliation FileBatch Input Files41: Inventory ManagementBusiness Data
49910F41291ZIG331Landed Cost Cache TableFiles41: Inventory ManagementBusiness Data
50910F4130MH241Consignment Master Header (FUTURE)Files41: Inventory Management
51910F4131MD232Consignment Master Detail (FUTURE)Files41: Inventory Management
52910F4132UH342Usage Header (FUTURE)Files41: Inventory Management
53910F4133UD494Usage Detail (FUTURE)Files41: Inventory Management
54910F4140PI112Cycle Count Header FileExtra Features Files41: Inventory ManagementBusiness Data
55910F4141PJ344Cycle Count Transaction FileExtra Features Files41: Inventory ManagementBusiness Data
56910F4141TPC303Cycle Count Transaction Tag FileFiles41: Inventory Management
57910F4141Z1SZ491F4141 Cycle Count Unedited Transaction TableMaster Files41: Inventory ManagementBusiness Data
58910F4160IT315Tag Inventory FileExtra Features Files41: Inventory ManagementBusiness Data
59910F41829IW21Item Word Search TableFiles41: Inventory ManagementBusiness Data
60910F4190IG21Item GroupsFiles41: Inventory ManagementBusiness Data
61910F41UI001IT2472Inventory Transactions Detail File"T" Work Files41: Inventory ManagementBusiness Data
62910F41UI002TI241Inventory Transactions Batch File"T" Work Files41: Inventory ManagementBusiness Data
63910F41UI003AA102ABC Analysis Detail - Work File"T" Work Files41: Inventory ManagementBusiness Data