Script BSILIBRCL: BSILIBRCL Reconciliation BSI import

The RELBANTRANDET entry point can be used to set or change field values when transferring data from the BSIIMPD table to the RELBANK table during the reconciliation flow of BSIIMPORT.

Transaction

There is one open transaction.

Log file

There is one log file opened.

Call cases

The entry point is called before writing the RELBANK record with transferred data from BSIIMPD.

Available variables and masks

The [M:BSIIMP] mask is available.

Variable or mask	Definition
Mask  [M: BSIIMP]	BSI import

Example

When the entry point is called, all required data from the BSIIMPD table is transferred to the RELBANK table. The entry point is called just before writing the RELBANK record.

$ACTION

    Case ACTION

        When " RELBANTRANDET "        : Gosub RELBANTRANDET

        When Default

    Endcase

Return

$ RELBANTRANDET

      #add leading zeros

      [F:RBK]REF = [F:BSIIMPD]FREREF(3)

RETURN

Open tables

Table	Significant content	Table Title
BSIIMPD	Yes	Bank statement import details
BSIIMP	Yes	Bank statement import
RELBANK	Yes	Bank account statement
BSIFILFMT	No	Bank import format definition
BSIFILFMT	No	Bank import format def. detail
BSISCT	No	Bank import segment
BSISCTD	No	Bank import segment detail
BSIIMPPAR	No	Bank import settings
BSIIMPDS	No	Bank statement imp. sub-detail

The RELBANTRANSUBDET entry point can be used to set or change field values when transferring data from the BSIIMPDS table to the RELBANK table in the reconciliation flow of BSIIMPORT.

Transaction

There is one open transaction.

Log file

There is one log file opened.

Call cases

The entry point is called before writing the RELBANK record with transferred data from BSIIMPDS.

Available variables and masks

The [M:BSIIMP] mask is available.

Variable or mask	Definition
Mask  [M: BSIIMP]	BSI import

Example

When the entry point is called, all required data from the BSIIMPDS table is transferred to the RELBANK table. The entry point is called just before writing the RELBANK record.

$ACTION

    Case ACTION

        When " RELBANTRANSUBDET "        : Gosub RELBANTRANSUBDET

        When Default

    Endcase

Return

$ RELBANTRANSUBDET

      #add leading zeros

      [F:RBK]REF = [F:BSIIMPDS]FREREF(3)

RETURN

Open tables

Table	Significant content	Table Title
BSIIMPD	Yes	Bank statement import details
BSIIMP	Yes	Bank statement import
RELBANK	Yes	Bank account statement
BSIFILFMT	No	Bank import format definition
BSIFILFMT	No	Bank import format def. detail
BSISCT	No	Bank import segment
BSISCTD	No	Bank import segment detail
BSIIMPPAR	No	Bank import settings
BSIIMPDS	Yes	Bank statement imp. sub-detail