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_ |
`` | Partition to retrieve data from. | ||
identifiers_ |
`` | 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_ |
varchar2 |
Closing Line Text Credit Limit | filters on the platform, writable, closing_ |
||
closing_ |
varchar2 |
Closing Line Text Discount | filters on the platform, writable, closing_ |
||
closing_ |
varchar2 |
Closing Line Text G-Account | filters on the platform, writable, closing_ |
||
closing_ |
varchar2 |
Closing Line Text Indication Credit | filters on the platform, writable, closing_ |
||
closing_ |
varchar2 |
Closing Line Text Taxable Amount | filters on the platform, writable, closing_ |
||
closing_ |
varchar2 |
Closing Line Text Total | filters on the platform, writable, closing_ |
||
closing_ |
varchar2 |
Closing Line Text Total Amount | filters on the platform, writable, closing_ |
||
closing_ |
varchar2 |
Closing Line Text VAT | filters on the platform, writable, closing_ |
||
closing_ |
varchar2 |
Closing Line Text VAT Percentage | filters on the platform, writable, closing_ |
||
closing_ |
varchar2 |
Closing Line Text VAT Reverse | filters on the platform, writable, closing_ |
||
conditions_ |
varchar2 |
Conditions Text Customer Type | filters on the platform, writable, conditions. |
||
conditions_ |
varchar2 |
Conditions Text Delivery | filters on the platform, writable, conditions. |
||
conditions_ |
varchar2 |
Conditions Text Payment | filters on the platform, writable, conditions. |
||
conditions_ |
varchar2 |
Conditions Text Rayon | filters on the platform, writable, conditions. |
||
conditions_ |
varchar2 |
Conditions Text Representative | filters on the platform, writable, conditions. |
||
conditions_ |
varchar2 |
Conditions Text Shipping Method | filters on the platform, writable, conditions. |
||
document_ |
int64 |
Document Text Number | filters on the platform, writable, document_ |
||
email_ |
char |
Email Print Company Details | filters on the platform, writable, email. |
||
email_ |
varchar2 |
Email Text BCC | filters on the platform, writable, email. |
||
email_ |
varchar2 |
Email Text Company Name | filters on the platform, writable, email. |
||
email_ |
varchar2 |
Email Text Email | filters on the platform, writable, email. |
||
email_ |
varchar2 |
Email Text Sender | filters on the platform, writable, email. |
||
email_ |
varchar2 |
Email Text Subject | filters on the platform, writable, email. |
||
footer_ |
int64 |
Footer Left | filters on the platform, writable, footer. |
||
footer_ |
int64 |
Footer Top | filters on the platform, writable, footer. |
||
footer_ |
char |
Footer Print VAT Specification | filters on the platform, writable, footer. |
||
footer_ |
char |
Footer Suppress Financial Details | filters on the platform, writable, footer. |
||
footer_ |
varchar2 |
Footer Text Credit Limit | filters on the platform, writable, footer. |
||
footer_ |
varchar2 |
Footer Text Footer | filters on the platform, writable, footer. |
||
footer_ |
varchar2 |
Footer Text Incasso | filters on the platform, writable, footer. |
||
footer_ |
varchar2 |
Footer Text Intracom | filters on the platform, writable, footer. |
||
footer_ |
varchar2 |
Footer Text Payment Info | filters on the platform, writable, footer. |
||
general_ |
varchar2 |
General Description | filters on the platform, writable, general. |
||
general_ |
int64 |
General Page Margin Left | filters on the platform, writable, general. |
||
header_ |
varchar2 |
Header Text Header | filters on the platform, writable, header. |
||
language |
varchar2 |
Language | filters on the platform, writable, language |
||
line_ |
int64 |
Line Column Width Article Code | filters on the platform, writable, line. |
||
line_ |
char |
Line Print Amount | filters on the platform, writable, line. |
||
line_ |
char |
Line Print Article Code | filters on the platform, writable, line. |
||
line_ |
char |
Line Print Date | filters on the platform, writable, line. |
||
line_ |
char |
Line Print Delivered | filters on the platform, writable, line. |
||
line_ |
char |
Line Print Description | filters on the platform, writable, line. |
||
line_ |
char |
Line Print Discount Percentage | filters on the platform, writable, line. |
||
line_ |
char |
Line Print Headings | filters on the platform, writable, line. |
||
line_ |
char |
Line Print Indication Price Per | filters on the platform, writable, line. |
||
line_ |
char |
Line Print Number of | filters on the platform, writable, line. |
||
line_ |
char |
Line Print Price | filters on the platform, writable, line. |
||
line_ |
char |
Line Print Unit | filters on the platform, writable, line. |
||
line_ |
varchar2 |
Line Text Amount | filters on the platform, writable, line. |
||
line_ |
varchar2 |
Line Text Article Code | filters on the platform, writable, line. |
||
line_ |
varchar2 |
Line Text Date | filters on the platform, writable, line. |
||
line_ |
varchar2 |
Line Text Delivered | filters on the platform, writable, line. |
||
line_ |
varchar2 |
Line Text Description | filters on the platform, writable, line. |
||
line_ |
varchar2 |
Line Text Discount | filters on the platform, writable, line. |
||
line_ |
varchar2 |
Line Text Discount Percentage | filters on the platform, writable, line. |
||
line_ |
varchar2 |
Line Text Number of | filters on the platform, writable, line. |
||
line_ |
varchar2 |
Line Text Percentage Left | filters on the platform, writable, line. |
||
line_ |
varchar2 |
Line Text Price | filters on the platform, writable, line. |
||
line_ |
varchar2 |
Line Text Unit | filters on the platform, writable, line. |
||
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