Table: Invoice Audit Prorate Lines

Table: POINVAQ
View: PO0411
Record Length: 1574

Flags: A R 

Keys: 2

Title Flags Fields
Detail DAYENDSEQ, INVAHSEQ, INVALSEQ, INVASSEQ
Currency DAYENDSEQ, INVAHSEQ, INVALSEQ, CURRENCY, INVASSEQ

Fields: 148

Field Type Title Presentation
DAYENDSEQ BCD*10.0 Day End Number
INVAHSEQ BCD*10.0 Processing Sequence
INVALSEQ BCD*10.0 Line Number
INVASSEQ BCD*10.0 Cost Number
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
GLITEM String*45 G/L Item Mask: %-45C
GLEXPENSE String*45 Return Account Mask: %-45C
GLCLEARING String*45 Receipt Clearing Account Mask: %-45C
POSTCLEARI Boolean Post to clearing account? List:2 entries
0 = No
1 = Yes
CURRENCY String*3 Currency Mask: %-3N
SCURNDECML Integer Decimal Places
FCITEM BCD*10.3 Func. Item Amount
SCITEM BCD*10.3 Item amount
FCEXPENSE BCD*10.3 Func. Expensed Amount
SCEXPENSE BCD*10.3 Expensed amount
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
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
FCTAXINCL BCD*10.3 Func. Tax Included in Price
SCTAXINCL BCD*10.3 Tax Included in 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
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
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
BILLRATE BCD*10.6 Billing Rate
BCBILLRATE BCD*10.6 (BC) Billing Rate
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
TXBASETOT1 BCD*10.3 Total Tax Base 1
TXBASETOT2 BCD*10.3 Total Tax Base 2
TXBASETOT3 BCD*10.3 Total Tax Base 3
TXBASETOT4 BCD*10.3 Total Tax Base 4
TXBASETOT5 BCD*10.3 Total Tax Base 5
TXALLOAMT1 BCD*10.3 Tax Allocated Amount 1
TXALLOAMT2 BCD*10.3 Tax Allocated Amount 2
TXALLOAMT3 BCD*10.3 Tax Allocated Amount 3
TXALLOAMT4 BCD*10.3 Tax Allocated Amount 4
TXALLOAMT5 BCD*10.3 Tax Allocated 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
BLRTTOT BCD*10.6 Total Billing Rate
BCBLRTTOT BCD*10.6 (BC) Total Billing Rate
FCRTGAMTOT BCD*10.3 Func. Total Retainage Amount
SCRTGAMTOT BCD*10.3 Total Retainage Amount
RTGPERCENT BCD*5.5 Retainage Percentage
BCRATE BCD*8.7 Billing Currency Conversion Rate
BCRATEDATE Date Billing Currency Conv. Rate Date
BCRATETYPE String*2 Billing Currency Conv. Rate Type Mask: %-2N
BCRATEOPER Integer Billing Curr. Cv. Rate Operation List:2 entries
1 = Multiply
2 = Divide
BCRATEXIST Boolean Billing Curr. Conv. Rate Exists List:2 entries
0 = No
1 = Yes
PMTRANSNUM Long PJC Transaction Number
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
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
TFALLOAMT1 BCD*10.3 Func. Tax Allocated Amount 1
TFALLOAMT2 BCD*10.3 Func. Tax Allocated Amount 2
TFALLOAMT3 BCD*10.3 Func. Tax Allocated Amount 3
TFALLOAMT4 BCD*10.3 Func. Tax Allocated Amount 4
TFALLOAMT5 BCD*10.3 Func. Tax Allocated Amount 5
TFRECVAMT1 BCD*10.3 Func. Tax Recoverable Amount 1
TFRECVAMT2 BCD*10.3 Func. Tax Recoverable Amount 2
TFRECVAMT3 BCD*10.3 Func. Tax Recoverable Amount 3
TFRECVAMT4 BCD*10.3 Func. Tax Recoverable Amount 4
TFRECVAMT5 BCD*10.3 Func. Tax Recoverable Amount 5
TFEXPSAMT1 BCD*10.3 Func. Tax Expense Amount 1
TFEXPSAMT2 BCD*10.3 Func. Tax Expense Amount 2
TFEXPSAMT3 BCD*10.3 Func. Tax Expense Amount 3
TFEXPSAMT4 BCD*10.3 Func. Tax Expense Amount 4
TFEXPSAMT5 BCD*10.3 Func. Tax Expense Amount 5
TRALLOAMT1 BCD*10.3 Tax Reporting Allocated Amount 1
TRALLOAMT2 BCD*10.3 Tax Reporting Allocated Amount 2
TRALLOAMT3 BCD*10.3 Tax Reporting Allocated Amount 3
TRALLOAMT4 BCD*10.3 Tax Reporting Allocated Amount 4
TRALLOAMT5 BCD*10.3 Tax Reporting Allocated Amount 5
TRRECVAMT1 BCD*10.3 Tax Reporting Recoverable Amt. 1
TRRECVAMT2 BCD*10.3 Tax Reporting Recoverable Amt. 2
TRRECVAMT3 BCD*10.3 Tax Reporting Recoverable Amt. 3
TRRECVAMT4 BCD*10.3 Tax Reporting Recoverable Amt. 4
TRRECVAMT5 BCD*10.3 Tax Reporting Recoverable Amt. 5
TREXPSAMT1 BCD*10.3 Tax Reporting Expense Amount 1
TREXPSAMT2 BCD*10.3 Tax Reporting Expense Amount 2
TREXPSAMT3 BCD*10.3 Tax Reporting Expense Amount 3
TREXPSAMT4 BCD*10.3 Tax Reporting Expense Amount 4
TREXPSAMT5 BCD*10.3 Tax Reporting Expense Amount 5
SCAPAMOUNT BCD*10.3 A/P Amount
FCAPAMOUNT BCD*10.3 Func. A/P Amount
RXAPALLO BCD*10.3 A/P Retainage Tax Allocated
RFAPALLO BCD*10.3 Func. A/P Retainage Tax Allocd.
RXAPEXPS BCD*10.3 A/P Retainage Tax Expensed
RFAPEXPS BCD*10.3 Func. A/P Retainage Tax Expensed
RXAPBASE1 BCD*10.3 A/P Retainage Tax Base 1
RXAPBASE2 BCD*10.3 A/P Retainage Tax Base 2
RXAPBASE3 BCD*10.3 A/P Retainage Tax Base 3
RXAPBASE4 BCD*10.3 A/P Retainage Tax Base 4
RXAPBASE5 BCD*10.3 A/P Retainage Tax Base 5
RXAPAMT1 BCD*10.3 A/P Retainage Tax Amount 1
RXAPAMT2 BCD*10.3 A/P Retainage Tax Amount 2
RXAPAMT3 BCD*10.3 A/P Retainage Tax Amount 3
RXAPAMT4 BCD*10.3 A/P Retainage Tax Amount 4
RXAPAMT5 BCD*10.3 A/P Retainage Tax Amount 5
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

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).