PJB_STD_BILLING_CONTROLS

Details

Schema: FUSION
Object owner: PJB
Object type: TABLE
Tablespace: INTERFACE

Primary Key

Name	Columns
pjb_std_billing_controls_PK	BATCH_ID, INTERFACE_ROW_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
BATCH_ID	NUMBER		18	Yes	Batch Id is unique for a bulk import batch.
INTERFACE_ROW_ID	NUMBER		18	Yes	Unique identifier for each interface row within a batch.
EXT_SOURCE	VARCHAR2	150			Part of a key that uniquely identifies a record. External source from where billing control was created.
EXT_KEY	VARCHAR2	150			Part of a key that uniquely identifies a record. Reference in the external source.
CONTRACT_PUID	VARCHAR2	120			Unique identifier of the contract for which billing controls are created.
LINE_PUID	VARCHAR2	120			Unique identifier of the contract line for which billing controls are created.
IMPORT_STATUS_CODE	VARCHAR2	30			Gives status of a row during import. Possible values are - I(In-process), V(Valid), S(Success), W(Warning), E(Error) and X(Format error).
ACTION_CODE	VARCHAR2	30			Specifies operation for a row. Possible values are NULL, INSERT, UPDATE and DELETE.
INTERNAL_ACTION_CODE	VARCHAR2	30			Internal column and will be set to UPDATE or INSERT for rows with ACTION_CODE=NULL depending on row already exists or not.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
FILE_NAME_SYSTASK_ID	NUMBER		18		Internal column, used by file import to save the individual sys task id for each input csv file.
FILE_RECORD_NUM	NUMBER		18		Internal column, used by file import to save the record number in each input csv file.
BILLING_CONTROL_ID	NUMBER		18		Not user enterable. For Internal usage. Refer to pjb_billing_controls table for functional usage.
MAJOR_VERSION	NUMBER		18		Not user enterable. For Internal usage. Refer to pjb_billing_controls table for functional usage.
CONTRACT_ID	NUMBER		18		Not user enterable. For Internal usage. Refer to pjb_billing_controls table for functional usage.
CONTRACT_LINE_ID	NUMBER		18		Not user enterable. For Internal usage. Refer to pjb_billing_controls table for functional usage.
RBS_ELEMENT_ID	NUMBER		18		Identification of the resource billing element.
RBS_ELEMENT_ALIAS	VARCHAR2	240			Billing Resource Alias which will uniquely identify a resource billing element.
START_DATE	DATE				Start date of the billing control.
END_DATE	DATE				End date of the billing control.
SOFT_LIMIT_AMOUNT	NUMBER				Soft limit amont of billing control.
HARD_LIMIT_AMOUNT	NUMBER				Hard limit amont of billing control.
DEFAULT_FLAG	VARCHAR2	1			Flag to identify the default billing control.
ACTIVE_FLAG	VARCHAR2	1			Flag to identify status of billing control.
INTERNAL_BILL_CTRN_OVN	NUMBER		9		Object Version Number copied from corresponding billing control record. This is used for UPDATE cases to see if record is updated by another user during processing of bulk import and throw error appropriately.
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.
CREATION_DATE	TIMESTAMP				Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64			Who column: indicates the user who created the row.
LAST_UPDATE_DATE	TIMESTAMP				Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64			Who column: indicates the user who last updated 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
PJB_STD_BC_INT_U1	Unique	FUSION_TS_INTERFACE	BATCH_ID, INTERFACE_ROW_ID