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=*
2=/
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 2008-Apr-11

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