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.