1. Tables and Views for SCM
  2. DOO_ORDER_BILLING_PLANS_INT

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