This page (revision-15) was last changed on 26-Nov-2021 10:22 by rforbes

This page was created on 26-Nov-2021 10:22 by rmorrell

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
15 26-Nov-2021 10:22 9 KB rforbes to previous
14 26-Nov-2021 10:22 9 KB rmorrell to previous | to last
13 26-Nov-2021 10:22 9 KB rmorrell to previous | to last
12 26-Nov-2021 10:22 8 KB rmorrell to previous | to last
11 26-Nov-2021 10:22 8 KB rmorrell to previous | to last
10 26-Nov-2021 10:22 7 KB rmorrell to previous | to last
9 26-Nov-2021 10:22 5 KB rmorrell to previous | to last
8 26-Nov-2021 10:22 5 KB rmorrell to previous | to last
7 26-Nov-2021 10:22 3 KB rmorrell to previous | to last
6 26-Nov-2021 10:22 2 KB rmorrell to previous | to last
5 26-Nov-2021 10:22 2 KB rmorrell to previous | to last
4 26-Nov-2021 10:22 1 KB rmorrell to previous | to last
3 26-Nov-2021 10:22 690 bytes rmorrell to previous | to last
2 26-Nov-2021 10:22 498 bytes rmorrell to previous | to last
1 26-Nov-2021 10:22 108 bytes rmorrell to last

Page References

Incoming links Outgoing links
HL$UPDIF_CDN
HL$UPDIF_CDN

Version management

Difference between version and

At line 3 added 180 lines
File Structure as created
This interface definition is intended to be modified by the end users as required by their receiving system.
!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| |
|30|8|Pay Issue Date|146|156|Date|0007 Pay Issue Date| |
|30|9|Number of Checks|157|160|Number|0052 Number of Checks| |
|30|10|Number of Deposits|161|164|Number|0053 Number of deposits| |
|30|11|Check Number|165|174|Number|0160 Check Number| |
|30|12|FED TD1 Amount|175|194|Number|0168 Fed TD1 Amount| |
|30|13|Federal Addn Tax PP|195|214|Number|0169 Fed Add Tax PP| |
|30|14|Federal Filing Status|215|244|Char|0171 Fed Filing Status LEX| |
|30|15|Federal Tax Method|245|274|Char|0173 Fed Tax Method LEX| |
|30|16|Provincial Num Dependents|275|280|Number|0174 Prov # Dependents| |
|30|17|Provincial Add Tax PP|281|291|Number|0175 Prov Add Tax PP| |
|30|18|Provincial Tax Method|292|321|Char|0177 Prov Tax Method LEX| |
|30|19|Provincial Filing Status|322|351|Char|0179 Prov Filing Status LEX| |
|30|20|Provincial Claim Amount|351|380|Number|0180 Prov Claim Amount| |
|41|1|3|1|3|Char| | |41
|41|2|Entity Code|4|19|Char|0050 Entity Code| |
|41|3|Pay Destination|20|49|Char|0001 Pay Destination| |
|41|4|Department|50|65|Char|0002 Department| |
|41|5|Full Name|66|125|Char|0003 Full Name| |
|41|6|Person Code|126|141|Char|0006 Person Code| |
|41|7|Pay Number|142|145|Char|0051 Pay Number| |
|41|8|Pay Issue Date|146|156|Date|0007 Pay Issue Date| |
|41|9|Number of Checks|157|160|Char|0052 Number of Checks| |
|41|10|Number of Deposits|161|164|Char|0053 Number of Deposits| |
|41|11|Check Number|165|174|Char|-1060 Check Number| |
|41|12|PC Code|175|178|Char|0087 PC Code| |
|41|13|Rate|179|198|Char|0092 Rate| |
|41|14|Rate Basis Code|199|200|Char|0093 Rate Basis| |
|41|15|Rate Basis LEX|201|220|Char|0094 Rate Basis LEX| |
|41|16|Time|221|240|Char|0095 Associated Time| |
|45|1|Record Type Code|1|3|Char| | |45
|45|2|Entity Code|4|19|Char|0050 Entity Code| |
|45|3|Pay Destination|20|49|Char|0001 Pay Destination| |
|45|4|Department|50|65|Char|0002 Department| |
|45|5|Full Name|66|125|Char|0003 Full Name| |
|45|6|Person Code|126|141|Char|0006 Person Code| |
|45|7|Pay Number|142|145|Number|0051 Pay Number| |
|45|8|Pay Issue Date|146|156|Date|0007 Pay Issue date| |
|45|9|Number of Checks|157|160|number|0052 Number of Checks| |
|45|10|Number of Deposits|161|164|Number|0053 Number of Deposits| |
|45|11|Check Number|165|174|Number|0160 Check Number| |
|45|12|PC|175|178|Char|0087 PC Code| |
|45|13|Abbrev|179|200|Char|PC Abbreviation| |
|45|14|Amount|201|220|Char|0111 Amount| |
|45|15|Task|221|236|Char|0115 Pay Point Task LEX| |
|45|16|Reference|237|286|Char|0166 Reference| |
|50|1|Record Type Code|1|3|Char| | |50
|50|2|Entity Code|4|19|Char|0050 Entity Code| |
|50|3|Pay Destination|20|49|Char|0001 Pay Destination| |
|50|4|Department|50|65|Char|0002 Department| |
|50|5|Full Name|66|125|Char|0003 Full Name| |
|50|6|Person Code|126|141|Char|0006 Person Code| |
|50|7|Pay Number|142|145|Number|0051 Pay Number| |
|50|8|Pay Issue Date|146|156|Date|0007 Pay Issue Date| |
|50|9|Number of Checks|157|160|Number|0052 Number of Checks| |
|50|10|Number of Deposits|161|164|Number|0053 Number of Deposits| |
|50|11|Check Number|165|174|Number|0160 Check Number| |
|50|12|PC|175|180|Char|0087 PC Code| |
|50|13|Abbrev|181|200|Char|0088 PC Abbreviation| |
|50|14|Deduction Amount|201|221|Number|0090 Current Value| |
|50|15|YTD|222|241|Number|0091 YTD Value| |
|60|1|Record Type Code|1|3|Char| | |60
|60|2|Entity Code|4|19|Char|0050 Entity Code| |
|60|3|Pay Destination|20|49|Char|0001 Pay Destination| |
|60|4|Department|50|65|Char|0002 Department Code| |
|60|5|Full Name|66|125|Char|0003 Full Name| |
|60|6|Person Code|126|141|Char|0006 Person Code| |
|60|7|Pay Number|142|145|Number|0051 Pay Number| |
|60|8|Pay Issue Date|146|156|Date|0007 Pay Issue Date| |
|60|9|Number of Checks|157|160|Number|0052 Number of Checks| |
|60|10|Number of Deposits|161|164|Number|0053 Number of Deposits| |
|60|11|Check Number|165|174|Number|0160 Check Number| |
|70|1|Record Type Code|1|3|Char| | |70
|70|2|Entity Code|4|19|Char|0050 Entity Code| |
|70|3|Pay Destination|20|49|Char|0001 Pay Destination| |
|70|4|Department|50|65|Char|0002 Department Code| |
|70|5|Full Name|66|125|Char|0003 Full Name| |
|70|6|Person Code|126|141|Char|0006 Person Code| |
|70|7|Pay Number|142|145|Number|0051 Pay Number| |
|70|8|Pay Issue Date|146|156|Date|0007 Pay Issue Date|DD-Mon-YYYY|
|70|9|Number of Checks|157|160|Number|0052 Number of Checks| |
|70|10|Number of Deposits|161|164|Number|0053 Number of Deposits| |
|70|11|Check Number|165|174|Number|0160 Check Number| |
|80|1|Record Type Code|1|3|Char| | |80
|80|2|Entity Code|4|19|Char|0050 Entity Code| |
|80|3|Pay Destination|20|49|Char|0001 Pay Destination| |
|80|4|Department|50|65|Char|0002 Department Name| |
|80|5|Full Name|66|125|Char|0003 Full Name| |
|80|6|Person Code|126|141|Char|0006 Person Code| |
|80|7|Pay Number|142|145|Number|0051 Pay Number| |
|80|8|Pay Issue Date|146|156|Date|0007 Pay Issue Date| |
|80|9|Number of Checks|157|160|Number|0052 Number of Checks| |
|80|10|Number of Deposits|161|164|Number|0053 Number of Deposits| |
|80|11|Check Number|165|174|Number|0160 Check Number| |
|80|12|PC|175|180|Char|0087 PC Code| |
|80|13|Amout|181|200|Char|0132 Arrears Amount| |
|80|14|Reference|201|251|Char|0133 Arrears Reference| |
|90|1|Record Type Code|1|3|Char| | |90
|90|2|Entity Code|4|19|Char|0050 Entity Code| |
|90|3|Pay Destination|20|49|Char|0001 Pay Destination| |
|90|4|Department|50|65|Char|0002 Department Code| |
|90|5|Full Name|66|125|Char|0003 Full Name| |
|90|6|Person Code|126|141|Char|0006 Person Code| |
|90|7|Pay Number|142|145|Number|0051 Pay Number| |
|90|8|Pay Issue Date|146|156|Date|0007 Pay Issue Date| |
|90|9|Number of Checks|157|160|Number|0052 Number of Checks| |
|90|10|Number of Deposits|161|164|Number|0053 Number of Deposits| |
|90|11|Check Number|165|174|Number|0160 Check Number| |
|100|1|Record Type Code|1|3|Char| | |100
|100|2|Entity Code|4|19|Char|0050 Entity Code| |
|100|3|Pay Destination|20|49|Char|0001 Pay Destination| |
|100|4|Department|50|65|Char|0002 Department Code| |
|100|5|Full Name|66|125|Char|0003 Full Name| |
|100|6|Person Code|126|141|Char|0006 Person Code| |
|100|7|Pay Number|142|145|Number|0051 Pay Number| |
|100|8|Pay Issue Date|146|156|Date|0007 Pay Issue Date| |
|100|9|Number of Checks|157|160|Number|0052 Number of Checks| |
|100|10|Number of Deposits||161|164|Number|0053 Number of Deposits| |
|100|11|Check Number|165|174|Number|0160 Check Number| |
|110|1|Record Type Code|1|3|Char| | |110
|110|2|Entity Code|4|19|Char|0050 Entity Code| |
|110|3|Pay Destination|20|49|Char|0001 Pay Destination| |
|110|4|Department|50|65|Char|0002 Department Code| |
|110|5|Full Name|66|125|Char|0003 Full name| |
|110|6|Person Code|126|141|Char|0006 Person Code| |
|110|7|Pay Nubmber|142|145|Number|0051 Pay Number| |
|110|8|Pay Issue Date|146|156|Date|0007 Pay Issue date| |
|110|9|Number of Checks|157|160|Number|0052 Number of Checks| |
|110|10|Number of Deposits|161|164|Number|0053 Number of Deposits| |
|110|11|Check Number|165|174|Number|0160 Check Number| |
|110|12|Message|175|374|Char|0158 Message| |
|120|1|Person Code|1|10|Char|0006 Person Code| |
|120|2|Pay Number|11|14|Char|0051 Pay Number| |
At line 4 changed one line
Interface layout as follows:
\\
----
![Notes|Edit:Internal.HL$UPDIF_CDN]
[{InsertPage page='Internal.HL$UPDIF_CDN' default='Click to create a new notes page'}]
This page (revision-15) was last changed on 26-Nov-2021 10:22 by rforbesTop