| CTUNIQ |
BCD*10.0 |
Contract Unique Code |
|
| PLINENUM |
Long |
Project Line Number |
|
| CLINENUM |
Long |
Line Number |
|
| AUDTDATE |
Date |
|
|
| AUDTTIME |
Time |
|
|
| AUDTUSER |
String*8 |
|
|
| AUDTORG |
String*6 |
|
|
| CONTRACT |
String*16 |
Contract |
Mask: %-16C |
| PROJECT |
String*16 |
Project |
Mask: %-16N |
| CATEGORY |
String*16 |
Category |
Mask: %-16N |
| CCY |
String*3 |
Currency |
Mask: %-3N |
| DETAILNUM |
Long |
Project Detail Number |
|
| DNUM |
Long |
Category Detail Number |
|
| DATELASTMN |
Date |
Last Maintained |
|
| DESC |
String*60 |
Description |
|
| COSTTYPE |
String*10 |
Cost Type |
Mask: %-10N |
| TYPE |
Integer |
Cost Class |
List: 6 entries
| 1 | = | Labor | | 2 | = | Material | | 3 | = | Equipment | | 4 | = | Subcontractor | | 5 | = | Overhead | | 6 | = | Miscellaneous |
|
| PONUMBER |
String*22 |
Last Purchase Order Number |
Mask: %-22C |
| 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 |
|
| ARITEM |
String*16 |
A/R Item No. |
Mask: %-16C |
| 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 |
|
| BILLRATE |
BCD*10.6 |
Billing Rate |
|
| 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 |
|
| 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 |
|
| 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 |
|
| ACTBILLHM |
BCD*10.3 |
Total Actual Revenue |
|
| ACTBILLSR |
BCD*10.3 |
Total Actual Revenue |
|
| ACTBILRRHM |
BCD*10.3 |
Total Revenue Recognized |
|
| ACTBILRRSR |
BCD*10.3 |
Total Revenue Recognized |
|
| CCYBILL |
String*3 |
Customer Currency |
Mask: %-3N |
| TORJCOSTSR |
BCD*10.3 |
Reserved |
|
| TORJCOSTHM |
BCD*10.3 |
Total Original Estimate Cost |
|
| TCURCOSTSR |
BCD*10.3 |
Reserved |
|
| TCURCOSTHM |
BCD*10.3 |
Total Current Estimate Cost |
|
| TACTCOSTSR |
BCD*10.3 |
Reserved |
|
| TACTCOSTHM |
BCD*10.3 |
Total Actual Cost |
|
| TCOSTRRSR |
BCD*10.3 |
Reserved |
|
| TCOSTRRHM |
BCD*10.3 |
Total Cost Recognized |
|
| PERTOTCOST |
BCD*5.5 |
Percent Total Cost |
|
| TARRECTSSR |
BCD*10.3 |
Total A/R Customer Receipts |
|
| TARRECTSHM |
BCD*10.3 |
Total A/R Customer Receipts |
|
| TAPPAYMTS |
BCD*10.3 |
A/P Vendor Payments |
|
| PERRETPAID |
BCD*5.5 |
A/P Retainage Percentage |
|
| RETPAIDD |
Integer |
A/P Retention Period |
|
| RETARAMTSR |
BCD*10.3 |
Retainage Receivable |
|
| RETARAMTHM |
BCD*10.3 |
Retainage Receivable |
|
| RETARRECSR |
BCD*10.3 |
Retainage Amount Received in A/R |
|
| RETARRECHM |
BCD*10.3 |
Retainage Amount Received in A/R |
|
| RETAPAMT |
BCD*10.3 |
Retainage Payable |
|
| RETAPPAID |
BCD*10.3 |
Retainage Amount Paid in A/P |
|
| POAMOUNTSR |
BCD*10.3 |
Reserved |
|
| POAMOUNTHM |
BCD*10.3 |
Reserved |
|
| POQTY |
BCD*10.5 |
Committed P/O Quantity |
|
| OEAMOUNTSR |
BCD*10.3 |
Reserved |
|
| OEAMOUNTHM |
BCD*10.3 |
Recognized Loss |
|
| OEQTY |
BCD*10.5 |
Reserved |
|
| POSTDATE |
Date |
Last Posting Date |
|
| WIPACCT |
String*45 |
Work in Progress |
Mask: %-45C |
| COSTACCT |
String*45 |
Cost of Sales |
Mask: %-45C |
| PAYACCT |
String*45 |
Payroll Expense |
Mask: %-45C |
| EXPACCT |
String*45 |
Employee Expense |
Mask: %-45C |
| EQUIPACCT |
String*45 |
Equipment |
Mask: %-45C |
| OHACCT |
String*45 |
Overhead |
Mask: %-45C |
| LABACCT |
String*45 |
Labor |
Mask: %-45C |
| GAINACCT |
String*45 |
Unrecognized Gain/Loss |
Mask: %-45C |
| LCSTAMT |
BCD*10.3 |
Last Cost Amount |
|
| LCSTDATE |
Date |
Last Cost Date |
|
| INVPEND |
BCD*10.3 |
Invoice Pending |
|
| LRECAMT |
BCD*10.3 |
Last Amount Recognized |
|
| LRECDATE |
Date |
Last Recognized Date |
|
| LINVAMT |
BCD*10.3 |
Last Invoice Amount |
|
| LINVDATE |
Date |
Last Invoice Date |
|
| TAUTH1 |
String*12 |
Tax Authority 1 |
Mask: %-12N |
| TAUTH2 |
String*12 |
Tax Authority 2 |
Mask: %-12N |
| TAUTH3 |
String*12 |
Tax Authority 3 |
Mask: %-12N |
| TAUTH4 |
String*12 |
Tax Authority 4 |
Mask: %-12N |
| TAUTH5 |
String*12 |
Tax Authority 5 |
Mask: %-12N |
| TCLASS1 |
Integer |
Tax Class 1 |
|
| TCLASS2 |
Integer |
Tax Class 2 |
|
| TCLASS3 |
Integer |
Tax Class 3 |
|
| TCLASS4 |
Integer |
Tax Class 4 |
|
| TCLASS5 |
Integer |
Tax Class 5 |
|
| TINCLUDED1 |
Boolean |
Tax Included 1 |
|
| TINCLUDED2 |
Boolean |
Tax Included 2 |
|
| TINCLUDED3 |
Boolean |
Tax Included 3 |
|
| TINCLUDED4 |
Boolean |
Tax Included 4 |
|
| TINCLUDED5 |
Boolean |
Tax Included 5 |
|
| TAXBASES1 |
BCD*10.3 |
Tax Base 1 |
|
| TAXBASES2 |
BCD*10.3 |
Tax Base 2 |
|
| TAXBASES3 |
BCD*10.3 |
Tax Base 3 |
|
| TAXBASES4 |
BCD*10.3 |
Tax Base 4 |
|
| TAXBASES5 |
BCD*10.3 |
Tax Base 5 |
|
| TAXBASEH1 |
BCD*10.3 |
Tax Base 1 |
|
| TAXBASEH2 |
BCD*10.3 |
Tax Base 2 |
|
| TAXBASEH3 |
BCD*10.3 |
Tax Base 3 |
|
| TAXBASEH4 |
BCD*10.3 |
Tax Base 4 |
|
| TAXBASEH5 |
BCD*10.3 |
Tax Base 5 |
|
| TAXAMTS1 |
BCD*10.3 |
Tax Amount 1 |
|
| TAXAMTS2 |
BCD*10.3 |
Tax Amount 2 |
|
| TAXAMTS3 |
BCD*10.3 |
Tax Amount 3 |
|
| TAXAMTS4 |
BCD*10.3 |
Tax Amount 4 |
|
| TAXAMTS5 |
BCD*10.3 |
Tax Amount 5 |
|
| TAXAMTH1 |
BCD*10.3 |
Tax Amount 1 |
|
| TAXAMTH2 |
BCD*10.3 |
Tax Amount 2 |
|
| TAXAMTH3 |
BCD*10.3 |
Tax Amount 3 |
|
| TAXAMTH4 |
BCD*10.3 |
Tax Amount 4 |
|
| TAXAMTH5 |
BCD*10.3 |
Tax Amount 5 |
|
| INVSTATE |
Integer |
Invoice Status |
List: 3 entries
| 1 | = | Not Processed | | 2 | = | On Worksheet | | 3 | = | On Invoice |
|
| BILLAMT |
BCD*10.3 |
Expected Billings |
|
| LSTBILLPER |
BCD*5.5 |
Last Billings Percent Complete |
|
| PRFTLOSSSR |
BCD*10.3 |
Recognized Profit / Loss |
|
| PRFTLOSSHM |
BCD*10.3 |
Recognized Profit / Loss |
|
| REVESTDATE |
Date |
Last Revised Posting Date |
|
| LSTRRPER |
BCD*5.5 |
Last Rev. Recognition Percentage |
|
| 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 |
|
| ODATEFROM |
Date |
Projected Start Date |
|
| ODATETO |
Date |
Projected End Date |
|
| CDATEFROM |
Date |
Current Start Date |
|
| CDATETO |
Date |
Current End Date |
|
| ORATETYPE |
String*2 |
Original Rate Type |
|
| ORATEDATE |
Date |
Original Rate Date |
|
| ORATE |
BCD*8.7 |
Original Rate |
|
| CRATETYPE |
String*2 |
Current Rate Type |
|
| CRATEDATE |
Date |
Current Rate Date |
|
| CRATE |
BCD*8.7 |
Current Rate |
|
| PLCODE |
String*16 |
Reserved |
|
| DEFRETFROM |
Integer |
Default Retainage From |
List: 2 entries
|
| BILLAMTC |
BCD*10.3 |
Current Billings (AR and on BW) |
|
| 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 |
|
| VALUES |
Long |
Optional Fields |
|
| TCUNITCOST |
Integer |
Default Unit Cost From |
List: 3 entries
| 0 | = | Use Default PJC Option | | 2 | = | PJC Employee Setup | | 6 | = | Category |
|
| TCBILLRATE |
Integer |
Default Billing Rate From |
List: 3 entries
| 0 | = | Use Default PJC Option | | 2 | = | PJC Employee Setup | | 6 | = | Category |
|
| CEACCT |
String*45 |
Cost |
Mask: %-45C |
| 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 |
|
|