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-