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
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
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F0411RPAccounts Payable Ledger
4F4311PDPurchase Order Detail File
5F4211SDSales Order Detail File
6F0006MCBusiness Unit Master
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

137 COLUMNS | 1 INDEXES | Print definition?910 | 42B | F49299 TABLE

42B: Sales Order Entry
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F49299UD1371S.O. Detail Tag Ledger FileFiles42B: Sales Order EntryBusiness Data
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

SELECT UDDOCO, UDDCTO, UDKCOO, UDLNID, UDVMCU, UDTRP, UDLOAD, UDDSGP, UDBPFG, UDDSTN, UDUM, UDDEFF, UDDUNC, UDFDUC, UDDREV, UDFDRV, UDANUM, UDSIDT, UDINCY, UDLDDT, UDLDTM, UDDCDT, UDPCQY, UDUOMC, UDTEMP, UDSTPU, UDDNTY, UDDNTP, UDDETP, UDDTPU, UDVCF, UDPRAS, UDCP01, UDIQTY, UDSTUM, UDBUM6, UDAMBR, UDBUM3, UDWGTR, UDBUM5, UDFRTV, UDFRTD, UDFRCC, UDFRVC, UDPVEH, UDRLNO, UDMCUR, UDFLTN, UDDSNN, UDARCT, UDSORG, UDELTM, UDPTNR, UDIAN8, UDPTC, UDDOC, UDDCT, UDKCO, UDCRR, UDCRCD, UDTXA1, UDEXR1, UDFRDM, UDFUPT, UDRINO, UDGLOC, UDAUTA, UDALPH, UDMET1, UDOPN1, UDPNR1, UDMET2, UDOPN2, UDPNR2, UDMET3, UDOPN3, UDPNR3, UDARDT, UDARTM, UDDPDT, UDDETM, UDDSTJ, UDSTM, UDEND, UDETM, UDTV01, UDTV02, UDTV03, UDTV04, UDTV05, UDTVCD, UDTVQT, UDTVDT, UDTVUM, UDUSER, UDPID, UDJOBN, UDUPMJ, UDTDAY, UDSBCK, UDEDCK, UDCMDM, UDBBCK, UDRQSJ, UDPSDJ, UDADLJ, UDSUB, UDSTTS, UDRATT, UDFUF1, UDFRTC, UDFRAT, UDAFT, UDOMCU, UDOBJ, UDLT, UDFAPP, UDDSPR, UDDSFT, UDDMT1, UDDMS1, UDCOT, UDCMGL, UDBALU, UDAPOT, UDACGD, UDANI, UDAID, UDOPOL, UDOPBO, UDOPID, UDOPCS, UDOPLL, UDOPMS, UDOPSS, UDOPBA, UDFXSR FROM F49299

TOP910 | 42B | F49299 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1UDDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
2UDDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
3UDKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
4UDLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
5UDVMCUDepot - TripStringGeneric Edit120 Allow NULL? 
6UDTRPTrip NumberNumericGeneric Edit80 Allow NULL? 
7UDLOADDate - Scheduled LoadDateGeneric Edit60
8UDDSGPDispatch GroupStringUDC (41B DG)30 Allow NULL? 
9UDBPFGBulk/Packed FlagCharacterUDC (41B BF)10 Allow NULL? 
10UDDSTNDistanceNumericGeneric Edit50 Allow NULL? 
11UDUMUnit of MeasureStringUDC (00 UM)20 Allow NULL? 
12UDDEFFDeferred Entries FlagCharacterGeneric Edit10 Allow NULL? 
13UDDUNCAmount - Deferred CostNumericGeneric Edit154 Allow NULL? 
14UDFDUCAmount - Foreign Deferred CostNumericGeneric Edit154 Allow NULL? 
15UDDREVAmount - Deferred RevenueNumericGeneric Edit154 Allow NULL? 
16UDFDRVAmount - Foreign Deferred RevenueNumericGeneric Edit154 Allow NULL? 
17UDANUMNumber - AAI Table NumberNumericGeneric Edit40 Allow NULL? 
18UDSIDTScheduled Invoice DateDateGeneric Edit60
19UDINCYInvoice Cycle CodeStringUDC (40 CY)30 Allow NULL? 
20UDLDDTLoad Confirm DateDateGeneric Edit60
21UDLDTMTime - LoadNumericGeneric Edit60 Allow NULL? 
22UDDCDTDelivery Confirm DateDateGeneric Edit60
23UDPCQYUnits - Primary Committed QuantityNumericGeneric Edit152 Allow NULL? 
24UDUOMCUnit of Measure - Committed QuantityStringUDC (00 UM)20 Allow NULL? 
25UDTEMPTemperatureNumericGeneric Edit72 Allow NULL? 
26UDSTPUTemperature TypeCharacterUDC (41B TP)10 Allow NULL? 
27UDDNTYDensityNumericGeneric Edit72 Allow NULL? 
28UDDNTPDensity Type - At Standard TemperatureCharacterUDC (41B DT)10 Allow NULL? 
29UDDETPDensity TemperatureNumericGeneric Edit72 Allow NULL? 
30UDDTPUTemperature TypeCharacterUDC (41B TP)10 Allow NULL? 
31UDVCFVolume Correction FactorNumericGeneric Edit74 Allow NULL? 
32UDPRASPrice at Ambient/Standard/Weight (A S W)CharacterUDC (38 PR)10 Allow NULL? 
33UDCP01Sales Price Based On DateCharacterUDC (40 DB)10 Allow NULL? 
34UDIQTYUnits - Invoice QuantityNumericGeneric Edit152 Allow NULL? 
35UDSTUMQuantity - Primary Stock Accounting UnitNumericGeneric Edit152 Allow NULL? 
36UDBUM6Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
37UDAMBRVolume - AmbientNumericGeneric Edit152 Allow NULL? 
38UDBUM3Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
39UDWGTRWeight ResultNumericGeneric Edit152 Allow NULL? 
40UDBUM5Unit of Measure 5StringUDC (00 UM)20 Allow NULL? 
41UDFRTVSupplier Freight CalculatedCharacterGeneric Edit10 Allow NULL? 
42UDFRTDCustomer Freight CalculatedCharacterGeneric Edit10 Allow NULL? 
43UDFRCCAmount - Customer Freight ChargeNumericGeneric Edit154 Allow NULL? 
44UDFRVCAmount - Supplier Freight ChargeNumericGeneric Edit154 Allow NULL? 
45UDPVEHPrimary Vehicle IdStringGeneric Edit120 Allow NULL? 
46UDRLNORegistration/License NumberStringGeneric Edit130 Allow NULL? 
47UDMCURBusiness Unit - A/R DefaultStringGeneric Edit120 Allow NULL? 
48UDFLTNFlight NumberStringGeneric Edit80 Allow NULL? 
49UDDSNNDestinationStringGeneric Edit50 Allow NULL? 
50UDARCTAircraft TypeStringGeneric Edit (49 AT)50 Allow NULL? 
51UDSORGOriginStringGeneric Edit150 Allow NULL? 
52UDELTMTime - ElapsedNumericGeneric Edit60 Allow NULL? 
53UDPTNRShipment NumberNumericGeneric Edit80 Allow NULL? 
54UDIAN8Address Number - Bond IssuedNumericGeneric Edit80 Allow NULL? 
55UDPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
56UDDOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
57UDDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
58UDKCODocument CompanyStringGeneric Edit50 Allow NULL? 
59UDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
60UDCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
61UDTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
62UDEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
63UDFRDMInternational/Domestic FlagCharacterGeneric Edit10 Allow NULL? 
64UDFUPTFueling PortStringUDC (49 FP)30 Allow NULL? 
65UDRINORegistration/Identification NumberStringGeneric Edit150 Allow NULL? 
66UDGLOCDelivery LocationStringGeneric Edit150 Allow NULL? 
67UDAUTAAuthorization NameStringGeneric Edit300 Allow NULL? 
68UDALPHName - AlphaStringGeneric Edit400 Allow NULL? 
69UDMET1Meter Ticket 1StringGeneric Edit100 Allow NULL? 
70UDOPN1Units - Beginning Throughput Qty. 1NumericGeneric Edit150 Allow NULL? 
71UDPNR1Closing Reading 1NumericGeneric Edit150 Allow NULL? 
72UDMET2Meter Ticket 2StringGeneric Edit100 Allow NULL? 
73UDOPN2Units - Beginning Throughput Qty. 2NumericGeneric Edit150 Allow NULL? 
74UDPNR2Closing Reading 2NumericGeneric Edit150 Allow NULL? 
75UDMET3Meter Ticket 3StringGeneric Edit100 Allow NULL? 
76UDOPN3Units - Beginning Throughput Qty. 3NumericGeneric Edit150 Allow NULL? 
77UDPNR3Closing Reading 3NumericGeneric Edit150 Allow NULL? 
78UDARDTDate - ArrivalDateGeneric Edit60
79UDARTMTime - ArrivalNumericGeneric Edit60 Allow NULL? 
80UDDPDTDate - DepartureDateGeneric Edit60
81UDDETMTime - DepartureNumericGeneric Edit60 Allow NULL? 
82UDDSTJDate - Start Job(Julian)DateGeneric Edit60
83UDSTMTime - Start (HH/MM)NumericGeneric Edit40 Allow NULL? 
84UDENDDate - EndingDateGeneric Edit60
85UDETMTime - End (HH/MM)NumericGeneric Edit40 Allow NULL? 
86UDTV01Sales Detail Line OriginCharacterGeneric Edit10 Allow NULL? 
87UDTV02Future Use 02CharacterGeneric Edit10 Allow NULL? 
88UDTV03Future Use 03CharacterGeneric Edit10 Allow NULL? 
89UDTV04Future Use 04CharacterGeneric Edit10 Allow NULL? 
90UDTV05Future Use 05CharacterGeneric Edit10 Allow NULL? 
91UDTVCDFuture Use CodeStringGeneric Edit20 Allow NULL? 
92UDTVQTFuture Use QuantityNumericGeneric Edit150 Allow NULL? 
93UDTVDTFuture Use DateDateGeneric Edit60
94UDTVUMFuture Use Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
95UDUSERUser IDStringGeneric Edit100 Allow NULL? 
96UDPIDProgram IDStringGeneric Edit100 Allow NULL? 
97UDJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
98UDUPMJDate - UpdatedDateGeneric Edit60
99UDTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
100UDSBCKCheck Sell By DateCharacterGeneric Edit10 Allow NULL? 
101UDEDCKCheck Expiration DateCharacterGeneric Edit10 Allow NULL? 
102UDCMDMCommitment Date MethodCharacterUDC (H40 CD)10 Allow NULL? 
103UDBBCKCheck Best Before DateCharacterGeneric Edit10 Allow NULL? 
104UDRQSJDate - Requested ShipDateGeneric Edit60
105UDPSDJDate - Future Date 2DateGeneric Edit60
106UDADLJDate - Actual DeliveryDateGeneric Edit60
107UDSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
108UDSTTSLine StatusStringGeneric Edit20 Allow NULL? 
109UDRATTRate Type - Freight/MiscCharacterGeneric Edit10 Allow NULL? 
110UDFUF1AIA Document FlagCharacterUDC (H40 FU)10 Allow NULL? 
111UDFRTCFreight Calculated (Y/N)CharacterGeneric Edit10 Allow NULL? 
112UDFRATRate Code - Frieght/MiscStringUDC (41 RT)100 Allow NULL? 
113UDAFTApply Freight - Y/NCharacterGeneric Edit10 Allow NULL? 
114UDOMCUProject Business UnitStringGeneric Edit120 Allow NULL? 
115UDOBJObject AccountStringGeneric Edit60 Allow NULL? 
116UDLTLedger TypesStringUDC (09 LT)20 Allow NULL? 
117UDFAPPDiscount Application TypeCharacterGeneric Edit10 Allow NULL? 
118UDDSPRDiscount FactorNumericGeneric Edit74 Allow NULL? 
119UDDSFTDiscount Factor Type - $ or % (D/P)CharacterUDC (H41 DS)10 Allow NULL? 
120UDDMT1Agreement Number - Distr. (secondary)StringGeneric Edit120 Allow NULL? 
121UDDMS1Agreement Supplement - Dist. (Secondary)NumericGeneric Edit30 Allow NULL? 
122UDCOTConditions of TransportStringUDC (00 TC)30 Allow NULL? 
123UDCMGLCommitment MethodCharacterUDC (H40 CM)10 Allow NULL? 
124UDBALUContract Balances Updated Y/NCharacterGeneric Edit10 Allow NULL? 
125UDAPOTActual PotencyNumericGeneric Edit73 Allow NULL? 
126UDACGDActual GradeStringUDC (40 LG)30 Allow NULL? 
127UDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290 Allow NULL? 
128UDAIDAccount IDStringGeneric Edit80 Allow NULL? 
129UDOPOLOP Original Line NumberNumericGeneric Edit63 Allow NULL? 
130UDOPBOOP Business ObjectiveStringUDC (34A BO)300 Allow NULL? 
131UDOPIDOP Scenario IDStringGeneric Edit300 Allow NULL? 
132UDOPCSOP CostNumericGeneric Edit154 Allow NULL? 
133UDOPLLOP Partial Ship Line ItemsCharacterGeneric Edit10 Allow NULL? 
134UDOPMSOP Allow Multi SourceCharacterGeneric Edit10 Allow NULL? 
135UDOPSSOP Allow SubstitutesCharacterGeneric Edit10 Allow NULL? 
136UDOPBAOP Allow BackordersCharacterGeneric Edit10 Allow NULL? 
137UDFXSRFix Source LocationCharacterGeneric Edit10 Allow NULL? 

TOP910 | 42B | F49299 INDEXES

NumberDescription
1Order Number Order Type... (Primary/Unique)
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4LNIDLine NumberAscending
5UPMJDate - UpdatedAscending
6TDAYTime of DayAscending