Table BANK
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| BANK | BAN | Bank accounts | Payroll |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| BAN0 | BAN | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACCCOD | Accounting code | CAC | [CAC]CAC0=13;ACCCOD;[V]GSUPCLE | Block | ||||
| ACS | Access code | ACS | [ACS]ACS0=[BAN]ACS | Block | ||||
| ADDLIG | Address | 3 | A | 35 | ||||
| AUUID | Single identifier | AUUID | ||||||
| BAN | Code | BAN | [BAN]BAN0=[BAN]BAN | Delete | ||||
| BANACC | Account | A | 15 | |||||
| BANCSH | Bank or cash | M | 15 | 653 | ||||
| BICCOD | BIC code | A | 11 | |||||
| BIDNUM | Bank ID number | BID | ||||||
| CHGTYP | Rate type | M | 15 | 202 | ||||
| CPY | Company | CPY | [CPY]CPY0=[BAN]CPY | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CRETIM | Time | L | 8 | |||||
| CREUSR | Creation user | A | 5 | |||||
| CRY | Country | CRY | [TCY]TCY0=[BAN]CRY | Block | ||||
| CRYNAM | Country name | A | 30 | |||||
| CTY | City | CTY | ||||||
| CUR | Currency | CUR | [TCU]TCU0=[BAN]CUR | Block | ||||
| DES | Title | DES | ||||||
| DESSHO | Short title | SHO | ||||||
| EXPNUM | Export number | L | 8 | |||||
| FAX | Fax | TEL | ||||||
| FCY | Site | FCY | [FCY]FCY0=[BAN]FCY | Block | ||||
| FILEXT | File extension | A | 3 | |||||
| IBACOD | IBAN code | A | 34 | |||||
| JOU | Journal | A | 5 | |||||
| PAB1 | Paying bank 1 | A | 30 | |||||
| PAB2 | Paying bank 2 | A | 30 | |||||
| POSCOD | Postal code | POS | ||||||
| SAT | Status | SAT | ||||||
| SCTPROLOT | Processing by batch | M | 4 | 1 | ||||
| SENNUM | Sender number | A | 10 | |||||
| TEL | Telephone | TEL | ||||||
| TRECOD | Treasury interface | A | 12 | |||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDTIM | Time | L | 8 | |||||
| UPDUSR | Change user | A | 5 | |||||
| WEB | Internet address | A | 50 |