Table: dbo.XactPay_Client_EIN_History
Table containing the EIN history for XactPay clients
Columns
NameTypeConstraintsDescription
xactpay_client_ein_history_KEYint (4)NOT NULLPrimary key for this table.
client_KEYint (4)NOT NULLThe associated client.
modified_datedatetime (8, 3)NOT NULLThe date the EIN was changed.
previous_EINnvarchar (22)NOT NULLThe previous EIN value before the change.
transmittedbit (1)NOT NULLWhether or not this change has been transmitted to XactPay
Primary key
NameColumnsDescription
PK_XactPay_Client_EIN_Historyxactpay_client_ein_history_KEY
Unique constraints
NameColumnsDescription
UK_XactPay_Client_EIN_History$client_KEY$modified_date$previous_EINclient_KEY, modified_date, previous_EIN
Foreign keys
NameColumnsReferenced tableDescription
FK_XactPay_Client_EIN_History__Client__client_KEYclient_KEYClient (client_KEY)

Schema diagram