Data by Bank/Payment Method (tfcmg0645m000)

Use this session to maintain bank data that is linked to a selected payment method.

The data includes the transactions of receipts and payments with the bank relation.

Field Information

Bank

The bank relation. You can define a bank relation in the Bank Relation (tfcmg0110s000) session.

Payment/Receipt Method

The payment method. You can define a payment method in the Payment/Receipt Methods (tfcmg0540m000) session.

The amounts are posted to ledger accounts and dimensions, depends on the combination of bank relation and payment method selected.

Anticipated Postings
Anticipated Transaction Type

The transaction type used for creating anticipated payment/receipt documents for this combination of bank/payment method.

Note: 

The transaction type category must be Cash.

The Block Backdating check box must be cleared in the Transaction Types (tfgld0511m000) session.

Anticipated Payment/Receipt Ledger Account

The ledger account to which the anticipated payments or receipts amounts are posted.

The ledger account is defined in the Chart of Accounts (tfgld0508m000) session.

Dimensions

dimensions

Series Number

The series that LN uses to generate the document numbers for anticipated payments/receipts.

Path Payment/Receipt Files

The path in which the payment/direct debit files are written.

The path must end with ~, which represents the file name.

Example

Path Creates a file with File name
/home/username/~~~~~~~T~~~~~ The current date and time: YYYYMMDD-HHMMSS 20151023-142315
/home/username/~~~~~~~T~~~ The current date and time: YYYYMMDD-HHMM 20151023-1423
/home/username/~~~~~~~~ The current date:YYYYMMDD 20151023
/home/username/~~~~~~ The current date:YYMMDD 151023
/home/username/~~~~ The current date:MMDD 1023

You can also create several files with the current date as the file name. A serial number is added at the end of the file name. The path includes #, which represents the serial number for the files created in a single day.

Example

Path Creates up to File name
/home/username/~~~~~~~~.# 9 files with the current date and a serial number as the file name. 23102015.1 to 23102015.9
/home/username/~~~~~~~~.## 99 files with the current date and a serial number as the file name. 23102015.01 to 23102015.99
/home/username/~~~~~~~~.### 999 files with the current date and a serial number as the file name. 23102015.001 to 23102015.999
Note: This field is available if, in the Payment/Receipt Method (tfcmg0140s000) session, Output Type is set to File.
Layout

The code of the XML layout that is used to generate the XML file.

Note: 

This field is available if both of the following apply:

  • The XML File check box in the Payment/Receipt Method (tfcmg0140s000) session is selected.
  • The status of the XML layout is Active.
Path for XML File

The server path in which the XML file is written.

The path must end with ~, which represents the file name.

Example

Date: October 23rd 2015

Path Creates a file with File name
/home/username/~~~~~~~T~~~~~ The current date and time: YYYYMMDD-HHMMSS 20151023-142315
/home/username/~~~~~~~T~~~ The current date and time: YYYYMMDD-HHMM 20151023-1423
/home/username/~~~~~~~~ The current date:YYYYMMDD 20151023
/home/username/~~~~~~ The current date:YYMMDD 151023
/home/username/~~~~ The current date:MMDD 1023

You can also create several files with the current date as the file name. A serial number is added at the end of the file name. The path includes #, which represents the serial number for the files created in a single day.

Example

Date: October 23rd 2015

Path Creates up to File name
/home/username/~~~~~~~~.# 9 files with the current date and a serial number as the file name. 23102015.1 to 23102015.9
/home/username/~~~~~~~~.## 99 files with the current date and a serial number as the file name. 23102015.01 to 23102015.99
/home/username/~~~~~~~~.### 999 files with the current date and a serial number as the file name. 23102015.001 to 23102015.999
Local Path

The local path in which the XML file is written.

Note: This field is available only if the Store File Locally check box is selected in the Transfer Payments (tfcmg1260m000) session.

The path must end with ~, which represents the file name.

Example

Date: October 23rd 2015

Path Creates a file with File name
/home/username/~~~~~~~T~~~~~ The current date and time: YYYYMMDD-HHMMSS 20151023-142315
/home/username/~~~~~~~T~~~ The current date and time: YYYYMMDD-HHMM 20151023-1423
/home/username/~~~~~~~~ The current date:YYYYMMDD 20151023
/home/username/~~~~~~ The current date:YYMMDD 151023
/home/username/~~~~ The current date:MMDD 1023

You can also create several files with the current date as the file name. A serial number is added at the end of the file name. The path includes #, which represents the serial number for the files created in a single day.

Example

Date: October 23rd 2015

Path Creates up to File name
/home/username/~~~~~~~~.# 9 files with the current date and a serial number as the file name. 23102015.1 to 23102015.9
/home/username/~~~~~~~~.## 99 files with the current date and a serial number as the file name. 23102015.01 to 23102015.99
/home/username/~~~~~~~~.### 999 files with the current date and a serial number as the file name. 23102015.001 to 23102015.999
Remove File From Server

If you specify a local path, you can select this check box to remove the XML file that is created on the server by default.

Number of Clearance Days

The number of days taken to process a bank order. This includes the time taken to send the diskette if the output type is File in the Output Type field in the Payment/Receipt Method (tfcmg0140s000) session.

Clearance days are required for automatic reconciliation in the Select for Automatic Receipt Reconciliation (tfcmg2121s000) session.

Min. No. Days before Planned Debit Date

The number of days preceding the planned debit date that a debit order can be sent to the bank without being rejected. If there are not enough days between the planned debit date and the day of processing, the process will not continue.

The value specified here is checked in these sessions:

  • Audit Direct Debit Batch (tfcmg4255m000)
  • Transfer Direct Debits (tfcmg4260s000)

A value of '0' (zero) means that there is no minimum, and thus no check will be performed.