Table PORQRC
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| PORQRC | PORQRC | Portuguese QR-data | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| PORQRC0 | DOCTYP+DOCNUM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[PORQRC]CREUSR | Other | ||||
| DOCNUM | Document number | VCR | ||||||
| DOCTYP | Entry type | A | 5 | |||||
| IMGQRC | QR image | ABB | ||||||
| QRC_A | A | 9 | ||||||
| QRC_B | A | 30 | ||||||
| QRC_C | Customer country | A | 12 | |||||
| QRC_D | Document type | A | 2 | |||||
| QRC_E | Document status | A | 1 | |||||
| QRC_F | Document date | A | 8 | |||||
| QRC_G | Document ID | A | 60 | |||||
| QRC_H | ATCUD | A | 70 | |||||
| QRC_I1 | A | 5 | ||||||
| QRC_I2 | A | 16 | ||||||
| QRC_I3 | A | 16 | ||||||
| QRC_I4 | A | 16 | ||||||
| QRC_I5 | A | 16 | ||||||
| QRC_I6 | A | 16 | ||||||
| QRC_I7 | A | 16 | ||||||
| QRC_I8 | A | 16 | ||||||
| QRC_J1 | A | 5 | ||||||
| QRC_J2 | A | 16 | ||||||
| QRC_J3 | A | 16 | ||||||
| QRC_J4 | A | 16 | ||||||
| QRC_J5 | A | 16 | ||||||
| QRC_J6 | A | 16 | ||||||
| QRC_J7 | A | 16 | ||||||
| QRC_J8 | A | 16 | ||||||
| QRC_K1 | A | 5 | ||||||
| QRC_K2 | A | 16 | ||||||
| QRC_K3 | A | 16 | ||||||
| QRC_K4 | A | 16 | ||||||
| QRC_K5 | A | 16 | ||||||
| QRC_K6 | A | 16 | ||||||
| QRC_K7 | A | 16 | ||||||
| QRC_K8 | A | 16 | ||||||
| QRC_L | Not subject to VAT | A | 16 | |||||
| QRC_M | A | 16 | ||||||
| QRC_N | A | 16 | ||||||
| QRC_O | Document total | A | 16 | |||||
| QRC_P | Withholding tax | A | 16 | |||||
| QRC_Q | Hash code | A | 4 | |||||
| QRC_R | Certificate number | A | 4 | |||||
| STAQRC | QR image status | M | 4 | 1 | ||||
| STRQRC | A | 250 | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[PORQRC]UPDUSR | Other |