# DocumentTexts: Minox Document Texts Retrieves the document texts - Catalog: `Minox` - Schema: `OtherDocumentTexts` - Label: Document Texts The data in this table is partitioned per value of the `administration_code` column. This is a read-only table function. The Minox API may not support changing the data or the Invantive UniversalSQL driver for Minox does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Minox API. ## Parameters of Table Function The following parameters can be used to control the behaviour of the table function `DocumentTexts`. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be evaluated using their default values. Value specification by position is done by listing all values from the first to the last needed value. For example: a `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three. Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third. | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `administration_code` | `` | ☐ | | Partition to retrieve data from. | | `identifiers_only` | `` | ☐ | | An option to only include type, text_nr and language fields. | | `language` | `` | ☐ | | An option to filter on the document language using country code, e.g. 'NL'. | | `type` | `` | ☐ | | An option to filter on the document type. (Values: reminder, accountstatement, quotation, invoice, orderresponse, packinglist, billoflading, subscription) | ## Columns of Table Function The columns of the table function `DocumentTexts` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `closing_line_text_credit_limit` | `varchar2` | Closing Line Text Credit Limit | ☐ | | | `closing_line_text_discount` | `varchar2` | Closing Line Text Discount | ☐ | | | `closing_line_text_g_account` | `varchar2` | Closing Line Text G-Account | ☐ | | | `closing_line_text_indication_credit` | `varchar2` | Closing Line Text Indication Credit | ☐ | | | `closing_line_text_taxable_amount` | `varchar2` | Closing Line Text Taxable Amount | ☐ | | | `closing_line_text_total_amount` | `varchar2` | Closing Line Text Total Amount | ☐ | | | `closing_line_text_total` | `varchar2` | Closing Line Text Total | ☐ | | | `closing_line_text_vat_percentage` | `varchar2` | Closing Line Text VAT Percentage | ☐ | | | `closing_line_text_vat_reverse` | `varchar2` | Closing Line Text VAT Reverse | ☐ | | | `closing_line_text_vat` | `varchar2` | Closing Line Text VAT | ☐ | | | `conditions_text_customer_type` | `varchar2` | Conditions Text Customer Type | ☐ | | | `conditions_text_delivery` | `varchar2` | Conditions Text Delivery | ☐ | | | `conditions_text_payment` | `varchar2` | Conditions Text Payment | ☐ | | | `conditions_text_rayon` | `varchar2` | Conditions Text Rayon | ☐ | | | `conditions_text_representative` | `varchar2` | Conditions Text Representative | ☐ | | | `conditions_text_shipping_method` | `varchar2` | Conditions Text Shipping Method | ☐ | | | `document_text_nr` | `int64` | Document Text Number | ☐ | | | `email_print_company_details` | `char` | Email Print Company Details | ☐ | | | `email_text_bcc` | `varchar2` | Email Text BCC | ☐ | | | `email_text_company_name` | `varchar2` | Email Text Company Name | ☐ | | | `email_text_email` | `varchar2` | Email Text Email | ☐ | | | `email_text_sender` | `varchar2` | Email Text Sender | ☐ | | | `email_text_subject` | `varchar2` | Email Text Subject | ☐ | | | `footer_footer_left` | `int64` | Footer Left | ☐ | | | `footer_footer_top` | `int64` | Footer Top | ☐ | | | `footer_print_vat_specification` | `char` | Footer Print VAT Specification | ☐ | | | `footer_suppress_financial_details` | `char` | Footer Suppress Financial Details | ☐ | | | `footer_text_credit_limit` | `varchar2` | Footer Text Credit Limit | ☐ | | | `footer_text_footer` | `varchar2` | Footer Text Footer | ☐ | | | `footer_text_incasso` | `varchar2` | Footer Text Incasso | ☐ | | | `footer_text_intracom` | `varchar2` | Footer Text Intracom | ☐ | | | `footer_text_payment_info` | `varchar2` | Footer Text Payment Info | ☐ | | | `general_description` | `varchar2` | General Description | ☐ | | | `general_page_margin_left` | `int64` | General Page Margin Left | ☐ | | | `header_text_header` | `varchar2` | Header Text Header | ☐ | | | `language` | `varchar2` | Language | ☐ | | | `line_column_width_article_code` | `int64` | Line Column Width Article Code | ☐ | | | `line_print_amount` | `char` | Line Print Amount | ☐ | | | `line_print_article_code` | `char` | Line Print Article Code | ☐ | | | `line_print_date` | `char` | Line Print Date | ☐ | | | `line_print_delivered` | `char` | Line Print Delivered | ☐ | | | `line_print_description` | `char` | Line Print Description | ☐ | | | `line_print_discount_percentage` | `char` | Line Print Discount Percentage | ☐ | | | `line_print_headings` | `char` | Line Print Headings | ☐ | | | `line_print_indication_price_per` | `char` | Line Print Indication Price Per | ☐ | | | `line_print_number_of` | `char` | Line Print Number of | ☐ | | | `line_print_price` | `char` | Line Print Price | ☐ | | | `line_print_unit` | `char` | Line Print Unit | ☐ | | | `line_text_amount` | `varchar2` | Line Text Amount | ☐ | | | `line_text_article_code` | `varchar2` | Line Text Article Code | ☐ | | | `line_text_date` | `varchar2` | Line Text Date | ☐ | | | `line_text_delivered` | `varchar2` | Line Text Delivered | ☐ | | | `line_text_description` | `varchar2` | Line Text Description | ☐ | | | `line_text_discount_percentage` | `varchar2` | Line Text Discount Percentage | ☐ | | | `line_text_discount` | `varchar2` | Line Text Discount | ☐ | | | `line_text_number_of` | `varchar2` | Line Text Number of | ☐ | | | `line_text_percentage_left` | `varchar2` | Line Text Percentage Left | ☐ | | | `line_text_price` | `varchar2` | Line Text Price | ☐ | | | `line_text_unit` | `varchar2` | Line Text Unit | ☐ | | | `type` | `varchar2` | Type | ☐ | The type of the document |