View: Receipt Additional Costs

RotoID: PO0713
Table: PORCPS
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:PORCPQ

Compositions: 2

RotoID Tables Title DLL
PO0700 PORCPH1PORCPH2 Receipts PORCPH
PO0718 PORCPV Receipt Vendors PORCPV

Keys: 4

Title Fields
Detail Key RCPHSEQ, VDCODE, RCPSREV
Sequence Key RCPHSEQ, RCPSSEQ
Vendor Sequence Key RCPHSEQ, VDCODE, RCPSSEQ
Detail Locator Key RCPSSEQ, RCPHSEQ

Fields: 203

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

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