Search for answers or browse our documentation.
iFILE
HSBC iFILE Screen
Figure 1
Country code – Identify the country (nationality) the file is being extracted for. May either be “IN” (for India) or “ZA” (for RSA).
Institution code – Identify the institution. May either be “HBAP” or “HBEU”.
Account currency – This the currency that must appear on the bank file must be entered here. It cannot exceed 3 characters and is mandatory. Selecting the browse button will show a list of BTS available currencies as per Figure 2.
Hexagon ABC ID – This is an 11 character field and is mandatory. This is used as the Customer ID.
HSBC net ID – This is an 18 character field and is mandatory. This is used as the HSBC ID.
Account number – This is a 35 character field and is mandatory. This is the customer account number.
File format – Will always be “IFILE”
File type – Will always be “CSV”
Authorization type – This is the authorization that needs to be supplied by the bank and can be: “P”, “F”, “V” or “S”
File version – Will always be 1.0
ADV required – Yes (if this check box is ticked)/No (if the check box is not ticked). This determines if the relevant records need to be extracted or not.
Figure 2
This BTS Bank format is available for the following SYSPRO Nationalities:
- RSA (Republic of South Africa)
Additional Information Trigger Screen
There are extra details required when using this BTS bank format. When maintaining the Supplier and/or Cash Book beneficiary in SYSPRO, the following screen as per Figure 3 will be seen:
Figure 3
Instruction type – This field must be selected from an available drop-down list (as per Figure 4) and is mandatory
Beneficiary country code – May not exceed 2 characters and is mandatory. A browse facility has been made available should you wish to search SYSPRO for available currency codes
Payment currency – May not exceed 2 characters and is mandatory. A browse facility has been made available should you wish to search SYSPRO for available currency codes. This field is not available for entry is the Instruction type is “ACC” or “ICO”.
Account number – May not exceed 11 character numerics and is mandatory only if the Instruction type is “ACH”
Branch number – This field must be selected from an available drop-down list (as per Figure 5) and is mandatory only if the Instruction type is “ACH”
Reference – May not exceed 34 characters and is mandatory only if the Instruction type is “ACH”
The following Email fields are only available for entry if the ADV required field has been selected in Figure 1
Email address 1 – May not exceed 70 characters and is mandatory
Email address 2 & 3 – May not exceed 70 characters and is optional
The following is only available for maintenance if the Instruction type is set to “PP”, “RTGS”, “IAT” or “NEFT” (as per Figure 6)
Account number – May not exceed 35 characters and is mandatory
Charge details – This field must be selected from an available drop-down list (as per Figure 7) and is mandatory (unless the Instruction type is set to “PP”, then this field is optional)
Bank ID/SWIFT code – This field must be selected from an available drop-down list (as per Figure 8) and is optional
Bank ID/SWIFT address – May not exceed 34 characters and is optional (unless the Instruction type is set to “NEFT” or “RTGS” then this field is mandatory)
Bene bank name – May not exceed 35 characters and is mandatory. Only available when only when the Instruction type is set to “PP”
Bene bank address 1 – 3 – May not exceed 35 characters. Only Bene bank address 1 is mandatory and the others are optional. Only available when only when the Instruction type is set to “PP”
Reference – May not exceed 35 characters and is optional. Only available when only when the Instruction type is set to “PP”
Bene CHIPS UID – May not exceed 6 characters and is optional. Only available when only when the Instruction type is set to “PP”
The following is only available for maintenance if the Instruction type is set to “ACC”, “ICO”, “IDD” (as per Figure 9)
Institution code – This field must be selected from an available drop-down list and if entered, may only be “HBAP”. This field is mandatory
Deduct charge flag – This field must be selected from an available drop-down list and if entered, may only be “B” or “C”. This field is mandatory
Printing location – This field must be selected from an available drop-down list and if entered, may only be “Bangalore”. This field is mandatory
Payable locations – May not exceed 100 characters and is optional, unless the Instruction type is set to “IDD” – in which case it is mandatory . A browse facility has been made available should you wish to search SYSPRO for available payable locations.
Deliver to – This field must be selected from an available drop-down list and if entered, may only be “S” or “B”. This field is mandatory
Figure 4
Figure 5
Figure 6
Figure 7
Figure 8
Figure 9
iFILE(HSBC)