Statement Transation Interface Table
This extract file interface handles the statement transaction records belonging to each statement in the extract set.
When a statement transaction represents an invoice already loaded CXP
Customer Experience Platform, or CXP, is MDS Global's self-service app that allows business customers to manage their own accounts and subscriptions., an Invoice_transaction record is generated in the database that bridges between the statement transaction and the corresponding invoice.
Data loaded via this interface is primarily bound for the STATEMENT_TRANSACTION and INVOICE_TRANSACTION CXP Admin schema table.
|
External table name |
Schema |
Mapped file |
|---|---|---|
|
Statement_Interface |
Staging |
statement.dat
|
Statement transaction interface table fields
|
Column Heading |
Type |
Length |
Description |
|---|---|---|---|
|
EXTERNAL_STATEMENT_ID |
VarChar2 |
40 |
CRM derived statement Identifier for the statement to which the current statement transaction belongs. |
| EXTERNAL_STATEMENT_TRANS_ID | VarChar2 | 40 | Unique statement transaction identifier as used by the originating CRM data base. This value will generally represent the identifier for a document/transaction entry in the CRM's ledger. |
| EXTERNAL_ORGANISATION_UNIT_ID | VarChar2 | 40 | Unique identifier denoting the CRM name for the organisation unit that owns the current statement transaction. |
| ORGANISATION_UNIT_LEVEL | Integer | The level within the organisation unit hierarchy, at which the current organisation unit resides. | |
| TRANSACTION_AMOUNT | NUMBER(14,4) | The monetary value of the current transaction. Transactions can be in one of three categories and should follow the basic rules of accountancy according to category: 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. | |
| TRANSACTION_TEXT | VarChar2 | 100 | Textual Information associated with the current statement transaction. For example, a note against the transaction in the ledger. |
| TRANSACTION_CATEGORY | VarChar2 | 40 | Transactions can be in one of three categories: Invoice, Payment, or Adjustment. |
| TRANSACTION_DATE | Date | The date of the transaction. DATE_FORMAT DATE MASK "yyyymmddhh24miss | |
| EXTERNAL _INVOICE_ID | VarChar2 | 40 | Used if the transaction refers to an invoice. This value is used by the database to create a bridge between statement transactions and invoices. |