T-Chek Upload File Format

The upload file to T-Check includes a header record for each company referenced along with detail records for each transaction belonging to that particular company. 

 

The following sections detail the specific contents requested by T-Chek to process advance transactions.

 

Upload File Header Record Layout

 

There will be a single header record for each distinct Company Number referenced within the file built when a Generate is performed in Advance Processing.

 

Position

Length

Field

Description

1-4

4

Title

“DBTD” (hardcoded)

5-9

5

Company Number

Company Number assigned to the branch of dispatcher in Branch Setup.  The specific branch record referenced is the Default Branch in the dispatcher Personnel Setup.

10-15

6

Creation Date

Date the file was created as “YYMMDD”

16-19

4

Creation Time

Time that the file was created as “HHMM”

20-27

8

Total Advance Amount

Amount of the settlement being uploaded (in pennies)

28-33

6

Upload Date

Date that the file is to be uploaded as “YYMMDD”

34-34

1

Carriage Return

Special character

35-35

1

Line Feed

Special character

 

 

Upload File Detail Record Layout

 

Each record selected to be included in the upload file generation within Advance Processing will have a detail record within the upload file.  All the detail records will list underneath the header record that corresponds to the Company Number listed within each record.

 

Position

Length

Field

Description

1-5

5

Company Number

Company Number assigned to the branch of dispatcher in Branch Setup.  The specific branch record referenced is the Default Branch in the dispatcher Personnel Setup.

6-15

10

Account Number

Account Number assigned to the driver through Personnel Setup.

16-21

6

Filler

Blanks

22-41

20

Driver Name

Employee Name from Personnel Setup

42-53

12

Driver ID

Account ID set within the Personnel Setup of the driver

54-54

1

Account Type

The type of advance drawn is based on the numeric value entered as one of the following:

“1” for savings,

“2” for checking

“4” for fuel card

The application set the Account Type to “4.”

55-71

17

Filler

Blanks

72-100

29

Document Number

Transaction (posting) number

101-107

7

Amount Advanced to the driver

Amount of the advance to load onto a T-Card in pennies

108-128

21

Filler

Blanks

129-129

1

Carriage Return

Special character

130-130

1

Line Feed

Special character

 

TECHNICAL NOTE: The application stores the contents of the upload file in the AdvanceBatch table.

 

See https://www.efsllc.com/t-chek/ for T-Chek official website.