PSC_BNP_REFUND_HIST

Details

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

Primary Key

Name	Columns
PSC_BNP_REFUND_HIST_LIN_PK	REFUND_HISTORY_KEY, REFUND_RECORD_KEY

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
REFUND_HISTORY_KEY	NUMBER		18	Yes	Parent history key.	Active
REFUND_RECORD_KEY	NUMBER		8	Yes	Auto-sequencing generated value for unique identification of each line row.	Active
AGENCY_ID	NUMBER		8	Yes	Attribute identifying the agency associated with the row.
ITEM_NAME	VARCHAR2	30			Item name used for the original payment for this item.	Active
ITEM_LINE	NUMBER		8	Yes	Item line used for the original payment for this item.	Active
ITEM_DESCRIPTION	VARCHAR2	100			Item description used for the original payment for this item.
ITEM_PAYMENT_AMOUNT	NUMBER				Payment amount from the original payment transaction for this item.	Active
ITEM_PAYMENT_CURRENCY	VARCHAR2	3			Currency code used from the original payment transaction for this item.	Active
ITEM_REFUND_AMOUNT	NUMBER			Yes	Refund amount.
ITEM_REFUND_CURRENCY	VARCHAR2	3		Yes	Refund currency.
ITEM_REFUND_REFERENCE1	VARCHAR2	50			Attribute identifying item level reference value provided by the refund source application.
ITEM_REFUND_REFERENCE2	VARCHAR2	50			Additional attribute identifying item level reference value provided by the refund source application.
CLASSIFICATION	VARCHAR2	3			Source application that generated the fee.
RECORD_ID	VARCHAR2	50			Source application's record id identifier.
RECORD_TYPE_ID	VARCHAR2	30			Source application's record type identifier.
FAR_RECEIPT_STATUS	VARCHAR2	30			Column contains status that drives the creation of receipts in oracle receivables.
FAR_CASH_RECEIPT_ID	NUMBER		18		Column contains cash receipt id from oracle receivables system.
ACCOUNTING_DATE	DATE				Accounting date for the payment transaction
EVENT_ID	NUMBER		18		Event id for the payment transaction
ACCTG_EVENT_STATUS	VARCHAR2	30		Yes	Accounting event status for the payment
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_REFUND_HIST_LIN	psc_bnp_refund_hist_hdr	REFUND_HISTORY_KEY

Indexes

Index	Uniqueness	Tablespace	Columns
PSC_BNP_REFUND_HIST_LIN_PK	Unique	Default	REFUND_HISTORY_KEY, REFUND_RECORD_KEY