This fact table stores the billing details for the subscription
Module: Subscription Management
BILL_LINE_ID
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 | |
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, 2024, Oracle and/or its affiliates.