Table: dbo.Online_Bill_Pay_Bank_Transaction
This table holds Online Bill Pay specific data for a given Bank Transaction.
Columns
Name | Type | Constraints | Description
bank_transaction_KEY | int (4) | NOT NULL | The primary key for this table.
online_bill_pay_transmission_status_KEY | int (4) | NOT NULL | The current transmission status for this record.
intercept_transaction_received_date | smalldatetime (4) |  | This value is sent to us from Intercept. It is the date they received the payment.
intercept_payment_key | int (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_date | datetime (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_code | int (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_description | nvarchar (256) | NOT NULL | This 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_reference | nvarchar (40) | NOT NULL | The Intercept assigned check reference for this transaction. This will only have a value if Intercept has printed a check for this transaction.

Primary key
Name | Columns | Description
PK_Online_Bill_Pay_Bank_Transaction$bank_transaction_KEY | bank_transaction_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Online_Bill_Pay_Bank_Transaction__Online_Bill_Pay_Transmission_Status__online_bill_pay_transmission_status_KEY | online_bill_pay_transmission_status_KEY | Online_Bill_Pay_Transmission_Status (online_bill_pay_transmission_status_KEY) |
FK_Online_Bill_Pay_Bank_Transaction__Vendor_Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Vendor_Bank_Transaction (bank_transaction_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Transmit_Online_Bill_Pay_Selection__Online_Bill_Pay_Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Transmit_Online_Bill_Pay_Selection |