PSC_BNP_CSH_DRW

Details

Schema: FUSION
Object owner: PSC_CC
Object type: TABLE
Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
PSC_BNP_CSH_DRW_RECON_PK	RECONCILE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
RECONCILE_ID	NUMBER		18	Yes	Unique identifier for the transaction.	Active
DRAWER_ID	VARCHAR2	30		Yes	Attribute identifying the cash drawer.	Active
SESSION_ID	VARCHAR2	50		Yes	Attribute identifying the cashier session.
AGENCY_ID	NUMBER		8	Yes	Attribute identifying the agency associated with the row.	Active
CURRENCY_CODE	VARCHAR2	3			Currency code used for the amounts in this row.	Active
RECONCILE_STATUS	VARCHAR2	30		Yes	Reconciliation status, Reconciled or Unreconciled.	Active
BEGINNING_BALANCE	NUMBER			Yes	Cashier Session beginning balance.	Active
TOTAL_COLLECTION	NUMBER			Yes	Payment amount total collection for this session.	Active
TOTAL_DISBURSEMENT	NUMBER			Yes	Total cash change disbursed for this session.	Active
CASH_EXPECTED	NUMBER			Yes	Cash amount expected for this session.	Active
PERSONAL_CHECK_EXPECTED	NUMBER		30	Yes	Personal check amount expected for this session.
CASHIER_CHECK_EXPECTED	NUMBER		30	Yes	Cashier check amount expected for this session.
ACTUAL_CASH	NUMBER			Yes	Actual cash amount for this session.	Active
ACTUAL_PERSONAL_CHECK	NUMBER			Yes	Actual personal check amount for this session.
ACTUAL_CASHIER_CHECK	NUMBER			Yes	Actual cashier check amount for this session.
DISCREPANCY_AMOUNT	NUMBER			Yes	Discrepancy amount (beginning balance + expected – actual)	Active
COMMENTS	VARCHAR2	240			Comments or additional information for this session.
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.	Active
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active

Foreign Keys

Table	Foreign Table	Foreign Key Column
PSC_BNP_CSH_DRW_RECON	psc_bnp_cash_drawer_b	AGENCY_ID, DRAWER_ID
PSC_BNP_CSH_DRW_RECON	psc_bnp_csh_drw_sess	SESSION_ID

Indexes

Index	Uniqueness	Tablespace	Columns	Status
PSC_BNP_CSH_DRW_RECON_N1	Non Unique	Default	AGENCY_ID, DRAWER_ID
PSC_BNP_CSH_DRW_RECON_U1	Unique	Default	RECONCILE_ID	Active