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

212 columns | Print definition?910 | DSC1

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP13: Plant/Equipment Management
1F13017Equipment Parts List28PLDSC1DescriptionStringGeneric Edit300
TOP13C: Condition-Base Maintenance
2F1310Condition-Based Alerts21CADSC1DescriptionStringGeneric Edit300
3F1310Z1Unedited Condition-Based Alerts35CBDSC1DescriptionStringGeneric Edit300
TOP13R: Resource Assignments
4F48311Resource Assignments33RADSC1DescriptionStringGeneric Edit300
5F48311SPurge - Resource Assignments33RADSC1DescriptionStringGeneric Edit300
6F48316Maintenance Rescheduling Metrics12RSDSC1DescriptionStringGeneric Edit300
TOP17: Customer Service Management
7F1775Claim Temporary Table5TCDSC1DescriptionStringGeneric Edit300
8F3111Z2Warranty Claim/Supplier Recovery processing44WPDSC1DescriptionStringGeneric Edit300
9F3112Z2Warranty Claim/Supplier Recovery processing25WLDSC1DescriptionStringGeneric Edit300
TOP17C: Call Management
10F1760Time Entry13ZBDSC1DescriptionStringGeneric Edit300
TOP30: Product Data Management
11F300210Lean Multi Level Bill of Material Header19EHDSC1DescriptionStringGeneric Edit300
12F300211Lean Multi Level Bill of Material Detail59EDDSC1DescriptionStringGeneric Edit300
13F3002Z1Bill of Material Transaction File63SZDSC1DescriptionStringGeneric Edit300
14F300311Lean Multi-Level Routing Detail File5EHDSC1DescriptionStringGeneric Edit300
15F3003Z1Routing Transactions File20SZDSC1DescriptionStringGeneric Edit300
16F30UI008Bill of Material Comparison Work File14IJDSC1DescriptionStringGeneric Edit300
TOP31: Shop Floor Control
17F3111Work Order Parts List31WMDSC1DescriptionStringGeneric Edit300
18F3111SPurge - Shop Floor Parts List31WMDSC1DescriptionStringGeneric Edit300
19F3111Z1Outbound Work Order Parts List44SZDSC1DescriptionStringGeneric Edit300
20F3112Work Order Routing12WLDSC1DescriptionStringGeneric Edit300
21F3112SPurge Shop Floor Control Routing Instructions12WLDSC1DescriptionStringGeneric Edit300
22F3112Z1Outbound Work Order Routings25SZDSC1DescriptionStringGeneric Edit300
TOP31B: Blend Management
23F31B0710Harvest Assumptions4HADSC1DescriptionStringGeneric Edit300
TOP32: Configuration Management
24F3212Configurator Routings File7RCDSC1DescriptionStringGeneric Edit300
25F3215Configurator Component Table6CCDSC1DescriptionStringGeneric Edit300
26F32159Configurator Component History Table6CHDSC1DescriptionStringGeneric Edit300
27F3216Configurator Price/Cost Table4PCDSC1DescriptionStringGeneric Edit300
28F32169Configurator Price/Cost History4KBDSC1DescriptionStringGeneric Edit300
29F3281Rules Table Definition3RTDSC1DescriptionStringGeneric Edit300
30F3291Configured Item Segments8KWDSC1DescriptionStringGeneric Edit300
31F3293Assembly Inclusions Rules10KYDSC1DescriptionStringGeneric Edit300
32F3295Needed for upgrade from Xe and below4KSDSC1DescriptionStringGeneric Edit300
TOP33: Capacity Planning
33F3311Capacity Message File11CNDSC1DescriptionStringGeneric Edit300
TOP34: Requirements Planning
34F3411MPS/MRP/DRP Message File13MMDSC1DescriptionStringGeneric Edit300
TOP34A: Advanced Planning & Scheduling
35F34A110Work Center Resource Table5N0DSC1DescriptionStringGeneric Edit300
36F34A120Routing Master Resource Table25N0DSC1DescriptionStringGeneric Edit300
37F34A80Resource Master Table2N0DSC1DescriptionStringGeneric Edit300
TOP37: Quality Management
38F3701Test Definitions Master File7QADSC1DescriptionStringGeneric Edit300
39F37013Test Result Name2TRDSC1DescriptionStringGeneric Edit300
40F37014Test Result Conversions2RCDSC1DescriptionStringGeneric Edit300
41F37015Test Result Conversion Tables3CTDSC1DescriptionStringGeneric Edit300
42F3702Specifications Definitions Master File3QSDSC1DescriptionStringGeneric Edit300
TOP39: Advanced Stock Valuation
43F3905Valuation Method Master2SVDSC1DescriptionStringGeneric Edit300
TOP40: Inventory/OP Base
44F3002Bill of Material Master File50IXDSC1DescriptionStringGeneric Edit300
45F3003Routing Master File7IRDSC1DescriptionStringGeneric Edit300
46F3011Bill of Materials Change File50IZDSC1DescriptionStringGeneric Edit300
47F3013ECO Parts List Detail47CYDSC1DescriptionStringGeneric Edit300
48F30UI004Bill of Material Update Work File67WFDSC1DescriptionStringGeneric Edit300
49F4011ZBatch Receiver File - Order Details59SZDSC1DescriptionStringGeneric Edit300
50F4012ZWWF - Destination Quantity15SPDSC1DescriptionStringGeneric Edit300
51F4080Related Order Cross Reference Table17RODSC1DescriptionStringGeneric Edit300
52F40UI74Price Adjustment History Work File40AWDSC1DescriptionStringGeneric Edit300
53F4104Item Cross Reference File8IVDSC1DescriptionStringGeneric Edit300
54F42008Order Hold Constants10HCDSC1DescriptionStringGeneric Edit300
55F4211Z1Sales Order Detail Unedited Transaction File56SZDSC1DescriptionStringGeneric Edit300
56F4220Basic Serial Numbers4SWDSC1DescriptionStringGeneric Edit300
TOP41: Inventory Management
57F4101Item Master4IMDSC1DescriptionStringGeneric Edit300
58F4101AItem File12IMDSC1DescriptionStringGeneric Edit300
59F4101DItem Master - Alternative Description5IMDSC1DescriptionStringGeneric Edit300
60F4101HDItem Hierarchy - Alternate Description4IHDSC1DescriptionStringGeneric Edit300
61F4101Z1F4101 Item Master Unedited Transaction Table19SZDSC1DescriptionStringGeneric Edit300
62F41291ZLanded Cost Cache Table9IGDSC1DescriptionStringGeneric Edit300
63F4140Cycle Count Header File2PIDSC1DescriptionStringGeneric Edit300
64F41UI001Inventory Transactions Detail File160ITDSC1DescriptionStringGeneric Edit300
65F41UI003ABC Analysis Detail - Work File7AADSC1DescriptionStringGeneric Edit300
TOP41B: Bulk Stock Management
66F41012Conversion Table Interface File2VADSC1DescriptionStringGeneric Edit300
TOP41F: Apparel Management
67F41F02WFStyle End Item Workfile7S1DSC1DescriptionStringGeneric Edit300
68FCW09Item Revisions Work File5WRDSC1DescriptionStringGeneric Edit300
69FCW31Proposal Order Line Details44LVDSC1DescriptionStringGeneric Edit300
70FCW67Style Work Order Parts List37WMDSC1DescriptionStringGeneric Edit300
71FCW68Style Work Order Routings13WLDSC1DescriptionStringGeneric Edit300
72FCW96Material Analysis13WODSC1DescriptionStringGeneric Edit300
73FCW961Simulation Detailed Parts List12DLDSC1DescriptionStringGeneric Edit300
74FCW962Simulation Consolidated Parts List7CLDSC1DescriptionStringGeneric Edit300
75FCW963Adjustment Calculation7ACDSC1DescriptionStringGeneric Edit300
TOP42: Sales Management
76F420UI55Kit Balance Work File8UIDSC1DescriptionStringGeneric Edit300
77F4211Sales Order Detail File43SDDSC1DescriptionStringGeneric Edit300
78F42119Sales Order History File43SDDSC1DescriptionStringGeneric Edit300
79F42199S.O. Detail Ledger File43SLDSC1DescriptionStringGeneric Edit300
80F42565Invoice Print File18IWDSC1DescriptionStringGeneric Edit300
81F42UI11SO Detail Cache File (MBF)42ZDDSC1DescriptionStringGeneric Edit300
82F42UI521Pick Slips Detail File38S9DSC1DescriptionStringGeneric Edit300
TOP42B: Sales Order Entry
83F42420Audit Log Transaction26ALDSC1DescriptionStringGeneric Edit300
TOP42W: Fulfillment Management
84F4277703Unfulfilled Items Workfile6UIDSC1DescriptionStringGeneric Edit300
TOP43: Procurement
85F43080Approvals Fields Constants52PDDSC1DescriptionStringGeneric Edit300
86F4311Purchase Order Detail File44PDDSC1DescriptionStringGeneric Edit300
87F4311ZPurchase Order Generator File48PWDSC1DescriptionStringGeneric Edit300
88F4311Z1Purchase Order Detail Unedited Transaction Table57SZDSC1DescriptionStringGeneric Edit300
89F43121ZReceiver workfile89PWDSC1DescriptionStringGeneric Edit300
90F43121Z1Receipts Unedited Transaction Table114SZDSC1DescriptionStringGeneric Edit300
91F43147Freight Distribution Workfile12FDDSC1DescriptionStringGeneric Edit300
92F4314ZVoucher Match Selection File9PNDSC1DescriptionStringGeneric Edit300
93F43199P.O. Detail Ledger File - Flexible Version44OLDSC1DescriptionStringGeneric Edit300
94F43632ZOpen Purchase Order by Item Work File16OIDSC1DescriptionStringGeneric Edit300
95F4371Suggested Reorder Stock Items12PDDSC1DescriptionStringGeneric Edit300
96F43UI50DPO Print Detail Work File9PWDSC1DescriptionStringGeneric Edit300
97F43UI50HPO Print Header Work File34PADSC1DescriptionStringGeneric Edit300
TOP43E: Requisition Self Service
98F43E09F43E09 - Approvals Activity Table24AADSC1DescriptionStringGeneric Edit300
99F43E11Requisition Detail17RDDSC1DescriptionStringGeneric Edit300
TOP43Q: Strategic Sourcing
100F43Q11Event Detail21EDDSC1DescriptionStringGeneric Edit300
101F43Q41Response Line16RBDSC1DescriptionStringGeneric Edit300
102F43Q51Analyze Event Detail12EDDSC1DescriptionStringGeneric Edit300
TOP44H: Homebuilder Management
103F4450Lot Proceed Header (World)117JDDSC1DescriptionStringGeneric Edit300
104F4451Lot Proceed Detail (World)29JFDSC1DescriptionStringGeneric Edit300
105F4456Lot Proceed Entry (World)117JIDSC1DescriptionStringGeneric Edit300
106F4461Option Master (World)20JNDSC1DescriptionStringGeneric Edit300
107F44H301Plan Master18PMDSC1DescriptionStringGeneric Edit300
108F44H511Option Selections15OSDSC1DescriptionStringGeneric Edit300
109F44H511HOption Selection History16OHDSC1DescriptionStringGeneric Edit300
110F44H611Bid Details36BDDSC1DescriptionStringGeneric Edit300
111F44H611WBid Details Work File40BWDSC1DescriptionStringGeneric Edit300
112F44H711Lot Start Workfile42SWDSC1DescriptionStringGeneric Edit300
113F44H711PAfter Start Purchasing31TPDSC1DescriptionStringGeneric Edit300
114F44H711ZHB Lot Start Unedited Transaction File55SZDSC1DescriptionStringGeneric Edit300
115F44H71W1Lot Start Generation Workfile42GWDSC1DescriptionStringGeneric Edit300
116F44H73W1Lot Start - P.O. / Committment Generation Work File37CGDSC1DescriptionStringGeneric Edit300
TOP45: Advanced Pricing
117F4576Ship and Debit Claims46ACDSC1DescriptionStringGeneric Edit300
118F4576TMPShip and Debit Claims- Temp Table46ACDSC1DescriptionStringGeneric Edit300
119F4576Z1Ship and Debit Claims Unedited Transaction Table59Z1DSC1DescriptionStringGeneric Edit300
TOP46: Warehouse Management
120F4600Warehouse Requests56R1DSC1DescriptionStringGeneric Edit300
121F4600PUWarehouse Requests - Purged54R1DSC1DescriptionStringGeneric Edit300
122F4611Warehouse Suggestions64R2DSC1DescriptionStringGeneric Edit300
123F4611PUWarehouse Suggestions - Purged63R2DSC1DescriptionStringGeneric Edit300
124F4611Z1Unedited Suggestion Table76SZDSC1DescriptionStringGeneric Edit300
TOP46L: License Plating
125F46LUI01Assign/Remove Items To LP Work File7WFDSC1DescriptionStringGeneric Edit300
TOP47: Electronic Commerce
126F47012EDI Purchase Order Detail - Inbound60SZDSC1DescriptionStringGeneric Edit300
127F47017EDI Purchase Order Detail - Outbound58SZDSC1DescriptionStringGeneric Edit300
128F47022EDI P.O. Acknowledgment Detail - Inbound58SZDSC1DescriptionStringGeneric Edit300
129F47027EDI P.O. Acknowledgment Detail - Outbound60SZDSC1DescriptionStringGeneric Edit300
130F47032EDI Shipping Notice Detail - Inbound53SZDSC1DescriptionStringGeneric Edit300
131F47037EDI Shipping Notice Detail - Outbound60SZDSC1DescriptionStringGeneric Edit300
132F470371EDI Shipping Notice Detail - Outbound68SZDSC1DescriptionStringGeneric Edit300
133F47042EDI Invoice Detail - Inbound50SZDSC1DescriptionStringGeneric Edit300
134F47047EDI Invoice Detail (Sales) - Outbound60SZDSC1DescriptionStringGeneric Edit300
135F47062EDI Planning Schedule Detail - Inbound19MYDSC1DescriptionStringGeneric Edit300
136F47067EDI Planning Schedule Detail - Outbound19MYDSC1DescriptionStringGeneric Edit300
137F47072EDI Receiving Advice Detail - Inbound59SZDSC1DescriptionStringGeneric Edit300
138F47077EDI Receiving Advice Detail - Outbound59SZDSC1DescriptionStringGeneric Edit300
139F47082EDI Price Sales Catalog Detail - Inbound19FYDSC1DescriptionStringGeneric Edit300
140F47092EDI Request for Quote Detail - Inbound60SZDSC1DescriptionStringGeneric Edit300
141F47097EDI Request for Quote Detail - Outbound58SZDSC1DescriptionStringGeneric Edit300
142F47102EDI Response to RFQ Detail - Inbound58SZDSC1DescriptionStringGeneric Edit300
143F47107EDI Response to RFQ Detail - Outbound60SZDSC1DescriptionStringGeneric Edit300
144F47122EDI Product Activity Data Detail - Inbound38MJDSC1DescriptionStringGeneric Edit300
145F47127EDI Product Activity Data Detail - Outbound38MJDSC1DescriptionStringGeneric Edit300
146F47132EDI Purchase Order Change Detail - Inbound61SZDSC1DescriptionStringGeneric Edit300
147F47137EDI Purchase Order Change Detail - Outbound59SZDSC1DescriptionStringGeneric Edit300
148F47142EDI P.O. Change Acknowledgment Detail - Inbound60SZDSC1DescriptionStringGeneric Edit300
149F47147EDI P.O. Change Acknowledgment Detail - Outbound62SZDSC1DescriptionStringGeneric Edit300
150F47157EDI Shipping Schedule Detail - Outbound61SZDSC1DescriptionStringGeneric Edit300
TOP49: Transportation Management
151F49T100Procurement Freight Request staging table28OBDSC1DescriptionStringGeneric Edit300
152F49T11Item Staging Table8ITDSC1DescriptionStringGeneric Edit300
TOP54HS: Health & Safety Incident Mgt
153F54HS08Incident Environmental Impact9S9DSC1DescriptionStringGeneric Edit300
154F54HS08MIncident Environmental Impact Change History12I9DSC1DescriptionStringGeneric Edit300
TOP55: Reserved for Clients
155F74H1051Invoicing Workfile - New27IWDSC1DescriptionStringGeneric Edit300
TOP74: EMEA Localization
156F7420033Sales Document Line (Print Info) - COMM - 427PIDSC1DescriptionStringGeneric Edit300
TOP74U: United Kingdom Localizations
157F74U0424SPC Subcontractor Payment Liability - UK - 4330PLDSC1DescriptionStringGeneric Edit300
158F74U0429SPL Cross Reference Table - UK - 436CRDSC1DescriptionStringGeneric Edit300
TOP74Z: Czech Republic
159F74Z0010Cash Desk Document Printed - CZE - 74Z14ZODSC1DescriptionStringGeneric Edit300
TOP75I: India
160F75I100QTDS Form 26Q - WorkFile (Quarterly)79EFDSC1DescriptionStringGeneric Edit300
161F75I3051Excise Fiscal Years14FYDSC1DescriptionStringGeneric Edit300
162F75I309Personal Consumption - CENVAT setoff - IND - 4135CSDSC1DescriptionStringGeneric Edit300
163F75I345XExcise - ARE-3 Form Header for Yarn37QRDSC1DescriptionStringGeneric Edit300
164F75I346Excise - D3-Form Table35Q9DSC1DescriptionStringGeneric Edit300
165F75I385RG23D Register - Issues - IND - 4223EDDSC1DescriptionStringGeneric Edit300
166F75I395BER - 5 (2)10ERDSC1DescriptionStringGeneric Edit300
167F75I395TER - 5 (temp)10ERDSC1DescriptionStringGeneric Edit300
TOP75T: Taiwan
168F75T004GUI/VAT Transaction Header - 75T78THDSC1DescriptionStringGeneric Edit300
169F75T0049GUI/VAT Transaction Header History - 75T78THDSC1DescriptionStringGeneric Edit300
170F75T004PGUI/VAT Transaction Header POS - 75T75THDSC1DescriptionStringGeneric Edit300
171F75T005GUI/VAT Transaction Detail - 75T9TDDSC1DescriptionStringGeneric Edit300
172F75T0059GUI/VAT Transaction Detail History - 75T9TDDSC1DescriptionStringGeneric Edit300
173F75T005PGUI/VAT Transaction Detail POS - 75T9TDDSC1DescriptionStringGeneric Edit300
174F75T005TGUI/VAT Transaction Detail Temp - 75T9TDDSC1DescriptionStringGeneric Edit300
175F75T005ZGUI/VAT Transaction Detail - Work - 75T16ZDDSC1DescriptionStringGeneric Edit300
176F75T42WWork file with union of F4211 and F4211918SWDSC1DescriptionStringGeneric Edit300
TOP76A: Argentina
177F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A8DLDSC1DescriptionStringGeneric Edit300
178F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A8DLDSC1DescriptionStringGeneric Edit300
179F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 03 - 76A8DLDSC1DescriptionStringGeneric Edit300
TOP76B: Brazil - Reporting System Only
180F76111BNota Fiscal - Detail (Fiscal Books) - 428QUDSC1DescriptionStringGeneric Edit300
181F76111BTConversion table for CFOP 5 digits - F76111B - 428TADSC1DescriptionStringGeneric Edit300
182F7611BNota Fiscal Detail - BRA - 4230FDDSC1DescriptionStringGeneric Edit300
183F761BAAS Fiscal file book - 0934FBDSC1DescriptionStringGeneric Edit300
184F76B040ePIS COFINS Job Header - BRA - 76B4PHDSC1DescriptionStringGeneric Edit300
185F76B0510Electronic Reporting Process Header - BR -2PHDSC1DescriptionStringGeneric Edit300
186F76B0521Item Master Brazilian Work File5IMDSC1DescriptionStringGeneric Edit300
187F76B0530Electronic Reporting Header Blocks - BR -4HBDSC1DescriptionStringGeneric Edit300
188F76B0730Ato Cotepe Header Blocks Template - BR - 005HBDSC1DescriptionStringGeneric Edit300
189F76B0740Ato Cotepe Process - BR - 003PHDSC1DescriptionStringGeneric Edit300
190F76B0765Item Change Track - BRA - 76B4CTDSC1DescriptionStringGeneric Edit300
191F76B103Verification ICMS / IPI - Information - 427QDDSC1DescriptionStringGeneric Edit300
192F76B105GNRE Table - 4214QCDSC1DescriptionStringGeneric Edit300
193F76B31Nota Fiscal Detail/Table for Goods - IN68 - 4210IMDSC1DescriptionStringGeneric Edit300
194F76B400GIN86-Work Table for Item Number and Service Code - 414ISDSC1DescriptionStringGeneric Edit300
195F76B940SPED Jobs -BR - 094SJDSC1DescriptionStringGeneric Edit300
196F76B941SPED Job Header Blocks - BR - 096HBDSC1DescriptionStringGeneric Edit300
TOP76H: Chile
197F76H3B34Sales Document Line (Print Info) - CHI - 03B - 76H9PIDSC1DescriptionStringGeneric Edit300
198F76H3B38Shipment Guide Line (Print Info) - CHI - 03B - 76H9PIDSC1DescriptionStringGeneric Edit300
TOP89: Conversion Programs
199F32961Needed for upgrade from Xe and below12KLDSC1DescriptionStringGeneric Edit300
200F329611Needed for upgrade from Xe and below14KBDSC1DescriptionStringGeneric Edit300
201F3296TNeeded for upgrade from Xe and below13KADSC1DescriptionStringGeneric Edit300
202F43199ATemp F43199 for ERP 9.0 Upgrade44OLDSC1DescriptionStringGeneric Edit300
TOPF30L: DFM Line Design
203FF30L002DFM Bill of Material Master44DHDSC1DescriptionStringGeneric Edit300
204FF30L102Mixed Model Family Items5FDDSC1DescriptionStringGeneric Edit300
205FF30L501DFM Item Definition Master6IBDSC1DescriptionStringGeneric Edit300
206FF30L801Sales Order Master8SDDSC1DescriptionStringGeneric Edit300
207FF30L930DFM Routings6LRDSC1DescriptionStringGeneric Edit300
TOPF31: Lean Transactions
208FF31111Lean Transaction Parts List32PLDSC1DescriptionStringGeneric Edit300
209FF31111SPurge - Lean Transaction Parts List32PRDSC1DescriptionStringGeneric Edit300
210FF31112Routing Transaction Table25EHDSC1DescriptionStringGeneric Edit300
211FF31112SPurge - Routing Transaction Table25ETDSC1DescriptionStringGeneric Edit300
TOPF34S: DFM Production Sequencing
212FF34S01WDFM Plan Demand Work File20PDDSC1DescriptionStringGeneric Edit300