OKC_BILL_LINES_INT

Interface table for okc_bill_lines_int

Details

• Schema: FUSION

• Object owner: OKC

• Object type: TABLE

• Tablespace: INTERFACE

Primary Key

Name	Columns
OKC_BILL_LINES_INT_PK	BATCH_ID, INTERFACE_ROW_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
BATCH_ID	NUMBER		18	Yes	BATCH_ID
INTERFACE_ROW_ID	NUMBER		18	Yes	INTERFACE_ROW_ID
IMPORT_STATUS_CODE	VARCHAR2	30			IMPORT_STATUS_CODE
FILE_RECORD_NUM	NUMBER		18		FILE_RECORD_NUM
ACTION_CODE	VARCHAR2	30			ACTION_CODE
INTERNAL_ACTION_CODE	VARCHAR2	30			INTERNAL_ACTION_CODE
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
FUSION_BILL_LINES_ID	NUMBER		18		FUSION_BILL_LINES_ID
MAJOR_VERSION	NUMBER		18		MAJOR_VERSION
EXT_SOURCE	VARCHAR2	120			EXT_SOURCE
EXT_KEY	VARCHAR2	120			EXT_KEY
DNZ_CHR_ID	NUMBER		18		DNZ_CHR_ID
CLE_ID	NUMBER		18		CLE_ID
KCA_ID	NUMBER		18		KCA_ID
HDR_EXT_SOURCE	VARCHAR2	120			HDR_EXT_SOURCE
HDR_EXT_KEY	VARCHAR2	120			HDR_EXT_KEY
LINE_EXT_SOURCE	VARCHAR2	120			LINE_EXT_SOURCE
LINE_EXT_KEY	VARCHAR2	120			LINE_EXT_KEY
COVERED_ASSET_EXT_SOURCE	VARCHAR2	120			COVERED_ASSET_EXT_SOURCE
COVERED_ASSET_EXT_KEY	VARCHAR2	120			COVERED_ASSET_EXT_KEY
DATE_TO_INTERFACE	DATE				DATE_TO_INTERFACE
DATE_BILLED_FROM	DATE				DATE_BILLED_FROM
DATE_BILLED_TO	DATE				DATE_BILLED_TO
AMOUNT	NUMBER				AMOUNT
RECURRING_FLAG	VARCHAR2	1			RECURRING_FLAG
SENT_YN	VARCHAR2	1			SENT_YN
TRX_CLASS	VARCHAR2	30			TRX_CLASS
TRX_CLASS_NAME	VARCHAR2	80			Transaction class name
TRX_DATE	DATE				TRX_DATE
TRX_NUMBER	VARCHAR2	30			TRX_NUMBER
TRX_TAX	NUMBER				TRX_TAX
TRX_AMOUNT	NUMBER				TRX_AMOUNT
SEQUENCE_NUMBER	NUMBER				SEQUENCE_NUMBER
CREATED_BY	VARCHAR2	64			Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP				Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64			Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP				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.
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.
FILE_NAME_SYSTASK_ID	NUMBER		18		FILE_NAME_SYSTASK_ID
INTERNAL_BILL_LINES_OVN	NUMBER		9		INTERNAL_BILL_LINES_OVN
DATA_LANG	VARCHAR2	4			Language for name columns
INTERNAL_HEADER_STATUS	VARCHAR2	30			The final status of the contract header.
USAGE_CAPTURE_DATE	DATE				Usgae Capture for Bill Lines
USAGE_PRICED_YN	VARCHAR2	1			Usgae Price for Bill Lines
CHARGE_DEFINITION_CODE	VARCHAR2	30			Charge Defination code for Bill Lines
USAGE_YN	VARCHAR2	1			Usage required by bill lines
USAGE_CAPTURED_YN	VARCHAR2	1			Usage Captureed allowed or not for Bill Lines
AMOUNT_WITHOUT_TA	NUMBER				Amount with tax for Bill Lines
CHARGE_PERIOD	NUMBER				Charge Period for Bill Lines
USAGE_QUANTITY	NUMBER				Usage quantity for Bill Lines
CHARGE_DEFINITION	VARCHAR2	80			Charge Defination for Bill Lines

Indexes

Index	Uniqueness	Tablespace	Columns
OKC_BILL_LINES_INT_N1	Non Unique	FUSION_TS_INTERFACE	BATCH_ID, INTERNAL_ACTION_CODE, IMPORT_STATUS_CODE
OKC_BILL_LINES_INT_N2	Non Unique	FUSION_TS_INTERFACE	BATCH_ID, EXT_SOURCE, EXT_KEY
OKC_BILL_LINES_INT_N3	Non Unique	Default	BATCH_ID, IMPORT_STATUS_CODE, TRX_CLASS, SENT_YN, KCA_ID
OKC_BILL_LINES_INT_U1	Unique	FUSION_TS_INTERFACE	BATCH_ID, INTERFACE_ROW_ID