View: Invoice Audit Lines

RotoID: PO0410
Table: POINVAL
Protocol: Detail
DLL:POINVAL

Compositions: 2

RotoID Tables Title DLL
PO0409 POINVAH Invoice Audit Headers POINVAH
PO0448 POINALO Invoice Audit Line Opt. Fields POINALO

Keys: 2

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

Fields: 140

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 
TRANSTYPE 4 Integer Transaction Type E A 
OEONUMBER 5 String*22 Order Number E A  Mask: %-22C
ITEMEXISTS 6 Boolean Item Exists E A  List:2 entries
0 = No
1 = Yes
ITEMNO 7 String*24 Item Number E A  Mask: %-24C
LOCATION 8 String*6 Location E A  Mask: %-6N
ITEMDESC 9 String*60 Item Description E A 
CNTLACCT 10 String*6 Control Account E A 
TAXCLASS1 11 Integer Tax Class 1 E A 
TAXCLASS2 12 Integer Tax Class 2 E A 
TAXCLASS3 13 Integer Tax Class 3 E A 
TAXCLASS4 14 Integer Tax Class 4 E A 
TAXCLASS5 15 Integer Tax Class 5 E A 
RQRECEIVED 16 BCD*10.4 Quantity Received E A 
RCPUNIT 17 String*10 Unit of Measure E A  Mask: %-10c
CONVERSION 18 BCD*10.6 Conversion Factor to Stocking E A 
SQRECEIVED 19 BCD*10.4 Stocking Quantity Received E A 
STOCKUNIT 20 String*10 Unit of Measure E A  Mask: %-10c
COSTUNIT 21 String*10 Costing unit of measure E A  Mask: %-10c
UNITCOST 22 BCD*10.6 Unit Cost E A 
PRUNITCOST 23 BCD*10.6 Unit Cost E A 
LOADEDCOST 24 BCD*10.6 Fully-loaded cost E A 
FCEXTENDED 25 BCD*10.3 Func. Extended Amount E A 
SCEXTENDED 26 BCD*10.3 Extended Amount E A 
FCBASEALLO 27 BCD*10.3 Func. Base to Allocate E A 
SCBASEALLO 28 BCD*10.3 Base to Allocate E A 
FCTAXALLO 29 BCD*10.3 Func. Total Tax Allocated E A 
SCTAXALLO 30 BCD*10.3 Total Tax Allocated E A 
FCPRORATED 31 BCD*10.3 Func. Total Prorate Allocated E A 
SCPRORATED 32 BCD*10.3 Total Prorate Allocated E A 
FCTAXINCL 33 BCD*10.3 Func. Tax Included in Price E A 
SCTAXINCL 34 BCD*10.3 Tax Included in Price E A 
FCTAXEXCL 35 BCD*10.3 Func. Tax Excluded from Price E A 
SCTAXEXCL 36 BCD*10.3 Tax Excluded from Price E A 
TAXBASE1 37 BCD*10.3 Tax Base 1 E A 
TAXBASE2 38 BCD*10.3 Tax Base 2 E A 
TAXBASE3 39 BCD*10.3 Tax Base 3 E A 
TAXBASE4 40 BCD*10.3 Tax Base 4 E A 
TAXBASE5 41 BCD*10.3 Tax Base 5 E A 
TAXINCLUD1 42 Boolean Tax Includable 1 E A  List:2 entries
0 = No
1 = Yes
TAXINCLUD2 43 Boolean Tax Includable 2 E A  List:2 entries
0 = No
1 = Yes
TAXINCLUD3 44 Boolean Tax Includable 3 E A  List:2 entries
0 = No
1 = Yes
TAXINCLUD4 45 Boolean Tax Includable 4 E A  List:2 entries
0 = No
1 = Yes
TAXINCLUD5 46 Boolean Tax Includable 5 E A  List:2 entries
0 = No
1 = Yes
TAXAMOUNT1 47 BCD*10.3 Tax Amount 1 E A 
TAXAMOUNT2 48 BCD*10.3 Tax Amount 2 E A 
TAXAMOUNT3 49 BCD*10.3 Tax Amount 3 E A 
TAXAMOUNT4 50 BCD*10.3 Tax Amount 4 E A 
TAXAMOUNT5 51 BCD*10.3 Tax Amount 5 E A 
TXRECVAMT1 52 BCD*10.3 Tax Recoverable Amount 1 E A 
TXRECVAMT2 53 BCD*10.3 Tax Recoverable Amount 2 E A 
TXRECVAMT3 54 BCD*10.3 Tax Recoverable Amount 3 E A 
TXRECVAMT4 55 BCD*10.3 Tax Recoverable Amount 4 E A 
TXRECVAMT5 56 BCD*10.3 Tax Recoverable Amount 5 E A 
TXEXPSAMT1 57 BCD*10.3 Tax Expense Amount 1 E A 
TXEXPSAMT2 58 BCD*10.3 Tax Expense Amount 2 E A 
TXEXPSAMT3 59 BCD*10.3 Tax Expense Amount 3 E A 
TXEXPSAMT4 60 BCD*10.3 Tax Expense Amount 4 E A 
TXEXPSAMT5 61 BCD*10.3 Tax Expense Amount 5 E A 
GLCLEARING 62 String*45 Receipt Clearing Account E A  Mask: %-45C
GLITEM 63 String*45 G/L Item E A  Mask: %-45C
GLISPOSTED 64 Boolean G/L data to be posted? E A  List:2 entries
0 = No
1 = Yes
RQRECTOTAL 65 BCD*10.4 Total Quantity Received E A 
SQRECTOTAL 66 BCD*10.4 Total Stock Quantity Received E A 
FCEXTTOTAL 67 BCD*10.3 Functional Total Cost E A 
SCEXTTOTAL 68 BCD*10.3 Total Cost E A 
STOCKITEM 69 Boolean Stock Item E A  List:2 entries
0 = No
1 = Yes
PONUMBER 70 String*22 Purchase Order Number E A  Mask: %-22C
RCPNUMBER 71 String*22 Receipt Number E A  Mask: %-22C
DISCPCT 72 BCD*5.5 Discount Percentage E A 
FCDISCOUNT 73 BCD*10.3 Func. Discount Amount E A 
SCDISCOUNT 74 BCD*10.3 Discount Amount E A 
FCDISCTOT 75 BCD*10.3 Functional Total Discount E A 
SCDISCTOT 76 BCD*10.3 Total Discount E A 
VALUES 77 Long Optional Fields E A C 
TERMDISCBL 78 Integer Payment Discountable E A  List:2 entries
0 = No
1 = Yes
RCPLSEQ 79 BCD*10.0 Receipt Line Sequence E A 
INVLSEQ 80 BCD*10.0 Invoice Line Sequence E A 
FCTAXRECV 81 BCD*10.3 Func. Total Tax Recoverable E A 
SCTAXRECV 82 BCD*10.3 Total Tax Recoverable E A 
FCTAXEXPS 83 BCD*10.3 Func. Total Tax Expensed E A 
SCTAXEXPS 84 BCD*10.3 Total Tax Expensed E A 
FCTAXAMT1 85 BCD*10.3 Func. Tax Amount 1 E A 
FCTAXAMT2 86 BCD*10.3 Func. Tax Amount 2 E A 
FCTAXAMT3 87 BCD*10.3 Func. Tax Amount 3 E A 
FCTAXAMT4 88 BCD*10.3 Func. Tax Amount 4 E A 
FCTAXAMT5 89 BCD*10.3 Func. Tax Amount 5 E A 
COMMENT 90 String*250 Comment E A 
CONTRACT 91 String*16 Contract E A  Mask: %-16C
PROJECT 92 String*16 Project E A  Mask: %-16N
CCATEGORY 93 String*16 (Cost) Category E A  Mask: %-16N
COSTCLASS 94 Integer Cost Class E A  List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
BILLTYPE 95 Integer Billing Type E A  List:4 entries
0 =
1 = Non-billable
2 = Billable
3 = No Charge
BILLRATE 96 BCD*10.6 Billing Rate E A 
BILLCURR 97 String*3 Billing Currency E A  Mask: %-3N
ARITEMNO 98 String*16 A/R Item Number E A  Mask: %-16C
ARUNIT 99 String*10 A/R Unit of Measure E A  Mask: %-10C
RTGPERCENT 100 BCD*5.5 Retainage Percentage E A 
RTGDAYS 101 Integer Retention Period E A 
SCRTGAMT 102 BCD*10.3 Retainage Amount E A 
FCRTGAMTOT 103 BCD*10.3 Func. Total Retainage Amount E A 
SCRTGAMTOT 104 BCD*10.3 Total Retainage Amount E A 
RTGDATEDUE 105 Date Retainage Due Date E A 
RTGAMTOVER 106 Boolean Retainage Amount Overridden E A  List:2 entries
0 = No
1 = Yes
RTGDDTOVER 107 Boolean Retainage Due Date Overridden E A  List:2 entries
0 = No
1 = Yes
GLOVERHEAD 108 String*45 Overhead Account E A  Mask: %-45C
GLLABOR 109 String*45 Labor Burden Account E A  Mask: %-45C
FCOVRHDAMT 110 BCD*10.3 Func. Overhead Amount E A 
SCOVRHDAMT 111 BCD*10.3 Overhead Amount E A 
FCLABORAMT 112 BCD*10.3 Func. Labor Burden Amount E A 
SCLABORAMT 113 BCD*10.3 Labor Burden Amount E A 
DFCUNITCST 114 BCD*10.6 Func. Unit Cost Difference E A 
DSCUNITCST 115 BCD*10.6 Unit Cost Difference E A 
DBILLRATE 116 BCD*10.6 Billing Rate Difference E A 
PMTRANSNUM 117 Long PJC Transaction Number E A 
RCTAXALLO 118 BCD*10.3 Rptg. Total Tax Allocated E A 
RCTAXRECV 119 BCD*10.3 Rptg. Total Tax Recoverable E A 
RCTAXEXPS 120 BCD*10.3 Rptg. Total Tax Expensed E A 
RCTAXINCL 121 BCD*10.3 Rptg. Total Tax Included E A 
TARAMOUNT1 122 BCD*10.3 Tax Reporting Amount 1 E A 
TARAMOUNT2 123 BCD*10.3 Tax Reporting Amount 2 E A 
TARAMOUNT3 124 BCD*10.3 Tax Reporting Amount 3 E A 
TARAMOUNT4 125 BCD*10.3 Tax Reporting Amount 4 E A 
TARAMOUNT5 126 BCD*10.3 Tax Reporting Amount 5 E A 
SCRAXALLO 127 BCD*10.3 Total Rtg. Tax Allocated E A 
FCRAXALLO 128 BCD*10.3 Func. Total Rtg. Tax Allocated E A 
SCRAXEXPS 129 BCD*10.3 Total Rtg. Tax Expensed E A 
FCRAXEXPS 130 BCD*10.3 Func. Total Rtg. Tax Expensed E A 
RFAPALLO 131 BCD*10.3 Func. A/P Retainage Tax Allocd. E A 
RFAPEXPS 132 BCD*10.3 Func. A/P Retainage Tax Expensed E A 
RFAPAMT1 133 BCD*10.3 Func. A/P Retainage Tax Amount 1 E A 
RFAPAMT2 134 BCD*10.3 Func. A/P Retainage Tax Amount 2 E A 
RFAPAMT3 135 BCD*10.3 Func. A/P Retainage Tax Amount 3 E A 
RFAPAMT4 136 BCD*10.3 Func. A/P Retainage Tax Amount 4 E A 
RFAPAMT5 137 BCD*10.3 Func. A/P Retainage Tax Amount 5 E A 
DEFEXTWGHT 138 BCD*10.4 Default Extended Weight E A 
TOTDEFEXWT 139 BCD*10.4 Total Def. Ext. Weight E A 
DETAILNUM 140 Integer Detail Number E A 

This page was generated on 2021-Nov-24

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