This table holds Online Bill Pay specific data for a given Bank Transaction. |
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. |