AR_OpenInvoiceTaxSummary AR Open Invoice Tax Summary Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AR_OpenInvoiceTaxSummary_bus SQL Def: N SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_OpenInvoiceTaxSummary.M4T"
KPRIMARY: ARDivisionNo+CustomerNo+InvoiceNo+InvoiceType+ScheduleSeqNo+TaxCode
Fld Column Name M/L TUR Description/Notes Class
1 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION Mask:00 FmtType:ZEROFILL Notes: {AR_16$(1,2)} 2 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO FmtType:MASTERNUMC ChngTag:Re place1/ARDivisionNo$ Notes: {AR_16$(3,7)} 3 InvoiceNo . . . . . . . . . . 7 SYY Invoice Number. . . . . . . . .INVOICE FmtType:MASTERNUM Notes: {AR_16$(10,7)} 4 InvoiceType . . . . . . . . . 2 SYY Invoice Type. . . . . . . . . . Valid:CA,CM,DM,FC,IN,PP,PY, BA,BC,BF Notes: CA=Cash, CM=Credit Memo, DM=Debit Memo, FC=Finance Charge, IN=Invoice, PP=PrePayment, PY=Payment, BA=Balance Forward Adjustment, BC=Balance Forward Other Charges, BF=Balance Forward {AR_16$(17,2)} 5 ScheduleSeqNo . . . . . . . . 6 SNY Schedule Sequence Number. . . . Mask:000000 FmtType:ZEROFILL Notes: {AR_16$(19,2)} 6 TaxCode . . . . . . . . . . . 15 SYN Tax Code. . . . . . . . . . . .TAXCODE Notes: {AR_16$(21,15)} 7 ExemptionNo . . . . . . . . . 20 SNN Exemption Number. . . . . . . . Notes: {AR_16$(36,20)} 8 Overridden. . . . . . . . . . 1 SYN Overridden. . . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {AR_16$(56,1)} 9 TaxableSalesAmt . . . . . . . 14.2 NNN Taxable Sales Amount. . . . . .SALESAMOUNT Mask:#,###,###,###.00- ChngTag:Sum Notes: {AR_16[0]} 10 NonTaxableSalesAmt. . . . . . 14.2 NNN NonTaxable Sales Amount . . . .SALESAMOUNT Mask:#,###,###,###.00- ChngTag:Sum Notes: {AR_16[3]} 11 ExemptSalesAmt. . . . . . . . 14.2 NNN Exempt Sales Amount . . . . . .SALESAMOUNT Mask:#,###,###,###.00- ChngTag:Sum Notes: {AR_16[4]} 12 TaxableFreightAmt . . . . . . 13.2 NNN Taxable Freight Amount. . . . .AMOUNT Mask:###,###,###.00 ChngTag:Sum Notes: {AR_16[1]} 13 TaxableTaxAmt . . . . . . . . 13.2 NNN Taxable Tax Amount. . . . . . .AMOUNT Mask:###,###,###.00 ChngTag:Sum Notes: {AR_16[2]} 14 SalesTaxAmt . . . . . . . . . 13.2 NNN Sales Tax Amount. . . . . . . .AMOUNT Mask:###,###,###.00 ChngTag:Sum Notes: {AR_16[7]} 15 NonTaxableFreightAmt. . . . . 13.2 NNN Non Taxable Freight Amount. . .AMOUNT Mask:###,###,###.00 ChngTag:Sum Notes: {AR_16[8]} 16 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y ChngTag:Max Notes: YYYYMMDD 17 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y ChngTag:CopyMax/D ateUpdated$ 18 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL ChngTag:Copy Max/DateUpdated$