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

268 COLUMNS | 2 INDEXES | Print definition?920 | 42 | F42199 TABLE

42: Sales Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F42199SL2682S.O. Detail Ledger FileHistory Files42: Sales Management
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 SLKCOO, SLDOCO, SLDCTO, SLLNID, SLSFXO, SLMCU, SLCO, SLOKCO, SLOORN, SLOCTO, SLOGNO, SLRKCO, SLRORN, SLRCTO, SLRLLN, SLDMCT, SLDMCS, SLAN8, SLSHAN, SLPA8, SLDRQJ, SLTRDJ, SLPDDJ, SLADDJ, SLIVD, SLCNDJ, SLDGL, SLRSDJ, SLPEFJ, SLPPDJ, SLVR01, SLVR02, SLITM, SLLITM, SLAITM, SLLOCN, SLLOTN, SLFRGD, SLTHGD, SLFRMP, SLTHRP, SLEXDP, SLDSC1, SLDSC2, SLLNTY, SLNXTR, SLLTTR, SLEMCU, SLRLIT, SLKTLN, SLCPNT, SLRKIT, SLKTP, SLSRP1, SLSRP2, SLSRP3, SLSRP4, SLSRP5, SLPRP1, SLPRP2, SLPRP3, SLPRP4, SLPRP5, SLUOM, SLUORG, SLSOQS, SLSOBK, SLSOCN, SLSONE, SLUOPN, SLQTYT, SLQRLV, SLCOMM, SLOTQY, SLUPRC, SLAEXP, SLAOPN, SLPROV, SLTPC, SLAPUM, SLLPRC, SLUNCS, SLECST, SLCSTO, SLTCST, SLINMG, SLPTC, SLRYIN, SLDTBS, SLTRDC, SLFUN2, SLASN, SLPRGR, SLCLVL, SLCADC, SLKCO, SLDOC, SLDCT, SLODOC, SLODCT, SLOKC, SLPSN, SLDELN, SLTAX1, SLTXA1, SLEXR1, SLATXT, SLPRIO, SLRESL, SLBACK, SLSBAL, SLAPTS, SLLOB, SLEUSE, SLDTYS, SLNTR, SLVEND, SLCARS, SLMOT, SLROUT, SLSTOP, SLZON, SLCNID, SLFRTH, SLSHCM, SLSHCN, SLSERN, SLUOM1, SLPQOR, SLUOM2, SLSQOR, SLUOM4, SLITWT, SLWTUM, SLITVL, SLVLUM, SLRPRC, SLORPR, SLORP, SLCMGP, SLGLC, SLCTRY, SLFY, SLSO01, SLSO02, SLSO03, SLSO04, SLSO05, SLSO06, SLSO07, SLSO08, SLSO09, SLSO10, SLSO11, SLSO12, SLSO13, SLSO14, SLSO15, SLACOM, SLCMCG, SLRCD, SLGRWT, SLGWUM, SLSBL, SLSBLT, SLLCOD, SLUPC1, SLUPC2, SLUPC3, SLSWMS, SLUNCD, SLCRMD, SLCRCD, SLCRR, SLFPRC, SLFUP, SLFEA, SLFUC, SLFEC, SLURCD, SLURDT, SLURAT, SLURAB, SLURRF, SLTORG, SLUSER, SLPID, SLJOBN, SLUPMJ, SLTDAY, SLSO16, SLSO17, SLSO18, SLSO19, SLSO20, SLIR01, SLIR02, SLIR03, SLIR04, SLIR05, SLSOOR, SLVR03, SLDEID, SLPSIG, SLRLNU, SLPMDT, SLRLTM, SLRLDJ, SLDRQT, SLADTM, SLOPTT, SLPDTT, SLPSTM, SLXDCK, SLXPTY, SLDUAL, SLBSC, SLCBSC, SLCORD, SLDVAN, SLPEND, SLRFRV, SLMCLN, SLSHPN, SLRSDT, SLPRJM, SLOSEQ, SLMERL, SLHOLD, SLHDBU, SLDMBU, SLBCRC, SLODLN, SLOPDJ, SLXKCO, SLXORN, SLXCTO, SLXLLN, SLXSFX, SLPOE, SLPMTO, SLANBY, SLPMTN, SLNUMB, SLAAID, SLPRAN8, SLSPATTN, SLPRCIDLN, SLCCIDLN, SLSHCCIDLN, SLOPPID, SLOSTP, SLUKID, SLCATNM, SLALLOC, SLFULPID, SLALLSTS, SLOSCORE, SLOSCOREO, SLCMCO, SLKITID, SLKITAMTDOM, SLKITAMTFOR, SLKITDIRTY, SLOCITT, SLOCCARDNO, SLPMPN, SLPNS FROM F42199

TOP920 | 42 | F42199 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1SLKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
2SLDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
3SLDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
4SLLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
5SLSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
6SLMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
7SLCOCompanyStringGeneric Edit50 Allow NULL? 
8SLOKCODocument Company (Original Order)StringGeneric Edit50 Allow NULL? 
9SLOORNOriginal Order NumberStringGeneric Edit80 Allow NULL? 
10SLOCTOOriginal Order TypeStringUDC (00 DT)20 Allow NULL? 
11SLOGNOOriginal Line NumberNumericGeneric Edit73 Allow NULL? 
12SLRKCOCompany - Key (Related Order)StringGeneric Edit50 Allow NULL? 
13SLRORNRelated PO/SO/WO NumberStringGeneric Edit80 Allow NULL? 
14SLRCTORelated PO/SO/WO Order TypeStringUDC (00 DT)20 Allow NULL? 
15SLRLLNRelated PO/SO Line NumberNumericGeneric Edit73 Allow NULL? 
16SLDMCTAgreement Number - DistributionStringGeneric Edit120 Allow NULL? 
17SLDMCSAgreement Supplement - DistributionNumericGeneric Edit30 Allow NULL? 
18SLAN8Address NumberNumericGeneric Edit80 Allow NULL? 
19SLSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
20SLPA8Address Number - ParentNumericGeneric Edit80 Allow NULL? 
21SLDRQJDate - RequestedDateGeneric Edit60
22SLTRDJDate - Order/TransactionDateGeneric Edit60
23SLPDDJDate - Scheduled PickDateGeneric Edit60
24SLADDJDate - Actual Ship DateDateGeneric Edit60
25SLIVDDate - InvoiceDateGeneric Edit60
26SLCNDJDate - CancelDateGeneric Edit60
27SLDGLDate - For G/L (and Voucher)DateGeneric Edit60
28SLRSDJDate - Promised DeliveryDateGeneric Edit60
29SLPEFJDate - Price Effective DateDateGeneric Edit60
30SLPPDJDate - Promised ShipmentDateGeneric Edit60
31SLVR01ReferenceStringGeneric Edit250 Allow NULL? 
32SLVR02Reference 2StringGeneric Edit250 Allow NULL? 
33SLITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
34SLLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
35SLAITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
36SLLOCNLocationStringGeneric Edit200 Allow NULL? 
37SLLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
38SLFRGDFrom GradeStringUDC (40 LG)30 Allow NULL? 
39SLTHGDThru GradeStringUDC (40 LG)30 Allow NULL? 
40SLFRMPFrom PotencyNumericGeneric Edit73 Allow NULL? 
41SLTHRPThru PotencyNumericGeneric Edit73 Allow NULL? 
42SLEXDPDays Before ExpirationNumericGeneric Edit50 Allow NULL? 
43SLDSC1DescriptionStringGeneric Edit300 Allow NULL? 
44SLDSC2Description - Line 2StringGeneric Edit300 Allow NULL? 
45SLLNTYLine TypeStringGeneric Edit20 Allow NULL? 
46SLNXTRStatus Code - NextStringUDC (40 AT)30 Allow NULL? 
47SLLTTRStatus Code - LastStringUDC (40 AT)30 Allow NULL? 
48SLEMCUBusiness Unit - HeaderStringGeneric Edit120 Allow NULL? 
49SLRLITItem Number - Related (Kit)StringGeneric Edit80 Allow NULL? 
50SLKTLNKit Master Line NumberNumericGeneric Edit63 Allow NULL? 
51SLCPNTComponent Line NumberNumericGeneric Edit41 Allow NULL? 
52SLRKITRelated Kit ComponentNumericGeneric Edit80 Allow NULL? 
53SLKTPNumber of Component Per ParentNumericGeneric Edit150 Allow NULL? 
54SLSRP1Sales Catalog SectionStringUDC (41 S1)30 Allow NULL? 
55SLSRP2Sub SectionStringUDC (41 S2)30 Allow NULL? 
56SLSRP3Sales Category Code 3StringUDC (41 S3)30 Allow NULL? 
57SLSRP4Sales Category Code 4StringUDC (41 S4)30 Allow NULL? 
58SLSRP5Sales Category Code 5StringUDC (41 S5)30 Allow NULL? 
59SLPRP1Commodity ClassStringUDC (41 P1)30 Allow NULL? 
60SLPRP2Commodity Sub ClassStringUDC (41 P2)30 Allow NULL? 
61SLPRP3Supplier Rebate CodeStringUDC (41 P3)30 Allow NULL? 
62SLPRP4Master Planning FamilyStringUDC (41 P4)30 Allow NULL? 
63SLPRP5Purchasing Category Code 5StringUDC (41 P5)30 Allow NULL? 
64SLUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
65SLUORGUnits - Order/Transaction QuantityNumericGeneric Edit150 Allow NULL? 
66SLSOQSQuantity ShippedNumericGeneric Edit150 Allow NULL? 
67SLSOBKUnits - Qty Backordered/HeldNumericGeneric Edit150 Allow NULL? 
68SLSOCNUnits - Quantity Canceled/ScrappedNumericGeneric Edit150 Allow NULL? 
69SLSONEUnits - Future Quantity CommittedNumericGeneric Edit150 Allow NULL? 
70SLUOPNUnits - OpenNumericGeneric Edit150 Allow NULL? 
71SLQTYTUnits - Shipped to DateNumericGeneric Edit150 Allow NULL? 
72SLQRLVUnits - RelievedNumericGeneric Edit150 Allow NULL? 
73SLCOMMCommitted (H/S)CharacterUDC (H42 CP)10 Allow NULL? 
74SLOTQYOther Quantity (1/2)CharacterUDC10 Allow NULL? 
75SLUPRCAmount - Price per UnitNumericGeneric Edit154 Allow NULL? 
76SLAEXPAmount - Extended PriceNumericGeneric Edit152 Allow NULL? 
77SLAOPNAmount - OpenNumericGeneric Edit152 Allow NULL? 
78SLPROVPrice Override CodeCharacterGeneric Edit10 Allow NULL? 
79SLTPCTemporary Price (Y/N)CharacterGeneric Edit10 Allow NULL? 
80SLAPUMUnit of Measure - Entered for Unit PriceStringUDC (00 UM)20 Allow NULL? 
81SLLPRCAmount - List PriceNumericGeneric Edit154 Allow NULL? 
82SLUNCSAmount - Unit CostNumericGeneric Edit154 Allow NULL? 
83SLECSTAmount - Extended CostNumericGeneric Edit152 Allow NULL? 
84SLCSTOCost Override CodeCharacterGeneric Edit10 Allow NULL? 
85SLTCSTExtended Cost - TransferNumericGeneric Edit154 Allow NULL? 
86SLINMGPrint MessageStringUDC (40 PM)100 Allow NULL? 
87SLPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
88SLRYINPayment InstrumentCharacterUDC (00 PY)10 Allow NULL? 
89SLDTBSBased on DateCharacterUDC (42 BD)10 Allow NULL? 
90SLTRDCDiscount - TradeNumericGeneric Edit73 Allow NULL? 
91SLFUN2Trade Discount (Old)NumericGeneric Edit154 Allow NULL? 
92SLASNPrice and Adjustment ScheduleStringUDC (40 AS)80 Allow NULL? 
93SLPRGRItem Price GroupStringUDC (40 PI)80 Allow NULL? 
94SLCLVLPricing Category LevelStringGeneric Edit30 Allow NULL? 
95SLCADCDiscount % - CashNumericGeneric Edit73 Allow NULL? 
96SLKCODocument CompanyStringGeneric Edit50 Allow NULL? 
97SLDOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
98SLDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
99SLODOCDocument - OriginalNumericGeneric Edit80 Allow NULL? 
100SLODCTDocument Type - OriginalStringUDC (00 DT)20 Allow NULL? 
101SLOKCDocument Company - OriginalStringGeneric Edit50 Allow NULL? 
102SLPSNPick Slip NumberNumericGeneric Edit80 Allow NULL? 
103SLDELNDelivery NumberNumericGeneric Edit80 Allow NULL? 
104SLTAX1Sales Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
105SLTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
106SLEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
107SLATXTAssociated TextCharacterGeneric Edit10 Allow NULL? 
108SLPRIOPriority - ProcessingCharacterUDC (H40 PR)10 Allow NULL? 
109SLRESLPrinted CodeCharacterGeneric Edit10 Allow NULL? 
110SLBACKBackorders Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
111SLSBALSubstitutes Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
112SLAPTSPartial Line Shipments Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
113SLLOBLine of BusinessStringUDC (40 LB)30 Allow NULL? 
114SLEUSEEnd UseStringUDC (40 EU)30 Allow NULL? 
115SLDTYSDuty StatusStringUDC (40 DS)20 Allow NULL? 
116SLNTRNature of TransactionStringUDC (00 NT)20 Allow NULL? 
117SLVENDPrimary / Last Supplier NumberNumericGeneric Edit80 Allow NULL? 
118SLCARSCarrier NumberNumericGeneric Edit80 Allow NULL? 
119SLMOTMode of TransportStringUDC (00 TM)30 Allow NULL? 
120SLROUTRoute CodeStringUDC (42 RT)30 Allow NULL? 
121SLSTOPStop CodeStringUDC (42 SP)30 Allow NULL? 
122SLZONZone NumberStringUDC (40 ZN)30 Allow NULL? 
123SLCNIDContainer I.D.StringGeneric Edit200 Allow NULL? 
124SLFRTHFreight Handling CodeStringUDC (42 FR)30 Allow NULL? 
125SLSHCMShipping Commodity ClassStringUDC (41 E)30 Allow NULL? 
126SLSHCNShipping Conditions CodeStringUDC (41 C)30 Allow NULL? 
127SLSERNSerial Number - LotStringGeneric Edit300 Allow NULL? 
128SLUOM1Unit of Measure - PrimaryStringUDC (00 UM)20 Allow NULL? 
129SLPQORUnits - Primary Quantity OrderedNumericGeneric Edit150 Allow NULL? 
130SLUOM2Unit of Measure - SecondaryStringUDC (00 UM)20 Allow NULL? 
131SLSQORUnits - Secondary Quantity OrderedNumericGeneric Edit150 Allow NULL? 
132SLUOM4Unit of Measure - PricingStringUDC (00 UM)20 Allow NULL? 
133SLITWTUnit WeightNumericGeneric Edit154 Allow NULL? 
134SLWTUMWeight Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
135SLITVLUnit VolumeNumericGeneric Edit154 Allow NULL? 
136SLVLUMVolume Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
137SLRPRCReprice (Basket Price) CategoryStringUDC (40 PI)80 Allow NULL? 
138SLORPROrder Reprice CategoryStringUDC (40 PI)80 Allow NULL? 
139SLORPOrder Repriced IndicatorCharacterGeneric Edit10 Allow NULL? 
140SLCMGPCosting Method - InventoryStringGeneric Edit20 Allow NULL? 
141SLGLCG/L OffsetStringGeneric Edit40 Allow NULL? 
142SLCTRYCenturyNumericGeneric Edit20 Allow NULL? 
143SLFYFiscal YearNumericGeneric Edit20 Allow NULL? 
144SLSO01Inter Branch SalesCharacterGeneric Edit10 Allow NULL? 
145SLSO02On Hand UpdatedCharacterGeneric Edit10 Allow NULL? 
146SLSO03Configurator Print FlagCharacterGeneric Edit10 Allow NULL? 
147SLSO04Sales Order Status 04CharacterGeneric Edit10 Allow NULL? 
148SLSO05Substitute Item IndicatorCharacterGeneric Edit10 Allow NULL? 
149SLSO06Preference Commitment IndicatorCharacterGeneric Edit10 Allow NULL? 
150SLSO07Ship date (PDDJ) overriddenCharacterGeneric Edit10 Allow NULL? 
151SLSO08Price Adjustment Line IndicatorCharacterGeneric Edit10 Allow NULL? 
152SLSO09Price Adj. History IndicatorCharacterGeneric Edit10 Allow NULL? 
153SLSO10Preference Production AllocationCharacterGeneric Edit10 Allow NULL? 
154SLSO11Transfer/Direct Ship/Intercompany FlagCharacterGeneric Edit10 Allow NULL? 
155SLSO12Deferred entries flagCharacterGeneric Edit10 Allow NULL? 
156SLSO13Euro Conversion Status FlagCharacterGeneric Edit10 Allow NULL? 
157SLSO14Sales Order Status 14CharacterGeneric Edit10 Allow NULL? 
158SLSO15Sales Order Status 15CharacterGeneric Edit10 Allow NULL? 
159SLACOMApply Commission (Y/N)CharacterGeneric Edit10 Allow NULL? 
160SLCMCGCommission CategoryStringGeneric Edit80 Allow NULL? 
161SLRCDReason CodeStringUDC (42 RC)30 Allow NULL? 
162SLGRWTGross WeightNumericGeneric Edit154 Allow NULL? 
163SLGWUMGross Weight Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
164SLSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
165SLSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
166SLLCODCode - Location Tax StatusStringUDC (46 LT)20 Allow NULL? 
167SLUPC1Price Code 1StringUDC (40 P1)20 Allow NULL? 
168SLUPC2Price Code 2StringUDC (40 P2)20 Allow NULL? 
169SLUPC3Price Code 3StringUDC (40 P3)20 Allow NULL? 
170SLSWMSStatus - In WarehouseCharacterGeneric Edit10 Allow NULL? 
171SLUNCDWork Order Freeze CodeCharacterUDC (H00 UN)10 Allow NULL? 
172SLCRMDSend MethodCharacterUDC (00 SM)10 Allow NULL? 
173SLCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
174SLCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
175SLFPRCAmount - List Price per UnitNumericGeneric Edit154 Allow NULL? 
176SLFUPAmount - Foreign Price per UnitNumericGeneric Edit154 Allow NULL? 
177SLFEAAmount - Foreign Extended PriceNumericGeneric Edit152 Allow NULL? 
178SLFUCAmount - Foreign Unit CostNumericGeneric Edit154 Allow NULL? 
179SLFECAmount - Foreign Extended CostNumericGeneric Edit152 Allow NULL? 
180SLURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
181SLURDTUser Reserved DateDateGeneric Edit60
182SLURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
183SLURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
184SLURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
185SLTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
186SLUSERUser IDStringGeneric Edit100 Allow NULL? 
187SLPIDProgram IDStringGeneric Edit100 Allow NULL? 
188SLJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
189SLUPMJDate - UpdatedDateGeneric Edit60
190SLTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
191SLSO16Manufacturing Variance Accounting FlagCharacterGeneric Edit10 Allow NULL? 
192SLSO17Sales Order Status 17CharacterGeneric Edit10 Allow NULL? 
193SLSO18Sales Order Status 18CharacterGeneric Edit10 Allow NULL? 
194SLSO19Sales Order Status 19CharacterGeneric Edit10 Allow NULL? 
195SLSO20Sales Order Status 20CharacterGeneric Edit10 Allow NULL? 
196SLIR01Integration Reference 01StringGeneric Edit300 Allow NULL? 
197SLIR02Integration Reference 02StringGeneric Edit300 Allow NULL? 
198SLIR03Integration Reference 03StringGeneric Edit300 Allow NULL? 
199SLIR04Integration Reference 04StringGeneric Edit300 Allow NULL? 
200SLIR05Integration Reference 05StringGeneric Edit300 Allow NULL? 
201SLSOORSource of OrderIntegerGeneric Edit110 Allow NULL? 
202SLVR03ReferenceStringGeneric Edit250 Allow NULL? 
203SLDEIDDemand Unique Key IDNumericGeneric Edit150 Allow NULL? 
204SLPSIGPull SignalStringGeneric Edit300 Allow NULL? 
205SLRLNURelease NumberStringGeneric Edit100 Allow NULL? 
206SLPMDTScheduled Shipment TimeNumericGeneric Edit60 Allow NULL? 
207SLRLTMTime - ReleaseNumericGeneric Edit60 Allow NULL? 
208SLRLDJDate - ReleaseDateGeneric Edit60
209SLDRQTRequested Delivery TimeNumericGeneric Edit60 Allow NULL? 
210SLADTMActual Shipment TimeNumericGeneric Edit60 Allow NULL? 
211SLOPTTTime - Original Promised DeliveryNumericGeneric Edit60 Allow NULL? 
212SLPDTTTime - Scheduled PickNumericGeneric Edit60 Allow NULL? 
213SLPSTMTime - Future Time 2NumericGeneric Edit60 Allow NULL? 
214SLXDCKCross-Docking FlagCharacterGeneric Edit10 Allow NULL? 
215SLXPTYCross Docking Priority for Sales OrdersNumericGeneric Edit150 Allow NULL? 
216SLDUALDual Unit Of Measure ItemCharacterGeneric Edit10 Allow NULL? 
217SLBSCBuying Segment CodeStringUDC (42B BS)100 Allow NULL? 
218SLCBSCCurrent Buying Segment CodeStringUDC (42B BS)100 Allow NULL? 
219SLCORDChange Order NumberNumericGeneric Edit30 Allow NULL? 
220SLDVANAddress Number - Deliver ToNumericGeneric Edit80 Allow NULL? 
221SLPENDPending Approval FlagCharacterGeneric Edit10 Allow NULL? 
222SLRFRVRevision ReasonStringUDC (42 RR)30 Allow NULL? 
223SLMCLNMatrix Control Line NumberNumericGeneric Edit63 Allow NULL? 
224SLSHPNShipment NumberNumericGeneric Edit80 Allow NULL? 
225SLRSDTPromised Delivery TimeNumericGeneric Edit60 Allow NULL? 
226SLPRJMProject NumberNumericGeneric Edit80 Allow NULL? 
227SLOSEQSequence NumberNumericGeneric Edit40 Allow NULL? 
228SLMERLItem Revision LevelStringGeneric Edit30 Allow NULL? 
229SLHOLDHold Orders CodeStringUDC (42 HC)20 Allow NULL? 
230SLHDBUBusiness Unit - HeaderStringGeneric Edit120 Allow NULL? 
231SLDMBUBusiness Unit - DemandStringGeneric Edit120 Allow NULL? 
232SLBCRCCurrency Code - BaseStringGeneric Edit30 Allow NULL? 
233SLODLNDocument Line Number - OriginalNumericGeneric Edit73 Allow NULL? 
234SLOPDJDate - Original Promised DeliveryDateGeneric Edit60
235SLXKCOCross Dock Order Company (Order Number)StringGeneric Edit50 Allow NULL? 
236SLXORNCross Dock Order NoNumericGeneric Edit80 Allow NULL? 
237SLXCTOCross Dock Order TypeStringUDC (00 DT)20 Allow NULL? 
238SLXLLNCross Dock Line NumberNumericGeneric Edit63 Allow NULL? 
239SLXSFXCross Dock Order SuffixStringGeneric Edit30 Allow NULL? 
240SLPOEPort of Entry or ExitStringUDC (40 PE)60 Allow NULL? 
241SLPMTOPayment Terms Override CodeCharacterGeneric Edit10 Allow NULL? 
242SLANBYBuyer NumberNumericGeneric Edit80 Allow NULL? 
243SLPMTNPromotion IDStringGeneric Edit120 Allow NULL? 
244SLNUMBAsset Item NumberNumericGeneric Edit80 Allow NULL? 
245SLAAIDParent NumberNumericGeneric Edit80 Allow NULL? 
246SLPRAN8Partner Address NumberNumericGeneric Edit80 Allow NULL? 
247SLSPATTNShip To AttentionStringGeneric Edit500 Allow NULL? 
248SLPRCIDLNPartner Contact Line Number IDNumericGeneric Edit50 Allow NULL? 
249SLCCIDLNCustomer Contact Line Number IDNumericGeneric Edit50 Allow NULL? 
250SLSHCCIDLNShip To Cust Contact Line Num IDNumericGeneric Edit50 Allow NULL? 
251SLOPPIDOpportunity NumberNumericGeneric Edit150 Allow NULL? 
252SLOSTPOrganization Structure TypeStringUDC (01 TS)30 Allow NULL? 
253SLUKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
254SLCATNMCatalog NameStringGeneric Edit300 Allow NULL? 
255SLALLOCAllocation Process FlagCharacterGeneric Edit10 Allow NULL? 
256SLFULPIDFulfillment Plan IDIntegerGeneric Edit110 Allow NULL? 
257SLALLSTSAllocation Status NumberStringUDC (42 AS)300 Allow NULL? 
258SLOSCORESales Order ScoreNumericGeneric Edit153 Allow NULL? 
259SLOSCOREOOrder Score OverrideCharacterGeneric Edit10 Allow NULL? 
260SLCMCOCustomer Master CompanyStringGeneric Edit50 Allow NULL? 
261SLKITIDKit IdentifierNumericGeneric Edit150 Allow NULL? 
262SLKITAMTDOMAccumulated Amount Invoiced (Domestic)NumericGeneric Edit152 Allow NULL? 
263SLKITAMTFORAccumulated Amount Invoiced (Foreign)NumericGeneric Edit152 Allow NULL? 
264SLKITDIRTYKit Component Dirty FlagCharacterGeneric Edit10 Allow NULL? 
265SLOCITTOC In-Transit FlagCharacterGeneric Edit10 Allow NULL? 
266SLOCCARDNOOC Kanban Card NoNumericGeneric Edit80 Allow NULL? 
267SLPMPNProduction NumberStringGeneric Edit300 Allow NULL? 
268SLPNSProduction Number ShortNumericGeneric Edit100 Allow NULL? 

TOP920 | 42 | F42199 INDEXES

NumberDescription
1Order Num 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
2Order Num Order Type+
ElementAliasDescriptionSequence
1KCOOOrder Company (Order Number)Ascending
2DOCODocument (Order No Invoice etc.)Ascending
3DCTOOrder TypeAscending
4LNIDLine NumberAscending
5KCODocument CompanyAscending
6DOCDocument (Voucher Invoice etc.)Ascending
7DCTDocument TypeAscending
8UPMJDate - UpdatedAscending
9TDAYTime of DayAscending