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

72 columns | Print definition?812 | ECST

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0018Sales/Use/V.A.T. Tax File10TDECSTAmount - Extended CostNumericGeneric Edit152
TOP04: Accounts Payable
2F09UI006Tax (F0018) Replica10TDECSTAmount - Extended CostNumericGeneric Edit152
TOP32: Configuration Management
3F3215Configurator Component Table20CCECSTAmount - Extended CostNumericGeneric Edit152
4F32159Configurator Component History Table20CHECSTAmount - Extended CostNumericGeneric Edit152
5F3216Configurator Price/Cost Table10PCECSTAmount - Extended CostNumericGeneric Edit152
6F32169Configurator Price/Cost History10KBECSTAmount - Extended CostNumericGeneric Edit152
TOP39: Advanced Stock Valuation
7F39121WAdditional Quantity Work File10AQECSTAmount - Extended CostNumericGeneric Edit152
TOP40: Inventory/OP Base
8F4011ZBatch Receiver File - Order Details99SZECSTAmount - Extended CostNumericGeneric Edit152
9F4012ZWWF - Destination Quantity33SPECSTAmount - Extended CostNumericGeneric Edit152
10F4211Z1Sales Order Detail Unedited Transaction File96SZECSTAmount - Extended CostNumericGeneric Edit152
11F4215Shipment Header27XHECSTAmount - Extended CostNumericGeneric Edit152
TOP41: Inventory Management
12F41051Average Cost Work file7CHECSTAmount - Extended CostNumericGeneric Edit152
13F41UI003ABC Analysis Detail - Work File9AAECSTAmount - Extended CostNumericGeneric Edit152
TOP41B: Bulk Stock Management
14F41511Bulk Product Transaction File41PAECSTAmount - Extended CostNumericGeneric Edit152
TOP42: Sales Management
15F4211Sales Order Detail File83SDECSTAmount - Extended CostNumericGeneric Edit152
16F42119Sales Order History File83SDECSTAmount - Extended CostNumericGeneric Edit152
17F42199S.O. Detail Ledger File83SLECSTAmount - Extended CostNumericGeneric Edit152
18F42565Invoice Print File28IWECSTAmount - Extended CostNumericGeneric Edit152
19F42UI11SO Detail Cache File (MBF)71ZDECSTAmount - Extended CostNumericGeneric Edit152
20F42UI521Pick Slips Detail File76S9ECSTAmount - Extended CostNumericGeneric Edit152
21F42UI800Sales Detail Work File - Sales Update20SDECSTAmount - Extended CostNumericGeneric Edit152
TOP42B: Sales Order Entry
22F42420Audit Log Transaction38ALECSTAmount - Extended CostNumericGeneric Edit152
TOP43: Procurement
23F43080Approvals Fields Constants84PDECSTAmount - Extended CostNumericGeneric Edit152
24F4311Purchase Order Detail File78PDECSTAmount - Extended CostNumericGeneric Edit152
25F4311ZPurchase Order Generator File82PWECSTAmount - Extended CostNumericGeneric Edit152
26F4311Z1Purchase Order Detail Unedited Transaction Table91SZECSTAmount - Extended CostNumericGeneric Edit152
27F43121Purchase Order Receiver File79PRECSTAmount - Extended CostNumericGeneric Edit152
28F43121ZReceiver workfile66PWECSTAmount - Extended CostNumericGeneric Edit152
29F43121Z1Receipts Unedited Transaction Table96SZECSTAmount - Extended CostNumericGeneric Edit152
30F4314ZVoucher Match Selection File179PNECSTAmount - Extended CostNumericGeneric Edit152
31F43199P.O. Detail Ledger File - Flexible Version78OLECSTAmount - Extended CostNumericGeneric Edit152
TOP43A: Purchase Order Receipt/Routing
32F43126Purchase Order Receiver Multiple Account33P4ECSTAmount - Extended CostNumericGeneric Edit152
TOP45: Advanced Pricing
33F4576Z1Ship and Debit Claims Unedited Transaction Table145Z1ECSTAmount - Extended CostNumericGeneric Edit152
TOP46: Warehouse Management
34F4942Z1Work File for F494240SYECSTAmount - Extended CostNumericGeneric Edit152
TOP47: Electronic Commerce
35F47012EDI Purchase Order Detail - Inbound100SZECSTAmount - Extended CostNumericGeneric Edit152
36F47017EDI Purchase Order Detail - Outbound92SZECSTAmount - Extended CostNumericGeneric Edit152
37F47022EDI P.O. Acknowledgment Detail - Inbound92SZECSTAmount - Extended CostNumericGeneric Edit152
38F47027EDI P.O. Acknowledgment Detail - Outbound100SZECSTAmount - Extended CostNumericGeneric Edit152
39F47032EDI Shipping Notice Detail - Inbound67SZECSTAmount - Extended CostNumericGeneric Edit152
40F47037EDI Shipping Notice Detail - Outbound95SZECSTAmount - Extended CostNumericGeneric Edit152
41F470371EDI Shipping Notice Detail - Outbound106SZECSTAmount - Extended CostNumericGeneric Edit152
42F47047EDI Invoice Detail (Sales) - Outbound100SZECSTAmount - Extended CostNumericGeneric Edit152
43F47072EDI Receiving Advice Detail - Inbound93SZECSTAmount - Extended CostNumericGeneric Edit152
44F47077EDI Receiving Advice Detail - Outbound93SZECSTAmount - Extended CostNumericGeneric Edit152
45F47092EDI Request for Quote Detail - Inbound100SZECSTAmount - Extended CostNumericGeneric Edit152
46F47097EDI Request for Quote Detail - Outbound92SZECSTAmount - Extended CostNumericGeneric Edit152
47F47102EDI Response to RFQ Detail - Inbound92SZECSTAmount - Extended CostNumericGeneric Edit152
48F47107EDI Response to RFQ Detail - Outbound100SZECSTAmount - Extended CostNumericGeneric Edit152
49F47132EDI Purchase Order Change Detail - Inbound101SZECSTAmount - Extended CostNumericGeneric Edit152
50F47137EDI Purchase Order Change Detail - Outbound93SZECSTAmount - Extended CostNumericGeneric Edit152
51F47142EDI P.O. Change Acknowledgment Detail - Inbound94SZECSTAmount - Extended CostNumericGeneric Edit152
52F47147EDI P.O. Change Acknowledgment Detail - Outbound102SZECSTAmount - Extended CostNumericGeneric Edit152
53F47157EDI Shipping Schedule Detail - Outbound99SZECSTAmount - Extended CostNumericGeneric Edit152
54F47UI001ASN Extract Work File38SZECSTAmount - Extended CostNumericGeneric Edit152
TOP49: Transportation Management
55F4941Shipment Routing Steps39RSECSTAmount - Extended CostNumericGeneric Edit152
56F4942Shipment Detail23ISECSTAmount - Extended CostNumericGeneric Edit152
57F4963Load In-transit14TIECSTAmount - Extended CostNumericGeneric Edit152
58F49631Load In-transit Ledger57TOECSTAmount - Extended CostNumericGeneric Edit152
59F49632Load In-transit Left on Board16LBECSTAmount - Extended CostNumericGeneric Edit152
60F49633Load In-Transit Confirmed Quantities25IQECSTAmount - Extended CostNumericGeneric Edit152
61F49634Load In-Transit Confirmed Quantities Detail16QDECSTAmount - Extended CostNumericGeneric Edit152
TOP55: Reserved for Clients
62F55IF421Sales Order per BO89SDECSTAmount - Extended CostNumericGeneric Edit152
63F55IF425Sales Order per BO - 200589SDECSTAmount - Extended CostNumericGeneric Edit152
64F55IFP01Kit Pricing File48KPECSTAmount - Extended CostNumericGeneric Edit152
65F55IFSFVEstrazione del venduto per Sales Force Automation28FSECSTAmount - Extended CostNumericGeneric Edit152
66F55W0100Correction Invoice Print - WF184SDECSTAmount - Extended CostNumericGeneric Edit152
TOP74: EMEA Localization
67F74093Workfile for Printing IVA Summary - Italy10HCECSTAmount - Extended CostNumericGeneric Edit152
TOP76B: Brazil - Reporting System Only
68F76B50Item Ledger Table - IN68 - 4214CEECSTAmount - Extended CostNumericGeneric Edit152
69F76B51Inventory Records Table - IN68 - 4210RIECSTAmount - Extended CostNumericGeneric Edit152
TOP76C: Colombia
70F76CT2Sales/Use/V.A.T. Tax File - COL - 76C16CTECSTAmount - Extended CostNumericGeneric Edit152
TOP89: Conversion Programs
71F43199ATemp F43199 for ERP 9.0 Upgrade78OLECSTAmount - Extended CostNumericGeneric Edit152
TOPH90: ONEWORLD TOOLS
72F99DTLWorkflow Demonstration Sales Order Detail9WDECSTAmount - Extended CostNumericGeneric Edit152