OSS_AR_FETCH

Details

Schema: FUSION
Object owner: OSS
Object type: TABLE
Tablespace: DEFAULT

Primary Key

Name	Columns
OSS_AR_FETCH_STAGING_PK	STAGE_ROW_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
STAGE_ROW_ID	NUMBER		18	Yes	Primary key of the table.
BILL_LINE_ID	NUMBER		18		Reference Bill Line for Event.
SUBSCRIPTION_ID	NUMBER		18		Subscription identifier in Subscription Management.
SUBSCRIPTION_PRODUCT_ID	NUMBER		18		Subscription product identifier in Subscription Management.
PRODUCT_ASSOCIATION_ID	NUMBER		18		Foreign key to product association.
TRX_CLASS	VARCHAR2	30			Transaction class.
CHARGE_ID	NUMBER		18		Foreign key to Charges.
CHARGE_NAME	VARCHAR2	120			Identifies the name of the charge.
SEQUENCE_NUMBER	NUMBER				Sequence Number.
CHARGE_PERIOD	NUMBER				Identifies Charge Period.
TRX_DATE	DATE				Date of Transaction.
TRX_NUMBER	VARCHAR2	30			Transaction Number.
TRX_TAX	NUMBER				Transaction Tax.
CUSTOMER_TRX_LINE_ID	NUMBER		18		Line identifier of customer transaction.
CUSTOMER_TRX_ID	NUMBER		18		Foreign Key to customer transaction id.
INCOMPLETE_INVOICE_FLAG	VARCHAR2	1			Flag to identify incomplete invoice.
BILL_LINE_TYPE	VARCHAR2	100			Identifies type of bill line.
SUMMARIZED_BILL_LINE_ID	NUMBER		18		Identifies summarized bill line.
TAX_AMOUNT	NUMBER				Tax amount.
BATCH_ID	NUMBER		18		Id of the processing batch.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	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.

Indexes

Index	Uniqueness	Tablespace	Columns
OSS_AR_FETCH_STAGING_PK	Unique	Default	STAGE_ROW_ID