| CTUNIQ |
BCD*10.0 |
Contract Uniq |
|
| PLINENUM |
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 |
| DETAILNUM |
Long |
Detail Number |
|
| DATELASTMN |
Date |
Last Maintained |
|
| STARTDATE |
Date |
Projected Start Date |
|
| ORJENDDATE |
Date |
Projected End Date |
|
| CURENDDATE |
Date |
Current End Date |
|
| CLOSEDDATE |
Date |
Date Closed |
|
| DESC |
String*60 |
Description |
|
| PROJTYPE |
Integer |
Project Type |
List: 3 entries
| 1 | = | Time and Materials | | 2 | = | Fixed Price | | 3 | = | Cost Plus |
|
| REVREC |
Integer |
Accounting Method |
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 |
BCD*5.5 |
Cost Plus Percentage |
|
| CLOSEBILL |
Integer |
Closed to Billings |
List: 2 entries
|
| CLOSECOST |
Integer |
Closed to Costs |
List: 2 entries
|
| PROJSTAT |
Integer |
Project Status |
List: 7 entries
| 10 | = | Estimate | | 20 | = | Approved | | 30 | = | Open | | 40 | = | On Hold | | 70 | = | Inactive | | 60 | = | Completed | | 50 | = | Closed |
|
| USEDEFREV |
Integer |
Revenue Type |
List: 2 entries
| 0 | = | Revenue | | 1 | = | Deferred Revenue |
|
| BILLTYPE |
Integer |
Billing Type |
List: 3 entries
| 2 | = | Billable | | 3 | = | No Charge | | 1 | = | Non-billable |
|
| PERRETREC |
BCD*5.5 |
A/R Retainage Percentage |
|
| RETRECD |
Integer |
A/R Retention Period |
|
| BILLACCT |
String*45 |
Billings |
Mask: %-45C |
| DEFRACCT |
String*45 |
Deferred Revenue |
Mask: %-45C |
| REVACCT |
String*45 |
Revenue |
Mask: %-45C |
| PROFITACCT |
String*45 |
Profit |
Mask: %-45C |
| LOSSACCT |
String*45 |
Loss |
Mask: %-45C |
| GAINACCT |
String*45 |
Gain |
Mask: %-45C |
| WIPACCT |
String*45 |
Work in Progress |
Mask: %-45C |
| COGSACCT |
String*45 |
Cost of Sales |
Mask: %-45C |
| PONUMBER |
String*22 |
P/O Number |
Mask: %-22C |
| FORMCODE |
String*6 |
Form Code |
Mask: %-6N |
| INVTYPE |
Integer |
A/R Invoice Type |
List: 2 entries
|
| ORATE |
BCD*8.7 |
Original Exchange Rate |
|
| ORATETYPE |
String*2 |
Original Rate Type |
Mask: %-2N |
| ORATEDATE |
Date |
Original Rate Date |
|
| RATE |
BCD*8.7 |
Exchange Rate |
|
| RATETYPE |
String*2 |
Rate Type |
Mask: %-2N |
| RATEOP |
Integer |
Rate Operator |
List: 2 entries
|
| RATEDATE |
Date |
Rate Date |
|
| RATESPREAD |
BCD*8.7 |
Rate Spread |
|
| ESTBILLCCY |
Integer |
Revenue And Cost Currency |
List: 3 entries
| 1 | = | Revenue and Costs in Functional Currency | | 2 | = | Revenue in Customer Currency | | 3 | = | Revenue and Costs in Customer Currency |
|
| COSTCCY |
String*3 |
Cost Currency |
Mask: %-3N |
| REVCCY |
String*3 |
Revenue Currency |
Mask: %-3N |
| INVSTATE |
Integer |
Invoice Status |
List: 3 entries
| 1 | = | Not Processed | | 2 | = | On Worksheet | | 3 | = | On Invoice |
|
| NUMCATS |
Long |
Number of Categories |
|
| ORJTIMECSR |
BCD*10.3 |
Reserved |
|
| ORJTIMECHM |
BCD*10.3 |
Orig. Labor Cost Est. |
|
| CURTIMECSR |
BCD*10.3 |
Reserved |
|
| CURTIMECHM |
BCD*10.3 |
Cur. Labor Cost Est. |
|
| ACTTIMECSR |
BCD*10.3 |
Reserved |
|
| ACTTIMECHM |
BCD*10.3 |
Actual Labor Costs |
|
| RECTIMECSR |
BCD*10.3 |
Reserved |
|
| RECTIMECHM |
BCD*10.3 |
Reserved |
|
| ORJTIMEBSR |
BCD*10.3 |
Orig. Labor Billing Est. |
|
| ORJTIMEBHM |
BCD*10.3 |
Orig. Labor Billing Est. |
|
| CURTIMEBSR |
BCD*10.3 |
Cur. Labor Billing Est. |
|
| CURTIMEBHM |
BCD*10.3 |
Cur. Labor Billing Est. |
|
| ACTTIMEBSR |
BCD*10.3 |
Actual Labor Billings |
|
| ACTTIMEBHM |
BCD*10.3 |
Actual Labor Billings |
|
| RECTIMEBSR |
BCD*10.3 |
Reserved |
|
| RECTIMEBHM |
BCD*10.3 |
Reserved |
|
| ORJTIMEQTY |
BCD*10.5 |
Orig. Labor Qty Est. |
|
| CURTIMEQTY |
BCD*10.5 |
Cur. Labor Qty Est. |
|
| ACTTIMEQTY |
BCD*10.5 |
Actual Labor Qty |
|
| PERTIMEQTY |
BCD*5.5 |
Labor Percentage Complete |
|
| ORJMATECSR |
BCD*10.3 |
Reserved |
|
| ORJMATECHM |
BCD*10.3 |
Orig. Material Estimated Cost |
|
| CURMATECSR |
BCD*10.3 |
Reserved |
|
| CURMATECHM |
BCD*10.3 |
Current Material Estimated Cost |
|
| ACTMATECSR |
BCD*10.3 |
Reserved |
|
| ACTMATECHM |
BCD*10.3 |
Actual Material Cost |
|
| RECMATECSR |
BCD*10.3 |
Reserved |
|
| RECMATECHM |
BCD*10.3 |
Reserved |
|
| ORJMATEBSR |
BCD*10.3 |
Orig. Material Billing Est. |
|
| ORJMATEBHM |
BCD*10.3 |
Orig. Material Billing Est. |
|
| CURMATEBSR |
BCD*10.3 |
Cur. Material Billing Est. |
|
| CURMATEBHM |
BCD*10.3 |
Cur. Material Billing Est. |
|
| ACTMATEBSR |
BCD*10.3 |
Actual Material Billed |
|
| ACTMATEBHM |
BCD*10.3 |
Actual Material Billed |
|
| RECMATEBSR |
BCD*10.3 |
Reserved |
|
| RECMATEBHM |
BCD*10.3 |
Reserved |
|
| ORJMATEQTY |
BCD*10.5 |
Orig. Material Qty Est. |
|
| CURMATEQTY |
BCD*10.5 |
Cur. Material Est. |
|
| ACTMATEQTY |
BCD*10.5 |
Actual Material Qty |
|
| ORJEQUICSR |
BCD*10.3 |
Reserved |
|
| ORJEQUICHM |
BCD*10.3 |
Orig. Estimated Equipment Cost |
|
| CUREQUICSR |
BCD*10.3 |
Reserved |
|
| CUREQUICHM |
BCD*10.3 |
Cur. Estimated Equipment Cost |
|
| ACTEQUICSR |
BCD*10.3 |
Reserved |
|
| ACTEQUICHM |
BCD*10.3 |
Actual Equipment Cost |
|
| RECEQUICSR |
BCD*10.3 |
Reserved |
|
| RECEQUICHM |
BCD*10.3 |
Reserved |
|
| ORJEQUIBSR |
BCD*10.3 |
Orig. Equipment Billing Est. |
|
| ORJEQUIBHM |
BCD*10.3 |
Orig. Equipment Billing Est. |
|
| CUREQUIBSR |
BCD*10.3 |
Cur. Equipment Billing Est. |
|
| CUREQUIBHM |
BCD*10.3 |
Cur. Equipment Billing Est. |
|
| ACTEQUIBSR |
BCD*10.3 |
Actual Equipment Amount Billed |
|
| ACTEQUIBHM |
BCD*10.3 |
Actual Equipment Amount Billed |
|
| RECEQUIBSR |
BCD*10.3 |
Reserved |
|
| RECEQUIBHM |
BCD*10.3 |
Reserved |
|
| ORJEQUIQTY |
BCD*10.5 |
Orig. Equipment Qty Est. |
|
| CUREQUIQTY |
BCD*10.5 |
Cur. Equipment Est. |
|
| ACTEQUIQTY |
BCD*10.5 |
Actual Equipment Qty |
|
| ORJSUBCCSR |
BCD*10.3 |
Reserved |
|
| ORJSUBCCHM |
BCD*10.3 |
Orig. Subcontractor Est. Cost |
|
| CURSUBCCSR |
BCD*10.3 |
Reserved |
|
| CURSUBCCHM |
BCD*10.3 |
Cur. Subcontractor Est. Cost |
|
| ACTSUBCCSR |
BCD*10.3 |
Reserved |
|
| ACTSUBCCHM |
BCD*10.3 |
Actual Subcontractor Cost |
|
| RECSUBCCSR |
BCD*10.3 |
Reserved |
|
| RECSUBCCHM |
BCD*10.3 |
Reserved |
|
| ORJSUBCBSR |
BCD*10.3 |
Orig. Subcontract Billing Est. |
|
| ORJSUBCBHM |
BCD*10.3 |
Orig. Subcontract Billing Est. |
|
| CURSUBCBSR |
BCD*10.3 |
Cur. Subcontract Billing Est. |
|
| CURSUBCBHM |
BCD*10.3 |
Cur. Subcontract Billing Est. |
|
| ACTSUBCBSR |
BCD*10.3 |
Actual Subcontract Amt Billed |
|
| ACTSUBCBHM |
BCD*10.3 |
Actual Subcontract Amt Billed |
|
| RECSUBCBSR |
BCD*10.3 |
Reserved |
|
| RECSUBCBHM |
BCD*10.3 |
Reserved |
|
| ORJSUBCQTY |
BCD*10.5 |
Orig. Subcontractor Qty Est. |
|
| CURSUBCQTY |
BCD*10.5 |
Cur. Subcontractor Est. |
|
| ACTSUBCQTY |
BCD*10.5 |
Actual Subcontractor Qty |
|
| ORJOHEXCSR |
BCD*10.3 |
Reserved |
|
| ORJOHEXCHM |
BCD*10.3 |
Orig. Est Overhead Expense Cost |
|
| CUROHEXCSR |
BCD*10.3 |
Reserved |
|
| CUROHEXCHM |
BCD*10.3 |
Cur. Est. Overhead Expense Cost |
|
| ACTOHEXCSR |
BCD*10.3 |
Reserved |
|
| ACTOHEXCHM |
BCD*10.3 |
Actual Overhead Expense Cost |
|
| RECOHEXCSR |
BCD*10.3 |
Reserved |
|
| RECOHEXCHM |
BCD*10.3 |
Reserved |
|
| ORJOHEXBSR |
BCD*10.3 |
Orig. Overhead Billing Est. |
|
| ORJOHEXBHM |
BCD*10.3 |
Orig. Overhead Billing Est. |
|
| CUROHEXBSR |
BCD*10.3 |
Cur. Overhead Billing Est. |
|
| CUROHEXBHM |
BCD*10.3 |
Cur. Overhead Billing Est. |
|
| ACTOHEXBSR |
BCD*10.3 |
Actual Overhead Amount Billed |
|
| ACTOHEXBHM |
BCD*10.3 |
Actual Overhead Billing Est. |
|
| RECOHEXBSR |
BCD*10.3 |
Reserved |
|
| RECOHEXBHM |
BCD*10.3 |
Reserved |
|
| ORJOHEXQTY |
BCD*10.5 |
Orig. Overhead Qty Est. |
|
| CUROHEXQTY |
BCD*10.5 |
Cur. Overhead Est. |
|
| ACTOHEXQTY |
BCD*10.5 |
Actual Overhead Qty |
|
| ORJMISCCSR |
BCD*10.3 |
Reserved |
|
| ORJMISCCHM |
BCD*10.3 |
Orig. Est. Miscellaneous Cost |
|
| CURMISCCSR |
BCD*10.3 |
Reserved |
|
| CURMISCCHM |
BCD*10.3 |
Cur. Est. Miscellaneous Cost |
|
| ACTMISCCSR |
BCD*10.3 |
Reserved |
|
| ACTMISCCHM |
BCD*10.3 |
Actual Miscellaneous Cost |
|
| RECMISCCSR |
BCD*10.3 |
Reserved |
|
| RECMISCCHM |
BCD*10.3 |
Reserved |
|
| ORJMISCBSR |
BCD*10.3 |
Orig. Miscellaneous Billing Est |
|
| ORJMISCBHM |
BCD*10.3 |
Orig. Miscellaneous Billing Est |
|
| CURMISCBSR |
BCD*10.3 |
Cur. Miscellaneous Billing Est. |
|
| CURMISCBHM |
BCD*10.3 |
Cur. Miscellaneous Billing Est. |
|
| ACTMISCBSR |
BCD*10.3 |
Actual Miscellaneous Amt Billed |
|
| ACTMISCBHM |
BCD*10.3 |
Actual Miscellaneous Amt Billed |
|
| RECMISCBSR |
BCD*10.3 |
Reserved |
|
| RECMISCBHM |
BCD*10.3 |
Reserved |
|
| ORJMISCQTY |
BCD*10.5 |
Orig. Miscellaneous Qty Est. |
|
| CURMISCQTY |
BCD*10.5 |
Cur. Miscellaneous Qty Est. |
|
| ACTMISCQTY |
BCD*10.5 |
Actual Miscellaneous Qty |
|
| CUSTOMER |
String*12 |
Customer |
Mask: %-12C |
|