VRM_POL_BILLING_EVENTS_GT

Oracle internal use only. This global temporary table is used in import billing data job during internal processing.

Details

• Schema: FUSION

• Object owner: VRM

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Columns

Name	Datatype	Length	Precision	Not-null	Comments
POL_BILLING_EVENT_ID	NUMBER		18	Yes	Billing event unique identifier.
PERF_OBLIGATION_LINE_ID	NUMBER		18		Performance obligation line identifier to which this event belongs.
BILLING_LINE_DETAIL_ID	NUMBER		18		Billing line detail unique identifier pointing to the billing record coming from the billing system.
PERF_OBLIGATION_ID	NUMBER		18		Performance obligation unique identifier.
CUSTOMER_CONTRACT_HEADER_ID	NUMBER		18		Customer contract header unique identifier.
LEDGER_ID	NUMBER		18		Ledger identifier of billing event.
BILL_ACCOUNTING_DATE	DATE				Accounting date on which billed amount is posted in contract revenue clearing account in billing system.
INITIAL_PERF_EVT_ACTUAL_DATE	DATE				Oracle Internal use only.
BILLING_EVENT_STATUS	VARCHAR2	30			Oracle Internal use only.
RECURRING_FLAG	VARCHAR2	1			Indicates whether the line will recur on the line's satisfaction plan end date. Valid values are from the lookup type VRM_YES/NO.
BILLING_LINE_APPLICATION_ID	NUMBER		18		Billing line application internal identifier.
DEVOLVE_PO_FLAG	VARCHAR2	1			Oracle internal use only. Indicates if the performance obligation of this billing event is devolved. A performance obligation is devolved if the Devolve performance obligation option is set to Yes in either the performance obligation identification rule or the implied obligation template that was used during identification of the performance obligations.
ADJUSTMENT_STATUS_CODE	VARCHAR2	30			Contract's eligibility for adjustment by the Residual Account Balance Write Off process. Values are from the lookup type ORA_ADJUSTMENT_STATUS.