# View: Receipt Additional Costs

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

## Compositions: 2

RotoID | Tables | Title | DLL
--- | --- | --- | ---
PO0700 | PORCPH1, PORCPH2 | Receipts | PORCPH
PO0718 | PORCPV | Receipt Vendors | PORCPV

## Keys: 3

Title | Fields
--- | ---
Detail Key | RCPHSEQ, VDCODE, RCPSREV
Sequence Key | RCPHSEQ, RCPSSEQ
Vendor Sequence Key | RCPHSEQ, VDCODE, RCPSSEQ

## 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: 6 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
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 2008-May-01

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