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     System    
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       Creation Timestamp    
CREATION_TIMESTAMP TIMESTAMP       Creation Date    
LAST_UPDATE_DATE DATE       Last Update Date    
LAST_UPDATE_TIMESTAMP TIMESTAMP       Last Update Timestamp    
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
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    

Copyright © 2019, 2023, Oracle and/or its affiliates.