# View: Projects

RotoID: PM0022
Table: PMPROJS
DLL: PMPROJS

## Compositions: 5

RotoID | Table | Title | DLL
--- | --- | --- | ---
PM0021 | PMCONTS | Contracts | PMCONTS
PM0039 | PMCATGT | Contract Categories | PMCATGT
PM0120 | PMRES | Contract Resources | PMRES
PM0121 | PMRESC | Contract Resource Categories | PMRESC
PM0851 | PMPROJSO | Project Optional Field | PMPROJSO

## Keys: 3

Title | Fields
--- | ---
Contract Uniquifier/Line Number | CTUNIQ, PLINENUM
Contract Uniquifier/Detail Numbe | CTUNIQ, DETAILNUM
Contract/Project | CONTRACT, PROJECT

## Fields: 370

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
CTUNIQ | 1 | BCD*10.0 | Contract Uniq | E A K R |
PLINENUM | 2 | Long | Line Number | E A K R |
CONTRACT | 3 | String*16 | Contract | E A | Mask: %-16C
PROJECT | 4 | String*16 | Project | E A | Mask: %-16N
DETAILNUM | 5 | Long | Detail Number | E A |
DATELASTMN | 6 | Date | Last Maintained | A C |
STARTDATE | 7 | Date | Projected Start Date | E A X |
ORJENDDATE | 8 | Date | Projected End Date | E A X |
CURENDDATE | 9 | Date | Current End Date | A X |
CLOSEDDATE | 10 | Date | Date Closed | A |
DESC | 11 | String*60 | Description | E A |
PROJTYPE | 12 | Integer | Project Type | A X | List: 3 entries
1 | = | Time and Materials
2 | = | Fixed Price
3 | = | Cost Plus
REVREC | 13 | Integer | Accounting Method | A P X | List: 7 entries
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
8 | = | Accrual-Basis
COSTPLUSP | 14 | BCD*5.5 | Cost Plus Percentage | A X |
CLOSEBILL | 15 | Integer | Closed to Billings | E A X | List: 2 entries
1 | = | Yes
0 | = | No
CLOSECOST | 16 | Integer | Closed to Costs | E A | List: 2 entries
1 | = | Yes
0 | = | No
PROJSTAT | 17 | Integer | Project Status | E A X | List: 7 entries
10 | = | Estimate
20 | = | Approved
30 | = | Open
40 | = | On Hold
70 | = | Inactive
60 | = | Completed
50 | = | Closed
USEDEFREV | 18 | Integer | Revenue Type | E A | List: 2 entries
0 | = | Revenue
1 | = | Deferred Revenue
BILLTYPE | 19 | Integer | Billing Type | E A X | List: 3 entries
2 | = | Billable
3 | = | No Charge
1 | = | Non-billable
PERRETREC | 20 | BCD*5.5 | A/R Retainage Percentage | E A |
RETRECD | 21 | Integer | A/R Retention Period | E A |
BILLACCT | 22 | String*45 | Billings | E A X | Mask: %-45C
DEFRACCT | 23 | String*45 | Deferred Revenue | A | Mask: %-45C
REVACCT | 24 | String*45 | Revenue | E A X | Mask: %-45C
PROFITACCT | 25 | String*45 | Profit | A | Mask: %-45C
LOSSACCT | 26 | String*45 | Loss | A | Mask: %-45C
GAINACCT | 27 | String*45 | Gain | A | Mask: %-45C
WIPACCT | 28 | String*45 | Work in Progress | A X | Mask: %-45C
COGSACCT | 29 | String*45 | Cost of Sales | A X | Mask: %-45C
PONUMBER | 30 | String*22 | P/O Number | E A | Mask: %-22C
FORMCODE | 31 | String*6 | Form Code | E A | Mask: %-6N
INVTYPE | 32 | Integer | A/R Invoice Type | A | List: 2 entries
1 | = | Item
2 | = | Summary
ORATE | 33 | BCD*8.7 | Original Exchange Rate | A |
ORATETYPE | 34 | String*2 | Original Rate Type | A | Mask: %-2N
ORATEDATE | 35 | Date | Original Rate Date | A |
RATE | 36 | BCD*8.7 | Exchange Rate | E A |
RATETYPE | 37 | String*2 | Rate Type | E A | Mask: %-2N
RATEOP | 38 | Integer | Rate Operator | E A | List: 2 entries
1 | = | Multiply
2 | = | Divide
RATEDATE | 39 | Date | Rate Date | E A |
RATESPREAD | 40 | BCD*8.7 | Rate Spread | E A |
ESTBILLCCY | 41 | Integer | Revenue And Cost Currency | E A | List: 3 entries
1 | = | Revenue and Costs in Functional Currency
2 | = | Revenue in Customer Currency
3 | = | Revenue and Costs in Customer Currency
COSTCCY | 42 | String*3 | Cost Currency | E A | Mask: %-3N
REVCCY | 43 | String*3 | Revenue Currency | E A | Mask: %-3N
INVSTATE | 44 | Integer | Invoice Status | E A | List: 3 entries
1 | = | Not Processed
2 | = | On Worksheet
3 | = | On Invoice
NUMCATS | 45 | Long | Number of Categories | E A |
ORJTIMECSR | 46 | BCD*10.3 | Reserved | A |
ORJTIMECHM | 47 | BCD*10.3 | Orig. Labor Cost Est. | A |
CURTIMECSR | 48 | BCD*10.3 | Reserved | A |
CURTIMECHM | 49 | BCD*10.3 | Cur. Labor Cost Est. | A |
ACTTIMECSR | 50 | BCD*10.3 | Reserved | A |
ACTTIMECHM | 51 | BCD*10.3 | Actual Labor Costs | A |
RECTIMECSR | 52 | BCD*10.3 | Reserved | A |
RECTIMECHM | 53 | BCD*10.3 | Reserved | A |
ORJTIMEBSR | 56 | BCD*10.3 | Orig. Labor Billing Est. | A |
ORJTIMEBHM | 57 | BCD*10.3 | Orig. Labor Billing Est. | A |
CURTIMEBSR | 58 | BCD*10.3 | Cur. Labor Billing Est. | A |
CURTIMEBHM | 59 | BCD*10.3 | Cur. Labor Billing Est. | A |
ACTTIMEBSR | 60 | BCD*10.3 | Actual Labor Billings | A |
ACTTIMEBHM | 61 | BCD*10.3 | Actual Labor Billings | A |
RECTIMEBSR | 62 | BCD*10.3 | Reserved | A |
RECTIMEBHM | 63 | BCD*10.3 | Reserved | A |
ORJTIMEQTY | 66 | BCD*10.5 | Orig. Labor Qty Est. | A |
CURTIMEQTY | 67 | BCD*10.5 | Cur. Labor Qty Est. | A |
ACTTIMEQTY | 68 | BCD*10.5 | Actual Labor Qty | A |
PERTIMEQTY | 69 | BCD*5.5 | PERTIMEQTY | A |
ORJMATECSR | 70 | BCD*10.3 | Reserved | A |
ORJMATECHM | 71 | BCD*10.3 | Orig. Material Estimated Cost | A |
CURMATECSR | 72 | BCD*10.3 | Reserved | A |
CURMATECHM | 73 | BCD*10.3 | Current Material Estimated Cost | A |
ACTMATECSR | 74 | BCD*10.3 | Reserved | A |
ACTMATECHM | 75 | BCD*10.3 | Actual Material Cost | A |
RECMATECSR | 76 | BCD*10.3 | Reserved | A |
RECMATECHM | 77 | BCD*10.3 | Reserved | A |
ORJMATEBSR | 80 | BCD*10.3 | Orig. Material Billing Est. | A |
ORJMATEBHM | 81 | BCD*10.3 | Orig. Material Billing Est. | A |
CURMATEBSR | 82 | BCD*10.3 | Cur. Material Billing Est. | A |
CURMATEBHM | 83 | BCD*10.3 | Cur. Material Billing Est. | A |
ACTMATEBSR | 84 | BCD*10.3 | Actual Material Billed | A |
ACTMATEBHM | 85 | BCD*10.3 | Actual Material Billed | A |
RECMATEBSR | 86 | BCD*10.3 | Reserved | A |
RECMATEBHM | 87 | BCD*10.3 | Reserved | A |
ORJMATEQTY | 90 | BCD*10.5 | Orig. Material Qty Est. | A |
CURMATEQTY | 91 | BCD*10.5 | Cur. Material Est. | A |
ACTMATEQTY | 92 | BCD*10.5 | Actual Material Qty | A |
ORJEQUICSR | 94 | BCD*10.3 | Reserved | A |
ORJEQUICHM | 95 | BCD*10.3 | Orig. Estimated Equipment Cost | A |
CUREQUICSR | 96 | BCD*10.3 | Reserved | A |
CUREQUICHM | 97 | BCD*10.3 | Cur. Estimated Equipment Cost | A |
ACTEQUICSR | 98 | BCD*10.3 | Reserved | A |
ACTEQUICHM | 99 | BCD*10.3 | Actual Equipment Cost | A |
RECEQUICSR | 100 | BCD*10.3 | Reserved | A |
RECEQUICHM | 101 | BCD*10.3 | Reserved | A |
ORJEQUIBSR | 104 | BCD*10.3 | Orig. Equipment Billing Est. | A |
ORJEQUIBHM | 105 | BCD*10.3 | Orig. Equipment Billing Est. | A |
CUREQUIBSR | 106 | BCD*10.3 | Cur. Equipment Billing Est. | A |
CUREQUIBHM | 107 | BCD*10.3 | Cur. Equipment Billing Est. | A |
ACTEQUIBSR | 108 | BCD*10.3 | Actual Equipment Amount Billed | A |
ACTEQUIBHM | 109 | BCD*10.3 | Actual Equipment Amount Billed | A |
RECEQUIBSR | 110 | BCD*10.3 | Reserved | A |
RECEQUIBHM | 111 | BCD*10.3 | Reserved | A |
ORJEQUIQTY | 114 | BCD*10.5 | Orig. Equipment Qty Est. | A |
CUREQUIQTY | 115 | BCD*10.5 | Cur. Equipment Est. | A |
ACTEQUIQTY | 116 | BCD*10.5 | Actual Equipment Qty | A |
ORJSUBCCSR | 118 | BCD*10.3 | Reserved | A |
ORJSUBCCHM | 119 | BCD*10.3 | Orig. Subcontractor Est. Cost | A |
CURSUBCCSR | 120 | BCD*10.3 | Reserved | A |
CURSUBCCHM | 121 | BCD*10.3 | Cur. Subcontractor Est. Cost | A |
ACTSUBCCSR | 122 | BCD*10.3 | Reserved | A |
ACTSUBCCHM | 123 | BCD*10.3 | Actual Subcontractor Cost | A |
RECSUBCCSR | 124 | BCD*10.3 | Reserved | A |
RECSUBCCHM | 125 | BCD*10.3 | Reserved | A |
ORJSUBCBSR | 128 | BCD*10.3 | Orig. Subcontract Billing Est. | A |
ORJSUBCBHM | 129 | BCD*10.3 | Orig. Subcontract Billing Est. | A |
CURSUBCBSR | 130 | BCD*10.3 | Cur. Subcontract Billing Est. | A |
CURSUBCBHM | 131 | BCD*10.3 | Cur. Subcontract Billing Est. | A |
ACTSUBCBSR | 132 | BCD*10.3 | Actual Subcontract Amt Billed | A |
ACTSUBCBHM | 133 | BCD*10.3 | Actual Subcontract Amt Billed | A |
RECSUBCBSR | 134 | BCD*10.3 | Reserved | A |
RECSUBCBHM | 135 | BCD*10.3 | Reserved | A |
ORJSUBCQTY | 138 | BCD*10.5 | Orig. Subcontractor Qty Est. | A |
CURSUBCQTY | 139 | BCD*10.5 | Cur. Subcontractor Est. | A |
ACTSUBCQTY | 140 | BCD*10.5 | Actual Subcontractor Qty | A |
ORJOHEXCSR | 142 | BCD*10.3 | Reserved | A |
ORJOHEXCHM | 143 | BCD*10.3 | Orig. Est Overhead Expense Cost | A |
CUROHEXCSR | 144 | BCD*10.3 | Reserved | A |
CUROHEXCHM | 145 | BCD*10.3 | Cur. Est. Overhead Expense Cost | A |
ACTOHEXCSR | 146 | BCD*10.3 | Reserved | A |
ACTOHEXCHM | 147 | BCD*10.3 | Actual Overhead Expense Cost | A |
RECOHEXCSR | 148 | BCD*10.3 | Reserved | A |
RECOHEXCHM | 149 | BCD*10.3 | Reserved | A |
ORJOHEXBSR | 152 | BCD*10.3 | Orig. Overhead Billing Est. | A |
ORJOHEXBHM | 153 | BCD*10.3 | Orig. Overhead Billing Est. | A |
CUROHEXBSR | 154 | BCD*10.3 | Cur. Overhead Billing Est. | A |
CUROHEXBHM | 155 | BCD*10.3 | Cur. Overhead Billing Est. | A |
ACTOHEXBSR | 156 | BCD*10.3 | Actual Overhead Amount Billed | A |
ACTOHEXBHM | 157 | BCD*10.3 | Actual Overhead Billing Est. | A |
RECOHEXBSR | 158 | BCD*10.3 | Reserved | A |
RECOHEXBHM | 159 | BCD*10.3 | Reserved | A |
ORJOHEXQTY | 162 | BCD*10.5 | Orig. Overhead Qty Est. | A |
CUROHEXQTY | 163 | BCD*10.5 | Cur. Overhead Est. | A |
ACTOHEXQTY | 164 | BCD*10.5 | Actual Overhead Qty | A |
ORJMISCCSR | 166 | BCD*10.3 | Reserved | A |
ORJMISCCHM | 167 | BCD*10.3 | Orig. Est. Miscellaneous Cost | A |
CURMISCCSR | 168 | BCD*10.3 | Reserved | A |
CURMISCCHM | 169 | BCD*10.3 | Cur. Est. Miscellaneous Cost | A |
ACTMISCCSR | 170 | BCD*10.3 | Reserved | A |
ACTMISCCHM | 171 | BCD*10.3 | Actual Miscellaneous Cost | A |
RECMISCCSR | 172 | BCD*10.3 | Reserved | A |
RECMISCCHM | 173 | BCD*10.3 | Reserved | A |
ORJMISCBSR | 176 | BCD*10.3 | Orig. Miscellaneous Billing Est | A |
ORJMISCBHM | 177 | BCD*10.3 | Orig. Miscellaneous Billing Est | A |
CURMISCBSR | 178 | BCD*10.3 | Cur. Miscellaneous Billing Est. | A |
CURMISCBHM | 179 | BCD*10.3 | Cur. Miscellaneous Billing Est. | A |
ACTMISCBSR | 180 | BCD*10.3 | Actual Miscellaneous Amt Billed | A |
ACTMISCBHM | 181 | BCD*10.3 | Actual Miscellaneous Amt Billed | A |
RECMISCBSR | 182 | BCD*10.3 | Reserved | A |
RECMISCBHM | 183 | BCD*10.3 | Reserved | A |
ORJMISCQTY | 186 | BCD*10.5 | Orig. Miscellaneous Qty Est. | A |
CURMISCQTY | 187 | BCD*10.5 | Cur. Miscellaneous Qty Est. | A |
ACTMISCQTY | 188 | BCD*10.5 | Actual Miscellaneous Qty | A |
ORJOHEADSR | 190 | BCD*10.3 | Reserved | A |
ORJOHEADHM | 191 | BCD*10.3 | Original Overhead Estimate | A |
CUROHEADSR | 192 | BCD*10.3 | Reserved | A |
CUROHEADHM | 193 | BCD*10.3 | Current Overhead Estimate | A |
ACTOHEADSR | 194 | BCD*10.3 | Reserved | A |
ACTOHEADHM | 195 | BCD*10.3 | Actual Overhead | A |
ORJLABSR | 199 | BCD*10.3 | Reserved | A |
ORJLABHM | 200 | BCD*10.3 | Original Labor Amount Estimate | A |
CURLABSR | 201 | BCD*10.3 | Reserved | A |
CURLABHM | 202 | BCD*10.3 | Current Labor Amount Estimate | A |
ACTLABSR | 203 | BCD*10.3 | Reserved | A |
ACTLABHM | 204 | BCD*10.3 | Actual Labor Amount | A |
ORJCHRGSR | 208 | BCD*10.3 | Reserved | A |
ORJCHRGHM | 209 | BCD*10.3 | Reserved | A |
CURCHRGSR | 210 | BCD*10.3 | Reserved | A |
CURCHRGHM | 211 | BCD*10.3 | Reserved | A |
ACTCHRGSR | 212 | BCD*10.3 | Actual Charge Amount | A |
ACTCHRGHM | 213 | BCD*10.3 | Actual Charge Amount | A |
ACTCHRGDSR | 214 | BCD*10.3 | Act Chrg Amt Billed & Deferred | A |
ACTCHRGDHM | 215 | BCD*10.3 | Act Chrg Amt Billed & Deferred | A |
RECCHRGSR | 216 | BCD*10.3 | Reserved | A |
RECCHRGHM | 217 | BCD*10.3 | Reserved | A |
ACTSTKRESR | 220 | BCD*10.3 | Reserved | A |
ACTSTKREHM | 221 | BCD*10.3 | Act Cost Stock Ret to Inventory | A |
ACTSTKRQTY | 222 | BCD*10.5 | Act Qty Stock Ret to Inventory | A |
TARRECTSSR | 223 | BCD*10.3 | Total A/R Customer Receipts | A |
TARRECTSHM | 224 | BCD*10.3 | Total A/R Customer Receipts | A |
TAPPAYMTS | 225 | BCD*10.3 | Total A/P Vendor Payments | A |
TORJCOSTSR | 226 | BCD*10.3 | Reserved | A |
TORJCOSTHM | 227 | BCD*10.3 | Total Orig. Cost Est. | A |
TCURCOSTSR | 228 | BCD*10.3 | Reserved | A |
TCURCOSTHM | 229 | BCD*10.3 | Total Cur. Cost Est. | A |
TACTCOSTSR | 230 | BCD*10.3 | Reserved | A |
TACTCOSTHM | 231 | BCD*10.3 | Total Actual Cost | A |
TRECCOSTSR | 232 | BCD*10.3 | Reserved | A |
TRECCOSTHM | 233 | BCD*10.3 | Total Cost Recognized | A |
PERTCOST | 234 | BCD*5.5 | Percent Total Cost | A |
PERTREV | 235 | BCD*5.5 | PERTREV | E A |
TORJREVSR | 236 | BCD*10.3 | Total Orig. Revenue Est. | A |
TORJREVHM | 237 | BCD*10.3 | Total Orig. Revenue Est. | A |
TCURREVSR | 238 | BCD*10.3 | Total Cur. Revenue Est. | A |
TCURREVHM | 239 | BCD*10.3 | Total Cur. Revenue Est. | A |
TACTREVSR | 240 | BCD*10.3 | Total Actual Revenue | A |
TACTREVHM | 241 | BCD*10.3 | Total Actual Revenue | A |
TRECREVSR | 242 | BCD*10.3 | Total Revenue Recognized | A |
TRECREVHM | 243 | BCD*10.3 | Total Revenue Recognized | A |
RETARAMTSR | 246 | BCD*10.3 | Retainage Receivable | A |
RETARAMTHM | 247 | BCD*10.3 | Retainage Receivable | A |
RETARRECSR | 248 | BCD*10.3 | Retainage Amount Received in A/R | A |
RETARRECHM | 249 | BCD*10.3 | Retainage Amount Received in A/R | A |
RETAPAMT | 250 | BCD*10.3 | Retainage Payable | A |
RETAPPAID | 251 | BCD*10.3 | Retainage Amount Paid in A/P | A |
POAMOUNTSR | 252 | BCD*10.3 | Reserved | A |
POAMOUNTHM | 253 | BCD*10.3 | Reserved | A |
POQTY | 254 | BCD*10.5 | Committed P/O Quantity | A C |
OEAMOUNTSR | 255 | BCD*10.3 | Reserved | A |
OEAMOUNTHM | 256 | BCD*10.3 | Reserved | A |
OEQTY | 257 | BCD*10.5 | Reserved | A |
PCOMPLETEB | 260 | BCD*5.5 | Billings Percent Complete | A |
PCOMPLETER | 262 | BCD*5.5 | RR Percent Complete | A |
FPAMOUNTSR | 263 | BCD*10.3 | Fixed Price Amount | A X |
FPAMOUNTHM | 264 | BCD*10.3 | Fixed Price Amount | A |
LSTBILLPER | 265 | BCD*5.5 | Last Billings Percent Complete | A |
BILLAMTRSR | 266 | BCD*10.3 | Recognized Amount to Bill | E A |
BILLAMTRHM | 267 | BCD*10.3 | Recognized Amount to Bill | E A |
COSTDATE | 268 | Date | Last Cost Posting Date | A |
BILLDATE | 269 | Date | Last Billings Posting Date | A |
OHDATE | 270 | Date | Last Overhead Posting Date | A |
CHARGEDATE | 271 | Date | Last Charge Posting Date | A |
REVRECDATE | 272 | Date | Last Revenue Rec Posting Date | A |
ARRECDATE | 273 | Date | Last A/R Receipt Posting Date | A |
APPAYDATE | 274 | Date | Last A/P Payment Posting Date | A |
TIMEDATE | 275 | Date | Last Timecard Posting Date | A |
STKTRDATE | 276 | Date | Last Material Usage Posting Date | A |
STKRETDATE | 277 | Date | Last Material Return Posting Dat | A |
EQUIPDATE | 278 | Date | Last Equipment Posting Date | A |
PODATE | 279 | Date | Last Purchase Order Date | A |
PORECDATE | 280 | Date | Last P/O Receipt Date | A |
PORETDATE | 281 | Date | Last P/O Return Date | A |
OEORDDATE | 282 | Date | Reserved | A |
OEINVDATE | 283 | Date | Reserved | A |
PTAXTOTAL | 284 | BCD*10.3 | PTAXTOTAL | E A |
TAUTH1 | 285 | String*12 | Tax Authority 1 | A X | Mask: %-12N
TAUTH2 | 286 | String*12 | Tax Authority 2 | A X | Mask: %-12N
TAUTH3 | 287 | String*12 | Tax Authority 3 | A X | Mask: %-12N
TAUTH4 | 288 | String*12 | Tax Authority 4 | A X | Mask: %-12N
TAUTH5 | 289 | String*12 | Tax Authority 5 | A X | Mask: %-12N
TCLASS1 | 290 | Integer | Tax Class 1 | A X |
TCLASS2 | 291 | Integer | Tax Class 2 | A X |
TCLASS3 | 292 | Integer | Tax Class 3 | A X |
TCLASS4 | 293 | Integer | Tax Class 4 | A X |
TCLASS5 | 294 | Integer | Tax Class 5 | A X |
TINCLUDED1 | 295 | Boolean | Tax Included 1 | A X |
TINCLUDED2 | 296 | Boolean | Tax Included 2 | A X |
TINCLUDED3 | 297 | Boolean | Tax Included 3 | A X |
TINCLUDED4 | 298 | Boolean | Tax Included 4 | A X |
TINCLUDED5 | 299 | Boolean | Tax Included 5 | A X |
TAXBASES1 | 300 | BCD*10.3 | Tax Base 1 | E A |
TAXBASES2 | 301 | BCD*10.3 | Tax Base 2 | E A |
TAXBASES3 | 302 | BCD*10.3 | Tax Base 3 | E A |
TAXBASES4 | 303 | BCD*10.3 | Tax Base 4 | E A |
TAXBASES5 | 304 | BCD*10.3 | Tax Base 5 | E A |
TAXBASEH1 | 305 | BCD*10.3 | Tax Base 1 | E A |
TAXBASEH2 | 306 | BCD*10.3 | Tax Base 2 | E A |
TAXBASEH3 | 307 | BCD*10.3 | Tax Base 3 | E A |
TAXBASEH4 | 308 | BCD*10.3 | Tax Base 4 | E A |
TAXBASEH5 | 309 | BCD*10.3 | Tax Base 5 | E A |
TAXAMTS1 | 310 | BCD*10.3 | Tax Amount 1 | E A |
TAXAMTS2 | 311 | BCD*10.3 | Tax Amount 2 | E A |
TAXAMTS3 | 312 | BCD*10.3 | Tax Amount 3 | E A |
TAXAMTS4 | 313 | BCD*10.3 | Tax Amount 4 | E A |
TAXAMTS5 | 314 | BCD*10.3 | Tax Amount 5 | E A |
TAXAMTH1 | 315 | BCD*10.3 | Tax Amount 1 | E A |
TAXAMTH2 | 316 | BCD*10.3 | Tax Amount 2 | E A |
TAXAMTH3 | 317 | BCD*10.3 | Tax Amount 3 | E A |
TAXAMTH4 | 318 | BCD*10.3 | Tax Amount 4 | E A |
TAXAMTH5 | 319 | BCD*10.3 | Tax Amount 5 | E A |
ONBW | 320 | Boolean | On Billing Worksheet | E A |
OPENED | 321 | Boolean | Project Has Been Opened | E A | List: 2 entries
0 | = | No
1 | = | Yes
BILLAMT | 322 | BCD*10.3 | Expected Billings | A |
ORATEOP | 323 | Integer | Rate Operator | E A | List: 2 entries
1 | = | Multiply
2 | = | Divide
LSTRRPER | 324 | BCD*5.5 | Last Rev. Recognition Percentage | A |
PRFTLOSSSR | 325 | BCD*10.3 | Recognized Profit / Loss | E A |
PRFTLOSSHM | 326 | BCD*10.3 | Recognized Profit / Loss | E A |
REVESTDATE | 327 | Date | Last Revised Posting Date | A |
ONRW | 328 | Boolean | On RR Worksheet | E A |
OLABEMHM | 329 | BCD*10.3 | Original Employee Labor | A |
CLABEMHM | 330 | BCD*10.3 | Current Employee Labor | A |
ALABEMHM | 331 | BCD*10.3 | Actual Employee Labor | A |
OOHEMHM | 332 | BCD*10.3 | Original Employee Overhead | A |
COHEMHM | 333 | BCD*10.3 | Current Employee Overhead | A |
AOHEMHM | 334 | BCD*10.3 | Actual Employee Overhead | A |
OOHEQHM | 335 | BCD*10.3 | Original Equipment Overhead | A |
COHEQHM | 336 | BCD*10.3 | Current Equipment Overhead | A |
AOHEQHM | 337 | BCD*10.3 | Actual Equipment Overhead | A |
OOHSUHM | 338 | BCD*10.3 | Original Subcontractor Overhead | A |
COHSUHM | 339 | BCD*10.3 | Current Subcontractor Overhead | A |
AOHSUHM | 340 | BCD*10.3 | Actual Subcontractor Overhead | A |
OOHOHHM | 341 | BCD*10.3 | Original Overhead Overhead | A |
COHOHHM | 342 | BCD*10.3 | Current Overhead Overhead | A |
AOHOHHM | 343 | BCD*10.3 | Actual Overhead Overhead | A |
OOHMIHM | 344 | BCD*10.3 | Original Miscellaneous Overhead | A |
COHMIHM | 345 | BCD*10.3 | Current Miscellaneous Overhead | A |
AOHMIHM | 346 | BCD*10.3 | Actual Miscellaneous Overhead | A |
OOHMAHM | 347 | BCD*10.3 | Original Material Overhead | A |
COHMAHM | 348 | BCD*10.3 | Current Material Overhead | A |
AOHMAHM | 349 | BCD*10.3 | Actual Material Overhead | A |
CDATEFROM | 350 | Date | Current Start Date | A X |
PROJSTYLE | 351 | Integer | Project Style | E A X | List: 2 entries
1 | = | Standard
2 | = | Basic
APTAXEXPHM | 352 | BCD*10.3 | Reserved | A |
APTAXRECHM | 353 | BCD*10.3 | Reserved | A |
APTAXEXCHM | 354 | BCD*10.3 | Reserved | A |
APDISCHM | 355 | BCD*10.3 | Reserved | A |
APINTHM | 356 | BCD*10.3 | Reserved | A |
ARTAXHM | 357 | BCD*10.3 | Reserved | A |
ARTAXSR | 358 | BCD*10.3 | Reserved | A |
ARDISCHM | 359 | BCD*10.3 | Reserved | A |
ARDISCSR | 360 | BCD*10.3 | Reserved | A |
ARINTHM | 361 | BCD*10.3 | Reserved | A |
ARINTSR | 362 | BCD*10.3 | Reserved | A |
ARWRITEHM | 363 | BCD*10.3 | Reserved | A |
ARWRITESR | 364 | BCD*10.3 | Reserved | A |
PLCODE | 365 | String*16 | Reserved | A |
BILLAMTC | 366 | BCD*10.3 | Current Billings (AR and on BW) | A |
POCOSTHM | 367 | BCD*10.3 | Committed P/O Cost | A C |
POOHHM | 368 | BCD*10.3 | Committed P/O Overhead | A C |
POLABORHM | 369 | BCD*10.3 | Committed P/O Labor | A C |
POTCOSTHM | 370 | BCD*10.3 | Committed P/O Total Cost | A C |
POEMQTY | 371 | BCD*10.5 | P/O Employee Quantity | A |
POEMOHHM | 372 | BCD*10.3 | P/O Employee Overhead | A |
POEMLABHM | 373 | BCD*10.3 | P/O Employee Labor | A |
POEMTCOSTH | 374 | BCD*10.3 | P/O Employee Total Cost | A |
POEQQTY | 375 | BCD*10.5 | P/O Equipment Quantity | A |
POEQOHHM | 376 | BCD*10.3 | P/O Equipment Overhead | A |
POEQTCOSTH | 377 | BCD*10.3 | P/O Equipment Total Cost | A |
POSUQTY | 378 | BCD*10.5 | P/O Subcontractor Quantity | A |
POSUOHHM | 379 | BCD*10.3 | P/O Subcontractor Overhead | A |
POSUTCOSTH | 380 | BCD*10.3 | P/O Subcontractor Total Cost | A |
POOHQTY | 381 | BCD*10.5 | P/O Overhead Quantity | A |
POOHOHHM | 382 | BCD*10.3 | P/O Overhead Overhead | A |
POOHTCOSTH | 383 | BCD*10.3 | P/O Overhead Total Cost | A |
POMIQTY | 384 | BCD*10.5 | P/O Miscellaneous Quantity | A |
POMIOHHM | 385 | BCD*10.3 | P/O Miscellaneous Overhead | A |
POMITCOSTH | 386 | BCD*10.3 | P/O Miscellaneous Total Cost | A |
POMAQTY | 387 | BCD*10.5 | P/O Material Quantity | A |
POMAOHHM | 388 | BCD*10.3 | P/O Material Overhead | A |
POMATCOSTH | 389 | BCD*10.3 | P/O Material Total Cost | A |
VALUES | 390 | Long | Optional Fields | E A C |
CLEARED | 391 | Integer | Transactions have been cleared | E A | List: 2 entries
0 | = | No
1 | = | Yes
UPCP | 1001 | Integer | Update Category Cost Plus % | E A C |
FUNCTION | 1002 | Integer | Function | E A C | List: 4 entries
0 | = | None
2 | = | Can insert categories?
3 | = | Reload Blank Accounts
10 | = | Load Optional Fields
RATEERR | 1003 | Integer | Rate Error Code | E A C | List: 5 entries
0 | = | No rate error
1 | = | Rate type is invalid
2 | = | Rate is zero
3 | = | Rate is outside spread
4 | = | No rate information exists
BILLDESC | 1004 | String*60 | Billing Account Description | A C |
REVDESC | 1005 | String*60 | Revenue Account Description | A C |
WIPDESC | 1006 | String*60 | WIP Account Description | A C |
COGSDESC | 1007 | String*60 | COGS Account Description | A C |
RCOSTPLUSP | 1008 | BCD*5.5 | Cost Plus % at Read | A C |
ORJQTY | 1010 | BCD*10.5 | Quantity | A C |
CURQTY | 1011 | BCD*10.5 | Current Quantity Estimate | A C |
ACTQTY | 1012 | BCD*10.5 | Actual Quantity | A C |
ORJCOSTHM | 1013 | BCD*10.3 | Extended Cost | A C |
CURCOSTHM | 1014 | BCD*10.3 | Current Cost Estimate | A C |
ACTCOSTHM | 1015 | BCD*10.3 | Actual Cost | A C |
SNAPCALC | 1016 | Integer | Extended Cost | E A |
SNAPOFROM | 1017 | Date | Extended Cost | E A X |
SNAPOTO | 1018 | Date | Extended Cost | E A X |
SNAPCFROM | 1019 | Date | Extended Cost | A X |
SNAPCTO | 1020 | Date | Extended Cost | A X |
HASOPT | 1021 | Boolean | Optional Fields | E A C | List: 2 entries
1 | = | Yes
0 | = | No
OPENING | 1022 | Integer | Optional Fields | E A C | List: 3 entries
0 | = | Not opening
1 | = | Contract opening
2 | = | Project opening

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.