Search Tips
Control File = JCIMPJOB.ctl
| Column Name | Screen Prompt | Description | Required | Type | Length |
|---|---|---|---|---|---|
| JCJI_COMP_CODE | Company | Company Code – This will be validated against the CMiC Company table. | Yes | Char | 8 |
| JCJI_JOB_CODE | Job Code | The job code to import or the string "*TO BE GENERATED*" if the system is creating the job code. | Yes | Char | 10 |
| JCJI_JOB_NAME | Name | Job Name – If the third party system does not have a job name, then a common method of creating a name is a concatenation of the address, city, and state. | No | Char | 60 |
| JCJI_JOB_LONG_CODE | Job Long Code – This is the job code used by the third party software. If the job code is set to "*TO BE GENERATED*" then this field will be used to help generate the job code if this field is not null. The first six characters of this field will be used as the first six digits of the job code. This field is also stored as a reference field on the Job Master file. | No | Char | 24 | |
| JCJI_JOB_CTRL_CODE | Control Job | Controlling Job Code – If the job is not a sub-job then enter the value "ALL". The controlling job must exist in the system or import file. Leave as null if the Job Control Long Code field is being used. | No | Char | 10 |
| JCJI_JOB_CTRL_LONG_CODE | Controlling Job Long Code – If the job being created is a sub-job then populate the Controlling Job Long Code field. Leave as null if the Job Control Code is being used. The Controlling Job Long Code must exist in the system or import file. | No | Char | 24 | |
| JCJI_CUST_CODE | Customer | Customer Code – This will be validated against the CMiC Customer Table. If the job is a Job Billing type job then the customer code is required. | No | Char | 8 |
| JCJI_CONTRACT_CODE | Contract | Contract Code − If this field is left blank the contract code will be set to the same as the job code. | No | Char | 8 |
| JCJI_CONTRACT_AMT | Current Contract Amount | The contract amount. | No | Num | 18,2 |
| JCJI_WM_CODE | The unit of measurement will be validated against the CMiC WM table. Set to the Not Applicable WM Code. | No | Char | 2 | |
| JCJI_EST_START_DATE 'DD-MON-YYYY' | Estimated Start Date | The Estimated Start Date of the job. | No | Date | |
| JCJI_EST_COMPL_DATE 'DD-MON-YYYY' | Estimated End Date | The Estimated End Date of the job. | No | Date | |
| JCJI_JOB_LOC_CODE | Location | Location Code will be validated against the CMiC Location Table. | No | Char | 5 |
| JCJI_PROJ_MGR | Project Manager | Project Manager – validated against the valid list of company contacts. Required, if mandatory on JC Control file. | No | Char | 10 |
| JCJI_TERMS | Terms | Terms Code validated against the CMiC Terms Code values. | Yes | Char | 6 |
| JCJI_MKT_SEC | Market Sector | The Market Sector value validated against the valid values in CMiC. | No | Char | 10 |
| JCJI_RET_CODE | Retainage Code | Retainage code validated against the retainage code maintained in CMiC. | No | Char | 10 |
| JCJI_ADDR_TYPE | Address Type | Address type validated against the business partner address codes. | No | Char | 5 |
| JCJI_WORK_LOC | Work Location | Work location validated against the valid CMiC work locations. | No | Char | 15 |
| JCJI_ALLOW_TRANS | Allow Transactions | 'Allow Transactions' checkbox value. Valid values are "Y" or "N". | No | Char | 1 |
| JCJI_BID_FLAG | Bid Job | Indicates if the job is still in the bid stage or not. "Y" indicates that this is a bid job. Do not flag this field if the job has already been won as it is considered to be a job in progress. A bid job cannot be billed via Job Billing. | Yes | Char | 1 Only Y/N are valid values |
| JCJI_BID_SUBMIT_DATE 'DD-MON-YYYY' | Bid Date | The Bid Submit date for this job. | No | Date | |
| JCJI_INV_FORMAT_CODE | Default Invoice Format | The Job Billing invoice format code. If entered, this must be a valid format code previously defined in the Job Billing module. | No | Char | 30 |
| JCJI_DEPT_CODE | Default Department | The department the job belongs to. If this is left blank, the department from the Job Cost Control File will be used. This must be a valid CMiC department code. | No | Char | 5 |
| JCJI_BILL_METH_CODE | Billing Method | The method that will be used to bill this job. Valid values are "AR" or "JB". | Yes | Char | 2 |
| JCJI_REVENUE_GEN_STATE | Revenue Generation | The revenue generation method to be used on this job. The valid values are "J" as costs incurred and no GL, "G" as costs incurred with GL. | Yes | Char | 1 |
| JCJI_BILLING_TYPE_CODE | Default Billing Type | This is the default type of billing to be used for JB only. This must be a valid CMiC Job Billing Type code if the Job Billing method is JB. | No | Char | 4 |
| JCJI_INVOICE_GROUP_CODE | Invoice Link | Leave blank unless otherwise told by CMiC. | No | Char | 10 |
| JCJI_PHS_CAT_TO_BILL_FLAG | Not utilized, but required to be set to ‘Y’. | Yes | Char | 1 | |
| JCJI_CONSTRUCTION_VALUE | Construction Value | Value of the complete job not just your own portion of the contract. This can be left blank. Do not set to zero. | No | Num | 18,2 |
| JCJI_MAX_HOURLY_RATE | Maximum Hourly Rate | The maximum hourly rate that is allowed to be charged to this job. | No | Num | 18,2 |
| JCJI_MAX_BILLING_AMT | Maximum Billing Amount | The maximum amount that can be billed to the owner for this job. Do not set to zero. | No | Num | 18,2 |
| JCJI_MAX_BILLING_BUDGET_AMT | Maximum Revenue Cap | The maximum amount of revenue allowed to be generated, before the auto-reserve function kicks in. | No | Num | 18,2 |
| JCJI_USE_PAY_BILL_RATE_FLAG | Use Payroll Bill Rates | Indicates if bill rates are derived from Payroll or the Job Billing Rate table defined for the job. | Yes | Char | 1 Only Y/N are valid values |
| JCJI_IB_ALLOW_FLAG | Allow Inter-branch charges | Does this job allow inter-branch charges? | Yes | Char | 1 Only Y/N are valid values |
| JCJI_BILLING_RATE_TABLE_CODE | Job Billing: Billing Rate Table | The Billing Rate Table to be used for this job. Required if the job is a Job Billing Type job. This must be an existing valid Billing Rate table. | No | Char | 10 |
| JCJI_IB_FULL_TARIFF_FLAG | Inter-branch Full Tariff used flag | Full tariff refers to inter-branching. If the tariff is partial, set to ‘N’, otherwise set to ‘Y’. | Yes | Char | 1 Only Y/N are valid values |
| JCJI_SEC_GROUP1 | Job Security Group Code | Job Security Code – If entered must be a valid security code for this company. If there is no security applied, you will need to utilize the JC security functions in System Data to give access to this job. | No | Char | 10 |
| JCJI_SEC_GROUP2 | Job Security Group Code | See above. | No | Char | 10 |
| JCJI_SEC_GROUP3 | Job Security Group Code | See above. | No | Char | 10 |
| JCJI_SEC_GROUP4 | Job Security Group Code | See above. | No | Char | 10 |
| JCJI_SEC_GROUP5 | Job Security Group Code | See above. | No | Char | 10 |
| JCJI_USER_FIELD1 | User Extension Field # 1 | If User Extensions are defined for jobs, then these next 10 fields represent the 10 fields specified on the Import utility and you may want to import the appropriate data, otherwise it can be entered manually after the import. | No | Char | 2000 |
| JCJI_USER_FIELD2 | User Extension Field # 2 | See above. | No | Char | 2000 |
| JCJI_USER_FIELD3 | User Extension Field # 3 | See above. | No | Char | 2000 |
| JCJI_USER_FIELD4 | User Extension Field # 4 | See above. | No | Char | 2000 |
| JCJI_USER_FIELD5 | User Extension Field # 5 | See above. | No | Char | 2000 |
| JCJI_USER_FIELD6 | User Extension Field # 6 | See above. | No | Char | 2000 |
| JCJI_USER_FIELD7 | User Extension Field # 7 | See above. | No | Char | 2000 |
| JCJI_USER_FIELD8 | User Extension Field # 8 | See above. | No | Char | 2000 |
| JCJI_USER_FIELD9 | User Extension Field # 9 | See above. | No | Char | 2000 |
| JCJI_USER_FIELD10 | User Extension Field # 10 | See above. | No | Char | 2000 |
| JCJI_PHS_TEMPLATE | Phase Template Code | Any phase template entered on the job record will override the template entered during the Create Job process. | No | Char | 8 |
| JCJI_ACT_START_DATE 'DD-MON-YYYY' | Actual Start Date | If this is entered, the job will be considered "In Process" instead of "Pending". | No | Date |