View: Invoice Additional Costs

RotoID: PO0440
Table: POINVS
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:POINVS

Compositions: 8

RotoID Tables Title DLL
PO0420 POINVH1POINVH2 Invoices POINVH
PO0419 Invoice Functions POINVG
PO0421 POINVI Invoice Postings POINVI
PO0441 POINVT Invoice Posting Cost Lines POINVT
PO0438 POINVR Invoice Receipts POINVR
PO0444 POINVS Inv. Add. Costs Superview POINVW
PO0443 POINVSO Invoice Add. Cost Opt. Fields POINVSO
PO0415 POINVD Invoice Cost Distributions POINVD

Keys: 3

Title Fields
Master Key INVHSEQ, INVSREV
Second Key INVHSEQ, INVSSEQ
Detail Locator Key INVSSEQ, INVHSEQ

Fields: 214

Field Index Type Title Attributes Presentation
INVHSEQ 1 BCD*10.0 Invoice Sequence Key E A K R 
INVSREV 2 BCD*10.0 Line Number E A K R 
INVSSEQ 3 BCD*10.0 Invoice Cost Sequence E A 
RCPHSEQ 4 BCD*10.0 Receipt Sequence Key A X 
RCPSSEQ 5 BCD*10.0 Receipt Cost Sequence A X 
RETHSEQ 6 BCD*10.0 Return Sequence Key A X 
RETSSEQ 7 BCD*10.0 Return Cost Sequence A X 
COMPLETION 8 Integer Completion Status A X  List:3 entries
1 = No
2 = Yes
3 = Yes
DTCOMPLETE 9 Date Date Completed A X 
INDBTABLE 10 Boolean Stored in Database Table A C X  List:2 entries
0 = No
1 = Yes
ADDCOST 11 String*6 Additional Cost E A X  Mask: %-6N
GLEXPACCT 12 String*45 Expense Account A X  Mask: %-45C
GLRETACCT 13 String*45 Return Account A X  Mask: %-45C
AMOUNT 14 BCD*10.3 Amount E A X 
PRORMETHOD 15 Integer Proration Method E A P X  List:5 entries
1 = No Proration
2 = Prorate by Quantity
3 = Prorate by Cost
4 = Prorate by Weight
5 = Prorate Manually
REPRORATE 16 Integer Reproration Method A P X  List:3 entries
1 = Leave
2 = Prorate
3 = Expense
DESCRIPTIO 17 String*60 Description E A X 
REFERENCE 18 String*60 Reference E A X 
COMMENT 19 String*250 Comment E A X 
TAXICLASS1 20 Integer Cost Tax Class 1 E A X 
TAXICLASS2 21 Integer Cost Tax Class 2 E A X 
TAXICLASS3 22 Integer Cost Tax Class 3 E A X 
TAXICLASS4 23 Integer Cost Tax Class 4 E A X 
TAXICLASS5 24 Integer Cost Tax Class 5 E A X 
TAXBASE1 25 BCD*10.3 Tax Base 1 A X 
TAXBASE2 26 BCD*10.3 Tax Base 2 A X 
TAXBASE3 27 BCD*10.3 Tax Base 3 A X 
TAXBASE4 28 BCD*10.3 Tax Base 4 A X 
TAXBASE5 29 BCD*10.3 Tax Base 5 A X 
TAXRATE1 30 BCD*8.5 Tax Rate 1 A X 
TAXRATE2 31 BCD*8.5 Tax Rate 2 A X 
TAXRATE3 32 BCD*8.5 Tax Rate 3 A X 
TAXRATE4 33 BCD*8.5 Tax Rate 4 A X 
TAXRATE5 34 BCD*8.5 Tax Rate 5 A X 
TAXAMOUNT1 35 BCD*10.3 Tax Amount 1 A X 
TAXAMOUNT2 36 BCD*10.3 Tax Amount 2 A X 
TAXAMOUNT3 37 BCD*10.3 Tax Amount 3 A X 
TAXAMOUNT4 38 BCD*10.3 Tax Amount 4 A X 
TAXAMOUNT5 39 BCD*10.3 Tax Amount 5 A X 
TAXINCLUD1 40 Boolean Tax Includable 1 E A X  List:2 entries
0 = No
1 = Yes
TAXINCLUD2 41 Boolean Tax Includable 2 E A X  List:2 entries
0 = No
1 = Yes
TAXINCLUD3 42 Boolean Tax Includable 3 E A X  List:2 entries
0 = No
1 = Yes
TAXINCLUD4 43 Boolean Tax Includable 4 E A X  List:2 entries
0 = No
1 = Yes
TAXINCLUD5 44 Boolean Tax Includable 5 E A X  List:2 entries
0 = No
1 = Yes
TXALLOAMT1 45 BCD*10.3 Tax Allocated Amount 1 A X 
TXALLOAMT2 46 BCD*10.3 Tax Allocated Amount 2 A X 
TXALLOAMT3 47 BCD*10.3 Tax Allocated Amount 3 A X 
TXALLOAMT4 48 BCD*10.3 Tax Allocated Amount 4 A X 
TXALLOAMT5 49 BCD*10.3 Tax Allocated Amount 5 A X 
TXRECVAMT1 50 BCD*10.3 Tax Recoverable Amount 1 A X 
TXRECVAMT2 51 BCD*10.3 Tax Recoverable Amount 2 A X 
TXRECVAMT3 52 BCD*10.3 Tax Recoverable Amount 3 A X 
TXRECVAMT4 53 BCD*10.3 Tax Recoverable Amount 4 A X 
TXRECVAMT5 54 BCD*10.3 Tax Recoverable Amount 5 A X 
TXEXPSAMT1 55 BCD*10.3 Tax Expense Amount 1 A X 
TXEXPSAMT2 56 BCD*10.3 Tax Expense Amount 2 A X 
TXEXPSAMT3 57 BCD*10.3 Tax Expense Amount 3 A X 
TXEXPSAMT4 58 BCD*10.3 Tax Expense Amount 4 A X 
TXEXPSAMT5 59 BCD*10.3 Tax Expense Amount 5 A X 
TXBASEALLO 60 BCD*10.3 Net of Tax A X 
TXINCLUDED 61 BCD*10.3 Tax Included A C X 
TXEXCLUDED 62 BCD*10.3 Tax Excluded A C X 
TAXAMOUNT 63 BCD*10.3 Total Tax A C X 
TXRECVAMT 64 BCD*10.3 Total Tax Recoverable A X 
TXEXPSAMT 65 BCD*10.3 Total Tax Expensed A X 
TXALLOAMT 66 BCD*10.3 Total Tax Allocated A X 
TFBASEALLO 67 BCD*10.3 Func. Net of Tax A C X 
TFINCLUDE1 68 BCD*10.3 Func. Tax Included Amount 1 A C X 
TFINCLUDE2 69 BCD*10.3 Func. Tax Included Amount 2 A C X 
TFINCLUDE3 70 BCD*10.3 Func. Tax Included Amount 3 A C X 
TFINCLUDE4 71 BCD*10.3 Func. Tax Included Amount 4 A C X 
TFINCLUDE5 72 BCD*10.3 Func. Tax Included Amount 5 A C X 
TFALLOAMT1 73 BCD*10.3 Func. Tax Allocated Amount 1 A C X 
TFALLOAMT2 74 BCD*10.3 Func. Tax Allocated Amount 2 A C X 
TFALLOAMT3 75 BCD*10.3 Func. Tax Allocated Amount 3 A C X 
TFALLOAMT4 76 BCD*10.3 Func. Tax Allocated Amount 4 A C X 
TFALLOAMT5 77 BCD*10.3 Func. Tax Allocated Amount 5 A C X 
TFRECVAMT1 78 BCD*10.3 Func. Tax Recoverable Amount 1 A C X 
TFRECVAMT2 79 BCD*10.3 Func. Tax Recoverable Amount 2 A C X 
TFRECVAMT3 80 BCD*10.3 Func. Tax Recoverable Amount 3 A C X 
TFRECVAMT4 81 BCD*10.3 Func. Tax Recoverable Amount 4 A C X 
TFRECVAMT5 82 BCD*10.3 Func. Tax Recoverable Amount 5 A C X 
TFEXPSAMT1 83 BCD*10.3 Func. Tax Expense Amount 1 A C X 
TFEXPSAMT2 84 BCD*10.3 Func. Tax Expense Amount 2 A C X 
TFEXPSAMT3 85 BCD*10.3 Func. Tax Expense Amount 3 A C X 
TFEXPSAMT4 86 BCD*10.3 Func. Tax Expense Amount 4 A C X 
TFEXPSAMT5 87 BCD*10.3 Func. Tax Expense Amount 5 A C X 
RCPNUMBER 88 String*22 Receipt Number A X  Mask: %-22C
RCPHSEQA 89 BCD*10.0 Apply To Receipt Sequence Key A X 
RCPNUMBERA 90 String*22 Apply To Receipt Number A X  Mask: %-22C
INVSSEQG 91 BCD*10.0 Invoice Cost Group Sequence A X 
VALUES 92 Long Optional Fields E A C X 
TERMDISCBL 93 Integer Payment Discountable E A X  List:2 entries
0 = No
1 = Yes
CONTRACT 94 String*16 Contract A X  Mask: %-16C
PROJECT 95 String*16 Project A X  Mask: %-16N
CCATEGORY 96 String*16 (Cost) Category A X  Mask: %-16N
COSTCLASS 97 Integer Cost Class A C X  List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
RESOURCE 98 String*24 Resource A P X  Mask: %-16N
BILLTYPE 99 Integer Billing Type A P X  List:4 entries
0 =
1 = Non-billable
2 = Billable
3 = No Charge
BILLRATE 100 BCD*10.6 Billing Rate A X 
BILLCURR 101 String*3 Billing Currency A C X  Mask: %-3N
ARITEMNO 102 String*16 A/R Item Number A X  Mask: %-16C
ARUNIT 103 String*10 A/R Unit of Measure A X  Mask: %-10C
CALCOVRHD 104 Boolean Calculate Overhead A X  List:2 entries
0 = No
1 = Yes
CALCLABOR 105 Boolean Calculate Labor A X  List:2 entries
0 = No
1 = Yes
RTGPERCENT 106 BCD*5.5 Retainage Percentage A X 
RTGDAYS 107 Integer Retention Period A X 
RTGAMOUNT 108 BCD*10.3 Retainage Amount A X 
RTGDATEDUE 109 Date Retainage Due Date A X 
RTGAMTOVER 110 Boolean Retainage Amount Overridden A C X  List:2 entries
0 = No
1 = Yes
RTGDDTOVER 111 Boolean Retainage Due Date Overridden A C X  List:2 entries
0 = No
1 = Yes
COSTDISTS 112 Long Cost Distributions E A C X 
MANDISTS 113 Long Manual Cost Distributions E A C X 
EXTDISTS 114 Long Extraneous Cost Distributions E A C X 
TARAMOUNT1 115 BCD*10.3 Tax Reporting Amount 1 A X 
TARAMOUNT2 116 BCD*10.3 Tax Reporting Amount 2 A X 
TARAMOUNT3 117 BCD*10.3 Tax Reporting Amount 3 A X 
TARAMOUNT4 118 BCD*10.3 Tax Reporting Amount 4 A X 
TARAMOUNT5 119 BCD*10.3 Tax Reporting Amount 5 A X 
TRALLOAMT1 120 BCD*10.3 Tax Reporting Allocated Amount 1 A X 
TRALLOAMT2 121 BCD*10.3 Tax Reporting Allocated Amount 2 A X 
TRALLOAMT3 122 BCD*10.3 Tax Reporting Allocated Amount 3 A X 
TRALLOAMT4 123 BCD*10.3 Tax Reporting Allocated Amount 4 A X 
TRALLOAMT5 124 BCD*10.3 Tax Reporting Allocated Amount 5 A X 
TRRECVAMT1 125 BCD*10.3 Tax Reporting Recoverable Amt. 1 A X 
TRRECVAMT2 126 BCD*10.3 Tax Reporting Recoverable Amt. 2 A X 
TRRECVAMT3 127 BCD*10.3 Tax Reporting Recoverable Amt. 3 A X 
TRRECVAMT4 128 BCD*10.3 Tax Reporting Recoverable Amt. 4 A X 
TRRECVAMT5 129 BCD*10.3 Tax Reporting Recoverable Amt. 5 A X 
TREXPSAMT1 130 BCD*10.3 Tax Reporting Expense Amount 1 A X 
TREXPSAMT2 131 BCD*10.3 Tax Reporting Expense Amount 2 A X 
TREXPSAMT3 132 BCD*10.3 Tax Reporting Expense Amount 3 A X 
TREXPSAMT4 133 BCD*10.3 Tax Reporting Expense Amount 4 A X 
TREXPSAMT5 134 BCD*10.3 Tax Reporting Expense Amount 5 A X 
GLEXPACCTD 141 String*60 Expense Account Description A C X 
GLRETACCTD 142 String*60 Return Expense Account Desc. A C X 
TXICLASS1D 143 String*60 Tax Class 1 Description A C X 
TXICLASS2D 144 String*60 Tax Class 2 Description A C X 
TXICLASS3D 145 String*60 Tax Class 3 Description A C X 
TXICLASS4D 146 String*60 Tax Class 4 Description A C X 
TXICLASS5D 147 String*60 Tax Class 5 Description A C X 
TXINCLUDE1 148 BCD*10.3 Included Tax Amount 1 A X 
TXINCLUDE2 149 BCD*10.3 Included Tax Amount 2 A X 
TXINCLUDE3 150 BCD*10.3 Included Tax Amount 3 A X 
TXINCLUDE4 151 BCD*10.3 Included Tax Amount 4 A X 
TXINCLUDE5 152 BCD*10.3 Included Tax Amount 5 A X 
TXEXCLUDE1 153 BCD*10.3 Excluded Tax Amount 1 A X 
TXEXCLUDE2 154 BCD*10.3 Excluded Tax Amount 2 A X 
TXEXCLUDE3 155 BCD*10.3 Excluded Tax Amount 3 A X 
TXEXCLUDE4 156 BCD*10.3 Excluded Tax Amount 4 A X 
TXEXCLUDE5 157 BCD*10.3 Excluded Tax Amount 5 A X 
MTOPRORATE 158 BCD*10.3 Manual To Prorate A C X 
ISCOMPLETE 159 Boolean Completed E A X  List:2 entries
0 = No
1 = Yes
TAXLINE 160 Long Lines Tax Calculation Sees A X 
COSTCMPL 161 Long Costs Complete A X 
COST 162 Long Costs A X 
RCPSREV 163 BCD*10.0 Line Number A C X 
PROCESSCMD 164 Integer Command E A C X  List:18 entries
0 = Nothing to Process
1 = Insert Optional Fields
2 = Default and Tranfer Optional Fields
3 = Default Opt. Fields During Record Generation
4 = Remove Optional Fields
5 = Transfer Opt. Fields from Standing Document
6 = Insert Item Serial Optional Fields
7 = Insert Item Lot Optional Fields
21 = Auto-generate Serials
22 = Auto-generate Lots
23 = Auto-allocate Serials
24 = Auto-allocate Lots
25 = Clear Serials
26 = Clear Lots
27 = Auto-assign Serials
28 = Auto-assign Lots
29 = Create Serials/Lots List
31 = Post Serials/Lots to IC Inventory
TERMDBWT 165 BCD*10.3 Payment Discount Base With Tax A X 
TERMDBNT 166 BCD*10.3 Payment Discount Base Without Tax A X 
JOBCOST 167 Long Job Related Cost A X 
AMOUNTC 168 BCD*10.3 Amount Distribution Sum E A C X 
BILLRATEC 169 BCD*10.6 Billing Rate Distribution Sum E A C X 
CONTSTYLE 170 Integer Project Style A C X  List:3 entries
0 =
1 = Standard
2 = Basic
PROJTYPE 171 Integer Project Type A C X  List:4 entries
0 =
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
REVREC 172 Integer Accounting Method A C X  List:9 entries
0 =
1 = Completed Project
2 = Total Cost Percentage Complete
3 = Labor Hours Percentage Complete
4 = Billings and Costs
5 = Project Percentage Complete
6 = Category Percentage Complete
7 = Completed Contract
8 = Accrual-Basis
UFMTCONTNO 173 String*16 Unformatted Contract Code A C X  Mask: %-16C
TRINCLUDE1 174 BCD*10.3 Tax Reporting Included Amount 1 A X 
TRINCLUDE2 175 BCD*10.3 Tax Reporting Included Amount 2 A X 
TRINCLUDE3 176 BCD*10.3 Tax Reporting Included Amount 3 A X 
TRINCLUDE4 177 BCD*10.3 Tax Reporting Included Amount 4 A X 
TRINCLUDE5 178 BCD*10.3 Tax Reporting Included Amount 5 A X 
TREXCLUDE1 179 BCD*10.3 Tax Reporting Excluded Amount 1 A X 
TREXCLUDE2 180 BCD*10.3 Tax Reporting Excluded Amount 2 A X 
TREXCLUDE3 181 BCD*10.3 Tax Reporting Excluded Amount 3 A X 
TREXCLUDE4 182 BCD*10.3 Tax Reporting Excluded Amount 4 A X 
TREXCLUDE5 183 BCD*10.3 Tax Reporting Excluded Amount 5 A X 
TARAMOUNT 184 BCD*10.3 Tax Reporting Total Amount A X 
TRINCLUDED 185 BCD*10.3 Tax Reporting Included Amount A X 
TREXCLUDED 186 BCD*10.3 Tax Reporting Excluded Amount A X 
TRRECVAMT 187 BCD*10.3 Tax Reporting Recoverable Amount A X 
TREXPSAMT 188 BCD*10.3 Tax Reporting Expensed Amount A X 
TRALLOAMT 189 BCD*10.3 Tax Reporting Allocated Amount A X 
RAXBASE1 190 BCD*10.3 Retainage Tax Base 1 A X 
RAXBASE2 191 BCD*10.3 Retainage Tax Base 2 A X 
RAXBASE3 192 BCD*10.3 Retainage Tax Base 3 A X 
RAXBASE4 193 BCD*10.3 Retainage Tax Base 4 A X 
RAXBASE5 194 BCD*10.3 Retainage Tax Base 5 A X 
RAXAMOUNT1 195 BCD*10.3 Retainage Tax Amount 1 A X 
RAXAMOUNT2 196 BCD*10.3 Retainage Tax Amount 2 A X 
RAXAMOUNT3 197 BCD*10.3 Retainage Tax Amount 3 A X 
RAXAMOUNT4 198 BCD*10.3 Retainage Tax Amount 4 A X 
RAXAMOUNT5 199 BCD*10.3 Retainage Tax Amount 5 A X 
RXRECVAMT1 201 BCD*10.3 Retainage Tax Recoverable Amt. 1 A X 
RXRECVAMT2 202 BCD*10.3 Retainage Tax Recoverable Amt. 2 A X 
RXRECVAMT3 203 BCD*10.3 Retainage Tax Recoverable Amt. 3 A X 
RXRECVAMT4 204 BCD*10.3 Retainage Tax Recoverable Amt. 4 A X 
RXRECVAMT5 205 BCD*10.3 Retainage Tax Recoverable Amt. 5 A X 
RXEXPSAMT1 206 BCD*10.3 Retainage Tax Expense Amount 1 A X 
RXEXPSAMT2 207 BCD*10.3 Retainage Tax Expense Amount 2 A X 
RXEXPSAMT3 208 BCD*10.3 Retainage Tax Expense Amount 3 A X 
RXEXPSAMT4 209 BCD*10.3 Retainage Tax Expense Amount 4 A X 
RXEXPSAMT5 210 BCD*10.3 Retainage Tax Expense Amount 5 A X 
RXALLOAMT1 211 BCD*10.3 Retainage Tax Allocated Amount 1 A X 
RXALLOAMT2 212 BCD*10.3 Retainage Tax Allocated Amount 2 A X 
RXALLOAMT3 213 BCD*10.3 Retainage Tax Allocated Amount 3 A X 
RXALLOAMT4 214 BCD*10.3 Retainage Tax Allocated Amount 4 A X 
RXALLOAMT5 215 BCD*10.3 Retainage Tax Allocated Amount 5 A X 
RAXAMOUNT 216 BCD*10.3 Retainage Tax Total Amount A X 
TXRXAMT1 217 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 1 A X 
TXRXAMT2 218 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 2 A X 
TXRXAMT3 219 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 3 A X 
TXRXAMT4 220 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 4 A X 
TXRXAMT5 221 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 5 A X 

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