Different styles are

 

TPS

ABN

BACS

RIBA

DEUTSCHE

JP Morgan

Bancafe Pagos  (Colombia)

Sebra (Colombia)

CrediPlus (Colombia)

ANZ (Australia)

ePF

SEPA (Europe)

OCBC (Singapore)

TPS - Treasury Payment System

The TPS export file is a comma-delimited file with the following format:

Field No	Field Name	Content
1	Batch Number/Report ID	e.g. 1234
2	Doc Ref	banktx_docref
3	Type	banktx_type
4	Amount	doc amount
5	Value	Value Date
6	Beneficiary	banktx_beneficiary
7	Address 1	banktx_clibankaddr1
8	Address 2	banktx_clibankaddr2
9	Address 3	banktx_clibankaddr3
10	Ben Country	boec_isocode
11	Ben Acc No	banktx_clibanknum
12	IBAN	banktx_iban
13	CLABE	banktx_clabe
14	Ben Bank	banktx_clibank
15	Ben Bank Add 1	banktx_benaddr1
16	Ben Bank Add 2	banktx_benaddr2
17	City	banktx_location
18	Zip Code	banktx_clibankzip
19	Bank Country	boec_isocode
20	Int Acc No	banktx_correspaccnum
21	Swift	banktx_swift
22	Sortcode	banktx_sortcode
23	FEDBA	banktx_fedaba
24	CHIPS	banktx_chips
25	Phone	banktx_clibankphonenum
26	Int Bank	banktx_correspname
27	Location	banktx_correspaddr
28	Int Country	boec_isocode
29	Corr Swift	banktx_correspswift
30	Corr Sortcode	banktx_correpsortcode
31	Corr FEDBA	banktx_correspfedaba
32	Corr CHIPS	banktx_correspchips
33	Sugar Account	banktx_sugaracc
34	Sugar sub A/c	banktx_sugsubacc
35	Doc Ccy	Document Currency
36	POPC	banktx_purpose
37	Ref	banktx_reference
38	Sens Pay	banktx_sensitive
39	Cli Ref	banktx_cliref
40	Entity Name	xxxx

ABN-AMRO-RABO/Netherlands

This supports two separate file formats depending on whether the payment is domestic (CLIE) or foreign (BTL91). The file formats are described below:

Foreign File Format (BTL91)

The file created is a text file with the naming format [comp][id]BTL91.TXT, where [comp] is the company mnemonic, and [id] is a unique incrementing identity, automatically maintained on a company table. It is 2 digits with a leading zero.

The file can only contain uppercase alphanumeric characters, as well as the following symbols: “./+-?:()',”. Any other symbol is replaced with a space. All rows are 192 bytes

Header Row

It consists of a mixture of hard-coded information, data from ITAS (company name, branch, batch number) and date information

Start	Length	Data
1	7	11ABNAX
8	2	ID number (see above)
10	8	Current system date in yyyymmdd format
18	3	Batch number. This is an automatically incrementing identity value, secured on a company table, 3 digits with a leading zero.
21	35	ITAS Company Name
56	35	First line of company address (hard-coded as “WEENA 612-614”)
91	35	Second line of company address (hard-coded as “ROTTERDAM”)
126	35	Third line of company address (hard-coded as “NEDERLAND”)
161	4	Branch Number. (ctrl02_bacsbranch)
165	8	ITAS date in yyyymmdd format.
173	20	Spaces

Transaction Rows

There are 4 different rows for each transaction. Each row is identified by the first two bytes which act as a record type. These are 21, 22, 23 and 24. All 4 records share the same payment number. Transactions are sorted by currency then time of creation (seconds since midnight)

Transaction Type 21

Start	Length	Data
1	2	Record Type “21”
3	4	Payment No. 4 digits, leading zero, starting at 1.
7	3	Currency Code. BANKCODES (ISO standard)
10	10	Bank Account Number. BANKCODES
20	3	Payment currency code . ISO standard
23	15	Amount. Formatted with 12 leading places including leading zeros and 3 decimal places i.e. 000000000000000. If the currency has 0 decimal places, it should be rounded prior to this.
38	8	Cash Value Date in format yyyymmdd
46	1	Domestic Cost (prompted in CASH)
47	1	Foreign Cost (prompted in CASH). Only secured if instruction kind is “0”
48	1	Instruction Kind. This is normally “0” but is “1” if payment method is “CH”
49	1	Transfer. This is normally “0”, but is “2” if payment method is “TT”
50	1	Cheque. This is “J” if the instruction kind is “1” (so method = “CH”)
51	1	Send Cheque (prompted in CASH)
52	2	Payment Instruction 1 (prompted in CASH). Only secured is instruction kind is “0”
54	2	Payment Instruction 2 (prompted in CASH). As instruction 1
56	2	Payment Instruction 3 (prompted in CASH). As instruction 1
58	2	Payment Instruction 4 (prompted in CASH). As instruction 1
60	1	Payment Concerns (prompted in CASH)
61	40	Payment Kind 1 (prompted in CASH). Only secured if payment concerns is “1” and goods code is “15” or “16”
101	40	Payment Kind 2 (prompted in CASH). As above
141	8	DNB Number. This is hard-coded as "00009613" if the payment concerns is 4 or 5
149	2	Goods Code. 01 to 16 (prompted in CASH), Only secured if payment concerns is “1”.
151	2	Article Number: 05, 07 or 22 (prompted in CASH). Only secured if payment concerns is “2”
153	4	Trader Number. This is “650” if payment concerns are “2”
157	36	Spaces

Transaction Type 22

Start	Length	Data
1	2	Record Type “22”
3	4	Payment No. 4 digits, leading zero, starting at 1
7	34	Client Bank Account (if instruction kind is not “1”)
41	35	Client Name
76	35	Client Address (if instruction kind is not “1” or send cheque = “3”)
111	35	Client Residence
146	2	Client ISO Country Code
148	35	Client Country
183	10	Spaces

Transaction Type 23

Start	Length	Data
1	2	Record Type “23”
3	4	Payment No. 4 digits, leading zero, starting at 1
7	11	Client Bank Swift Address (If instruction kind = “0”)
18	35	Client Bank Name (If instruction kind = “0”)
53	35	Client Bank Address (If instruction kind = “0”)
88	35	Client Bank Residence (If instruction kind = “0”)
123	2	Client Bank ISO Country Code (If instruction kind = “0”)
125	35	Client Bank Country (If instruction kind = “0”)
160	33	Spaces

Transaction Type 24

Start	Length	Data
1	2	Record Type “24”
3	4	Payment No. 4 digits, leading zero, starting at 1
7	35	Payment Description 1 (prompted in CASH)
42	35	Payment Description 2 (prompted in CASH)
77	35	Payment Description 3 (prompted in CASH)
112	35	Payment Description 4 (prompted in CASH)
147	46	Spaces

Currency Summary Row

A row is printed for each currency after all of the transactions have been printed.

Start	Length	Data
1	2	Record Type “31”
3	3	Payment ISO Code
6	15	Total amount for that currency. Formatted as per transactions formatting
21	4	Number of records for that currency, leading zeros.
25	168	Spaces

Footer Row

Start	Length	Data
1	2	Record Type “41”
3	6	Total record count, including all headers and footers, leading zero
9	4	Number of payments (i.e. highest payment number), leading zeros
13	24	Zeros
37	156	Spaces

Domestic File Format (CLIE)

The file created is a text file with the naming format [comp]CLIE[id].TXT, where [comp] is the company mnemonic, and [id] is a unique incrementing identity, automatically maintained on a company table (different to the foreign ID). It is 2 digits with a leading zero.

There are no restrictions on which characters can be displayed. All rows are 50 bytes.

Header Row

Start	Length	Data
1	4	“0001”
5	1	“A”
6	6	ITAS date as ddmmyy
12	8	“CLIEOP03”
20	5	Short Company Code e.g. “MANPR”
25	2	Day number as dd
27	2	File ID. This is an automatically incrementing identity value, secured on a company table, 2 digits with a leading zero.
29	1	“1”
30	21	Spaces

Sequence Header Rows

Sequence header rows are printed on change of value date and currency. There are two sequence header rows.

Start	Length	Data
1	4	“0010”
5	1	“B”
6	2	“00”
8	10	Operating Co. Bank Account No. (applicable code from BANKCODES)
18	4	Batch Number, leading zeros. Increments with each batch header; first is 0001
22	3	Currency
25	26	Spaces

Start	Length	Data
1	4	“0030”
5	1	“B”
6	1	“1”
7	6	Value date as ddmmyy
13	35	ITAS Company name
48	1	“P”
49	2	Spaces

Transaction Rows

There are a maximum of 6 transaction rows.

Main Transaction Row

Start	Length	Data
1	4	“0100”
5	1	“A”
6	4	Record Code. Normally “0005” unless the Client bank a/c number begins with a ‘P’, in which case “0000”
10	12	Amount formatted with 10 leading and 2 trailing, no decimal place. Leading zeros.
22	10	Op. Co. Bank Account Number – BANKCODES
32	10	Client Bank Account Number
42	9	Spaces

Payment Description Rows

There are up to 3 payment description rows, depending on whether there is content for this field.

Start	Length	Data
1	4	“0160”
5	1	“A”
6	32	Payment Description (prompted in CASH)
38	13	Spaces

Client Name Row

Start	Length	Data
1	4	“0170”
5	1	“B”
6	24	Client Name
30	11	Spaces
41	10	Spaces

Client Residence Row

Start	Length	Data
1	4	“0173”
5	1	“B”
6	20	Client Residence
26	15	Space
41	10	Space

Sequence Trailer Row

A single row is printed after each batch of transactions. It contains a checksum. This is the numeric values of all the client accounts and principal account numbers. It has leading zeros. Only the last 10 digits are used.

Start	Length	Data
1	4	“9990”
5	1	“A”
6	18	Total amount, 16 leading, 2 trailing, no decimal place, leading zeros.
24	10	Checksum (see description)
34	7	Number of records, leading zeros
41	10	Spaces

Footer Row

This record is 50 bytes in length.

Start	Length	Data
1	4	“9999”
5	1	“A”
6	45	Spaces

BACS/UK

S01 is used to specify the ITAS bank account and currency that will allow the user to make BACS payments in the simple and the payment processes of CASH.  The user activates the BACS file dispatch as frequently as they wish. If the Company has been setup (S01) for full BACS authorization, there will be several other options made available to ensure integrity/security of authorising, creation of transfer files and undo processes.   A text file is created with the naming format [xx]BACS[id].TXT, where [id] is a unique incrementing identity (ctrl02_bacsdomesticid) and [xx] is the company mnemonic. The is 2 digits with a leading zero.   The user is prompted to collect/dispatch any number of CP documents that have been nominated for BACS transfer during CASH entry, note only documents for the nominated company currency {ctrl02_bacsccy} can be secured.  The user selects the folder for saving the text file and can optionally create a copy in another directory/folder  There are 2 styles of BACS output; Standard and Sage (activated by user request on Transmit screen)

Standard style (.txt)

Start	Length	Data
1	8	Value Date, formatted dd/mm/yy
9	11	Amount, 8 leading, 2 trailing (no signing)
20	8	Client Bank Account ( 8 numeric) – CLI/Banks/chr23_accnum
28	18	Client Name
46	6	Client Bank SortCode( 6 numeric) – CLI/Banks/chr23_bankno+ chr23_bankbranch

  

Sage Style (.csv)

Column	Data
1	SortCode	max 6 digits, banktx_sortcode
2	Client Name
3	Client Bank A/c	8 numeric – CLI/Banks/chr23_accnum
4	Amount
5	Doc Reference

RIBA/Italy Banking

No definition

DEUTSCHE/Germany

S01 is used to specify the ITAS currency that will allow the user to make DEUTSCHE payments in the simple and the payment processes of CASH.  The ITAS accounts that are setup in BANKCODES further control the user as to which bank accounts are setup for transmission. The user activates the DEUTSCHE file dispatch in CASH as frequently as they wish, but the bank will only accept one file at a time.

File Format

The format of the file naming is DTAUSndd.TXT, where n is a number indicating the bank account (last digit of ITAS bank account) and dd is ITAS day number.

Character Format

The following characters are allowed in file:

a) Numerics 0-9 (ASCII 48 – 57, hex 30 - 39)

b) Upper case alphabetic A – Z (ASCII 65 – 90, hex 41 – 5A)

c) Special characters (see below)

Special Characters

Description	Character	ASCII	Hex
space		32	20
Period		46	2E
Comma		44	2C
Ampersand	“&”	38	26
Hyphen (Minus)		45	2D
Stroke		47	2F
Plus Sign		43	2B
Asterisk		42	2A
Dollar Sign		36	24
Percent Sign		37	25
A-Umlaut	“Ä”	91 or 142	5B or 8E
O-Umlaut	“Ö”	92 or 153	5C or 99
U-Umlaut	“Ü”	93 or 154	5D or 9A
Double-S	“ß”	126 or 225	7E or E1

Records

The file consists of fixed length records of 128 bytes. There is always a header and footer record (A and E), and at least 2 transaction records (C).

Data Carrier Header Record (A)

Details of sender and recipient; there is 1 header record per file.

Field	Offset	Length	Description	Content
1	1	4	Record Length	“0128”
2	5	1	Record Type	“A”
3	6	2	Data Indicator	“GK”
4	8	8	Receiving Bank Code (Numeric)	From BANKCODES, leading zeros
5	16	8		"00000000"
6	24	27	Name of customer	Operating company Name
7	51	6	Creation Date (DDMMYY)	Current (system) date
8	57	4	Blank	"    "
9	61	10	Bank Account Number	From BANKCODES, leading zeros
10	71	10	Numeric Customer Reference No. (Optional)	"0000000000"
11a	81	15	Blank	"               "
11b	96	8	Date of Execution (DDMMYYYY)	Value Date
11c	104	24	Blank	Spaces
12	128	1	Currency	“1”

Notes

Data Detail Record (C) – 1st Record

This contains transaction details.

Field	Offset	Length	Description	Content
1	1	4	Record Length	"0216"
2	5	1	Record Type	“C”
3	6	8	1st Credit Institution Bank Code	From BANKCODES, leading zeros
4	14	8	Beneficiary Bank Code	Client bank branch, leading zeros
5	22	10	Account Number	Client bank account, leading zeros
6	32	13	Internal Customer Number	"0000000000000"
7a	45	2	Text Key	“51”
7b	47	3	Text Key Extension	“000”
8	50	1	Reserved
9	51	11	DM Amount	"00000000000"
10	62	8	Bank Initially Instructed Code	From BANKCODES, leading zeros
11	70	10	Remitter/Payee Account Number	From BANKCODES, leading zeros
12	80	11	EUR Amount	Numeric, leading zeros
13	91	3	Reserved	"   "
14a	94	27	Remittee/Debtor Name	client Title
14b	121	8	Reserved	Spaces

Data Detail Record (C) – 2nd Record

Field	Offset	Length	Description	Content
15	1	27	Name	Operating Company Name
16	28	27	Reason for payment	Document Narrative
17a	55	1	Currency	“1”
17b	56	2	Reserved	"  "
18	58	2	Extension Attribute	"01"
19	60	2	Extension Indicator	"02"
20	62	27	Extension Part	Spaces
21	89	2	Extension Indicator	Spaces
22	91	27	Extension	Spaces
23	118	11	Reserved	Spaces

The extensions can continue onto a 3rd type C record consisting of 3 extension indicators and extension parts (29 x 4 = 116 bytes) plus 12 spaces.

Notes

Data Carrier Trailer (E)

Field	Offset	Length	Content	Description
1	1	4	Record Length	“0128”
2	5	1	Record Type	“E”
3	6	5	Reserved	Spaces
4	11	7	No. “C” records	Used for checking
5	18	13	DM total	"0000000000000"
6	31	17	C5 total	Used for checking
7	48	17	C4 total	Used for checking
8	65	13	EUR total
9	78	51	Reserved	Spaces

Notes

Text Keys

The text keys indicate the type of payment. The only one used in ITAS is 51 000:

Key	Extension	Description
04	000	Instruction to bank to pay debit notes
05	001	Authorisation of payee to collect
05	005	Debit from POS – electronic cash
05	006	Debit from POS – foreign cash
05	015	Debit from POS – drawing POZ
51	000	Transfer credit entry (e.g. commercial payment)
53	000	Salary, Wage, Pension credit entry
54	XXJ	Capital Building Fringe Benefit
56	000	Transfer by Public Funds

JP Morgan Format (CSV)

The JP Morgan export file is a comma-delimited file with the following format:

Header Record

Field	Type	Max Length	Description
Start of File Indicator	A	2	"CI"
Date/Time	N	14	Format YYYYMMDDHHMMSS
User Identifier	A	8	User Name (owner of the file)
Batch Number	N	4	Sequential batch number. Increments by 1 for each import done by the above user within one day.

Trailer Record

Field	Type	Max Length	Description
End of File Indicator	N	2	99
Total Detail Records	N	7	Max. value 9999999 (Number of detail records in file).
Hash Total of Amounts	N	21	Max. value 99999999999999999.999. Amount hash total, always max 3 decimal places.

Detail Records

The following detail type records can be created by ITAS:

Data Source

The data secured on the JP Morgan files comes from the banktx table in ITAS. This is maintained when creating the documents in CASH. In turn, its values are defaulted from CLI Bank Accounts (chr23). So, for example “Pay Method” is populated by banktx_fedaba which comes from the “FED ABA” field in CLI (chr23_fedaba).

FreeForm DMT Layout

Field	Type	Max Length	Description	ITAS	Sample
Record Indicator	N	2	4 = Create a DMT random transfer	"4"	4
Pay Method	A	3	Must be a valid CTM pay method for location. One of CHP, FED, BKT.	From banktx_fedaba and banktx_chips depending on which has content. If both have content, use FED. If none, use ‘CHP’. If an Internal payment, use “BKT”.	CHP
Bank	A	11	Must be a valid CTM bank.	"JP Morgan"	JP Morgan
Location	A	3	Must be a valid CTM location (NYC, SAN or HOU).	banktx_payvia. This can only be a valid “Payment Via” code used in BANKCODES	NYC
Account	A	34	Must be a valid CTM/CPS account. Lookup will be by account plus bank/location if supplied in the above fields. Must be an account held in the NYC back office.	cmy44_account where cmy44_nlaccno matches the nominal ledger bank account and cmy44_ccy matches the document currency and cmy44_payvia matches banktx_payvia.	400707225
Currency	A	3	USD. Can also be USN if BKT pay method.	dhl21_ccy	USD
Amount	N	15	14 digits and decimal place. Must be > 0.	dhlxx_amount	1.01
Value Date	D	8	Date must be >= today, cannot exceed max forward business days for the account's location and must not be a bank or local holiday.	dhl21_vdate	20071113
Pay thru Bank ID	N	35	Valid ID for pay method or free-format text.	banktx_correspfedaba or banktx_correspchips as per above.	21000089
Pay thru Bank Name	A	35	Free-format text or Namesearch name and address if ID has been entered.	banktx_correspname	Citibank
Pay thru Bank 2	A	35	As above.	banktx_corresplocation	New York
Pay thru Bank 3	A	35	As above.	Description of banktx_correspcountry
Pay thru Bank 4	A	35	As above.
Pay thru Advice Type	A	3	One of LTR, PHN, or SWF - only imported if the above fields have data.
Pay thru Instructions	A	35	Will only be imported if advice type specified.
Beneficiary Bank ID	A	35	Valid ID for pay method or free-format text	banktx_fedaba or banktx_chips	36204769
Beneficiary Bank Name	A	35	Free-format text or Namesearch name and address.	banktx_clibank	EKO Intl Bank
Beneficary Bank 2	A	35	as above	banktx_location	Nigeria
Beneficiary Bank 3	A	35	as above	Description of banktx_country
Beneficiary Bank 4	A	35	as above
Beneficiary Advice Type	A	3	One of LTR, PHN, or SWF - only imported if the above fields have data.
Beneficiary Instructions	A	35	Will only be imported if Beneficiary advice type specified.
Ult Bene ID	N	34	Valid ID for pay method or free-format text.	banktx_clibanknum	726128135
Ult Bene Name	A	35	Free-format text or Namesearch name and address if ID has been entered.	banktx_beneficiary
Ult Bene 2	A	35	Free-format text or Namesearch name and address if ID has been entered.
Ult Bene 3	A	35	As above.
Ult Bene 4	A	35	As above.
Ult Bene Advice Type	A	3	As above.
Ult Bene Instructions	A	35	Only imported if advice type specified.
Customer Reference	A	16	Corresponds to By Order Of panel on CPS Single Entry Screen.	Equivalent to the [picked_cliref] DOCDES rule
Originator Ref No	A	35	If this field is populated, it will be stored in the By Order of - Address 1
Originator Text	A	35	If this field is populated, it will be stored in the By Order of - Name
Reference text line 1	A	35/70	Line of free-format Reference text	banktx_reference
Reference text line 2	A	35/70	Line of free-format Reference text
Reference text line 3	A	35/70	Line of free-format Reference text
Reference text line 4	A	35/70	Line of free-format Reference text
Reference text line 5	A	35/70	Line of free-format Reference text
Reference text line 6	A	35/70	Line of free-format Reference text
Code Value 1	A	8	Valid Value for CPS Active Code 1
Code Value 2	A	8	Valid Value for CPS Active Code 2
Code Value 3	A	8	Valid Value for CPS Active Code 3
Code Value 4	A	8	Valid Value for CPS Active Code 4
Code Value 5	A	8	Valid Value for CPS Active Code 5
Code Value 6	A	8	Valid Value for CPS Active Code 6
Field text line 1	A	25	Free format. Must have a CPS Active Code 1
Field text line 2	A	25	Free format. Must have a CPS Active Code 2
Field text line 3	A	25	Free format. Must have a CPS Active Code 3
Field text line 4	A	25	Free format. Must have a CPS Active Code 4
Field text line 5	A	25	Free format. Must have a CPS Active Code 5
Field text line 6	A	25	Free format. Must have a CPS Active Code 6
By Order Of ID	A	35
By Order of - Name	A	35	By Order of information (Line 1 of 4).
By Order of - Address 1	A	35	By Order of information (Line 2 of 4).
By Order of - Address 2	A	35	By Order of information (Line 3 of 4).
By Order of - Address 3	A	35	By Order of information (Line 4 of 4).
Bank Info Line 4	A	35
Bank Info Line 5	A	35
Bank Charges	A	1

 FreeFormat GMT Layout

Field	Type	Max Length	Description	ITAS	JPMv1	Sample
Record Indicator	N	4	4.01 = Create a GMT random transfer	"4.01"		4.01
Pay Method	A	3	Must be a valid CTM pay method for location.	IAT or TLX		IAT
Bank	A	11	Must be a valid CTM bank.	"JP Morgan"		JP Morgan
Location	A	3	Must be a valid CTM location	banktx_payvia		LON
Account	A	34	Must be a valid CTM/CPS account. Lookup will be by account plus bank/location if supplied in the above fields. Must not be NYC account.	cmy44_account where cmy44_nlaccno matches the nominal ledger bank account and cmy44_ccy matches the document currency.		24677206
Currency	A	3	Must be a valid CTM currency	dhl21_ccy		USD
Amount	N	15	14 digits and decimal place. Must be > 0.	dhlxx_amount		1.01
Value Date	D	8	Date must be >= today, cannot exceed max forward business days for the account's location and must not be a bank or local holiday.	dhl21_vdate		20071113
Bene Bank ID	A	35	This field is imported(?)	banktx_sortcode or banktx_swift		chasgb21
Bene Bank Name	A	35	At least 1 character of text required. For payments, this is beneficiary bank.	banktx_clibank		jpmorgan chase bank
Bene Bank Address 1	A	35	Free-format text	banktx_location		Chaseside
Bene Bank Address 2	A	35	Free-format text	Description of banktx_country		Bournemouth
Bene Bank Address 3	A	35	Free-format text			Dorset
Ult Bene Acct No	A	34	Ultimate Beneficiary Credit Account for Payments	banktx_clibanknum		9999999
Ult Bene Name	A	35/70	At least 1 character of text required - name & address details. If the pay method is ATE or DFE (Asia text methods) then the max line length is 70. Otherwise it is 35.	banktx_beneficiary chr20_title (JPMv1)		Hivedome ltd
Ult Bene Address 1 Ult Bene Address 2	A	35/70	Free-format text	chr20_addr1 chr20_addr2	Y	Crofton poynters lane
Ult Bene Address 3 Ult Bene Address 4	A	35/70	Free-format text	chr20_addr3 chr20_addr4	Y	Southend Ss3 9tz
chr20_geogcd Description	A	70	Unused unless ATE or DFE.	Chr20_geogcd description	Y
Unused	A		Unused
Pay thru/Corres ID	A	35	If record indicator is 4.01 and pay method is not Asia text, this field is imported into the Correspondent ID.	banktx_correspsortcode or banktx_correspswift		chasus33
Pay thru/Corres Name	A	35	Free-format text - name & address of pay thru/correspondent.	banktx_correspname		jp morgan chase bank
Pay thru/Corres Bank Address 1	A	35	Free-format text.	banktx_corresplocation		new york plaza
Pay thru/Corres Bank Address 2	A	35	Free-format text.	Description for banktx_correspcountry		new york
Pay thru/Corres Bank Address 3	A	35	Free-format text.			10002
Instructions to Debit Bank Line 1	A	35	Free-format text.
Instructions to Debit Bank Line 2	A	35	Free-format text.
Instructions to Debit Bank Line 3	A	35	Free-format text.
Instructions to Debit Bank Line 4	A	35	Free-format text.
Correspondent Bank Charges	A	1	For Payments either "R" - Remitter or "B" - Beneficiary. Not used for Receipts.			R
Debit Bank Charges	A	1	Either "R" - Remitter or "B" - Beneficiary.			B
Customer Reference	A	16	Customer Ref. for Payments.	Equivalent to the [picked_cliref] DOCDES rule
Delivery Instructions	A		ATE/DFE Only
Pay thru/Corres ID	A	10	ATE/DFE Only
Remitter text line 1	A	35/70	Line of free-format Remitter text	"b/o" plus operating company title
Remitter text line 2	A	35/70	Line of free-format Remitter text
Remitter text line 3	A	35/70	Line of free-format Remitter text
Remitter text line 4	A	35/70	Line of free-format Remitter text
Remitter text line 5	A	70	ATE and DFE only
Remitter text line 6	A	70	ATE and DFE only
Remitter text line 7	A	70	ATE and DFE only
Remitter text line 8	A	70	ATE and DFE only
Remitter text line 9	A	70	ATE and DFE only
Remitter text line 10	A	70	ATE and DFE only
Remitter text line 11	A	70	ATE and DFE only
Remitter text line 12	A	70	ATE and DFE only
Code Value 1	A	8	Valid Value for CPS Active Code 1
Code Value 2	A	8	Valid Value for CPS Active Code 2
Code Value 3	A	8	Valid Value for CPS Active Code 3
Code Value 4	A	8	Valid Value for CPS Active Code 4
Code Value 5	A	8	Valid Value for CPS Active Code 5
Code Value 6	A	8	Valid Value for CPS Active Code 6
Field text line 1	A	25	Free format. Must have a CPS Active Code 1
Field text line 2	A	25	Free format. Must have a CPS Active Code 2
Field text line 3	A	25	Free format. Must have a CPS Active Code 3
Field text line 4	A	25	Free format. Must have a CPS Active Code 4
Field text line 5	A	25	Free format. Must have a CPS Active Code 5
Field text line 6	A	25	Free format. Must have a CPS Active Code 6

Bancafe Pagos (Colombia)

S01 is used to specify the currency that will allow the user to make Bancafe Pagos payments in the simple and the payment processes of CASH.  The user activates the Bancafe Pagos file dispatch as frequently as they wish. A text file is created with the naming format ccBANCAFEnnn.Txt, where cc is the company mnemonic and nnn is a unique incrementing identity, maintained on a company table (ctrl02_bacsdomesticid). The is 2 digits with a leading zero.   The user is prompted to collect/dispatch any number of CP documents that have been nominated for Bancafe Pagos  transfer during CASH entry, note only documents for the nominated company currency {ctrl02_bacsccy} can be secured.  The user selects the folder for saving the text file and can optionally create a copy on another media e.g. floppy disk, CD.

Field	Type	Length	Remarks
Destination Bank Code	Numeric	3	Right justified with leading zeros. Codes as per attached table. Bank No – chr23_bankno
Identification Number of Destination	Alphanumeric	15	Left justified with zeros at the right VAT Reg. No. – chr20_vatreg
ID Type	Alphanumeric	1	1    Cedula de Ciudadania 2    Nit Menores 3    NIT Personas Juridicas 4    Tarjeta de Identidad 5    NIT Persona Natural 6    Cedula de Extranjeria 7    NIT Empresa Unipersonal (BTA) 8    NIT Empresa Unipersonal (FBTA) R   Registro Civil de Nacimiento N   Nuip (Numero Unico de       Identificacion Personal) Id type - chr23_idtype
Account Number of Destination	Alphanumeric	17	Left justified with space to the right. Account No - chr23_accnum
Account Type of Destination	Numeric	1	0 = Corriente 1 = Ahorro Account type – chr23_acctype
Name of Recipientes	Alphanumeric	30	Left justified with spaces to the right. Allow normal letters and numbers only. (ASCII Convencional) A/c Title – chr20_title
Amount	Numeric	12.2	Right justified with spaces to the left. Decimal separator with point (.) Document amount - txx_amt
Type of Reference	Numeric	3	Always 999
Reference	Alphanumeric	50	Left justified with spaces to the right. Optional. Allow normal letters and numbers only. (ASCII Convencional) Document reference – txx_docref

Sebra

S01 is used to specify the currency that will allow the user to make Sebra payments in the simple and the payment processes of CASH.  The user activates the Sebra interface as frequently as they wish. A report is printed The user is prompted to collect/dispatch any number of CP documents that have been nominated for Sebra transfer during CASH entry, note only documents for the nominated company currency {ctrl02_bacsccy} can be secured. 

The report uses the company logo as set up in S01. The Sebra interface requires:

1) The client account SEBRA.P to be set up as a bank, and is used to supply the

    Central bank of name, contact and phone no.

2) The prevailing interest rate to be set up in the nominated currency (ctrl02_bacsccy) and name SEBRA

3) The 2 signatories to be set up in  TEXT with text names SIG1 and SIG2 and group SEBRA.

ANZ (Multi Client payment process)

This process enables the production of a CP document to include many different Client transactions. Each accounting leg will then be processed with its’ CLI/Bank static e.g. bank branch, account number

The export file is a txt file with the following format:

Header Record

Field	Type	Position	Description
Rec. type	N	1	"0"
Sequence Id	N	19-20	“01”
Name of User Inst.	A	21-23	“ANZ”
User Co Name	X	31-56	Company name ex. ITAS
User Id Number	N	57-62	Leading zero required
Description of entries	X	63-74	“CREDITORS”
Value Date	N	75-80	Format DDMMYY

Trailer Record

Field	Type	Position	Description
Rec. Type	N	1	“7”
Total Amount	N	21-30	Max. value 9999999999. Amount hash total, always implied 2  decimal places and leading ZERO filled
Total Credit Amounts	N	31-40	Max. value 9999999999. Amount hash total, always implied 2  decimal places and leading ZERO filled
Total Debit Amounts	N	41-50	Max. value 9999999999. Amount hash total, always implied 2  decimal places and leading ZERO filled
Item count	N	75-80	Max. value 999999 (Number of detail records in file).

Detail Records

Field	Type	Position	Description
Rec. Type	N	1	“1”
Bank No/branch	X	2-8	999-999 (need retrieve from Client bank data)
Account No.	N	9-17	Include leading zeros of the static data (CLI/Bank data)
Trans. code	X	19-20	“50”
Amount	N	21-30	Max. value 9999999999. Amount hash total, always implied 2  decimal places and leading ZERO filled
Name of Beneficiary	X	31-62
Transaction Ref	X	63-80
Trace BSB	X	81-87	999-999 (data for operating company)
Trace A/c	N	88-96	Include leading zeros of static data (CLI/bank for Op company)
Remitter name	X	97-112	Company (ITAS) name

ePF File Format (LD)

No definition

SEPA (Single Euro Payments Area) for Domestic/Euro and BLT91 for other currencies

This subsystem supports 2 separate file formats, dependent on currency i.e. EURO activates PAIN001 layout and foreign is BTL91. 

 The SEPA CT ISO20022 format is applied in conjunction with Rabo cash management procedures.

The S01 configuration must be followed to enable the CASH processes i.e. field? on Style, Ccy and bank will reference what needs to be configured. CLI Bank data is essential for the Operating Company and the Payee e.g. IBAN number, Address lines