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

90 columns | Print definition?920 | ADDJ

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP12: Fixed Assets
1F1217Equipment Master Extension11WRADDJDate - Actual Ship DateDateGeneric Edit60
2F1217PEquipment Master Extension Purge Table11WRADDJDate - Actual Ship DateDateGeneric Edit60
3F1217Z1Unedited Equipment Tag Transactions24WRADDJDate - Actual Ship DateDateGeneric Edit60
4F1217Z2Unedited Equipment Tag Transactions24WRADDJDate - Actual Ship DateDateGeneric Edit60
TOP40: Inventory/OP Base
5F4001ZBatch Receiver File - Order Headings43SYADDJDate - Actual Ship DateDateGeneric Edit60
6F4011ZBatch Receiver File - Order Details39SZADDJDate - Actual Ship DateDateGeneric Edit60
7F4201Z1Sales Order Header Unedited Transaction File33SYADDJDate - Actual Ship DateDateGeneric Edit60
8F4211DTSales Order Detail Date Tracking File25DTADDJDate - Actual Ship DateDateGeneric Edit60
9F4211Z1Sales Order Detail Unedited Transaction File37SZADDJDate - Actual Ship DateDateGeneric Edit60
TOP40G: Grower Management
10F40G95Pay On Proceeds Log File19PPADDJDate - Actual Ship DateDateGeneric Edit60
TOP40R: Demand Scheduling
11F40R12Cumulative Quantities19CQADDJDate - Actual Ship DateDateGeneric Edit60
12F40R12WFCUM Rollback Workfile22CQADDJDate - Actual Ship DateDateGeneric Edit60
13F40R41Demand History10DIADDJDate - Actual Ship DateDateGeneric Edit60
14F40R42Cumulative Quantity History22CHADDJDate - Actual Ship DateDateGeneric Edit60
TOP40S: Supply Chain Self Service
15F4947SWSelf-Service Shipment Tracking Work File8SWADDJDate - Actual Ship DateDateGeneric Edit60
TOP41: Inventory Management
16F41182Container Serial6CSADDJDate - Actual Ship DateDateGeneric Edit60
TOP42: Sales Management
17F4201Sales Order Header File20SHADDJDate - Actual Ship DateDateGeneric Edit60
18F42019Sales Order Header History File20SHADDJDate - Actual Ship DateDateGeneric Edit60
19F4211Sales Order Detail File24SDADDJDate - Actual Ship DateDateGeneric Edit60
20F42119Sales Order History File24SDADDJDate - Actual Ship DateDateGeneric Edit60
21F42199S.O. Detail Ledger File24SLADDJDate - Actual Ship DateDateGeneric Edit60
22F42UI01SO Header Cache File (MBF)25ZHADDJDate - Actual Ship DateDateGeneric Edit60
23F42UI11SO Detail Cache File (MBF)28ZDADDJDate - Actual Ship DateDateGeneric Edit60
24F42UI521Pick Slips Detail File23S9ADDJDate - Actual Ship DateDateGeneric Edit60
TOP43: Procurement
25F4301Purchase Order Header18PHADDJDate - Actual Ship DateDateGeneric Edit60
26F4301ZPO Header Work File22PAADDJDate - Actual Ship DateDateGeneric Edit60
27F4301Z1Purchase Order Header Unedited Transaction Table31SYADDJDate - Actual Ship DateDateGeneric Edit60
28F43080Approvals Fields Constants33PDADDJDate - Actual Ship DateDateGeneric Edit60
29F4311Purchase Order Detail File25PDADDJDate - Actual Ship DateDateGeneric Edit60
30F4311ZPurchase Order Generator File29PWADDJDate - Actual Ship DateDateGeneric Edit60
31F4311Z1Purchase Order Detail Unedited Transaction Table38SZADDJDate - Actual Ship DateDateGeneric Edit60
32F43121Z1Receipts Unedited Transaction Table111SZADDJDate - Actual Ship DateDateGeneric Edit60
33F43199P.O. Detail Ledger File - Flexible Version25OLADDJDate - Actual Ship DateDateGeneric Edit60
TOP44H: Homebuilder Management
34F44H601Bid Header26BHADDJDate - Actual Ship DateDateGeneric Edit60
TOP45: Advanced Pricing
35F4575Ship and Debit History60AHADDJDate - Actual Ship DateDateGeneric Edit60
36F4575TMPShip and Debit History - Temp Table60AHADDJDate - Actual Ship DateDateGeneric Edit60
37F4576Ship and Debit Claims43ACADDJDate - Actual Ship DateDateGeneric Edit60
38F4576TMPShip and Debit Claims- Temp Table43ACADDJDate - Actual Ship DateDateGeneric Edit60
39F4576Z1Ship and Debit Claims Unedited Transaction Table56Z1ADDJDate - Actual Ship DateDateGeneric Edit60
TOP47: Electronic Commerce
40F47011EDI Purchase Order Header - Inbound38SYADDJDate - Actual Ship DateDateGeneric Edit60
41F47012EDI Purchase Order Detail - Inbound39SZADDJDate - Actual Ship DateDateGeneric Edit60
42F47016EDI Purchase Order Header - Outbound33SYADDJDate - Actual Ship DateDateGeneric Edit60
43F47017EDI Purchase Order Detail - Outbound38SZADDJDate - Actual Ship DateDateGeneric Edit60
44F47021EDI P.O. Acknowledgment Header - Inbound33SYADDJDate - Actual Ship DateDateGeneric Edit60
45F47022EDI P.O. Acknowledgment Detail - Inbound38SZADDJDate - Actual Ship DateDateGeneric Edit60
46F47026EDI P.O. Acknowledgment Header - Outbound35SYADDJDate - Actual Ship DateDateGeneric Edit60
47F47027EDI P.O. Acknowledgment Detail - Outbound39SZADDJDate - Actual Ship DateDateGeneric Edit60
48F47031EDI Shipping Notice Header - Inbound33SYADDJDate - Actual Ship DateDateGeneric Edit60
49F47032EDI Shipping Notice Detail - Inbound40SZADDJDate - Actual Ship DateDateGeneric Edit60
50F47037EDI Shipping Notice Detail - Outbound40SZADDJDate - Actual Ship DateDateGeneric Edit60
51F470371EDI Shipping Notice Detail - Outbound40SZADDJDate - Actual Ship DateDateGeneric Edit60
52F47046EDI Invoice Header (Sales) - Outbound35SYADDJDate - Actual Ship DateDateGeneric Edit60
53F47047EDI Invoice Detail (Sales) - Outbound39SZADDJDate - Actual Ship DateDateGeneric Edit60
54F47071EDI Receiving Advice Header - Inbound34SYADDJDate - Actual Ship DateDateGeneric Edit60
55F47072EDI Receiving Advice Detail - Inbound39SZADDJDate - Actual Ship DateDateGeneric Edit60
56F47076EDI Receiving Advice Header - Outbound34SYADDJDate - Actual Ship DateDateGeneric Edit60
57F47077EDI Receiving Advice Detail - Outbound39SZADDJDate - Actual Ship DateDateGeneric Edit60
58F47091EDI Request for Quote Header - Inbound38SYADDJDate - Actual Ship DateDateGeneric Edit60
59F47092EDI Request for Quote Detail - Inbound39SZADDJDate - Actual Ship DateDateGeneric Edit60
60F47096EDI Request for Quote Header - Outbound33SYADDJDate - Actual Ship DateDateGeneric Edit60
61F47097EDI Request for Quote Detail - Outbound38SZADDJDate - Actual Ship DateDateGeneric Edit60
62F47101EDI Response to RFQ Header - Inbound33SYADDJDate - Actual Ship DateDateGeneric Edit60
63F47102EDI Response to RFQ Detail - Inbound38SZADDJDate - Actual Ship DateDateGeneric Edit60
64F47106EDI Response to RFQ Header - Outbound35SYADDJDate - Actual Ship DateDateGeneric Edit60
65F47107EDI Response to RFQ Detail - Outbound39SZADDJDate - Actual Ship DateDateGeneric Edit60
66F47131EDI Purchase Order Change Header - Inbound35SYADDJDate - Actual Ship DateDateGeneric Edit60
67F47132EDI Purchase Order Change Detail - Inbound40SZADDJDate - Actual Ship DateDateGeneric Edit60
68F47136EDI Purchase Order Change Header - Outbound33SYADDJDate - Actual Ship DateDateGeneric Edit60
69F47137EDI Purchase Order Change Detail - Outbound39SZADDJDate - Actual Ship DateDateGeneric Edit60
70F47141EDI P.O. Change Acknowledgment Header - Inbound34SYADDJDate - Actual Ship DateDateGeneric Edit60
71F47142EDI P.O. Change Acknowledgment Detail - Inbound40SZADDJDate - Actual Ship DateDateGeneric Edit60
72F47146EDI P.O. Change Acknowledgment Header - Outbound36SYADDJDate - Actual Ship DateDateGeneric Edit60
73F47147EDI P.O. Change Acknowledgment Detail - Outbound41SZADDJDate - Actual Ship DateDateGeneric Edit60
74F47156EDI Shipping Schedule Header - Outbound35SYADDJDate - Actual Ship DateDateGeneric Edit60
75F47157EDI Shipping Schedule Detail - Outbound40SZADDJDate - Actual Ship DateDateGeneric Edit60
76F47191EDI Acknowledgement Header30AHADDJDate - Actual Ship DateDateGeneric Edit60
TOP49: Transportation Management
77F49380Seal Numbers8SUADDJDate - Actual Ship DateDateGeneric Edit60
78F4941Shipment Routing Steps46RSADDJDate - Actual Ship DateDateGeneric Edit60
79F4957Transportation Confirmed Batch Shipment7BCADDJDate - Actual Ship DateDateGeneric Edit60
80F4960Load Header22TMADDJDate - Actual Ship DateDateGeneric Edit60
81F4961Load Legs19LLADDJDate - Actual Ship DateDateGeneric Edit60
82F4981Freight Audit History61FHADDJDate - Actual Ship DateDateGeneric Edit60
83F49T30Sales Confirm Staging Table13SOADDJDate - Actual Ship DateDateGeneric Edit60
84F49T380Seal Numbers6SOADDJDate - Actual Ship DateDateGeneric Edit60
TOP74: EMEA Localization
85F0018TIntrastat Revision39TDADDJDate - Actual Ship DateDateGeneric Edit60
86F7420033Sales Document Line (Print Info) - COMM - 4223PIADDJDate - Actual Ship DateDateGeneric Edit60
87F7430010Legal Document Header - COMM - 03B14LDADDJDate - Actual Ship DateDateGeneric Edit60
TOP76B: Brazil
88F7601BNota Fiscal Header - BRA - 4253FHADDJDate - Actual Ship DateDateGeneric Edit60
89F761BAAS Fiscal file book - 0987FBADDJDate - Actual Ship DateDateGeneric Edit60
TOP89: Conversion Programs
90F43199ATemp F43199 for ERP 9.0 Upgrade25OLADDJDate - Actual Ship DateDateGeneric Edit60