SO_SalesOrderDetail SO Sales Order Detail Rel: 7.50 Bld: 408 6/29/2026 Physical Path: "MAS_"+%C$+"/SO"+%C$+"/SO_SalesOrderDetail.M4T" SQL Create: Y SQL Sys DB: N SQL Null Dates: N Exclude V/I: Y Create Tbl: N Bus Obj: SO_SalesOrderDetail_bus SO_SalesJournal_upd IT_ShoppingCart_upd RA_GenerateTransactions_upd BC_CommonImport Mirror Table: SO_SalesOrderHistoryDetail Record ID Column: ItemType
KPRIMARY: SalesOrderNo+LineKey KDISPLAY: SalesOrderNo+LineSeqNo+LineKey KEXTENDEDDESC: ExtendedDescriptionKey+SalesOrderNo+LineKey KITEMTYPE: ItemType+ItemCode+SalesOrderNo+LineKey KITEMWHSE: ItemCode+WarehouseCode+SalesOrderNo+LineKey KVENDOR: APDivisionNo+VendorNo+SalesOrderNo+LineKey kWAREHOUSE: WarehouseCode+SalesOrderNo+LineKey
Fld Column Name M/L TUR Description/Notes Class
1 SalesOrderNo. . . . . . . . . 7 SYY Sales Order Number. . . . . . .SALESORDERNO Read Only:Y FmtType:CHARNUM 2 LineKey . . . . . . . . . . . 6 SNY Line Key. . . . . . . . . . . . Read Only:Y Mask:000000 FmtType:ZEROFILL 3 LineSeqNo . . . . . . . . . . 14 SNY Line Sequence Number. . . . . . Read Only:Y Mask:000000000000 00 FmtType:ZEROFILL 4 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE ValGroup:ItemPriceByTotQty ChngTag:Replace0 5 ItemType. . . . . . . . . . . 1 SYY ItemType. . . . . . . . . . . . Valid:1,2,3,4,5 Notes: 1=Regular Item, 2=Special Item, 3=Charge Item, 4=Comment Item, 5=Miscellaneo us Item 6 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . .DESCRIPTION ValGroup:ItemRequired, NotComment 7 ExtendedDescriptionKey. . . . 10 SYN Extended Description Key. . . .EXTDESCKEY Read Only:Y ValGroup:NotComme nt,ItemRequired,ItemTypes 8 Discount. . . . . . . . . . . 1 SYN Discount. . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment, NotComponent 9 Commissionable. . . . . . . . 1 SYN Commissionable. . . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:SalespersonReporting ,NotComment,NotComponent 10 SubjectToExemption. . . . . . 1 SYN Subject To Exemption. . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:ARSalesTax, NotComment 11 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE FmtType:CHARNUM DepVal:REQUIR ED ValGroup:IMIntegrated, ItemRequired,NotComment, MultiWarehouse,RegularItem, NotNulWarehouseCode ChngTag:Replace0 12 Valuation . . . . . . . . . . 1 SYN Valuation . . . . . . . . . . . Valid:1,2,3,4,5,6 ValGroup:No tComment Notes: 1=Standard, 2=Average, 3=Fifo, 4=Lifo, 5=Lot, 6=Serial 13 PriceLevel. . . . . . . . . . 15 SYN Price Level . . . . . . . . . . DepVal:REQUIRED ValGroup:IMIn tegrated,ItemRequired, RegularItem,NotComponent, ItemPriceByTotQty 14 MasterOrderLineKey. . . . . . 6 SNN Master Order Line Key . . . . . Mask:000000 FmtType:ZEROFILL 15 UnitOfMeasure . . . . . . . . 4 SYN Unit Of Measure . . . . . . . .UNITOFMEASURE ValGroup:ItemRequired, ItemTypes,ItemPriceByTotQty 16 DropShip. . . . . . . . . . . 1 SYN Drop Ship . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:ItemTypes 17 LotSerialFullyDistributed . . 1 SYN Lot/Serial Fully Distributed. .YESNO DfltVal:Y Valid:Y,N ValGroup:NotComment 18 PrintDropShipment . . . . . . 1 SYN Print Drop Shipment . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment 19 SalesKitLineKey . . . . . . . 6 SNN Sales Kit Line Key. . . . . . . Mask:000000 FmtType:ZEROFILL 20 CostOfGoodsSoldAcctKey. . . . 9 SNN Cost of Goods Sold Account Key.ACCOUNT DepVal:REQUIRED ValGroup:Item Required,ItemTypes 21 SalesAcctKey. . . . . . . . . 9 SNN Sales Account Key . . . . . . .ACCOUNT DepVal:REQUIRED ValGroup:NotC omment,ItemRequired 22 PriceOverridden . . . . . . . 1 SYN Has Price Been Overridden . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment 23 ExplodedKitItem . . . . . . . 1 SYN Exploded Kit Item . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment 24 StandardKitBill . . . . . . . 1 SYN Standard/Kit Bill . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment 25 Revision. . . . . . . . . . . 3 SNN Bill Revision Code. . . . . . . 26 BillOption1 . . . . . . . . . 2 SYN Bill Option 1 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, BillHasOptions,ItemRequired, RegularItem 27 BillOption2 . . . . . . . . . 2 SYN Bill Option 2 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, BillHasOptions,ItemRequired, RegularItem 28 BillOption3 . . . . . . . . . 2 SYN Bill Option 3 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, BillHasOptions,ItemRequired, RegularItem 29 BillOption4 . . . . . . . . . 2 SYN Bill Option 4 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, BillHasOptions,ItemRequired, RegularItem 30 BillOption5 . . . . . . . . . 2 SYN Bill Option 5 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, BillHasOptions,ItemRequired, RegularItem 31 BillOption6 . . . . . . . . . 2 SYN Bill Option 6 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, BillHasOptions,ItemRequired, RegularItem 32 BillOption7 . . . . . . . . . 2 SYN Bill Option 7 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, BillHasOptions,ItemRequired, RegularItem 33 BillOption8 . . . . . . . . . 2 SYN Bill Option 8 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, BillHasOptions,ItemRequired, RegularItem 34 BillOption9 . . . . . . . . . 2 SYN Bill Option 9 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, BillHasOptions,ItemRequired, RegularItem 35 BackorderKitCompLine. . . . . 1 SYN Backorder Kit Component Line. .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment Notes: Kit Bckord=0, Comp Bckord>0 Flg=Y 36 SkipPrintCompLine . . . . . . 1 SYN Skip Printing Of This ComponentYESNO DfltVal:N Valid:Y,N Notes: Line In S/O 37 PromiseDate . . . . . . . . . 8 SNN Promise Date. . . . . . . . . .DATE ValGroup:ItemRequired, NotComment 38 AliasItemNo . . . . . . . . . 30 SYN Alias Item Number . . . . . . . ValGroup:ItemRequired, RegularItem 39 SOHistoryDetlSeqNo. . . . . . 14 SNN Sales Order History Detail Sequ Mask:00000000000000 FmtType:ZEROFILL 40 TaxClass. . . . . . . . . . . 2 SYN Tax Class . . . . . . . . . . .TAXCLASS DepVal:REQUIRED ValGroup:ARSa lesTax,NotComment 41 CustomerAction. . . . . . . . 1 SYN Customer Action . . . . . . . . DfltVal:N Valid:N,C,P,R ValGroup:NotComment Notes: N=None, C=Credit, P=rePlaceme nt, R=Repair 42 ItemAction. . . . . . . . . . 1 SYN Item Action . . . . . . . . . . DfltVal:N Valid:N,S,P,R ValGroup:NotComment Notes: N=None, S=Stock, P=scraP, R=Repair 43 WarrantyCode. . . . . . . . . 10 SYN Warranty Code . . . . . . . . .WARRANTYCODE DepVal:REQUIRED ValGroup:Item Required,RegularItem, WarrantyTracking 44 ExpirationDate. . . . . . . . 8 SNN Expiration Date . . . . . . . .DATE ValGroup:ItemRequired, RegularItem,WarrantyTracking 45 ExpirationOverridden. . . . . 1 SYN Expiration Overridden . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment 46 CostOverridden. . . . . . . . 1 SYN Cost Overridden . . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment 47 CostCode. . . . . . . . . . . 9 SYN Cost Code . . . . . . . . . . .COSTCODE FmtType:CHARNUM DepVal:REQUIR ED ValGroup:PostJCCosts, NotComment 48 CostType. . . . . . . . . . . 1 SYN Cost Type . . . . . . . . . . .COSTTYPE DepVal:REQUIRED ValGroup:Post JCCosts,NotComment 49 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . .COMMENT 50 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . .APDIVISION Mask:00 DepVal:REQUIRED ValGroup:NotComment,POSetup, ItemRequired 51 VendorNo. . . . . . . . . . . 7 SYN Vendor Number . . . . . . . . .VENDORNO FmtType:MASTERNUM DepVal:REQU IRED ValGroup:NotComment, POSetup,ItemRequired ChngTag:Replace1/APDivisionNo $ 52 PurchaseOrderNo . . . . . . . 7 SYN Purchase Order Number . . . . .PURCHASEORDERNO FmtType:CHARNUM ValGroup:NotC omment,POSetup,ItemRequired 53 PurchaseOrderRequiredDate . . 8 SNN Purchase Order Required Date. .DATE ValGroup:NotComment,POSetup, ItemRequired 54 CommodityCode . . . . . . . . 12 SNN Commodity Code. . . . . . . . .COMMODITYCODE ValGroup:NotComment, NotComponent Notes: Added in for CC Corporate Level III support 55 AlternateTaxIdentifier. . . . 15 SNN Alternate Tax Identifier. . . . ValGroup:CCLevel3Dtl, NotComment,NotComponent Notes: Added in for CC Corporate Level III support 56 TaxTypeApplied. . . . . . . . 4 SNN Tax Type Applied. . . . . . . . ValGroup:CCLevel3Dtl, NotComment,NotComponent Notes: Added in for CC Corporate Level III support 57 NetGrossIndicator . . . . . . 1 SNN Net Gross Indicator . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:CCLevel3Dtl, NotComment,NotComponent Notes: Added in for CC Corporate Level III supportAlways false (N); Per SPS, when true this indicates sales tax included in ExtendedItemAmount 58 DebitCreditIndicator. . . . . 1 SYN Debit Credit Indicator. . . . . DfltVal:C Valid:D,C ValGroup:CCLevel3Dtl, NotComment,NotComponent Notes: Added in for CC Corporate Level III supportPer SPS, Always 'C'reditcard 59 QuantityOrdered . . . . . . . 16.6 NNN Quantity Ordered. . . . . . . .QUANTITY Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,ItemTypes, ItemPriceByTotQty 60 QuantityShipped . . . . . . . 16.6 NNN Quantity Shipped. . . . . . . .QUANTITY Mask:##,###,###.000000- ValGroup:NotComment, NotMasterRepeating,ItemRequir ed,ItemTypes 61 QuantityBackordered . . . . . 16.6 NNN Quantity Backordered. . . . . .QUANTITY Mask:##,###,###.000000- ValGroup:NotComment, NotMasterRepeating,ItemRequir ed,ItemTypes,NotQuote 62 MasterOriginalQty . . . . . . 16.6 NNN Master Original Quantity. . . .QUANTITY Mask:##,###,###.000000- ValGroup:MasterOrder, ItemRequired,ItemTypes, ItemPriceByTotQty 63 MasterQtyBalance. . . . . . . 16.6 NNN Master Quantity Balance . . . .QUANTITY Mask:##,###,###.000000- ValGroup:MasterOrder, NotComment 64 MasterQtyOrderedToDate. . . . 16.6 NNN Master Quantity Ordered To DateQUANTITY Mask:##,###,###.000000- ValGroup:MasterOrder, NotComment 65 RepeatingQtyShippedToDate . . 16.6 NNN Repeating Quantity Shipped To DQUANTITY Mask:##,###,###.000000- ValGroup:RepeatingOrder 66 UnitPrice . . . . . . . . . . 16.6 NNN Unit Price. . . . . . . . . . .PRICE Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,ItemTypes, ItemPriceByTotQty 67 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . .COST Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,ItemTypes 68 ExtensionAmt. . . . . . . . . 12.2 NNN Extension Amount. . . . . . . . Mask:##,###,###.00- ValGroup:NotComment, ItemRequired,ItemPriceByTotQt y 69 UnitOfMeasureConvFactor . . . 12.4 NNN Unit Of Measure Conversion FactUMCONVFACTOR Read Only:Y Mask:#####0.0000 ValGroup:NotComment, ItemPriceByTotQty 70 QuantityPerBill . . . . . . . 16.6 NNN Quantity Per Bill . . . . . . .QUANTITY Mask:##,###,###.000000- ValGroup:BMIntegrated, NotComment 71 LineDiscountPercent . . . . . 9.3 NNN Line Discount Percent . . . . . Mask:#,##0.000- ValGroup:Line Discount,ItemRequired, ItemTypes 72 LineWeight. . . . . . . . . . 12.2 NNN Line Weight . . . . . . . . . .MISCAMOUNT Read Only:Y Mask:##,###, ###.00- 73 TaxAmt. . . . . . . . . . . . 12.2 NNN Tax Amount. . . . . . . . . . .MISCAMOUNT Mask:##,###,###.00- ValGroup:CCLevel3Dtl, NotComment,NotComponent Notes: Added in for CC Corporate Level III support 74 TaxRate . . . . . . . . . . . 11.6 NNN Tax Rate. . . . . . . . . . . . Mask:###.000000- Valid:0-999. 999999 ValGroup:CCLevel3Dtl, NotComment,NotComponent Notes: Added in for CC Corporate Level III support 75 ItemTaxCode . . . . . . . . . 10 SYN Item Tax Code . . . . . . . . .SUTTAXCODE DepVal:REQUIRED ValGroup:NotC omment,NotComponent