SO_InvoiceTaxDetail SO Invoice Tax Detail Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: SO_InvoiceTaxDetail_bus
SQL Def: N SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_InvoiceTaxDetail.M4T"
KPRIMARY: InvoiceNo+ScheduleSeqNo+TaxCode+TaxClass
Fld Column Name M/L TUR Description/Notes Class
1 InvoiceNo . . . . . . . . . . 7 SYY Invoice Number. . . . . . . . .INVOICE
FmtType:MASTERNUM Notes:
{SO_17$(1,7)}
2 ScheduleSeqNo . . . . . . . . 6 SNY Schedule Sequence Number. . . .
Mask:000000 FmtType:ZEROFILL
Notes: {SO_17$(8,2)}
3 TaxCode . . . . . . . . . . . 15 SYY Tax Code. . . . . . . . . . . .TAXCODE
Notes: {SO_17$(10,15)}
4 TaxClass. . . . . . . . . . . 2 SYY Tax Class . . . . . . . . . . .TAXCLASS
Notes: {SO_17$(25,2)}
5 TaxableSalesAmt . . . . . . . 13.2 NNN Taxable Sales Amount. . . . . .
Mask:###,###,###.00- Notes:
{SO_17[0]}
6 NonTaxableSalesAmt. . . . . . 13.2 NNN Non-Taxable Sales Amount. . . .
Mask:###,###,###.00- Notes:
{SO_17[1]}
7 ExemptSalesAmt. . . . . . . . 13.2 NNN Exempt Sales Amount . . . . . .
Mask:###,###,###.00- Notes:
{SO_17[2]}
8 TaxableSalesSubjToDisc. . . . 13.2 NNN Taxble Sales Subject To Discoun
Mask:###,###,###.00- Notes:
{SO_17[3]}
9 NonTaxableSalesSubjToDisc . . 13.2 NNN Non-Taxable Sales Subject To Di
Mask:###,###,###.00- Notes:
{SO_17[4]}
10 TaxRate . . . . . . . . . . . 11.6 NNN Tax Rate. . . . . . . . . . . .
Mask:##0.000000- Notes:
{SO_17[5]}
11 DiscountAmt . . . . . . . . . 12.2 NNN Discount Amount . . . . . . . .
Mask:##,###,###.00- Notes:
{SO_17[6]}
12 RetentionAmt. . . . . . . . . 13.2 NNN Retention Amount. . . . . . . .AMOUNT
Mask:###,###,###.00
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