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

1 column | Print definition?812 | 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
1    SDACGDActual GradeY
2    SDACOMApply Commission (Y/N)Y
3    SDADDJActual ShipY
4    SDADLJActual DeliveryY
5    SDAEXPExtended PriceY
6    SDAFT Apply Freight (Y/N)Y
7    SDAID Account IDY
8    SDAITM3rd Item NumberY
9    SDAN8 Address NumberY
10    SDANBYBuyer NumberY
11    SDANI Account NumberY
12    SDAOPNAmount OpenY
13    SDAPOTActual PotencyY
14    SDAPTSPartial Shipments AllowedY
15    SDAPUMEntered Unit of Measure fY
16    SDASN Adjustment ScheduleY
17    SDATXTAssociated TextY
18    SDBACKBackorders Allowed (Y/N)Y
19    SDBALUContract Balances UpdatedY
20    SDBCRCBase CurrencyY
21    SDBTANBill To NumberY
22    SDCADCCash Discount %Y
23    SDCARSCarrier NumberY
24    SDCLVLPricing Category LevelY
25    SDCMCGCommission CategoryY
26    SDCMGLCommitment MethodY
27    SDCMGPInventory Costing MethodY
28    SDCNDJCancel DateY
29    SDCNIDContainer IDY
30    SDCO  CompanyY
31    SDCOM Committed (H/S)Y
32    SDCOT Conditions of TransportY
33    SDCPNTComponent Line NumberY
34    SDCRCDCurrency CodeY
35    SDCRMDSend MethodY
36    SDCRR Exchange RateY
37    SDCSIDConfigured String IDY
38    SDCSTOCost Override CodeY
39    SDCTRYCenturyY
40    SDDCT Document TypeY
41    SDDCTOOrder TypeY
42    SDDELNDelivery NumberY
43    SDDGL G/L DateY
44    SDDMBUDemand Business UnitY
45    SDDMCSAgreement SupplementY
46    SDDMCTAgreement NbrY
47    SDDMS1Agreement SupplementY
48    SDDMT1Borrow AgreementY
49    SDDOC Document NumberY
50    SDDOCOOrder NumberY
51    SDDRQJRequestedY
52    SDDRQTRequested Delivery TimeY
53    SDDSC1DescriptionY
54    SDDSC2Description 2Y
55    SDDSFTDiscount Factor Type - $Y
56    SDDSPRDiscount FactorY
57    SDDTBSBased on DateY
58    SDDTYSDuty StatusY
59    SDECSTExtended CostY
60    SDEMCUHeader Business UnitY
61    SDEUSEEnd UseY
62    SDEXDPDays Before ExpirationY
63    SDEXR1Tax Expl CodeY
64    SDFAPPDiscount Application TypeY
65    SDFEA Foreign Extended PriceY
66    SDFEC Foreign Extended CostY
67    SDFPRCForeign List PriceY
68    SDFRATRate Code _ Freight/MiscY
69    SDFRGDFrom GradeY
70    SDFRMPFrom PotencyY
71    SDFRTCFreight Calculated (Y/N)Y
72    SDFRTHFreight Handling CodeY
73    SDFUC Foreign Unit CostY
74    SDFUF1AIA DocumentY
75    SDFUN2Trade Discount (Old)Y
76    SDFUP Foreign Unit PriceY
77    SDFY  Fiscal YearY
78    SDGLC G/L OffsetY
79    SDGRWTGross WeightY
80    SDGWUMGross Weight Unit of MeasureY
81    SDHDBUHeader Business UnitY
82    SDHOLDHold Orders CodeY
83    SDINMGPrint MessageY
84    SDITM Item Number (Short)Y
85    SDITVLUnit VolumeY
86    SDITWTUnit WeightY
87    SDIVD Invoice DateY
88    SDJOBNWork Station IDY
89    SDKCO Document CompanyY
90    SDKCOOOrder CompanyY
91    SDKTLNKit Master Line NumberY
92    SDKTP Number of Component Per PY
93    SDLCODLoc Tax CodeY
94    SDLDNMLoad NumberY
95    SDLITM2nd Item NumberY
96    SDLNIDLine NumberY
97    SDLNTYLine TypeY
98    SDLOB Line of BusinessY
99    SDLOCNLocationY
100    SDLOTNLot/SNY
101    SDLPRCUnit List PriceY
102    SDLT  Ledger TypeY
103    SDLTTRStatus Code - LastY
104    SDMCU Business UnitY
105    SDMERLItem Revision LevelY
106    SDMKFRMark-forY
107    SDMOT Mode of TrnY
108    SDNTR Nature of TransactionY
109    SDNXTRStatus Code - NextY
110    SDOBJ Object AccountY
111    SDOCTOOriginal Order TypeY
112    SDODCTOriginal Document TypeY
113    SDODOCOriginal Document NoY
114    SDOGNOOriginal Line NumberY
115    SDOKC Original Document CompanyY
116    SDOKCOOriginal Order Document CY
117    SDOMCUProject Cost CenterY
118    SDOORNOriginal Order NumberY
119    SDOPDJOriginal PromisedY
120    SDORP Order Repriced IndicatorY
121    SDORPROrder Reprice GroupY
122    SDOSEQSequence NumberY
123    SDOTQYOther QuantityY
124    SDPA8 Parent NumberY
125    SDPDDJScheduled PickY
126    SDPEFJPrice EffectiveY
127    SDPID Program IDY
128    SDPPDJShipY
129    SDPQORQuantity OrderedY
130    SDPRGRItem Price GroupY
131    SDPRIOPriority Processing CodeY
132    SDPROVPrice Override CodeY
133    SDPRP1Commodity ClassY
134    SDPRP2Commodity Sub ClassY
135    SDPRP3Supplier Rebate CodeY
136    SDPRP4Master Planning FamilyY
137    SDPRP5Landed Cost RuleY
138    SDPSN Pick Slip NumberY
139    SDPTC Payment TermsY
140    SDPTSKTask NumberY
141    SDQRLVQuantity RelievedY
142    SDQTYTQuantity Shipped to DateY
143    SDRATTRate Type - Freight/MiscY
144    SDRCD Reason CodeY
145    SDRCTORelated PO/SO/WO Order TyY
146    SDRESLPrinted CodeY
147    SDRKCORelated Order Key CompanyY
148    SDRKITRelated Kit ComponentY
149    SDRLITRelated Item Number (Kit)Y
150    SDRLLNRelated PO/SO Line NumberY
151    SDRORNRelated PO/SO/WO NumberY
152    SDROUTRoute CodeY
153    SDRPRCBasket Reprice GroupY
154    SDRQSJRequestedY
155    SDRSDJPromised DeliveryY
156    SDRSDTPromised Delivery TimeY
157    SDRYINPayment InstrumentY
158    SDS013Sales Order Status 13Y
159    SDS014Sale Order Status 14Y
160    SDS015Sales Order Status 15Y
161    SDSBALSubstitutes Allowed (Y/N)Y
162    SDSBL SubledgerY
163    SDSBLTSubledger TypeY
164    SDSCPDScheduled Completed DateY
165    SDSCPSScheduled Completed ShiftY
166    SDSCPTScheduled Completed TimeY
167    SDSERNLot Serial NumberY
168    SDSFX Pay ItemY
169    SDSFXOOrder SuffixY
170    SDSHANShip ToY
171    SDSHCMShipping Commodity ClassY
172    SDSHCNShipping Conditions CodeY
173    SDSHMTShipment Number (ITLS)Y
174    SDSHPNShipment NumberY
175    SDSLC2Salesperson CommissionY
176    SDSLCMSalesperson Commision 1Y
177    SDSLM2Salesperson Code 02Y
178    SDSLSMSalesperson Code 01Y
179    SDSO01Inter Branch SalesY
180    SDSO02On Hand UpdatedY
181    SDSO03Configurator Print FlagY
182    SDSO04Sales Order Status 04Y
183    SDSO05Substitue Item IndicatorY
184    SDSO06Preference Commitment IndY
185    SDSO07Ship Date OverriddenY
186    SDSO08Price Adjustment Line IndY
187    SDSO09Price Adj History IndicaY
188    SDSO10Preference Product AllocaY
189    SDSO11Transfer/Direct Ship FlagY
190    SDSO12Sales Order Status 12Y
191    SDSO16Sales Order Status 16Y
192    SDSO17Sales Order Status 17Y
193    SDSO18Sales Order Status 18Y
194    SDSO19Sales Order Status 19Y
195    SDSO20Sales Order Status 20Y
196    SDSOBKQuantity BackorderedY
197    SDSOCNQuantity CanceledY
198    SDSONEFuture Quantity CommittedY
199    SDSOQSQuantity ShippedY
200    SDSQORSecondary Quantity OrdereY
201    SDSRP1Sales Catalog SectionY
202    SDSRP2Sub SectionY
203    SDSRP3Sales Category Code 3Y
204    SDSRP4Sales Category Code 4Y
205    SDSRP5Sales Category Code 5Y
206    SDSTOPStop CodeY
207    SDSTTSLine StatusY
208    SDSUB SubsidiaryY
209    SDSWMSWarehouse Status CodeY
210    SDTAX1Sales TaxableY
211    SDTCSTTransfer CostY
212    SDTDAYTime of DayY
213    SDTHGDThru GradeY
214    SDTHRPThru PotencyY
215    SDTKDATicket DateY
216    SDTKNRTicket NumberY
217    SDTKTMTicket TimeY
218    SDTORGTransaction OriginatorY
219    SDTPC Temporary Price (Y/N)Y
220    SDTRDCTrade DiscountY
221    SDTRDJOrder DateY
222    SDTXA1Tax Rate/AreaY
223    SDUNCDFreeze CodeY
224    SDUNCSUnit CostY
225    SDUOM U/MY
226    SDUOM1Unit of MeasureY
227    SDUOM2Secondary UOMY
228    SDUOM4Pricing UOMY
229    SDUOPNQuantity OpenY
230    SDUORGQuantityY
231    SDUPC1Price Code 1Y
232    SDUPC2Price Code 2Y
233    SDUPC3Price Code 3Y
234    SDUPMJDate UpdatedY
235    SDUPRCUnit PriceY
236    SDURABUser Reserved NumberY
237    SDURATUser Reserved AmountY
238    SDURCDUser Reserved CodeY
239    SDURDTUser Reserved DateY
240    SDURRFUser Reserved ReferenceY
241    SDUSERUser IDY
242    SDVENDPrimary / Last Supplier NY
243    SDVLUMVolume Unit of MeasureY
244    SDVR01ReferenceY
245    SDVR02Reference 2Y
246    SDVR03Mark-for ReferenceY
247    SDWTUMWeight Unit of MeasureY
248    SDZON Zone NumberY
249    XDPAK SSCC Number - Pack LevelY
250    XDPLT SSCC Number - Tare LevelY
251    XDSCCNSCC NumberY
252    XDSCCQSCC QuantityY
253    XDSCUMSCC Unit of MeasureY
254    XDUPCNUPC NumberY
255    XDUPQTUPC QuantityY
256    XDUPUMUPC Unit of MeasureY
257SDACGD    Actual GradeY
258SDACOM    Apply Commission (Y/N)Y
259SDADDJ    Actual ShipY
260SDADLJ    Actual DeliveryY
261SDAEXP    Extended PriceY
262SDAFT     Apply Freight (Y/N)Y
263SDAID     Account IDY
264SDAITM    3rd Item NumberY
265SDAN8     Address NumberY
266SDANBY    Buyer NumberY
267SDANI     Account NumberY
268SDAOPN    Amount OpenY
269SDAPOT    Actual PotencyY
270SDAPTS    Partial Shipments AllowedY
271SDAPUM    Entered Unit of Measure fY
272SDASN     Adjustment ScheduleY
273SDATXT    Associated TextY
274SDBACK    Backorders Allowed (Y/N)Y
275SDBALU    Contract Balances UpdatedY
276SDBCRC    Base CurrencyY
277SDBTAN    Bill To NumberY
278SDCADC    Cash Discount %Y
279SDCARS    Carrier NumberY
280SDCLVL    Pricing Category LevelY
281SDCMCG    Commission CategoryY
282SDCMGL    Commitment MethodY
283SDCMGP    Inventory Costing MethodY
284SDCNDJ    Cancel DateY
285SDCNID    Container IDY
286SDCO      CompanyY
287SDCOM     Committed (H/S)Y
288SDCOMM    Committed (H/S)Y
289SDCOT     Conditions of TransportY
290SDCPNT    Component Line NumberY
291SDCRCD    Currency CodeY
292SDCRMD    Send MethodY
293SDCRR     Exchange RateY
294SDCSID    Configured String IDY
295SDCSTO    Cost Override CodeY
296SDCTRY    CenturyY
297SDDCT     Document TypeY
298SDDCTO    Order TypeY
299SDDELN    Delivery NumberY
300SDDGL     G/L DateY
301SDDMBU    Demand Business UnitY
302SDDMCS    Agreement SupplementY
303SDDMCT    Agreement NbrY
304SDDMS1    Agreement SupplementY
305SDDMT1    Borrow AgreementY
306SDDOC     Document NumberY
307SDDOCO    Order NumberY
308SDDRQJ    RequestedY
309SDDRQT    Requested Delivery TimeY
310SDDSC1    DescriptionY
311SDDSC2    Description 2Y
312SDDSFT    Discount Factor Type - $Y
313SDDSPR    Discount FactorY
314SDDTBS    Based on DateY
315SDDTYS    Duty StatusY
316SDECST    Extended CostY
317SDEMCU    Header Business UnitY
318SDEUSE    End UseY
319SDEXDP    Days Before ExpirationY
320SDEXR1    Tax Expl CodeY
321SDFAPP    Discount Application TypeY
322SDFEA     Foreign Extended PriceY
323SDFEC     Foreign Extended CostY
324SDFPRC    Foreign List PriceY
325SDFRAT    Rate Code _ Freight/MiscY
326SDFRGD    From GradeY
327SDFRMP    From PotencyY
328SDFRTC    Freight Calculated (Y/N)Y
329SDFRTH    Freight Handling CodeY
330SDFUC     Foreign Unit CostY
331SDFUF1    AIA DocumentY
332SDFUN2    Trade Discount (Old)Y
333SDFUP     Foreign Unit PriceY
334SDFY      Fiscal YearY
335SDGLC     G/L OffsetY
336SDGRWT    Gross WeightY
337SDGWUM    Gross Weight Unit of MeasureY
338SDHDBU    Header Business UnitY
339SDHOLD    Hold Orders CodeY
340SDINMG    Print MessageY
341SDITM     Item Number (Short)Y
342SDITVL    Unit VolumeY
343SDITWT    Unit WeightY
344SDIVD     Invoice DateY
345SDJOBN    Work Station IDY
346SDKCO     Document CompanyY
347SDKCOO    Order CompanyY
348SDKTLN    Kit Master Line NumberY
349SDKTP     Number of Component Per PY
350SDLCOD    Loc Tax CodeY
351SDLDNM    Load NumberY
352SDLITM    2nd Item NumberY
353SDLNID    Line NumberY
354SDLNTY    Line TypeY
355SDLOB     Line of BusinessY
356SDLOCN    LocationY
357SDLOTN    Lot/SNY
358SDLPRC    Unit List PriceY
359SDLT      Ledger TypeY
360SDLTTR    Status Code - LastY
361SDMCU     Business UnitY
362SDMERL    Item Revision LevelY
363SDMKFR    Mark-forY
364SDMOT     Mode of TrnY
365SDNTR     Nature of TransactionY
366SDNXTR    Status Code - NextY
367SDOBJ     Object AccountY
368SDOCTO    Original Order TypeY
369SDODCT    Original Document TypeY
370SDODOC    Original Document NoY
371SDOGNO    Original Line NumberY
372SDOKC     Original Document CompanyY
373SDOKCO    Original Order Document CY
374SDOMCU    Project Cost CenterY
375SDOORN    Original Order NumberY
376SDOPDJ    Original PromisedY
377SDORP     Order Repriced IndicatorY
378SDORPR    Order Reprice GroupY
379SDOSEQ    Sequence NumberY
380SDOTQY    Other QuantityY
381SDPA8     Parent NumberY
382SDPDDJ    Scheduled PickY
383SDPEFJ    Price EffectiveY
384SDPID     Program IDY
385SDPPDJ    ShipY
386SDPQOR    Quantity OrderedY
387SDPRGR    Item Price GroupY
388SDPRIO    Priority Processing CodeY
389SDPROV    Price Override CodeY
390SDPRP1    Commodity ClassY
391SDPRP2    Commodity Sub ClassY
392SDPRP3    Supplier Rebate CodeY
393SDPRP4    Master Planning FamilyY
394SDPRP5    Landed Cost RuleY
395SDPSN     Pick Slip NumberY
396SDPTC     Payment TermsY
397SDPTSK    Task NumberY
398SDQRLV    Quantity RelievedY
399SDQTYT    Quantity Shipped to DateY
400SDRATT    Rate Type - Freight/MiscY
401SDRCD     Reason CodeY
402SDRCTO    Related PO/SO/WO Order TyY
403SDRESL    Printed CodeY
404SDRKCO    Related Order Key CompanyY
405SDRKIT    Related Kit ComponentY
406SDRLIT    Related Item Number (Kit)Y
407SDRLLN    Related PO/SO Line NumberY
408SDRORN    Related PO/SO/WO NumberY
409SDROUT    Route CodeY
410SDRPRC    Basket Reprice GroupY
411SDRQSJ    RequestedY
412SDRSDJ    Promised DeliveryY
413SDRSDT    Promised Delivery TimeY
414SDRYIN    Payment InstrumentY
415SDS013    Sales Order Status 13Y
416SDS014    Sale Order Status 14Y
417SDS015    Sales Order Status 15Y
418SDSBAL    Substitutes Allowed (Y/N)Y
419SDSBL     SubledgerY
420SDSBLT    Subledger TypeY
421SDSCPD    Scheduled Completed DateY
422SDSCPS    Scheduled Completed ShiftY
423SDSCPT    Scheduled Completed TimeY
424SDSERN    Lot Serial NumberY
425SDSFX     Pay ItemY
426SDSFXO    Order SuffixY
427SDSHAN    Ship ToY
428SDSHCM    Shipping Commodity ClassY
429SDSHCN    Shipping Conditions CodeY
430SDSHMT    Shipment Number (ITLS)Y
431SDSHPN    Shipment NumberY
432SDSLC2    Salesperson CommissionY
433SDSLCM    Salesperson Commision 1Y
434SDSLM2    Salesperson Code 02Y
435SDSLSM    Salesperson Code 01Y
436SDSO01    Inter Branch SalesY
437SDSO02    On Hand UpdatedY
438SDSO03    Configurator Print FlagY
439SDSO04    Sales Order Status 04Y
440SDSO05    Substitue Item IndicatorY
441SDSO06    Preference Commitment IndY
442SDSO07    Ship Date OverriddenY
443SDSO08    Price Adjustment Line IndY
444SDSO09    Price Adj History IndicaY
445SDSO10    Preference Product AllocaY
446SDSO11    Transfer/Direct Ship FlagY
447SDSO12    Sales Order Status 12Y
448SDSO13    Euro Conversion FlagY
449SDSO14    Sales Order Status 14Y
450SDSO15    Sales Order Status 15Y
451SDSO16    Sales Order Status 16Y
452SDSO17    Sales Order Status 17Y
453SDSO18    Sales Order Status 18Y
454SDSO19    Sales Order Status 19Y
455SDSO20    Sales Order Status 20Y
456SDSOBK    Quantity BackorderedY
457SDSOCN    Quantity CanceledY
458SDSONE    Future Quantity CommittedY
459SDSOQS    Quantity ShippedY
460SDSQOR    Secondary Quantity OrdereY
461SDSRP1    Sales Catalog SectionY
462SDSRP2    Sub SectionY
463SDSRP3    Sales Category Code 3Y
464SDSRP4    Sales Category Code 4Y
465SDSRP5    Sales Category Code 5Y
466SDSTOP    Stop CodeY
467SDSTTS    Line StatusY
468SDSUB     SubsidiaryY
469SDSWMS    Warehouse Status CodeY
470SDTAX1    Sales TaxableY
471SDTCST    Transfer CostY
472SDTDAY    Time of DayY
473SDTHGD    Thru GradeY
474SDTHRP    Thru PotencyY
475SDTKDA    Ticket DateY
476SDTKNR    Ticket NumberY
477SDTKTM    Ticket TimeY
478SDTORG    Transaction OriginatorY
479SDTPC     Temporary Price (Y/N)Y
480SDTRDC    Trade DiscountY
481SDTRDJ    Order DateY
482SDTXA1    Tax Rate/AreaY
483SDUNCD    Freeze CodeY
484SDUNCS    Unit CostY
485SDUOM     U/MY
486SDUOM1    Unit of MeasureY
487SDUOM2    Secondary UOMY
488SDUOM4    Pricing UOMY
489SDUOPN    Quantity OpenY
490SDUORG    QuantityY
491SDUPC1    Price Code 1Y
492SDUPC2    Price Code 2Y
493SDUPC3    Price Code 3Y
494SDUPMJ    Date UpdatedY
495SDUPRC    Unit PriceY
496SDURAB    User Reserved NumberY
497SDURAT    User Reserved AmountY
498SDURCD    User Reserved CodeY
499SDURDT    User Reserved DateY
500SDURRF    User Reserved ReferenceY
501SDUSER    User IDY
502SDVEND    Primary / Last Supplier NY
503SDVLUM    Volume Unit of MeasureY
504SDVR01    ReferenceY
505SDVR02    Reference 2Y
506SDVR03    Mark-for ReferenceY
507SDWTUM    Weight Unit of MeasureY
508SDZON     Zone NumberY
509UDJOBSQ   Sequence NumberY
510UDPSJOBNO Job NumberY
511XDPAK     SSCC Number - Pack LevelY
512XDPLT     SSCC Number - Tare LevelY
513XDSCCN    SCC NumberY
514XDSCCQ    SCC QuantityY
515XDSCUM    SCC Unit of MeasureY
516XDUPCN    UPC NumberY
517XDUPQT    UPC QuantityY
518XDUPUM    UPC Unit of MeasureY