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

190 columns | Print definition?910 | 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
10F3462Forecast Shipment Summary14MBSHANAddress Number - Ship ToNumericGeneric Edit80
11F4001ZBatch Receiver File - Order Headings37SYSHANAddress Number - Ship ToNumericGeneric Edit80
12F40051Return Material Authorization23RDSHANAddress Number - Ship ToNumericGeneric Edit80
13F4011ZBatch Receiver File - Order Details33SZSHANAddress Number - Ship ToNumericGeneric Edit80
14F4012ZWWF - Destination Quantity4SPSHANAddress Number - Ship ToNumericGeneric Edit80
15F40300RPreference Resolution History - Master30PMSHANAddress Number - Ship ToNumericGeneric Edit80
16F40320Preference Profile - Multi Shipping/Receiving Locations18LPSHANAddress Number - Ship ToNumericGeneric Edit80
17F40320RPreference Resolution Ledger - Multi ShiP/Rec Locations19LPSHANAddress Number - Ship ToNumericGeneric Edit80
18F41112Item ASOF File12INSHANAddress Number - Ship ToNumericGeneric Edit80
19F4201Z1Sales Order Header Unedited Transaction File27SYSHANAddress Number - Ship ToNumericGeneric Edit80
20F4209Held Orders27HOSHANAddress Number - Ship ToNumericGeneric Edit80
21F4211AUSales Order Detail Audit File14AUSHANAddress Number - Ship ToNumericGeneric Edit80
22F4211DTSales Order Detail Date Tracking File8DTSHANAddress Number - Ship ToNumericGeneric Edit80
23F4211Z1Sales Order Detail Unedited Transaction File32SZSHANAddress Number - Ship ToNumericGeneric Edit80
24F4215Shipment Header34XHSHANAddress Number - Ship ToNumericGeneric Edit80
25F4220Basic Serial Numbers11SWSHANAddress Number - Ship ToNumericGeneric Edit80
TOP40R: Demand Scheduling
26F40R10Demand Header4DHSHANAddress Number - Ship ToNumericGeneric Edit80
27F40R11Demand Detail5DDSHANAddress Number - Ship ToNumericGeneric Edit80
28F40R12Cumulative Quantities5CQSHANAddress Number - Ship ToNumericGeneric Edit80
29F40R12WFCUM Rollback Workfile8CQSHANAddress Number - Ship ToNumericGeneric Edit80
30F40R20Demand Rules3DRSHANAddress Number - Ship ToNumericGeneric Edit80
31F40R22Demand Workflow3DWSHANAddress Number - Ship ToNumericGeneric Edit80
32F40R23Product CUM Model3PCSHANAddress Number - Ship ToNumericGeneric Edit80
33F40R24Carton CUM Model3CLSHANAddress Number - Ship ToNumericGeneric Edit80
34F40R30WFDemand Work File16DSSHANAddress Number - Ship ToNumericGeneric Edit80
35F40R31Additional Demand Label Data3ADSHANAddress Number - Ship ToNumericGeneric Edit80
36F40R41Demand History7DISHANAddress Number - Ship ToNumericGeneric Edit80
37F40R42Cumulative Quantity History7CHSHANAddress Number - Ship ToNumericGeneric Edit80
38F47171EDI Demand Header16EHSHANAddress Number - Ship ToNumericGeneric Edit80
39F47UI002ASN Extract Packaging Work File32SPSHANAddress Number - Ship ToNumericGeneric Edit80
TOP40S: Supply Chain Self Service
40F4947SWSelf-Service Shipment Tracking Work File24SWSHANAddress Number - Ship ToNumericGeneric Edit80
TOP41: Inventory Management
41F41025Consignment Sites (FUTURE)3CSSHANAddress Number - Ship ToNumericGeneric Edit80
42F4111Item Ledger File62ILSHANAddress Number - Ship ToNumericGeneric Edit80
43F4118Container Deposit File2CNSHANAddress Number - Ship ToNumericGeneric Edit80
44F41181Container Transaction File7CMSHANAddress Number - Ship ToNumericGeneric Edit80
45F4130Consignment Master Header (FUTURE)4MHSHANAddress Number - Ship ToNumericGeneric Edit80
46F4132Usage Header (FUTURE)4UHSHANAddress Number - Ship ToNumericGeneric Edit80
47F41UI001Inventory Transactions Detail File212ITSHANAddress Number - Ship ToNumericGeneric Edit80
TOP42: Sales Management
48F4201Sales Order Header File14SHSHANAddress Number - Ship ToNumericGeneric Edit80
49F42019Sales Order Header History File14SHSHANAddress Number - Ship ToNumericGeneric Edit80
50F4211Sales Order Detail File19SDSHANAddress Number - Ship ToNumericGeneric Edit80
51F42119Sales Order History File19SDSHANAddress Number - Ship ToNumericGeneric Edit80
52F42199S.O. Detail Ledger File19SLSHANAddress Number - Ship ToNumericGeneric Edit80
53F4239Last Customer Shipment1LCSHANAddress Number - Ship ToNumericGeneric Edit80
54F42430Customer Set2CSSHANAddress Number - Ship ToNumericGeneric Edit80
55F42565Invoice Print File13IWSHANAddress Number - Ship ToNumericGeneric Edit80
56F4290Delivery Note History4SESHANAddress Number - Ship ToNumericGeneric Edit80
57F42CSSCustomer Self Service Workfile5CSSHANAddress Number - Ship ToNumericGeneric Edit80
58F42UI01SO Header Cache File (MBF)19ZHSHANAddress Number - Ship ToNumericGeneric Edit80
59F42UI11SO Detail Cache File (MBF)23ZDSHANAddress Number - Ship ToNumericGeneric Edit80
60F42UI11CCustomer Self Service Shopping Cart Workfile12SCSHANAddress Number - Ship ToNumericGeneric Edit80
61F42UI520Pick Slips Header File7S8SHANAddress Number - Ship ToNumericGeneric Edit80
62F42UI521Pick Slips Detail File17S9SHANAddress Number - Ship ToNumericGeneric Edit80
63F42UI800Sales Detail Work File - Sales Update37SDSHANAddress Number - Ship ToNumericGeneric Edit80
TOP42B: Sales Order Entry
64F42420Audit Log Transaction43ALSHANAddress Number - Ship ToNumericGeneric Edit80
TOP42W: Fulfillment Management
65F427UI01Release Fulfillment Work File13RFSHANAddress Number - Ship ToNumericGeneric Edit80
TOP43: Procurement
66F4301Purchase Order Header13PHSHANAddress Number - Ship ToNumericGeneric Edit80
67F4301ZPO Header Work File17PASHANAddress Number - Ship ToNumericGeneric Edit80
68F4301Z1Purchase Order Header Unedited Transaction Table26SYSHANAddress Number - Ship ToNumericGeneric Edit80
69F43080Approvals Fields Constants30PDSHANAddress Number - Ship ToNumericGeneric Edit80
70F4311Purchase Order Detail File20PDSHANAddress Number - Ship ToNumericGeneric Edit80
71F4311ZPurchase Order Generator File24PWSHANAddress Number - Ship ToNumericGeneric Edit80
72F4311Z1Purchase Order Detail Unedited Transaction Table33SZSHANAddress Number - Ship ToNumericGeneric Edit80
73F43121Z1Receipts Unedited Transaction Table112SZSHANAddress Number - Ship ToNumericGeneric Edit80
74F43199P.O. Detail Ledger File - Flexible Version20OLSHANAddress Number - Ship ToNumericGeneric Edit80
75F4332Multiple Requisition File9P2SHANAddress Number - Ship ToNumericGeneric Edit80
76F4371Suggested Reorder Stock Items4PDSHANAddress Number - Ship ToNumericGeneric Edit80
77F43UI50DPO Print Detail Work File50PWSHANAddress Number - Ship ToNumericGeneric Edit80
78F43UI50HPO Print Header Work File7PASHANAddress Number - Ship ToNumericGeneric Edit80
TOP43E: Requisition Self Service
79F43E11Requisition Detail8RDSHANAddress Number - Ship ToNumericGeneric Edit80
TOP43Q: Strategic Sourcing
80F43Q10Event Header62EHSHANAddress Number - Ship ToNumericGeneric Edit80
81F43Q11Event Detail35EDSHANAddress Number - Ship ToNumericGeneric Edit80
82F43Q50Analyze Event Header18AVSHANAddress Number - Ship ToNumericGeneric Edit80
83F43Q51Analyze Event Detail31EDSHANAddress Number - Ship ToNumericGeneric Edit80
TOP44H: Homebuilder Management
84F44H601Bid Header16BHSHANAddress Number - Ship ToNumericGeneric Edit80
85F44H611Bid Details24BDSHANAddress Number - Ship ToNumericGeneric Edit80
86F44H611WBid Details Work File28BWSHANAddress Number - Ship ToNumericGeneric Edit80
87F44H711Lot Start Workfile34SWSHANAddress Number - Ship ToNumericGeneric Edit80
88F44H711ZHB Lot Start Unedited Transaction File47SZSHANAddress Number - Ship ToNumericGeneric Edit80
89F44H71W1Lot Start Generation Workfile34GWSHANAddress Number - Ship ToNumericGeneric Edit80
90F44H73W1Lot Start - P.O. / Committment Generation Work File69CGSHANAddress Number - Ship ToNumericGeneric Edit80
TOP45: Advanced Pricing
91F4576Z1Ship and Debit Claims Unedited Transaction Table133Z1SHANAddress Number - Ship ToNumericGeneric Edit80
TOP46: Warehouse Management
92F4600Warehouse Requests12R1SHANAddress Number - Ship ToNumericGeneric Edit80
93F4600PUWarehouse Requests - Purged12R1SHANAddress Number - Ship ToNumericGeneric Edit80
94F460131Standard Pack Recommendation Rules3SPSHANAddress Number - Ship ToNumericGeneric Edit80
95F4611Warehouse Suggestions118R2SHANAddress Number - Ship ToNumericGeneric Edit80
96F4611PUWarehouse Suggestions - Purged117R2SHANAddress Number - Ship ToNumericGeneric Edit80
97F4611Z1Unedited Suggestion Table129SZSHANAddress Number - Ship ToNumericGeneric Edit80
98F4615Carton Recommendations17CRSHANAddress Number - Ship ToNumericGeneric Edit80
99F46201Carton Charge Reference Setup2CCSHANAddress Number - Ship ToNumericGeneric Edit80
100F46UI15Carton Recommendations - Work File17RCSHANAddress Number - Ship ToNumericGeneric Edit80
101F4942Z1Work File for F494220SYSHANAddress Number - Ship ToNumericGeneric Edit80
TOP46L: License Plating
102F46LUI01Assign/Remove Items To LP Work File31WFSHANAddress Number - Ship ToNumericGeneric Edit80
TOP47: Electronic Commerce
103F47011EDI Purchase Order Header - Inbound32SYSHANAddress Number - Ship ToNumericGeneric Edit80
104F47012EDI Purchase Order Detail - Inbound33SZSHANAddress Number - Ship ToNumericGeneric Edit80
105F47016EDI Purchase Order Header - Outbound28SYSHANAddress Number - Ship ToNumericGeneric Edit80
106F47017EDI Purchase Order Detail - Outbound33SZSHANAddress Number - Ship ToNumericGeneric Edit80
107F47021EDI P.O. Acknowledgment Header - Inbound28SYSHANAddress Number - Ship ToNumericGeneric Edit80
108F47022EDI P.O. Acknowledgment Detail - Inbound33SZSHANAddress Number - Ship ToNumericGeneric Edit80
109F47026EDI P.O. Acknowledgment Header - Outbound29SYSHANAddress Number - Ship ToNumericGeneric Edit80
110F47027EDI P.O. Acknowledgment Detail - Outbound33SZSHANAddress Number - Ship ToNumericGeneric Edit80
111F47031EDI Shipping Notice Header - Inbound29SYSHANAddress Number - Ship ToNumericGeneric Edit80
112F47032EDI Shipping Notice Detail - Inbound36SZSHANAddress Number - Ship ToNumericGeneric Edit80
113F47037EDI Shipping Notice Detail - Outbound34SZSHANAddress Number - Ship ToNumericGeneric Edit80
114F470371EDI Shipping Notice Detail - Outbound34SZSHANAddress Number - Ship ToNumericGeneric Edit80
115F47041EDI Invoice Header - Inbound27SYSHANAddress Number - Ship ToNumericGeneric Edit80
116F47046EDI Invoice Header (Sales) - Outbound29SYSHANAddress Number - Ship ToNumericGeneric Edit80
117F47047EDI Invoice Detail (Sales) - Outbound33SZSHANAddress Number - Ship ToNumericGeneric Edit80
118F470472EDI Invoice Expanded Detail (Sales)9S6SHANAddress Number - Ship ToNumericGeneric Edit80
119F47071EDI Receiving Advice Header - Inbound29SYSHANAddress Number - Ship ToNumericGeneric Edit80
120F47072EDI Receiving Advice Detail - Inbound34SZSHANAddress Number - Ship ToNumericGeneric Edit80
121F47076EDI Receiving Advice Header - Outbound29SYSHANAddress Number - Ship ToNumericGeneric Edit80
122F47077EDI Receiving Advice Detail - Outbound34SZSHANAddress Number - Ship ToNumericGeneric Edit80
123F47081EDI Price Sales Catalog Header - Inbound28FVSHANAddress Number - Ship ToNumericGeneric Edit80
124F47091EDI Request for Quote Header - Inbound32SYSHANAddress Number - Ship ToNumericGeneric Edit80
125F47092EDI Request for Quote Detail - Inbound33SZSHANAddress Number - Ship ToNumericGeneric Edit80
126F47096EDI Request for Quote Header - Outbound28SYSHANAddress Number - Ship ToNumericGeneric Edit80
127F47097EDI Request for Quote Detail - Outbound33SZSHANAddress Number - Ship ToNumericGeneric Edit80
128F47101EDI Response to RFQ Header - Inbound28SYSHANAddress Number - Ship ToNumericGeneric Edit80
129F47102EDI Response to RFQ Detail - Inbound33SZSHANAddress Number - Ship ToNumericGeneric Edit80
130F47106EDI Response to RFQ Header - Outbound29SYSHANAddress Number - Ship ToNumericGeneric Edit80
131F47107EDI Response to RFQ Detail - Outbound33SZSHANAddress Number - Ship ToNumericGeneric Edit80
132F47131EDI Purchase Order Change Header - Inbound29SYSHANAddress Number - Ship ToNumericGeneric Edit80
133F47132EDI Purchase Order Change Detail - Inbound34SZSHANAddress Number - Ship ToNumericGeneric Edit80
134F47136EDI Purchase Order Change Header - Outbound28SYSHANAddress Number - Ship ToNumericGeneric Edit80
135F47137EDI Purchase Order Change Detail - Outbound34SZSHANAddress Number - Ship ToNumericGeneric Edit80
136F47141EDI P.O. Change Acknowledgment Header - Inbound29SYSHANAddress Number - Ship ToNumericGeneric Edit80
137F47142EDI P.O. Change Acknowledgment Detail - Inbound35SZSHANAddress Number - Ship ToNumericGeneric Edit80
138F47146EDI P.O. Change Acknowledgment Header - Outbound30SYSHANAddress Number - Ship ToNumericGeneric Edit80
139F47147EDI P.O. Change Acknowledgment Detail - Outbound35SZSHANAddress Number - Ship ToNumericGeneric Edit80
140F47156EDI Shipping Schedule Header - Outbound29SYSHANAddress Number - Ship ToNumericGeneric Edit80
141F47157EDI Shipping Schedule Detail - Outbound34SZSHANAddress Number - Ship ToNumericGeneric Edit80
142F47181EDI Consumption Header (FUTURE)5EHSHANAddress Number - Ship ToNumericGeneric Edit80
143F47191EDI Acknowledgement Header24AHSHANAddress Number - Ship ToNumericGeneric Edit80
TOP49: Transportation Management
144F49110Transportation Bill of Lading Workfile14BWSHANAddress Number - Ship ToNumericGeneric Edit80
145F49141Packing List Workfile10PWSHANAddress Number - Ship ToNumericGeneric Edit80
146F49490Document Selection16TQSHANAddress Number - Ship ToNumericGeneric Edit80
147F4950Routing Entries15RTSHANAddress Number - Ship ToNumericGeneric Edit80
148F49594Document Print - Document Detail11DISHANAddress Number - Ship ToNumericGeneric Edit80
149F49631Load In-transit Ledger75TOSHANAddress Number - Ship ToNumericGeneric Edit80
150F49697Document Register Summary10DNSHANAddress Number - Ship ToNumericGeneric Edit80
151F4972Rate Detail3RXSHANAddress Number - Ship ToNumericGeneric Edit80
152F4981Freight Audit History53FHSHANAddress Number - Ship ToNumericGeneric Edit80
153F49T10Sales Order Release Staging Table9ORSHANAddress Number - Ship ToNumericGeneric Edit80
154F49T100Procurement Freight Request staging table11OBSHANAddress Number - Ship ToNumericGeneric Edit80
TOP55: Reserved for Clients
155F55FR001Storno Bolle4SBSHANAddress Number - Ship ToNumericGeneric Edit80
156F55IF010SavePDF Archive9ARSHANAddress Number - Ship ToNumericGeneric Edit80
157F55IF421Sales Order per BO20SDSHANAddress Number - Ship ToNumericGeneric Edit80
158F55IF425Sales Order per BO - 200520SDSHANAddress Number - Ship ToNumericGeneric Edit80
159F55IFALBEsportazione provvigioni da F42113PRSHANAddress Number - Ship ToNumericGeneric Edit80
160F55IFP06Sales Analyze by Product Group nad Sales Region DETAIL3WFSHANAddress Number - Ship ToNumericGeneric Edit80
161F55PROVVEsportazione provvigioni da F42113PRSHANAddress Number - Ship ToNumericGeneric Edit80
162F55W0100Correction Invoice Print - WF120SDSHANAddress Number - Ship ToNumericGeneric Edit80
163F74H1050Invoicing Workfile Header - New8IHSHANAddress Number - Ship ToNumericGeneric Edit80
164F74H1051Invoicing Workfile - New16IWSHANAddress Number - Ship ToNumericGeneric Edit80
165F59I0020P07 Shipment Header5PHSHANAddress Number - Ship ToNumericGeneric Edit80
166F59W0080P30 Pallet Header6PHSHANAddress Number - Ship ToNumericGeneric Edit80
TOP74: EMEA Localization
167F0018TIntrastat Revision46TDSHANAddress Number - Ship ToNumericGeneric Edit80
168F740018DData extraction ESL - 7439DESHANAddress Number - Ship ToNumericGeneric Edit80
169F740018WData extraction ESL - Workfile - 7439DESHANAddress Number - Ship ToNumericGeneric Edit80
170F7430030Legal Document Header (Print Info) - COMM - 03B9PISHANAddress Number - Ship ToNumericGeneric Edit80
TOP74R: CIS
171F74R3038Adjustment Invoice Header Info AR/SOP - RUS - 74R21AISHANAddress Number - Ship ToNumericGeneric Edit80
TOP75I: India
172F75I385RG23D Register - Issues - IND - 4231EDSHANAddress Number - Ship ToNumericGeneric Edit80
173F75I4223Sales Tax Summary/Detail28SDSHANAddress Number - Ship ToNumericGeneric Edit80
174F75I701Bill of Entry - Header64QHSHANAddress Number - Ship ToNumericGeneric Edit80
TOP75T: Taiwan
175F75T004GUI/VAT Transaction Header - 75T67THSHANAddress Number - Ship ToNumericGeneric Edit80
176F75T0049GUI/VAT Transaction Header History - 75T67THSHANAddress Number - Ship ToNumericGeneric Edit80
177F75T004PGUI/VAT Transaction Header POS - 75T63THSHANAddress Number - Ship ToNumericGeneric Edit80
178F75T004ZGUI/VAT Transaction Header - Work - 75T43ZHSHANAddress Number - Ship ToNumericGeneric Edit80
179F75T42WWork file with union of F4211 and F421198SWSHANAddress Number - Ship ToNumericGeneric Edit80
TOP76A: Argentina
180F76A0209Header & Footer Invoice/ShipmentNote History WF - ARG - 76A30HFSHANAddress Number - Ship ToNumericGeneric Edit80
181F76A020PHeader/Footer Inv./ShipmentNote History WF Purge - AR - 76A30HFSHANAddress Number - Ship ToNumericGeneric Edit80
182F76AUI20Header & Footer Invoice/ShipmentNote Workfile - ARG - - 76A30HFSHANAddress Number - Ship ToNumericGeneric Edit80
TOP76B: Brazil - Reporting System Only
183F7601BNota Fiscal Header - BRA - 4213FHSHANAddress Number - Ship ToNumericGeneric Edit80
184F7611BNota Fiscal Detail - BRA - 4241FDSHANAddress Number - Ship ToNumericGeneric Edit80
185F761BAAS Fiscal file book - 0944FBSHANAddress Number - Ship ToNumericGeneric Edit80
TOP76H: Chile
186F76H3B31Legal Document Header (Print Info) - CHI - 03B - 76H20PISHANAddress Number - Ship ToNumericGeneric Edit80
TOP80D: Plant Manager Dashboard
187F80D010Sales Order Fact10SFSHANAddress Number - Ship ToNumericGeneric Edit80
TOP89: Conversion Programs
188F43199ATemp F43199 for ERP 9.0 Upgrade20OLSHANAddress Number - Ship ToNumericGeneric Edit80
TOPH91: Design Tools
189F98TCHDRTable Conversion Header5HDSHANAddress Number - Ship ToNumericGeneric Edit80
TOPH95: Tech Resources/Applications
190F00166Media Object Categories17GTSHANAddress Number - Ship ToNumericGeneric Edit80