Table PAYFRM
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| PAYFRM | FRM | Payment slips | A/P-A/R accounting |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| FRM0 | FRMFLG+FRMNUM | No | |
| FRM1 | FRMFLG+TFBDAT-FILIDMOD | Yes | KUS |
| FRM2 | FRMFLG+FRMGRP | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| BAN | Bank | BAN | [BAN]BAN0=[FRM]BAN | Block | ||||
| CHQTYP | Check type | M | 15 | 654 | ||||
| CPY | Company | CPY | [CPY]CPY0=[FRM]CPY | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| EXEDAT | Execution date | D | ||||||
| FILIDMOD | File identifier | A | 1 | KUS | ||||
| FRMFCY | Site | FCY | [FCY]FCY0=[FRM]FRMFCY | Block | ||||
| FRMFLG | Slip type | M | 15 | 685 | ||||
| FRMGRP | Group | A | 20 | |||||
| FRMNUM | Slip no. | VCR | ||||||
| FRMTYP | Discount type | M | 15 | 655 | ||||
| PAYTYP | Payment type | TPY | [TPY]TPY0=PAYTYP;[V]GSUPCLE | Block | ||||
| STA | Status | M | 30 | 689 | ||||
| TFBDAT | Bank file | D | ||||||
| TFBFIL | Bank file | A | 15 | |||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 |