SUBRBK processing: Bank Statement Importing
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 |