Costpoint Help

File Layout

The file layout provides information on the fields included in the input file created by the Import Timesheets from Deltek Time and Expense application.

You name the input file when exporting timesheets from Time & Expense. After you upload a file, it is renamed with an extension of ".ZZZ". If a file with the same name and extension already exists, it is overwritten. This helps prevent uploading the same file twice.

When the import process for Time and Expense completes, the application creates a confirmation file with an extension of ".CFM". This confirmation file contains error information if any error occurred during the import process.

If you are using Deltek Time & Expense 7.x to 8.1.1, the file layout does not include the Withholding State field.

Note: The input file layout may contain fields that are available only in Costpoint Advanced. If you are using Costpoint Essentials, these fields are excluded from the import process and may be left blank or null when you create the input file.

Input File Excel Template

For Costpoint 2025.x and later releases, you can download the Excel template file specifically designed for this preprocessor from the Costpoint Preprocessor Guides page on the Deltek Learning Hub.

For Costpoint 8.1, the input file is available on the Developer Resources page in the Costpoint Information Center.

Excel templates for the other Costpoint preprocessors can be found in these same locations.

File Layout Information

#

Field Name

Length

Column #

Required/Optional

Format/Source

1

ET Batch ID

Char 10

1-10

Batch ID from Deltek Time & Expense

2

Employee ID

Char 12

11-22

Employee ID from Deltek Time & Expense

3

Year

Char 4

23-26

Spaces

4

Period Number

Char 3

27-29

Spaces

5

Timesheet Schedule

Char 10

30-39

Timesheet Schedule Code from Deltek Time & Expense

6

Line Number

Num 3

40-42

Line number from Deltek Time & Expense

7

Timesheet Line Date

Char 6

43-48

Required if the prorate Calculation Method is Days per Cycle (LAB_SETTINGS.prorate_calc_mthd = D).

If Summary, fill with spaces.

Otherwise, TS Date (YYMMDD).

8

Timesheet Date

Char 10

49-58

Required

(Default provided)

YYYY-MM-DD

9

Employee ID

Char 12

59-70

Required

10

Timesheet Type Code

Char 2

71-72

Required

(Default provided)

R, L, B, C, D, or N

11

Working State

Char 2

73-74

Required

(Default provided)

12

Fiscal Year

Char 6

75-80

Required

(Default provided)

13

Period

Num 2

81-82

Required

(Default provided)

14

Sub Period

Num 2

83-84

Required

(Default provided)

Note:

This field is not used if you have a Costpoint Starter Edition license. The value defaults to 1 when imported.

Required

(Default provided)

Note

15

Correcting Ref Date

Char 10

85-94

Optional

YYYY-MM-DD

16

Pay Type

Char 15

95-109

Required

(Default provided)

17

General Labor Category

Char 6

110-115

Required

(Default provided)

18

Timesheet Line Type Code

Char 1

116-116

Required

(Default provided)

A, B, L, M, S, W

19

Labor Cost Amount

Num 15

117-131

Required

(Default provided)

99999999999.99

20

Hours

Num 10

132-141

Required

-999999.99

21

Worker’s Comp Code

Char 6

142-147

Required

(Default provided)

22

Labor Location Code

Char 6

148-153

Required if the Require Labor Location check box is selected on the Configure Labor Settings screen.

(Default provided)

23

Organization ID

Char 20

154-173

Required

(Default provided)

24

Account ID

Char 15

174-188

Required

(Default provided)

25

Project ID

Char 30

189-218

Required if a Project Required account is specified.

(Default provided)

26

Project Labor Category

Char 6

219-224

Required /Optional status dependent upon project setup

(Default provided)

27

Reference Number 1

Char 20

225-244

Optional

(Default provided)

Note:

This field is not used if you have a Costpoint Starter Edition license.

Optional

(Default provided)

Note

28

Reference Number 2

Char 20

245-264

Optional

(Default provided)

Note:

This field is not used if you have a Costpoint Starter Edition license.

Optional

(Default provided)

Note

29

Manufacturing Order ID

Char 10

265-274

Required if the Timesheet Line Type Code is Mor W.

30

Operation Sequence No

Num 4

275 -278

Required if Operation Step No is specified and Timesheet Line Type Code is Mor W.

31

Operation Step No

Num 3

279-281

Required if Operation Sequence No is specified and Timesheet Line Type Code is Mor W.

32

Activity Type

Char 1

282-282

Required if the Timesheet Line Type Code is Mor W.

Ror S

If blank, Costpoint populates the timesheet with an R.

33

Work Center ID

Char 12

283-294

If the Timesheet Line Type Code is Mand no work center is provided in the input file, default the MO_ROUTING.wc_id where:

  1. The MO_ROUTING.mo_id matches the timesheet line Manufacturing Order ID (field 29).
  2. The MO_ROUTING.mo_oper_seq_no matches the timesheet line Operation Sequence No (field 30).

  3. The MO_ROUTING.mo_oper_step_no matches the timesheet line Operation Step No (field 31).

    If the Timesheet Line Type Code is Wand no work center is provided in the input file, default the WO_ROUTING.wc_id where:

  4. The WO_ROUTING.mo_id matches timesheet line Manufacturing Order ID (field 29).
  5. The WO_ROUTING.wo_oper_seq_no matches the timesheet line Operation Sequence No (field 30).
  6. The WO_ROUTING.wo_oper_step_no matches the timesheet line Operation Step No (field 31).

34

Sales Order ID

Char 10

295-304

Required if Timesheet Line Type Code is S.

(Not currently populated by Deltek Time & Expense)

35

SO Release No

Num 2

305-306

Required if Timesheet Line Type Code is S.

(Not currently populated by Deltek Time & Expense)

36

SO Line No

Num 2

307-308

Optional.

(Not currently populated by Deltek Time & Expense)

37

Organization Abbreviation

Char 6

309-314

Optional

38

Project Abbreviation

Char 6

315-320

Optional

39

Sequence Number

Num 1

321-321

Required

If the timesheet type is Correcting, the application automatically increments the sequence number if a timesheet already exists for the employee/TS date/TS type/seq no (whether or not a sequence number is provided in the input file).

If this field is blank, the timesheet type is Regular, and no timesheet already exists for the Empl/TS Date/TS Type, 1 defaults. If this field is blank and a sequence 1 timesheet already exists for the Empl/TS Date/TS Type, an error message prints.

1-9

40

Effective Billing Date

Char 10

322-331

Optional.

(Default provided if a PLC exists on the timesheet line.)

YYYY-MM-DD

41

Project-Account Abbreviation

Char 6

332-337

Optional

42

Withholding State

Char 2

338-339

Optional/Required. This value is required if you are using Deltek Time & Expense 8.1.2 and above and the Enable Multi-State Tax Withholding check box is selected on the Manage Pay Periods screen.

43

Timesheet Complete Flag (For future use)

Char 1

340-340

Optional - reserved for future use

Y, N or null

44

Timesheet in Process Flag (For future use)

Char 1

341-341

Optional - reserved for future use

Y, N or null

45

Future Use

Char 46

342-387

Optional

46

Notes

Char 254

388-641

Optional

Parent Topic:

Import Timesheets from Deltek Time and Expense