Sage 100 Contractor 6-5 Cost Codes
Overview:
Import Cost Codes directly into Sage 100 Contractor. Simply download your cost codes into Excel, review and apply cost code information and import directly into Sage 100 Contractor 6-5 Cost Codes.
Are you tired of manually keying in Cost Codes one by one into Sage 100 Contractor? Would you rather download your cost codes, fill in the blanks in Excel and import the details directly into Sage 100 Contractor? The following integration template allows you to do just that. It mimics every feature and function of the 6-5 Cost Codes data entry form.
Key Features:
- Download Cost Codes into Excel
- Edit key cost code information in Excel
- Bulk import cost codes directly into Sage 100 Contractor
- Supports all native features and functions of the 6-5 Cost Codes Entry Form
Import Template Download:
Import File Layout:
| Header | Reference | Data Type | Tab | Example | Description |
| filetype | Required | PJCC | PJCC | PJCC | |
| recnum | Required | Numeric(9,3) | 2010.000 | Cost Code | |
| cdenme | Required | String(50) | Interior Demolition | Cost Code Name | |
| divnum | Required ** | Numeric | Division | ||
| untdsc | String(10) | Unit Desc | |||
| cmpcde | ** | Numeric | Comp Code 1 | ||
| maxwge | Numeric(3,2) | Max Wage | |||
| cmpcd2 | ** | Numeric | Comp Code 2 | ||
| dptnum | ** | Numeric | Department | ||
| ntetxt | TEXT | Notes | |||
| inactv | String(1) | Y=Yes;N=No | Inactive |
** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor
File Example:
filetype,recnum,cdenme,divnum
PJCC,2011.000,"Interior Demo",2
PJCC,2012.000,"Exterior Demo",2