Table BID
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| BID | BID | Bank ID statement | Supervisor |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| BID0 | BPATYP+BPANUM+BIDNUM+BPAADD | No | |
| BID2 | BPATYP+BPANUM+BPAADD | Yes | |
| BID1 | BPATYP+BPANUM+BVRNUM | Yes | KSW |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACCNONREI | Non resident account | M | 4 | 1 | ||||
| AUUID | Single identifier | AUUID | ||||||
| BICCOD | BIC code | A | 11 | VII | ||||
| BIDNUM | Bank acct. number | BID | ||||||
| BIDNUMFLG | By default | M | 4 | 1 | ||||
| BNF | Beneficiary | PAB | ||||||
| BPAADD | Address | ADR | ||||||
| BPANUM | Entity | BPA | ||||||
| BPATYP | Entity type | M | 15 | 943 | ||||
| BVRNUM | ISR customer no. | A | 11 | KSW | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | AUS | [AUS]CODUSR=[BID]CREUSR | Other | ||||
| CRY | Country | CRY | [TCY]TCY0=[BID]CRY | Block | ||||
| CUR | Currency | CUR | [TCU]TCU0=[BID]CUR | Block | ||||
| EXPNUM | Export number | L | 8 | |||||
| IBAN | IBAN pref | A | 4 | |||||
| MIDBICCOD | Intermediary bank BIC code | A | 11 | VII | ||||
| MIDCRY | Intermediary bank country | CRY | [TCY]TCY0=[BID]MIDCRY | Block | VII | |||
| MIDPAB1 | Intermediary bank name | PAB | VII | |||||
| MIDPAB2 | Intermediary bank address 1 | PAB | VII | |||||
| MIDPAB3 | Intermediary bank address 1 | PAB | VII | |||||
| MIDPAB4 | Intermediary bank address 3 | PAB | VII | |||||
| PAB1 | Paying bank | PAB | ||||||
| PAB2 | Paying bank 2 | PAB | VII | |||||
| PAB3 | Paying bank 3 | PAB | VII | |||||
| PAB4 | Paying bank 4 | PAB | VII | |||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | AUS | [AUS]CODUSR=[BID]UPDUSR | Other |