Table: dbo.Online_Bill_Pay_Bank_Transaction
This table holds Online Bill Pay specific data for a given Bank Transaction.
Columns
NameTypeConstraintsDescription
bank_transaction_KEYint (4)NOT NULLThe primary key for this table.
online_bill_pay_transmission_status_KEYint (4)NOT NULLThe current transmission status for this record.
intercept_transaction_received_datesmalldatetime (4)This value is sent to us from Intercept. It is the date they received the payment.
intercept_payment_keyint (4)This is the key value generated by Intercept for this payment. This value will only be non-null where we have received a transmission confirmation from Intercept, giving us a status of Pending or Successful, otherwise this will be null. This is not used by the app which uses the bank transactions GUID returned by Intercept. This is stored solely for troubleshooting or possible future use.
transaction_transmitted_datedatetime (8, 3)This is the date time stamp from when this transaction was transmitted to Intercept from the transmitters location. This will be null if we have not yet attempted to transmit to Intercept, a status of Not Transmitted. Any other status will have a date time stamp marking when we attempted to transmit.
intercept_transaction_error_codeint (4)This holds an error code returned by Intercept for any transmitted payments that were rejected by Intercept. This is only valid for Online Bill Payment Bank Transactions with an Online Bill Payment Transmission status of Failed
intercept_transaction_error_descriptionnvarchar (256)NOT NULLThis holds the description for and error code returned by Intercept for any transmitted payments that were rejected by Intercept. This is only valid for Online Bill Payment Bank Transactions with an Online Bill Payment Transmission status of Failed
intercept_assigned_check_referencenvarchar (40)NOT NULLThe Intercept assigned check reference for this transaction. This will only have a value if Intercept has printed a check for this transaction.
Primary key
NameColumnsDescription
PK_Online_Bill_Pay_Bank_Transaction$bank_transaction_KEYbank_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Online_Bill_Pay_Bank_Transaction__Online_Bill_Pay_Transmission_Status__online_bill_pay_transmission_status_KEYonline_bill_pay_transmission_status_KEYOnline_Bill_Pay_Transmission_Status (online_bill_pay_transmission_status_KEY)
FK_Online_Bill_Pay_Bank_Transaction__Vendor_Bank_Transaction__bank_transaction_KEYbank_transaction_KEYVendor_Bank_Transaction (bank_transaction_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Transmit_Online_Bill_Pay_Selection__Online_Bill_Pay_Bank_Transaction__bank_transaction_KEYbank_transaction_KEYTransmit_Online_Bill_Pay_Selection

Schema diagram