Posts_CalculationLineItemsById |
Find one
Catalogus: Robaws
Schema: Posts
Dit is een alleen-lezen tabelfunctie. De ROBAWS API biedt mogelijk geen ondersteuning voor het wijzigen van de data of het Invantive SQL-stuurprogramma voor ROBAWS ondersteunt dit niet. In het laatste geval gebruikt u de tabel NativePlatformScalarRequests om gegevens te uploaden naar de ROBAWS-API.
Kolommen van Tabelfunctie
De kolommen van de tabelfunctie Posts_CalculationLineItemsById worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
activity__metadata_description |
string |
|
☐ |
|
activity__metadata_href |
string |
|
☐ |
|
activity__metadata_resource |
string |
|
☐ |
|
activity__metadata_resourceTypeId |
string |
|
☐ |
|
activity_archivedAt |
datetime |
|
☐ |
|
activity_createdAt |
datetime |
|
☐ |
|
activity_deletedAt |
datetime |
|
☐ |
|
activity_extraFields |
string |
|
☐ |
|
activity_id |
string |
|
☐ |
|
activity_lockedAt |
datetime |
|
☐ |
|
activity_name |
string |
|
☐ |
|
activity_updatedAt |
datetime |
|
☐ |
|
activityId |
string |
|
☐ |
|
archivedAt_1 |
datetime |
|
☐ |
|
archivedAt |
datetime |
|
☐ |
|
article__metadata_description |
string |
|
☐ |
|
article__metadata_href |
string |
|
☐ |
|
article__metadata_resource |
string |
|
☐ |
|
article__metadata_resourceTypeId |
string |
|
☐ |
|
article_activity__metadata_description |
string |
|
☐ |
|
article_activity__metadata_href |
string |
|
☐ |
|
article_activity__metadata_resource |
string |
|
☐ |
|
article_activity__metadata_resourceTypeId |
string |
|
☐ |
|
article_activity_archivedAt |
datetime |
|
☐ |
|
article_activity_createdAt |
datetime |
|
☐ |
|
article_activity_deletedAt |
datetime |
|
☐ |
|
article_activity_extraFields |
string |
|
☐ |
|
article_activity_id |
string |
|
☐ |
|
article_activity_lockedAt |
datetime |
|
☐ |
|
article_activity_name |
string |
|
☐ |
|
article_activity_updatedAt |
datetime |
|
☐ |
|
article_activityId |
string |
|
☐ |
|
article_archivedAt |
datetime |
|
☐ |
|
article_articleGroupId |
string |
|
☐ |
|
article_articleNumber |
string |
|
☐ |
|
article_availableStock |
decimal |
|
☐ |
This property should be used by third parties (for example webshops) that want to know how much stock is available for sale.When reading, only present if requested via 'include' query parameter, otherwise null. |
article_backorderStock |
decimal |
|
☐ |
When reading, only present if requested via 'include' query parameter, otherwise null. |
article_barcode |
string |
Artikel Streepjescode |
☐ |
|
article_brand |
string |
|
☐ |
|
article_calculationType |
string |
|
☐ |
|
article_costPrice |
decimal |
|
☐ |
|
article_costPriceStrategy |
string |
|
☐ |
|
article_createdAt |
datetime |
|
☐ |
|
article_deletedAt |
datetime |
|
☐ |
|
article_description |
string |
|
☐ |
|
article_descriptionTranslations |
string |
|
☐ |
|
article_extraFields |
string |
|
☐ |
|
article_group__metadata_description |
string |
|
☐ |
|
article_group__metadata_href |
string |
|
☐ |
|
article_group__metadata_resource |
string |
|
☐ |
|
article_group__metadata_resourceTypeId |
string |
|
☐ |
|
article_group_archivedAt |
datetime |
|
☐ |
|
article_group_createdAt |
datetime |
|
☐ |
|
article_group_deletedAt |
datetime |
|
☐ |
|
article_group_extraFields |
string |
|
☐ |
|
article_group_id |
string |
|
☐ |
|
article_group_image__metadata_description |
string |
|
☐ |
|
article_group_image__metadata_href |
string |
|
☐ |
|
article_group_image__metadata_resource |
string |
|
☐ |
|
article_group_image__metadata_resourceTypeId |
string |
|
☐ |
|
article_group_image_archivedAt |
datetime |
|
☐ |
|
article_group_image_contentType |
string |
|
☐ |
|
article_group_image_createdAt |
datetime |
|
☐ |
|
article_group_image_deletedAt |
datetime |
|
☐ |
|
article_group_image_directory |
boolean |
|
☐ |
|
article_group_image_id |
string |
|
☐ |
|
article_group_image_lockedAt |
datetime |
|
☐ |
|
article_group_image_name |
string |
|
☐ |
|
article_group_image_parentId |
string |
|
☐ |
|
article_group_image_previewUrl |
string |
|
☐ |
|
article_group_image_size |
int64 |
|
☐ |
|
article_group_image_updatedAt |
datetime |
|
☐ |
|
article_group_image_url |
string |
|
☐ |
|
article_group_lockedAt |
datetime |
|
☐ |
|
article_group_name |
string |
|
☐ |
|
article_group_parentId |
string |
|
☐ |
|
article_group_updatedAt |
datetime |
|
☐ |
|
article_group_wappy |
boolean |
|
☐ |
|
article_id |
string |
Artikel ID |
☐ |
|
article_image__metadata_description |
string |
|
☐ |
|
article_image__metadata_href |
string |
|
☐ |
|
article_image__metadata_resource |
string |
|
☐ |
|
article_image__metadata_resourceTypeId |
string |
|
☐ |
|
article_image_archivedAt |
datetime |
|
☐ |
|
article_image_contentType |
string |
|
☐ |
|
article_image_createdAt |
datetime |
|
☐ |
|
article_image_deletedAt |
datetime |
|
☐ |
|
article_image_directory |
boolean |
|
☐ |
|
article_image_id |
string |
|
☐ |
|
article_image_lockedAt |
datetime |
|
☐ |
|
article_image_name |
string |
|
☐ |
|
article_image_parentId |
string |
|
☐ |
|
article_image_previewUrl |
string |
|
☐ |
|
article_image_size |
int64 |
|
☐ |
|
article_image_updatedAt |
datetime |
|
☐ |
|
article_image_url |
string |
|
☐ |
|
article_installation |
boolean |
|
☐ |
|
article_lockedAt |
datetime |
|
☐ |
|
article_margin |
decimal |
|
☐ |
|
article_minimumStock |
decimal |
|
☐ |
|
article_name |
string |
|
☐ |
|
article_nameTranslations |
string |
|
☐ |
|
article_purchaseGLAccount__metadata_description |
string |
|
☐ |
|
article_purchaseGLAccount__metadata_href |
string |
|
☐ |
|
article_purchaseGLAccount__metadata_resource |
string |
|
☐ |
|
article_purchaseGLAccount__metadata_resourceTypeId |
string |
|
☐ |
|
article_purchaseGLAccount_archivedAt |
datetime |
|
☐ |
|
article_purchaseGLAccount_code |
string |
|
☐ |
|
article_purchaseGLAccount_createdAt |
datetime |
|
☐ |
|
article_purchaseGLAccount_deletedAt |
datetime |
|
☐ |
|
article_purchaseGLAccount_extraFields |
string |
|
☐ |
|
article_purchaseGLAccount_id |
string |
|
☐ |
|
article_purchaseGLAccount_lockedAt |
datetime |
|
☐ |
|
article_purchaseGLAccount_name |
string |
|
☐ |
|
article_purchaseGLAccount_updatedAt |
datetime |
|
☐ |
|
article_purchaseGLAccountId |
string |
|
☐ |
|
article_reservedStock |
decimal |
|
☐ |
When reading, only present if requested via 'include' query parameter, otherwise null. |
article_saleName |
string |
|
☐ |
|
article_salePrice |
decimal |
|
☐ |
|
article_salePriceStrategy |
string |
|
☐ |
|
article_salesGLAccount__metadata_description |
string |
|
☐ |
|
article_salesGLAccount__metadata_href |
string |
|
☐ |
|
article_salesGLAccount__metadata_resource |
string |
|
☐ |
|
article_salesGLAccount__metadata_resourceTypeId |
string |
|
☐ |
|
article_salesGLAccount_archivedAt |
datetime |
|
☐ |
|
article_salesGLAccount_code |
string |
|
☐ |
|
article_salesGLAccount_createdAt |
datetime |
|
☐ |
|
article_salesGLAccount_deletedAt |
datetime |
|
☐ |
|
article_salesGLAccount_extraFields |
string |
|
☐ |
|
article_salesGLAccount_id |
string |
|
☐ |
|
article_salesGLAccount_lockedAt |
datetime |
|
☐ |
|
article_salesGLAccount_name |
string |
|
☐ |
|
article_salesGLAccount_updatedAt |
datetime |
|
☐ |
|
article_salesGLAccountId |
string |
|
☐ |
|
article_stockArticle |
boolean |
|
☐ |
|
article_stockPlace |
string |
|
☐ |
|
article_targetStock |
decimal |
|
☐ |
|
article_timeOperation |
boolean |
|
☐ |
|
article_totalStock |
decimal |
|
☐ |
When reading, only present if requested via 'include' query parameter, otherwise null. |
article_type |
string |
|
☐ |
|
article_unitType |
string |
|
☐ |
|
article_updatedAt |
datetime |
|
☐ |
|
article_vatTariffId |
string |
|
☐ |
|
article_wappy |
boolean |
|
☐ |
|
articleGroupId |
string |
|
☐ |
|
articleId |
string |
|
☐ |
|
c_metadata_description_1 |
string |
|
☐ |
|
c_metadata_description |
string |
|
☐ |
|
c_metadata_href_1 |
string |
|
☐ |
|
c_metadata_href |
string |
|
☐ |
|
c_metadata_resource_1 |
string |
|
☐ |
|
c_metadata_resource |
string |
|
☐ |
|
c_metadata_resourceTypeId_1 |
string |
|
☐ |
|
c_metadata_resourceTypeId |
string |
|
☐ |
|
calculationDescription |
string |
|
☐ |
|
calculationDescriptionOnPdf |
boolean |
|
☐ |
|
calculationType |
string |
Berekeningssoort |
☐ |
|
chapter |
string |
Hoofdstuk |
☐ |
|
costPrice |
decimal |
Kostprijs |
☐ |
|
createdAt_1 |
datetime |
|
☐ |
|
createdAt |
datetime |
|
☐ |
|
customPrice_1 |
decimal |
|
☐ |
|
customPrice |
boolean |
Aangepaste Prijs |
☐ |
|
deletedAt_1 |
datetime |
|
☐ |
|
deletedAt |
datetime |
|
☐ |
|
description |
string |
Omschrijving |
☐ |
|
extendedDescription |
string |
|
☐ |
|
extraFields_1 |
string |
|
☐ |
|
extraFields |
string |
|
☐ |
|
headerLevel |
string |
Koptekstniveau |
☐ |
|
id_1 |
string |
|
☐ |
|
id |
string |
ID |
☐ |
|
indirectCostFactor |
decimal |
Indirecte Kostenfactor |
☐ |
|
lineType |
string |
Regelsoort |
☐ |
|
lockedAt_1 |
datetime |
|
☐ |
|
lockedAt |
datetime |
|
☐ |
|
margin |
decimal |
Marge |
☐ |
|
name |
string |
Naam |
☐ |
|
nameTranslations |
string |
|
☐ |
|
newPage |
boolean |
Nieuwe Pagina |
☐ |
|
number |
string |
|
☐ |
|
postId |
string |
|
☐ |
Only present when obtained via bulk endpoint |
price |
decimal |
Prijs |
☐ |
|
quantity |
decimal |
|
☐ |
|
quantityFormula |
string |
|
☐ |
|
saleName |
string |
|
☐ |
|
totalExclVat |
decimal |
|
☐ |
|
totality |
boolean |
Totaliteit |
☐ |
|
type |
string |
Soort |
☐ |
|
unitType_1 |
string |
|
☐ |
|
unitType |
string |
Unitsoort |
☐ |
|
updatedAt_1 |
datetime |
|
☐ |
|
updatedAt |
datetime |
|
☐ |
|
vatTariffId |
string |
|
☐ |
|
28-09-2023 13:25 Versie 22.1.262-BETA+4120