PSC_BNP_BILL

Details

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

Primary Key

Name	Columns
PSC_BNP_BILL_LINE_PK	AGENCY_ID, INVOICE, INVOICE_LINE, BILL_TYPE

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
INVOICE	VARCHAR2	50		Yes	Attribute used to store the invoice number for the associated bill header.	Active
INVOICE_LINE	NUMBER		18	Yes	Attribute used to store the invoice line number	Active
DESCRIPTION	VARCHAR2	100		Yes	Attibute used to describe the fee passed from source application or description of the fee (service charge) passed from Payment
AGENCY_ID	NUMBER		8	Yes	Attribute identifying the agency associated with the row.	Active
ORIGINAL_INVOICE	VARCHAR2	50			Attribute used to track adjustments to the invoice	Active
ORIGINAL_LINE	NUMBER		18		Attribute used to track adjustments to the invoice line	Active
NEXT_ADJ_INVOICE	VARCHAR2	50			Attribute used to track adjustments to the invoice	Active
NEXT_ADJ_LINE	NUMBER		3		Attribute used to track adjustments to the invoice line	Active
PRIOR_ADJ_INVOICE	VARCHAR2	50			Attribute used to track adjustments to the invoice	Active
PRIOR_ADJ_LINE	NUMBER		3		Attribute used to track adjustments to the invoice line	Active
LATEST_INVOICE	VARCHAR2	50			Attribute used to track adjustments to the invoice	Active
LATEST_LINE	NUMBER		3		Attribute used to track adjustments to the invoice line	Active
CURRENCY_CODE	VARCHAR2	3			Attribute used to indicate the currency used for this transaction. Passed from source application.	Active
QUANTITY	NUMBER				Attribute used to store the unit quantity	Active
PRICE	NUMBER				Attribute used to store the fee amount or unit price	Active
INVOICE_LINE_AMOUNT	NUMBER				Attribute used to store the (quantity x price) + discount - surcharge	Active
DISCOUNT_AMOUNT	NUMBER				Attribute used to reduce the amount paid. Passed from source application.	Active
SURCHARGE_AMOUNT	NUMBER				Attribute used to increase the amount paid. Passed from source application.	Active
APPLICATION_REFERENCE_ID1	VARCHAR2	50			Identifying information/key from the application source.
APPLICATION_REFERENCE_ID2	VARCHAR2	50			Additional identifying information/key from the source application.
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
BILL_TYPE	VARCHAR2	15		Yes	BILL_TYPE
FEE_ITEM_ID	VARCHAR2	30			FEE_ITEM_ID
DEPARTMENT_ID	VARCHAR2	30			DEPARTMENT_ID
RECORD_ID	VARCHAR2	50			RECORD_ID
CUSTOMER_TRX_LINE_ID	NUMBER		18		CUSTOMER_TRX_LINE_ID
ISSUE_DATE	TIMESTAMP				ISSUE_DATE
EXPIRATION_DATE	TIMESTAMP				EXPIRATION_DATE
RENEWAL_DATE	TIMESTAMP				RENEWAL_DATE
CLASSIFICATION	VARCHAR2	3			CLASSIFICATION
RECORD_TYPE	VARCHAR2	50			RECORD_TYPE
MEMO_LINE_ID	NUMBER		18		Indicates Memo Line identifier on an invoice line in Fusion Receivables

Foreign Keys

Table	Foreign Table	Foreign Key Column
PSC_BNP_BILL_LINE	psc_bnp_bill_header	AGENCY_ID, INVOICE, BILL_TYPE

Indexes

Index	Uniqueness	Tablespace	Columns	Status
PSC_BNP_BILL_LINE_PK	Unique	Default	AGENCY_ID, INVOICE, INVOICE_LINE, BILL_TYPE	Active