Table > Module Common Data > Table Credit card transactions

Table SETXN

Table	Abbreviation	Description	Module	Activity code
SETXN	SEX	Credit card transactions	Common Data	SEPP

Key	Description	Duplicates	Activity code
SEX0	TXNDATTIM+REQRSP+TXNID	Yes
SEX1	REF2+TXNDATTIM+REQRSP	Yes

Column	Normal title	Dim.	Type	Length	Menu	Link expression	Cancellation	Act
ACCNAM	Name		NAM
ADDLIG	Address	2	ADL
AMT	Amount		MD1
AUUID	Single identifier		AUUID
AVS	AVS		A	1
AVSCV2RESP	Security check		A	50
BPCNUM	Customer		BPC			[BPC]BPC0=[SEX]BPCNUM	Delete
CRDTYP	Card type		ADI			[ADI]CODE=398;CRDTYP	Block
CREDATTIM	Date time		ADATIM
CREUSR	User		AUS			[AUS]CODUSR=[SEX]CREUSR	Other
CRY	Country		CRY			[TCY]TCY0=[SEX]CRY	Block
CTY	City		CTY
CVV	CVV		A	1
DECLINECODE	Reject code		A	2
EMAIL	Email address		MAI
EXPDAT	Expiration		A	4
GUID	Vault GUID		A	50
PAYDES	Payment description		A	20
PAYPRC	Payment processor		M	4	2098
POSCOD	Postal code		POS
POSTCODERESP	Postal code control		A	20
REF1	Reference 1		A	50
REF2	Reference 2		A	50
REQRSP	Response		M	15	2096
RESP	Resp		A	15
RSPCOD	Response code		A	15
RSPMSG	Response message		A	250
SAT	Region		SAT
SPSECKEY	Security key		A	10
SPTXNID	Transaction		A	38
SPTXNTYP	Transaction type		A	15
TAXAMT	Tax amount		MD1
TXNDAT	Transaction date		D
TXNDATTIM	Txn date time		A	25
TXNID	Transaction		A	50
TXNTYP	Type		ADI			[ADI]CODE=399;TXNTYP	Block
UPDDATTIM	Date time		ADATIM
UPDUSR	User		AUS			[AUS]CODUSR=[SEX]UPDUSR	Other
VANREF	VAN reference		A	20