Version: 1.0
| Attribute ID | Datatype | Data length | Nullabe ? | Label | Description |
|---|---|---|---|---|---|
| CATALOG_CURRENCY_CODE | CHAR | 3 | Y | Currency code of catalog | |
| CONTACT | VARCHAR2 | 831 | Y | Contact | Contact name in format: "last name, first name (contact number)". No contact number if only beneficiary. |
| CONTACT_ADDR_COUNTRY_CODE | CHAR | 2 | Y | Country | Address country code |
| CONTACT_ADDR_TOWN | VARCHAR2 | 400 | Y | Town | Town of address |
| CONTACT_ADDR_ZIPCODE | VARCHAR2 | 20 | Y | State | Postal code |
| CONTACT_TELEPHONE | VARCHAR2 | 31 | Y | Phone number incl. Prefix | |
| FILE_NUMBER | VARCHAR2 | 4000 | Y | File number | File number |
| INSTIT_CODE | VARCHAR2 | 15 | N | Institution code | |
| LAST_UPDATE | TIMESTAMP(6) WITH TIME ZONE | 13 | Y | Date of last update of report data | |
| OPERATOR | VARCHAR2 | 825 | Y | Operator | Operator name + login |
| OPERATORLOGIN | VARCHAR2 | 20 | Y | Operator login | |
| ORDER_NUMBER | VARCHAR2 | 4000 | Y | Order Number | Order number |
| ORGANIZATION | VARCHAR2 | 240 | Y | Organization | Organization name |
| POS | VARCHAR2 | 32 | Y | Point of sales code | |
| SALES_CHANNEL | VARCHAR2 | 240 | Y | Sales channel | Sales channel name |
| STRUCTURE | VARCHAR2 | 400 | Y | Structure | Name of the company/organization the contact belongs to |
| TRANSACTION_DATE | TIMESTAMP(6) WITH TIME ZONE | 13 | Y | Transaction date | Financial transaction date |
| TRANSACTION_KIND | VARCHAR2 | 25 | Y | Transaction kind | Financial transaction type. Possible values are: - Credit note credit - Deposit credit - Suspense account credit - Credit note debit - Suspense account debit |
| TRANSACTION_TYPE | VARCHAR2 | 4000 | Y | Transaction type | Type of account impacted by financial transaction: - Waiting/pending account - Credit note - Deposit |
| TRANS_PAYMENT_BANK | VARCHAR2 | 800 | Y | Bank name | |
| TRANS_PAYMENT_CREDIT_AMT | NUMBER | 22 | Y | Transaction amount (only set if credit) | |
| TRANS_PAYMENT_CURRENCY_AMT | NUMBER | 22 | Y | Transaction amount | |
| TRANS_PAYMENT_CURRENCY_CODE | CHAR | 3 | Y | Currency code | |
| TRANS_PAYMENT_DEBIT_AMT | NUMBER | 22 | Y | Transaction amount (only set if debit) | |
| TRANS_PAYMENT_IBAN | VARCHAR2 | 34 | Y | IBAN account number | |
| TRANS_PAYMENT_IDENTIFIER | VARCHAR2 | 200 | Y | Payment identification | |
| TRANS_PAYMENT_METHOD | VARCHAR2 | 240 | Y | Name of payment method | |
| TRANS_PAYMENT_REMARK | VARCHAR2 | 4000 | Y | Payment remark | |
| T_CASHDESK_ID | NUMBER | 22 | Y | Technical identifier of cash desk | |
| T_CONTACT_ID | NUMBER | 22 | Y | Contact technical identifier | |
| T_IS_VIRTUAL_OP | CHAR | 1 | Y | Flag mentioning if the author is a virtual operator | |
| T_ORGANIZATION_ID | NUMBER | 22 | N | Technical identifier of organization | |
| T_POS_ID | NUMBER | 22 | N | Technical identifier of point of sales | |
| T_SALES_CHANNEL_ID | NUMBER | 22 | N | Technical identifier of sales channel | |
| T_TRANSACTION_PAYMENT_ID | NUMBER | 22 | N | Technical identifier of payment | |
| T_TYPE | VARCHAR2 | 40 | Y | Type of account (see above): - PAY_TYPE/CA (waiting account) - PAY_TYPE/AVR (credit note) - PAY_TYPE/DEPOSIT (deposit) |