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
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

268 COLUMNS | 9 INDEXES | Print definition?920 | 42 | F42119 TABLE

42: Sales Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F42119SD2689Sales Order History FileHistory 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 SDKCOO, SDDOCO, SDDCTO, SDLNID, SDSFXO, SDMCU, SDCO, SDOKCO, SDOORN, SDOCTO, SDOGNO, SDRKCO, SDRORN, SDRCTO, SDRLLN, SDDMCT, SDDMCS, SDAN8, SDSHAN, SDPA8, SDDRQJ, SDTRDJ, SDPDDJ, SDADDJ, SDIVD, SDCNDJ, SDDGL, SDRSDJ, SDPEFJ, SDPPDJ, SDVR01, SDVR02, SDITM, SDLITM, SDAITM, SDLOCN, SDLOTN, SDFRGD, SDTHGD, SDFRMP, SDTHRP, SDEXDP, SDDSC1, SDDSC2, SDLNTY, SDNXTR, SDLTTR, SDEMCU, SDRLIT, SDKTLN, SDCPNT, SDRKIT, SDKTP, SDSRP1, SDSRP2, SDSRP3, SDSRP4, SDSRP5, SDPRP1, SDPRP2, SDPRP3, SDPRP4, SDPRP5, SDUOM, SDUORG, SDSOQS, SDSOBK, SDSOCN, SDSONE, SDUOPN, SDQTYT, SDQRLV, SDCOMM, SDOTQY, SDUPRC, SDAEXP, SDAOPN, SDPROV, SDTPC, SDAPUM, SDLPRC, SDUNCS, SDECST, SDCSTO, SDTCST, SDINMG, SDPTC, SDRYIN, SDDTBS, SDTRDC, SDFUN2, SDASN, SDPRGR, SDCLVL, SDCADC, SDKCO, SDDOC, SDDCT, SDODOC, SDODCT, SDOKC, SDPSN, SDDELN, SDTAX1, SDTXA1, SDEXR1, SDATXT, SDPRIO, SDRESL, SDBACK, SDSBAL, SDAPTS, SDLOB, SDEUSE, SDDTYS, SDNTR, SDVEND, SDCARS, SDMOT, SDROUT, SDSTOP, SDZON, SDCNID, SDFRTH, SDSHCM, SDSHCN, SDSERN, SDUOM1, SDPQOR, SDUOM2, SDSQOR, SDUOM4, SDITWT, SDWTUM, SDITVL, SDVLUM, SDRPRC, SDORPR, SDORP, SDCMGP, SDGLC, SDCTRY, SDFY, SDSO01, SDSO02, SDSO03, SDSO04, SDSO05, SDSO06, SDSO07, SDSO08, SDSO09, SDSO10, SDSO11, SDSO12, SDSO13, SDSO14, SDSO15, SDACOM, SDCMCG, SDRCD, SDGRWT, SDGWUM, SDSBL, SDSBLT, SDLCOD, SDUPC1, SDUPC2, SDUPC3, SDSWMS, SDUNCD, SDCRMD, SDCRCD, SDCRR, SDFPRC, SDFUP, SDFEA, SDFUC, SDFEC, SDURCD, SDURDT, SDURAT, SDURAB, SDURRF, SDTORG, SDUSER, SDPID, SDJOBN, SDUPMJ, SDTDAY, SDSO16, SDSO17, SDSO18, SDSO19, SDSO20, SDIR01, SDIR02, SDIR03, SDIR04, SDIR05, SDSOOR, SDVR03, SDDEID, SDPSIG, SDRLNU, SDPMDT, SDRLTM, SDRLDJ, SDDRQT, SDADTM, SDOPTT, SDPDTT, SDPSTM, SDXDCK, SDXPTY, SDDUAL, SDBSC, SDCBSC, SDCORD, SDDVAN, SDPEND, SDRFRV, SDMCLN, SDSHPN, SDRSDT, SDPRJM, SDOSEQ, SDMERL, SDHOLD, SDHDBU, SDDMBU, SDBCRC, SDODLN, SDOPDJ, SDXKCO, SDXORN, SDXCTO, SDXLLN, SDXSFX, SDPOE, SDPMTO, SDANBY, SDPMTN, SDNUMB, SDAAID, SDSPATTN, SDPRAN8, SDPRCIDLN, SDCCIDLN, SDSHCCIDLN, SDOPPID, SDOSTP, SDUKID, SDCATNM, SDALLOC, SDFULPID, SDALLSTS, SDOSCORE, SDOSCOREO, SDCMCO, SDKITID, SDKITAMTDOM, SDKITAMTFOR, SDKITDIRTY, SDOCITT, SDOCCARDNO, SDPMPN, SDPNS FROM F42119

TOP920 | 42 | F42119 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1SDKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
2SDDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
3SDDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
4SDLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
5SDSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
6SDMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
7SDCOCompanyStringGeneric Edit50 Allow NULL? 
8SDOKCODocument Company (Original Order)StringGeneric Edit50 Allow NULL? 
9SDOORNOriginal Order NumberStringGeneric Edit80 Allow NULL? 
10SDOCTOOriginal Order TypeStringUDC (00 DT)20 Allow NULL? 
11SDOGNOOriginal Line NumberNumericGeneric Edit73 Allow NULL? 
12SDRKCOCompany - Key (Related Order)StringGeneric Edit50 Allow NULL? 
13SDRORNRelated PO/SO/WO NumberStringGeneric Edit80 Allow NULL? 
14SDRCTORelated PO/SO/WO Order TypeStringUDC (00 DT)20 Allow NULL? 
15SDRLLNRelated PO/SO Line NumberNumericGeneric Edit73 Allow NULL? 
16SDDMCTAgreement Number - DistributionStringGeneric Edit120 Allow NULL? 
17SDDMCSAgreement Supplement - DistributionNumericGeneric Edit30 Allow NULL? 
18SDAN8Address NumberNumericGeneric Edit80 Allow NULL? 
19SDSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
20SDPA8Address Number - ParentNumericGeneric Edit80 Allow NULL? 
21SDDRQJDate - RequestedDateGeneric Edit60
22SDTRDJDate - Order/TransactionDateGeneric Edit60
23SDPDDJDate - Scheduled PickDateGeneric Edit60
24SDADDJDate - Actual Ship DateDateGeneric Edit60
25SDIVDDate - InvoiceDateGeneric Edit60
26SDCNDJDate - CancelDateGeneric Edit60
27SDDGLDate - For G/L (and Voucher)DateGeneric Edit60
28SDRSDJDate - Promised DeliveryDateGeneric Edit60
29SDPEFJDate - Price Effective DateDateGeneric Edit60
30SDPPDJDate - Promised ShipmentDateGeneric Edit60
31SDVR01ReferenceStringGeneric Edit250 Allow NULL? 
32SDVR02Reference 2StringGeneric Edit250 Allow NULL? 
33SDITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
34SDLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
35SDAITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
36SDLOCNLocationStringGeneric Edit200 Allow NULL? 
37SDLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
38SDFRGDFrom GradeStringUDC (40 LG)30 Allow NULL? 
39SDTHGDThru GradeStringUDC (40 LG)30 Allow NULL? 
40SDFRMPFrom PotencyNumericGeneric Edit73 Allow NULL? 
41SDTHRPThru PotencyNumericGeneric Edit73 Allow NULL? 
42SDEXDPDays Before ExpirationNumericGeneric Edit50 Allow NULL? 
43SDDSC1DescriptionStringGeneric Edit300 Allow NULL? 
44SDDSC2Description - Line 2StringGeneric Edit300 Allow NULL? 
45SDLNTYLine TypeStringGeneric Edit20 Allow NULL? 
46SDNXTRStatus Code - NextStringUDC (40 AT)30 Allow NULL? 
47SDLTTRStatus Code - LastStringUDC (40 AT)30 Allow NULL? 
48SDEMCUBusiness Unit - HeaderStringGeneric Edit120 Allow NULL? 
49SDRLITItem Number - Related (Kit)StringGeneric Edit80 Allow NULL? 
50SDKTLNKit Master Line NumberNumericGeneric Edit63 Allow NULL? 
51SDCPNTComponent Line NumberNumericGeneric Edit41 Allow NULL? 
52SDRKITRelated Kit ComponentNumericGeneric Edit80 Allow NULL? 
53SDKTPNumber of Component Per ParentNumericGeneric Edit150 Allow NULL? 
54SDSRP1Sales Catalog SectionStringUDC (41 S1)30 Allow NULL? 
55SDSRP2Sub SectionStringUDC (41 S2)30 Allow NULL? 
56SDSRP3Sales Category Code 3StringUDC (41 S3)30 Allow NULL? 
57SDSRP4Sales Category Code 4StringUDC (41 S4)30 Allow NULL? 
58SDSRP5Sales Category Code 5StringUDC (41 S5)30 Allow NULL? 
59SDPRP1Commodity ClassStringUDC (41 P1)30 Allow NULL? 
60SDPRP2Commodity Sub ClassStringUDC (41 P2)30 Allow NULL? 
61SDPRP3Supplier Rebate CodeStringUDC (41 P3)30 Allow NULL? 
62SDPRP4Master Planning FamilyStringUDC (41 P4)30 Allow NULL? 
63SDPRP5Purchasing Category Code 5StringUDC (41 P5)30 Allow NULL? 
64SDUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
65SDUORGUnits - Order/Transaction QuantityNumericGeneric Edit150 Allow NULL? 
66SDSOQSQuantity ShippedNumericGeneric Edit150 Allow NULL? 
67SDSOBKUnits - Qty Backordered/HeldNumericGeneric Edit150 Allow NULL? 
68SDSOCNUnits - Quantity Canceled/ScrappedNumericGeneric Edit150 Allow NULL? 
69SDSONEUnits - Future Quantity CommittedNumericGeneric Edit150 Allow NULL? 
70SDUOPNUnits - OpenNumericGeneric Edit150 Allow NULL? 
71SDQTYTUnits - Shipped to DateNumericGeneric Edit150 Allow NULL? 
72SDQRLVUnits - RelievedNumericGeneric Edit150 Allow NULL? 
73SDCOMMCommitted (H/S)CharacterUDC (H42 CP)10 Allow NULL? 
74SDOTQYOther Quantity (1/2)CharacterUDC10 Allow NULL? 
75SDUPRCAmount - Price per UnitNumericGeneric Edit154 Allow NULL? 
76SDAEXPAmount - Extended PriceNumericGeneric Edit152 Allow NULL? 
77SDAOPNAmount - OpenNumericGeneric Edit152 Allow NULL? 
78SDPROVPrice Override CodeCharacterGeneric Edit10 Allow NULL? 
79SDTPCTemporary Price (Y/N)CharacterGeneric Edit10 Allow NULL? 
80SDAPUMUnit of Measure - Entered for Unit PriceStringUDC (00 UM)20 Allow NULL? 
81SDLPRCAmount - List PriceNumericGeneric Edit154 Allow NULL? 
82SDUNCSAmount - Unit CostNumericGeneric Edit154 Allow NULL? 
83SDECSTAmount - Extended CostNumericGeneric Edit152 Allow NULL? 
84SDCSTOCost Override CodeCharacterGeneric Edit10 Allow NULL? 
85SDTCSTExtended Cost - TransferNumericGeneric Edit154 Allow NULL? 
86SDINMGPrint MessageStringUDC (40 PM)100 Allow NULL? 
87SDPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
88SDRYINPayment InstrumentCharacterUDC (00 PY)10 Allow NULL? 
89SDDTBSBased on DateCharacterUDC (42 BD)10 Allow NULL? 
90SDTRDCDiscount - TradeNumericGeneric Edit73 Allow NULL? 
91SDFUN2Trade Discount (Old)NumericGeneric Edit154 Allow NULL? 
92SDASNPrice and Adjustment ScheduleStringUDC (40 AS)80 Allow NULL? 
93SDPRGRItem Price GroupStringUDC (40 PI)80 Allow NULL? 
94SDCLVLPricing Category LevelStringGeneric Edit30 Allow NULL? 
95SDCADCDiscount % - CashNumericGeneric Edit73 Allow NULL? 
96SDKCODocument CompanyStringGeneric Edit50 Allow NULL? 
97SDDOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
98SDDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
99SDODOCDocument - OriginalNumericGeneric Edit80 Allow NULL? 
100SDODCTDocument Type - OriginalStringUDC (00 DT)20 Allow NULL? 
101SDOKCDocument Company - OriginalStringGeneric Edit50 Allow NULL? 
102SDPSNPick Slip NumberNumericGeneric Edit80 Allow NULL? 
103SDDELNDelivery NumberNumericGeneric Edit80 Allow NULL? 
104SDTAX1Sales Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
105SDTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
106SDEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
107SDATXTAssociated TextCharacterGeneric Edit10 Allow NULL? 
108SDPRIOPriority - ProcessingCharacterUDC (H40 PR)10 Allow NULL? 
109SDRESLPrinted CodeCharacterGeneric Edit10 Allow NULL? 
110SDBACKBackorders Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
111SDSBALSubstitutes Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
112SDAPTSPartial Line Shipments Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
113SDLOBLine of BusinessStringUDC (40 LB)30 Allow NULL? 
114SDEUSEEnd UseStringUDC (40 EU)30 Allow NULL? 
115SDDTYSDuty StatusStringUDC (40 DS)20 Allow NULL? 
116SDNTRNature of TransactionStringUDC (00 NT)20 Allow NULL? 
117SDVENDPrimary / Last Supplier NumberNumericGeneric Edit80 Allow NULL? 
118SDCARSCarrier NumberNumericGeneric Edit80 Allow NULL? 
119SDMOTMode of TransportStringUDC (00 TM)30 Allow NULL? 
120SDROUTRoute CodeStringUDC (42 RT)30 Allow NULL? 
121SDSTOPStop CodeStringUDC (42 SP)30 Allow NULL? 
122SDZONZone NumberStringUDC (40 ZN)30 Allow NULL? 
123SDCNIDContainer I.D.StringGeneric Edit200 Allow NULL? 
124SDFRTHFreight Handling CodeStringUDC (42 FR)30 Allow NULL? 
125SDSHCMShipping Commodity ClassStringUDC (41 E)30 Allow NULL? 
126SDSHCNShipping Conditions CodeStringUDC (41 C)30 Allow NULL? 
127SDSERNSerial Number - LotStringGeneric Edit300 Allow NULL? 
128SDUOM1Unit of Measure - PrimaryStringUDC (00 UM)20 Allow NULL? 
129SDPQORUnits - Primary Quantity OrderedNumericGeneric Edit150 Allow NULL? 
130SDUOM2Unit of Measure - SecondaryStringUDC (00 UM)20 Allow NULL? 
131SDSQORUnits - Secondary Quantity OrderedNumericGeneric Edit150 Allow NULL? 
132SDUOM4Unit of Measure - PricingStringUDC (00 UM)20 Allow NULL? 
133SDITWTUnit WeightNumericGeneric Edit154 Allow NULL? 
134SDWTUMWeight Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
135SDITVLUnit VolumeNumericGeneric Edit154 Allow NULL? 
136SDVLUMVolume Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
137SDRPRCReprice (Basket Price) CategoryStringUDC (40 PI)80 Allow NULL? 
138SDORPROrder Reprice CategoryStringUDC (40 PI)80 Allow NULL? 
139SDORPOrder Repriced IndicatorCharacterGeneric Edit10 Allow NULL? 
140SDCMGPCosting Method - InventoryStringGeneric Edit20 Allow NULL? 
141SDGLCG/L OffsetStringGeneric Edit40 Allow NULL? 
142SDCTRYCenturyNumericGeneric Edit20 Allow NULL? 
143SDFYFiscal YearNumericGeneric Edit20 Allow NULL? 
144SDSO01Inter Branch SalesCharacterGeneric Edit10 Allow NULL? 
145SDSO02On Hand UpdatedCharacterGeneric Edit10 Allow NULL? 
146SDSO03Configurator Print FlagCharacterGeneric Edit10 Allow NULL? 
147SDSO04Sales Order Status 04CharacterGeneric Edit10 Allow NULL? 
148SDSO05Substitute Item IndicatorCharacterGeneric Edit10 Allow NULL? 
149SDSO06Preference Commitment IndicatorCharacterGeneric Edit10 Allow NULL? 
150SDSO07Ship date (PDDJ) overriddenCharacterGeneric Edit10 Allow NULL? 
151SDSO08Price Adjustment Line IndicatorCharacterGeneric Edit10 Allow NULL? 
152SDSO09Price Adj. History IndicatorCharacterGeneric Edit10 Allow NULL? 
153SDSO10Preference Production AllocationCharacterGeneric Edit10 Allow NULL? 
154SDSO11Transfer/Direct Ship/Intercompany FlagCharacterGeneric Edit10 Allow NULL? 
155SDSO12Deferred entries flagCharacterGeneric Edit10 Allow NULL? 
156SDSO13Euro Conversion Status FlagCharacterGeneric Edit10 Allow NULL? 
157SDSO14Sales Order Status 14CharacterGeneric Edit10 Allow NULL? 
158SDSO15Sales Order Status 15CharacterGeneric Edit10 Allow NULL? 
159SDACOMApply Commission (Y/N)CharacterGeneric Edit10 Allow NULL? 
160SDCMCGCommission CategoryStringGeneric Edit80 Allow NULL? 
161SDRCDReason CodeStringUDC (42 RC)30 Allow NULL? 
162SDGRWTGross WeightNumericGeneric Edit154 Allow NULL? 
163SDGWUMGross Weight Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
164SDSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
165SDSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
166SDLCODCode - Location Tax StatusStringUDC (46 LT)20 Allow NULL? 
167SDUPC1Price Code 1StringUDC (40 P1)20 Allow NULL? 
168SDUPC2Price Code 2StringUDC (40 P2)20 Allow NULL? 
169SDUPC3Price Code 3StringUDC (40 P3)20 Allow NULL? 
170SDSWMSStatus - In WarehouseCharacterGeneric Edit10 Allow NULL? 
171SDUNCDWork Order Freeze CodeCharacterUDC (H00 UN)10 Allow NULL? 
172SDCRMDSend MethodCharacterUDC (00 SM)10 Allow NULL? 
173SDCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
174SDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
175SDFPRCAmount - List Price per UnitNumericGeneric Edit154 Allow NULL? 
176SDFUPAmount - Foreign Price per UnitNumericGeneric Edit154 Allow NULL? 
177SDFEAAmount - Foreign Extended PriceNumericGeneric Edit152 Allow NULL? 
178SDFUCAmount - Foreign Unit CostNumericGeneric Edit154 Allow NULL? 
179SDFECAmount - Foreign Extended CostNumericGeneric Edit152 Allow NULL? 
180SDURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
181SDURDTUser Reserved DateDateGeneric Edit60
182SDURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
183SDURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
184SDURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
185SDTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
186SDUSERUser IDStringGeneric Edit100 Allow NULL? 
187SDPIDProgram IDStringGeneric Edit100 Allow NULL? 
188SDJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
189SDUPMJDate - UpdatedDateGeneric Edit60
190SDTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
191SDSO16Manufacturing Variance Accounting FlagCharacterGeneric Edit10 Allow NULL? 
192SDSO17Sales Order Status 17CharacterGeneric Edit10 Allow NULL? 
193SDSO18Sales Order Status 18CharacterGeneric Edit10 Allow NULL? 
194SDSO19Sales Order Status 19CharacterGeneric Edit10 Allow NULL? 
195SDSO20Sales Order Status 20CharacterGeneric Edit10 Allow NULL? 
196SDIR01Integration Reference 01StringGeneric Edit300 Allow NULL? 
197SDIR02Integration Reference 02StringGeneric Edit300 Allow NULL? 
198SDIR03Integration Reference 03StringGeneric Edit300 Allow NULL? 
199SDIR04Integration Reference 04StringGeneric Edit300 Allow NULL? 
200SDIR05Integration Reference 05StringGeneric Edit300 Allow NULL? 
201SDSOORSource of OrderIntegerGeneric Edit110 Allow NULL? 
202SDVR03ReferenceStringGeneric Edit250 Allow NULL? 
203SDDEIDDemand Unique Key IDNumericGeneric Edit150 Allow NULL? 
204SDPSIGPull SignalStringGeneric Edit300 Allow NULL? 
205SDRLNURelease NumberStringGeneric Edit100 Allow NULL? 
206SDPMDTScheduled Shipment TimeNumericGeneric Edit60 Allow NULL? 
207SDRLTMTime - ReleaseNumericGeneric Edit60 Allow NULL? 
208SDRLDJDate - ReleaseDateGeneric Edit60
209SDDRQTRequested Delivery TimeNumericGeneric Edit60 Allow NULL? 
210SDADTMActual Shipment TimeNumericGeneric Edit60 Allow NULL? 
211SDOPTTTime - Original Promised DeliveryNumericGeneric Edit60 Allow NULL? 
212SDPDTTTime - Scheduled PickNumericGeneric Edit60 Allow NULL? 
213SDPSTMTime - Future Time 2NumericGeneric Edit60 Allow NULL? 
214SDXDCKCross-Docking FlagCharacterGeneric Edit10 Allow NULL? 
215SDXPTYCross Docking Priority for Sales OrdersNumericGeneric Edit150 Allow NULL? 
216SDDUALDual Unit Of Measure ItemCharacterGeneric Edit10 Allow NULL? 
217SDBSCBuying Segment CodeStringUDC (42B BS)100 Allow NULL? 
218SDCBSCCurrent Buying Segment CodeStringUDC (42B BS)100 Allow NULL? 
219SDCORDChange Order NumberNumericGeneric Edit30 Allow NULL? 
220SDDVANAddress Number - Deliver ToNumericGeneric Edit80 Allow NULL? 
221SDPENDPending Approval FlagCharacterGeneric Edit10 Allow NULL? 
222SDRFRVRevision ReasonStringUDC (42 RR)30 Allow NULL? 
223SDMCLNMatrix Control Line NumberNumericGeneric Edit63 Allow NULL? 
224SDSHPNShipment NumberNumericGeneric Edit80 Allow NULL? 
225SDRSDTPromised Delivery TimeNumericGeneric Edit60 Allow NULL? 
226SDPRJMProject NumberNumericGeneric Edit80 Allow NULL? 
227SDOSEQSequence NumberNumericGeneric Edit40 Allow NULL? 
228SDMERLItem Revision LevelStringGeneric Edit30 Allow NULL? 
229SDHOLDHold Orders CodeStringUDC (42 HC)20 Allow NULL? 
230SDHDBUBusiness Unit - HeaderStringGeneric Edit120 Allow NULL? 
231SDDMBUBusiness Unit - DemandStringGeneric Edit120 Allow NULL? 
232SDBCRCCurrency Code - BaseStringGeneric Edit30 Allow NULL? 
233SDODLNDocument Line Number - OriginalNumericGeneric Edit73 Allow NULL? 
234SDOPDJDate - Original Promised DeliveryDateGeneric Edit60
235SDXKCOCross Dock Order Company (Order Number)StringGeneric Edit50 Allow NULL? 
236SDXORNCross Dock Order NoNumericGeneric Edit80 Allow NULL? 
237SDXCTOCross Dock Order TypeStringUDC (00 DT)20 Allow NULL? 
238SDXLLNCross Dock Line NumberNumericGeneric Edit63 Allow NULL? 
239SDXSFXCross Dock Order SuffixStringGeneric Edit30 Allow NULL? 
240SDPOEPort of Entry or ExitStringUDC (40 PE)60 Allow NULL? 
241SDPMTOPayment Terms Override CodeCharacterGeneric Edit10 Allow NULL? 
242SDANBYBuyer NumberNumericGeneric Edit80 Allow NULL? 
243SDPMTNPromotion IDStringGeneric Edit120 Allow NULL? 
244SDNUMBAsset Item NumberNumericGeneric Edit80 Allow NULL? 
245SDAAIDParent NumberNumericGeneric Edit80 Allow NULL? 
246SDSPATTNShip To AttentionStringGeneric Edit500 Allow NULL? 
247SDPRAN8Partner Address NumberNumericGeneric Edit80 Allow NULL? 
248SDPRCIDLNPartner Contact Line Number IDNumericGeneric Edit50 Allow NULL? 
249SDCCIDLNCustomer Contact Line Number IDNumericGeneric Edit50 Allow NULL? 
250SDSHCCIDLNShip To Cust Contact Line Num IDNumericGeneric Edit50 Allow NULL? 
251SDOPPIDOpportunity NumberNumericGeneric Edit150 Allow NULL? 
252SDOSTPOrganization Structure TypeStringUDC (01 TS)30 Allow NULL? 
253SDUKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
254SDCATNMCatalog NameStringGeneric Edit300 Allow NULL? 
255SDALLOCAllocation Process FlagCharacterGeneric Edit10 Allow NULL? 
256SDFULPIDFulfillment Plan IDIntegerGeneric Edit110 Allow NULL? 
257SDALLSTSAllocation Status NumberStringUDC (42 AS)300 Allow NULL? 
258SDOSCORESales Order ScoreNumericGeneric Edit153 Allow NULL? 
259SDOSCOREOOrder Score OverrideCharacterGeneric Edit10 Allow NULL? 
260SDCMCOCustomer Master CompanyStringGeneric Edit50 Allow NULL? 
261SDKITIDKit IdentifierNumericGeneric Edit150 Allow NULL? 
262SDKITAMTDOMAccumulated Amount Invoiced (Domestic)NumericGeneric Edit152 Allow NULL? 
263SDKITAMTFORAccumulated Amount Invoiced (Foreign)NumericGeneric Edit152 Allow NULL? 
264SDKITDIRTYKit Component Dirty FlagCharacterGeneric Edit10 Allow NULL? 
265SDOCITTOC In-Transit FlagCharacterGeneric Edit10 Allow NULL? 
266SDOCCARDNOOC Kanban Card NoNumericGeneric Edit80 Allow NULL? 
267SDPMPNProduction NumberStringGeneric Edit300 Allow NULL? 
268SDPNSProduction Number ShortNumericGeneric Edit100 Allow NULL? 

TOP920 | 42 | F42119 INDEXES

NumberDescription
1Order Num Order Type (Primary/Unique)
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4LNIDLine NumberAscending
2Item Branch +D
ElementAliasDescriptionSequence
1ITMItem Number - ShortAscending
2MCUBusiness UnitAscending
3DRQJDate - RequestedAscending
3OrderType NextStatus +B
ElementAliasDescriptionSequence
1DCTOOrder TypeAscending
2NXTRStatus Code - NextAscending
3LNTYLine TypeAscending
4OriginalOrderNo Type Co
ElementAliasDescriptionSequence
1OORNOriginal Order NumberAscending
2OCTOOriginal Order TypeAscending
3OKCODocument Company (Original Order)Ascending
8AddressNumber
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2TRDJDate - Order/TransactionAscending
9ShipTo
ElementAliasDescriptionSequence
1SHANAddress Number - Ship ToAscending
10Order Num Variance
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2SO16Manufacturing Variance Accounting FlagAscending
11Order Num Type Co KitID
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4KITIDKit IdentifierAscending
5LNIDLine NumberAscending
12Short Item Trans Date SoldTo
ElementAliasDescriptionSequence
1TRDJDate - Order/TransactionAscending
2AN8Address NumberAscending
3ITMItem Number - ShortAscending
4UPRCAmount - Price per UnitAscending
5UNCSAmount - Unit CostAscending
6AEXPAmount - Extended PriceAscending
7ECSTAmount - Extended CostAscending
8DOCODocument (Order No Invoice etc.)Ascending
9MCUBusiness UnitAscending
10UOM4Unit of Measure - PricingAscending
11CMCOCustomer Master CompanyAscending
12KCOOOrder Company (Order Number)Ascending
13KTLNKit Master Line NumberAscending
14UORGUnits - Order/Transaction QuantityAscending
15LTTRStatus Code - LastAscending
16DCTOOrder TypeAscending