Table: Invoice Audit Costs

Table: POINVAS
View: PO0412
Record Length: 1740

Flags: A R 

Keys: 1

Title Flags Fields

Detail Key DAYENDSEQINVAHSEQINVASSEQ

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 = Multiply
2 = Divide
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 = Multiply
2 = Divide
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