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 DAYENDSEQ, INVAHSEQ, INVASSEQ

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 

This page was generated on 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).