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

164 columns | Print definition?812 | SHAN

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F004201Prepayment Transaction Table41PTSHANAddress Number - Ship ToNumericGeneric Edit80
TOP12: Fixed Assets
2F1217Equipment Master Extension12WRSHANAddress Number - Ship ToNumericGeneric Edit80
3F1217PEquipment Master Extension Purge Table12WRSHANAddress Number - Ship ToNumericGeneric Edit80
4F1217Z1Unedited Equipment Tag Transactions25WRSHANAddress Number - Ship ToNumericGeneric Edit80
5F1217Z2Unedited Equipment Tag Transactions25WRSHANAddress Number - Ship ToNumericGeneric Edit80
TOP17: Customer Service Management
6F1721Contract Detail29CDSHANAddress Number - Ship ToNumericGeneric Edit80
TOP32: Configuration Management
7F3201Configurator Master Table10CMSHANAddress Number - Ship ToNumericGeneric Edit80
8F32019Configurator Master History Table10CHSHANAddress Number - Ship ToNumericGeneric Edit80
TOP36: Forecasting
9F3470Demand Spreading Template2DSSHANAddress Number - Ship ToNumericGeneric Edit80
TOP40: Inventory/OP Base
10F4001ZBatch Receiver File - Order Headings37SYSHANAddress Number - Ship ToNumericGeneric Edit80
11F40051Return Material Authorization23RDSHANAddress Number - Ship ToNumericGeneric Edit80
12F4011ZBatch Receiver File - Order Details33SZSHANAddress Number - Ship ToNumericGeneric Edit80
13F4012ZWWF - Destination Quantity4SPSHANAddress Number - Ship ToNumericGeneric Edit80
14F40300RPreference Resolution History - Master30PMSHANAddress Number - Ship ToNumericGeneric Edit80
15F40320Preference Profile - Multi Shipping/Receiving Locations18LPSHANAddress Number - Ship ToNumericGeneric Edit80
16F40320RPreference Resolution Ledger - Multi ShiP/Rec Locations19LPSHANAddress Number - Ship ToNumericGeneric Edit80
17F4201Z1Sales Order Header Unedited Transaction File27SYSHANAddress Number - Ship ToNumericGeneric Edit80
18F4209Held Orders27HOSHANAddress Number - Ship ToNumericGeneric Edit80
19F4211AUSales Order Detail Audit File14AUSHANAddress Number - Ship ToNumericGeneric Edit80
20F4211DTSales Order Detail Date Tracking File8DTSHANAddress Number - Ship ToNumericGeneric Edit80
21F4211Z1Sales Order Detail Unedited Transaction File32SZSHANAddress Number - Ship ToNumericGeneric Edit80
22F4215Shipment Header34XHSHANAddress Number - Ship ToNumericGeneric Edit80
23F4220Basic Serial Numbers11SWSHANAddress Number - Ship ToNumericGeneric Edit80
TOP40R: Demand Scheduling
24F40R10Demand Header4DHSHANAddress Number - Ship ToNumericGeneric Edit80
25F40R11Demand Detail5DDSHANAddress Number - Ship ToNumericGeneric Edit80
26F40R12Cumulative Quantities5CQSHANAddress Number - Ship ToNumericGeneric Edit80
27F40R12WFCUM Rollback Workfile8CQSHANAddress Number - Ship ToNumericGeneric Edit80
28F40R20Demand Rules3DRSHANAddress Number - Ship ToNumericGeneric Edit80
29F40R22Demand Workflow3DWSHANAddress Number - Ship ToNumericGeneric Edit80
30F40R23Product CUM Model3PCSHANAddress Number - Ship ToNumericGeneric Edit80
31F40R24Carton CUM Model3CLSHANAddress Number - Ship ToNumericGeneric Edit80
32F40R30WFDemand Work File16DSSHANAddress Number - Ship ToNumericGeneric Edit80
33F40R31Additional Demand Label Data3ADSHANAddress Number - Ship ToNumericGeneric Edit80
34F40R41Demand History7DISHANAddress Number - Ship ToNumericGeneric Edit80
35F40R42Cumulative Quantity History7CHSHANAddress Number - Ship ToNumericGeneric Edit80
36F47171EDI Demand Header16EHSHANAddress Number - Ship ToNumericGeneric Edit80
37F47UI002ASN Extract Packaging Work File32SPSHANAddress Number - Ship ToNumericGeneric Edit80
TOP40S: Supply Chain Self Service
38F4947SWSelf-Service Shipment Tracking Work File24SWSHANAddress Number - Ship ToNumericGeneric Edit80
TOP41: Inventory Management
39F4111Item Ledger File62ILSHANAddress Number - Ship ToNumericGeneric Edit80
40F4118Container Deposit File2CNSHANAddress Number - Ship ToNumericGeneric Edit80
41F41181Container Transaction File7CMSHANAddress Number - Ship ToNumericGeneric Edit80
42F41UI001Inventory Transactions Detail File212ITSHANAddress Number - Ship ToNumericGeneric Edit80
TOP42: Sales Management
43F4201Sales Order Header File14SHSHANAddress Number - Ship ToNumericGeneric Edit80
44F42019Sales Order Header History File14SHSHANAddress Number - Ship ToNumericGeneric Edit80
45F4211Sales Order Detail File19SDSHANAddress Number - Ship ToNumericGeneric Edit80
46F42119Sales Order History File19SDSHANAddress Number - Ship ToNumericGeneric Edit80
47F42199S.O. Detail Ledger File19SLSHANAddress Number - Ship ToNumericGeneric Edit80
48F4239Last Customer Shipment1LCSHANAddress Number - Ship ToNumericGeneric Edit80
49F42430Customer Set2CSSHANAddress Number - Ship ToNumericGeneric Edit80
50F42565Invoice Print File13IWSHANAddress Number - Ship ToNumericGeneric Edit80
51F4290Delivery Note History4SESHANAddress Number - Ship ToNumericGeneric Edit80
52F42CSSCustomer Self Service Workfile5CSSHANAddress Number - Ship ToNumericGeneric Edit80
53F42UI01SO Header Cache File (MBF)19ZHSHANAddress Number - Ship ToNumericGeneric Edit80
54F42UI11SO Detail Cache File (MBF)23ZDSHANAddress Number - Ship ToNumericGeneric Edit80
55F42UI11CCustomer Self Service Shopping Cart Workfile12SCSHANAddress Number - Ship ToNumericGeneric Edit80
56F42UI520Pick Slips Header File7S8SHANAddress Number - Ship ToNumericGeneric Edit80
57F42UI521Pick Slips Detail File17S9SHANAddress Number - Ship ToNumericGeneric Edit80
58F42UI800Sales Detail Work File - Sales Update37SDSHANAddress Number - Ship ToNumericGeneric Edit80
TOP42B: Sales Order Entry
59F42420Audit Log Transaction43ALSHANAddress Number - Ship ToNumericGeneric Edit80
TOP43: Procurement
60F4301Purchase Order Header13PHSHANAddress Number - Ship ToNumericGeneric Edit80
61F4301ZPO Header Work File17PASHANAddress Number - Ship ToNumericGeneric Edit80
62F4301Z1Purchase Order Header Unedited Transaction Table26SYSHANAddress Number - Ship ToNumericGeneric Edit80
63F43080Approvals Fields Constants30PDSHANAddress Number - Ship ToNumericGeneric Edit80
64F4311Purchase Order Detail File20PDSHANAddress Number - Ship ToNumericGeneric Edit80
65F4311ZPurchase Order Generator File24PWSHANAddress Number - Ship ToNumericGeneric Edit80
66F4311Z1Purchase Order Detail Unedited Transaction Table33SZSHANAddress Number - Ship ToNumericGeneric Edit80
67F43121Z1Receipts Unedited Transaction Table112SZSHANAddress Number - Ship ToNumericGeneric Edit80
68F43199P.O. Detail Ledger File - Flexible Version20OLSHANAddress Number - Ship ToNumericGeneric Edit80
69F4332Multiple Requisition File9P2SHANAddress Number - Ship ToNumericGeneric Edit80
70F4371Suggested Reorder Stock Items4PDSHANAddress Number - Ship ToNumericGeneric Edit80
71F43UI50DPO Print Detail Work File50PWSHANAddress Number - Ship ToNumericGeneric Edit80
72F43UI50HPO Print Header Work File7PASHANAddress Number - Ship ToNumericGeneric Edit80
TOP43E: Requisition Self Service
73F43E11Requisition Detail8RDSHANAddress Number - Ship ToNumericGeneric Edit80
TOP43Q: Strategic Sourcing
74F43Q10Event Header62EHSHANAddress Number - Ship ToNumericGeneric Edit80
75F43Q11Event Detail35EDSHANAddress Number - Ship ToNumericGeneric Edit80
76F43Q50Analyze Event Header18AVSHANAddress Number - Ship ToNumericGeneric Edit80
77F43Q51Analyze Event Detail31EDSHANAddress Number - Ship ToNumericGeneric Edit80
TOP44H: Homebuilder Management
78F44H601Bid Header16BHSHANAddress Number - Ship ToNumericGeneric Edit80
79F44H611Bid Details24BDSHANAddress Number - Ship ToNumericGeneric Edit80
80F44H611WBid Details Work File28BWSHANAddress Number - Ship ToNumericGeneric Edit80
81F44H711Lot Start Workfile34SWSHANAddress Number - Ship ToNumericGeneric Edit80
82F44H711ZHB Lot Start Unedited Transaction File47SZSHANAddress Number - Ship ToNumericGeneric Edit80
83F44H71W1Lot Start Generation Workfile34GWSHANAddress Number - Ship ToNumericGeneric Edit80
84F44H73W1Lot Start - P.O. / Committment Generation Work File69CGSHANAddress Number - Ship ToNumericGeneric Edit80
TOP45: Advanced Pricing
85F4576Z1Ship and Debit Claims Unedited Transaction Table133Z1SHANAddress Number - Ship ToNumericGeneric Edit80
TOP46: Warehouse Management
86F4600Warehouse Requests12R1SHANAddress Number - Ship ToNumericGeneric Edit80
87F4600PUWarehouse Requests - Purged12R1SHANAddress Number - Ship ToNumericGeneric Edit80
88F460131Standard Pack Recommendation Rules3SPSHANAddress Number - Ship ToNumericGeneric Edit80
89F4611Warehouse Suggestions118R2SHANAddress Number - Ship ToNumericGeneric Edit80
90F4611PUWarehouse Suggestions - Purged117R2SHANAddress Number - Ship ToNumericGeneric Edit80
91F4611Z1Unedited Suggestion Table129SZSHANAddress Number - Ship ToNumericGeneric Edit80
92F4615Carton Recommendations17CRSHANAddress Number - Ship ToNumericGeneric Edit80
93F46201Carton Charge Reference Setup2CCSHANAddress Number - Ship ToNumericGeneric Edit80
94F46UI15Carton Recommendations - Work File17RCSHANAddress Number - Ship ToNumericGeneric Edit80
95F4942Z1Work File for F494220SYSHANAddress Number - Ship ToNumericGeneric Edit80
TOP46L: License Plating
96F46LUI01Assign/Remove Items To LP Work File31WFSHANAddress Number - Ship ToNumericGeneric Edit80
TOP47: Electronic Commerce
97F47011EDI Purchase Order Header - Inbound32SYSHANAddress Number - Ship ToNumericGeneric Edit80
98F47012EDI Purchase Order Detail - Inbound33SZSHANAddress Number - Ship ToNumericGeneric Edit80
99F47016EDI Purchase Order Header - Outbound28SYSHANAddress Number - Ship ToNumericGeneric Edit80
100F47017EDI Purchase Order Detail - Outbound33SZSHANAddress Number - Ship ToNumericGeneric Edit80
101F47021EDI P.O. Acknowledgment Header - Inbound28SYSHANAddress Number - Ship ToNumericGeneric Edit80
102F47022EDI P.O. Acknowledgment Detail - Inbound33SZSHANAddress Number - Ship ToNumericGeneric Edit80
103F47026EDI P.O. Acknowledgment Header - Outbound29SYSHANAddress Number - Ship ToNumericGeneric Edit80
104F47027EDI P.O. Acknowledgment Detail - Outbound33SZSHANAddress Number - Ship ToNumericGeneric Edit80
105F47031EDI Shipping Notice Header - Inbound29SYSHANAddress Number - Ship ToNumericGeneric Edit80
106F47032EDI Shipping Notice Detail - Inbound36SZSHANAddress Number - Ship ToNumericGeneric Edit80
107F47037EDI Shipping Notice Detail - Outbound34SZSHANAddress Number - Ship ToNumericGeneric Edit80
108F470371EDI Shipping Notice Detail - Outbound34SZSHANAddress Number - Ship ToNumericGeneric Edit80
109F47041EDI Invoice Header - Inbound27SYSHANAddress Number - Ship ToNumericGeneric Edit80
110F47046EDI Invoice Header (Sales) - Outbound29SYSHANAddress Number - Ship ToNumericGeneric Edit80
111F47047EDI Invoice Detail (Sales) - Outbound33SZSHANAddress Number - Ship ToNumericGeneric Edit80
112F470472EDI Invoice Expanded Detail (Sales)9S6SHANAddress Number - Ship ToNumericGeneric Edit80
113F47071EDI Receiving Advice Header - Inbound29SYSHANAddress Number - Ship ToNumericGeneric Edit80
114F47072EDI Receiving Advice Detail - Inbound34SZSHANAddress Number - Ship ToNumericGeneric Edit80
115F47076EDI Receiving Advice Header - Outbound29SYSHANAddress Number - Ship ToNumericGeneric Edit80
116F47077EDI Receiving Advice Detail - Outbound34SZSHANAddress Number - Ship ToNumericGeneric Edit80
117F47081EDI Price Sales Catalog Header - Inbound28FVSHANAddress Number - Ship ToNumericGeneric Edit80
118F47091EDI Request for Quote Header - Inbound32SYSHANAddress Number - Ship ToNumericGeneric Edit80
119F47092EDI Request for Quote Detail - Inbound33SZSHANAddress Number - Ship ToNumericGeneric Edit80
120F47096EDI Request for Quote Header - Outbound28SYSHANAddress Number - Ship ToNumericGeneric Edit80
121F47097EDI Request for Quote Detail - Outbound33SZSHANAddress Number - Ship ToNumericGeneric Edit80
122F47101EDI Response to RFQ Header - Inbound28SYSHANAddress Number - Ship ToNumericGeneric Edit80
123F47102EDI Response to RFQ Detail - Inbound33SZSHANAddress Number - Ship ToNumericGeneric Edit80
124F47106EDI Response to RFQ Header - Outbound29SYSHANAddress Number - Ship ToNumericGeneric Edit80
125F47107EDI Response to RFQ Detail - Outbound33SZSHANAddress Number - Ship ToNumericGeneric Edit80
126F47131EDI Purchase Order Change Header - Inbound29SYSHANAddress Number - Ship ToNumericGeneric Edit80
127F47132EDI Purchase Order Change Detail - Inbound34SZSHANAddress Number - Ship ToNumericGeneric Edit80
128F47136EDI Purchase Order Change Header - Outbound28SYSHANAddress Number - Ship ToNumericGeneric Edit80
129F47137EDI Purchase Order Change Detail - Outbound34SZSHANAddress Number - Ship ToNumericGeneric Edit80
130F47141EDI P.O. Change Acknowledgment Header - Inbound29SYSHANAddress Number - Ship ToNumericGeneric Edit80
131F47142EDI P.O. Change Acknowledgment Detail - Inbound35SZSHANAddress Number - Ship ToNumericGeneric Edit80
132F47146EDI P.O. Change Acknowledgment Header - Outbound30SYSHANAddress Number - Ship ToNumericGeneric Edit80
133F47147EDI P.O. Change Acknowledgment Detail - Outbound35SZSHANAddress Number - Ship ToNumericGeneric Edit80
134F47156EDI Shipping Schedule Header - Outbound29SYSHANAddress Number - Ship ToNumericGeneric Edit80
135F47157EDI Shipping Schedule Detail - Outbound34SZSHANAddress Number - Ship ToNumericGeneric Edit80
136F47191EDI Acknowledgement Header24AHSHANAddress Number - Ship ToNumericGeneric Edit80
TOP49: Transportation Management
137F49110Transportation Bill of Lading Workfile14BWSHANAddress Number - Ship ToNumericGeneric Edit80
138F49141Packing List Workfile10PWSHANAddress Number - Ship ToNumericGeneric Edit80
139F49490Document Selection16TQSHANAddress Number - Ship ToNumericGeneric Edit80
140F4950Routing Entries15RTSHANAddress Number - Ship ToNumericGeneric Edit80
141F49594Document Print - Document Detail11DISHANAddress Number - Ship ToNumericGeneric Edit80
142F49631Load In-transit Ledger75TOSHANAddress Number - Ship ToNumericGeneric Edit80
143F49697Document Register Summary10DNSHANAddress Number - Ship ToNumericGeneric Edit80
144F4972Rate Detail3RXSHANAddress Number - Ship ToNumericGeneric Edit80
145F4981Freight Audit History53FHSHANAddress Number - Ship ToNumericGeneric Edit80
TOP55: Reserved for Clients
146F74H1050Invoicing Workfile Header - New8IHSHANAddress Number - Ship ToNumericGeneric Edit80
147F74H1051Invoicing Workfile - New16IWSHANAddress Number - Ship ToNumericGeneric Edit80
TOP74: EMEA Localization
148F0018TIntrastat Revision46TDSHANAddress Number - Ship ToNumericGeneric Edit80
149F7430030Legal Document Header (Print Info) - COMM - 03B9PISHANAddress Number - Ship ToNumericGeneric Edit80
TOP75T: Taiwan
150F75T004GUI/VAT Transaction Header - 75T52THSHANAddress Number - Ship ToNumericGeneric Edit80
151F75T0049GUI/VAT Transaction Header History - 75T52THSHANAddress Number - Ship ToNumericGeneric Edit80
152F75T004PGUI/VAT Transaction Header POS - 75T52THSHANAddress Number - Ship ToNumericGeneric Edit80
153F75T004ZGUI/VAT Transaction Header - Work - 75T32ZHSHANAddress Number - Ship ToNumericGeneric Edit80
TOP76A: Argentina
154F76A0209Header and Footer Invoice/ShipmentNote History WF - ARG - 76A30HFSHANAddress Number - Ship ToNumericGeneric Edit80
155F76A020PHeader/Footer Inv./ShipmentNote History WF Purge - AR - 76A30HFSHANAddress Number - Ship ToNumericGeneric Edit80
156F76AUI20Header and Footer Invoice/ShipmentNote Workfile - ARG - - 0030HFSHANAddress Number - Ship ToNumericGeneric Edit80
TOP76B: Brazil - Reporting System Only
157F7601BNota Fiscal Header - Brazil13FHSHANAddress Number - Ship ToNumericGeneric Edit80
158F7611BNota Fiscal Detail - Brazil41FDSHANAddress Number - Ship ToNumericGeneric Edit80
159F761BAAS Fiscal file book44FBSHANAddress Number - Ship ToNumericGeneric Edit80
TOP76H: Chile
160F76H3B31Legal Document Header (Print Info) - CHI - 03B - 76H20PISHANAddress Number - Ship ToNumericGeneric Edit80
TOP89: Conversion Programs
161F43199ATemp F43199 for ERP 9.0 Upgrade20OLSHANAddress Number - Ship ToNumericGeneric Edit80
TOPD3N: dcLINK (data collection) - DSI
162FD3N913TranPrint - Default Labels - Table8DLSHANAddress Number - Ship ToNumericGeneric Edit80
TOPH91: Design Tools
163F98TCHDRTable Conversion Header5HDSHANAddress Number - Ship ToNumericGeneric Edit80
TOPH95: Tech Resources/Applications
164F00166Media Object Categories17GTSHANAddress Number - Ship ToNumericGeneric Edit80