SO_SalesOrderHistoryDetail SO Sales Order History Detail Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: SO_SalesOrderHistoryInquiryDetail_bus
SQL Def: N SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_SalesOrderHistoryDetail.M4T"
KPRIMARY: SalesOrderNo+SequenceNo
KEXTENDEDDESC: ExtendedDescriptionKey+SalesOrderNo+SequenceNo
KDISPLAY: SalesOrderNo+SequenceNo+LineKey
Fld Column Name M/L TUR Description/Notes Class
1 SalesOrderNo. . . . . . . . . 7 SYY Sales Order Number. . . . . . .SALESORDERNO
FmtType:CHARNUM Notes:
{SO_04$(1,7)}
2 SequenceNo. . . . . . . . . . 14 SNY Sequence Number . . . . . . . .
Mask:00000000000000
FmtType:ZEROFILL Notes:
{SO_04$(8,10)}
3 LineKey . . . . . . . . . . . 6 SNY Line Key. . . . . . . . . . . .
Mask:000000 FmtType:ZEROFILL
Notes: {SO_04$(18,5)}
4 OriginalLine. . . . . . . . . 1 SYN Original Line . . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO_04$(23,1)}
5 CancelledLine . . . . . . . . 1 SYN Cancelled Line. . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO_04$(24,1)}
6 CancelReasonCode. . . . . . . 5 SYN Cancel Reason Code. . . . . . .CANCELREASONCODE
Notes: {SO_04$(25,5)}
7 ItemCode. . . . . . . . . . . 30 SYN Item Code . . . . . . . . . . .ITEMCODE
ChngTag:Replace0 Notes:
{SO_04$(30,15)}
8 ItemType. . . . . . . . . . . 1 SYY Item Type . . . . . . . . . . .
Valid:1,2,3,4,5 Notes:
1=Inventory Item, 2=Special
Item, 3=Charge Item,
4=Comment Item, 5=Miscellaneo
us Item {SO_04$(50,1)}
9 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . .DESCRIPTION
Notes: {SO_04$(58,30)}
10 ExtendedDescriptionKey. . . . 10 SYN Extended Description Key. . . .EXTDESCKEY
Read Only:Y Notes: {SO_04$(45
,5)}
11 Discount. . . . . . . . . . . 1 SYN Discount. . . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO_04$(51,1)}
12 Commissionable. . . . . . . . 1 SYN Commissionable. . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO_04$(52,1)}
13 SubjectToExemption. . . . . . 1 SYN Subject To Exemption. . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO_04$(53,1)}
14 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE
FmtType:CHARNUM Notes:
{SO_04$(54,3)}
15 PriceLevel. . . . . . . . . . 1 SYN Price Level . . . . . . . . . .
Notes: {SO_04$(57,1)}
16 DropShip. . . . . . . . . . . 1 SYN Drop Ship . . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO_04$(110,1)}
17 PrintDropShipment . . . . . . 1 SYN Print Drop Shipment . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO_04$(93,1)}
18 MasterOrderLineKey. . . . . . 6 SNN Master Order Line Key . . . . .
Mask:000000 FmtType:ZEROFILL
Notes: {SO_04$(94,5)}
19 UnitOfMeasure . . . . . . . . 4 SYN Unit Of Measure . . . . . . . .UNITOFMEASURE
Notes: {SO_04$(106,4)}
20 SalesKitLineKey . . . . . . . 6 SNN Sales Kit Line Key. . . . . . .
Mask:000000 FmtType:ZEROFILL
Notes: {SO_04$(112,5)}
21 CostOfGoodsSoldAcctKey. . . . 9 SYN Cost of Goods Sold Account Key.ACCOUNT
Notes: {SO_04$(117,9)}
22 SalesAcctKey. . . . . . . . . 9 SYN Sales Account Key . . . . . . .ACCOUNT
Notes: {SO_04$(126,9)}
23 PriceOverridden . . . . . . . 1 SYN Has Price Been Overridden . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO_04$(136,1)}
24 ExplodedKitItem . . . . . . . 1 SYN Exploded Kit Item . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO_04$(135,1)}
25 StandardKitBill . . . . . . . 1 SYN Standard/Kit Bill . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO_04$(155,1)}
26 Revision. . . . . . . . . . . 3 SNN Bill Revision Code. . . . . . .
27 BillOption1 . . . . . . . . . 2 SYN Bill Option 1 . . . . . . . . .BILLOPTION
FmtType:CHARNUM Notes:
{SO_04$(137,2)}
28 BillOption2 . . . . . . . . . 2 SYN Bill Option 2 . . . . . . . . .BILLOPTION
FmtType:CHARNUM Notes:
{SO_04$(139,2)}
29 BillOption3 . . . . . . . . . 2 SYN Bill Option 3 . . . . . . . . .BILLOPTION
FmtType:CHARNUM Notes:
{SO_04$(141,2)}
30 BillOption4 . . . . . . . . . 2 SYN Bill Option 4 . . . . . . . . .BILLOPTION
FmtType:CHARNUM Notes:
{SO_04$(143,2)}
31 BillOption5 . . . . . . . . . 2 SYN Bill Option 5 . . . . . . . . .BILLOPTION
FmtType:CHARNUM Notes:
{SO_04$(145,2)}
32 BillOption6 . . . . . . . . . 2 SYN Bill Option 6 . . . . . . . . .BILLOPTION
FmtType:CHARNUM Notes:
{SO_04$(147,2)}
33 BillOption7 . . . . . . . . . 2 SYN Bill Option 7 . . . . . . . . .BILLOPTION
FmtType:CHARNUM Notes:
{SO_04$(149,2)}
34 BillOption8 . . . . . . . . . 2 SYN Bill Option 8 . . . . . . . . .BILLOPTION
FmtType:CHARNUM Notes:
{SO_04$(151,2)}
35 BillOption9 . . . . . . . . . 2 SYN Bill Option 9 . . . . . . . . .BILLOPTION
FmtType:CHARNUM Notes:
{SO_04$(153,2)}
36 BackorderKitCompLine. . . . . 1 SYN Backorder Kit Component Line. .YESNO
DfltVal:N Valid:Y,N Notes:
Kit Bckord=0, Comp Bckord>0
Flg=Y {SO_04$(158,1)}
37 SkipPrintCompLine . . . . . . 1 SYN Skip Print Of Component Line. .YESNO
DfltVal:N Valid:Y,N Notes:
Component Line In S/O
{SO_04$(159,1)}
38 PromiseDate . . . . . . . . . 8 SNN Promise Date. . . . . . . . . .DATE
Notes: {SO_04$(160,6)}
39 AliasItemNo . . . . . . . . . 30 SYN Alias Item Number . . . . . . .
Notes: {SO_04$(166,30)}
40 TaxClass. . . . . . . . . . . 2 SYN Tax Class . . . . . . . . . . .TAXCLASS
Notes: {SO_04$(196,2)}
41 CustomerAction. . . . . . . . 1 SYN Customer Action . . . . . . . .
DfltVal:N Valid:N,C,P,R
Notes: N=None, C=Credit,
P=rePlacement, R=Repair
{SO_04$(198,1)}
42 ItemAction. . . . . . . . . . 1 SYN Item Action . . . . . . . . . .
DfltVal:N Valid:N,S,P,R
Notes: N=None, S=Stock,
P=Scrap, R=Repair
43 WarrantyCode. . . . . . . . . 10 SYN Warranty Code . . . . . . . . .WARRANTYCODE
Notes: {SO_04$(199,10)}
44 ExpirationDate. . . . . . . . 8 SNN Expiration Date . . . . . . . .DATE
Notes: {SO_04$(209,6)}
45 ExpirationOverridden. . . . . 1 SYN Expiration Overridden . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO_04$(215,1)}
46 CostOverridden. . . . . . . . 1 SYN Cost Overridden . . . . . . . .YESNO
DfltVal:N Valid:Y,N
47 CostCode. . . . . . . . . . . 9 SYN Cost Code . . . . . . . . . . .COSTCODE
FmtType:CHARNUM
48 CostType. . . . . . . . . . . 1 SYN Cost Type . . . . . . . . . . .COSTTYPE
49 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . .COMMENT
Notes: {SO_04$(51,100)}
50 QuantityOrderedOriginal . . . 16.6 NNN Quantity Ordered Original . . .QUANTITY
Mask:##,###,###.000000-
Notes: {SO_04[0]}
51 QuantityOrderedRevised. . . . 16.6 NNN Quantity Ordered Revised. . . .QUANTITY
Mask:##,###,###.000000-
Notes: {SO_04[1]}
52 QuantityShipped . . . . . . . 16.6 NNN Quantity Shipped. . . . . . . .QUANTITY
Mask:##,###,###.000000-
Notes: {SO_04[2]}
53 QuantityBackordered . . . . . 16.6 NNN Quantity Backordered. . . . . .QUANTITY
Mask:##,###,###.000000-
Notes: {SO_04[3]}
54 OriginalUnitPrice . . . . . . 16.6 NNN Original Unit Price . . . . . .PRICE
Mask:##,###,###.000000-
Notes: {SO_04[4]}
55 LastUnitPrice . . . . . . . . 16.6 NNN Last Unit Price . . . . . . . .PRICE
Mask:##,###,###.000000-
Notes: {SO_04[5]}
56 LastExtensionAmt. . . . . . . 12.2 NNN Last Extension Amount . . . . .
Mask:##,###,###.00- Notes:
{SO_04[6]}
57 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . .COST
Mask:##,###,###.000000-
Notes: {SO_04[7]}
58 UnitOfMeasureConvFactor . . . 12.4 NNN Unit Of Measure Conversion FactUMCONVFACTOR
Mask:#####0.0000 Notes:
{SO_04[8]}
59 QuantityPerBill . . . . . . . 16.6 NNN Quantity Per Bill . . . . . . .QUANTITY
Mask:##,###,###.000000-
Notes: {SO_04[9]}
60 LineDiscountPercent . . . . . 9.3 NNN Line Discount Percent . . . . .
Mask:#,###.000- Notes:
{SO_04$(99,7)}
61 LineWeight. . . . . . . . . . 12.2 NNN Miscellaneous Amount. . . . . .MISCAMOUNT
Mask:##,###,###.00-