Table: dbo.XactPay_Consent
Table containing XactPay consent file information
Columns
NameTypeConstraintsDescription
xactpay_consent_KEYint (4)NOT NULLPrimary key for this table.
client_KEYint (4)NOT NULLThe associated client.
effective_datedatetime (8, 3)NOT NULLPolicy effective date.
transaction_datedatetime (8, 3)NOT NULLTransaction date.
transaction_typenvarchar (100)NOT NULLTransaction type description returned by XactPay.
policy_statusnvarchar (100)NOT NULLPolicy status description returned by XactPay.
download_date_timedatetime (8, 3)NOT NULLDate and time consent file was downloaded.
Primary key
NameColumnsDescription
PK_XactPay_Consentxactpay_consent_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_XactPay_Consent__Client__client_KEYclient_KEYClient (client_KEY)

Schema diagram