JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides | 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
9F03012AICustomer Master by Line of Business
10F0006MCBusiness Unit Master

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

188 columns | Print definition?812 | 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
32F3295Segment Value History File4KSDSC1DescriptionStringGeneric Edit300
33F32961Configurator Cost/Price Adjustment File12KLDSC1DescriptionStringGeneric Edit300
34F329611Configurator Detail Cost/Price Adjustment Table14KBDSC1DescriptionStringGeneric Edit300
35F3296TConfigurator Level Sequence File Table13KADSC1DescriptionStringGeneric Edit300
TOP33: Capacity Planning
36F3311Capacity Message File11CNDSC1DescriptionStringGeneric Edit300
TOP34: Requirements Planning
37F3411MPS/MRP/DRP Message File13MMDSC1DescriptionStringGeneric Edit300
TOP34A: Advanced Planning & Scheduling
38F34A110Work Center Resource Table5N0DSC1DescriptionStringGeneric Edit300
39F34A120Routing Master Resource Table25N0DSC1DescriptionStringGeneric Edit300
40F34A80Resource Master Table2N0DSC1DescriptionStringGeneric Edit300
TOP37: Quality Management
41F3701Test Definitions Master File7QADSC1DescriptionStringGeneric Edit300
42F37013Test Result Name2TRDSC1DescriptionStringGeneric Edit300
43F37014Test Result Conversions2RCDSC1DescriptionStringGeneric Edit300
44F37015Test Result Conversion Tables3CTDSC1DescriptionStringGeneric Edit300
45F3702Specifications Definitions Master File3QSDSC1DescriptionStringGeneric Edit300
TOP39: Advanced Stock Valuation
46F3905Valuation Method Master2SVDSC1DescriptionStringGeneric Edit300
TOP40: Inventory/OP Base
47F3002Bill of Material Master File50IXDSC1DescriptionStringGeneric Edit300
48F3003Routing Master File7IRDSC1DescriptionStringGeneric Edit300
49F3011Bill of Materials Change File50IZDSC1DescriptionStringGeneric Edit300
50F3013ECO Parts List Detail47CYDSC1DescriptionStringGeneric Edit300
51F30UI004Bill of Material Update Work File67WFDSC1DescriptionStringGeneric Edit300
52F4011ZBatch Receiver File - Order Details59SZDSC1DescriptionStringGeneric Edit300
53F4012ZWWF - Destination Quantity15SPDSC1DescriptionStringGeneric Edit300
54F4080Related Order Cross Reference Table17RODSC1DescriptionStringGeneric Edit300
55F40UI74Price Adjustment History Work File40AWDSC1DescriptionStringGeneric Edit300
56F4104Item Cross Reference File8IVDSC1DescriptionStringGeneric Edit300
57F42008Order Hold Constants10HCDSC1DescriptionStringGeneric Edit300
58F4211Z1Sales Order Detail Unedited Transaction File56SZDSC1DescriptionStringGeneric Edit300
59F4220Basic Serial Numbers4SWDSC1DescriptionStringGeneric Edit300
TOP41: Inventory Management
60F4101Item Master4IMDSC1DescriptionStringGeneric Edit300
61F4101AItem File12IMDSC1DescriptionStringGeneric Edit300
62F4101DItem Master - Alternative Description5IMDSC1DescriptionStringGeneric Edit300
63F4101HDItem Hierarchy - Alternate Description4IHDSC1DescriptionStringGeneric Edit300
64F4101Z1F4101 Item Master Unedited Transaction Table19SZDSC1DescriptionStringGeneric Edit300
65F41291ZLanded Cost Cache Table9IGDSC1DescriptionStringGeneric Edit300
66F4140Cycle Count Header File2PIDSC1DescriptionStringGeneric Edit300
67F41UI001Inventory Transactions Detail File160ITDSC1DescriptionStringGeneric Edit300
68F41UI003ABC Analysis Detail - Work File7AADSC1DescriptionStringGeneric Edit300
TOP41B: Bulk Stock Management
69F41012Conversion Table Interface File2VADSC1DescriptionStringGeneric Edit300
TOP42: Sales Management
70F4211Sales Order Detail File43SDDSC1DescriptionStringGeneric Edit300
71F42119Sales Order History File43SDDSC1DescriptionStringGeneric Edit300
72F42199S.O. Detail Ledger File43SLDSC1DescriptionStringGeneric Edit300
73F42565Invoice Print File18IWDSC1DescriptionStringGeneric Edit300
74F42UI11SO Detail Cache File (MBF)42ZDDSC1DescriptionStringGeneric Edit300
75F42UI521Pick Slips Detail File38S9DSC1DescriptionStringGeneric Edit300
TOP42B: Sales Order Entry
76F42420Audit Log Transaction26ALDSC1DescriptionStringGeneric Edit300
TOP43: Procurement
77F43080Approvals Fields Constants52PDDSC1DescriptionStringGeneric Edit300
78F4311Purchase Order Detail File44PDDSC1DescriptionStringGeneric Edit300
79F4311ZPurchase Order Generator File48PWDSC1DescriptionStringGeneric Edit300
80F4311Z1Purchase Order Detail Unedited Transaction Table57SZDSC1DescriptionStringGeneric Edit300
81F43121ZReceiver workfile89PWDSC1DescriptionStringGeneric Edit300
82F43121Z1Receipts Unedited Transaction Table114SZDSC1DescriptionStringGeneric Edit300
83F4314ZVoucher Match Selection File9PNDSC1DescriptionStringGeneric Edit300
84F43199P.O. Detail Ledger File - Flexible Version44OLDSC1DescriptionStringGeneric Edit300
85F43632ZOpen Purchase Order by Item Work File16OIDSC1DescriptionStringGeneric Edit300
86F4371Suggested Reorder Stock Items12PDDSC1DescriptionStringGeneric Edit300
87F43E09F43E09 - Approvals Activity Table24AADSC1DescriptionStringGeneric Edit300
88F43UI50DPO Print Detail Work File9PWDSC1DescriptionStringGeneric Edit300
89F43UI50HPO Print Header Work File34PADSC1DescriptionStringGeneric Edit300
TOP43E: Requisition Self Service
90F43E11Requisition Detail17RDDSC1DescriptionStringGeneric Edit300
TOP43Q: Strategic Sourcing
91F43Q11Event Detail21EDDSC1DescriptionStringGeneric Edit300
92F43Q41Response Line16RBDSC1DescriptionStringGeneric Edit300
93F43Q51Analyze Event Detail12EDDSC1DescriptionStringGeneric Edit300
TOP44H: Homebuilder Management
94F4450Lot Proceed Header (World)117JDDSC1DescriptionStringGeneric Edit300
95F4451Lot Proceed Detail (World)29JFDSC1DescriptionStringGeneric Edit300
96F4456Lot Proceed Entry (World)117JIDSC1DescriptionStringGeneric Edit300
97F4461Option Master (World)20JNDSC1DescriptionStringGeneric Edit300
98F44H301Plan Master18PMDSC1DescriptionStringGeneric Edit300
99F44H511Option Selections15OSDSC1DescriptionStringGeneric Edit300
100F44H511HOption Selection History16OHDSC1DescriptionStringGeneric Edit300
101F44H611Bid Details36BDDSC1DescriptionStringGeneric Edit300
102F44H611WBid Details Work File40BWDSC1DescriptionStringGeneric Edit300
103F44H711Lot Start Workfile42SWDSC1DescriptionStringGeneric Edit300
104F44H711PAfter Start Purchasing31TPDSC1DescriptionStringGeneric Edit300
105F44H711ZHB Lot Start Unedited Transaction File55SZDSC1DescriptionStringGeneric Edit300
106F44H71W1Lot Start Generation Workfile42GWDSC1DescriptionStringGeneric Edit300
107F44H73W1Lot Start - P.O. / Committment Generation Work File37CGDSC1DescriptionStringGeneric Edit300
TOP45: Advanced Pricing
108F4576Ship and Debit Claims46ACDSC1DescriptionStringGeneric Edit300
109F4576TMPShip and Debit Claims- Temp Table46ACDSC1DescriptionStringGeneric Edit300
110F4576Z1Ship and Debit Claims Unedited Transaction Table59Z1DSC1DescriptionStringGeneric Edit300
TOP46: Warehouse Management
111F4600Warehouse Requests56R1DSC1DescriptionStringGeneric Edit300
112F4600PUWarehouse Requests - Purged54R1DSC1DescriptionStringGeneric Edit300
113F4611Warehouse Suggestions64R2DSC1DescriptionStringGeneric Edit300
114F4611PUWarehouse Suggestions - Purged63R2DSC1DescriptionStringGeneric Edit300
115F4611Z1Unedited Suggestion Table76SZDSC1DescriptionStringGeneric Edit300
TOP46L: License Plating
116F46LUI01Assign/Remove Items To LP Work File7WFDSC1DescriptionStringGeneric Edit300
TOP47: Electronic Commerce
117F47012EDI Purchase Order Detail - Inbound60SZDSC1DescriptionStringGeneric Edit300
118F47017EDI Purchase Order Detail - Outbound58SZDSC1DescriptionStringGeneric Edit300
119F47022EDI P.O. Acknowledgment Detail - Inbound58SZDSC1DescriptionStringGeneric Edit300
120F47027EDI P.O. Acknowledgment Detail - Outbound60SZDSC1DescriptionStringGeneric Edit300
121F47032EDI Shipping Notice Detail - Inbound53SZDSC1DescriptionStringGeneric Edit300
122F47037EDI Shipping Notice Detail - Outbound60SZDSC1DescriptionStringGeneric Edit300
123F470371EDI Shipping Notice Detail - Outbound68SZDSC1DescriptionStringGeneric Edit300
124F47042EDI Invoice Detail - Inbound50SZDSC1DescriptionStringGeneric Edit300
125F47047EDI Invoice Detail (Sales) - Outbound60SZDSC1DescriptionStringGeneric Edit300
126F47062EDI Planning Schedule Detail - Inbound19MYDSC1DescriptionStringGeneric Edit300
127F47067EDI Planning Schedule Detail - Outbound19MYDSC1DescriptionStringGeneric Edit300
128F47072EDI Receiving Advice Detail - Inbound59SZDSC1DescriptionStringGeneric Edit300
129F47077EDI Receiving Advice Detail - Outbound59SZDSC1DescriptionStringGeneric Edit300
130F47082EDI Price Sales Catalog Detail - Inbound19FYDSC1DescriptionStringGeneric Edit300
131F47092EDI Request for Quote Detail - Inbound60SZDSC1DescriptionStringGeneric Edit300
132F47097EDI Request for Quote Detail - Outbound58SZDSC1DescriptionStringGeneric Edit300
133F47102EDI Response to RFQ Detail - Inbound58SZDSC1DescriptionStringGeneric Edit300
134F47107EDI Response to RFQ Detail - Outbound60SZDSC1DescriptionStringGeneric Edit300
135F47122EDI Product Activity Data Detail - Inbound38MJDSC1DescriptionStringGeneric Edit300
136F47127EDI Product Activity Data Detail - Outbound38MJDSC1DescriptionStringGeneric Edit300
137F47132EDI Purchase Order Change Detail - Inbound61SZDSC1DescriptionStringGeneric Edit300
138F47137EDI Purchase Order Change Detail - Outbound59SZDSC1DescriptionStringGeneric Edit300
139F47142EDI P.O. Change Acknowledgment Detail - Inbound60SZDSC1DescriptionStringGeneric Edit300
140F47147EDI P.O. Change Acknowledgment Detail - Outbound62SZDSC1DescriptionStringGeneric Edit300
141F47157EDI Shipping Schedule Detail - Outbound61SZDSC1DescriptionStringGeneric Edit300
TOP55: Reserved for Clients
142F550200Correspondent Accounts Report4WFDSC1DescriptionStringGeneric Edit300
143F55IF421Sales Order per BO49SDDSC1DescriptionStringGeneric Edit300
144F55IF425Sales Order per BO - 200549SDDSC1DescriptionStringGeneric Edit300
145F55IFALBEsportazione provvigioni da F42116PRDSC1DescriptionStringGeneric Edit300
146F55IFPRMPromozioni ordini di vendita2PRDSC1DescriptionStringGeneric Edit300
147F55IFSCHCust / Supp Balance Workfile - Copia estesa di F7441228RPDSC1DescriptionStringGeneric Edit300
148F55PROVVEsportazione provvigioni da F42116PRDSC1DescriptionStringGeneric Edit300
149F55W0100Correction Invoice Print - WF144SDDSC1DescriptionStringGeneric Edit300
150F59BO001Cash Journal Master File16CJDSC1DescriptionStringGeneric Edit300
151F59PO001Cash Journal Master File16CJDSC1DescriptionStringGeneric Edit300
152F59PO00NCash Journal Next Numbers8CNDSC1DescriptionStringGeneric Edit300
153F74H1051Invoicing Workfile - New27IWDSC1DescriptionStringGeneric Edit300
154F59I0060Cycle Count Import Table12CCDSC1DescriptionStringGeneric Edit300
TOP74: EMEA Localization
155F7420033Sales Document Line (Print Info) - COMM - 427PIDSC1DescriptionStringGeneric Edit300
TOP75T: Taiwan
156F75T004GUI/VAT Transaction Header - 75T63THDSC1DescriptionStringGeneric Edit300
157F75T0049GUI/VAT Transaction Header History - 75T63THDSC1DescriptionStringGeneric Edit300
158F75T004PGUI/VAT Transaction Header POS - 75T63THDSC1DescriptionStringGeneric Edit300
159F75T005GUI/VAT Transaction Detail - 75T7TDDSC1DescriptionStringGeneric Edit300
160F75T0059GUI/VAT Transaction Detail History - 75T7TDDSC1DescriptionStringGeneric Edit300
161F75T005PGUI/VAT Transaction Detail POS - 75T7TDDSC1DescriptionStringGeneric Edit300
162F75T005ZGUI/VAT Transaction Detail - Work - 75T13ZDDSC1DescriptionStringGeneric Edit300
TOP76A: Argentina
163F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A8DLDSC1DescriptionStringGeneric Edit300
164F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A8DLDSC1DescriptionStringGeneric Edit300
165F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 00 - 008DLDSC1DescriptionStringGeneric Edit300
TOP76B: Brazil - Reporting System Only
166F76111BNota Fiscal - Detail (Fiscal Books) - 428QUDSC1DescriptionStringGeneric Edit300
167F76111BTConversion table for CFOP 5 digits - F76111B - 428TADSC1DescriptionStringGeneric Edit300
168F7611BNota Fiscal Detail - Brazil30FDDSC1DescriptionStringGeneric Edit300
169F761BAAS Fiscal file book34FBDSC1DescriptionStringGeneric Edit300
170F76B103Verification ICMS / IPI - Information - 427QDDSC1DescriptionStringGeneric Edit300
171F76B105GNRE Table - 4214QCDSC1DescriptionStringGeneric Edit300
172F76B31Nota Fiscal Detail/Table for Goods - IN68 - 4210IMDSC1DescriptionStringGeneric Edit300
173F76B400GIN86-Work Table for Item Number and Service Code - 414ISDSC1DescriptionStringGeneric Edit300
174T76B002Temporary file for DIPJ - Material - 422QBDSC1DescriptionStringGeneric Edit300
TOP76H: Chile
175F76H3B34Sales Document Line (Print Info) - CHI - 03B - 76H9PIDSC1DescriptionStringGeneric Edit300
176F76H3B38Shipment Guide Line (Print Info) - CHI - 03B - 76H9PIDSC1DescriptionStringGeneric Edit300
TOP89: Conversion Programs
177F43199ATemp F43199 for ERP 9.0 Upgrade44OLDSC1DescriptionStringGeneric Edit300
TOPF30L: DFM Line Design
178FF30L002DFM Bill of Material Master44DHDSC1DescriptionStringGeneric Edit300
179FF30L102Mixed Model Family Items5FDDSC1DescriptionStringGeneric Edit300
180FF30L501DFM Item Definition Master6IBDSC1DescriptionStringGeneric Edit300
181FF30L801Sales Order Master8SDDSC1DescriptionStringGeneric Edit300
182FF30L930DFM Routings6LRDSC1DescriptionStringGeneric Edit300
TOPF31: Lean Transactions
183FF31111Lean Transaction Parts List32PLDSC1DescriptionStringGeneric Edit300
184FF31111SPurge - Lean Transaction Parts List32PRDSC1DescriptionStringGeneric Edit300
185FF31112Routing Transaction Table25EHDSC1DescriptionStringGeneric Edit300
186FF31112SPurge - Routing Transaction Table25ETDSC1DescriptionStringGeneric Edit300
TOPF34S: DFM Production Sequencing
187FF34S01WDFM Plan Demand Work File20PDDSC1DescriptionStringGeneric Edit300
TOPH91: Design Tools
188F98EVHDREvent Header File7EHDSC1DescriptionStringGeneric Edit300