Table TMPCNSBAN
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| TMPCNSBAN | TCB | Bank inquiry | A/P-A/R accounting |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| TCB0 | TCBNUM | No | |
| TCB1 | USRCRE+ADXNUM | Yes | |
| TCB2 | ACCNUM | Yes | |
| TCB3 | NUMPAY+USRCRE+ADXNUM | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACCDAT | Accounting date | D | ||||||
| ACCNUM | Unique number | UNQ | ||||||
| ADXNUM | No. | L | 8 | |||||
| AMTBAN | Bank amount | MD1 | ||||||
| AMTCUR | Amount in currency | MD1 | ||||||
| AUUID | Single identifier | AUUID | ||||||
| BANDAT | Bank date | D | KIT | |||||
| BID | Bank account number | BID | ||||||
| BIDCRY | Bank acct. country | CRY | [TCY]TCY0=[TCB]BIDCRY | Block | ||||
| BILDAT | Date created | D | ||||||
| BOLLATO | Bollato sequence number | VCR | KIT | |||||
| BPR | BP | BPR | [BPR]BPR0=[TCB]BPR | Block | ||||
| BPRDATVCR | Document date | D | ||||||
| BPRREF | Drawee reference | A | 10 | |||||
| BPRSAC | Control | SAC | ||||||
| BPRVCR | Source document | A | 20 | |||||
| CHQNUM | Check number | A | 15 | |||||
| COLOR | Color | C | 1 | |||||
| CRDNUM | Bank card number | A | 16 | |||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[TCB]CREUSR | Other | ||||
| CUR | Currency | CUR | [TCU]TCU0=[TCB]CUR | Block | ||||
| DES | Description | DES | ||||||
| DUDDAT | Due date | D | ||||||
| ENTDAT | Entry date | D | ||||||
| FCY | Site | FCY | [FCY]FCY0=[TCB]FCY | Block | ||||
| JOU | Journal | JOU | [JOU]JOU0=JOU;[V]GSUPCLE | Block | ||||
| NUM | Order no. | VCR | ||||||
| NUMPAY | Payment no. | VCR | ||||||
| ORIDAT | Source date | D | ||||||
| PAM | Payment method | TAM | [TAM]TAM0=PAM;[V]GSUPCLE | Block | ||||
| PAYLOT | Batch code | VCR | ||||||
| PAYTYP | Transaction | TPY | [TPY]TPY0=PAYTYP;[V]GSUPCLE | Block | ||||
| RATCUR | Currency rate | RCU | ||||||
| RATDAT | Rate date | D | ||||||
| RATRPT | Reporting rate | RCU | ||||||
| REF | Reference | REF | ||||||
| SNS | Sign | M | 15 | 632 | ||||
| STA | Status | M | 30 | 689 | ||||
| TCBNUM | Internal number | L | 8 | |||||
| TYP | Entry type | GTE | [GTE]GTE0=TYP;[V]GSUPCLE | Block | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[TCB]UPDUSR | Other | ||||
| USRCRE | User | AUS | [AUS]CODUSR=[TCB]USRCRE | Block | ||||
| VALDAT | Value date | D |