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$