Invoice Line Interface Table

This extract file interface handles the charge line records belonging to the invoices in the extract set. Data loaded via this interface is primarily bound for the INVOICE_LINE CXP 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
Invoice_Line_Interface	Staging	invoice_line.dat

 

Invoice line interface table fields

Column Heading	Type	Length	Description
EXTERNAL _INVOICE_ID	VarChar2	40	The CRM derived identifier of the invoice to which the current invoice line belongs.
EXTERNAL_ INVOICE_LINE_ID	VarChar2	40	CRM derived identifier for the current invoice line within its invoice. For example, a line number or similar.
EXTERNAL_ORGANISATION_UNIT_ID	VarChar2	40	Unique identifier denoting the CRM name for the organisation unit that owns the current invoice line.
ORGANISATION_UNIT_LEVEL	Integer		The level within the organisation unit hierarchy, at which the current organisation unit resides.
CHARGE_DESCRIPTION	VarChar2	100	A textual description of the service being charged for by the current invoice line. Note: This field maps to INVOICE_LINE_DESCRIPTION in the Lavastorm Spend Analyzer database
CHARGE_GROUP	VarChar2	40	A name for a logical grouping of invoice line charges. This grouping can be used to drive data selection and collection in reports over invoice charge data.
CHARGE_SUB_GROUP	VarChar2	40	A name for a logical grouping of invoice lines within a charge group. Again, this grouping can be used to drive data selection and collection in reports over invoice charge data.
CHARGE_START_DATE	Date		The date/time on which the charged for service began. DATE_FORMAT DATE MASK "yyyymmddhh24miss"
CHARGE_END_DATE	Date		The date/time on which the charged for service ended.
AMOUNT	Number	14,4	This value represents a monetary contribution made to the total invoice charge by this invoice line. There are two main categories of invoice line (see the invoice_line_category interface field). - If the invoice line is a tax line then the charge amount represents the tax associated with the charges for the current organisation unit and tax code. - If the invoice line is NOT a tax line, then the charge amount represents a net value (not inclusive of a tax component).
TAX_RATE	Number	14,4	The rate of tax that has been applied to a net charge type invoice line amount, or the rate of tax relevant to a tax type invoice line.
TAX_CODE	VarChar2	40	The identifying code for tax generated from a net charge type invoice line, or the code for the tax being shown on a tax type invoice line.
TAX_CODE_DESCRIPTION	VarChar2	100	A user readable description for the tax code.
BILLED QUANTITY	Integer		The billed quantity of billable units consumed by the services charged for by the current invoice line. This can differ from the gross quantity for various reasons, such as inclusive quantity discount schemes.
UNIT_OF_MEASURE	VarChar2	40	The unit of measure that qualifies the gross and billed quantity.
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 that the unit of measure and unit of measure category combination given must be one of the valid combinations configured within the CXP database. Note that 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.
INVOICE_LINE_CATEGORY	VarChar2	40	An enumerated type. Tax lines have a category of 'TAX'. Other lines currently default to an open category with a NULL value and are all deemed to be non-tax lines.
ATTRIBUTE_1	VarChar2	300	Customisable invoice line 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	300	Customisable invoice line 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
ATTRIBUTE_3	VarChar2	300	Customisable invoice line 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
TAX_LINE	Number		'1' (Yes/True) or '0' (No/False). Is the current invoice line a dedicated tax line?
SERVICE_TYPE	VarChar2	100	Defines the type of service that is being charged for by the current invoice line and used to differentiate the invoice line for reporting purposes (e.g. for report inclusion, exclusion, sorting and grouping).
NETWORK_TYPE	VarChar2	100	The type of the network, the use of whose services resulted in the raising of the current invoice line charge and used to differentiate the invoice line for reporting purposes (e.g. for report inclusion, exclusion, sorting and grouping).
RECURRING_CHARGE	Number		'1' (Yes/True) or '0' (No/False). Is the current invoice line a recurring charge applied to the customer’s invoice every billing cycle, as part of their contract for example?
NET_OF_TAX_SUMMARY	Number	14,4	This value applies to tax lines only. - If the invoice line is a tax line then the net of tax summary amount represents the total net value of charges associated with the current organisation unit and tax code. - If the invoice line is NOT a tax line, then this value should be left empty.