Standard Database Settings setup form
Fill out one copy of this form.
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Job cost tab
Job cost interface type (choose one):
Sage 300 Construction
None
Complete the appropriate table (below) based on the interface type you selected. If you chose None, no additional entries are needed for this tab.
Sage 300 Construction Job Cost interface
Field Entry |
Use Sage 300 Constructions
Job Cost data (Select this check box if you want to import information, such as cost codes, categories from Job Cost.) |
Use the same format for Sage Estimating (Select this check box to use the same format and job cost phase codes for Sage Estimating and job cost phase codes.) |
Transfer crew units as man
hours |
Job Cost phase suffix |
Job Cost cost categories: |
Labor ________________ Prefills with: LAB |
Material ________________ Prefills with: MAT |
Subcontract ________________ Prefills with: SUB |
Equipment ________________ Prefills with: EQU |
Other ________________ Prefills with: OTH |
Export folder |
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Miscellaneous tab
Field Entry |
Sage Estimating phase code suffix |
Labor/Equipment: |
||
Hours per day _________ Prefills with: 8.0 |
||
Hours per week _________ Prefills with: 40.0 |
||
Hours per month _________ Prefills with: 173.33 |
||
Multiple Labor Productivities: |
|
|
When there is no labor productivity on the specified table |
Choose
one:
|
|
Multiple Price: |
|
|
When there is no price on the specified table |
Choose
one:
|
|
|
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Crew pricing tab (if you have a license for Crews)
Field Entry |
Default labor rate table (enter the table name) |
Default equipment rate table (enter the table name) |
Default crew pricing: |
Reporting hours: |
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
WBS tab
WBS Code | Name | Size | Unit | Type (check one) |
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 ![]() ![]() ![]() |
|
13 ![]() ![]() ![]() |
|
14 ![]() ![]() ![]() |
|
15 ![]() ![]() ![]() |
|
16 ![]() ![]() ![]() |
|
17 ![]() ![]() ![]() |
|
18 ![]() ![]() ![]() |
|
19 ![]() ![]() ![]() |
|
20 ![]() ![]() ![]() |
|
21 ![]() ![]() ![]() |
|
22 ![]() ![]() ![]() |
|
23 ![]() ![]() ![]() |
|
24 ![]() ![]() ![]() |
|
25 ![]() ![]() ![]() |
|
26 ![]() ![]() ![]() |
|
27 ![]() ![]() ![]() |
|
28 ![]() ![]() ![]() |
|
29 ![]() ![]() ![]() |
|
30 ![]() ![]() ![]() |
|
31 ![]() ![]() ![]() |
|
32 ![]() ![]() ![]() |
|
33 ![]() ![]() ![]() |
|
34 ![]() ![]() ![]() |
|
35 ![]() ![]() ![]() |
|
36 ![]() ![]() ![]() |
|
37 ![]() ![]() ![]() |
|
38 ![]() ![]() ![]() |
|
39 ![]() ![]() ![]() |
|
40 ![]() ![]() ![]() |
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Item Sorting tab
Item Sort Number and Description sort elements (choose up to four) |
1 |
2 |
3 |
4 |
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Productivities/Prices tab
This tab is available when you select to use multiple labor productivities or prices on the Miscellaneous tab.
Labor Productivity Tables
Price Tables
Name | Description | Source | Default | Source Web Address |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
13 |
14 |
15 |
16 |
17 |
18 |
19 |
20 |