RA_RECURRING_BILL_PLAN_LINES

This table contains the changes to a recurring bill plan, such as the amount to credit, quantity to credit, override amount, override quantity, and effective date.

Details

• Schema: FUSION

• Object owner: AR

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
RA_RECUR_BILL_PLAN_LINES_PK	RECURRING_BILL_PLAN_LINE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
RECURRING_BILL_PLAN_LINE_ID	NUMBER		18	Yes	Unique identifier of the recurring bill plan line.
RECURRING_BILL_PLAN_ID	NUMBER		18		Unique identifier of the recurring bill plan.
EFFECTIVE_DATE	DATE				Effective date of the changes described in the recurring bill plan line.
FIRST_OVERRIDE_PERIOD_NUM	NUMBER		18		Number that indicates the first period with an override amount. For example, the first invoice is for period 1, the second invoice is for period 2, and others.
FIRST_OVERRIDE_QUANTITY	NUMBER				Override quantity for the period indicated in the first override period.
FIRST_OVERRIDE_AMOUNT	NUMBER				Override amount for the period indicated in the first override period.
SECOND_OVERRIDE_PERIOD_NUM	NUMBER		18		Number that indicates the second period with an override amount. For example, the first invoice is for period 1, the second invoice is for period 2, and others.
SECOND_OVERRIDE_QUANTITY	NUMBER				Override quantity for the period indicated in the second override period.
SECOND_OVERRIDE_AMOUNT	NUMBER				Override amount for the period indicated in the second override period.
THIRD_OVERRIDE_PERIOD_NUM	NUMBER		18		Number that indicates the third period with an override amount. For example, the first invoice is for period 1, the second invoice is for period 2, and others.
THIRD_OVERRIDE_QUANTITY	NUMBER				Override quantity for the period indicated in the third override period.
THIRD_OVERRIDE_AMOUNT	NUMBER				Override amount for the period indicated in the third override period.
FOURTH_OVERRIDE_PERIOD_NUM	NUMBER		18		Number that indicates the fourth period with an override amount. For example, the first invoice is for period 1, the second invoice is for period 2, and others.
FOURTH_OVERRIDE_QUANTITY	NUMBER				Override quantity for the period indicated in the fourth override period.
FOURTH_OVERRIDE_AMOUNT	NUMBER				Override amount for the period indicated in the fourth override period.
FIFTH_OVERRIDE_PERIOD_NUM	NUMBER		18		Number that indicates the fifth period with an override amount. For example, the first invoice is for period 1, the second invoice is for period 2, and others.
FIFTH_OVERRIDE_QUANTITY	NUMBER				Override quantity for the period indicated in the fifth override period.
FIFTH_OVERRIDE_AMOUNT	NUMBER				Override amount for the period indicated in the fifth override period.
AMOUNT_TO_CREDIT	NUMBER				Amount to credit in a full recurring period.
QUANTITY_TO_CREDIT	NUMBER				Quantity to credit in a full recurring period.
UNIT_SELLING_PRICE_REDUCTION	NUMBER				Reduction in the unit selling price for a full recurring period.
CONTRACT_LINE_AMOUNT	NUMBER				Either the original item amount on the contract or the new item amount after any credits on the contract, if the transaction line is associated with a contract.
CONTRACT_LINE_QUANTITY	NUMBER				Either the original item quantity on the contract or the new item quantity after any credits on the contract, if the transaction line is associated with a contract.
CONTRACT_LINE_UNITPRICE	NUMBER				Either the original item unit price on the contract or the new item unit price after any credits on the contract, if the transaction line is associated with a contract.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	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.
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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
RA_RECURRING_BILL_PLAN_LINES	ra_recurring_bill_plans	RECURRING_BILL_PLAN_ID
ra_interface_lines_all	ra_recurring_bill_plan_lines	RECURRING_BILL_PLAN_LINE_ID
ra_customer_trx_lines_all	ra_recurring_bill_plan_lines	RECURRING_BILL_PLAN_LINE_ID

Indexes

Index	Uniqueness	Tablespace	Columns
RA_RECUR_BILL_PLAN_LINES_U1	Unique	Default	RECURRING_BILL_PLAN_LINE_ID