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

99 columns | Print definition?910 | SHPN

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP03B: Enhanced Accounts Receivable
1F03B11Customer Ledger134RPSHPNShipment NumberNumericGeneric Edit80
2F03B11PCustomer Ledger Purge File134RPSHPNShipment NumberNumericGeneric Edit80
3F03B11Z1Batch Invoices184VJSHPNShipment NumberNumericGeneric Edit80
4F03B11Z2F03B11 Interoperability Table148SYSHPNShipment NumberNumericGeneric Edit80
5F03B14Receipts Detail121RZSHPNShipment NumberNumericGeneric Edit80
6F03B14PReceipts Detail Purge File121RZSHPNShipment NumberNumericGeneric Edit80
7F03B14Z2F03B14 Interoperability Table134SZSHPNShipment NumberNumericGeneric Edit80
8F03B40A/R Deduction Management38RBSHPNShipment NumberNumericGeneric Edit80
9F03B465A/R Netting Workfile55ROSHPNShipment NumberNumericGeneric Edit80
10F03B575Auto Debit Invoice Select and Build144RDSHPNShipment NumberNumericGeneric Edit80
TOP40: Inventory/OP Base
11F4011ZBatch Receiver File - Order Details247SZSHPNShipment NumberNumericGeneric Edit80
12F4211Z1Sales Order Detail Unedited Transaction File237SZSHPNShipment NumberNumericGeneric Edit80
13F4215Shipment Header1XHSHPNShipment NumberNumericGeneric Edit80
14F4217Shipment Reference Numbers1XISHPNShipment NumberNumericGeneric Edit80
TOP40R: Demand Scheduling
15F40R12Cumulative Quantities15CQSHPNShipment NumberNumericGeneric Edit80
16F40R12WFCUM Rollback Workfile18CQSHPNShipment NumberNumericGeneric Edit80
17F40R41Demand History9DISHPNShipment NumberNumericGeneric Edit80
18F40R42Cumulative Quantity History18CHSHPNShipment NumberNumericGeneric Edit80
19F47UI002ASN Extract Packaging Work File6SPSHPNShipment NumberNumericGeneric Edit80
TOP40S: Supply Chain Self Service
20F4947SWSelf-Service Shipment Tracking Work File3SWSHPNShipment NumberNumericGeneric Edit80
TOP42: Sales Management
21F4211Sales Order Detail File224SDSHPNShipment NumberNumericGeneric Edit80
22F42119Sales Order History File224SDSHPNShipment NumberNumericGeneric Edit80
23F42199S.O. Detail Ledger File224SLSHPNShipment NumberNumericGeneric Edit80
24F42565Invoice Print File95IWSHPNShipment NumberNumericGeneric Edit80
25F42UI11SO Detail Cache File (MBF)136ZDSHPNShipment NumberNumericGeneric Edit80
26F42UI12Sales Order Detail Cache 2 (MBF)82ZDSHPNShipment NumberNumericGeneric Edit80
TOP43: Procurement
27F43080Approvals Fields Constants186PDSHPNShipment NumberNumericGeneric Edit80
28F4311Purchase Order Detail File188PDSHPNShipment NumberNumericGeneric Edit80
29F4311ZPurchase Order Generator File224PWSHPNShipment NumberNumericGeneric Edit80
30F4311Z1Purchase Order Detail Unedited Transaction Table202SZSHPNShipment NumberNumericGeneric Edit80
31F43121Purchase Order Receiver File118PRSHPNShipment NumberNumericGeneric Edit80
32F43121ZReceiver workfile135PWSHPNShipment NumberNumericGeneric Edit80
33F43121Z1Receipts Unedited Transaction Table178SZSHPNShipment NumberNumericGeneric Edit80
34F43199P.O. Detail Ledger File - Flexible Version188OLSHPNShipment NumberNumericGeneric Edit80
TOP46: Warehouse Management
35F4600Warehouse Requests90R1SHPNShipment NumberNumericGeneric Edit80
36F4600PUWarehouse Requests - Purged89R1SHPNShipment NumberNumericGeneric Edit80
37F4611Warehouse Suggestions151R2SHPNShipment NumberNumericGeneric Edit80
38F4611PUWarehouse Suggestions - Purged152R2SHPNShipment NumberNumericGeneric Edit80
39F4615Carton Recommendations2CRSHPNShipment NumberNumericGeneric Edit80
40F4620Carton Detail Information16CDSHPNShipment NumberNumericGeneric Edit80
41F46200Bulk Pick Requests27BRSHPNShipment NumberNumericGeneric Edit80
42F46200PUBulk Pick Requests - Purged27BRSHPNShipment NumberNumericGeneric Edit80
43F4622Unusable Label Numbers4ULSHPNShipment NumberNumericGeneric Edit80
44F46UI15Carton Recommendations - Work File2RCSHPNShipment NumberNumericGeneric Edit80
TOP46L: License Plating
45F46L99License Plate History57LMSHPNShipment NumberNumericGeneric Edit80
TOP47: Electronic Commerce
46F47012EDI Purchase Order Detail - Inbound248SZSHPNShipment NumberNumericGeneric Edit80
47F47027EDI P.O. Acknowledgment Detail - Outbound252SZSHPNShipment NumberNumericGeneric Edit80
48F47032EDI Shipping Notice Detail - Inbound160SZSHPNShipment NumberNumericGeneric Edit80
49F47037EDI Shipping Notice Detail - Outbound176SZSHPNShipment NumberNumericGeneric Edit80
50F470371EDI Shipping Notice Detail - Outbound151SZSHPNShipment NumberNumericGeneric Edit80
51F470373EDI ASN Shipping16AGSHPNShipment NumberNumericGeneric Edit80
52F47047EDI Invoice Detail (Sales) - Outbound251SZSHPNShipment NumberNumericGeneric Edit80
53F470472EDI Invoice Expanded Detail (Sales)12S6SHPNShipment NumberNumericGeneric Edit80
54F47072EDI Receiving Advice Detail - Inbound206SZSHPNShipment NumberNumericGeneric Edit80
55F47077EDI Receiving Advice Detail - Outbound207SZSHPNShipment NumberNumericGeneric Edit80
56F47092EDI Request for Quote Detail - Inbound248SZSHPNShipment NumberNumericGeneric Edit80
57F47107EDI Response to RFQ Detail - Outbound248SZSHPNShipment NumberNumericGeneric Edit80
58F47114EDI Lockbox/Payment Detail - Payment44Z4SHPNShipment NumberNumericGeneric Edit80
59F47132EDI Purchase Order Change Detail - Inbound249SZSHPNShipment NumberNumericGeneric Edit80
60F47147EDI P.O. Change Acknowledgment Detail - Outbound251SZSHPNShipment NumberNumericGeneric Edit80
61F47191EDI Acknowledgement Header21AHSHPNShipment NumberNumericGeneric Edit80
62F47UI001ASN Extract Work File6SZSHPNShipment NumberNumericGeneric Edit80
TOP49: Transportation Management
63F49110Transportation Bill of Lading Workfile4BWSHPNShipment NumberNumericGeneric Edit80
64F49111Carton Detail Shipment Workfile4CDSHPNShipment NumberNumericGeneric Edit80
65F49130Shipment Document Workfile8BWSHPNShipment NumberNumericGeneric Edit80
66F49140SSCC Print Label Workfile5BWSHPNShipment NumberNumericGeneric Edit80
67F49141Packing List Workfile6PWSHPNShipment NumberNumericGeneric Edit80
68F49380Seal Numbers6SUSHPNShipment NumberNumericGeneric Edit80
69F4941Shipment Routing Steps1RSSHPNShipment NumberNumericGeneric Edit80
70F4942Shipment Detail1ISSHPNShipment NumberNumericGeneric Edit80
71F4943Shipment Pieces1SPSHPNShipment NumberNumericGeneric Edit80
72F4944Shipment/Load Options and Equipment1OESHPNShipment NumberNumericGeneric Edit80
73F4945Shipment Charges1SCSHPNShipment NumberNumericGeneric Edit80
74F4947Shipment Status Codes1STSHPNShipment NumberNumericGeneric Edit80
75F49490Document Selection1TQSHPNShipment NumberNumericGeneric Edit80
76F4957Transportation Confirmed Batch Shipment1BCSHPNShipment NumberNumericGeneric Edit80
77F49591Document Print - Batch Selection9DBSHPNShipment NumberNumericGeneric Edit80
78F49594Document Print - Document Detail27DISHPNShipment NumberNumericGeneric Edit80
79F49621Load Compartment Detail11TDSHPNShipment NumberNumericGeneric Edit80
80F4963Load In-transit3TISHPNShipment NumberNumericGeneric Edit80
81F49631Load In-transit Ledger8TOSHPNShipment NumberNumericGeneric Edit80
82F49632Load In-transit Left on Board3LBSHPNShipment NumberNumericGeneric Edit80
83F49633Load In-Transit Confirmed Quantities4IQSHPNShipment NumberNumericGeneric Edit80
84F49634Load In-Transit Confirmed Quantities Detail1QDSHPNShipment NumberNumericGeneric Edit80
85F49696Document Register Detail11DJSHPNShipment NumberNumericGeneric Edit80
86F49697Document Register Summary13DNSHPNShipment NumberNumericGeneric Edit80
87F49721Spot Quote Detail2QSSHPNShipment NumberNumericGeneric Edit80
88F4981Freight Audit History2FHSHPNShipment NumberNumericGeneric Edit80
89F49T30Sales Confirm Staging Table4SOSHPNShipment NumberNumericGeneric Edit80
TOP55: Reserved for Clients
90F55W0100Correction Invoice Print - WF1225SDSHPNShipment NumberNumericGeneric Edit80
TOP76B: Brazil - Reporting System Only
91F76B947SPED Job Hash Codes - BR - 093SHPNPeriod Number - General LedgerNumericGeneric Edit20
TOP89: Conversion Programs
92F4215TOBSOLETE - Shipment Header Tag File1XTSHPNShipment NumberNumericGeneric Edit80
93F4311TATemp table for ERP 9.0 upgrade7PDSHPNShipment NumberNumericGeneric Edit80
94F43121TAERP 9.0 temp F43121T for upgrade9PRSHPNShipment NumberNumericGeneric Edit80
95F43199ATemp F43199 for ERP 9.0 Upgrade188OLSHPNShipment NumberNumericGeneric Edit80
96F4600TOBSOLETE - Warehouse Requests Tag File5R1SHPNShipment NumberNumericGeneric Edit80
97F4600TPUOBSOLETE - Warehouse Requests Tag File - Purged5R1SHPNShipment NumberNumericGeneric Edit80
98F4611TOBSOLETE - Warehouse Suggestions Tag File5R2SHPNShipment NumberNumericGeneric Edit80
99F4611TPUOBSOLETE - Warehouse Suggestions Tag File - Purged5R2SHPNShipment NumberNumericGeneric Edit80