SO_SalesOrderDetail SO Sales Order Detail Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: SO_SalesOrderDetail_bus,SO_SalesJournal_upd,IT_ShoppingCartMirror: SO_SalesOrderHistoryDetail SQL Def: N SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_SalesOrderDetail.M4T"
KPRIMARY: SalesOrderNo+LineKey KDISPLAY: SalesOrderNo+LineSeqNo+LineKey KEXTENDEDDESC: ExtendedDescriptionKey+SalesOrderNo+LineKey KITEMTYPE: ItemType+ItemCode+SalesOrderNo+LineKey KITEMWHSE: ItemCode+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 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 ValGroup:IMIn tegrated,ItemRequired, NotComment,MultiWarehouse, RegularItem,NotNulWarehouseCo de 12 PriceLevel. . . . . . . . . . 1 SYN Price Level . . . . . . . . . . DepVal:REQUIRED ValGroup:IMIn tegrated,ItemRequired, RegularItem,NotComponent 13 MasterOrderLineKey. . . . . . 6 SNN Master Order Line Key . . . . . Mask:000000 FmtType:ZEROFILL 14 UnitOfMeasure . . . . . . . . 4 SYN Unit Of Measure . . . . . . . .UNITOFMEASURE ValGroup:ItemRequired, ItemTypes 15 DropShip. . . . . . . . . . . 1 SYN Drop Ship . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:ItemTypes 16 PrintDropShipment . . . . . . 1 SYN Print Drop Shipment . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment 17 SalesKitLineKey . . . . . . . 6 SNN Sales Kit Line Key. . . . . . . Mask:000000 FmtType:ZEROFILL 18 CostOfGoodsSoldAcctKey. . . . 9 SNN Cost of Goods Sold Account Key.ACCOUNT DepVal:REQUIRED ValGroup:Item Required,ItemTypes 19 SalesAcctKey. . . . . . . . . 9 SNN Sales Account Key . . . . . . .ACCOUNT DepVal:REQUIRED ValGroup:NotC omment,ItemRequired 20 PriceOverridden . . . . . . . 1 SYN Has Price Been Overridden . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment 21 ExplodedKitItem . . . . . . . 1 SYN Exploded Kit Item . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment 22 StandardKitBill . . . . . . . 1 SYN Standard/Kit Bill . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment 23 Revision. . . . . . . . . . . 3 SNN Bill Revision Code. . . . . . . 24 BillOption1 . . . . . . . . . 2 SYN Bill Option 1 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, BillHasOptions,ItemRequired, RegularItem 25 BillOption2 . . . . . . . . . 2 SYN Bill Option 2 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, BillHasOptions,ItemRequired, RegularItem 26 BillOption3 . . . . . . . . . 2 SYN Bill Option 3 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, BillHasOptions,ItemRequired, RegularItem 27 BillOption4 . . . . . . . . . 2 SYN Bill Option 4 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, BillHasOptions,ItemRequired, RegularItem 28 BillOption5 . . . . . . . . . 2 SYN Bill Option 5 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, BillHasOptions,ItemRequired, RegularItem 29 BillOption6 . . . . . . . . . 2 SYN Bill Option 6 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, BillHasOptions,ItemRequired, RegularItem 30 BillOption7 . . . . . . . . . 2 SYN Bill Option 7 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, BillHasOptions,ItemRequired, RegularItem 31 BillOption8 . . . . . . . . . 2 SYN Bill Option 8 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, BillHasOptions,ItemRequired, RegularItem 32 BillOption9 . . . . . . . . . 2 SYN Bill Option 9 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, BillHasOptions,ItemRequired, RegularItem 33 BackorderKitCompLine. . . . . 1 SYN Backorder Kit Component Line. .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment Notes: Kit Bckord=0, Comp Bckord>0 Flg=Y 34 SkipPrintCompLine . . . . . . 1 SYN Skip Printing Of This ComponentYESNO DfltVal:N Valid:Y,N Notes: Line In S/O 35 PromiseDate . . . . . . . . . 8 SNN Promise Date. . . . . . . . . .DATE ValGroup:ItemRequired, NotComment 36 AliasItemNo . . . . . . . . . 30 SYN Alias Item Number . . . . . . . ValGroup:ItemRequired, RegularItem 37 SOHistoryDetlSeqNo. . . . . . 14 SNN Sales Order History Detail Sequ Mask:00000000000000 FmtType:ZEROFILL 38 TaxClass. . . . . . . . . . . 2 SYN Tax Class . . . . . . . . . . .TAXCLASS ValGroup:ARSalesTax, NotComment 39 CustomerAction. . . . . . . . 1 SYN Customer Action . . . . . . . . DfltVal:N Valid:N,C,P,R ValGroup:NotComment Notes: N=None, C=Credit, P=rePlaceme nt, R=Repair 40 ItemAction. . . . . . . . . . 1 SYN Item Action . . . . . . . . . . DfltVal:N Valid:N,S,P,R ValGroup:NotComment Notes: N=None, S=Stock, P=scraP, R=Repair 41 WarrantyCode. . . . . . . . . 10 SYN Warranty Code . . . . . . . . .WARRANTYCODE DepVal:REQUIRED ValGroup:Item Required,RegularItem, WarrantyTracking 42 ExpirationDate. . . . . . . . 8 SNN Expiration Date . . . . . . . .DATE ValGroup:ItemRequired, RegularItem,WarrantyTracking 43 ExpirationOverridden. . . . . 1 SYN Expiration Overridden . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment 44 CostOverridden. . . . . . . . 1 SYN Cost Overridden . . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment 45 CostCode. . . . . . . . . . . 9 SYN Cost Code . . . . . . . . . . .COSTCODE FmtType:CHARNUM DepVal:REQUIR ED ValGroup:PostJCCosts, NotComment 46 CostType. . . . . . . . . . . 1 SYN Cost Type . . . . . . . . . . .COSTTYPE DepVal:REQUIRED ValGroup:Post JCCosts,NotComment 47 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . .COMMENT 48 QuantityOrdered . . . . . . . 16.6 NNN Quantity Ordered. . . . . . . .QUANTITY Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,ItemTypes 49 QuantityShipped . . . . . . . 16.6 NNN Quantity Shipped. . . . . . . .QUANTITY Mask:##,###,###.000000- ValGroup:NotComment, NotMasterRepeating,ItemRequir ed,ItemTypes 50 QuantityBackordered . . . . . 16.6 NNN Quantity Backordered. . . . . .QUANTITY Mask:##,###,###.000000- ValGroup:NotComment, NotMasterRepeating,ItemRequir ed,ItemTypes,NotQuote 51 MasterOriginalQty . . . . . . 16.6 NNN Master Original Quantity. . . .QUANTITY Mask:##,###,###.000000- ValGroup:MasterOrder, ItemRequired,ItemTypes 52 MasterQtyBalance. . . . . . . 16.6 NNN Master Quantity Balance . . . .QUANTITY Mask:##,###,###.000000- ValGroup:MasterOrder, NotComment 53 MasterQtyOrderedToDate. . . . 16.6 NNN Master Quantity Ordered To DateQUANTITY Mask:##,###,###.000000- ValGroup:MasterOrder, NotComment 54 RepeatingQtyShippedToDate . . 16.6 NNN Repeating Quantity Shipped To DQUANTITY Mask:##,###,###.000000- ValGroup:RepeatingOrder 55 UnitPrice . . . . . . . . . . 16.6 NNN Unit Price. . . . . . . . . . .PRICE Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,ItemTypes 56 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . .COST Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,ItemTypes 57 ExtensionAmt. . . . . . . . . 12.2 NNN Extension Amount. . . . . . . . Mask:##,###,###.00- ValGroup:NotComment, ItemRequired 58 UnitOfMeasureConvFactor . . . 12.4 NNN Unit Of Measure Conversion FactUMCONVFACTOR Mask:#####0.0000 ValGroup:Not Comment 59 QuantityPerBill . . . . . . . 16.6 NNN Quantity Per Bill . . . . . . .QUANTITY Mask:##,###,###.000000- ValGroup:BMIntegrated, NotComment 60 LineDiscountPercent . . . . . 9.3 NNN Line Discount Percent . . . . . Mask:#,##0.000- ValGroup:Line Discount,ItemRequired, ItemTypes 61 LineWeight. . . . . . . . . . 12.2 NNN Line Weight . . . . . . . . . .MISCAMOUNT Read Only:Y Mask:##,###, ###.00-