...
| Name | Syntax | Explanation |
|---|---|---|
| Constant | "Constant text" | returns any text contained within " " **to include brackets () as part of constant text, each bracket must be preceded by - , e.g. " -(part á "&FORMAT(_vat_rate;0.00)&"% -)" **& symbol should be avoided as literal text wherever possible |
| Variable | _field_value | returns value of field_value |
| Mandatory | MANDATORY(_field_value) | field_value is mandatory and if no value given in raw data, file is not created and error is logged |
| Format | FORMAT(field;format) | value of field will be formatted according to format Available Formats (for FORMAT() formula) 0.00 az09 → abcdefghijklmnopqrstuvwxyz1234567890 ddmmyy ddmmyyyy dd/MM/yy dd/MM/yyyy dd.mmMM.yyyy ddmmyyyy yy dd.MM.yyyymm.aaaa |
| If | IF(logical_test;value_if_true;else) | if logical_test returns true, value_if_true will be returned (and analysed if it is a formula), otherwise else will be returned (and analysed if it is a formula) |
| If error | IFERROR(value;value_if_error) | returns value if not empty/null, and if value=empty/null, value_if_error |
| Or | OR(value_1;value_2;…;value_n);true_value;false_value | if any of the conditions (value_1, value_2, etc.) return true, returns true_value; if all of the conditions return false, returns false_value |
| Concatenate | value_1&value_2&value_n | concatenates value_1 with value_2, etc |
| Equal | value_a=value_b | returns true if value_a is equal to value_b, else returns false |
...
| Field name | Example value |
| _order_date | 25.02.2023 |
| _payment_date | 25.02.2023 |
| _order_id | 20995 |
| _line_id | 10228546422575 |
| _type | DIRECT_PAYMENT / SALE / CREDIT_WAIT_ACCOUNT / DEBIT_WAIT_ACCOUNT / COMPENSATION_SALE / DEBIT_CREDIT_NOTE / REFUND / REFUND_CLIENT / VAT |
| _kind | COMPOSED_PRODUCT / CHARGES / SINGLE_ENTRY |
| _accounting_code_1 | Visa / Credit / Pending / Voucher |
| _accounting_code_2 | 700000 |
| _accounting_code_3 | CA9 |
| _accounting_code_4 | |
| _accounting_code_5 | |
| _name | Gift voucher / Championship / Cap / Season ticket |
| _product_family | INT_PRODFAM/SPORTING / INT_PRODFAM/GOODS / INT_PRODFAM/MEM |
| _item_date | 2022-10-14 18:30:00.0 |
| _amount | 48000.00 |
| _vat_rate | 5500 |
| _vatcode_id | 15255 |
| _operator_name | PLC_TS |
| _contact_number | 10228546376027 |
| _payment_sale | P / S |
| _line_type | PAYMENT / SALE / VAT / ANALYTIC / ANALYTIC_2 / COMPENSATION_SALE / COMPENSATION_PAYMENT |
| _payment_currency | EUR |
| _payment_method_code | CB |
| _payment_method_internal_name | Carte Bancaire |
| _card_type | VISA |
| _amount_without_vat | 48000 |
| _credit_debit | C / D |
| _vat_accounting_code_1 | 44571402 |
| _vat_accounting_code_2 | |
| _vat_accounting_code_3 | |
| _vat_accounting_code_4 | |
| _vat_accounting_code_5 | |
| _invoice_number | SPORT-0000021 |
| _invoice_date | 08.01.2023 |
| _purchaser_contact_number | 38791 |
| _purchaser_structure_name | FEDERAL EXPRESS FRANCE |
| _purchaser_first_name | Joe |
| _purchaser_last_name | Bloggs |
| _sales_channel_code | TS |
| _sales_channel_internal_name | Ticketshop Grand Public |
| _sc_accounting_code_1 | CA9 |
| _sc_accounting_code_2 | 70121000 |
| _sc_accounting_code_3 | |
| _sc_accounting_code_4 | |
| _sc_accounting_code_5 | |
| _delayed_payment | Yes / No |
| _logical_seat_category_code | Cat1 / Cat2 / Cat3 / Cat4 / Visitor |
| _product_code | Park / Champ / Season |
| _season_code | Y |
| _file_number | 4578 |
| _audience_category | FULL |
...