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 | N | Organization | Organization name |
POS | VARCHAR2 | 32 | Y | Point of sales code | |
SALES_CHANNEL | VARCHAR2 | 240 | N | 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 | N | 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 | N | 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 | N | 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) |