RA_RECURRING_BILL_PLANS
Recurring Bill Plan stores the information about recurring bills such as amount per bill, number of bills, and first invoice date.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
RA_RECURRING_BILL_PLANS_PK |
RECURRING_BILL_PLAN_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RECURRING_BILL_PLAN_ID | NUMBER | 18 | Yes | Unique identifier for the recurring bill plan | |
| PERIODICITY_CODE | VARCHAR2 | 30 | Period of the recurring invoice. Valid values are DAY, WEEK, MONTH, QUARTER, YEAR. | ||
| FIRST_INVOICE_DATE | DATE | Transaction date of the first invoice for recurring invoices. | |||
| SECOND_INVOICE_DATE | DATE | Transaction date of the second invoice for recurring invoices, if the first invoice was for a partial period. | |||
| NUMBER_OF_CONTRACTED_PERIODS | NUMBER | 6 | Number of recurring invoices to issue. | ||
| AMOUNT | NUMBER | Recurring transaction line amount for recurring invoices. | |||
| FIRST_OVERRIDE_PERIOD_NUM | NUMBER | 18 | Number indicating the period that has an override amount. For example, the first invoice is for period 1, the second invoice is for period 2, and so on. | ||
| FIRST_OVERRIDE_AMOUNT | NUMBER | The override amount for the period indicated in First Override Period. | |||
| FIRST_OVERRIDE_QUANTITY | NUMBER | Override quantity for the period indicated in the first override period. | |||
| SECOND_OVERRIDE_PERIOD_NUM | NUMBER | 18 | Number indicating the period that has an override amount. For example, the first invoice is for period 1, the second invoice is for period 2, and so on. | ||
| SECOND_OVERRIDE_AMOUNT | NUMBER | The override amount for the period indicated in Second Override Period. | |||
| SECOND_OVERRIDE_QUANTITY | NUMBER | Override quantity for the period indicated in the second override period. | |||
| THIRD_OVERRIDE_PERIOD_NUM | NUMBER | 18 | Number indicating the period that has an override amount. For example, the first invoice is for period 1, the second invoice is for period 2, and so on. | ||
| THIRD_OVERRIDE_AMOUNT | NUMBER | The override amount for the period indicated in Third Override Period. | |||
| THIRD_OVERRIDE_QUANTITY | NUMBER | Override quantity for the period indicated in the third override period. | |||
| FOURTH_OVERRIDE_PERIOD_NUM | NUMBER | 18 | Number indicating the period that has an override amount. For example, the first invoice is for period 1, the second invoice is for period 2, and so on. | ||
| FOURTH_OVERRIDE_AMOUNT | NUMBER | The override amount for the period indicated in Fourth Override Period. | |||
| FOURTH_OVERRIDE_QUANTITY | NUMBER | Override quantity for the period indicated in the fourth override period. | |||
| FIFTH_OVERRIDE_PERIOD_NUM | NUMBER | 18 | Number indicating the period that has an override amount. For example, the first invoice is for period 1, the second invoice is for period 2, and so on. | ||
| FIFTH_OVERRIDE_AMOUNT | NUMBER | The override amount for the period indicated in Fifth Override Period. | |||
| FIFTH_OVERRIDE_QUANTITY | NUMBER | Override quantity for the period indicated in the fifth override period. | |||
| FIRST_BILLING_PERIOD_START_DT | DATE | The start date of the billing period on the first invoice, that is, the contract start date. | |||
| SECOND_BILLING_PERIOD_START_DT | DATE | The start date of the billing period on the second invoice, if the first invoice did not cover a full billing period. | |||
| CANCELED_FLAG | VARCHAR2 | 1 | Indicator of a canceled recurring bill plan. Valid values are Y, N, and null. Null is the same as N. | ||
| 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. | ||
| 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. | |
| 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. |
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_plans | RECURRING_BILL_PLAN_ID |
| ra_customer_trx_lines_all | ra_recurring_bill_plans | RECURRING_BILL_PLAN_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| RA_RECURRING_BILL_PLANS_U1 | Unique | Default | RECURRING_BILL_PLAN_ID |