SO_InvoiceTaxSummary SO Invoice Tax Summary Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: SO_InvoiceTaxSummary_bus
SQL Def: N SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_InvoiceTaxSummary.M4T"
KPRIMARY: InvoiceNo+ScheduleSeqNo+TaxCode
KTAXCODE: TaxCode+InvoiceNo+ScheduleSeqNo
Fld Column Name M/L TUR Description/Notes Class
1 InvoiceNo . . . . . . . . . . 7 SYY Invoice Number. . . . . . . . .INVOICE
FmtType:MASTERNUM Notes:
{SO_18$(1,7)}
2 ScheduleSeqNo . . . . . . . . 6 SNY Schedule Sequence Number. . . .
Mask:000000 FmtType:ZEROFILL
Notes: {SO_18$(8,2)}
3 TaxCode . . . . . . . . . . . 15 SYY Tax Code. . . . . . . . . . . .TAXCODE
Notes: {SO_18$(10,15)}
4 ExemptionNo . . . . . . . . . 20 SNN Exemption Number. . . . . . . .
Notes: {SO_18$(25,20)}
5 Overridden. . . . . . . . . . 1 SYN Overridden. . . . . . . . . . .YESNO
Read Only:Y DfltVal:N
Valid:Y,N Notes: {SO_18$(45,
1)}
6 TaxableSalesAmt . . . . . . . 13.2 NNN Taxable Sales Amount. . . . . .
Read Only:Y Mask:###,###,
###.00- Notes: {SO_18[0]}
7 NonTaxableSalesAmt. . . . . . 13.2 NNN Non-Taxable Sales Amount. . . .
Read Only:Y Mask:###,###,
###.00- Notes: {SO_18[3]}
8 TaxableFreightAmt . . . . . . 12.2 NNN Taxable Freight Amount. . . . .
Read Only:Y Mask:##,###,
###.00- Notes: {SO_18[1]}
9 TaxableTaxAmt . . . . . . . . 12.2 NNN Taxable Tax Amount. . . . . . .
Read Only:Y Mask:##,###,
###.00- Notes: {SO_18[2]}
10 ExemptSalesAmt. . . . . . . . 13.2 NNN Exempt Sales Amount . . . . . .
Read Only:Y Mask:###,###,
###.00- Notes: {SO_18[4]}
11 SalesTaxAmt . . . . . . . . . 12.2 NNN Sales Tax Amount. . . . . . . .
Mask:##,###,###.00- Notes:
{SO_18[7]}
12 NonTaxableFreightAmt. . . . . 12.2 NNN Non-Taxable Freight Amount. . .
Read Only:Y Mask:##,###,
###.00- Notes: {SO_18[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