# Table: Invoice Audit Costs

Table: POINVAS
View: PO0412
Record length: 1740
Flags: A R

## Keys: 1

Title | Flags | Fields
--- | --- | ---
Detail Key |  | DAYENDSEQ, INVAHSEQ, INVASSEQ

## Fields: 151

Field | Type | Title | Presentation
--- | --- | --- | ---
DAYENDSEQ | BCD*10.0 | Day End Number |
INVAHSEQ | BCD*10.0 | Processing Sequence |
INVASSEQ | BCD*10.0 | Cost Number |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
TRANSTYPE | Integer | Transaction Type |
INVNUMBER | String*22 | Invoice Number | Mask: %-22C
PONUMBER | String*22 | Purchase Order Number | Mask: %-22C
RCPNUMBER | String*22 | Receipt Number | Mask: %-22C
ADDCOST | String*6 | Additional Cost | Mask: %-6N
DESCRIPTIO | String*60 | Description |
PRORMETHOD | Integer | Proration Method | List: 5 entries
1 | = | No Proration
2 | = | Prorate by Quantity
3 | = | Prorate by Cost
4 | = | Prorate by Weight
5 | = | Prorate Manually
REPRORATE | Integer | Reproration Method | List: 3 entries
1 | = | Leave
2 | = | Prorate
3 | = | Expense
VENDOR | String*12 | Vendor | Mask: %-12C
VENDORNAME | String*60 | Name |
TAXGROUP | String*12 | Tax Group | Mask: %-12N
TAXAUTH1 | String*12 | Tax Authority 1 |
TAXAUTH2 | String*12 | Tax Authority 2 |
TAXAUTH3 | String*12 | Tax Authority 3 |
TAXAUTH4 | String*12 | Tax Authority 4 |
TAXAUTH5 | String*12 | Tax Authority 5 |
TAXVCLASS1 | Integer | Vendor Tax Class 1 |
TAXVCLASS2 | Integer | Vendor Tax Class 2 |
TAXVCLASS3 | Integer | Vendor Tax Class 3 |
TAXVCLASS4 | Integer | Vendor Tax Class 4 |
TAXVCLASS5 | Integer | Vendor Tax Class 5 |
TAXICLASS1 | Integer | Cost Tax Class 1 |
TAXICLASS2 | Integer | Cost Tax Class 2 |
TAXICLASS3 | Integer | Cost Tax Class 3 |
TAXICLASS4 | Integer | Cost Tax Class 4 |
TAXICLASS5 | Integer | Cost Tax Class 5 |
CURRENCY | String*3 | Currency | Mask: %-3N
EXRATE | BCD*8.7 | Exchange Rate |
RATEDATE | Date | Rate Date |
RATETYPE | String*2 | Rate Type | Mask: %-2N
RATEOPER | Integer | Rate Operation | List: 2 entries
1 | = | *
2 | = | /
RATEOVER | Boolean | Rate Overridden | List: 2 entries
0 | = | No
1 | = | Yes
SCURNDECML | Integer | Decimal Places |
GLEXPACCT | String*45 | Expense Account | Mask: %-45C
GLRETACCT | String*45 | Return Account | Mask: %-45C
FCAMOUNT | BCD*10.3 | Conversion Functional Amount |
SCAMOUNT | BCD*10.3 | Conversion Source Amount |
FCBASEALLO | BCD*10.3 | Func. Base to Allocate |
SCBASEALLO | BCD*10.3 | Base to Allocate |
FCTAXALLO | BCD*10.3 | Func. Total Tax Allocated |
SCTAXALLO | BCD*10.3 | Total Tax Allocated |
FCTAXINCL | BCD*10.3 | Func. Tax Included in Price |
SCTAXINCL | BCD*10.3 | Tax Included in Price |
FCTAXEXCL | BCD*10.3 | Func. Tax Excluded from Price |
SCTAXEXCL | BCD*10.3 | Tax Excluded from Price |
TAXBASE1 | BCD*10.3 | Tax Base 1 |
TAXBASE2 | BCD*10.3 | Tax Base 2 |
TAXBASE3 | BCD*10.3 | Tax Base 3 |
TAXBASE4 | BCD*10.3 | Tax Base 4 |
TAXBASE5 | BCD*10.3 | Tax Base 5 |
TAXINCLUD1 | Boolean | Tax Includable 1 | List: 2 entries
0 | = | No
1 | = | Yes
TAXINCLUD2 | Boolean | Tax Includable 2 | List: 2 entries
0 | = | No
1 | = | Yes
TAXINCLUD3 | Boolean | Tax Includable 3 | List: 2 entries
0 | = | No
1 | = | Yes
TAXINCLUD4 | Boolean | Tax Includable 4 | List: 2 entries
0 | = | No
1 | = | Yes
TAXINCLUD5 | Boolean | Tax Includable 5 | List: 2 entries
0 | = | No
1 | = | Yes
TAXAMOUNT1 | BCD*10.3 | Tax Amount 1 |
TAXAMOUNT2 | BCD*10.3 | Tax Amount 2 |
TAXAMOUNT3 | BCD*10.3 | Tax Amount 3 |
TAXAMOUNT4 | BCD*10.3 | Tax Amount 4 |
TAXAMOUNT5 | BCD*10.3 | Tax Amount 5 |
TXRECVAMT1 | BCD*10.3 | Tax Recoverable Amount 1 |
TXRECVAMT2 | BCD*10.3 | Tax Recoverable Amount 2 |
TXRECVAMT3 | BCD*10.3 | Tax Recoverable Amount 3 |
TXRECVAMT4 | BCD*10.3 | Tax Recoverable Amount 4 |
TXRECVAMT5 | BCD*10.3 | Tax Recoverable Amount 5 |
TXEXPSAMT1 | BCD*10.3 | Tax Expense Amount 1 |
TXEXPSAMT2 | BCD*10.3 | Tax Expense Amount 2 |
TXEXPSAMT3 | BCD*10.3 | Tax Expense Amount 3 |
TXEXPSAMT4 | BCD*10.3 | Tax Expense Amount 4 |
TXEXPSAMT5 | BCD*10.3 | Tax Expense Amount 5 |
INVSSEQG | BCD*10.0 | Invoice Cost Group Sequence |
VALUES | Long | Optional Fields |
TERMDISCBL | Integer | Payment Discountable | List: 2 entries
0 | = | No
1 | = | Yes
RCPSSEQ | BCD*10.0 | Receipt Cost Sequence |
INVSSEQ | BCD*10.0 | Invoice Cost Sequence |
FCTAXRECV | BCD*10.3 | Func. Total Tax Recoverable |
SCTAXRECV | BCD*10.3 | Total Tax Recoverable |
FCTAXEXPS | BCD*10.3 | Func. Total Tax Expensed |
SCTAXEXPS | BCD*10.3 | Total Tax Expensed |
FCTAXAMT1 | BCD*10.3 | Func. Tax Amount 1 |
FCTAXAMT2 | BCD*10.3 | Func. Tax Amount 2 |
FCTAXAMT3 | BCD*10.3 | Func. Tax Amount 3 |
FCTAXAMT4 | BCD*10.3 | Func. Tax Amount 4 |
FCTAXAMT5 | BCD*10.3 | Func. Tax Amount 5 |
GLNOPRORCR | String*45 | Expensed Add'l Cost Clr. Acct. | Mask: %-45C
NOPRORTOGL | Boolean | Exp. Add'l Cost G/L data posted? | List: 2 entries
0 | = | No
1 | = | Yes
COMMENT | String*250 | Comment |
CONTRACT | String*16 | Contract | Mask: %-16C
PROJECT | String*16 | Project | Mask: %-16N
CCATEGORY | String*16 | (Cost) Category | Mask: %-16N
COSTCLASS | Integer | Cost Class | List: 7 entries
0 | = |
1 | = | Labor
2 | = | Material
3 | = | Equipment
4 | = | Subcontractor
5 | = | Overhead
6 | = | Miscellaneous
RESOURCE | String*24 | Resource | Mask: %-24C
BILLTYPE | Integer | Billing Type | List: 4 entries
0 | = |
1 | = | Non-billable
2 | = | Billable
3 | = | No Charge
BILLRATE | BCD*10.6 | Billing Rate |
BILLCURR | String*3 | Billing Currency | Mask: %-3N
ARITEMNO | String*16 | A/R Item Number | Mask: %-16C
ARUNIT | String*10 | A/R Unit of Measure | Mask: %-10C
CALCOVRHD | Boolean | Calculate Overhead | List: 2 entries
0 | = | No
1 | = | Yes
CALCLABOR | Boolean | Calculate Labor | List: 2 entries
0 | = | No
1 | = | Yes
HASRTG | Boolean | Has Retainage | List: 2 entries
0 | = | No
1 | = | Yes
RTGRATE | Integer | Retainage Exchange Rate | List: 2 entries
0 | = | Use Original Document Exchange Rate
1 | = | Use Current Exchange Rate
RTGPERCENT | BCD*5.5 | Retainage Percentage |
RTGDAYS | Integer | Retention Period |
SCRTGAMT | BCD*10.3 | Retainage Amount |
FCRTGAMTOT | BCD*10.3 | Func. Total Retainage Amount |
SCRTGAMTOT | BCD*10.3 | Total Retainage Amount |
RTGDATEDUE | Date | Retainage Due Date |
RTGAMTOVER | Boolean | Retainage Amount Overridden | List: 2 entries
0 | = | No
1 | = | Yes
RTGDDTOVER | Boolean | Retainage Due Date Overridden | List: 2 entries
0 | = | No
1 | = | Yes
GLOVERHEAD | String*45 | Overhead Account | Mask: %-45C
GLLABOR | String*45 | Labor Burden Account | Mask: %-45C
FCOVRHDAMT | BCD*10.3 | Func. Overhead Amount |
SCOVRHDAMT | BCD*10.3 | Overhead Amount |
FCLABORAMT | BCD*10.3 | Func. Labor Burden Amount |
SCLABORAMT | BCD*10.3 | Labor Burden Amount |
PMTRANSNUM | Long | PJC Transaction Number |
TRCURRENCY | String*3 | Tax Reporting Currency | Mask: %-3N
EXRATERC | BCD*8.7 | Tax Reporting Exchange Rate |
RATEDATERC | Date | Tax Reporting Rate Date |
RATETYPERC | String*2 | Tax Reporting Rate Type | Mask: %-2N
RATEOPERRC | Integer | Tax Reporting Rate Operation | List: 2 entries
1 | = | *
2 | = | /
RATERCOVER | Boolean | Tax Reporting Rate Overridden | List: 2 entries
0 | = | No
1 | = | Yes
RCURNDECML | Integer | Tax Reporting Decimal Places |
RCTAXALLO | BCD*10.3 | Rptg. Total Tax Allocated |
RCTAXRECV | BCD*10.3 | Rptg. Total Tax Recoverable |
RCTAXEXPS | BCD*10.3 | Rptg. Total Tax Expensed |
RCTAXINCL | BCD*10.3 | Rptg. Total Tax Included |
TARAMOUNT1 | BCD*10.3 | Tax Reporting Amount 1 |
TARAMOUNT2 | BCD*10.3 | Tax Reporting Amount 2 |
TARAMOUNT3 | BCD*10.3 | Tax Reporting Amount 3 |
TARAMOUNT4 | BCD*10.3 | Tax Reporting Amount 4 |
TARAMOUNT5 | BCD*10.3 | Tax Reporting Amount 5 |
FCAPAMOUNT | BCD*10.3 | Func. A/P Amount |
SCRAXALLO | BCD*10.3 | Total Rtg. Tax Allocated |
FCRAXALLO | BCD*10.3 | Func. Total Rtg. Tax Allocated |
SCRAXEXPS | BCD*10.3 | Total Rtg. Tax Expensed |
FCRAXEXPS | BCD*10.3 | Func. Total Rtg. Tax Expensed |
RFAPALLO | BCD*10.3 | Func. A/P Retainage Tax Allocd. |
RFAPEXPS | BCD*10.3 | Func. A/P Retainage Tax Expensed |
RFAPAMT1 | BCD*10.3 | Func. A/P Retainage Tax Amount 1 |
RFAPAMT2 | BCD*10.3 | Func. A/P Retainage Tax Amount 2 |
RFAPAMT3 | BCD*10.3 | Func. A/P Retainage Tax Amount 3 |
RFAPAMT4 | BCD*10.3 | Func. A/P Retainage Tax Amount 4 |
RFAPAMT5 | BCD*10.3 | Func. A/P Retainage Tax Amount 5 |

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.