Inclusive Usage Allocations Interface Table

This extract file interface handles the details of the inclusive usageClosed The consumption of services, for example a subscriber using call minutes. allocations utilised by usage items associated with the invoices in the current extract set.

It is possible for usage items to be discounted by inclusive usage schemes (bundles). This extract file contains a record for each inclusive usage allocation utilised by usage items in the current extract data set

Data loaded via this interface is primarily bound for the INC_USAGE_INVOICE_SUMMARY and INC_USAGE_ALLOCATION_SNAPSHOT CXPClosed Customer Experience Platform, or CXP, is MDS Global's self-service app that allows business customers to manage their own accounts and subscriptions. Admin schema tables.

External table name

Schema

Mapped file

inc_usage_alloc_Interface

Staging

inc_usage_alloc.dat

 

Inclusive usage allocations interface table fields

Column Heading

Type

Length

Description

EXTERNAL_ INC_USAGE_ALLOC_ID

VarChar2

40

Unique inclusive usage allocation discount scheme identifier as used by the originating CRM data base.
EXTERNAL_ORGANISATION_UNIT_ID VarChar2 40 Unique identifier denoting the CRM name for the organisation unit that owns the current inclusive usage allocation.
ORGANISATION_UNIT_LEVEL Integer   The level within the organisation unit hierarchy, at which the current organisation unit resides.
INC_USAGE_ALLOC_NAME VarChar2 40 A name for the inclusive usage scheme in use on the current record. This value can be used to hold a CRM specific code for the scheme.
INC_USAGE_ALLOC_DESCRIPTION VarChar2 100 A user friendly description for the inclusive usage scheme in use on the current record.
QUANTITY_BROUGHT_FORWARD NUMBER(14,4)   The number of allocation units carried into the current allocation from previous allocations.
QUANTITY_ALLOCATED

NUMBER(14,4)

   The total number of units available to the current discount allocation when it was first created.
QUANTITY_USED

NUMBER(14,4)

   The number of allocation units used up at the time of billing.
QUANTITY_UNUSED

NUMBER(14,4)

   The number of allocation units remaining.
QUANTITY_CARRIED_FORWARD

NUMBER(14,4)

   The number of allocation units that will be carried over to future allocations.
UNIT_OF_MEASURE VarChar2 40 The unit of measure that qualifies the various quantities used on the current allocation record.
UNIT_OF_MEASURE_CATEGORY VarChar2 40 The categorisation for the unit of measure used on the current record. It allows records to be grouped together for reporting purposes. For example, inclusion of all charges that have a particular unit of measure category. Note: The unit of measure and unit of measure category combination given must be one of the valid combinations configured within the CXP database. Note: It is possible for any particular unit of measure value to be used in conjunction with different unit of measure categories (it is not a one to one relationship). The category supplied acts to place a record in that category for reporting and analysis.
ATTRIBUTE_1 VarChar2 100 Customisable inclusive usage allocation data element. This field is usually used to hold a value specific to the original CRM data base's billing profile, which is not otherwise directly supported by CXP.
ATTRIBUTE_2 VarChar2 100 Customisable inclusive usage allocation data element. This field is usually used to hold a value specific to the original CRM data base's billing profile, which is not otherwise directly supported by CXP.
ATTRIBUTE_3 VarChar2 100 Customisable inclusive usage allocation data element. This field is usually used to hold a value specific to the original CRM data base's billing profile, which is not otherwise directly supported by CXP.