T-Chek Upload File Detail Record Layout

 

Each record selected to be included in the upload file generation within Advanced Processing will have a detail record within the upload file.  All the detail records will be listed 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 for the dispatcher

6-15

10

Account Number

Account Number assigned to the driver

16-21

6

Filler

Blanks

22-41

20

Driver Name

Vendor or driver name from Personnel record

42-53

12

Driver ID

Account ID from the driver’s Personnel record

54-54

1

Account Type

Either: “1” for savings, “2” for Checking, or “4” for Fuel Card

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