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 | VAT number | A | 9 | |||||
QRC_B | Customer VAT | 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 | Region VAT rule | A | 5 | |||||
QRC_I2 | Exempted VAT base | A | 16 | |||||
QRC_I3 | Reduced VAT base | A | 16 | |||||
QRC_I4 | Total reduced VAT | A | 16 | |||||
QRC_I5 | Intermediate VAT base | A | 16 | |||||
QRC_I6 | Total intermediate VAT | A | 16 | |||||
QRC_I7 | Normal VAT base | A | 16 | |||||
QRC_I8 | Total normal VAT | A | 16 | |||||
QRC_J1 | Region VAT rule | A | 16 | |||||
QRC_J2 | Exempted VAT base | A | 16 | |||||
QRC_J3 | Reduced VAT base | A | 16 | |||||
QRC_J4 | Total reduced VAT | A | 16 | |||||
QRC_J5 | Intermediate VAT base | A | 16 | |||||
QRC_J6 | Total intermediate VAT | A | 16 | |||||
QRC_J7 | Normal VAT base | A | 16 | |||||
QRC_J8 | Total normal VAT | A | 16 | |||||
QRC_K1 | Region VAT rule | A | 5 | |||||
QRC_K2 | Exempted VAT base | A | 16 | |||||
QRC_K3 | Reduced VAT base | A | 16 | |||||
QRC_K4 | Total reduced VAT | A | 16 | |||||
QRC_K5 | Intermediate VAT base | A | 16 | |||||
QRC_K6 | Total intermediate VAT | A | 16 | |||||
QRC_K7 | Normal VAT base | A | 16 | |||||
QRC_K8 | Total normal VAT | A | 16 | |||||
QRC_L | Not subject to VAT | A | 16 | |||||
QRC_M | Stamp tax | A | 16 | |||||
QRC_N | Total tax | 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 | QR text | A | 250 | |||||
UPDDATTIM | Date time | ADATIM | ||||||
UPDUSR | User | AUS | [AUS]CODUSR=[PORQRC]UPDUSR | Other |