anz transactive file format guide · 2011. 7. 28. · 3 payment file specifications table 01. this...

ANZ TRANSACTIVEFILE FORMAT GUIDE

PiPe DelimiteD

2

PAYmeNt File SPeCiFiCAtiONS 3

Table 01 Format of detail record for Payments 3

File Naming Convention 3

File Layout 3

Volumes 3

DiReCt DeBit File SPeCiFiCAtiONS 7

Table 02 Format of detail record for Direct Debits 7


File Layout 7

Volumes 7

ACCOUNt StAtemeNt File SPeCiFiCAtiONS 10

Table 03 Specification for Account Statement 10


File Layout 10

Volumes 10

contents

3

PAYmeNt File SPeCiFiCAtiONS

tABle 01. thiS tABle DeSCRiBeS the FORmAt OF the DetAil ReCORD FOR PAYmeNtS.The ANZ electronic payments facility can process files of electronic credit value transactions transmitted through ANZ Transactive.1

File NAmiNG CONVeNtiONNot applicable

File lAYOUtA payment file consists of:

> Detail record – pipe delimited

VOlUmeS

It is recommended that the number of transactions in any one batch should not exceed 5,000 records (i.e. 5,000 transactions) or 2.5MB.

ORDeR FielD NAmemANDAtORY/OPtiONAl DeSCRiPtiON

mAX. leNGth

AlPhA/NUmeRiC/ ChARACteR UNiCODe

1 Payment Method M

this describes the payment method. List of methods available are:

> AcH/GIRo> BKt> RtGs> ccHK> BcHK> cBFt

4 Alpha/numeric no

2 Debit Account number M Account number payment is debited from 30 Alpha/numeric no

3 Beneficiary name M Beneficiary’s name 35 Alpha/numeric Yes

4 Beneficiary Account number M

Beneficiary’s account number this is only mandatory when payment type is equal to AcH/GIRo, RtGs, BKt, cBFtthis is not required when Payment Method = ccHK or BcHK

34 Alpha/numeric no

5 Beneficiary Bank/ Branch code M

Beneficiary bank details and associate branch codeonly Mandatory when Payment type is equal to AcH/GIRo, RtGs, BKt, cBFtthis is not required when Payment Method = ccHK or BcHK

35 Alpha/numeric no

6 Payment currency M currency of payment i.e. currency 3 character no

7 Payment Amount M Amount of payment 15,3 numeric no

8 customer Reference o Account number payment is debited from 20 Alpha/numeric

9 country ocountry code where payment is initiated from. this is required if payment method is cBFt, otherwise this is optional

2 character no

10 execution Date o Format: DD/MM/YYYY 10 Date no

11 Beneficiary Address 1 o Beneficiary’s address 35 Alpha/numeric Yes

12 Beneficiary Address 2 o Beneficiary’s address (continued) 35 Alpha/numeric Yes

13 Beneficiary Address 3 o Beneficiary’s address (continued) 35 Alpha/numeric Yes

14 Beneficiary Address 4* o Beneficiary’s address (continued) 35 Alpha/numeric Yes

15 Beneficiary Fax no o Beneficiary’s fax number 15 Alpha/numeric no

* Note: Not required for CBFT payments1 The clearing system operates on the basis of account details provided only. ANZ will process your instructions based on the account details provided by you. ANZ does not check that the account details provided match those of the intended beneficiary. You should implement your own internal procedures to ensure that payments are directed to correct account details and bank details for the intended beneficiary.

4


mAX. leNGth


16 Beneficiary email ID oBeneficiary’s email address.Multiple addresses can be separated by a comma

255 Alpha/numeric no

17 charges o

AcH/GIRo> o– ours> B – Beneficiary> s – other

these values are captured in AnZ transactive as radio buttons the values in the payment file will need to be mapped to the corresponding radio button in AnZ transactive

1 Alpha no

18 Beneficiary Bank/Branch name o Bank branch of beneficiary 35 Alpha/numeric Yes

19 Beneficiary Bank name o name of beneficiary’s bank 35 Alpha/numeric Yes

20 Beneficiary Bank/Branch Address 1 o Beneficiary’s bank branch name 35 Alpha/numeric Yes

21 Beneficiary Bank/Branch Address 2 oBeneficiary’s bank branch address (continued) 35 Alpha/numeric Yes

22 Beneficiary Bank Branch city o city of the Beneficiary’s Bank Branch 31 Alpha/numeric Yes

23 Beneficiary Bank Branch Province o Province of the Beneficiary’s Bank Branch 8 Alpha/numeric Yes

24 Beneficiary Bank Branch country o country of the Beneficiary’s Bank Branch 2 Alpha/numeric no

25 Payable Location o Location of where the cheque will be credited 20 Alpha/numeric Yes

26 Print Location o Location of where a cheque can be printed 20 Alpha/numeric Yes

27 Delivery Method & Deliver to o

Values: > cB – (courier to Beneficiary)> Mc – ( Mail to customer)> MB – (Mail to Beneficiary)> Pc – (Pick up by customer)> PB – (Pick up by Beneficiary)

2 Alpha no

28 Mailing Address 1 o Mailing address used for sending out cheques 35 Alpha/numeric Yes

29 Mailing Address 2 o Mailing address used for sending out cheques (continued) 35 Alpha/numeric Yes



32 Details of Payment o Details of what the service or product that the payment is for 140 Alpha/numeric Yes

33 Instruction number o number assigned to a Beneficiary’s transaction 10 numeric no

5


mAX. leNGth


34 First Intermediary Bank/Branch code oFirst intermediary bank code that identifies the branch 35 Alpha/numeric no

35 First Intermediary Bank name othis will be mapped to the First Intermediary Bank name and address text box on the Payment screen

35 Alpha/numeric no

36 First Intermediary Bank/Branch name othis will be mapped to the First Intermediary Bank name and address text box on the Payment screen

35 Alpha/numeric no

37 First Intermediary Bank/Branch Address 1 othis will be mapped to the First Intermediary Bank name and address text box on the Payment screen

35 Alpha/numeric no

38 First Intermediary Bank/Branch Address 2 othis will be mapped to the First Intermediary Bank name and address text box on the Payment screen

35 Alpha/numeric no

39 First Intermediary Bank/Branch city o

this will be mapped to the First Intermediary Bank name and Address text box on the Payment screennote: combination of city and Province cannot exceed 31

31 Alpha/numeric no

40 First Intermediary Bank/Branch Province o

this will be mapped to the First Intermediary Bank name and Address text box on the Payment screennote: combination of city and Province cannot exceed 31

8 Alpha/numeric no

41 First Intermediary Bank/Branch country othis will be mapped to the First Intermediary Bank name and address text box on the payment screen

2 Alpha/numeric no

42 central Bank Reporting 1 o

central Bank Reporting Detail which is captured when Payment Method is equal to cBFt* this field is required if Payment Method is cBFt

35 Alpha/numeric no

43 central Bank Reporting 2 ocentral Bank Reporting Detail which is captured when Payment Method is equal to cBFt

35 Alpha/numeric no

44 central Bank Reporting 3 ocentral Bank Reporting Detail which is captured when Payment Method is equal to cBFt

35 Alpha/numeric no

45 confidential Indicator M

Valid values are Y and n. this indicates if the contents of the file are confidential or not. If Y, then only a user with access to confidential files based on his/her user profile can process/access the transaction/file upload. If n, then any user who has access to payments can process/access the transactions/file upload.

1 Alpha/numeric no

6

File VAliDAtiONAn automatic file validation process will start once a payment file has been uploaded. In the event a payment file doesn’t meet the required specifications an error message will appear indicative of the failure reason. Refer below for the list of payment file criteria that are validated and the associated error messages:

VAliDAtiON eRROR meSSAGe

Payment File size Payment file can not exceed 2.5 MB

Verify File Format File must be in pipe delimited format. Please correct your file format and upload again.

Verification of Payment Method

Payment method is not supported for the payment transaction

Payment method must be the same for each beneficiary

this payment method of is not valid for this currency and country. Please contact the bank for assistance.

Verification of the Debit Account

Invalid debit account

Debit account is inactive

Account is not available for Payment transactions

Account is not valid for debit for this user

Payment currency must be the same for each beneficiary

execution Date execution date line (x) is in the incorrect format. Please update to DD/MM/YYYY format

Validate city & Province combination combination of city & Province cannot be more than 31 characters

Beneficiary Level edits

Field: is a required value and has not been provided

Beneficiary Bank/Branch code is not valid for this Payment method and country of debit account

contains the following invalid sWIFt characters: ‘’

contains the following invalid characters: (semicolon)

7


mAX. leNGth

AlPhA/NUmeRiCChARACteR

1 Payment Method M Valid values:> DDI 5 Alpha/numeric

2 credit Account number M Proponix customer's credit account number to be credited 30 Alpha/numeric

3 Payer name M name of Payer 140 Alpha/numeric

4 Payer Account no M Account number of Payer 34 Alpha/numeric

5 Payer Bank/Branch code M code that identifies the Payer’s Bank Branch 35 Alpha/numeric

6 credit currency M currency of the Payment 3 char

7 Payment credit Amount M Amount of the Payment 153 numeric

8 Bo Reference o Billing organisation reference 20 Alpha/numeric

9 Payer country o country 2 char

10 execution Date o

Use the first execution date found within the file and set that as the execution date of the direct debit transaction. Format: DD/MM/YYYY

10 Date

11 Payer Address 1 o Address line 1 of Payer 35 Alpha/numeric




15 Payer Fax no o Fax number of Payer 15 Alpha/numeric

16 Payer email ID o email ID of Payer 255 Alpha/numeric

17 Payer Bank name o Bank name of Payer 35 Alpha/numeric

18 Payer Bank/Branch name o Bank Branch address of Payer 35 Alpha/numeric

19 Payer Bank/Branch Address 1 o Bank Branch address of Payer (continued) 35 Alpha/numeric

20 Payer Bank/Branch Address 2 o Bank Branch address of Payer (continued) 35 Alpha/numeric

21 Payer Bank/Branch city o Bank Branch city of Payer 31 Alpha/numeric

22 Payer Bank/Branch Province o Bank Branch city of Payer 8 Alpha/numeric

23 Payer Bank/Branch country o Bank Branch city of Payer 2 Alpha

DiReCt DeBit File SPeCiFiCAtiONS

tABle 02. thiS tABle DeSCRiBeS the FORmAt OF the DetAil ReCORD FOR DiReCt DeBitS.

File NAmiNG CONVeNtiONNot applicable

File lAYOUtA payment file consists of:

> Detail record – pipe delimited

VOlUmeS

It is recommended that the number of transactions in any one batch should not exceed 5,000 records (i.e. 5,000 transactions) or 2.5MB.

8


mAX. leNGth


24 charges o

Valid Values:> o – ours> P – Payer> s – shared

1 Alpha

25 credit Details o Details of credit 140 Alpha/numeric

26 ordering Party o contact that generates the Direct Debit 35 Alpha/numeric

27 ordering Party Address 1 o Address of contact that generates the Direct Debit 35 Alpha/numeric

28 ordering Party Address 2 o Address of contact that generates the Direct Debit (continued) 35 Alpha/numeric



31 ordering Party country o country of ordering party 2 Alpha/numeric

32 ordering Party Bank/Branch code ocode that identifies Bank Branch of contact that generates Direct Debit 35 Alpha/numeric

33 ordering Party Bank name o contact that generates Direct Debit Bank name 35 Alpha/numeric

34 ordering Party Bank Address 1 o contact the generates Direct Debit Bank Address 35 Alpha/numeric

35 ordering Party Bank Address 2 o contact the generates Direct Debit Bank Address (continued) 35 Alpha/numeric

9

File VAliDAtiONAn automatic file validation process will start once a payment file has been uploaded. In the event a payment file doesn’t meet the required specifications an error message will appear indicative of the failure reason. Refer below for the list of payment file criteria that are validated and the associated error messages:

VAliDAtiON eRROR meSSAGe

Payment File size Payment file can not exceed 2.5 MB

Verify File Format File must be in pipe delimited format. Please correct your file format and upload again.

Verification of Payment Method

Payment method is not supported for the payment transaction

Payment method must be the same for each beneficiary

this payment method of is not valid for this currency and country. Please contact the bank for assistance.

Verification of the Debit Account

Invalid debit account

Debit account is inactive

Account is not available for Payment transactions

Account is not valid for debit for this user

Payment currency must be the same for each beneficiary

execution Date execution date line (x) is in the incorrect format. Please update to DD/MM/YYYY format

Validate city & Province combination combination of city & Province cannot be more than 31 characters

Beneficiary Level edits

Field: is a required value and has not been provided

Beneficiary Bank/Branch code is not valid for this Payment method and country of debit account

contains the following invalid sWIFt characters: ‘’

contains the following invalid characters: (semicolon)

10

ACCOUNt StAtemeNt File SPeCiFiCAtiONS

tABle 03. thiS tABle DeSCRiBeS the SPeCiFiCAtiONS FOR the ACCOUNt StAtemeNt File, eXtRACteD FROm ANZ tRANSACtiVe iNtO eXCel.The extracted file provides transaction and balance details for registered ANZ Accounts. All clients registered for either Reporting or any Cash product have access to download the Account Statement file.

File NAmiNG CONVeNtiONNot Applicable

File lAYOUtAccount statement file consists of:

> Comma separate variable (CSV file)

> Where a text field contacts a comma in the data, the field must be wrapped in double quotes (“ “) prior to importing the file into your accounting package. e.g. Transaction Narrative - “Payment for Invoice 1, 3, 5”

VOlUmeSNot Applicable

FielD NAmemANDAtORY/OPtiONAl DeSCRiPtiON

mAX.leNGth


Account number M Account number at originated financial institution 30 Alpha/numeric

Account type M

Account type: M - Foreign (commonly used for singapore, Hong Kong, & china domiciled accounts) D - Deposit (recommended for Vietnam) s - savings or current

3 Alpha

currency of Account MIso currency code for related account. e.g. sGD, UsD, HKD

3 Alpha

Balance Date Meffective date of balance details reflected in detailed record Format: DD/MM/YYYY HH:MM:ss

19 Alpha

closing Balance M

signed, closing balance of the related account for the balance date reflected in the detailed record (as above). number of decimal places will be determined based on the currency code.

nB: there will be an explicit decimal point in the balance format when applicable.

example 1 (AUD):AUD $100 credit (cR) is represented as:+100.00

example 2 (JPY):JPY $200 debt (DR) is represented as:-200

18,3 numeric

11


mAX. leNGth


total Debit Movement M

Unsigned, total value of debit transactions for the related account on the date (balance date) reflected above. number of decimal places will be determined based on the currency code.


example 1 (sGD): sGD $100 credit (cR) is represented as:100.00

example 2 (JPY): JPY $200 debt (DR) is represented as:200

18,3 numeric

number of Debits MAccumulated number of debit items for related account on the date (balance date) reflected above.

5 numeric

total credit Movement M

Unsigned, total value of credit transactions for the related account on the date (balance date) reflected above. number of decimal places will be determined based on the currency code.


example 1 (sGD): sGD $100 credit (cR) is represented as:100.00

example 2 (JPY): JPY $200 debt (DR) is represented as:200

18,3 numeric

number of credits MAccumulated number of credit items for related account on the date (balance date) reflected above.

5 numeric

Debit Interest Rate o Debit Interest Rate 7,3 numeric

credit Interest Rate o credit Interest Rate 7,3 numeric

Account name M Registered account name within AnZ transactive 35 Alpha

customer name M organisational name registered within AnZ transactive. 30 Alpha

transaction type M

type of transaction: - Debit - credit - ntRF* (i.e. transfer between accounts) - ncHK* (i.e. cheques) - none (i.e. no transactions)

*only applicable in Vietnam and cambodia

10 Alpha

12

This document is issued by Australia and New Zealand Banking Group (PNG) Limited (ANZ) which is a subsidiary of Australia and New Zealand Banking Group Limited, which is incorporated in Australia. ANZ is a trade mark of ANZ. All other trade marks and products are either trade marks or registered trade marks of their owners. This document is provided to you on a commercial-in-confidential basis and must not be disclosed to any person outside of your organisation without express written permission of ANZ. The information contained in this guide is intended as general information only. The guide is subject to change without notice.


mAX. leNGth


transaction Date MDate transaction was posted to the related accountFormat: DD/MM/YYYY HH:MM:ss

19 Alpha

transaction Amount M

signed, transaction value. Value amount of transaction (debit/credit) on related account on the date (balance date) reflected above, number of decimal places will be determined based on the currency code.


example 1: sGD $100 credit (cR) represented as:+100.00

example 2: JPY $200 credit (cR) represented as:+200

18,3 numeric

transaction narrative M Particulars of transaction, variable format and is specified by the initiator of the transaction 160 Alpha

opening Balance M

signed, opening Balance of related account on the date (balance date) reflected above. number of decimal places will be determined based on the currency code.

example 1: sGD $100 credit (cR) represented as:+100.00

example 2: JPY $200 credit (cR) represented as:+200

18,3 numeric

sequence number M sequential system generated number within AnZ transactive 8 numeric

effective Date Meffective date of transaction on related account referenced above, Format: DD/MM/YYYY HH:MM:ss

19 Alpha

anz.com/papuanewguinea

This document is issued by A

ustralia and New

Zealand Banking Group (PN

G) Lim

ited (AN

Z) which is a subsidiary of A

ustralia and N

ew Zealand Banking G

roup Limited, w

hich is incorporated in Australia. Item

No. FFG

0006 07.2011 (77648) W239549

anz transactive file format guide · 2011. 7. 28. · 3 payment file specifications table 01. this...

Documents