Table: dbo.XactPay_Consent
Table containing XactPay consent file information
Columns
Name | Type | Constraints | Description
xactpay_consent_KEY | int (4) | NOT NULL | Primary key for this table.
client_KEY | int (4) | NOT NULL | The associated client.
effective_date | datetime (8, 3) | NOT NULL | Policy effective date.
transaction_date | datetime (8, 3) | NOT NULL | Transaction date.
transaction_type | nvarchar (100) | NOT NULL | Transaction type description returned by XactPay.
policy_status | nvarchar (100) | NOT NULL | Policy status description returned by XactPay.
download_date_time | datetime (8, 3) | NOT NULL | Date and time consent file was downloaded.

Primary key
Name | Columns | Description
PK_XactPay_Consent | xactpay_consent_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_XactPay_Consent__Client__client_KEY | client_KEY | Client (client_KEY) |