# View: Invoice Audit Prorate Lines

RotoID: PO0411
Table: POINVAQ
Protocol: Detail
DLL: POINVAQ

## Compositions: 1

RotoID | Tables | Title | DLL
--- | --- | --- | ---
PO0409 | POINVAH | Invoice Audit Headers | POINVAH

## Keys: 2

Title | Fields
--- | ---
Detail | DAYENDSEQ, INVAHSEQ, INVALSEQ, INVASSEQ
Currency | DAYENDSEQ, INVAHSEQ, INVALSEQ, CURRENCY, INVASSEQ

## Fields: 144

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 |
INVALSEQ | 3 | BCD*10.0 | Line Number | E A K R |
INVASSEQ | 4 | BCD*10.0 | Cost Number | E A K R |
GLITEM | 5 | String*45 | G/L Item | E A | Mask: %-45C
GLEXPENSE | 6 | String*45 | Return Account | E A | Mask: %-45C
GLCLEARING | 7 | String*45 | Receipt Clearing Account | E A | Mask: %-45C
POSTCLEARI | 8 | Boolean | Post to clearing account? | E A | List: 2 entries
0 | = | No
1 | = | Yes
CURRENCY | 9 | String*3 | Currency | E A | Mask: %-3N
SCURNDECML | 10 | Integer | Decimal Places | E A |
FCITEM | 11 | BCD*10.3 | Func. Item Amount | E A |
SCITEM | 12 | BCD*10.3 | Item amount | E A |
FCEXPENSE | 13 | BCD*10.3 | Func. Expensed Amount | E A |
SCEXPENSE | 14 | BCD*10.3 | Expensed amount | E A |
FCAMOUNT | 15 | BCD*10.3 | Conversion Functional Amount | E A |
SCAMOUNT | 16 | BCD*10.3 | Conversion Source Amount | E A |
FCBASEALLO | 17 | BCD*10.3 | Func. Base to Allocate | E A |
SCBASEALLO | 18 | BCD*10.3 | Base to Allocate | E A |
FCTAXALLO | 19 | BCD*10.3 | Func. Total Tax Allocated | E A |
SCTAXALLO | 20 | BCD*10.3 | Total Tax Allocated | E A |
FCTAXRECV | 21 | BCD*10.3 | Func. Total Tax Recoverable | E A |
SCTAXRECV | 22 | BCD*10.3 | Total Tax Recoverable | E A |
FCTAXEXPS | 23 | BCD*10.3 | Func. Total Tax Expensed | E A |
SCTAXEXPS | 24 | BCD*10.3 | Total Tax Expensed | E A |
FCTAXINCL | 25 | BCD*10.3 | Func. Tax Included in Price | E A |
SCTAXINCL | 26 | BCD*10.3 | Tax Included in Price | E A |
TAXBASE1 | 27 | BCD*10.3 | Tax Base 1 | E A |
TAXBASE2 | 28 | BCD*10.3 | Tax Base 2 | E A |
TAXBASE3 | 29 | BCD*10.3 | Tax Base 3 | E A |
TAXBASE4 | 30 | BCD*10.3 | Tax Base 4 | E A |
TAXBASE5 | 31 | BCD*10.3 | Tax Base 5 | E A |
TAXAMOUNT1 | 32 | BCD*10.3 | Tax Amount 1 | E A |
TAXAMOUNT2 | 33 | BCD*10.3 | Tax Amount 2 | E A |
TAXAMOUNT3 | 34 | BCD*10.3 | Tax Amount 3 | E A |
TAXAMOUNT4 | 35 | BCD*10.3 | Tax Amount 4 | E A |
TAXAMOUNT5 | 36 | BCD*10.3 | Tax Amount 5 | E A |
FCTAXAMT1 | 37 | BCD*10.3 | Func. Tax Amount 1 | E A |
FCTAXAMT2 | 38 | BCD*10.3 | Func. Tax Amount 2 | E A |
FCTAXAMT3 | 39 | BCD*10.3 | Func. Tax Amount 3 | E A |
FCTAXAMT4 | 40 | BCD*10.3 | Func. Tax Amount 4 | E A |
FCTAXAMT5 | 41 | BCD*10.3 | Func. Tax Amount 5 | E A |
BILLRATE | 42 | BCD*10.6 | Billing Rate | E A |
BCBILLRATE | 43 | BCD*10.6 | (BC) Billing Rate | E A |
GLOVERHEAD | 44 | String*45 | Overhead Account | E A | Mask: %-45C
GLLABOR | 45 | String*45 | Labor Burden Account | E A | Mask: %-45C
FCOVRHDAMT | 46 | BCD*10.3 | Func. Overhead Amount | E A |
SCOVRHDAMT | 47 | BCD*10.3 | Overhead Amount | E A |
FCLABORAMT | 48 | BCD*10.3 | Func. Labor Burden Amount | E A |
SCLABORAMT | 49 | BCD*10.3 | Labor Burden Amount | E A |
TXBASETOT1 | 50 | BCD*10.3 | Total Tax Base 1 | E A |
TXBASETOT2 | 51 | BCD*10.3 | Total Tax Base 2 | E A |
TXBASETOT3 | 52 | BCD*10.3 | Total Tax Base 3 | E A |
TXBASETOT4 | 53 | BCD*10.3 | Total Tax Base 4 | E A |
TXBASETOT5 | 54 | BCD*10.3 | Total Tax Base 5 | E A |
TXALLOAMT1 | 55 | BCD*10.3 | Tax Allocated Amount 1 | E A |
TXALLOAMT2 | 56 | BCD*10.3 | Tax Allocated Amount 2 | E A |
TXALLOAMT3 | 57 | BCD*10.3 | Tax Allocated Amount 3 | E A |
TXALLOAMT4 | 58 | BCD*10.3 | Tax Allocated Amount 4 | E A |
TXALLOAMT5 | 59 | BCD*10.3 | Tax Allocated Amount 5 | E A |
TXRECVAMT1 | 60 | BCD*10.3 | Tax Recoverable Amount 1 | E A |
TXRECVAMT2 | 61 | BCD*10.3 | Tax Recoverable Amount 2 | E A |
TXRECVAMT3 | 62 | BCD*10.3 | Tax Recoverable Amount 3 | E A |
TXRECVAMT4 | 63 | BCD*10.3 | Tax Recoverable Amount 4 | E A |
TXRECVAMT5 | 64 | BCD*10.3 | Tax Recoverable Amount 5 | E A |
TXEXPSAMT1 | 65 | BCD*10.3 | Tax Expense Amount 1 | E A |
TXEXPSAMT2 | 66 | BCD*10.3 | Tax Expense Amount 2 | E A |
TXEXPSAMT3 | 67 | BCD*10.3 | Tax Expense Amount 3 | E A |
TXEXPSAMT4 | 68 | BCD*10.3 | Tax Expense Amount 4 | E A |
TXEXPSAMT5 | 69 | BCD*10.3 | Tax Expense Amount 5 | E A |
BLRTTOT | 70 | BCD*10.6 | Total Billing Rate | E A |
BCBLRTTOT | 71 | BCD*10.6 | (BC) Total Billing Rate | E A |
FCRTGAMTOT | 72 | BCD*10.3 | Func. Total Retainage Amount | E A |
SCRTGAMTOT | 73 | BCD*10.3 | Total Retainage Amount | E A |
RTGPERCENT | 74 | BCD*5.5 | Retainage Percentage | E A |
BCRATE | 75 | BCD*8.7 | Billing Currency Conversion Rate | E A |
BCRATEDATE | 76 | Date | Billing Currency Conv. Rate Date | E A |
BCRATETYPE | 77 | String*2 | Billing Currency Conv. Rate Type | E A | Mask: %-2N
BCRATEOPER | 78 | Integer | Billing Curr. Cv. Rate Operation | E A | List: 2 entries
1 | = | *
2 | = | /
BCRATEXIST | 79 | Boolean | Billing Curr. Conv. Rate Exists | E A | List: 2 entries
0 | = | No
1 | = | Yes
PMTRANSNUM | 80 | Long | PJC Transaction Number | E A |
RCTAXALLO | 81 | BCD*10.3 | Rptg. Total Tax Allocated | E A |
RCTAXRECV | 82 | BCD*10.3 | Rptg. Total Tax Recoverable | E A |
RCTAXEXPS | 83 | BCD*10.3 | Rptg. Total Tax Expensed | E A |
RCTAXINCL | 84 | BCD*10.3 | Rptg. Total Tax Included | E A |
TARAMOUNT1 | 85 | BCD*10.3 | Tax Reporting Amount 1 | E A |
TARAMOUNT2 | 86 | BCD*10.3 | Tax Reporting Amount 2 | E A |
TARAMOUNT3 | 87 | BCD*10.3 | Tax Reporting Amount 3 | E A |
TARAMOUNT4 | 88 | BCD*10.3 | Tax Reporting Amount 4 | E A |
TARAMOUNT5 | 89 | BCD*10.3 | Tax Reporting Amount 5 | E A |
SCRAXALLO | 90 | BCD*10.3 | Total Rtg. Tax Allocated | E A |
FCRAXALLO | 91 | BCD*10.3 | Func. Total Rtg. Tax Allocated | E A |
SCRAXEXPS | 92 | BCD*10.3 | Total Rtg. Tax Expensed | E A |
FCRAXEXPS | 93 | BCD*10.3 | Func. Total Rtg. Tax Expensed | E A |
TFALLOAMT1 | 94 | BCD*10.3 | Func. Tax Allocated Amount 1 | E A |
TFALLOAMT2 | 95 | BCD*10.3 | Func. Tax Allocated Amount 2 | E A |
TFALLOAMT3 | 96 | BCD*10.3 | Func. Tax Allocated Amount 3 | E A |
TFALLOAMT4 | 97 | BCD*10.3 | Func. Tax Allocated Amount 4 | E A |
TFALLOAMT5 | 98 | BCD*10.3 | Func. Tax Allocated Amount 5 | E A |
TFRECVAMT1 | 99 | BCD*10.3 | Func. Tax Recoverable Amount 1 | E A |
TFRECVAMT2 | 100 | BCD*10.3 | Func. Tax Recoverable Amount 2 | E A |
TFRECVAMT3 | 101 | BCD*10.3 | Func. Tax Recoverable Amount 3 | E A |
TFRECVAMT4 | 102 | BCD*10.3 | Func. Tax Recoverable Amount 4 | E A |
TFRECVAMT5 | 103 | BCD*10.3 | Func. Tax Recoverable Amount 5 | E A |
TFEXPSAMT1 | 104 | BCD*10.3 | Func. Tax Expense Amount 1 | E A |
TFEXPSAMT2 | 105 | BCD*10.3 | Func. Tax Expense Amount 2 | E A |
TFEXPSAMT3 | 106 | BCD*10.3 | Func. Tax Expense Amount 3 | E A |
TFEXPSAMT4 | 107 | BCD*10.3 | Func. Tax Expense Amount 4 | E A |
TFEXPSAMT5 | 108 | BCD*10.3 | Func. Tax Expense Amount 5 | E A |
TRALLOAMT1 | 109 | BCD*10.3 | Tax Reporting Allocated Amount 1 | E A |
TRALLOAMT2 | 110 | BCD*10.3 | Tax Reporting Allocated Amount 2 | E A |
TRALLOAMT3 | 111 | BCD*10.3 | Tax Reporting Allocated Amount 3 | E A |
TRALLOAMT4 | 112 | BCD*10.3 | Tax Reporting Allocated Amount 4 | E A |
TRALLOAMT5 | 113 | BCD*10.3 | Tax Reporting Allocated Amount 5 | E A |
TRRECVAMT1 | 114 | BCD*10.3 | Tax Reporting Recoverable Amt. 1 | E A |
TRRECVAMT2 | 115 | BCD*10.3 | Tax Reporting Recoverable Amt. 2 | E A |
TRRECVAMT3 | 116 | BCD*10.3 | Tax Reporting Recoverable Amt. 3 | E A |
TRRECVAMT4 | 117 | BCD*10.3 | Tax Reporting Recoverable Amt. 4 | E A |
TRRECVAMT5 | 118 | BCD*10.3 | Tax Reporting Recoverable Amt. 5 | E A |
TREXPSAMT1 | 119 | BCD*10.3 | Tax Reporting Expense Amount 1 | E A |
TREXPSAMT2 | 120 | BCD*10.3 | Tax Reporting Expense Amount 2 | E A |
TREXPSAMT3 | 121 | BCD*10.3 | Tax Reporting Expense Amount 3 | E A |
TREXPSAMT4 | 122 | BCD*10.3 | Tax Reporting Expense Amount 4 | E A |
TREXPSAMT5 | 123 | BCD*10.3 | Tax Reporting Expense Amount 5 | E A |
SCAPAMOUNT | 124 | BCD*10.3 | A/P Amount | E A |
FCAPAMOUNT | 125 | BCD*10.3 | Func. A/P Amount | E A |
RXAPALLO | 126 | BCD*10.3 | A/P Retainage Tax Allocated | E A |
RFAPALLO | 127 | BCD*10.3 | Func. A/P Retainage Tax Allocd. | E A |
RXAPEXPS | 128 | BCD*10.3 | A/P Retainage Tax Expensed | E A |
RFAPEXPS | 129 | BCD*10.3 | Func. A/P Retainage Tax Expensed | E A |
RXAPBASE1 | 130 | BCD*10.3 | A/P Retainage Tax Base 1 | E A |
RXAPBASE2 | 131 | BCD*10.3 | A/P Retainage Tax Base 2 | E A |
RXAPBASE3 | 132 | BCD*10.3 | A/P Retainage Tax Base 3 | E A |
RXAPBASE4 | 133 | BCD*10.3 | A/P Retainage Tax Base 4 | E A |
RXAPBASE5 | 134 | BCD*10.3 | A/P Retainage Tax Base 5 | E A |
RXAPAMT1 | 135 | BCD*10.3 | A/P Retainage Tax Amount 1 | E A |
RXAPAMT2 | 136 | BCD*10.3 | A/P Retainage Tax Amount 2 | E A |
RXAPAMT3 | 137 | BCD*10.3 | A/P Retainage Tax Amount 3 | E A |
RXAPAMT4 | 138 | BCD*10.3 | A/P Retainage Tax Amount 4 | E A |
RXAPAMT5 | 139 | BCD*10.3 | A/P Retainage Tax Amount 5 | E A |
RFAPAMT1 | 140 | BCD*10.3 | Func. A/P Retainage Tax Amount 1 | E A |
RFAPAMT2 | 141 | BCD*10.3 | Func. A/P Retainage Tax Amount 2 | E A |
RFAPAMT3 | 142 | BCD*10.3 | Func. A/P Retainage Tax Amount 3 | E A |
RFAPAMT4 | 143 | BCD*10.3 | Func. A/P Retainage Tax Amount 4 | E A |
RFAPAMT5 | 144 | BCD*10.3 | Func. A/P Retainage Tax Amount 5 | E A |

This page was generated on 2008-May-01

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