Statement Interface Table

This extract file interface handles header records for each statement in the extract set.

Data loaded via this interface is primarily bound for the STATEMENT 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
Statement_Interface	Staging	statement.dat

 

Statement interface table fields

Column Heading	Type	Length	Description
EXTERNAL_STATEMENT_ID	VarChar2	40	Unique statement 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 statement. This will be a posting account against charges are levied and for which the opening balance on the current statement is applicable.
ORGANISATION_UNIT_LEVEL	Integer		The level within the organisation unit hierarchy, at which the current organisation unit resides.
EXTERNAL_DELIVERY_ADDRESS_ID	VarChar2	40	A CRM derived delivery address identifier. This value provides a link to the delivery_address.dat extract file record that contains the details of the current statement's delivery address.
OPENING_BALANCE	NUMBER(14,4)		The amount due (closing balance) brought forward from the previous statement period. Note: To calculate the closing balance for the statement period you would do the following calculation: Closing balance = Opening Balance + Transaction total. The queried total can then be used to adjust the customer's outstanding balance for credit control pursuit purposes.
TRANSACTION_TOTAL	NUMBER(14,4)		The total value of the transactions associated with the statement owner, raised since the previous statement was produced. This value is generated from the total of invoice, payment and adjustment transactions generated this period (since the last statement). Following the basic rules of accounting, if the transaction total is a net credit to the account it should be a negative value and if it is a net debit to the account is should be a positive value. Example: When calculating this value: A PAYMENT should be a negative value if it credits the account. An ADJUSTMENT that credits the account should be a negative value, one that debits the account a positive value. An INVOICE total should generally be a positive value (to debit the account), but this depends on the nature of the invoice.
QUERIED_TOTAL	NUMBER(14,4)		This value represents the total of any charges that are in dispute by the customer. Queried amounts place a credit against an account whilst the disputed charges are investigated. This credit is designed to give the customer the benefit of the doubt and prevent create control activity from acting against their account. QUERIED_TOTAL should be a negative amount if a charge is in dispute (i.e. the queried amount acts as a credit on the account).
STATEMENT_TEXT	VarChar2	100	Textual Information associated with the current statement.
STATEMENT_DATE	Date		Statement production date. The date at which the calculated closing balance for the current statement is correct. DATE_FORMAT DATE MASK "yyyymmddhh24miss"