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
2F0101ABAddress Book Master
3F4311PDPurchase Order Detail File
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File

160 COLUMNS | 3 INDEXES | Print definition?920 | 40 | F49211Z1 TABLE

40: Inventory/OP Base
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F49211Z1S11603Sales Order Detail Tag Unedited Transaction FileExtra Features Files42: Sales ManagementBusiness 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 S1EDUS, S1EDBT, S1EDTN, S1EDLN, S1EDCT, S1TYTN, S1EDFT, S1EDDT, S1DRIN, S1EDDL, S1EDSP, S1PNID, S1TNAC, S1DOCO, S1DCTO, S1KCOO, S1LNID, S1VMCU, S1TRP, S1LOAD, S1DSGP, S1BPFG, S1DSTN, S1UM, S1DEFF, S1DUNC, S1FDUC, S1DREV, S1FDRV, S1ANUM, S1SIDT, S1INCY, S1LDDT, S1LDTM, S1DCDT, S1PCQY, S1UOMC, S1TEMP, S1STPU, S1DNTY, S1DNTP, S1DETP, S1DTPU, S1VCF, S1PRAS, S1CP01, S1IQTY, S1STUM, S1BUM6, S1AMBR, S1BUM3, S1WGTR, S1BUM5, S1FRTV, S1FRTD, S1FRCC, S1FRVC, S1PVEH, S1RLNO, S1MCUR, S1FLTN, S1DSNN, S1ARCT, S1SORG, S1ELTM, S1PTNR, S1IAN8, S1PTC, S1DOC, S1DCT, S1KCO, S1CRR, S1CRCD, S1TXA1, S1EXR1, S1FRDM, S1FUPT, S1RINO, S1GLOC, S1AUTA, S1ALPH, S1MET1, S1OPN1, S1PNR1, S1MET2, S1OPN2, S1PNR2, S1MET3, S1OPN3, S1PNR3, S1ARDT, S1ARTM, S1DPDT, S1DETM, S1DSTJ, S1STM, S1END, S1ETM, S1TV01, S1TV02, S1TV03, S1TV04, S1TV05, S1TVCD, S1TVQT, S1TVDT, S1TVUM, S1URCD, S1URDT, S1URAT, S1URAB, S1URRF, S1TORG, S1USER, S1PID, S1JOBN, S1UPMJ, S1TDAY, S1SBCK, S1EDCK, S1CMDM, S1BBCK, S1RQSJ, S1PSDJ, S1ADLJ, S1SUB, S1STTS, S1RATT, S1FUF1, S1FRTC, S1FRAT, S1AFT, S1OMCU, S1OBJ, S1LT, S1FAPP, S1DSPR, S1DSFT, S1DMT1, S1DMS1, S1COT, S1CMGL, S1BALU, S1APOT, S1ACGD, S1ANI, S1AID, S1OPOL, S1OPBO, S1OPID, S1OPCS, S1OPLL, S1OPMS, S1OPSS, S1OPBA, S1FXSR, S1PSJOBNO, S1JOBSQ, S1CARDNO, S1DELBATCH FROM F49211Z1

TOP920 | 40 | F49211Z1 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1S1EDUSEDI - User IDStringGeneric Edit100 Allow NULL? 
2S1EDBTEDI - Batch NumberStringGeneric Edit150 Allow NULL? 
3S1EDTNEDI - Transaction NumberStringGeneric Edit220 Allow NULL? 
4S1EDLNEDI - Line NumberNumericGeneric Edit73 Allow NULL? 
5S1EDCTEDI - Document TypeStringGeneric Edit20 Allow NULL? 
6S1TYTNType - TransactionStringUDC (00 TT)80 Allow NULL? 
7S1EDFTEDI - Translation FormatStringGeneric Edit100 Allow NULL? 
8S1EDDTEDI - Transmission DateDateGeneric Edit60
9S1DRINDirection IndicatorCharacterUDC (00 DN)10 Allow NULL? 
10S1EDDLEDI - Detail Lines ProcessedNumericGeneric Edit50 Allow NULL? 
11S1EDSPEDI - Successfully ProcessedCharacterGeneric Edit10 Allow NULL? 
12S1PNIDTrading Partner IDStringGeneric Edit150 Allow NULL? 
13S1TNACTransaction ActionStringUDC (00 TA)20 Allow NULL? 
14S1DOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
15S1DCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
16S1KCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
17S1LNIDLine NumberNumericGeneric Edit63 Allow NULL? 
18S1VMCUDepot - TripStringGeneric Edit120 Allow NULL? 
19S1TRPTrip NumberNumericGeneric Edit80 Allow NULL? 
20S1LOADDate - Scheduled LoadDateGeneric Edit60
21S1DSGPDispatch GroupStringUDC (41B DG)30 Allow NULL? 
22S1BPFGBulk/Packed FlagCharacterUDC (41B BF)10 Allow NULL? 
23S1DSTNDistanceNumericGeneric Edit50 Allow NULL? 
24S1UMUnit of MeasureStringUDC (00 UM)20 Allow NULL? 
25S1DEFFDeferred Entries FlagCharacterGeneric Edit10 Allow NULL? 
26S1DUNCAmount - Deferred CostNumericGeneric Edit154 Allow NULL? 
27S1FDUCAmount - Foreign Deferred CostNumericGeneric Edit154 Allow NULL? 
28S1DREVAmount - Deferred RevenueNumericGeneric Edit154 Allow NULL? 
29S1FDRVAmount - Foreign Deferred RevenueNumericGeneric Edit154 Allow NULL? 
30S1ANUMNumber - AAI Table NumberNumericGeneric Edit40 Allow NULL? 
31S1SIDTScheduled Invoice DateDateGeneric Edit60
32S1INCYInvoice Cycle CodeStringUDC (40 CY)30 Allow NULL? 
33S1LDDTLoad Confirm DateDateGeneric Edit60
34S1LDTMTime - LoadNumericGeneric Edit60 Allow NULL? 
35S1DCDTDelivery Confirm DateDateGeneric Edit60
36S1PCQYUnits - Primary Committed QuantityNumericGeneric Edit150 Allow NULL? 
37S1UOMCUnit of Measure - Committed QuantityStringUDC (00 UM)20 Allow NULL? 
38S1TEMPTemperatureNumericGeneric Edit72 Allow NULL? 
39S1STPUTemperature TypeCharacterUDC (41B TP)10 Allow NULL? 
40S1DNTYDensityNumericGeneric Edit72 Allow NULL? 
41S1DNTPDensity Type - At Standard TemperatureCharacterUDC (41B DT)10 Allow NULL? 
42S1DETPDensity TemperatureNumericGeneric Edit72 Allow NULL? 
43S1DTPUTemperature TypeCharacterUDC (41B TP)10 Allow NULL? 
44S1VCFVolume Correction FactorNumericGeneric Edit75 Allow NULL? 
45S1PRASPrice at Ambient/Standard/Weight (A S W)CharacterUDC (38 PR)10 Allow NULL? 
46S1CP01Sales Price Based On DateCharacterUDC (40 DB)10 Allow NULL? 
47S1IQTYUnits - Invoice QuantityNumericGeneric Edit150 Allow NULL? 
48S1STUMQuantity - Primary Stock Accounting UnitNumericGeneric Edit150 Allow NULL? 
49S1BUM6Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
50S1AMBRVolume - AmbientNumericGeneric Edit150 Allow NULL? 
51S1BUM3Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
52S1WGTRWeight ResultNumericGeneric Edit150 Allow NULL? 
53S1BUM5Unit of Measure 5StringUDC (00 UM)20 Allow NULL? 
54S1FRTVSupplier Freight CalculatedCharacterGeneric Edit10 Allow NULL? 
55S1FRTDCustomer Freight CalculatedCharacterGeneric Edit10 Allow NULL? 
56S1FRCCAmount - Customer Freight ChargeNumericGeneric Edit154 Allow NULL? 
57S1FRVCAmount - Supplier Freight ChargeNumericGeneric Edit154 Allow NULL? 
58S1PVEHPrimary Vehicle IdStringGeneric Edit120 Allow NULL? 
59S1RLNORegistration/License NumberStringGeneric Edit130 Allow NULL? 
60S1MCURBusiness Unit - A/R DefaultStringGeneric Edit120 Allow NULL? 
61S1FLTNFlight NumberStringGeneric Edit80 Allow NULL? 
62S1DSNNDestinationStringGeneric Edit50 Allow NULL? 
63S1ARCTAircraft TypeStringGeneric Edit (49 AT)50 Allow NULL? 
64S1SORGOriginStringGeneric Edit150 Allow NULL? 
65S1ELTMTime - ElapsedNumericGeneric Edit60 Allow NULL? 
66S1PTNRShipment NumberNumericGeneric Edit80 Allow NULL? 
67S1IAN8Address Number - Bond IssuedNumericGeneric Edit80 Allow NULL? 
68S1PTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
69S1DOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
70S1DCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
71S1KCODocument CompanyStringGeneric Edit50 Allow NULL? 
72S1CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
73S1CRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
74S1TXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
75S1EXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
76S1FRDMInternational/Domestic FlagCharacterGeneric Edit10 Allow NULL? 
77S1FUPTFueling PortStringUDC (49 FP)30 Allow NULL? 
78S1RINORegistration/Identification NumberStringGeneric Edit150 Allow NULL? 
79S1GLOCDelivery LocationStringGeneric Edit150 Allow NULL? 
80S1AUTAAuthorization NameStringGeneric Edit300 Allow NULL? 
81S1ALPHName - AlphaStringGeneric Edit400 Allow NULL? 
82S1MET1Meter Ticket 1StringGeneric Edit100 Allow NULL? 
83S1OPN1Units - Beginning Throughput Qty. 1NumericGeneric Edit150 Allow NULL? 
84S1PNR1Closing Reading 1NumericGeneric Edit150 Allow NULL? 
85S1MET2Meter Ticket 2StringGeneric Edit100 Allow NULL? 
86S1OPN2Units - Beginning Throughput Qty. 2NumericGeneric Edit150 Allow NULL? 
87S1PNR2Closing Reading 2NumericGeneric Edit150 Allow NULL? 
88S1MET3Meter Ticket 3StringGeneric Edit100 Allow NULL? 
89S1OPN3Units - Beginning Throughput Qty. 3NumericGeneric Edit150 Allow NULL? 
90S1PNR3Closing Reading 3NumericGeneric Edit150 Allow NULL? 
91S1ARDTDate - ArrivalDateGeneric Edit60
92S1ARTMTime - ArrivalNumericGeneric Edit60 Allow NULL? 
93S1DPDTDate - DepartureDateGeneric Edit60
94S1DETMTime - DepartureNumericGeneric Edit60 Allow NULL? 
95S1DSTJDate - Start Job(Julian)DateGeneric Edit60
96S1STMTime - Start (HH/MM)NumericGeneric Edit40 Allow NULL? 
97S1ENDDate - EndingDateGeneric Edit60
98S1ETMTime - End (HH/MM)NumericGeneric Edit40 Allow NULL? 
99S1TV01Sales Detail Line OriginCharacterGeneric Edit10 Allow NULL? 
100S1TV02Future Use 02CharacterGeneric Edit10 Allow NULL? 
101S1TV03Future Use 03CharacterGeneric Edit10 Allow NULL? 
102S1TV04Future Use 04CharacterGeneric Edit10 Allow NULL? 
103S1TV05Future Use 05CharacterGeneric Edit10 Allow NULL? 
104S1TVCDFuture Use CodeStringGeneric Edit20 Allow NULL? 
105S1TVQTFuture Use QuantityNumericGeneric Edit150 Allow NULL? 
106S1TVDTFuture Use DateDateGeneric Edit60
107S1TVUMFuture Use Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
108S1URCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
109S1URDTUser Reserved DateDateGeneric Edit60
110S1URATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
111S1URABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
112S1URRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
113S1TORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
114S1USERUser IDStringGeneric Edit100 Allow NULL? 
115S1PIDProgram IDStringGeneric Edit100 Allow NULL? 
116S1JOBNWork Station IDStringGeneric Edit100 Allow NULL? 
117S1UPMJDate - UpdatedDateGeneric Edit60
118S1TDAYTime of DayNumericGeneric Edit60 Allow NULL? 
119S1SBCKCheck Sell By DateCharacterGeneric Edit10 Allow NULL? 
120S1EDCKCheck Expiration DateCharacterGeneric Edit10 Allow NULL? 
121S1CMDMCommitment Date MethodCharacterUDC (H40 CD)10 Allow NULL? 
122S1BBCKCheck Best Before DateCharacterGeneric Edit10 Allow NULL? 
123S1RQSJDate - Requested ShipDateGeneric Edit60
124S1PSDJDate - Future Date 2DateGeneric Edit60
125S1ADLJDate - Actual DeliveryDateGeneric Edit60
126S1SUBSubsidiaryStringGeneric Edit80 Allow NULL? 
127S1STTSLine StatusStringGeneric Edit20 Allow NULL? 
128S1RATTRate Type - Freight/MiscCharacterGeneric Edit10 Allow NULL? 
129S1FUF1AIA Document FlagCharacterUDC (H40 FU)10 Allow NULL? 
130S1FRTCFreight Calculated (Y/N)CharacterGeneric Edit10 Allow NULL? 
131S1FRATRate Code - Frieght/MiscStringUDC (41 RT)100 Allow NULL? 
132S1AFTApply Freight - Y/NCharacterGeneric Edit10 Allow NULL? 
133S1OMCUProject Business UnitStringGeneric Edit120 Allow NULL? 
134S1OBJObject AccountStringGeneric Edit60 Allow NULL? 
135S1LTLedger TypesStringUDC (09 LT)20 Allow NULL? 
136S1FAPPDiscount Application TypeCharacterGeneric Edit10 Allow NULL? 
137S1DSPRDiscount FactorNumericGeneric Edit74 Allow NULL? 
138S1DSFTDiscount Factor Type - $ or % (D/P)CharacterUDC (H41 DS)10 Allow NULL? 
139S1DMT1Agreement Number - Distr. (secondary)StringGeneric Edit120 Allow NULL? 
140S1DMS1Agreement Supplement - Dist. (Secondary)NumericGeneric Edit30 Allow NULL? 
141S1COTConditions of TransportStringUDC (00 TC)30 Allow NULL? 
142S1CMGLCommitment MethodCharacterUDC (H40 CM)10 Allow NULL? 
143S1BALUContract Balances Updated Y/NCharacterGeneric Edit10 Allow NULL? 
144S1APOTActual PotencyNumericGeneric Edit73 Allow NULL? 
145S1ACGDActual GradeStringUDC (40 LG)30 Allow NULL? 
146S1ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290 Allow NULL? 
147S1AIDAccount IDStringGeneric Edit80 Allow NULL? 
148S1OPOLOP Original Line NumberNumericGeneric Edit63 Allow NULL? 
149S1OPBOOP Business ObjectiveStringUDC (34A BO)300 Allow NULL? 
150S1OPIDOP Scenario IDStringGeneric Edit300 Allow NULL? 
151S1OPCSOP CostNumericGeneric Edit154 Allow NULL? 
152S1OPLLOP Partial Ship Line ItemsCharacterGeneric Edit10 Allow NULL? 
153S1OPMSOP Allow Multi SourceCharacterGeneric Edit10 Allow NULL? 
154S1OPSSOP Allow SubstitutesCharacterGeneric Edit10 Allow NULL? 
155S1OPBAOP Allow BackordersCharacterGeneric Edit10 Allow NULL? 
156S1FXSRFix Source LocationCharacterGeneric Edit10 Allow NULL? 
157S1PSJOBNOProduction Sequencing Job NumberStringGeneric Edit150 Allow NULL? 
158S1JOBSQJob Sequence NumberStringGeneric Edit150 Allow NULL? 
159S1CARDNOCard NumberStringUDC (40R CD)40 Allow NULL? 
160S1DELBATCHDelivery Batch NumberStringGeneric Edit60 Allow NULL? 

TOP920 | 40 | F49211Z1 INDEXES

NumberDescription
1UserID BatchNumber +A (Primary/Unique)
ElementAliasDescriptionSequence
1EDUSEDI - User IDAscending
2EDBTEDI - Batch NumberAscending
3EDTNEDI - Transaction NumberAscending
4EDLNEDI - Line NumberAscending
2Doc Number Doc Type +
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4EDUSEDI - User IDAscending
5LNIDLine NumberAscending
3Doc Number Line Number +
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4LNIDLine NumberAscending
5EDUSEDI - User IDAscending