AdministrationAddressEmailAddresses2: Minox Administration Address Email Addresses
read only per partition REST
- Catalog:
Minox - Schema:
MasterDataAdministration - Label: Administration Address Email Addresses
Retrieves a single administration.
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} - Operation:
get /tenant/{tenant_id}/administration/{administration_id}
Table Columns
The columns of the table AdministrationAddressEmailAddresses2 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 |
|---|---|---|---|---|---|
address_ |
varchar2 |
Address Type | writable, ::ancestor. |
The address type. | |
bank_ |
varchar2 |
Bank Account | filters on the platform, writable, ::ancestor. |
||
chamber_ |
varchar2 |
Chamber Of Commerce City | filters on the platform, writable, ::ancestor. |
||
chamber_ |
varchar2 |
Chamber Of Commerce ID | filters on the platform, writable, ::ancestor. |
||
city |
varchar2 |
City | writable, ::ancestor. |
The city of where it is located. | |
contact_ |
varchar2 |
Contact Email | filters on the platform, writable, ::ancestor. |
||
contact_ |
varchar2 |
Contact Name | writable, ::ancestor. |
The name of the contact person. | |
contact_ |
varchar2 |
itgen_minox_contact_name_2 | filters on the platform, writable, ::ancestor. |
||
contact_ |
varchar2 |
Contact Salutation | filters on the platform, writable, ::ancestor. |
||
country_ |
varchar2 |
Country Code | writable, ::ancestor. |
An ISO-3166-1-alpha2 country code. See https://en.wikipedia.org/wiki/ISO_3166-1_alpha-2#Officially_assigned_code_elements for more information. | |
currency_ |
varchar2 |
Currency Description | filters on the platform, writable, ::ancestor. |
||
currency_ |
decimal |
Currency Exchange Rate | filters on the platform, writable, ::ancestor. |
||
currency_ |
varchar2 |
Currency ID | filters on the platform, writable, ::ancestor. |
||
decimals_ |
int64 |
Decimals Amount | filters on the platform, writable, ::ancestor. |
||
decimals_ |
int64 |
Decimals Volume | filters on the platform, writable, ::ancestor. |
||
declaration_ |
varchar2 |
Declaration Type | filters on the platform, writable, ::ancestor. |
||
email_ |
varchar2 |
Email Address | writable, email_ |
The e-mail address. | |
email_ |
varchar2 |
Email Address Type | writable, email_ |
Deprecated. | |
extended_ |
varchar2 |
Extended Name | writable, ::ancestor. |
The extended name of the company. | |
follow_ |
varchar2 |
Follow Up Description Extra Description | filters on the platform, writable, ::ancestor. |
||
follow_ |
char |
Follow Up Description Invoice Texts | filters on the platform, writable, ::ancestor. |
||
follow_ |
char |
Follow Up Description Manual Descriptions | filters on the platform, writable, ::ancestor. |
||
follow_ |
varchar2 |
Follow Up Description Under or After | filters on the platform, writable, ::ancestor. |
||
g_ |
varchar2 |
G-Account IBAN | filters on the platform, writable, ::ancestor. |
||
g_ |
decimal |
G-Account Percentage | filters on the platform, writable, ::ancestor. |
||
id |
varchar2 |
ID | writable, ::ancestor. |
The unique identifier of a delivery address. | |
id_2 |
int64 |
itgen_minox_id_2 | filters on the platform, writable, ::ancestor. |
||
incasso_ |
varchar2 |
Incasso Mandate ID | filters on the platform, writable, ::ancestor. |
||
include_ |
varchar2 |
Include Invoice | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Automatic Payments Description | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Automatic Payment ID | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Automatic Payment Scheme | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Automatic Payment Type | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Debt Collection Description | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Debt Collection ID | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Debt Collection Scheme | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Debt Collection Type | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Exchange Rate Description | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Exchange Rate ID | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Exchange Rate Scheme | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Exchange Rate Type | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Invoice High Description | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Invoice High ID | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Invoice High Scheme | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Invoice High Type | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Invoice Low Description | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Invoice Low ID | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Invoice Low Scheme | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Invoice Low Type | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Invoice Zero Description | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Invoice Zero ID | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Invoice Zero Scheme | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Invoice Zero Type | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Paid Received VAT Description | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Paid Received VAT ID | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Paid Received VAT Scheme | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Paid Received VAT Type | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Private VAT Description | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Private VAT ID | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Private VAT Scheme | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Private VAT Type | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Profit Loss Description | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Profit Loss ID | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Profit Loss Scheme | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Profit Loss Type | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Transaction Rounding Description | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Transaction Rounding ID | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Transaction Rounding Scheme | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Transaction Rounding Type | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Unknown Transactions Description | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Unknown Transactions ID | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Unknown Transactions Scheme | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts Unknown Transactions Type | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts VAT In Europe GL Account Description | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts VAT In Europe GL Account ID | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts VAT In Europe GL Account Scheme | filters on the platform, writable, ::ancestor. |
||
ledger_ |
varchar2 |
Ledger Accounts VAT In Europe GL Account Type | filters on the platform, writable, ::ancestor. |
||
memo_ |
varchar2 |
Memo Action Text | filters on the platform, writable, ::ancestor. |
Memo to note actions that must be undertaken | |
memo_ |
varchar2 |
Memo Assignation Text | filters on the platform, writable, ::ancestor. |
Memo to note permanent agreements | |
memo_ |
varchar2 |
Memo Text | filters on the platform, writable, ::ancestor. |
Deprecated / Not in use | |
name |
varchar2 |
Name | writable, ::ancestor. |
The company name. | |
name_2 |
varchar2 |
itgen_minox_name_2 | filters on the platform, writable, ::ancestor. |
||
new_ |
varchar2 |
New Document | filters on the platform, writable, ::ancestor. |
||
next_ |
int64 |
Next Number Invoice Number | filters on the platform, writable, ::ancestor. |
||
next_ |
int64 |
Next Number Order Number | filters on the platform, writable, ::ancestor. |
||
next_ |
int64 |
Next Number Quotation Number | filters on the platform, writable, ::ancestor. |
||
next_ |
int64 |
Next Number Subscription Number | filters on the platform, writable, ::ancestor. |
||
number_ |
int64 |
Number of Periods | filters on the platform, writable, ::ancestor. |
||
order_ |
varchar2 |
Order Collection Sorting | filters on the platform, writable, ::ancestor. |
||
postal_ |
varchar2 |
Postal Code | writable, ::ancestor. |
The postal code. | |
salutation |
varchar2 |
Salutation | writable, ::ancestor. |
The salutation of the contact person. | |
search |
varchar2 |
Search | writable, ::ancestor. |
The search name of the delivery address. | |
share_ |
varchar2 |
Share ID | filters on the platform, writable, ::ancestor. |
||
show_ |
char |
Show On Accountancy Dashboard | filters on the platform, writable, ::ancestor. |
||
streetname_ |
varchar2 |
Street Name And Number | writable, ::ancestor. |
The name of the street and house number. | |
tax_ |
varchar2 |
Tax Sourcing Method | filters on the platform, writable, ::ancestor. |
||
tax_ |
varchar2 |
Tax Sourcing Provided by Becon Number | filters on the platform, writable, ::ancestor. |
||
tax_ |
varchar2 |
Tax Sourcing Provided by Contact | filters on the platform, writable, ::ancestor. |
||
tax_ |
varchar2 |
Tax Sourcing Provided by Phone Number | filters on the platform, writable, ::ancestor. |
||
uuid |
varchar2 |
UUID | filters on the platform, writable, ::ancestor. |
||
vat_ |
int64 |
VAT Codes High VAT ID | filters on the platform, writable, ::ancestor. |
||
vat_ |
int64 |
VAT Codes Low VAT ID | filters on the platform, writable, ::ancestor. |
||
vat_id |
varchar2 |
VAT ID | filters on the platform, writable, ::ancestor. |
||
vat_ |
char |
VAT in Europe Threshold Active | filters on the platform, writable, ::ancestor. |
||
vat_ |
varchar2 |
VAT Number | filters on the platform, writable, ::ancestor. |
||
vat_ |
char |
VAT On Sub | filters on the platform, writable, ::ancestor. |
||
write_ |
decimal |
Write Off VAT Difference Until | filters on the platform, writable, ::ancestor. |
||
www |
varchar2 |
www | writable, ::ancestor. |
The website. |
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