Banks: Minox Banks
read only per partition REST
- Catalog:
Minox - Schema:
MasterDataAdministration - Label: Banks
Retrieves an administration list.
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 - Operation:
get /tenant/{tenant_id}/administration
Table Columns
The columns of the table Banks 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 |
|---|---|---|---|---|---|
bank_ |
varchar2 |
Bank Account | filters on the platform, writable, ::ancestor. |
||
bic |
varchar2 |
BIC | writable, bic |
||
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, city |
||
contact_ |
varchar2 |
Contact Email | filters on the platform, writable, ::ancestor. |
||
contact_ |
varchar2 |
Contact Name | filters on the platform, writable, ::ancestor. |
||
contact_ |
varchar2 |
Contact Salutation | filters on the platform, writable, ::ancestor. |
||
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. |
||
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. |
||
iban |
varchar2 |
IBAN | writable, iban |
||
id |
int64 |
ID | writable, id |
||
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. |
||
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, 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. |
||
share_ |
varchar2 |
Share ID | filters on the platform, writable, ::ancestor. |
||
show_ |
char |
Show On Accountancy Dashboard | filters on the platform, writable, ::ancestor. |
||
tax_ |
varchar2 |
Tax Sourcing Method | 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. |
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