Table: Invoice Audit Lines

Table: POINVAL
View: PO0410
Record Length: 1718

Flags: A R 

Keys: 2

Title Flags Fields
Detail Key DAYENDSEQ, INVAHSEQ, INVALSEQ
Detail Number DAYENDSEQ, INVAHSEQ, DETAILNUM, INVALSEQ

Fields: 144

Field Type Title Presentation
DAYENDSEQ BCD*10.0 Day End Number
INVAHSEQ BCD*10.0 Processing Sequence
INVALSEQ BCD*10.0 Line Number
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
TRANSTYPE Integer Transaction Type
OEONUMBER String*22 Order Number Mask: %-22C
ITEMEXISTS Boolean Item Exists List:2 entries
0 = No
1 = Yes
ITEMNO String*24 Item Number Mask: %-24C
LOCATION String*6 Location Mask: %-6N
ITEMDESC String*60 Item Description
CNTLACCT String*6 Control Account
TAXCLASS1 Integer Tax Class 1
TAXCLASS2 Integer Tax Class 2
TAXCLASS3 Integer Tax Class 3
TAXCLASS4 Integer Tax Class 4
TAXCLASS5 Integer Tax Class 5
RQRECEIVED BCD*10.4 Quantity Received
RCPUNIT String*10 Unit of Measure Mask: %-10c
CONVERSION BCD*10.6 Conversion Factor to Stocking
SQRECEIVED BCD*10.4 Stocking Quantity Received
STOCKUNIT String*10 Unit of Measure Mask: %-10c
COSTUNIT String*10 Costing unit of measure Mask: %-10c
UNITCOST BCD*10.6 Unit Cost
PRUNITCOST BCD*10.6 Unit Cost
LOADEDCOST BCD*10.6 Fully-loaded cost
FCEXTENDED BCD*10.3 Func. Extended Amount
SCEXTENDED BCD*10.3 Extended 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
FCPRORATED BCD*10.3 Func. Total Prorate Allocated
SCPRORATED BCD*10.3 Total Prorate Allocated
FCTAXINCL BCD*10.3 Func. Tax Included in Price
SCTAXINCL BCD*10.3 Tax Included in Price
FCTAXEXCL BCD*10.3 Func. Tax Excluded from Price
SCTAXEXCL BCD*10.3 Tax Excluded from 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
TAXINCLUD1 Boolean Tax Includable 1 List:2 entries
0 = No
1 = Yes
TAXINCLUD2 Boolean Tax Includable 2 List:2 entries
0 = No
1 = Yes
TAXINCLUD3 Boolean Tax Includable 3 List:2 entries
0 = No
1 = Yes
TAXINCLUD4 Boolean Tax Includable 4 List:2 entries
0 = No
1 = Yes
TAXINCLUD5 Boolean Tax Includable 5 List:2 entries
0 = No
1 = Yes
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
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
GLCLEARING String*45 Receipt Clearing Account Mask: %-45C
GLITEM String*45 G/L Item Mask: %-45C
GLISPOSTED Boolean G/L data to be posted? List:2 entries
0 = No
1 = Yes
RQRECTOTAL BCD*10.4 Total Quantity Received
SQRECTOTAL BCD*10.4 Total Stock Quantity Received
FCEXTTOTAL BCD*10.3 Functional Total Cost
SCEXTTOTAL BCD*10.3 Total Cost
STOCKITEM Boolean Stock Item List:2 entries
0 = No
1 = Yes
PONUMBER String*22 Purchase Order Number Mask: %-22C
RCPNUMBER String*22 Receipt Number Mask: %-22C
DISCPCT BCD*5.5 Discount Percentage
FCDISCOUNT BCD*10.3 Func. Discount Amount
SCDISCOUNT BCD*10.3 Discount Amount
FCDISCTOT BCD*10.3 Functional Total Discount
SCDISCTOT BCD*10.3 Total Discount
VALUES Long Optional Fields
TERMDISCBL Integer Payment Discountable List:2 entries
0 = No
1 = Yes
RCPLSEQ BCD*10.0 Receipt Line Sequence
INVLSEQ BCD*10.0 Invoice Line Sequence
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
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
COMMENT String*250 Comment
CONTRACT String*16 Contract Mask: %-16C
PROJECT String*16 Project Mask: %-16N
CCATEGORY String*16 (Cost) Category Mask: %-16N
COSTCLASS Integer Cost Class List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
BILLTYPE Integer Billing Type List:4 entries
0 =
1 = Non-billable
2 = Billable
3 = No Charge
BILLRATE BCD*10.6 Billing Rate
BILLCURR String*3 Billing Currency Mask: %-3N
ARITEMNO String*16 A/R Item Number Mask: %-16C
ARUNIT String*10 A/R Unit of Measure Mask: %-10C
RTGPERCENT BCD*5.5 Retainage Percentage
RTGDAYS Integer Retention Period
SCRTGAMT BCD*10.3 Retainage Amount
FCRTGAMTOT BCD*10.3 Func. Total Retainage Amount
SCRTGAMTOT BCD*10.3 Total Retainage Amount
RTGDATEDUE Date Retainage Due Date
RTGAMTOVER Boolean Retainage Amount Overridden List:2 entries
0 = No
1 = Yes
RTGDDTOVER Boolean Retainage Due Date Overridden List:2 entries
0 = No
1 = Yes
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
DFCUNITCST BCD*10.6 Func. Unit Cost Difference
DSCUNITCST BCD*10.6 Unit Cost Difference
DBILLRATE BCD*10.6 Billing Rate Difference
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
RFAPALLO BCD*10.3 Func. A/P Retainage Tax Allocd.
RFAPEXPS BCD*10.3 Func. A/P Retainage Tax Expensed
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
DEFEXTWGHT BCD*10.4 Default Extended Weight
TOTDEFEXWT BCD*10.4 Total Def. Ext. Weight
DETAILNUM Integer Detail Number

This page was generated on 2022-Aug-18

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