Table SWIQRC
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
SWIQRC | SWIQRC | Swiss QR-data | A/P-A/R accounting |
Key | Description | Duplicates | Activity code |
---|---|---|---|
SWIQRC0 | NUM+ORIMOD | No | |
SWIQRC1 | REF+ORIMOD | Yes |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
ALTPAR1 | Parameter | A | 100 | |||||
ALTPAR2 | Parameter | A | 100 | |||||
AMT | Payment amount | A | 12 | |||||
AUUID | Single identifier | AUUID | ||||||
CDTRADRLIN1 | Address | A | 70 | |||||
CDTRADRLIN2 | Address | A | 70 | |||||
CDTRADRTP | Address type | A | 1 | |||||
CDTRBLDGNBR | House no. | A | 70 | |||||
CDTRCRY | Country | A | 2 | |||||
CDTRCTY | City | A | 35 | |||||
CDTRNAM | Name | A | 70 | |||||
CDTRPSTCOD | Postal code | A | 16 | |||||
CDTRSTRNAM | Street | A | 70 | |||||
CHRCODTYP | Type | A | 1 | |||||
CREDATTIM | Date time | ADATIM | ||||||
CREUSR | User | AUS | [AUS]CODUSR=[SWIQRC]CREUSR | Other | ||||
CUR | Currency | A | 3 | |||||
IBACOD | IBAN code | A | 21 | |||||
IMGQRC | QR image | ABB | ||||||
NUM | Document no. | VCR | ||||||
ORIMOD | Source module | M | 10 | 14 | ||||
PAYREFTYP | Type of payment reference | A | 4 | |||||
QRCODTYP | A | 3 | ||||||
REF | Reference | A | 27 | |||||
STAQRC | QR image status | M | 4 | 1 | ||||
STRDBKGINF | Invoice information | A | 140 | |||||
TRAILER | Unique code | A | 3 | |||||
UCDTADRTP | Address type | A | 1 | |||||
UCDTRADRLIN1 | Address | A | 70 | |||||
UCDTRADRLIN2 | Address | A | 70 | |||||
UCDTRBLDGNBR | House no. | A | 70 | |||||
UCDTRCRY | Country | A | 2 | |||||
UCDTRCTY | City | A | 35 | |||||
UCDTRNAM | Name | A | 70 | |||||
UCDTRPSTCOD | Postal code | A | 16 | |||||
UCDTRSTRNAM | Street | A | 70 | |||||
UDBTADRTP | Address type | A | 1 | |||||
UDBTRADRLIN1 | Address | A | 70 | |||||
UDBTRADRLIN2 | Address | A | 70 | |||||
UDBTRBLDGNBR | House no. | A | 70 | |||||
UDBTRCRY | Country | A | 2 | |||||
UDBTRCTY | City | A | 35 | |||||
UDBTRNAM | Name | A | 70 | |||||
UDBTRPSTCOD | Postal code | A | 16 | |||||
UDBTRSTRNAM | Street | A | 70 | |||||
UPDDATTIM | Date time | ADATIM | ||||||
UPDUSR | User | AUS | [AUS]CODUSR=[SWIQRC]UPDUSR | Other | ||||
USTREF | Unstructured reference | A | 140 | |||||
VER | Version | A | 4 |