JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.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
6F9671SDSoftware Update Detail Table
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F0006MCBusiness Unit Master
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F76AUI46WFCERG A/R -Work File - ARG - 03B - 76A
3F4211SDSales Order Detail File
4F4101IMItem Master
5F0101ABAddress Book Master
6F0911GLAccount Ledger
7F4102IBItem Branch File
8F03B11RPCustomer Ledger
9F4111ILItem Ledger File
10F4311PDPurchase Order Detail File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0006MCBusiness Unit Master
5F0411RPAccounts Payable Ledger
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

41 columns | Print definition?920 | GSHAN

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP40R: Demand Scheduling
1F47171EDI Demand Header41EHGSHANShip To GLNNumericGeneric Edit130
2F47UI002ASN Extract Packaging Work File60SPGSHANShip To GLNNumericGeneric Edit130
TOP47: Electronic Commerce
3F47011EDI Purchase Order Header - Inbound204SYGSHANShip To GLNNumericGeneric Edit130
4F47012EDI Purchase Order Detail - Inbound262SZGSHANShip To GLNNumericGeneric Edit130
5F47016EDI Purchase Order Header - Outbound150SYGSHANShip To GLNNumericGeneric Edit130
6F47017EDI Purchase Order Detail - Outbound231SZGSHANShip To GLNNumericGeneric Edit130
7F47021EDI P.O. Acknowledgment Header - Inbound112SYGSHANShip To GLNNumericGeneric Edit130
8F47022EDI P.O. Acknowledgment Detail - Inbound223SZGSHANShip To GLNNumericGeneric Edit130
9F47026EDI P.O. Acknowledgment Header - Outbound145SYGSHANShip To GLNNumericGeneric Edit130
10F47027EDI P.O. Acknowledgment Detail - Outbound254SZGSHANShip To GLNNumericGeneric Edit130
11F47031EDI Shipping Notice Header - Inbound107SYGSHANShip To GLNNumericGeneric Edit130
12F47032EDI Shipping Notice Detail - Inbound177SZGSHANShip To GLNNumericGeneric Edit130
13F47037EDI Shipping Notice Detail - Outbound215SZGSHANShip To GLNNumericGeneric Edit130
14F470371EDI Shipping Notice Detail - Outbound254SZGSHANShip To GLNNumericGeneric Edit130
15F47041EDI Invoice Header - Inbound67SYGSHANShip To GLNNumericGeneric Edit130
16F47046EDI Invoice Header (Sales) - Outbound150SYGSHANShip To GLNNumericGeneric Edit130
17F47047EDI Invoice Detail (Sales) - Outbound256SZGSHANShip To GLNNumericGeneric Edit130
18F470472EDI Invoice Expanded Detail (Sales)84S6GSHANShip To GLNNumericGeneric Edit130
19F47071EDI Receiving Advice Header - Inbound113SYGSHANShip To GLNNumericGeneric Edit130
20F47072EDI Receiving Advice Detail - Inbound255SZGSHANShip To GLNNumericGeneric Edit130
21F47076EDI Receiving Advice Header - Outbound112SYGSHANShip To GLNNumericGeneric Edit130
22F47077EDI Receiving Advice Detail - Outbound241SZGSHANShip To GLNNumericGeneric Edit130
23F47091EDI Request for Quote Header - Inbound142SYGSHANShip To GLNNumericGeneric Edit130
24F47092EDI Request for Quote Detail - Inbound254SZGSHANShip To GLNNumericGeneric Edit130
25F47096EDI Request for Quote Header - Outbound111SYGSHANShip To GLNNumericGeneric Edit130
26F47097EDI Request for Quote Detail - Outbound223SZGSHANShip To GLNNumericGeneric Edit130
27F47106EDI Response to RFQ Header - Outbound145SYGSHANShip To GLNNumericGeneric Edit130
28F47107EDI Response to RFQ Detail - Outbound254SZGSHANShip To GLNNumericGeneric Edit130
29F47131EDI Purchase Order Change Header - Inbound164SYGSHANShip To GLNNumericGeneric Edit130
30F47132EDI Purchase Order Change Detail - Inbound255SZGSHANShip To GLNNumericGeneric Edit130
31F47136EDI Purchase Order Change Header - Outbound113SYGSHANShip To GLNNumericGeneric Edit130
32F47137EDI Purchase Order Change Detail - Outbound191SZGSHANShip To GLNNumericGeneric Edit130
33F47141EDI P.O. Change Acknowledgment Header - Inbound113SYGSHANShip To GLNNumericGeneric Edit130
34F47142EDI P.O. Change Acknowledgment Detail - Inbound225SZGSHANShip To GLNNumericGeneric Edit130
35F47146EDI P.O. Change Acknowledgment Header - Outbound145SYGSHANShip To GLNNumericGeneric Edit130
36F47147EDI P.O. Change Acknowledgment Detail - Outbound256SZGSHANShip To GLNNumericGeneric Edit130
37F47156EDI Shipping Schedule Header - Outbound106SYGSHANShip To GLNNumericGeneric Edit130
38F47157EDI Shipping Schedule Detail - Outbound220SZGSHANShip To GLNNumericGeneric Edit130
39F47191EDI Acknowledgement Header58AHGSHANShip To GLNNumericGeneric Edit130
TOP49: Transportation Management
40F49110Transportation Bill of Lading Workfile85BWGSHANShip To GLNNumericGeneric Edit130
41F49130Shipment Document Workfile46BWGSHANShip To GLNNumericGeneric Edit130