Inclusive Usage Units Interface Table

This extract file interface handles the inclusive usageClosed The consumption of services, for example a subscriber using call minutes. unit records that indicate how many inclusive usage allocation units have been consumed by usage items in the current extract set.

Note that it is possible for an individual usage item to be discounted by none, one, or many inclusive usage schemes.

Each record indicates how much of an inclusive usage allocation was consumed by a usage item.

The association between inc_usage_units.dat records and the corresponding usage_item.dat record is made via the EXTERNAL_USAGE_ITEM_ID field.

Data loaded via this interface is primarily bound for the INCLUSIVE_USAGE_ITEM 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 table.

External table name

Schema

Mapped file

inc_usage_units_Interface

Staging

inc_usage_units.dat

 

Inclusive usage units interface table fields

Column Heading

Type

Length

Description

EXTERNAL_USAGE_ITEM_ID

VarChar2

40

This Value is used for reference with usage item data (see usage_item_Interface). It is used to associate the current inclusive usage units record with the usage item record that it has discounted.
EXTERNAL_ INC_USAGE_ALLOC_ID VarChar2 40 Unique inclusive usage allocation discount scheme identifier as used by the originating CRM data base. This value indicates which allocation the current inclusive usage unit record has acquired its units from to discount a usage item.
EXTERNAL _INVOICE_ID VarChar2 40 The CRM derived identifier of the invoice to which the usage item discounted by the current inclusive usage item record belongs.
INCLUSIVE_QUANTITY NUMBER(14,4)   The number of allocation units used up when discounting the associated usage item record.
UNIT_OF_MEASURE VarChar2 40 The unit of measure that qualifies the inclusive quantity value.
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.