View: Invoice Audit Costs

RotoID: PO0412
Table: POINVAS
Protocol: Detail
DLL:POINVAS

Compositions: 2

RotoID Tables Title DLL

PO0409 POINVAH Invoice Audit Headers POINVAH
PO0449 POINASO Invoice Audit Cost Opt. Fields POINASO

Keys: 1

Title Fields

Detail Key DAYENDSEQINVAHSEQINVASSEQ

Fields: 147

Field Index Type Title Attributes Presentation

DAYENDSEQ 1 BCD*10.0 Day End Number E A K R 
INVAHSEQ 2 BCD*10.0 Processing Sequence E A K R 
INVASSEQ 3 BCD*10.0 Cost Number E A K R 
TRANSTYPE 4 Integer Transaction Type E A 
INVNUMBER 5 String*22 Invoice Number E A  Mask: %-22C
PONUMBER 6 String*22 Purchase Order Number E A  Mask: %-22C
RCPNUMBER 7 String*22 Receipt Number E A  Mask: %-22C
ADDCOST 8 String*6 Additional Cost E A  Mask: %-6N
DESCRIPTIO 9 String*60 Description E A 
PRORMETHOD 10 Integer Proration Method E A  List:5 entries
1 = No Proration
2 = Prorate by Quantity
3 = Prorate by Cost
4 = Prorate by Weight
5 = Prorate Manually
REPRORATE 11 Integer Reproration Method E A  List:3 entries
1 = Leave
2 = Prorate
3 = Expense
VENDOR 12 String*12 Vendor E A  Mask: %-12C
VENDORNAME 13 String*60 Name E A 
TAXGROUP 14 String*12 Tax Group E A  Mask: %-12N
TAXAUTH1 15 String*12 Tax Authority 1 E A 
TAXAUTH2 16 String*12 Tax Authority 2 E A 
TAXAUTH3 17 String*12 Tax Authority 3 E A 
TAXAUTH4 18 String*12 Tax Authority 4 E A 
TAXAUTH5 19 String*12 Tax Authority 5 E A 
TAXVCLASS1 20 Integer Vendor Tax Class 1 E A 
TAXVCLASS2 21 Integer Vendor Tax Class 2 E A 
TAXVCLASS3 22 Integer Vendor Tax Class 3 E A 
TAXVCLASS4 23 Integer Vendor Tax Class 4 E A 
TAXVCLASS5 24 Integer Vendor Tax Class 5 E A 
TAXICLASS1 25 Integer Cost Tax Class 1 E A 
TAXICLASS2 26 Integer Cost Tax Class 2 E A 
TAXICLASS3 27 Integer Cost Tax Class 3 E A 
TAXICLASS4 28 Integer Cost Tax Class 4 E A 
TAXICLASS5 29 Integer Cost Tax Class 5 E A 
CURRENCY 30 String*3 Currency E A  Mask: %-3N
EXRATE 31 BCD*8.7 Exchange Rate E A 
RATEDATE 32 Date Rate Date E A 
RATETYPE 33 String*2 Rate Type E A  Mask: %-2N
RATEOPER 34 Integer Rate Operation E A  List:2 entries
1 = Multiply
2 = Divide
RATEOVER 35 Boolean Rate Overridden E A  List:2 entries
0 = No
1 = Yes
SCURNDECML 36 Integer Decimal Places E A 
GLEXPACCT 37 String*45 Expense Account E A  Mask: %-45C
GLRETACCT 38 String*45 Return Account E A  Mask: %-45C
FCAMOUNT 39 BCD*10.3 Conversion Functional Amount E A 
SCAMOUNT 40 BCD*10.3 Conversion Source Amount E A 
FCBASEALLO 41 BCD*10.3 Func. Base to Allocate E A 
SCBASEALLO 42 BCD*10.3 Base to Allocate E A 
FCTAXALLO 43 BCD*10.3 Func. Total Tax Allocated E A 
SCTAXALLO 44 BCD*10.3 Total Tax Allocated E A 
FCTAXINCL 45 BCD*10.3 Func. Tax Included in Price E A 
SCTAXINCL 46 BCD*10.3 Tax Included in Price E A 
FCTAXEXCL 47 BCD*10.3 Func. Tax Excluded from Price E A 
SCTAXEXCL 48 BCD*10.3 Tax Excluded from Price E A 
TAXBASE1 49 BCD*10.3 Tax Base 1 E A 
TAXBASE2 50 BCD*10.3 Tax Base 2 E A 
TAXBASE3 51 BCD*10.3 Tax Base 3 E A 
TAXBASE4 52 BCD*10.3 Tax Base 4 E A 
TAXBASE5 53 BCD*10.3 Tax Base 5 E A 
TAXINCLUD1 54 Boolean Tax Includable 1 E A  List:2 entries
0 = No
1 = Yes
TAXINCLUD2 55 Boolean Tax Includable 2 E A  List:2 entries
0 = No
1 = Yes
TAXINCLUD3 56 Boolean Tax Includable 3 E A  List:2 entries
0 = No
1 = Yes
TAXINCLUD4 57 Boolean Tax Includable 4 E A  List:2 entries
0 = No
1 = Yes
TAXINCLUD5 58 Boolean Tax Includable 5 E A  List:2 entries
0 = No
1 = Yes
TAXAMOUNT1 59 BCD*10.3 Tax Amount 1 E A 
TAXAMOUNT2 60 BCD*10.3 Tax Amount 2 E A 
TAXAMOUNT3 61 BCD*10.3 Tax Amount 3 E A 
TAXAMOUNT4 62 BCD*10.3 Tax Amount 4 E A 
TAXAMOUNT5 63 BCD*10.3 Tax Amount 5 E A 
TXRECVAMT1 64 BCD*10.3 Tax Recoverable Amount 1 E A 
TXRECVAMT2 65 BCD*10.3 Tax Recoverable Amount 2 E A 
TXRECVAMT3 66 BCD*10.3 Tax Recoverable Amount 3 E A 
TXRECVAMT4 67 BCD*10.3 Tax Recoverable Amount 4 E A 
TXRECVAMT5 68 BCD*10.3 Tax Recoverable Amount 5 E A 
TXEXPSAMT1 69 BCD*10.3 Tax Expense Amount 1 E A 
TXEXPSAMT2 70 BCD*10.3 Tax Expense Amount 2 E A 
TXEXPSAMT3 71 BCD*10.3 Tax Expense Amount 3 E A 
TXEXPSAMT4 72 BCD*10.3 Tax Expense Amount 4 E A 
TXEXPSAMT5 73 BCD*10.3 Tax Expense Amount 5 E A 
INVSSEQG 74 BCD*10.0 Invoice Cost Group Sequence E A 
VALUES 75 Long Optional Fields E A C 
TERMDISCBL 76 Integer Payment Discountable E A  List:2 entries
0 = No
1 = Yes
RCPSSEQ 77 BCD*10.0 Receipt Cost Sequence E A 
INVSSEQ 78 BCD*10.0 Invoice Cost Sequence E A 
FCTAXRECV 79 BCD*10.3 Func. Total Tax Recoverable E A 
SCTAXRECV 80 BCD*10.3 Total Tax Recoverable E A 
FCTAXEXPS 81 BCD*10.3 Func. Total Tax Expensed E A 
SCTAXEXPS 82 BCD*10.3 Total Tax Expensed E A 
FCTAXAMT1 83 BCD*10.3 Func. Tax Amount 1 E A 
FCTAXAMT2 84 BCD*10.3 Func. Tax Amount 2 E A 
FCTAXAMT3 85 BCD*10.3 Func. Tax Amount 3 E A 
FCTAXAMT4 86 BCD*10.3 Func. Tax Amount 4 E A 
FCTAXAMT5 87 BCD*10.3 Func. Tax Amount 5 E A 
GLNOPRORCR 88 String*45 Expensed Add'l Cost Clr. Acct. E A  Mask: %-45C
NOPRORTOGL 89 Boolean Exp. Add'l Cost G/L data posted? E A  List:2 entries
0 = No
1 = Yes
COMMENT 90 String*250 Comment E A 
CONTRACT 91 String*16 Contract E A  Mask: %-16C
PROJECT 92 String*16 Project E A  Mask: %-16N
CCATEGORY 93 String*16 (Cost) Category E A  Mask: %-16N
COSTCLASS 94 Integer Cost Class E A  List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
RESOURCE 95 String*24 Resource E A  Mask: %-24C
BILLTYPE 96 Integer Billing Type E A  List:4 entries
0 =
1 = Non-billable
2 = Billable
3 = No Charge
BILLRATE 97 BCD*10.6 Billing Rate E A 
BILLCURR 98 String*3 Billing Currency E A  Mask: %-3N
ARITEMNO 99 String*16 A/R Item Number E A  Mask: %-16C
ARUNIT 100 String*10 A/R Unit of Measure E A  Mask: %-10C
CALCOVRHD 101 Boolean Calculate Overhead E A  List:2 entries
0 = No
1 = Yes
CALCLABOR 102 Boolean Calculate Labor E A  List:2 entries
0 = No
1 = Yes
HASRTG 103 Boolean Has Retainage E A  List:2 entries
0 = No
1 = Yes
RTGRATE 104 Integer Retainage Exchange Rate E A  List:2 entries
0 = Use Original Document Exchange Rate
1 = Use Current Exchange Rate
RTGPERCENT 105 BCD*5.5 Retainage Percentage E A 
RTGDAYS 106 Integer Retention Period E A 
SCRTGAMT 107 BCD*10.3 Retainage Amount E A 
FCRTGAMTOT 108 BCD*10.3 Func. Total Retainage Amount E A 
SCRTGAMTOT 109 BCD*10.3 Total Retainage Amount E A 
RTGDATEDUE 110 Date Retainage Due Date E A 
RTGAMTOVER 111 Boolean Retainage Amount Overridden E A  List:2 entries
0 = No
1 = Yes
RTGDDTOVER 112 Boolean Retainage Due Date Overridden E A  List:2 entries
0 = No
1 = Yes
GLOVERHEAD 113 String*45 Overhead Account E A  Mask: %-45C
GLLABOR 114 String*45 Labor Burden Account E A  Mask: %-45C
FCOVRHDAMT 115 BCD*10.3 Func. Overhead Amount E A 
SCOVRHDAMT 116 BCD*10.3 Overhead Amount E A 
FCLABORAMT 117 BCD*10.3 Func. Labor Burden Amount E A 
SCLABORAMT 118 BCD*10.3 Labor Burden Amount E A 
PMTRANSNUM 119 Long PJC Transaction Number E A 
TRCURRENCY 120 String*3 Tax Reporting Currency E A  Mask: %-3N
EXRATERC 121 BCD*8.7 Tax Reporting Exchange Rate E A 
RATEDATERC 122 Date Tax Reporting Rate Date E A 
RATETYPERC 123 String*2 Tax Reporting Rate Type E A  Mask: %-2N
RATEOPERRC 124 Integer Tax Reporting Rate Operation E A  List:2 entries
1 = Multiply
2 = Divide
RATERCOVER 125 Boolean Tax Reporting Rate Overridden E A  List:2 entries
0 = No
1 = Yes
RCURNDECML 126 Integer Tax Reporting Decimal Places E A 
RCTAXALLO 127 BCD*10.3 Rptg. Total Tax Allocated E A 
RCTAXRECV 128 BCD*10.3 Rptg. Total Tax Recoverable E A 
RCTAXEXPS 129 BCD*10.3 Rptg. Total Tax Expensed E A 
RCTAXINCL 130 BCD*10.3 Rptg. Total Tax Included E A 
TARAMOUNT1 131 BCD*10.3 Tax Reporting Amount 1 E A 
TARAMOUNT2 132 BCD*10.3 Tax Reporting Amount 2 E A 
TARAMOUNT3 133 BCD*10.3 Tax Reporting Amount 3 E A 
TARAMOUNT4 134 BCD*10.3 Tax Reporting Amount 4 E A 
TARAMOUNT5 135 BCD*10.3 Tax Reporting Amount 5 E A 
FCAPAMOUNT 136 BCD*10.3 Func. A/P Amount E A 
SCRAXALLO 137 BCD*10.3 Total Rtg. Tax Allocated E A 
FCRAXALLO 138 BCD*10.3 Func. Total Rtg. Tax Allocated E A 
SCRAXEXPS 139 BCD*10.3 Total Rtg. Tax Expensed E A 
FCRAXEXPS 140 BCD*10.3 Func. Total Rtg. Tax Expensed E A 
RFAPALLO 141 BCD*10.3 Func. A/P Retainage Tax Allocd. E A 
RFAPEXPS 142 BCD*10.3 Func. A/P Retainage Tax Expensed E A 
RFAPAMT1 143 BCD*10.3 Func. A/P Retainage Tax Amount 1 E A 
RFAPAMT2 144 BCD*10.3 Func. A/P Retainage Tax Amount 2 E A 
RFAPAMT3 145 BCD*10.3 Func. A/P Retainage Tax Amount 3 E A 
RFAPAMT4 146 BCD*10.3 Func. A/P Retainage Tax Amount 4 E A 
RFAPAMT5 147 BCD*10.3 Func. A/P Retainage Tax Amount 5 E A