View: ^5

RotoID: PM0022
Tables: PMPROJS, PMPROJT
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:PMPROJS

Compositions: 5

RotoID Tables Title DLL
PM0021 PMCONTSPMCONTT ^4 PMCONTS
PM0039 PMCATGT ^1 ^6 PMCATGT
PM0120 PMRES ^1 Resources PMRES
PM0121 PMRESC ^1 Resource ^6 PMRESC
PM0851 PMPROJSO Project Optional Field PMPROJSO

Keys: 4

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

Fields: 412

Field Index Type Title Attributes Presentation
CTUNIQ 1 BCD*10.0 ^1 Uniq E A K R 
PLINENUM 2 Long Line Number E A K R 
CONTRACT 3 String*16 ^1 E A  Mask: %-16C
PROJECT 4 String*16 ^2 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 ^2 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 ^2 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 X  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 ^6 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 Labor Percentage Complete 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 
CUSTOMER 416 String*12 Customer E A X  Mask: %-12C
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 Percent Total Revenue 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 Recognized Loss 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 Date 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 Last O/E Invoice Date A 
PTAXTOTAL 284 BCD*10.3 Project tax total 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 ^2 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 ^2 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
CODETAXGRP 392 String*12 Tax Group E A  Mask: %-12N
CTCLASS1 393 Integer Customer Tax Class 1 E A 
CTCLASS2 394 Integer Customer Tax Class 2 E A 
CTCLASS3 395 Integer Customer Tax Class 3 E A 
CTCLASS4 396 Integer Customer Tax Class 4 E A 
CTCLASS5 397 Integer Customer Tax Class 5 E A 
CTAUTH1 398 String*12 Customer Tax Authority 1 E A 
CTAUTH2 399 String*12 Customer Tax Authority 2 E A 
CTAUTH3 400 String*12 Customer Tax Authority 3 E A 
CTAUTH4 401 String*12 Customer Tax Authority 4 E A 
CTAUTH5 402 String*12 Customer Tax Authority 5 E A 
LUPDATE 403 Date Last US Payroll Posting Date A 
LCPDATE 404 Date Last Canadian Payroll Posting Date A 
STRDCOSTHM 405 BCD*10.3 Stored Cost A 
STRDBILLSR 406 BCD*10.3 Stored Billable Amount A 
PRECOLEDSR 407 BCD*10.3 Previous D + E A 
STRDOHHM 408 BCD*10.3 Overhead Amount A 
STRDTCSTHM 409 BCD*10.3 Total Stored Cost A 
TXEXPCOMHM 410 BCD*10.3 Tax (exp) Committed (func) A 
TXALLCOMHM 411 BCD*10.3 Tax (all) Committed (func) A 
STRDQTY 412 BCD*10.5 Stored Quantity A 
PREAIAPAY 413 BCD*10.3 Previous Certificates for Payment A 
PRESTORED 414 BCD*10.3 G703 Column F from Last AIA Report A 
PRERETAIN 415 BCD*10.3 G703 Column I from Last AIA Report A 
IDACCTSET 417 String*6 Account Set E A  Mask: %-6N
CUSTCCY 418 String*3 Customer Currency E A 
CUSCONTACT 419 String*60 Contact E A 
CTACTITTLE 420 String*60 Position E A 
CTACPHONE 421 String*30 Phone E A  Mask: (%-3C) %-3C-%-24C
OTHERPHONE 422 String*30 Other Phone E A  Mask: (%-3C) %-3C-%-24C
CTACFAX 423 String*30 Fax E A  Mask: (%-3C) %-3C-%-24C
CTACEMAIL 424 String*60 E-mail E A 
MULTICUST 425 Integer Invoice to Multiple Customers E A X  List:2 entries
1 = Yes
0 = No
BILLED 426 Integer Has this ^2 been billed? E A 
OESHPDATE 427 Date Last O/E Shipment Date A 
PRICEOPT 428 Integer Default Billing Rate E A X  List:3 entries
1 = Billing Rate
2 = Use Customer Price List
3 = Use Specified Price List
PRICELIST 429 String*6 Price List A X  Mask: %-6N
OEMCHGOPT 430 Integer O/E Miscellaneous Charges E A X  List:2 entries
0 = Default Cost from Contract
1 = Default Cost from Misc. Charges
ARACCTSET 431 String*6 A/R Account Set E A X  Mask: %-6N
UPCP 1001 Integer Update Category Cost Plus % rt E A C 
FUNCTION 1002 Integer Function rt 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 rt 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 rt A C 
REVDESC 1005 String*60 Revenue Account Description rt A C 
WIPDESC 1006 String*60 WIP Account Description rt A C 
COGSDESC 1007 String*60 COGS Account Description rt A C 
RCOSTPLUSP 1008 BCD*5.5 Cost Plus % at Read rt A C 
ORJQTY 1010 BCD*10.5 Quantity rt A C 
CURQTY 1011 BCD*10.5 Current Quantity Estimate rt A C 
ACTQTY 1012 BCD*10.5 Actual Quantity rt A C 
ORJCOSTHM 1013 BCD*10.3 Extended Cost rt A C 
CURCOSTHM 1014 BCD*10.3 Current Cost Estimate rt A C 
ACTCOSTHM 1015 BCD*10.3 Actual Cost rt A C 
SNAPCALC 1016 Integer Extended Cost rt E A 
SNAPOFROM 1017 Date Extended Cost rt E A X 
SNAPOTO 1018 Date Extended Cost rt E A X 
SNAPCFROM 1019 Date Extended Cost rt A X 
SNAPCTO 1020 Date Extended Cost rt A X 
HASOPT 1021 Boolean Optional Fields rt E A C  List:2 entries
1 = Yes
0 = No
OPENING 1022 Integer Optional Fields rt E A C  List:3 entries
0 = Not opening
1 = Contract opening
2 = Project opening
UPDATE 1023 Integer Optional Fields rt E A C 
CUSTNAME 1024 String*60 Customer Name rt A C 

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