CBPL - Citibank Paylink

There are two options for generating the Citibank Paylink EFT File format in a New Zealand database:

To generate the Citibank Paylink Bank File format via the new method, the Bank File Format on the required Company Bank Details record/s must be set to CITIBKPLNZ.

 

To configure the use of the Citibank Paylink EFT File via the Old Method:

  • The Bank File Format on the required Company Bank Details record/s must be set to PAY64

  • Positions 14-19 of Program Control PAY64 must be set to CBPLNZ

 

The file format is a plain text file that uses (carriage return and) line feed characters to distinguish between lines.

It contains one record for each Bank Deposit with each record represented by one line in the file.

The fields in each record are separated by '@'. They can be any length up to the stated maximum format length for each field.

 

  Detailed Transaction Record      
Field Number Field Name Type Length Description
1 Product Code/ Payment Method Alphanumeric 3 Fixed value of NPR
2 Debit Account Country Code Alphanumeric 2 Fixed value of NZ
3 Debit Account Number Numeric 10 Account Number from the Company Bank Details screen
4 Payment Currency Alphanumeric 3 Fixed value of NZD
5 Payment Amount Numeric 15 Payment Amount for the Employee
6 Branch Code Alphanumeric 4 Leave Blank
7 Value Date Numeric 10

Direct Credit Date from EFT Processing screen

Format = CCYYMMDD
8 Transaction Reference Number     Leave Blank
9 Pre-format Group Code     Leave Blank
10 Pre-format Code     Leave Blank
11 Confidential Indicator     Leave Blank
12 Ordering Party [ID/Advice] Type     Leave Blank
13 Ordering Party ID     Leave Blank
14 Ordering Party Name Alphanumeric 35

1st to 35th characters of Account Name from the Company Bank Details screen when generated via R006 method

1st to 16th characters of Account Name from the Company Bank Details screen when generated via PAY64 method

Note: This field currently only allows up to 25 characters at screen level.
15 Ordering Party Address 1     Leave Blank
16 Ordering Party Address 2     Leave Blank
17 Ordering Party Address 3     Leave Blank
18 Ordering Party Routing Method     Leave Blank
19 Ordering Party Routing Code     Leave Blank
20 Beneficiary Name Alphanumeric 70

Account Name from the Bank Details screen
21 Beneficiary Address 1     Leave Blank
22 Beneficiary Address 2     Leave Blank
23 Beneficiary Address 3     Leave Blank
24 Beneficiary Account or Other ID Type     Leave Blank
25 Beneficiary Account Number [or Other ID] Numeric 10

Concatenation of:

  • 1st to 7th characters of Account Number from the Bank Details screen
  • Fixed value - '0'
  • Suffix from the Bank Details screen
26 Beneficiary Reference     Leave Blank
27 Beneficiary Bank Name     Leave Blank
28 Beneficiary Bank Address 1     Leave Blank
29 Beneficiary Bank Address 2     Leave Blank
30 Beneficiary Bank Address 3     Leave Blank
31 Beneficiary Bank Routing Method     Leave Blank
32 Beneficiary Bank Routing Method Numeric 6 BSB Number from the Bank Details screen
33 Beneficiary Bank Account or Other ID Type     Leave Blank
34 Beneficiary Bank Account     Leave Blank
35 Beneficiary Bank Advice Type     Leave Blank
36 Payment Details, Line 1 Alphanumeric 35

Concatenation of:
37 Payment Details, Line 2     Leave Blank
38 Payment Details, Line 3     Leave Blank
39 Payment Details, Line 4     Leave Blank
40 Beneficiary Is [A Bank]     Leave Blank
41 Bank to Bank Information, Line 1     Leave Blank
42 Bank to Bank Information, Line 2     Leave Blank
43 Bank to Bank Information, Line 3     Leave Blank
44 Bank to Bank Information, Line 4     Leave Blank
45 Bank to Bank Information, Line 5     Leave Blank
46 Bank to Bank Information, Line 6     Leave Blank
47 Intermediary Bank Routing Method     Leave Blank
48 Intermediary Bank Routing Method     Leave Blank
49 Intermediary Bank Name     Leave Blank
50 Intermediary Bank Address 1     Leave Blank
51 Intermediary Bank Address 2     Leave Blank
52 Intermediary Bank Address 3     Leave Blank
53 Intermediary Bank Country Code     Leave Blank
54 Intermediary Bank Country Name     Leave Blank
55 FX Contract     Leave Blank
56 Exchange Rate     Leave Blank
57 Intra-Company [Indicator]     Leave Blank
58 Charges Indicator     Leave Blank
59 Charges Account     Leave Blank
60 Priority Flag     Leave Blank
61 Pre-Advice Flag     Leave Blank
62 Number of Credit Parties     Leave Blank
63 Entry Description     Leave Blank
64 Second Intermediary Bank Account or Other ID Type     Leave Blank
65 Second Intermediary Bank Account or Other ID     Leave Blank
66 Second Intermediary Bank Advice Type     Leave Blank
67 Second Intermediary Bank Name     Leave Blank
68 Second Intermediary Bank Address 1     Leave Blank
69 Second Intermediary Bank Address 2     Leave Blank
70 Second Intermediary Bank Address 3     Leave Blank
71 Advice to Name     Leave Blank
72 Advice Media/Bene Advice Type     Leave Blank
73 Fax Number     Leave Blank
74 Alternate Fax Number     Leave Blank
75 Contact Phone Number     Leave Blank
76 Internet Address - Account Name/Domain Name     Leave Blank
77 Payment Type     Leave Blank
78 Transaction Type     Leave Blank
79 Mail To Name     Leave Blank
80 Mail To Address 1     Leave Blank
81 Mail To Address 2     Leave Blank
82 Mail To Address 3     Leave Blank
83 Mail To Address 4     Leave Blank
84 Mail To Country Code     Leave Blank
85 Mail To Country Name     Leave Blank
86 Beneficiary Country Code     Leave Blank
87 Beneficiary Country Name     Leave Blank
88 Clearing Country Code     Leave Blank
89 Clearing Country Name     Leave Blank
90 Delivery Method     Leave Blank
91 Payable At Location     Leave Blank
92 PDC Discounting     Leave Blank
93 Custom Field 1     Leave Blank
94 Custom Field 2     Leave Blank
95 Custom Field 3     Leave Blank
96 Custom Field 4     Leave Blank
97 Custom Field 5     Leave Blank
98 Custom Field 6     Leave Blank
99 Custom Field 7     Leave Blank
100 Custom Field 8     Leave Blank
101 Custom Field 9     Leave Blank
102 Custom Field 10     Leave Blank
103 Custom Field 11     Leave Blank
104 Custom Field 12     Leave Blank
105 Custom Field 13     Leave Blank
106 Custom Field 14     Leave Blank
107 Custom Field 15     Leave Blank
108 Custom Field 16     Leave Blank
109 Custom Field 17     Leave Blank
110 Custom Field 18     Leave Blank
111 Custom Field 19     Leave Blank
112 Subsidiary Identifier     Leave Blank