invantive documentation
Invantive Support ForumsLog In / Sign Up

DocumentTexts: Minox Document Texts

read only per partition REST

  • Catalog: Minox
  • Schema: OtherDocumentTexts
  • Label: Document Texts

Retrieves the document texts

The data in this table is partitioned per value of the administration_code column.

Can only retrieve data.

API Source

  • Endpoint: /tenant/{tenant_id}/administration/{administration_id}/documenttext
  • Operation: get /tenant/{tenant_id}/administration/{administration_id}/documenttext

Parameters

Name Data Type Required Default 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)

Table Columns

The columns of the table DocumentTexts are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
closing_line_text_credit_limit varchar2 Closing Line Text Credit Limit filters on the platform, writable, closing_line.text_credit_limit
closing_line_text_discount varchar2 Closing Line Text Discount filters on the platform, writable, closing_line.text_discount
closing_line_text_g_account varchar2 Closing Line Text G-Account filters on the platform, writable, closing_line.text_g_account
closing_line_text_indication_credit varchar2 Closing Line Text Indication Credit filters on the platform, writable, closing_line.text_indication_credit
closing_line_text_taxable_amount varchar2 Closing Line Text Taxable Amount filters on the platform, writable, closing_line.text_taxable_amount
closing_line_text_total varchar2 Closing Line Text Total filters on the platform, writable, closing_line.text_total
closing_line_text_total_amount varchar2 Closing Line Text Total Amount filters on the platform, writable, closing_line.text_total_amount
closing_line_text_vat varchar2 Closing Line Text VAT filters on the platform, writable, closing_line.text_vat
closing_line_text_vat_percentage varchar2 Closing Line Text VAT Percentage filters on the platform, writable, closing_line.text_vat_percentage
closing_line_text_vat_reverse varchar2 Closing Line Text VAT Reverse filters on the platform, writable, closing_line.text_vat_reverse
conditions_text_customer_type varchar2 Conditions Text Customer Type filters on the platform, writable, conditions.text_customer_type
conditions_text_delivery varchar2 Conditions Text Delivery filters on the platform, writable, conditions.text_delivery
conditions_text_payment varchar2 Conditions Text Payment filters on the platform, writable, conditions.text_payment
conditions_text_rayon varchar2 Conditions Text Rayon filters on the platform, writable, conditions.text_rayon
conditions_text_representative varchar2 Conditions Text Representative filters on the platform, writable, conditions.text_representative
conditions_text_shipping_method varchar2 Conditions Text Shipping Method filters on the platform, writable, conditions.text_shipping_method
document_text_nr int64 Document Text Number filters on the platform, writable, document_text_nr
email_print_company_details char Email Print Company Details filters on the platform, writable, email.print_company_details
email_text_bcc varchar2 Email Text BCC filters on the platform, writable, email.text_bcc
email_text_company_name varchar2 Email Text Company Name filters on the platform, writable, email.text_company_name
email_text_email varchar2 Email Text Email filters on the platform, writable, email.text_email
email_text_sender varchar2 Email Text Sender filters on the platform, writable, email.text_sender
email_text_subject varchar2 Email Text Subject filters on the platform, writable, email.text_subject
footer_footer_left int64 Footer Left filters on the platform, writable, footer.footer_left
footer_footer_top int64 Footer Top filters on the platform, writable, footer.footer_top
footer_print_vat_specification char Footer Print VAT Specification filters on the platform, writable, footer.print_vat_specification
footer_suppress_financial_details char Footer Suppress Financial Details filters on the platform, writable, footer.suppress_financial_details
footer_text_credit_limit varchar2 Footer Text Credit Limit filters on the platform, writable, footer.text_credit_limit
footer_text_footer varchar2 Footer Text Footer filters on the platform, writable, footer.text_footer
footer_text_incasso varchar2 Footer Text Incasso filters on the platform, writable, footer.text_incasso
footer_text_intracom varchar2 Footer Text Intracom filters on the platform, writable, footer.text_intracom
footer_text_payment_info varchar2 Footer Text Payment Info filters on the platform, writable, footer.text_payment_info
general_description varchar2 General Description filters on the platform, writable, general.description
general_page_margin_left int64 General Page Margin Left filters on the platform, writable, general.page_margin_left
header_text_header varchar2 Header Text Header filters on the platform, writable, header.text_header
language varchar2 Language filters on the platform, writable, language
line_column_width_article_code int64 Line Column Width Article Code filters on the platform, writable, line.column_width_article_code
line_print_amount char Line Print Amount filters on the platform, writable, line.print_amount
line_print_article_code char Line Print Article Code filters on the platform, writable, line.print_article_code
line_print_date char Line Print Date filters on the platform, writable, line.print_date
line_print_delivered char Line Print Delivered filters on the platform, writable, line.print_delivered
line_print_description char Line Print Description filters on the platform, writable, line.print_description
line_print_discount_percentage char Line Print Discount Percentage filters on the platform, writable, line.print_discount_percentage
line_print_headings char Line Print Headings filters on the platform, writable, line.print_headings
line_print_indication_price_per char Line Print Indication Price Per filters on the platform, writable, line.print_indication_price_per
line_print_number_of char Line Print Number of filters on the platform, writable, line.print_number_of
line_print_price char Line Print Price filters on the platform, writable, line.print_price
line_print_unit char Line Print Unit filters on the platform, writable, line.print_unit
line_text_amount varchar2 Line Text Amount filters on the platform, writable, line.text_amount
line_text_article_code varchar2 Line Text Article Code filters on the platform, writable, line.text_article_code
line_text_date varchar2 Line Text Date filters on the platform, writable, line.text_date
line_text_delivered varchar2 Line Text Delivered filters on the platform, writable, line.text_delivered
line_text_description varchar2 Line Text Description filters on the platform, writable, line.text_description
line_text_discount varchar2 Line Text Discount filters on the platform, writable, line.text_discount
line_text_discount_percentage varchar2 Line Text Discount Percentage filters on the platform, writable, line.text_discount_percentage
line_text_number_of varchar2 Line Text Number of filters on the platform, writable, line.text_number_of
line_text_percentage_left varchar2 Line Text Percentage Left filters on the platform, writable, line.text_percentage_left
line_text_price varchar2 Line Text Price filters on the platform, writable, line.text_price
line_text_unit varchar2 Line Text Unit filters on the platform, writable, line.text_unit
type varchar2 Type filters on the platform, writable, type The type of the document

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

Changes of This Table, 26.0 to 27.0

  • - administration_code
  • - administration_name

All changes of the driver, 26.0 to 27.0