Entry points > Module A/P-A/R accounting > Standard script SUBRBK 

LINE: After the write of a line in the statements table

Use this entry point to manage the update of tables other than the statement table (RELBANK) when a statement is loaded.

Context and operating mode

Transaction

There is one transaction in progress.

Log file

There is an open log file.

Different call cases

This entry point intervenes after each line of the loaded statement are written in the RELBANK table, irrespective of the type of the line processed (start balance, detail or end balance).

Available variables and masks
The RELBAN mask is available.

Variable or mask

Definition

 RELBAN [DIA]

 Criteria mask

Open tables

The [RBK] class contains the statement line that has just been inserted in the table.

Table

Significant content

Table Title

 RELBANK [RBK]

 

 Statements

 RELBANK [RBKK]

 

 Statements

 BANK [BAN]

 

 Bank accounts

 TABFILBAN [TFB]

 

 Bank file definitions

 TABCUR [TCU]

 

 Currencies

 COMPANY [CPY]

 

 Companies

 TABCOUAFF [TCA]

 

 Sequence number assignment

RBKIMP: Before importing the file

Use this entry point to take over before importing the file.

Context and operating mode

Transaction

There is one transaction in progress.

Log file

There is an open log file.

Different call cases

The entry point is called before importing the file.

By this entry point, backups of the file to import can be carried out if needed.

Available variables and masks

The RELBAN mask is available.

Variable or mask

Definition

 RELBAN [DIA]

 Criteria mask

Open tables

The [RBK] class is empty and is populated during the read of the statement.

Table

Significant content

Table Title

 RELBANK [RBK]

 

 Statements

 RELBANK [RBKK]

 

 Statements

 BANK [BAN]

 

 Bank accounts

 TABFILBAN [TFB]

 

 Bank file definitions

 TABCUR [TCU]

 

 Currencies

 COMPANY [CPY]

 

 Companies

 TABCOUAFF [TCA]

 

 Sequence number counters

CTRFRM: Before the read of a formula to be imported

This entry point is used to control import formulas for bank statements.

Context and operating mode

Transaction

There is one transaction in progress.

Log file

There is an open log file.

Different call cases

This entry point is called before the date are assigned in the RELBANK table, irrespective of the type of line processed (start balance, detail or end balance).

Standard and specific formulas can be controlled via this entry point before populating the RELBANK table.

Available variables and masks

The RELBAN mask is available.

Variable or mask

Definition

 RELBAN [DIA]

 Criteria mask

COK [L]

 Validity flag (COK=0 = Error)

Open tables

The [RBK] class is empty and is populated during the read of the statement.

Table

Significant content

Table Title

 RELBANK [RBK]

 

 Statements

 RELBANK [RBKK]

 

 Statements

 BANK [BAN]

 

 Bank accounts

 TABFILBAN [TFB]

 

 Bank file definitions

 TABCUR [TCU]

 

 Currencies

 COMPANY [CPY]

 

 Companies

 TABCOUAFF [TCA]

 

 Sequence number assignment

MAJFRM: After the read of a formula to import

This entry point is used to exploit new formulas in the bank statement import.

Context and operating mode

Transaction

There is one transaction in progress.

Log file

There is an open log file.

Different call cases

This entry point is called before the read of each line in the statement loaded in RELBANK table, irrespective of the type of line processed (start balance, detail, end balance).

Standard and specific formulas can populate or modify the data in the RELBANK table.

Available variables and masks

The RELBAN mask is available.

Variable or mask

Definition

 RELBAN [DIA]

 Criteria mask

COK [L]

 Validity flag (COK=0 = Error)

Open tables

The [RBK] class is empty and is populated during the read of the statement.

Table

Significant content

Table Title

 RELBANK [RBK]

 

 Statements

 RELBANK [RBKK]

 

 Statements

 BANK [BAN]

 

 Bank accounts

 TABFILBAN [TFB]

 

 Bank file definitions

 TABCUR [TCU]

 

 Currencies

 COMPANY [CPY]

 

 Companies

 TABCOUAFF [TCA]

 

 Sequence number assignment

SNSFRM: Before the assignment of the sign and amount to be imported

Use this entry point to take over before the assignment of the amount and the sign for the bank statement line.

Context and operating mode

Transaction

There is one transaction in progress.

Log file

There is an open log file.

Different call cases

This entry point is called before the assignment of the amount and sign of a statement line.

Assignments of sign and amount can be carried out via this entry point. If when resuming the execution of the processing, the SENS variable is null, the standard assignment will be performed.

Available variables and masks

The RELBAN mask is available.

Variable or mask

Definition

 RELBAN [DIA]

 Criteria mask

SENS [L]

 Line sign

IMPMONT [L]

 Line amount

CHP [L]

 Current field

VIRG [L]

 Number of decimal

COK [L]

 Validity flag (COK=0 = Error)

 Open tables

The [RBK] class is empty and is populated during the read of the statement.

Table

Significant content

Table Title

 RELBANK [RBK]

 

 Statements

 RELBANK [RBKK]

 

 Statements

 BANK [BAN]

 

 Bank accounts

 TABFILBAN [TFB]

 

 Bank file definitions

 TABCUR [TCU]

 

 Currencies

 COMPANY [CPY]

 

 Companies

 TABCOUAFF [TCA]

 

 Sequence number assignment