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
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

1 column | Print definition?920 | FLDN01 | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP47: Electronic Commerce
1F47HLHierarchical Configuration18HLFLDN01Data Field Name + Table PrefixStringUDC120

User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.

TOPUDC 47 / FD (DD Alias and Desc for V4211AA) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1SDACOMApply Commission (Y/N) Y
2SDADDJActual Ship Y
3SDAEXPExtended Price Y
4SDAFTApply Freight (Y/N) Y
5SDAIDAccount ID Y
6SDAITM3rd Item Number Y
7SDAN8Address Number Y
8SDANBYBuyer Number Y
9SDANIAccount Number Y
10SDAOPNAmount Open Y
11SDAPTSPartial Shipments Allowed Y
12SDAPUMEntered Unit of Measure f Y
13SDASNAdjustment Schedule Y
14SDATXTAssociated Text Y
15SDBACKBackorders Allowed (Y/N) Y
16SDBALUContract Balances Updated Y
17SDBCRCBase Currency Y
18SDCADCCash Discount % Y
19SDCARSCarrier Number Y
20SDCLVLPricing Category Level Y
21SDCMCGCommission Category Y
22SDCMGLCommitment Method Y
23SDCMGPInventory Costing Method Y
24SDCNDJCancel Date Y
25SDCNIDContainer ID Y
26SDCOCompany Y
27SDCOMMCommitted (H/S) Y
28SDCOTConditions of Transport Y
29SDCPNTComponent Line Number Y
30SDCRCDCurrency Code Y
31SDCRMDSend Method Y
32SDCRRExchange Rate Y
33SDCSTOCost Override Code Y
34SDCTRYCentury Y
35SDDCTDocument Type Y
36SDDCTOOrder Type Y
37SDDELNDelivery Number Y
38SDDGL G/L Date Y
39SDDMBUDemand Business Unit Y
40SDDMCSAgreement Supplement Y
41SDDMCTAgreement Nbr Y
42SDDMT1Borrow Agreement Y
43SDDOCDocument Number Y
44SDDOCOOrder Number Y
45SDDRQJRequested Y
46SDDRQTRequested Delivery Time Y
47SDDSC1Description Y
48SDDSC2Description 2 Y
49SDDSFTDiscount Factor Type - $ Y
50SDDSPRDiscount Factor Y
51SDDTBSBased on Date Y
52SDDTYSDuty Status Y
53SDECSTExtended Cost Y
54SDEMCUHeader Business Unit Y
55SDEUSEEnd Use Y
56SDEXDPDays Before Expiration Y
57SDEXR1Tax Expl Code Y
58SDFAPPDiscount Application Type Y
59SDFEAForeign Extended Price Y
60SDFECForeign Extended Cost Y
61SDFPRCForeign List Price Y
62SDFRATRate Code _ Freight/Misc Y
63SDFRGDFrom Grade Y
64SDFRMPFrom Potency Y
65SDFRTCFreight Calculated (Y/N) Y
66SDFRTHFreight Handling Code Y
67SDFUCForeign Unit Cost Y
68SDFUF1AIA Document Y
69SDFUN2Trade Discount (Old) Y
70SDFUPForeign Unit Price Y
71SDFY Fiscal Year Y
72SDGLCG/L Offset Y
73SDGRWTGross Weight Y
74SDGWUMGross Weight Unit of Measure Y
75SDHDBUHeader Business Unit Y
76SDHOLDHold Orders Code Y
77SDINMGPrint Message Y
78SDITMItem Number (Short) Y
79SDITVLUnit Volume Y
80SDITWTUnit Weight Y
81SDIVDInvoice Date Y
82SDJOBNWork Station ID Y
83SDKCODocument Company Y
84SDKCOOOrder Company Y
85SDKTLNKit Master Line Number Y
86SDKTPNumber of Component Per P Y
87SDLCODLoc Tax Code Y
88SDLITM2nd Item Number Y
89SDLNIDLine Number Y
90SDLNTYLine Type Y
91SDLOBLine of Business Y
92SDLOCNLocation Y
93SDLOTNLot/SN Y
94SDLPRCUnit List Price Y
95SDLTLedger Type Y
96SDLTTRStatus Code - Last Y
97SDMCUBusiness Unit Y
98SDMERLItem Revision Level Y
99SDMOTMode of Trn Y
100SDNTRNature of Transaction Y
101SDNXTRStatus Code - Next Y
102SDOBJObject Account Y
103SDOCTOOriginal Order Type Y
104SDODCTOriginal Document Type Y
105SDODOC Original Document No Y
106SDOGNOOriginal Line Number Y
107SDOKCOriginal Document Company Y
108SDOKCOOriginal Order Document C Y
109SDOMCUProject Cost Center Y
110SDOORNOriginal Order Number Y
111SDOPDJOriginal Promised Y
112SDORPOrder Repriced Indicator Y
113SDORPR Order Reprice Group Y
114SDOSEQSequence Number Y
115SDOTQYOther Quantity Y
116SDPA8Parent Number Y
117SDPDDJScheduled Pick Y
118SDPEFJPrice Effective Y
119SDPIDProgram ID Y
120SDPPDJShip Y
121SDPQORQuantity Ordered Y
122SDPRGRItem Price Group Y
123SDPRIOPriority Processing Code Y
124SDPROVPrice Override Code Y
125SDPRP1Commodity Class Y
126SDPRP2Commodity Sub Class Y
127SDPRP3Supplier Rebate Code Y
128SDPRP4Master Planning Family Y
129SDPRP5Landed Cost Rule Y
130SDPSNPick Slip Number Y
131SDPTCPayment Terms Y
132SDPTSKTask Number Y
133SDQRLVQuantity Relieved Y
134SDQTYTQuantity Shipped to Date Y
135SDRATTRate Type - Freight/Misc Y
136SDRCDReason Code Y
137SDRCTORelated PO/SO/WO Order Ty Y
138SDRESLPrinted Code Y
139SDRKCORelated Order Key Company Y
140SDRKITRelated Kit Component Y
141SDRLITRelated Item Number (Kit) Y
142SDRLLNRelated PO/SO Line Number Y
143SDRORNRelated PO/SO/WO Number Y
144SDROUTRoute Code Y
145SDRPRCBasket Reprice Group Y
146SDRQSJRequested Y
147SDRSDJPromised Delivery Y
148SDRSDTPromised Delivery Time Y
149SDRYIN Payment Instrument Y
150SDSBALSubstitutes Allowed (Y/N) Y
151SDSBLSubledger Y
152SDSBLTSubledger Type Y
153SDSERNLot Serial Number Y
154SDSFXOOrder Suffix Y
155SDSHANShip To Y
156SDSHCMShipping Commodity Class Y
157SDSHCNShipping Conditions Code Y
158SDSHPNShipment Number Y
159SDSLC2Salesperson Commission Y
160SDSLCMSalesperson Commission 1 Y
161SDSLM2Salesperson Code 02 Y
162SDSLSMSalesperson Code 01 Y
163SDSO01Inter Branch Sales Y
164SDSO02On Hand Updated Y
165SDSO03Configurator Print Flag Y
166SDSO04Sales Order Status 04 Y
167SDSO05Substitute Item Indicator Y
168SDSO06Preference Commitment Ind Y
169SDSO07Ship Date Overridden Y
170SDSO08 Price Adjustment Line Ind Y
171SDSO09Price Adj History Indica Y
172SDSO10Preference Product Alloca Y
173SDSO11Transfer/Direct Ship Flag Y
174SDSO12Sales Order Status 12 Y
175SDSO13Euro Conversion Flag Y
176SDSO14Sales Order Status 14 Y
177SDSO15Sales Order Status 15 Y
178SDSO16Sales Order Status 16 Y
179SDSO17Sales Order Status 17 Y
180SDSO18Sales Order Status 18 Y
181SDSO19Sales Order Status 19 Y
182SDSO20Sales Order Status 20 Y
183SDSOBKQuantity Backordered Y
184SDSOCNQuantity Canceled Y
185SDSONEFuture Quantity Committed Y
186SDSOQSQuantity Shipped Y
187SDSQORSecondary Quantity Ordered Y
188SDSRP1Sales Catalog Section Y
189SDSRP2Sub Section Y
190SDSRP3Sales Category Code 3 Y
191SDSRP4Sales Category Code 4 Y
192SDSRP5Sales Category Code 5 Y
193SDSTOPStop Code Y
194SDSTTSLine Status Y
195SDSUBSubsidiary Y
196SDSWMSWarehouse Status Code Y
197SDTAX1Sales Taxable Y
198SDTCSTTransfer Cost Y
199SDTDAYTime of Day Y
200SDTHGDThru Grade Y
201SDTHRPThru Potency Y
202SDTORGTransaction Originator Y
203SDTPCTemporary Price (Y/N) Y
204SDTRDCTrade Discount Y
205SDTRDJOrder Date Y
206SDTXA1Tax Rate/Area Y
207SDUNCDFreeze Code Y
208SDUNCSUnit Cost Y
209SDUOMU/M Y
210SDUOM1Unit of Measure Y
211SDUOM2Secondary UOM Y
212SDUOM4Pricing UOM Y
213SDUOPNQuantity Open Y
214SDUORGQuantity Y
215SDUPC1Price Code 1 Y
216SDUPC2Price Code 2 Y
217SDUPC3Price Code 3 Y
218SDUPMJDate Updated Y
219SDUPRCUnit Price Y
220SDURABUser Reserved Number Y
221SDURATUser Reserved Amount Y
222SDURCDUser Reserved Code Y
223SDURDTUser Reserved Date Y
224SDURRFUser Reserved Reference Y
225SDUSERUser ID Y
226SDVENDPrimary / Last Supplier N Y
227SDVLUMVolume Unit of Measure Y
228SDVR01Reference Y
229SDVR02Reference 2 Y
230SDWTUMWeight Unit of Measure Y
231SDZONZone Number Y
232UDJOBSQSequence Number Y
233UDPSJOBNOJob Number Y
234XDPAKSSCC Number - Pack Level Y
235XDPLTSSCC Number - Tare Level Y
236XDSCCNSCC Number Y
237XDSCCQSCC Quantity Y
238XDSCUMSCC Unit of Measure Y
239XDUPCNUPC Number Y
240XDUPQTUPC Quantity Y
241XDUPUMUPC Unit of Measure Y