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
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger 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

32 columns | Print definition?920 | TXCT

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP01: Address Book
1F0101Address Book Master64ABTXCTCertificate Tax ExemptionStringGeneric Edit200
2F0101Z2Address Book - Interoperability77SZTXCTCertificate Tax ExemptionStringGeneric Edit200
TOP40: Inventory/OP Base
3F4001ZBatch Receiver File - Order Headings61SYTXCTCertificate Tax ExemptionStringGeneric Edit200
4F4201Z1Sales Order Header Unedited Transaction File50SYTXCTCertificate Tax ExemptionStringGeneric Edit200
TOP42: Sales Management
5F4201Sales Order Header File37SHTXCTCertificate Tax ExemptionStringGeneric Edit200
6F42019Sales Order Header History File37SHTXCTCertificate Tax ExemptionStringGeneric Edit200
7F42UI01SO Header Cache File (MBF)42ZHTXCTCertificate Tax ExemptionStringGeneric Edit200
TOP43: Procurement
8F4301Purchase Order Header35PHTXCTCertificate Tax ExemptionStringGeneric Edit200
9F4301ZPO Header Work File39PATXCTCertificate Tax ExemptionStringGeneric Edit200
10F4301Z1Purchase Order Header Unedited Transaction Table48SYTXCTCertificate Tax ExemptionStringGeneric Edit200
TOP47: Electronic Commerce
11F47011EDI Purchase Order Header - Inbound56SYTXCTCertificate Tax ExemptionStringGeneric Edit200
12F47016EDI Purchase Order Header - Outbound50SYTXCTCertificate Tax ExemptionStringGeneric Edit200
13F47021EDI P.O. Acknowledgment Header - Inbound50SYTXCTCertificate Tax ExemptionStringGeneric Edit200
14F47026EDI P.O. Acknowledgment Header - Outbound52SYTXCTCertificate Tax ExemptionStringGeneric Edit200
15F47031EDI Shipping Notice Header - Inbound45SYTXCTCertificate Tax ExemptionStringGeneric Edit200
16F47046EDI Invoice Header (Sales) - Outbound52SYTXCTCertificate Tax ExemptionStringGeneric Edit200
17F47071EDI Receiving Advice Header - Inbound51SYTXCTCertificate Tax ExemptionStringGeneric Edit200
18F47076EDI Receiving Advice Header - Outbound51SYTXCTCertificate Tax ExemptionStringGeneric Edit200
19F47091EDI Request for Quote Header - Inbound56SYTXCTCertificate Tax ExemptionStringGeneric Edit200
20F47096EDI Request for Quote Header - Outbound50SYTXCTCertificate Tax ExemptionStringGeneric Edit200
21F47101EDI Response to RFQ Header - Inbound50SYTXCTCertificate Tax ExemptionStringGeneric Edit200
22F47106EDI Response to RFQ Header - Outbound52SYTXCTCertificate Tax ExemptionStringGeneric Edit200
23F47131EDI Purchase Order Change Header - Inbound53SYTXCTCertificate Tax ExemptionStringGeneric Edit200
24F47136EDI Purchase Order Change Header - Outbound50SYTXCTCertificate Tax ExemptionStringGeneric Edit200
25F47141EDI P.O. Change Acknowledgment Header - Inbound51SYTXCTCertificate Tax ExemptionStringGeneric Edit200
26F47146EDI P.O. Change Acknowledgment Header - Outbound53SYTXCTCertificate Tax ExemptionStringGeneric Edit200
27F47156EDI Shipping Schedule Header - Outbound53SYTXCTCertificate Tax ExemptionStringGeneric Edit200
TOP54R: Rental Management
28F54R099Rental Contract Header Ledger59HLTXCTCertificate Tax ExemptionStringGeneric Edit200
29F54R10Rental Contract Header57CHTXCTCertificate Tax ExemptionStringGeneric Edit200
30F54R11Rental Contract Detail91CDTXCTCertificate Tax ExemptionStringGeneric Edit200
31F54R199Rental Contract Detail Ledger87DLTXCTCertificate Tax ExemptionStringGeneric Edit200
TOP74H: Hungary
32F74H1010Effective EU Tax Identifiers - HUN - 003AETXCTCertificate Tax ExemptionStringGeneric Edit200