Sage 100 Contractor 8-3 Equipment
Overview:
Import Equipment directly into Sage 100 Contractor. Simply download your equipment into Excel, review and apply equipment information and import directly into Sage 100 Contractor 8-3 Equipment.
Are you tired of manually keying in Equipment one by one into Sage 100 Contractor? Would you rather download your equipment, 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 8-3 Equipment data entry form.
Key Features:
- Download Equipment into Excel
- Edit key equipment information in Excel
- Bulk import equipment directly into Sage 100 Contractor
- Supports all native features and functions of the 8-3 Equipment Entry Form
Import Template Download:
Import File Layout:
| Header | Reference | Data Type | Tab | Example | Description |
| filetype | Required | EQUIP | EQUIP | EQUIP | |
| recnum | Required | Numeric | Header | Equip No | |
| eqpnme | Required(I) | String (50) | Header | Equip Desc | |
| shtnme | Required(I) | String (30) | Header | Equip Short Name | |
| status | Required(I) ** | Numeric | Header | 1-Available;2-Under Repair;3-Out of Service;4-Sold | Status |
| eqptyp | ** | Numeric | Header | Equip Type | |
| srlnum | String (30) | General Info | Serial# | ||
| licnum | String (30) | General Info | License# | ||
| pucnum | String (30) | General Info | PUC# | ||
| usrdf1 | String (50) | General Info | User Def1 | ||
| usrdf2 | String (50) | General Info | User Def2 | ||
| lstloc | String (75) | General Info | Last Location | ||
| pchdte | Date | General Info | yyyy-mm-dd | Purchase Date | |
| slddte | Date | General Info | yyyy-mm-dd | Sold Date | |
| orghrs | Numeric (10,2) | General Info | Original Hours | ||
| orgmls | Numeric (10,2) | General Info | Original Miles | ||
| ttlhrs | Numeric (10,2) | General Info | Total Hours | ||
| ttlmls | Numeric (10,2) | General Info | Total Miles | ||
| intact | ** | Numeric | Financial Info | Interest Exp Acct | |
| depact | ** | Numeric | Financial Info | Depreciation Exp Acct | |
| depmnt | ** | Numeric | Financial Info | Department | |
| lontyp | ** | Numeric | Financial Info | 0-None;1-Amortized;2-Principal + Interest;3-Lease | Loan Type |
| lender | ** | Numeric | Financial Info | Lender | |
| lonnum | String (30) | Financial Info | Loan# | ||
| nxtpay | Date | Financial Info | yyyy-mm-dd | Loan Pay Date | |
| intrte | Numeric (10,2) | Financial Info | Loan Interest Rate | ||
| paymnt | Numeric (10,2) | Financial Info | Loan Pmt Amt | ||
| deprte | Numeric (10,2) | Financial Info | Monthly Depreciation | ||
| strdte | Date | Cost Recov Wrksht | yyyy-mm-dd | Start Date | |
| enddte | Date | Cost Recov Wrksht | yyyy-mm-dd | End Date | |
| strval | Numeric (10,2) | Cost Recov Wrksht | Start Value | ||
| endval | Numeric (10,2) | Cost Recov Wrksht | Ending Value | ||
| unttyp | ** | Numeric | Cost Recov Wrksht | 1-Hours;2-Days;3-Weeks;4-Months;5-Miles | Est Use Unit type |
| estuse | Numeric (10,2) | Cost Recov Wrksht | Est Use Amount | ||
| insrnc | Numeric (10,2) | Cost Recov Wrksht | Cost of Own - Insurance | ||
| taxlic | Numeric (10,2) | Cost Recov Wrksht | Cost of Own - Tax and Lic | ||
| inspct | Numeric (10,2) | Cost Recov Wrksht | Cost of Own - Inspection | ||
| storag | Numeric (10,2) | Cost Recov Wrksht | Cost of Own - Storage | ||
| ovrhed | Numeric (10,2) | Cost Recov Wrksht | Cost of Own - Overhaul | ||
| financ | Numeric (10,2) | Cost Recov Wrksht | Cost of Own - Financing | ||
| cstcap | Numeric (10,2) | Cost Recov Wrksht | Cost of Own - Cost of Capital | ||
| othcst | Numeric (10,2) | Cost Recov Wrksht | Cost of Own - Other Costs | ||
| fuloil | Numeric (10,2) | Cost Recov Wrksht | Cost of Oper - Fuel and Oil | ||
| oilchg | Numeric (10,2) | Cost Recov Wrksht | Cost of Oper - Oil Change | ||
| fluchg | Numeric (10,2) | Cost Recov Wrksht | Cost of Oper - Fluid Change | ||
| mntcst | Numeric (10,2) | Cost Recov Wrksht | Cost of Oper - Maintenance | ||
| csttir | Numeric (10,2) | Cost Recov Wrksht | Cost of Oper - Tires | ||
| minrpr | Numeric (10,2) | Cost Recov Wrksht | Cost of Oper - Minor Repair | ||
| othopr | Numeric (10,2) | Cost Recov Wrksht | Cost of Oper - Other Cost | ||
| oprcst | Numeric (10,2) | Cost and Bill Rates | Operated - Cost Rates | ||
| oprbll | Numeric (10,2) | Cost and Bill Rates | Operated - Bill Rates | ||
| dyopbl | Numeric (10,2) | Cost and Bill Rates | Operated - Daily | ||
| wkopbl | Numeric (10,2) | Cost and Bill Rates | Operated - Weekly | ||
| mtopbl | Numeric (10,2) | Cost and Bill Rates | Operated - Monthly | ||
| idlcst | Numeric (10,2) | Cost and Bill Rates | Idled - Cost Rates | ||
| idlbll | Numeric (10,2) | Cost and Bill Rates | Idled - Bill Rates | ||
| dyidbl | Numeric (10,2) | Cost and Bill Rates | Idled - Daily | ||
| wkidbl | Numeric (10,2) | Cost and Bill Rates | Idled - Weekly | ||
| mtidbl | Numeric (10,2) | Cost and Bill Rates | Idled - Monthly | ||
| stbcst | Numeric (10,2) | Cost and Bill Rates | Standby - Cost Rates | ||
| stbbll | Numeric (10,2) | Cost and Bill Rates | Standby - Bill Rates | ||
| dystbl | Numeric (10,2) | Cost and Bill Rates | Standby - Daily | ||
| wkstbl | Numeric (10,2) | Cost and Bill Rates | Standby - Weekly | ||
| mtstbl | Numeric (10,2) | Cost and Bill Rates | Standby - Monthly | ||
| moblbl | Numeric (10,2) | Cost and Bill Rates | Mobilization Billing Amt | ||
| ntetxt | Text | Header | Notes |
Required(I) - required for Inserts only
** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor
File Example:
filetype,recnum,eqpnme,shtnme,status,eqptyp,srlnum,licnum,pucnum
EQUIP,19101,"Equip #101","EQ101",1,,"","",""
EQUIP,19102,"Equip #102","EQ102",1,,"","",""
EQUIP,19103,"Equip #103","EQ103",1,,"","",""