AP_OpenInvoiceTaxSummary AP Open Invoice Tax Summary Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: AP_OpenInvoiceTaxSummary_bus,PO_ReturnRegister_upd
SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_OpenInvoiceTaxSummary.M4T"
KPRIMARY: APDivisionNo+VendorNo+InvoiceNo+ScheduleSeqNo+TaxCode
Fld Column Name M/L TUR Description/Notes Class
1 APDivisionNo. . . . . . . . . 2 SNY AP Division Number. . . . . . .APDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {AP_07$(1,2)}
2 VendorNo. . . . . . . . . . . 7 SYY Vendor Number . . . . . . . . .VENDORNO
FmtType:MASTERNUM ChngTag:Rep
lace1/APDivisionNo$ Notes:
{AP_07$(3,7)}
3 InvoiceNo . . . . . . . . . . 10 SNY AP Invoice Number . . . . . . .APINVOICE
Notes: {AP_07$(10,10)}
4 ScheduleSeqNo . . . . . . . . 6 SNY Schedule Sequence Number. . . .
Mask:000000 FmtType:ZEROFILL
Notes: {AP_07$(20,2)}
5 TaxCode . . . . . . . . . . . 15 SYN Tax Code. . . . . . . . . . . .TAXCODE
Notes: {AP_07$(22,15)}
6 ExemptionNo . . . . . . . . . 20 SNN Exemption Number. . . . . . . .
Notes: {AP_07$(37,20)}
7 TaxablePurchasesAmt . . . . . 13.2 NNN Taxable Purchases Amount. . . .AMOUNT
Mask:###,###,###.00-
ChngTag:Sum Notes: {AP_07[0]}
8 TaxableFreightAmt . . . . . . 13.2 NNN Taxable Freight Amount. . . . .AMOUNT
Mask:###,###,###.00-
ChngTag:Sum Notes: {AP_07[1]}
9 TaxableTaxAmt . . . . . . . . 13.2 NNN Taxable Tax Amount. . . . . . .AMOUNT
Mask:###,###,###.00-
ChngTag:Sum Notes: {AP_07[2]}
10 NonTaxablePurchasesAmt. . . . 13.2 NNN Non-Taxable Purchases Amount. .AMOUNT
Mask:###,###,###.00-
ChngTag:Sum Notes: {AP_07[3]}
11 NonTaxableFreightAmt. . . . . 13.2 NNN Non-Taxable Freight Amount. . .AMOUNT
Mask:###,###,###.00-
ChngTag:Sum Notes: {AP_07[4]}
12 ExemptPurchasesAmt. . . . . . 13.2 NNN Exempt Purchases Amount . . . .AMOUNT
Mask:###,###,###.00-
ChngTag:Sum Notes: {AP_07[5]}
13 UseTaxAmt . . . . . . . . . . 13.2 NNN Use Tax Amount. . . . . . . . .AMOUNT
Mask:###,###,###.00-
ChngTag:Sum Notes: {AP_07[6]}
14 NonRecoverableAmt . . . . . . 13.2 NNN Non-Recoverable Amount. . . . .AMOUNT
Mask:##,###,###.00-
ChngTag:Sum Notes: {AP_07[7]}
15 TaxAmt. . . . . . . . . . . . 13.2 NNN Tax Amount. . . . . . . . . . .AMOUNT
Mask:###,###,###.00-
ChngTag:Sum Notes: {AP_07[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 SNN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
ChngTag:CopyMax/DateUpdated$