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