ROBAWS API Data Model

Zoom Window Out
Larger Text | Smaller Text
Hide Page Header
Show Expanding Text
Print Topic
Send Mail Feedback
Share This Topic
Save Permalink URL

Navigation: Schema: Articles > Tables

Articles_ArticleSuppliersById

Contents Previous Home Next More

https://cloud.invantive.com/robaws/Sql

get

Catalog: Robaws

Schema: Articles

Select: true

Insert: false

Update: false

Delete: false

Select Service URL (OData-specific): /api/v1/articles/{id}

Insert Service URL (OData-specific): /api/v1/articles/{id}

Update Service URL (OData-specific): /api/v1/articles/{id}

Delete Service URL (OData-specific): /api/v1/articles/{id}

Field Selection Method (OData-specific): NotRequired

Base Path (OData-specific): articleSuppliers[*]

Select Operation (Swagger-specific): get /api/v1/articles/{id}

Table Function Parameters

The following parameters can be used to control the behaviour of the table function Articles_ArticleSuppliersById. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be treated using their default values.

Value specification by position is done by listing all values from the first to the last needed value. For example with `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three.

Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third.

Name	Data Type	Required	Default Value	Documentation
id	int64	☑		id

Table Columns

The columns of the table Articles_ArticleSuppliersById are shown below. Each column has an SQL data type.

Name	Data Type	Label	Required
accountancyCode_code	string		☐
accountancyCode_externalId	string		☐
accountancyCode_id	int64		☐
accountancyCode_name	string	Accountancy Code Name	☐
accountancyCode_version	int64	Accountancy Code Version	☐
accountancyCodePurchase_code	string		☐
accountancyCodePurchase_externalId	string		☐
accountancyCodePurchase_id	int64		☐
accountancyCodePurchase_name	string		☐
accountancyCodePurchase_version	int64		☐
activity	string	Activity	☐
agreementType	string	Agreement Type	☐
articleGroup_contextPath	string		☐
articleGroup_id	int64	Article Group ID	☐
articleGroup_name	string	Article Group Name	☐
articleGroup_photo_availableForWappy	boolean		☐
articleGroup_photo_directory	boolean		☐
articleGroup_photo_documentDate	datetime		☐
articleGroup_photo_expirationDate	datetime		☐
articleGroup_photo_filename	string		☐
articleGroup_photo_fileSize	int64		☐
articleGroup_photo_id	int64		☐
articleGroup_photo_mimeType	string		☐
articleGroup_photo_objectRef_objectId	int64		☐
articleGroup_photo_objectRef_objectType	string		☐
articleGroup_photo_parentId	int64		☐
articleGroup_photo_path	string		☐
articleGroup_photo_uuid	string		☐
articleGroup_photo_version	int64		☐
articleGroup_photo_wappy	boolean		☐
articleGroup_version	int64	Article Group Version	☐
articleNumber	string	Article Number	☐
articleType	string	Article Type	☐
barcode	string	Bar Code	☐
brand	string	Brand	☐
calc	boolean	Calc	☐
calcDescription	string	Calc Description	☐
calculationType	string	Calculation Type	☐
chapter	string	Chapter	☐
costPrice	double	Cost Price	☐
costPriceStrategy	string		☐
currencySymbol	string	Currency Symbol	☐
currencySymbol_1	string		☐
date	datetime	Date	☐
description	string	Description	☐
deviantSalesName	string	Deviating Sales Name	☐
externalId	string	External ID	☐
grossPrice	double		☐
headerLevel	string	Header Level	☐
id	int64	ID	☐
id_1	int64		☐
indirectCostFactor	double	Indirect Cost Factor	☐
internalPhoto	boolean	Internal Photograph	☐
lineType	string	Line Type	☐
margin	double	Margin	☐
materialInstallation	boolean	Material Installation	☐
minimumAmount	double		☐
minimumSaleAmount	double	Minimum Sales Amount	☐
minimumStockAmount	double	Minimum Stock Amount	☐
name	string	Name	☐
newPage	boolean	New Page	☐
photo_availableForWappy	boolean		☐
photo_directory	boolean	Photo Directory	☐
photo_documentDate	datetime	Photo Document Date	☐
photo_expirationDate	datetime	Photo Expiration Date	☐
photo_filename	string	Photo File Name	☐
photo_fileSize	int64	Photo File Size	☐
photo_id	int64	Photo ID	☐
photo_mimeType	string	Photo MIME Type	☐
photo_objectRef_objectId	int64		☐
photo_objectRef_objectType	string		☐
photo_parentId	int64		☐
photo_path	string		☐
photo_uuid	string	Photo UUID	☐
photo_version	int64	Photo Version	☐
photo_wappy	boolean		☐
price	double	Price	☐
reference	string	Reference	☐
saleName	string		☐
salePrice	double	Sales Price	☐
salePriceStrategy	string		☐
stockAmount	double	Stock Amount	☐
stockChanges	string	Stock Changes	☐
stockLocation	string	Stock Location	☐
supplier_accountancyCodePurchase_code	string		☐
supplier_accountancyCodePurchase_externalId	string		☐
supplier_accountancyCodePurchase_id	int64		☐
supplier_accountancyCodePurchase_name	string		☐
supplier_accountancyCodePurchase_version	int64		☐
supplier_accountNr	string		☐
supplier_addressString	string		☐
supplier_bank	string		☐
supplier_btwNumber	string		☐
supplier_currencySymbol	string		☐
supplier_email	string		☐
supplier_externalId	string		☐
supplier_fax	string		☐
supplier_gsm	string		☐
supplier_id	int64		☐
supplier_invoiceAddress_city	string		☐
supplier_invoiceAddress_country	string		☐
supplier_invoiceAddress_latLng_defined	boolean		☐
supplier_invoiceAddress_latLng_lat	double		☐
supplier_invoiceAddress_latLng_lng	double		☐
supplier_invoiceAddress_street	string		☐
supplier_invoiceAddress_streetBase	string		☐
supplier_invoiceAddress_streetExtra	string		☐
supplier_invoiceAddress_streetNumber	string		☐
supplier_invoiceAddress_zipcode	string		☐
supplier_invoiceRemarks	string		☐
supplier_language	string		☐
supplier_legalForm_hasVat	boolean		☐
supplier_legalForm_id	int64		☐
supplier_legalForm_name	string		☐
supplier_legalForm_pdfName	string		☐
supplier_legalForm_version	int64		☐
supplier_legalName	string		☐
supplier_logicId	string		☐
supplier_name	string		☐
supplier_planningEmail	string		☐
supplier_status	string		☐
supplier_supplyOrderRemarks	string		☐
supplier_tel	string		☐
supplier_vat_ublSchemeId	string		☐
supplier_vat_vatCode	string		☐
supplier_vat_vatCountry	string		☐
supplier_vat_vatValid	boolean		☐
supplier_vatNr	string		☐
supplier_vatTarif	string		☐
supplier_version	int64		☐
supplier_website	string		☐
supplierName	string	Supplier Name	☐
supplierNames	string	Supplier Names	☐
timeOperation	boolean	Time Operation	☐
unitType	string	Unit Type	☐
unitType_1	string		☐
vatTarif	string	VAT Code	☐
version	int64	Version	☐
version_1	int64		☐
webshop	string		☐

17-11-2020 16:0920.1.279-BETA+2990

Please enable JavaScript to view this site.

ROBAWS API Data Model

Articles_ArticleSuppliersById

Table Function Parameters

Table Columns