Table: Invoice Audit Prorate Lines

Table: POINVAQ
View: PO0411
Record Length: 1574

Flags: A R 

Keys: 2

Title Flags Fields

Detail DAYENDSEQINVAHSEQINVALSEQINVASSEQ
Currency DAYENDSEQINVAHSEQINVALSEQCURRENCYINVASSEQ

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