SO_SalesOrderHistoryTaxSummary SO Sales Order History Tax SummaRel: 4.40 Bld: 398 8/28/2009
Bus Obj: SO_SalesOrderHistoryTaxSummary_bus
SQL Def: N SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_SalesOrderHistoryTaxSummary.M4T"
KPRIMARY: SalesOrderNo+ScheduleSeqNo+TaxCode
Fld Column Name M/L TUR Description/Notes Class
1 SalesOrderNo. . . . . . . . . 7 SYY Sales Order Number. . . . . . .SALESORDERNO
FmtType:CHARNUM Notes:
{SO_12$(1,7)}
2 ScheduleSeqNo . . . . . . . . 6 SNY Schedule Sequence Number. . . .
Mask:000000 FmtType:ZEROFILL
Notes: {SO_12$(8,2)}
3 TaxCode . . . . . . . . . . . 15 SYY Tax Code. . . . . . . . . . . .TAXCODE
Notes: {SO_12$(10,15)}
4 ExemptionNo . . . . . . . . . 20 SNN Exemption Number. . . . . . . .
Notes: {SO_12$(25,20)}
5 Overridden. . . . . . . . . . 1 SYN Overridden. . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO_12$(45,1)}
6 TaxableSalesAmt . . . . . . . 13.2 NNN Taxable Sales Amount. . . . . .AMOUNT
Mask:###,###,###.00 Notes:
{SO_12[0]}
7 NonTaxableSalesAmt. . . . . . 13.2 NNN Non-Taxable Sales Amount. . . .AMOUNT
Mask:###,###,###.00 Notes:
{SO_12[3]}
8 ExemptSalesAmt. . . . . . . . 13.2 NNN Exempt Sales Amount . . . . . .AMOUNT
Mask:###,###,###.00 Notes:
{SO_12[4]}
9 TaxableFreightAmt . . . . . . 12.2 NNN Taxable Freight Amount. . . . .MISCAMOUNT
Mask:##,###,###.00- Notes:
{SO_12[1]}
10 TaxableTaxAmt . . . . . . . . 12.2 NNN Taxable Tax Amount. . . . . . .MISCAMOUNT
Mask:##,###,###.00- Notes:
{SO_12[2]}
11 SalesTaxAmt . . . . . . . . . 12.2 NNN Sales Tax Amount. . . . . . . .MISCAMOUNT
Mask:##,###,###.00- Notes:
{SO_12[7]}
12 NonTaxableFreightAmt. . . . . 12.2 NNN Non-Taxable Freight Amount. . .MISCAMOUNT
Mask:##,###,###.00- Notes:
{SO_12[8]}
13 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
14 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
15 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL