What is in the JCE file created by Sage Estimating? (SQL)
Description
Cause
Resolution
The Job Cost Transfer wizard creates a category transaction with the following fields for each job cost category set up for items in the estimate. Additional addon transactions are generated if you decide not to allocate addons. The information comes from the job cost phases and categories in the estimate spreadsheet.

Field

Description

Size

1

Type of record (C)

1

2

Job cost phase code

15

3

Phase description

30

4

Job cost category

3

5

Date of file generation (mmddyyyy)

8

6

Item quantity

8.2 signed

7

Unit description

4

8

Amount

8.2 signed

 

Example:


"C"," 318100"," ","LAB",02051997,0.66,"hour",9.90,,,"",""

 

[BCB:164:Chat Estimating US:ECB] 
Steps to duplicate
Related Solutions

Getting Started: Sage 300 CRE Job Cost interface (SQL)