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