| CTUNIQ |
BCD*10.0 |
^1 Uniq |
|
| PLINENUM |
Long |
Project Line Number |
|
| CLINENUM |
Long |
Line Number |
|
| AUDTDATE |
Date |
|
|
| AUDTTIME |
Time |
|
|
| AUDTUSER |
String*8 |
|
|
| AUDTORG |
String*6 |
|
|
| CONTRACT |
String*16 |
^1 |
Mask: %-16C |
| PROJECT |
String*16 |
^2 |
Mask: %-16N |
| DETAILNUM |
Long |
^2 Detail Number |
|
| DATELASTMN |
Date |
Last Maintained |
|
| PNUM |
Long |
Employee Detail Number |
|
| DNUM |
Long |
Detail Number |
|
| TYPE |
Integer |
Cost Class |
List:6 entries
| 1 |
= |
Labor |
| 2 |
= |
Material |
| 3 |
= |
Equipment |
| 4 |
= |
Subcontractor |
| 5 |
= |
Overhead |
| 6 |
= |
Miscellaneous |
|
| RESOURCE |
String*24 |
Resource |
Mask: %-16N |
| ITEMNO |
String*24 |
Unformatted Item Number |
Mask: %-24C |
| LOCATION |
String*6 |
Location |
Mask: %-6N |
| CONVERSION |
BCD*10.6 |
Conversion Factor |
|
| CATEGORY |
String*16 |
^3 |
Mask: %-16N |
| COMMENT |
String*60 |
Description |
|
| COSTTYPE |
String*10 |
Cost Type |
Mask: %-10N |
| BILLTYPE |
Integer |
Billing Type |
List:3 entries
| 2 |
= |
Billable |
| 3 |
= |
No Charge |
| 1 |
= |
Non-billable |
|
| ORJQTY |
BCD*10.5 |
Quantity |
|
| CURQTY |
BCD*10.5 |
Current Quantity Estimate |
|
| ACTQTY |
BCD*10.5 |
Actual Quantity |
|
| UOM |
String*10 |
Unit of Measure |
Mask: %-10C |
| UNITCOST |
BCD*10.6 |
Unit Cost |
|
| ORJCOSTSR |
BCD*10.3 |
Reserved |
|
| ORJCOSTHM |
BCD*10.3 |
Extended Cost |
|
| CURCOSTSR |
BCD*10.3 |
Reserved |
|
| CURCOSTHM |
BCD*10.3 |
Current Cost Estimate |
|
| ACTCOSTSR |
BCD*10.3 |
Reserved |
|
| ACTCOSTHM |
BCD*10.3 |
Actual Cost |
|
| OVERHD |
Integer |
Overhead Type |
List:3 entries
| 1 |
= |
None |
| 2 |
= |
Flat Rate Per Unit |
| 5 |
= |
Percentage of Cost |
|
| OHEADRATE |
BCD*10.6 |
Overhead Rate |
|
| HEADPER |
BCD*5.5 |
Overhead Percentage |
|
| ORJOHSR |
BCD*10.3 |
Reserved |
|
| ORJOHHM |
BCD*10.3 |
Original Overhead Estimate |
|
| CUROHSR |
BCD*10.3 |
Reserved |
|
| CUROHHM |
BCD*10.3 |
Current Overhead Estimate |
|
| ACTOHSR |
BCD*10.3 |
Reserved |
|
| ACTOHHM |
BCD*10.3 |
Actual Overhead |
|
| BILLRATE |
BCD*10.6 |
Billing Rate |
|
| COSTPLUSP |
BCD*5.5 |
Cost Plus Percentage |
|
| ORJBILLSR |
BCD*10.3 |
Revenue |
|
| ORJBILLHM |
BCD*10.3 |
Revenue |
|
| CURBILLSR |
BCD*10.3 |
Current Revenue Estimate |
|
| CURBILLHM |
BCD*10.3 |
Current Revenue Estimate |
|
| ACTBILLSR |
BCD*10.3 |
Actual Revenue |
|
| ACTBILLHM |
BCD*10.3 |
Actual Revenue |
|
| ARITEM |
String*16 |
A/R Item No. |
Mask: %-16C |
| LABOR |
Integer |
Labor Type |
List:3 entries
| 1 |
= |
None |
| 2 |
= |
Flat Rate Per Labor Hour/Unit |
| 3 |
= |
Percentage of Labor Cost |
|
| LABORRATE |
BCD*10.6 |
Labor Rate |
|
| LABORPER |
BCD*5.5 |
Labor Percentage |
|
| ORJLABORSR |
BCD*10.3 |
Reserved |
|
| ORJLABORHM |
BCD*10.3 |
Original Labor Amount Estimate |
|
| CURLABORSR |
BCD*10.3 |
Reserved |
|
| CURLABORHM |
BCD*10.3 |
Current Labor Amount Estimate |
|
| ACTLABORSR |
BCD*10.3 |
Reserved |
|
| ACTLABORHM |
BCD*10.3 |
Actual Labor Amount |
|
| TORJCOSTSR |
BCD*10.3 |
Reserved |
|
| TORJCOSTHM |
BCD*10.3 |
Original Total Cost |
|
| TCURCOSTSR |
BCD*10.3 |
Reserved |
|
| TCURCOSTHM |
BCD*10.3 |
Current Total Cost |
|
| TACTCOSTSR |
BCD*10.3 |
Reserved |
|
| TACTCOSTHM |
BCD*10.3 |
Actual Total Cost |
|
| ADJUNITCST |
BCD*10.6 |
Reserved |
|
| COSTSEQNUM |
Long |
Reserved |
|
| COSTDATE |
Date |
Reserved |
|
| STOCKITEM |
Boolean |
Reserved |
|
| BILLAMT |
BCD*10.3 |
Expected Billings |
|
| OOHTYPE |
Integer |
Overhead Type |
List:3 entries
| 1 |
= |
None |
| 2 |
= |
Flat Rate Per Unit |
| 5 |
= |
Percentage of Cost |
|
| OOHRATE |
BCD*10.6 |
Overhead Rate |
|
| OOHPER |
BCD*5.5 |
Overhead Percentage |
|
| COHTYPE |
Integer |
Overhead Type |
List:3 entries
| 1 |
= |
None |
| 2 |
= |
Flat Rate Per Unit |
| 5 |
= |
Percentage of Cost |
|
| COHRATE |
BCD*10.6 |
Overhead Rate |
|
| COHPER |
BCD*5.5 |
Overhead Percentage |
|
| OLABORTYPE |
Integer |
Labor Type |
List:3 entries
| 1 |
= |
None |
| 2 |
= |
Flat Rate Per Labor Hour/Unit |
| 3 |
= |
Percentage of Labor Cost |
|
| OLABORRATE |
BCD*10.6 |
Labor Rate |
|
| OLABORPER |
BCD*5.5 |
Labor Percentage |
|
| CLABORTYPE |
Integer |
Labor Type |
List:3 entries
| 1 |
= |
None |
| 2 |
= |
Flat Rate Per Labor Hour/Unit |
| 3 |
= |
Percentage of Labor Cost |
|
| CLABORRATE |
BCD*10.6 |
Labor Rate |
|
| CLABORPER |
BCD*5.5 |
Labor Percentage |
|
| OUNITCOST |
BCD*10.6 |
Original Unit Cost |
|
| OBILLRATE |
BCD*10.6 |
Original Billing Rate |
|
| OCOSTPLUSP |
BCD*5.5 |
Original Cost Plus Percentage |
|
| CUNITCOST |
BCD*10.6 |
Current Unit Cost |
|
| CBILLRATE |
BCD*10.6 |
Current Billing Rate |
|
| CCOSTPLUSP |
BCD*5.5 |
Current Cost Plus Percentage |
|
| ICUOM |
String*10 |
^7 |
Mask: %-10c |
| ODATEFROM |
Date |
Projected Start Date |
|
| ODATETO |
Date |
Projected End Date |
|
| CDATEFROM |
Date |
Current Start Date |
|
| CDATETO |
Date |
Current End Date |
|
| POQTY |
BCD*10.5 |
Committed P/O Quantity |
|
| POCOSTHM |
BCD*10.3 |
Committed P/O Cost |
|
| POOHHM |
BCD*10.3 |
Committed P/O Overhead |
|
| POLABORHM |
BCD*10.3 |
Committed P/O Labor |
|
| POTCOSTHM |
BCD*10.3 |
Committed P/O Total Cost |
|
| TCUNITCOST |
Integer |
Default Unit Cost From |
List:1 entries
| 0 |
= |
Use Default PJC Option |
|
| TCBILLRATE |
Integer |
Default Billing Rate From |
List:1 entries
| 0 |
= |
Use Default PJC Option |
|
| PAYTYPE |
Integer |
|
List:3 entries
| 3 |
= |
None |
| 1 |
= |
US Payroll |
| 2 |
= |
Canadian Payroll |
|
| STRDQTY |
BCD*10.5 |
Stored Quantity |
|
| STRDCOSTHM |
BCD*10.3 |
Stored Cost |
|
| STRDBILLSR |
BCD*10.3 |
Stored Billable Amount |
|
| PRECOLEDSR |
BCD*10.3 |
Previous D + E |
|
| STRDOHHM |
BCD*10.3 |
Overhead Amount |
|
| STRDTCSTHM |
BCD*10.3 |
Total Stored Cost |
|
| TXEXPCOMHM |
BCD*10.3 |
Tax (exp) Committed (func) |
|
| TXALLCOMHM |
BCD*10.3 |
Tax (all) Committed (func) |
|
| PREAIAPAY |
BCD*10.3 |
Previous Certificates for Payment |
|
| PRESTORED |
BCD*10.3 |
G703 Column F from Last AIA Report |
|
| PRERETAIN |
BCD*10.3 |
G703 Column I from Last AIA Report |
|
|