ArticleSuppliersByArticleId |
Find all
Catalog: Robaws
Schema: ArticleSuppliers
This is a read-only table function. The Robaws API may not support changing the data or the Invantive SQL driver for Robaws does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Robaws API.
Select Robaws API URL: /api/v2/articles/{articleId}/article-suppliers
Insert Robaws API URL: /api/v2/articles/{articleId}/article-suppliers
Update Robaws API URL: /api/v2/articles/{articleId}/article-suppliers
Delete Robaws API URL: /api/v2/articles/{articleId}/article-suppliers
Field Selection Method: NotRequired
Base Path: items[*]
Select Robaws API Operation: get /api/v2/articles/{articleId}/article-suppliers
Table Function Columns
The columns of the table function ArticleSuppliersByArticleId are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
archivedAt |
datetime |
|
☐ |
|
createdAt |
datetime |
|
☐ |
|
date |
datetime |
Date |
☐ |
|
deletedAt |
datetime |
|
☐ |
|
grossPrice |
decimal |
|
☐ |
|
id |
string |
ID |
☐ |
|
minimumPurchaseAmount |
decimal |
|
☐ |
|
price |
decimal |
Price |
☐ |
|
reference |
string |
Reference |
☐ |
|
supplier_archivedAt |
datetime |
|
☐ |
|
supplier_createdAt |
datetime |
|
☐ |
|
supplier_deletedAt |
datetime |
|
☐ |
|
supplier_email |
string |
|
☐ |
|
supplier_fax |
string |
|
☐ |
|
supplier_generalLedgerAccount_archivedAt |
datetime |
|
☐ |
|
supplier_generalLedgerAccount_code |
string |
|
☐ |
|
supplier_generalLedgerAccount_createdAt |
datetime |
|
☐ |
|
supplier_generalLedgerAccount_deletedAt |
datetime |
|
☐ |
|
supplier_generalLedgerAccount_id |
string |
|
☐ |
|
supplier_generalLedgerAccount_name |
string |
|
☐ |
|
supplier_generalLedgerAccount_updatedAt |
datetime |
|
☐ |
|
supplier_generalLedgerAccountId |
string |
|
☐ |
|
supplier_gsm |
string |
|
☐ |
|
supplier_iban |
string |
|
☐ |
|
supplier_id |
string |
|
☐ |
|
supplier_invoiceAddress_addressLine1 |
string |
|
☐ |
|
supplier_invoiceAddress_addressLine2 |
string |
|
☐ |
|
supplier_invoiceAddress_city |
string |
|
☐ |
|
supplier_invoiceAddress_country |
string |
|
☐ |
|
supplier_invoiceAddress_latitude |
double |
|
☐ |
|
supplier_invoiceAddress_longitude |
double |
|
☐ |
|
supplier_invoiceAddress_postalCode |
string |
|
☐ |
|
supplier_invoiceRemarks |
string |
|
☐ |
|
supplier_kvk |
string |
|
☐ |
|
supplier_language |
string |
|
☐ |
|
supplier_legalForm_archivedAt |
datetime |
|
☐ |
|
supplier_legalForm_createdAt |
datetime |
|
☐ |
|
supplier_legalForm_deletedAt |
datetime |
|
☐ |
|
supplier_legalForm_id |
string |
|
☐ |
|
supplier_legalForm_legalAbbreviation |
string |
|
☐ |
|
supplier_legalForm_name |
string |
|
☐ |
|
supplier_legalForm_updatedAt |
datetime |
|
☐ |
|
supplier_legalForm_vatLiable |
boolean |
|
☐ |
|
supplier_legalFormId |
string |
|
☐ |
|
supplier_logicId |
string |
|
☐ |
|
supplier_name |
string |
|
☐ |
|
supplier_paymentConditionId |
string |
|
☐ |
|
supplier_planningEmail |
string |
|
☐ |
|
supplier_status |
string |
|
☐ |
|
supplier_supplyOrderRemarks |
string |
|
☐ |
|
supplier_tel |
string |
|
☐ |
|
supplier_updatedAt |
datetime |
|
☐ |
|
supplier_vatIdNumber |
string |
|
☐ |
|
supplier_vatTariff_additionalMention |
string |
|
☐ |
|
supplier_vatTariff_archivedAt |
datetime |
|
☐ |
|
supplier_vatTariff_category |
string |
|
☐ |
|
supplier_vatTariff_createdAt |
datetime |
|
☐ |
|
supplier_vatTariff_deletedAt |
datetime |
|
☐ |
|
supplier_vatTariff_description |
string |
|
☐ |
|
supplier_vatTariff_id |
string |
|
☐ |
|
supplier_vatTariff_name |
string |
|
☐ |
|
supplier_vatTariff_percentage |
decimal |
|
☐ |
|
supplier_vatTariff_updatedAt |
datetime |
|
☐ |
|
supplier_vatTariffId |
string |
|
☐ |
|
supplier_website |
string |
|
☐ |
|
supplierId |
string |
|
☐ |
|
unitType |
string |
Unit Type |
☐ |
|
updatedAt |
datetime |
|
☐ |
|
17-06-2022 11:59 Version 22.1.46-BETA+3385