SO_SalesOrderHistoryTaxDetail SO Sales Order History Tax DetaiRel: 4.40 Bld: 398 8/28/2009
Bus Obj: SO_SalesOrderHistoryTaxDetail_bus
SQL Def: N SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_SalesOrderHistoryTaxDetail.M4T"
KPRIMARY: SalesOrderNo+ScheduleSeqNo+TaxCode+TaxClass
Fld Column Name M/L TUR Description/Notes Class
1 SalesOrderNo. . . . . . . . . 7 SYY Sales Order Number. . . . . . .SALESORDERNO
FmtType:CHARNUM Notes:
{SO_11$(1,7)}
2 ScheduleSeqNo . . . . . . . . 6 SNY Schedule Sequence Number. . . .
Mask:000000 FmtType:ZEROFILL
Notes: {SO_11$(8,2)}
3 TaxCode . . . . . . . . . . . 15 SYY Tax Code. . . . . . . . . . . .TAXCODE
Notes: {SO_11$(10,15)}
4 TaxClass. . . . . . . . . . . 2 SYY Tax Class . . . . . . . . . . .TAXCLASS
Notes: {SO_11$(25,2)}
5 TaxableSalesAmt . . . . . . . 13.2 NNN Taxable Sales Amount. . . . . .AMOUNT
Mask:###,###,###.00 Notes:
{SO_11[0]}
6 NonTaxableSalesAmt. . . . . . 13.2 NNN Non-Taxable Sales Amount. . . .AMOUNT
Mask:###,###,###.00 Notes:
{SO_11[1]}
7 ExemptSalesAmt. . . . . . . . 13.2 NNN Exempt Sales Amount . . . . . .AMOUNT
Mask:###,###,###.00 Notes:
{SO_11[2]}
8 TaxableSalesSubjToDisc. . . . 13.2 NNN Taxble Sales Subject To DiscounAMOUNT
Mask:###,###,###.00 Notes:
{SO_11[3]}
9 NonTaxableSalesSubjToDisc . . 13.2 NNN Non-Taxble Sales Subject To DisAMOUNT
Mask:###,###,###.00 Notes:
{SO_11[4]}
10 TaxRate . . . . . . . . . . . 11.6 NNN Tax Rate. . . . . . . . . . . .
Mask:##0.000000 Notes:
{SO_11[5]}
11 DiscountAmt . . . . . . . . . 13.2 NNN Discount Amount . . . . . . . .AMOUNT
Mask:###,###,###.00 Notes:
{SO_11[6]}
12 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
13 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
14 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL