Table > Module Common Data > Table Portuguese QR-data

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