Dictionary >  Module Common Data >  Table Credit card transactions  

Display all Hide all

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