Wiki: HL$UPDIF

Disbursement Interface - Canada (HL)#

Interface Type: Disbursement File
File Structure as created

Structure#

Record#	Field#	Name	Beg	End	Type	Variable	Format Mask	Constant
10	1	Record Type Code	1	3	Char			10
10	2	Entity Code	4	19	Char	0050 Entity Code
10	3	Pay Destination	20	49	Char	0001 Pay Destination
10	4	Department	50	65	Char	0002 Department Code
10	5	Full Name	66	125	Char	0003 Full Name
10	6	Person Code	126	141	Char	0006 Person Code
10	7	Pay Number	142	145	Number	0051 Pay Number
10	8	Pay Issue Date	146	156	Date	0007 Pay Issue Date	DD-Mon-YYYY
10	9	Number of Checks	157	160	Number	0052 Number of Checks
10	10	Number of Deposits	161	164	Number	0053 Number of Deposits
10	11	Check Number	165	174	Number	0160 Check Number
10	12	Amount	175	200	Number	0068 Check/Deposit Amount	00000009.99
10	13	String	201	249	Char	0069 Amount String
10	14	PRENOTE	250	251	Char	0070 PreNote
20	1	Record Type Code	1	3	Char			20
20	2	Entity Code	4	19	Char	0050 Entity Code
20	3	Pay Destination	20	49	Char	0001 Pay Destination
20	4	Department	50	65	Char	0002 Department Code
20	5	Full Name	66	125	Char	0003 Full Name
20	6	Person Code	126	141	Char	0006 Person Code
20	7	Pay Number	142	145	Number	0051 Pay Number
20	8	Pay Issue Date	146	156	Date	0007 Pay Issue Date
20	9	Number of Checks	157	160	Number	0052 Number of Checks
20	10	Number of Deposits	161	164	Number	0053 Number of Deposits
20	11	Check Number	165	174	Number	0160 Check Number
20	12	Department Name	175	200	Char	0034 Department Name
20	13	Locality	201	249	Char	0014 City
20	14	State	250	299	Char	0021 State
20	15	Net Pay	300	325	Number	0064 CTD Net Pay
20	16	Pay Number	326	330	Number	0051 Pay Number
20	17	Taxes	331	350	Number	0193 CTD Taxes Withheld
20	18	Deductions (Except Taxes)	351	370	Number	0194 CTD Deductions Excl Taxes
20	19	Taxes YTD	371	390	Number	0195 YTD Taxes Withheld
30	1	Record Type Code	1	3	Char			30
30	2	Entity Code	4	19	Char	0050 Entity Code
30	3	Pay Destination	20	49	Char	0001 Pay Destination
30	4	Department	50	65	Char	0002 Department Code
30	5	Full Name	66	125	Char	0003 Full Name
30	6	Person Code	126	141	Char	0006 Person Code
30	7	Pay Number	142	145	Number	0051 Pay Number