Payroll Clock In/Out Export File (POS And Store Manager)

This file is created in the upload Xpress Server’s upload sub directory when a user presses the EXPORT button in the Payroll function.

Note Note

FILENAME=SSSSSSQQQQ.CLK

Where: SSSSSS is the store number

QQQQ is the sequential number generated for each export.

End of the note.

Header Record

Field	Columns	Size	Values
1. Line Type	1-1	1	H
2. Sequence No.	2-5	4	####
3. Export Start Date/Time	6-20	15	YYYY-MM-DDHH:MM
4. Export End Date/Time	21-35	15	YYYY-MM-DDHH:MM

Total bytes: 35

Detail Record

Field	Columns	Size	Values
1. Line Type	1-1	1	D
2. Employee No.	2-16	15	###############
3. Confirmed	17-17	1	N - No Y - Yes
4. Export Start Date/Time	18-32	15	YYYY-MM-DDHH:MM
5. Export Start Date/Time	33-47	15	YYYY-MM-DDHH:MM
6. Total Hrs Worked	48-58	8.2	00000030.00
7. Completed	59-59	1	N - No Y - Yes E- Error
8. Reason Code	60-62	3	001
9. Bulk Entry	63-67	2.2	00.00
10. Secondary Store	68-72	5	00000
11. Division	73-77	5	00000
12. Audit Cashier Number	78-83	6	000000
13. Cashier Number	84-89	6	000000
14. Social Security ID	90-98	9	000000000
15 Employee Last Name	99-118	20
16 Future	119	1
17 Employee First Name	120-139	20
18 Extended Audit Cashier number	140-141	2	High order digits for Cashier ID Extension with leading zeros.
19 Extended Cashier number	142-143	2	High order digits for Cashier ID Extension with leading zeros.
20 Extended Secondary Store	144-146	3	High order digits for Secondary Store ID Extension with leading zeros.

Total bytes: 146

Total Record

Field	Columns	Size	Values
1. Line Type	1-1	1	T
2. Total Hrs for Employee	2-16	8.2	00000030.00
3. Completed	17-17	1	Y - Yes N - No E - Error
4. Audit Cashier Number	18-23	6	000000
5. Cashier Number	24-29	6	000000
6. Social Security ID	30-38	9	000000000
7 Extended Audit Cashier Number	39-40	2	High order digits for Cashier ID Extension with leading zeros.
8 Extended Cashier Number	41-42	2	High order digits for Cashier ID Extension with leading zeros.

Total bytes: 42