DW_CXS_SUBSCRIPTION_BILL_LINE_CF

This fact table stores the billing details for the subscription

Details

Module: Subscription Management

Key Columns

BILL_LINE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
BILL_LINE_ID NUMBER 38 0 True Bill Line Identifier
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. System Generated Unique Identifier
BILL_LINE_PUBLIC_UNIQUE_IDENTIFIER VARCHAR2 128 Bill Line Public Unique Identifier
SUBSCRIPTION_ID NUMBER 38 0 Subscription Identifier
SUBSCRIPTION_PRODUCT_ID NUMBER 38 0 Subscription Product Identifier
BILL_CHARGE_NAME VARCHAR2 128 Bill Charge Name
SEQUENCE_NUMBER NUMBER Sequence Number
DATE_TO_INTERFACE DATE Date to Interface
DATE_BILLED_FROM DATE Date Billed From
DATE_BILLED_TO DATE Date Billed To
RECURRING_FLAG VARCHAR2 16 Recurring Flag
COVERED_LEVEL_FLAG VARCHAR2 16 Bill Line associated with a Covered Level
USAGE_FLAG VARCHAR2 16 Usage Flag
INTERFACED_FLAG VARCHAR2 16 Interfaced Flag
TRANSACTION_CLASS_CODE VARCHAR2 32 Transaction Class. Stores values such as Invoice, Credit Memo. DW_AR_TRANSACTION_CLASS_LKP_TL AR_TRANSACTION_CLASS_CODE
TRANSACTION_DATE DATE The Invoice Transaction Date of the Bill Line.
INVOICE_NUMBER VARCHAR2 32 Invoice Number
INVOICE_TEXT VARCHAR2 256 Invoice Text
BILL_CHARGE_PERIOD NUMBER Charge Period
INVOICE_DATE DATE The Planned Invoice Date of the Bill Line
CREATION_DATE DATE Who column: indicates the date of the creation of the row
CREATION_TIMESTAMP TIMESTAMP Who column: indicates the date and time of the creation of the row
LAST_UPDATE_DATE DATE Who column: indicates the date of the update of the row
LAST_UPDATE_TIMESTAMP TIMESTAMP Who column: indicates the date and time of the update of the row
USAGE_CHARGE_TYPE_CODE VARCHAR2 32 Usage Charge Type. Stores values such as True up, Estimated, and Actual. DW_CXS_USAGE_CHARGE_TYPE_D_TL CODE
CHARGE_PUBLIC_UNIQUE_IDENTIFIER VARCHAR2 128 Charge Public Unique Identifier
CHARGE_PRICE_PERIODICITY_CODE VARCHAR2 32 Periodicity. Stores values such as Day, Month, Quarter, Year. DW_UNIT_OF_MEASURE_D_TL UOM_CODE
SUBSCRIPTION_PRIMARY_PARTY_ID NUMBER 38 0 Primary Party of the Subscription DW_PARTY_D PARTY_ID
SUBSCRIPTION_SALES_ACCOUNT_ID NUMBER 38 0 Subscription Sales Account Identifier DW_CXS_SALES_ACCOUNT_D SALES_ACCOUNT_ID
SUBSCRIPTION_BUSINESS_UNIT_ID NUMBER 38 0 Business Unit Identifier of the Subscription DW_BUSINESS_UNIT_D_TL BUSINESS_UNIT_ID
SUBSCRIPTION_COVERAGE_SCHEDULE_ID NUMBER 38 0 Subscription coverage schedule identifier DW_CXSR_COVERAGE_HEADERS_D
SUBS_PRODUCT_START_DATE DATE Subscription Product Start Date
SUBS_PRODUCT_END_DATE DATE Subscription Product End Date
SUBS_PRODUCT_CLOSED_DATE DATE The date on which the subscription is terminated
SUBS_PRODUCT_CANCELED_DATE DATE The date on which the subscription is cancelled
SUBS_PRODUCT_RENEWED_DATE DATE The date on which the product is renewed.
SUBS_PRODUCT_STATUS_CODE VARCHAR2 32 Subscription Product Status. Stores values such as Active, Draft, Expired, Canceled, Pending approval, On Hold, Suspended, Closed, Under amendment. DW_CXS_SUBSCRIPTION_STATUS_D_TL CODE
SUBS_PRODUCT_BILL_TO_PARTY_ID NUMBER 38 0 Subscription Product bill-to party identifier DW_PARTY_D PARTY_ID
SUBS_PRODUCT_BILL_TO_CUSTOMER_ACCOUNT_ID NUMBER 38 0 Subscription Product bill-to account identifier DW_CUSTOMER_ACCOUNT_D CUSTOMER_ACCOUNT_ID
SUBS_PRODUCT_SHIP_TO_PARTY_ID NUMBER 38 0 Subscription Product ship-to party identifier DW_PARTY_D PARTY_ID
SUBS_PRODUCT_SHIP_TO_CUSTOMER_ACCOUNT_ID NUMBER 38 0 Subscription Product ship-to account identifier DW_CUSTOMER_ACCOUNT_D CUSTOMER_ACCOUNT_ID
SUBS_PRODUCT_INVENTORY_ITEM_ID NUMBER 38 0 Inventory Item Identifier DW_SYSTEM_INVENTORY_ITEM_D_TL INVENTORY_ITEM_ID
SUBS_PRODUCT_INVENTORY_ORGANIZATION_ID NUMBER 38 0 Inventory Organization Identifier DW_INTERNAL_ORG_D_TL ORGANIZATION_ID
SUBS_PRODUCT_SALES_PRODUCT_TYPE_CODE VARCHAR2 32 Identifies type of product. Stores values such as Software Maintenance, Subscription, Included Warranty, and Extended Warranty. DW_CXS_SALES_PRODUCT_TYPE_D_TL CODE
SUBS_PRODUCT_CURRENCY_CODE VARCHAR2 16 Subscription Product Currency DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
GLOBAL_CURRENCY_CODE VARCHAR2 16 Global Currency Code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
LIST_PRICE NUMBER List Price
GLOBAL_CURRENCY_LIST_PRICE NUMBER List Price in Global Currency
TRANSACTION_AMOUNT NUMBER Transaction Amount
GLOBAL_CURRENCY_TRANSACTION_AMOUNT NUMBER Transaction Amount in Global Currency
AMOUNT NUMBER Amount
GLOBAL_CURRENCY_AMOUNT NUMBER Amount in Global Currency
USAGE_QUANTITY NUMBER Usage Quantity