DOO_ORDER_BILLING_PLANS_INT
Billing Plan stores the information related to various Billing Types such as Periodic or Milestone. Details stored include number of bills, billing transaction date, override periods and remaining billing amount per period.
Details
-
Schema: FUSION
-
Object owner: DOO
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
SOURCE_TRANSACTION_ID | VARCHAR2 | 50 | Unique identifier of the transaction in the system that captured the transaction. | ||
SOURCE_TRANSACTION_SYSTEM | VARCHAR2 | 30 | System or application that submitted the order request. | ||
SOURCE_TRANSACTION_LINE_ID | VARCHAR2 | 50 | Unique identifier of the transaction line from the system that captured the transaction. | ||
SOURCE_TRANSACTION_SCHEDULE_ID | VARCHAR2 | 50 | Unique identifier of a schedule, shipment, or subline, as assigned by the system that captured the transaction. | ||
BILLING_PLAN_TYPE_CODE | VARCHAR2 | 30 | Type of billing plan for example, PERIODIC or MILESTONE. | ||
PERIODICITY_CODE | VARCHAR2 | 30 | Code used to signify the period of the recurring invoice. Valid values are DAY, WEEK, MONTH, QUARTER, YEAR. | ||
NUMBER_OF_BILLING_PERIODS | NUMBER | 9 | Number of recurring invoices to issue. | ||
BILLING_PERIOD_START_DATE | DATE | The start date of the billing period corresponding to the billing period number. This date may be the contract start date for the first billing period or it may refer to the billing start date of the subsequent billing period if the previous invoice did not cover a full billing period. | |||
BILLING_PERIOD_END_DATE | DATE | The end date of the billing period corresponding to the billing period number. This date may be the contract end date for the first billing period or it may refer to the billing end date of the subsequent billing period if the previous invoice did not cover a full billing period. | |||
BILLING_TRANSACTION_DATE | DATE | Transaction date of the first invoice for recurring invoices or it may also refer to the Transaction date of the subsequent invoice for recurring invoices, if the previous invoice was for a partial period. | |||
BILLING_PERIOD_NUMBER | NUMBER | 9 | The period number corresponding to the Billing Start Date, End Date, or Transaction Date. | ||
OVERRIDE_PERIOD | NUMBER | 9 | 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. | ||
OVERRIDE_PERIOD_QUANTITY | NUMBER | The override quantity for the period indicated in the override period. | |||
OVERRIDE_PERIOD_AMOUNT | NUMBER | The override amount for the period indicated in the override period. | |||
CANCELLATION_EFFECTIVE_DATE | DATE | Effective date that the recurring billing should stop and no future billing should occur. | |||
SOURCE_BILLING_PLAN_ID | VARCHAR2 | 50 | Unique identifier for the billing plan in the application that created the transaction. | ||
LOAD_REQUEST_ID | NUMBER | 18 | Identifier of the process that populates the interface table. | ||
CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||
LAST_UPDATED_BY | VARCHAR2 | 64 | 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. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
DOO_ORDER_BILLING_PLANS_INT_N1 | Non Unique | Default | SOURCE_TRANSACTION_ID, SOURCE_TRANSACTION_SYSTEM, LOAD_REQUEST_ID, SOURCE_TRANSACTION_LINE_ID, SOURCE_TRANSACTION_SCHEDULE_ID |