Table TABPAYTYP
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| TABPAYTYP | TPY | Payment transactions | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| TPY0 | PAYTYP+LEG | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACETYP91 | Payment grouping | M | 15 | 657 | ||||
| ACETYP92 | Discount grouping | M | 15 | 657 | ||||
| ACS | Access code | ACS | [ACS]ACS0=[TPY]ACS | Block | ||||
| AUTACE10 | Group entry | GRA | [GRA]GRA0=[TPY]AUTACE10 | Block | ||||
| AUTACE3 | Group entries | GRA | [GRA]GRA0=AUTACE3 | Block | ||||
| AUTACE8 | Group entries | GRA | [GRA]GRA0=AUTACE8 | Block | ||||
| AUTACE9 | Group entries | GRA | [GRA]GRA0=AUTACE9 | Block | ||||
| AUUID | Single identifier | AUUID | ||||||
| BANCSH | Bank or cash | M | 15 | 653 | ||||
| BPRTYP | Business partner | M | 15 | 644 | KPO | |||
| CIB | Interbank code | ADI | [ADI]CODE=306;CIB | Block | ||||
| CODEDT | Payment report code | TED | [TED]TED0=CODEDT;[V]GSUPCLE | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CSHVATRGM | Cash VAT | M | 4 | 1 | KPO | |||
| DACADD | Address | M | 4 | 1 | ||||
| DACAMTBAN | Bank amount | M | 4 | 1 | ||||
| DACBAN | Bank | M | 4 | 1 | ||||
| DACBANDAT | Bank date | M | 4 | 1 | ||||
| DACBID | Bank account number | M | 4 | 1 | ||||
| DACBILDAT | Date created | M | 4 | 1 | ||||
| DACBPRREF | Drawee reference | M | 4 | 1 | ||||
| DACCHQBAN | Pay-by branch | M | 4 | 1 | ||||
| DACCHQNUM | Check number | M | 4 | 1 | ||||
| DACCHQTYP | Check type | M | 4 | 1 | ||||
| DACCPY | Company | M | 4 | 1 | ||||
| DACCRDAUZ | Credit card authorized | M | 4 | 1 | ||||
| DACCRDNUM | Bank card number | M | 4 | 1 | ||||
| DACCURRAT | Currency rate | M | 4 | 1 | ||||
| DACDES | Header description | M | 4 | 1 | ||||
| DACDESLIN | Line description | M | 4 | 1 | ||||
| DACDUDDAT | Due date | M | 4 | 1 | ||||
| DACEPARENPAY | Payment reason | M | 4 | 1 | ||||
| DACFRMREF | Remittance reference | M | 4 | 1 | ||||
| DACFRMTYP | Discount type | M | 4 | 1 | ||||
| DACORIDAT | Source date | M | 4 | 1 | ||||
| DACPAB1 | Paying bank 1 | M | 4 | 1 | ||||
| DACPAB2 | Paying bank 2 | M | 4 | 1 | ||||
| DACPAM | Payment method | M | 4 | 1 | ||||
| DACPAYTYP | Payment entry transaction | C | 4 | REGBC | ||||
| DACPURTYP | Purchase type | M | 4 | 1 | ||||
| DACPYL | Entry batch | M | 4 | 1 | ||||
| DACREF | Reference | M | 4 | 1 | ||||
| DACREGNUM | Bank/Cash reg. no. | C | 4 | REGBC | ||||
| DACSUP | Extra field 1 | 30 | M | 4 | 1 | |||
| DACVALDAT | Value date | M | 4 | 1 | ||||
| DENDEF | Default payment attribute | CDA | [CDA]CDA0=DENDEF;[V]GSUPCLE | Block | ||||
| DES | Description | DES | ||||||
| DESSHO | Short description | SHO | ||||||
| DESTRA | Description | AX3 | ||||||
| DUDFLG | Due date | M | 4 | 1 | ||||
| EDTFLG | Edit flag | M | 4 | 1 | ||||
| ENAFLG | Active | M | 4 | 1 | ||||
| EPACDTTRF | SEPA generation | M | 4 | 1 | ||||
| EXPNUM | Export number | L | 8 | |||||
| FICCAS | File grouping code | ADI | [ADI]CODE=325;FICCAS | Block | CASIN | |||
| FILREF6 | File reference | A | 10 | |||||
| FILREF71 | File reference | A | 10 | |||||
| FILREF72 | File reference | A | 10 | |||||
| FILREF8 | File reference | A | 10 | |||||
| FLGCAS | Triggering event | M | 15 | 2673 | CASIN | |||
| FLGEND | Endorsement flag | C | 4 | KAG | ||||
| GFY | Group | AGF | [AGF]AGF0=[TPY]GFY | Block | ||||
| GRPCUR | Currency | M | 4 | 1 | ||||
| GRPDUD | Due date | M | 4 | 1 | ||||
| GRPPAM | Payment method | M | 4 | 1 | ||||
| JOU10 | Journal type | M | 15 | 660 | ||||
| JOU3 | Journal type | M | 15 | 660 | ||||
| JOU8 | Cash journal type | M | 15 | 660 | ||||
| JOU82 | Discount journal type | M | 15 | 660 | ||||
| JOU9 | Journal type | M | 15 | 660 | ||||
| LEG | Legislation | ADI | [ADI]CODE=909;LEG | Block | ||||
| LOTPROBALCTL | Balance control | M | 4 | 1 | ||||
| NATPAY | File family | M | 5 | 2604 | ||||
| NBRCOL | No. of fixed columns | C | 2 | |||||
| NBRPAM | Number of payment methods | C | 2 | |||||
| NBRSUP | No. | C | 2 | |||||
| PAM | Payment method | 10 | TAM | [TAM]TAM0=PAM;[V]GSUPCLE | Block | |||
| PAYAPP | Payment authorization | M | 4 | 1 | ||||
| PAYPPS | Auto proposal | M | 4 | 1 | ||||
| PAYTYP | Payment type | TPY | [TPY]TPY0=PAYTYP;LEG | Delete | ||||
| RATINV | Invoices rate | M | 4 | 1 | ||||
| RATTYP | Rate type | M | 15 | 202 | ||||
| SHOTRA | Short description | AX1 | ||||||
| SNS | Sign | M | 15 | 661 | ||||
| SPACSH | Cash payment | M | 4 | 1 | KSP | |||
| STA2 | Acceptance return | M | 4 | 1 | ||||
| STA3 | Notes P/R posting | M | 4 | 1 | ||||
| STA4 | Bank allocation | M | 4 | 1 | ||||
| STA5 | Remittances | M | 4 | 1 | ||||
| STA6 | Electronic file | M | 4 | 1 | ||||
| STA7 | Paying banks | M | 4 | 1 | ||||
| STA8 | Intermediate posting | M | 4 | 1 | ||||
| STA9 | Bank posting | M | 4 | 1 | ||||
| SWIPAYTYP | Swiss payment type | M | 15 | 3662 | KSW | |||
| UPDBIL | Portfolio update | M | 15 | 680 | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| ZONSUP | Extra field 2 | 30 | A | 10 |