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

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