View: Super View

RotoID: PM0482

Protocol: Superview
DLL:PMCPRJ

Keys: 1

Title Fields
Customer / Contract CUSTOMER, CONTRACT

Fields: 307

Field Index Type Title Attributes Presentation
CTUNIQ 1 BCD*10.0 ^1 Uniq E A R 
CONTRACT 2 String*16 Unformatted ^1 E A K  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 

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