View: ^4

RotoID: PM0021
Tables: PMCONTSPMCONTT
Protocol: Header, Key auto generate
DLL:PMCONTS

Compositions: 5

RotoID Tables Title DLL

PM0022 PMPROJSPMPROJT ^5 PMPROJS
PM0039 PMCATGT ^1 ^6 PMCATGT
PM0120 PMRES ^1 Resources PMRES
PM0121 PMRESC ^1 Resource ^6 PMRESC
PM0850 PMCONO Contract Optional Field PMCONO

Keys: 4

Title Fields

Contract Uniquifier CTUNIQ
Unformatted Contract CONTRACT
Customer / Contract CUSTOMERCONTRACT
Contract FMTCONTNO

Fields: 307

Field Index Type Title Attributes Presentation

CTUNIQ 1 BCD*10.0 ^1 Uniq E A K R 
CONTRACT 2 String*16 Unformatted ^1 E A  Mask: %-16C
DESC 3 String*60 Description E A 
DATELASTMN 4 Date Last Maintained A 
CONTBRKID 5 String*6 Structure Code E A X  Mask: %-6N
FMTCONTNO 6 String*16 ^1 E A  Mask: %-16C
CUSTOMER 7 String*12 Customer Number E A X  Mask: %-12C
MANAGER 8 String*16 ^1 Manager E A  Mask: %-16N
PONUMBER 9 String*22 P/O Number E A  Mask: %-22C
CONTACT 10 String*60 Contact E A 
PHONE 11 String*30 Telephone E A  Mask: (%-3C) %-3C-%-24C
FAX 12 String*30 Fax E A  Mask: (%-3C) %-3C-%-24C
STARTDATE 13 Date Start Date E A X 
ORJENDDATE 14 Date Original End Date E A X 
CURENDDATE 15 Date Projected End Date A X 
CLOSEDDATE 16 Date Closed Date A X 
COMMENT 17 String*250 Comment E A 
USERR 18 Boolean Use ^1 Revenue Recognition Information E A 
REVREC 19 Integer Accounting Method E A P  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
USEOVERH 20 Boolean Use the ^1 Overhead Information E A 
OVERHEAD 21 Integer Overhead Type E A  List:3 entries
1 = None
2 = Flat Rate Per Unit
5 = Percentage of Cost
OHEADRATE 22 BCD*10.6 Overhead Rate E A 
HEADPER 23 BCD*5.5 Overhead Percentage E A 
USELABOR 24 Boolean Use the ^1 Labor Information E A 
LABOR 25 Integer Labor Type E A  List:3 entries
1 = None
2 = Flat Rate Per Labor Hour/Unit
3 = Percentage of Labor Cost
LABORRATE 26 BCD*10.6 Labor Rate E A 
LABORPER 27 BCD*5.5 Labor Percentage E A 
STATUS 28 Integer ^1 Status E A X  List:7 entries
10 = Estimate
20 = Approved
30 = Open
40 = On Hold
70 = Inactive
60 = Completed
50 = Closed
USECOSTP 29 Boolean Use the ^1 Cost Plus Percentage A X 
COSTPLUSP 30 BCD*5.5 Cost Plus Percentage E A 
USEPTYPE 31 Integer ^2 Type E A 
PROJTYPE 32 Integer ^2 Type E A  List:3 entries
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
CHANGEORD 33 Integer Number of Change Orders to the ^1 E A 
NXTCHGORD 34 Long Next Change Order Number E A 
IDACCTSET 35 String*6 Account Set E A  Mask: %-6N
TEMPLAT 37 String*16 Template E A  Mask: %-16C
USEBILL 38 Boolean Use the ^1 Billing Type A X 
BILLTYPE 39 Integer Billing Type A X  List:3 entries
2 = Billable
3 = No Charge
1 = Non-billable
SCHCODE 40 String*12 Schedule E A  Mask: %-12N
USERETAIN 41 Boolean Use the ^1 Retainage Information E A 
PERRETREC 42 BCD*5.5 A/R Retainage Percentage E A 
RETRECD 43 Integer A/R Retention Period E A 
PERRETPAID 44 BCD*5.5 Reserved E A 
RETPAIDD 45 Integer Reserved E A 
SEGMENT1 58 String*16 Segment 1 E A 
SEGMENT2 59 String*16 Segment 2 E A 
SEGMENT3 60 String*16 Segment 3 E A 
SEGMENT4 61 String*16 Segment 4 E A 
SEGMENT5 62 String*16 Segment 5 E A 
CONSOLINV 63 Boolean Consolidate ^5 onto the One Invoice E A 
FORMCODE 64 String*6 Form Code E A  Mask: %-6N
NEXTNUM 65 Long Next Detail Number E A 
NUMDETAILS 66 Long Number of Details A 
ESTBILLCCY 67 Integer Revenue And Cost Currency E A X  List:3 entries
1 = Revenue and Costs in Functional Currency
2 = Revenue in Customer Currency
3 = Revenue and Costs in Customer Currency
CUSTCCY 68 String*3 Customer Currency E A  Mask: %-3N
CONTSTYLE 69 Integer ^1 Style E A X  List:2 entries
1 = Standard
2 = Basic
ORJTIMECSR 70 BCD*10.3 Number of non percent projects A 
ORJTIMECHM 71 BCD*10.3 Orig. Labor Cost Est. A 
CURTIMECSR 72 BCD*10.3 Reserved A 
CURTIMECHM 73 BCD*10.3 Cur. Labor Cost Est. A 
ACTTIMECSR 74 BCD*10.3 Reserved A 
ACTTIMECHM 75 BCD*10.3 Actual Labor Costs A 
RECTIMECSR 76 BCD*10.3 Reserved A 
RECTIMECHM 77 BCD*10.3 Reserved A 
ORJTIMEBSR 80 BCD*10.3 Orig. Labor Billing Est. A 
ORJTIMEBHM 81 BCD*10.3 Orig. Labor Billing Est. A 
CURTIMEBSR 82 BCD*10.3 Cur. Labor Billing Est. A 
CURTIMEBHM 83 BCD*10.3 Cur. Labor Billing Est. A 
ACTTIMEBSR 84 BCD*10.3 Actual Labor Billings A 
ACTTIMEBHM 85 BCD*10.3 Actual Labor Billings A 
RECTIMEBSR 86 BCD*10.3 Reserved A 
RECTIMEBHM 87 BCD*10.3 Reserved A 
ORJTIMEQTY 90 BCD*10.5 Orig. Labor Qty Est. A 
CURTIMEQTY 91 BCD*10.5 Cur. Labor Qty Est. A 
ACTTIMEQTY 92 BCD*10.5 Actual Labor Qty A 
PERTIMEQTY 93 BCD*5.5 Labor Percentage Complete A 
ORJMATECSR 94 BCD*10.3 Reserved A 
ORJMATECHM 95 BCD*10.3 Orig. Material Estimated Cost A 
CURMATECSR 96 BCD*10.3 Reserved A 
CURMATECHM 97 BCD*10.3 Current Material Estimated Cost A 
ACTMATECSR 98 BCD*10.3 Reserved A 
ACTMATECHM 99 BCD*10.3 Actual Material Cost A 
RECMATECSR 100 BCD*10.3 Reserved A 
RECMATECHM 101 BCD*10.3 Reserved A 
ORJMATEBSR 104 BCD*10.3 Orig. Material Billing Est. A 
ORJMATEBHM 105 BCD*10.3 Orig. Material Billing Est. A 
CURMATEBSR 106 BCD*10.3 Cur. Material Billing Est. A 
CURMATEBHM 107 BCD*10.3 Cur. Material Billing Est. A 
ACTMATEBSR 108 BCD*10.3 Actual Material Amount Billed A 
ACTMATEBHM 109 BCD*10.3 Actual Material Amount Billed A 
RECMATEBSR 110 BCD*10.3 Reserved A 
RECMATEBHM 111 BCD*10.3 Reserved A 
ORJMATEQTY 114 BCD*10.5 Orig. Material Qty Est. A 
CURMATEQTY 115 BCD*10.5 Cur. Material Est. A 
ACTMATEQTY 116 BCD*10.5 Actual Material Qty A 
ORJEQUICSR 118 BCD*10.3 Reserved A 
ORJEQUICHM 119 BCD*10.3 Orig. Estimated Equipment Cost A 
CUREQUICSR 120 BCD*10.3 Reserved A 
CUREQUICHM 121 BCD*10.3 Cur. Estimated Equipment Cost A 
ACTEQUICSR 122 BCD*10.3 Reserved A 
ACTEQUICHM 123 BCD*10.3 Actual Equipment Cost A 
RECEQUICSR 124 BCD*10.3 Reserved A 
RECEQUICHM 125 BCD*10.3 Reserved A 
ORJEQUIBSR 128 BCD*10.3 Orig. Equipment Billing Est. A 
ORJEQUIBHM 129 BCD*10.3 Orig. Equipment Billing Est. A 
CUREQUIBSR 130 BCD*10.3 Cur. Equipment Billing Est. A 
CUREQUIBHM 131 BCD*10.3 Cur. Equipment Billing Est. A 
ACTEQUIBSR 132 BCD*10.3 Actual Equipment Amount Billed A 
ACTEQUIBHM 133 BCD*10.3 Actual Equipment Amount Billed A 
RECEQUIBSR 134 BCD*10.3 Reserved A 
RECEQUIBHM 135 BCD*10.3 Reserved A 
ORJEQUIQTY 138 BCD*10.5 Orig. Equipment Qty Est. A 
CUREQUIQTY 139 BCD*10.5 Cur. Equipment Est. A 
ACTEQUIQTY 140 BCD*10.5 Actual Equipment Qty A 
ORJSUBCCSR 142 BCD*10.3 Reserved A 
ORJSUBCCHM 143 BCD*10.3 Orig. Subcontractor Est. Cost A 
CURSUBCCSR 144 BCD*10.3 Reserved A 
CURSUBCCHM 145 BCD*10.3 Cur. Subcontractor Est. Cost A 
ACTSUBCCSR 146 BCD*10.3 Reserved A 
ACTSUBCCHM 147 BCD*10.3 Actual Subcontractor Cost A 
RECSUBCCSR 148 BCD*10.3 Reserved A 
RECSUBCCHM 149 BCD*10.3 Reserved A 
ORJSUBCBSR 152 BCD*10.3 Orig. Subcontract Billing Est. A 
ORJSUBCBHM 153 BCD*10.3 Orig. Subcontract Billing Est. A 
CURSUBCBSR 154 BCD*10.3 Cur. Subcontract Billing Est. A 
CURSUBCBHM 155 BCD*10.3 Cur. Subcontract Billing Est. A 
ACTSUBCBSR 156 BCD*10.3 Actual Subcontract Amt Billed A 
ACTSUBCBHM 157 BCD*10.3 Actual Subcontract Amt Billed A 
RECSUBCBSR 158 BCD*10.3 Reserved A 
RECSUBCBHM 159 BCD*10.3 Reserved A 
ORJSUBCQTY 162 BCD*10.5 Orig. Subcontractor Qty Est. A 
CURSUBCQTY 163 BCD*10.5 Cur. Subcontractor Est. A 
ACTSUBCQTY 164 BCD*10.5 Actual Subcontractor Qty A 
ORJOHEXCSR 166 BCD*10.3 Reserved A 
ORJOHEXCHM 167 BCD*10.3 Orig. Est Overhead Expense Cost A 
CUROHEXCSR 168 BCD*10.3 Reserved A 
CUROHEXCHM 169 BCD*10.3 Cur. Est. Overhead Expense Cost A 
ACTOHEXCSR 170 BCD*10.3 Reserved A 
ACTOHEXCHM 171 BCD*10.3 Actual Overhead Expense Cost A 
RECOHEXCSR 172 BCD*10.3 Reserved A 
RECOHEXCHM 173 BCD*10.3 Reserved A 
ORJOHEXBSR 176 BCD*10.3 Orig. Overhead Billing Est. A 
ORJOHEXBHM 177 BCD*10.3 Orig. Overhead Billing Est. A 
CUROHEXBSR 178 BCD*10.3 Cur. Overhead Billing Est. A 
CUROHEXBHM 179 BCD*10.3 Cur. Overhead Billing Est. A 
ACTOHEXBSR 180 BCD*10.3 Actual Overhead Amount Billed A 
ACTOHEXBHM 181 BCD*10.3 Actual Overhead Billing Est. A 
RECOHEXBSR 182 BCD*10.3 Reserved A 
RECOHEXBHM 183 BCD*10.3 Reserved A 
ORJOHEXQTY 186 BCD*10.5 Orig. Overhead Qty Est. A 
CUROHEXQTY 187 BCD*10.5 Cur. Overhead Est. A 
ACTOHEXQTY 188 BCD*10.5 Actual Overhead Qty A 
ORJMISCCSR 190 BCD*10.3 Reserved A 
ORJMISCCHM 191 BCD*10.3 Orig. Est. Miscellaneous Cost A 
CURMISCCSR 192 BCD*10.3 Reserved A 
CURMISCCHM 193 BCD*10.3 Cur. Est. Miscellaneous Cost A 
ACTMISCCSR 194 BCD*10.3 Reserved A 
ACTMISCCHM 195 BCD*10.3 Actual Miscellaneous Cost A 
RECMISCCSR 196 BCD*10.3 Reserved A 
RECMISCCHM 197 BCD*10.3 Reserved A 
ORJMISCBSR 200 BCD*10.3 Orig. Miscellaneous Billing Est A 
ORJMISCBHM 201 BCD*10.3 Orig. Miscellaneous Billing Est A 
CURMISCBSR 202 BCD*10.3 Cur. Miscellaneous Billing Est. A 
CURMISCBHM 203 BCD*10.3 Cur. Miscellaneous Billing Est. A 
ACTMISCBSR 204 BCD*10.3 Actual Miscellaneous Amt Billed A 
ACTMISCBHM 205 BCD*10.3 Actual Miscellaneous Amt Billed A 
RECMISCBSR 206 BCD*10.3 Reserved A 
RECMISCBHM 207 BCD*10.3 Reserved A 
ORJMISCQTY 210 BCD*10.5 Orig. Miscellaneous Qty Est. A 
CURMISCQTY 211 BCD*10.5 Cur. Miscellaneous Est. A 
ACTMISCQTY 212 BCD*10.5 Actual Miscellaneous Qty A 
ORJOHEADSR 214 BCD*10.3 Reserved A 
ORJOHEADHM 215 BCD*10.3 Original Overhead Estimate A 
CUROHEADSR 216 BCD*10.3 Reserved A 
CUROHEADHM 217 BCD*10.3 Current Overhead Estimate A 
ACTOHEADSR 218 BCD*10.3 Reserved A 
ACTOHEADHM 219 BCD*10.3 Actual Overhead A 
ORJLABSR 224 BCD*10.3 Original Labor Amount Estimate A 
ORJLABHM 225 BCD*10.3 Original Labor Amount Estimate A 
CURLABSR 226 BCD*10.3 Current Labor Amount Estimate A 
CURLABHM 227 BCD*10.3 Current Labor Amount Estimate A 
ACTLABSR 228 BCD*10.3 Actual Labor Amount A 
ACTLABHM 229 BCD*10.3 Actual Labor Amount A 
ORJCHRGSR 234 BCD*10.3 Reserved A 
ORJCHRGHM 235 BCD*10.3 Reserved A 
CURCHRGSR 236 BCD*10.3 Reserved A 
CURCHRGHM 237 BCD*10.3 Reserved A 
ACTCHRGSR 238 BCD*10.3 Actual Charge Amount Billed A 
ACTCHRGHM 239 BCD*10.3 Actual Charge Amount Billed A 
ACTCHRGDSR 240 BCD*10.3 Act Chrg Amt Billed & Deferred A 
ACTCHRGDHM 241 BCD*10.3 Act Chrg Amt Billed & Deferred A 
RECCHRGSR 242 BCD*10.3 Reserved A 
RECCHRGHM 243 BCD*10.3 Reserved A 
ACTSTKRESR 246 BCD*10.3 Reserved A 
ACTSTKREHM 247 BCD*10.3 Act Cost Stock Ret to Inventory A 
ACTSTKRQTY 248 BCD*10.5 Act Qty Stock Ret to Inventory A 
TARRECTSSR 249 BCD*10.3 Total A/R Customer Receipts A 
TARRECTSHM 250 BCD*10.3 Total A/R Customer Receipts A 
TAPPAYMTS 251 BCD*10.3 Total A/P Vendor Payments A 
TORJCOSTSR 252 BCD*10.3 Reserved A 
TORJCOSTHM 253 BCD*10.3 Total Orig. Cost Est. A 
TCURCOSTSR 254 BCD*10.3 Reserved A 
TCURCOSTHM 255 BCD*10.3 Total Cur. Cost Est. A 
TACTCOSTSR 256 BCD*10.3 Reserved A 
TACTCOSTHM 257 BCD*10.3 Total Actual Cost A 
TRECCOSTSR 258 BCD*10.3 Reserved A 
TRECCOSTHM 259 BCD*10.3 Total Cost Recognized A 
PERTCOST 260 BCD*5.5 Percent Total Cost A 
TORJREVSR 262 BCD*10.3 Total Orig. Revenue Est. A 
TORJREVHM 263 BCD*10.3 Total Orig. Revenue Est. A 
TCURREVSR 264 BCD*10.3 Total Cur. Revenue Est. A 
TCURREVHM 265 BCD*10.3 Total Cur. Revenue Est. A 
TACTREVSR 266 BCD*10.3 Total Actual Revenue A 
TACTREVHM 267 BCD*10.3 Total Actual Revenue Est. A 
TRECREVSR 268 BCD*10.3 Total Revenue Recognized A 
TRECREVHM 269 BCD*10.3 Total Revenue Recognized A 
RETARAMTSR 272 BCD*10.3 Retainage Receivable A 
RETARAMTHM 273 BCD*10.3 Retainage Receivable A 
RETARRECSR 274 BCD*10.3 Retainage Amount Received in A/R A 
RETARRECHM 275 BCD*10.3 Retainage Amount Received in A/R A 
RETAPAMT 276 BCD*10.3 Retainage Payable A 
RETAPPAID 277 BCD*10.3 Retainage Amount Paid in A/P A 
POAMOUNTSR 278 BCD*10.3 Reserved E A 
POAMOUNTHM 279 BCD*10.3 Reserved E A 
POQTY 280 BCD*10.5 Reserved E A 
OEAMOUNTSR 281 BCD*10.3 Reserved E A 
OEAMOUNTHM 282 BCD*10.3 Recognized Loss A 
OEQTY 283 BCD*10.5 Reserved E A 
PCOMLETERR 286 BCD*5.5 Recognized % Complete E A 
FPAMOUNTSR 287 BCD*10.3 ^2 Amount E A 
FPAMOUNTHM 288 BCD*10.3 ^2 Amount E A 
LSTBILLPER 289 BCD*5.5 Last Billings Percent Complete E A 
BILLAMTSR 290 BCD*10.3 Amt Bill Fixed Price ^1 E A 
BILLAMTHM 291 BCD*10.3 Amt Bill Fixed Price ^1 E A 
COSTDATE 294 Date Last Cost Posting Date E A 
BILLDATE 295 Date Last Billings Posting Date E A 
OHDATE 296 Date Last Overhead Posting Date E A 
CHARGEDATE 297 Date Last Charge Posting Date E A 
REVRECDATE 298 Date Last Rev. Recognition Posting Date E A 
ARRECDATE 299 Date Last A/R Receipt Posting Date E A 
APPAYDATE 300 Date Last A/P Payment Posting Date E A 
TIMEDATE 301 Date Last Timecard Posting Date E A 
STKTRDATE 302 Date Last Material Usage Posting Date E A 
STKRETDATE 303 Date Last Material Return Posting Date E A 
EQUIPDATE 304 Date Last Equipment Posting Date E A 
PODATE 305 Date Last Purchase Order Date E A 
PORECDATE 306 Date Last P/O Receipt Date E A 
PORETDATE 307 Date Last P/O Return Date E A 
OEORDDATE 308 Date Last O/E Order Date E A 
OEINVDATE 309 Date Last O/E Invoice Date E A 
FUNCRND 310 BCD*10.3 Functional Rounding Amount E A 
NEXTTRAN 311 Long Next Transaction Number E A 
OPENPROJ 312 Long Number of open ^5 A 
OPENED 313 Boolean ^1 Has Been Opened E A  List:2 entries
0 = No
1 = Yes
BILLAMT 314 BCD*10.3 Expected Billings A 
PCOMPLETEB 315 BCD*5.5 Billings Percent Complete E A 
LSTRRPER 316 BCD*5.5 Last Rev. Recognition Percentage E A 
PRFTLOSSSR 317 BCD*10.3 Recognized Profit / Loss E A 
PRFTLOSSHM 318 BCD*10.3 Recognized Profit / Loss E A 
REVESTDATE 319 Date Last Revised Posting Date E A 
CDATEFROM 320 Date Current Start Date E A 
PLCODE 321 String*16 Reserved E A 
RRMETHOD 322 Integer Percentage Complete Method A  List:3 entries
1 = Clear Billings and WIP During Revenue Recognition
0 = Clear Billings and WIP During Project Close
2 = From Options
NUMPROJECT 323 Long Number of Projects A 
POCOSTHM 324 BCD*10.3 Committed P/O Cost A 
POOHHM 325 BCD*10.3 Committed P/O Overhead A 
POLABORHM 326 BCD*10.3 Committed P/O Labor A 
POTCOSTHM 327 BCD*10.3 Committed P/O Total Cost A 
VALUES 328 Long Optional Fields E A 
CUSCONTACT 329 String*60 Contact E A 
CTACTITTLE 330 String*60 Position E A 
CTACPHONE 331 String*30 Phone E A  Mask: (%-3C) %-3C-%-24C
OTHERPHONE 332 String*30 Other Phone E A  Mask: (%-3C) %-3C-%-24C
CTACFAX 333 String*30 Fax E A  Mask: (%-3C) %-3C-%-24C
CTACEMAIL 334 String*60 E-mail E A 
USETAXGRP 335 Boolean Tax Group E A 
CODETAXGRP 336 String*12 Tax Group E A  Mask: %-12N
TCLASS1 337 Integer Tax Class 1 E A 
TCLASS2 338 Integer Tax Class 2 E A 
TCLASS3 339 Integer Tax Class 3 E A 
TCLASS4 340 Integer Tax Class 4 E A 
TCLASS5 341 Integer Tax Class 5 E A 
TAUTH1 342 String*12 Customer Tax Authority 1 E A 
TAUTH2 343 String*12 Customer Tax Authority 2 E A 
TAUTH3 344 String*12 Customer Tax Authority 3 E A 
TAUTH4 345 String*12 Customer Tax Authority 4 E A 
TAUTH5 346 String*12 Customer Tax Authority 5 E A 
STRDCOSTHM 347 BCD*10.3 Stored Cost A 
STRDBILLSR 348 BCD*10.3 Stored Billable Amount A 
STRDOHHM 349 BCD*10.3 Overhead Amount A 
STRDTCSTHM 350 BCD*10.3 Total Stored Cost A 
TXEXPCOMHM 351 BCD*10.3 Tax (exp) Committed (func) A 
TXALLCOMHM 352 BCD*10.3 Tax (all) Committed (func) A 
PREAIAPAY 353 BCD*10.3 Previous Certificates for Payment E A 
PRESTORED 354 BCD*10.3 G703 Column F from Last AIA Report E A 
PRERETAIN 355 BCD*10.3 G703 Column I from Last AIA Report E A 
MULTICUST 356 Integer Invoice to Multiple Customers E A 
CURVAR 357 Integer Currency different from that on project? E A C 
BONECUST 358 Integer Allow Multiple Customers A X  List:2 entries
1 = Yes
0 = No
ARACCTSET 359 String*6 A/R Account Set E A  Mask: %-6N
FUNCTION 1000 Integer Function E A  List:5 entries
0 = None
1 = Update Project Status
3 = Update COSTPLUSP on projects
4 = Verify ALL totals
10 = Load Optional Fields
PARM16 1001 Integer 16 Bit Parameter E A 
PARMSTR 1002 String*200 String Parameter E A 
CTTVALID 1006 Boolean Contract Number is valid E A 
CUSTNAME 1007 String*60 Customer Name A 
BMETER 1008 Integer Show progress bar during posting E A  List:3 entries
0 = No meter
1 = Meter
2 = Meter but no cancel button
DELETING 1009 Boolean Deleting Contract E A