PSC_BNP_CASH_RECON_ACCTG
This table contains accounting infomation for cash reconciliation. It is used to save the accounting rows for cash shortage, cash overage, check shortage and check overage when user reconciles balances for a cash drawer
Details
-
Schema: FUSION
-
Object owner: PSC_CC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PSC_BNP_CASH_RECON_ACCTG_PK |
TRANSACTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRANSACTION_ID | NUMBER | 18 | Yes | Attribute identifying the transaction id of cash reconcile accounting. | |
| AGENCY_ID | NUMBER | 8 | Yes | Attribute identifying the agency associated with the row. | |
| RECONCILE_ID | NUMBER | 18 | Yes | Attribute identifying the reconcile id with the row. | |
| RECONCILE_DATE | DATE | Attribute identifying the reconcile date with the row. | |||
| TRANSACTION_TYPE | VARCHAR2 | 30 | Yes | Attribute identifying the transaction type of cash draw reconcile. | |
| TRANSACTION_AMOUNT | NUMBER | Yes | Attribute identifying the transaction amount of cash draw reconcile. | ||
| CURRENCY_CODE | VARCHAR2 | 3 | Yes | Attribute identifying the transaction currency code. | |
| ACCOUNTING_DATE | DATE | Attribute identifying the transaction accounting date. | |||
| EVENT_ID | NUMBER | 18 | Attribute identifying the event id of cash reconcile accounting. | ||
| ACCTG_EVENT_STATUS | VARCHAR2 | 30 | Yes | Attribute identifying the accounting event status. | |
| 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_CASH_RECON_ACCTG_U1 | Unique | Default | TRANSACTION_ID |