| CTUNIQ |
BCD*10.0 |
Contract Uniq |
|
| AUDTDATE |
Date |
|
|
| AUDTTIME |
Time |
|
|
| AUDTUSER |
String*8 |
|
|
| AUDTORG |
String*6 |
|
|
| CONTRACT |
String*16 |
Unformatted Contract |
Mask: %-16C |
| DESC |
String*60 |
Description |
|
| DATELASTMN |
Date |
Last Maintained |
|
| CONTBRKID |
String*6 |
Structure Code |
Mask: %-6N |
| FMTCONTNO |
String*16 |
Contract |
Mask: %-16C |
| CUSTOMER |
String*12 |
Customer Number |
Mask: %-12C |
| MANAGER |
String*16 |
Contract Manager |
Mask: %-16N |
| PONUMBER |
String*22 |
P/O Number |
Mask: %-22C |
| CONTACT |
String*60 |
Contact |
|
| PHONE |
String*30 |
Telephone |
Mask: %-30c |
| FAX |
String*30 |
Fax |
Mask: %-30c |
| STARTDATE |
Date |
Start Date |
|
| ORJENDDATE |
Date |
Original End Date |
|
| CURENDDATE |
Date |
Projected End Date |
|
| CLOSEDDATE |
Date |
Closed Date |
|
| COMMENT |
String*250 |
Comment |
|
| USERR |
Boolean |
Use Contract Revenue Recognition Information |
|
| 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 |
|
| USEOVERH |
Boolean |
Use the Contract Overhead Information |
|
| OVERHEAD |
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 |
|
| USELABOR |
Boolean |
Use the Contract Labor Information |
|
| 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 |
|
| STATUS |
Integer |
Contract Status |
List: 7 entries
| 10 | = | Estimate | | 20 | = | Approved | | 30 | = | Open | | 40 | = | On Hold | | 70 | = | Inactive | | 60 | = | Completed | | 50 | = | Closed |
|
| USECOSTP |
Boolean |
Use the Contract Cost Plus Percentage |
|
| COSTPLUSP |
BCD*5.5 |
Cost Plus Percentage |
|
| USEPTYPE |
Integer |
Project Type |
|
| PROJTYPE |
Integer |
Project Type |
List: 3 entries
| 1 | = | Time and Materials | | 2 | = | Fixed Price | | 3 | = | Cost Plus |
|
| CHANGEORD |
Integer |
Number of Change Orders to the Contract |
|
| NXTCHGORD |
Long |
Next Change Order Number |
|
| IDACCTSET |
String*6 |
Account Set |
Mask: %-6N |
| TEMPLAT |
String*16 |
Template |
Mask: %-16C |
| USEBILL |
Boolean |
Use the Contract Billing Type |
|
| BILLTYPE |
Integer |
Billing Type |
List: 3 entries
| 2 | = | Billable | | 3 | = | No Charge | | 1 | = | Non-billable |
|
| SCHCODE |
String*12 |
Schedule |
Mask: %-12N |
| USERETAIN |
Boolean |
Use the Contract Retainage Information |
|
| PERRETREC |
BCD*5.5 |
A/R Retainage Percentage |
|
| RETRECD |
Integer |
A/R Retention Period |
|
| PERRETPAID |
BCD*5.5 |
Reserved |
|
| RETPAIDD |
Integer |
Reserved |
|
| SEGMENT1 |
String*16 |
Segment 1 |
|
| SEGMENT2 |
String*16 |
Segment 2 |
|
| SEGMENT3 |
String*16 |
Segment 3 |
|
| SEGMENT4 |
String*16 |
Segment 4 |
|
| SEGMENT5 |
String*16 |
Segment 5 |
|
| CONSOLINV |
Boolean |
Consolidate Projects onto the One Invoice |
|
| FORMCODE |
String*6 |
Form Code |
Mask: %-6N |
| NEXTNUM |
Long |
Next Detail Number |
|
| NUMDETAILS |
Long |
Number of Details |
|
| 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 |
|
| CUSTCCY |
String*3 |
Customer Currency |
Mask: %-3N |
| CONTSTYLE |
Integer |
Contract Style |
List: 2 entries
|
| ORJTIMECSR |
BCD*10.3 |
Number of non percent projects |
|
| 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 Amount Billed |
|
| ACTMATEBHM |
BCD*10.3 |
Actual Material Amount 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 |
|
|