PSC_BNP_BANK_RECON_TRANSACTION
Store payments and refunds that have to be reconciled with a bank statement.
Details
-
Schema: FUSION
-
Object owner: PSC_CC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
psc_bnp_bank_recon_transac_PK |
RECON_HISTORY_KEY |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RECON_HISTORY_KEY | NUMBER | 18 | Yes | Unique identifier for each record. | |
| AGENCY_ID | NUMBER | 8 | Yes | Unique identifier of the agency. | |
| RECONCILIATION_SYSTEM | VARCHAR2 | 30 | Yes | Bank reconciliation system that will reconcile the payment transaction with bank statement. | |
| BANK_ACCOUNT_NAME | VARCHAR2 | 360 | Bank account associated with deposit of receipts or issue of refunds. | ||
| BUSINESS_UNIT_NAME | VARCHAR2 | 360 | Business unit associated to the bank account. | ||
| ACCOUNTING_FLAG | VARCHAR2 | 1 | Yes | Indicates whether accounting transaction should be created in bank reconciliation system. | |
| TRANSACTION_CATEGORY | VARCHAR2 | 30 | Yes | Indicates whether the transaction is a payment or refund. | |
| PAYMENT_METHOD_CODE | VARCHAR2 | 30 | Yes | Identifies the mode of payment. | |
| PAYMENT_REFERENCE_ID | VARCHAR2 | 50 | Unique identifier associated with a payment or refund. | ||
| PAYMENT_TRANSACTION_ID | VARCHAR2 | 50 | Transaction identifier associated with a payment or refund. | ||
| AUTHORIZATION_CODE | VARCHAR2 | 10 | Authorization code value returned by the payment gateway. | ||
| AUTHORIZATION_DTTM | TIMESTAMP | Date and time when the payment was authorized by payment gateway. | |||
| REFUND_TYPE | VARCHAR2 | 10 | Indicates whether a refund transaction is a chargeback or refund. | ||
| REFUND_METHOD_CODE | VARCHAR2 | 30 | Identifies the mode of refund. | ||
| REFUND_REFERENCE_ID | VARCHAR2 | 50 | Unique identifier associated with a refund. | ||
| REFUND_TRANSACTION_ID | VARCHAR2 | 50 | Transaction ID received from the payment gateway. | ||
| REFUND_REQUEST_CODE | VARCHAR2 | 50 | Refund code or reference value returned by the payment gateway. | ||
| REFUND_DTTM | TIMESTAMP | Date and time when the refund was processed. | |||
| DEPOSIT_SLIP_NUMBER | VARCHAR2 | 50 | Unique identifier associated with deposit of cash and checks. | ||
| RECEIPT_NUMBER | VARCHAR2 | 50 | Unique identifier associated with receipt of cash and checks. | ||
| RECEIPT_LINE_NUMBER | NUMBER | 3 | Line number associated with receipt of cash and checks. | ||
| DRAWER_ID | VARCHAR2 | 30 | Cash drawer identifier associated with receipt of cash and checks. | ||
| SESSION_ID | VARCHAR2 | 50 | Cashier session identifier associated with receipt of cash and checks. | ||
| CASHIER_ID | VARCHAR2 | 50 | Cashier identifier associated with receipt of cash and checks. | ||
| CHECK_NUMBER | VARCHAR2 | 10 | Check number recorded for a check transaction. | ||
| CHECK_DATE | DATE | Check date recorded for a check transaction. | |||
| PAYMENT_DATE | DATE | Date on which the transaction was recorded for a payment. | |||
| AMOUNT | NUMBER | Yes | Amount of the payment or refund. | ||
| CURRENCY_CODE | VARCHAR2 | 3 | Yes | Currency code of the transaction recorded for a payment or refund. | |
| DEPOSIT_ACCOUNT_NUMBER | VARCHAR2 | 30 | Unique account number associated with a deposit account. | ||
| SOURCE_TRANSACTION_KEY | NUMBER | 18 | payment history key or refund history key. | ||
| PUBLISHED_STATUS | VARCHAR2 | 30 | Yes | Indicates the publish status of the transaction. | |
| EXTERNAL_TRANSACTION_ID | NUMBER | 18 | The unique identifier of the external transaction. | ||
| MANUAL_RECON_STATUS | VARCHAR2 | 30 | Status of the bank reconciliation transaction when the transaction is reconciled manually. | ||
| MANUAL_RECON_DATETIME | TIMESTAMP | Date the bank reconciliation transaction was reconciled when the transaction is reconciled manually. | |||
| MANAUAL_RECON_BY | VARCHAR2 | 64 | User id of the agency staff who manually reconciled the transaction. | ||
| MANUAL_RECON_BY_NAME | VARCHAR2 | 240 | User name of the agency staff who manually reconciled the transaction. | ||
| DESCRIPTION | VARCHAR2 | 360 | Free form text for the bank reconciliation transaction. | ||
| REVERSAL_FLAG | VARCHAR2 | 1 | Yes | Indicates a check return. | |
| ASSET_CCID | NUMBER | 18 | The cash general ledger account code combination of the external transaction. | ||
| OFFSET_CCID | NUMBER | 18 | The offset general ledger account code combination of the external transaction. | ||
| TRANSACTION_TYPE | VARCHAR2 | 30 | Transaction type that should be passed to fusion cash management. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| psc_bnp_bank_recon_trans_N1 | Non Unique | Default | PAYMENT_REFERENCE_ID |
| psc_bnp_bank_recon_trans_N2 | Non Unique | Default | REFUND_REFERENCE_ID |
| psc_bnp_bank_recon_trans_PK | Unique | Default | RECON_HISTORY_KEY |