Import Budgets directly into Sage 100 Contractor. Simply download your budgets into Excel, review and apply budget information and import directly into Sage 100 Contractor 6-2 Budgets.
Are you tired of manually keying in Budgets one by one into Sage 100 Contractor? Would you rather download your budgets, 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-2 Budgets data entry form.
Header | Reference | Data Type | Tab | Example | Description |
filetype | Required | PJBUDGET | PJBUDGET | PJBUDGET | |
lckedt | Required | Numeric | 1=Yes;0=No (1) | Lock Edit | |
setbdgt | Required | Numeric | 1=Yes;0=No (1) | Set Budget | |
recnum | Required ** | Numeric | Job No | ||
phsnum | ** | Numeric | Phase No | ||
cstcde | Required ** | Numeric (9,3) | Cost Code | ||
hrsbdg | Numeric (10,2) | Hours | |||
matbdg | Numeric (10,2) | Material | |||
labbdg | Numeric (10,2) | Labor | |||
eqpbdg | Numeric (10,2) | Equipment | |||
subbdg | Numeric (10,2) | Subcontract | |||
othbdg | Numeric (10,2) | Other | |||
usrcs6 | Numeric (10,2) | User Def 6 | |||
usrcs7 | Numeric (10,2) | User Def 7 | |||
usrcs8 | Numeric (10,2) | User Def 8 | |||
usrcs9 | Numeric (10,2) | User Def 9 | |||
estunt | Numeric (8,4) | No Units | |||
usrdf1 | String (50) | User Defined | |||
ntetxt | Text | Notes |