SO_SalesOrderHistoryTaxDetail SO Sales Order History Tax DetaiRel: 4.40 Bld: 398 8/28/2009 Bus Obj: SO_SalesOrderHistoryTaxDetail_bus SQL Def: N SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_SalesOrderHistoryTaxDetail.M4T"
KPRIMARY: SalesOrderNo+ScheduleSeqNo+TaxCode+TaxClass
Fld Column Name M/L TUR Description/Notes Class
1 SalesOrderNo. . . . . . . . . 7 SYY Sales Order Number. . . . . . .SALESORDERNO FmtType:CHARNUM Notes: {SO_11$(1,7)} 2 ScheduleSeqNo . . . . . . . . 6 SNY Schedule Sequence Number. . . . Mask:000000 FmtType:ZEROFILL Notes: {SO_11$(8,2)} 3 TaxCode . . . . . . . . . . . 15 SYY Tax Code. . . . . . . . . . . .TAXCODE Notes: {SO_11$(10,15)} 4 TaxClass. . . . . . . . . . . 2 SYY Tax Class . . . . . . . . . . .TAXCLASS Notes: {SO_11$(25,2)} 5 TaxableSalesAmt . . . . . . . 13.2 NNN Taxable Sales Amount. . . . . .AMOUNT Mask:###,###,###.00 Notes: {SO_11[0]} 6 NonTaxableSalesAmt. . . . . . 13.2 NNN Non-Taxable Sales Amount. . . .AMOUNT Mask:###,###,###.00 Notes: {SO_11[1]} 7 ExemptSalesAmt. . . . . . . . 13.2 NNN Exempt Sales Amount . . . . . .AMOUNT Mask:###,###,###.00 Notes: {SO_11[2]} 8 TaxableSalesSubjToDisc. . . . 13.2 NNN Taxble Sales Subject To DiscounAMOUNT Mask:###,###,###.00 Notes: {SO_11[3]} 9 NonTaxableSalesSubjToDisc . . 13.2 NNN Non-Taxble Sales Subject To DisAMOUNT Mask:###,###,###.00 Notes: {SO_11[4]} 10 TaxRate . . . . . . . . . . . 11.6 NNN Tax Rate. . . . . . . . . . . . Mask:##0.000000 Notes: {SO_11[5]} 11 DiscountAmt . . . . . . . . . 13.2 NNN Discount Amount . . . . . . . .AMOUNT Mask:###,###,###.00 Notes: {SO_11[6]} 12 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 13 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y 14 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL