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