StockChangesFromSupplyOrder: ROBAWS Voorraadwijzigingen van leveringsorder |
Get stock change from supply order
Catalogus: Robaws
Schema: StockChanges
Label: Voorraadwijzigingen van leveringsorder
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.
Parameters van de tabelfunctie
De volgende parameters kunnen worden gebruikt om het gedrag van de tabelfunctie StockChangesFromSupplyOrder in te stellen. Voor verplichte parameters moet altijd een waarde worden opgegeven, maar optionele parameters hoeven in het algemeen geen waarde te hebben en de uitvoering zal standaard een vooraf bepaald gedrag vertonen. Waarden kunnen worden gespecificeerd op basis van positie en naam. In beide gevallen worden alle niet-gespecificeerde parameters geëvalueerd aan de hand van hun standaardwaarden.
Waardespecificatie op positie gebeurt door alle waarden van de eerste tot de laatste benodigde waarde op te sommen. Bijvoorbeeld: een `select * uit tabel(waarde1, waarde2, waarde3)` op een tabel met vier parameters zal de standaardwaarde voor de vierde parameter gebruiken en de opgegeven waarden voor de eerste drie.
Waardespecificatie op naam gebeurt door alle waarden die een waarde vereisen op te sommen. Bijvoorbeeld met `selecteer * uit tabel(naam1 => waarde1, naam3 => waarde3)` op dezelfde tabel zullen de standaardwaarden voor de tweede en vierde parameter worden gebruikt en de opgegeven waarden voor de eerste en derde.
Naam |
Datatype |
Verplicht |
Standaardwaarde |
Documentatie |
---|---|---|---|---|
supplyOrderId |
string |
☑ |
|
|
Kolommen van Tabelfunctie
De kolommen van de tabelfunctie StockChangesFromSupplyOrder worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
archivedAt |
datetime |
Gearchiveerd op |
☐ |
|
assignedEmployee__metadata_description |
string |
|
☐ |
|
assignedEmployee__metadata_href |
string |
|
☐ |
|
assignedEmployee__metadata_resource |
string |
|
☐ |
|
assignedEmployee__metadata_resourceTypeId |
string |
|
☐ |
|
assignedEmployee_archivedAt |
datetime |
|
☐ |
|
assignedEmployee_bankAccountNumber |
string |
|
☐ |
|
assignedEmployee_civilStatus |
string |
|
☐ |
|
assignedEmployee_collaborationEndDate |
datetime |
|
☐ |
|
assignedEmployee_collaborationStartDate |
datetime |
|
☐ |
|
assignedEmployee_competenceLevel |
string |
|
☐ |
|
assignedEmployee_costPerHour |
decimal |
|
☐ |
|
assignedEmployee_createdAt |
datetime |
|
☐ |
|
assignedEmployee_dateOfBirth |
datetime |
|
☐ |
|
assignedEmployee_defaultStockLocation_archivedAt |
datetime |
|
☐ |
|
assignedEmployee_defaultStockLocation_createdAt |
datetime |
|
☐ |
|
assignedEmployee_defaultStockLocation_deletedAt |
datetime |
|
☐ |
|
assignedEmployee_defaultStockLocation_extraFields |
string |
|
☐ |
|
assignedEmployee_defaultStockLocation_id |
string |
|
☐ |
|
assignedEmployee_defaultStockLocation_lockedAt |
datetime |
|
☐ |
|
assignedEmployee_defaultStockLocation_name |
string |
|
☐ |
|
assignedEmployee_defaultStockLocation_updatedAt |
datetime |
|
☐ |
|
assignedEmployee_defaultStockLocationId |
string |
|
☐ |
|
assignedEmployee_defaultTimeOperation_activityId |
string |
|
☐ |
|
assignedEmployee_defaultTimeOperation_archivedAt |
datetime |
|
☐ |
|
assignedEmployee_defaultTimeOperation_articleGroupId |
string |
|
☐ |
|
assignedEmployee_defaultTimeOperation_articleNumber |
string |
|
☐ |
|
assignedEmployee_defaultTimeOperation_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. |
assignedEmployee_defaultTimeOperation_backorderStock |
decimal |
|
☐ |
When reading, only present if requested via 'include' query parameter, otherwise null. |
assignedEmployee_defaultTimeOperation_barcode |
string |
|
☐ |
|
assignedEmployee_defaultTimeOperation_brand |
string |
|
☐ |
|
assignedEmployee_defaultTimeOperation_calculationType |
string |
|
☐ |
|
assignedEmployee_defaultTimeOperation_costPrice |
decimal |
|
☐ |
|
assignedEmployee_defaultTimeOperation_costPriceStrategy |
string |
|
☐ |
|
assignedEmployee_defaultTimeOperation_createdAt |
datetime |
|
☐ |
|
assignedEmployee_defaultTimeOperation_deletedAt |
datetime |
|
☐ |
|
assignedEmployee_defaultTimeOperation_description |
string |
|
☐ |
|
assignedEmployee_defaultTimeOperation_descriptionTranslations |
string |
|
☐ |
|
assignedEmployee_defaultTimeOperation_extraFields |
string |
|
☐ |
|
assignedEmployee_defaultTimeOperation_id |
string |
|
☐ |
|
assignedEmployee_defaultTimeOperation_installation |
boolean |
|
☐ |
|
assignedEmployee_defaultTimeOperation_lockedAt |
datetime |
|
☐ |
|
assignedEmployee_defaultTimeOperation_margin |
decimal |
|
☐ |
|
assignedEmployee_defaultTimeOperation_minimumStock |
decimal |
|
☐ |
|
assignedEmployee_defaultTimeOperation_name |
string |
|
☐ |
|
assignedEmployee_defaultTimeOperation_nameTranslations |
string |
|
☐ |
|
assignedEmployee_defaultTimeOperation_purchaseGLAccountId |
string |
|
☐ |
|
assignedEmployee_defaultTimeOperation_reservedStock |
decimal |
|
☐ |
When reading, only present if requested via 'include' query parameter, otherwise null. |
assignedEmployee_defaultTimeOperation_saleName |
string |
|
☐ |
|
assignedEmployee_defaultTimeOperation_salePrice |
decimal |
|
☐ |
|
assignedEmployee_defaultTimeOperation_salePriceStrategy |
string |
|
☐ |
|
assignedEmployee_defaultTimeOperation_salesGLAccountId |
string |
|
☐ |
|
assignedEmployee_defaultTimeOperation_stockArticle |
boolean |
|
☐ |
|
assignedEmployee_defaultTimeOperation_stockPlace |
string |
|
☐ |
|
assignedEmployee_defaultTimeOperation_targetStock |
decimal |
|
☐ |
|
assignedEmployee_defaultTimeOperation_timeOperation |
boolean |
|
☐ |
|
assignedEmployee_defaultTimeOperation_totalStock |
decimal |
|
☐ |
When reading, only present if requested via 'include' query parameter, otherwise null. |
assignedEmployee_defaultTimeOperation_type |
string |
|
☐ |
|
assignedEmployee_defaultTimeOperation_unitType |
string |
|
☐ |
|
assignedEmployee_defaultTimeOperation_updatedAt |
datetime |
|
☐ |
|
assignedEmployee_defaultTimeOperation_vatTariffId |
string |
|
☐ |
|
assignedEmployee_defaultTimeOperation_wappy |
boolean |
|
☐ |
|
assignedEmployee_defaultTimeOperationId |
string |
|
☐ |
|
assignedEmployee_deletedAt |
datetime |
|
☐ |
|
assignedEmployee_dimonaExpirationDate |
datetime |
|
☐ |
|
assignedEmployee_dimonaNumber |
string |
|
☐ |
|
assignedEmployee_distance |
decimal |
|
☐ |
|
assignedEmployee_domicileAddress_addressLine1 |
string |
|
☐ |
|
assignedEmployee_domicileAddress_addressLine2 |
string |
|
☐ |
|
assignedEmployee_domicileAddress_city |
string |
|
☐ |
|
assignedEmployee_domicileAddress_country |
string |
|
☐ |
|
assignedEmployee_domicileAddress_latitude |
double |
|
☐ |
|
assignedEmployee_domicileAddress_longitude |
double |
|
☐ |
|
assignedEmployee_domicileAddress_postalCode |
string |
|
☐ |
|
assignedEmployee_driverLicense |
string |
|
☐ |
|
assignedEmployee_email |
string |
|
☐ |
|
assignedEmployee_emergencyTel |
string |
|
☐ |
|
assignedEmployee_employeeRole_archivedAt |
datetime |
|
☐ |
|
assignedEmployee_employeeRole_createdAt |
datetime |
|
☐ |
|
assignedEmployee_employeeRole_deletedAt |
datetime |
|
☐ |
|
assignedEmployee_employeeRole_extraFields |
string |
|
☐ |
|
assignedEmployee_employeeRole_id |
string |
|
☐ |
|
assignedEmployee_employeeRole_lockedAt |
datetime |
|
☐ |
|
assignedEmployee_employeeRole_name |
string |
|
☐ |
|
assignedEmployee_employeeRole_updatedAt |
datetime |
|
☐ |
|
assignedEmployee_employeeRoleId |
string |
|
☐ |
|
assignedEmployee_employer_archivedAt |
datetime |
|
☐ |
|
assignedEmployee_employer_createdAt |
datetime |
|
☐ |
|
assignedEmployee_employer_deletedAt |
datetime |
|
☐ |
|
assignedEmployee_employer_email |
string |
|
☐ |
|
assignedEmployee_employer_extraFields |
string |
|
☐ |
|
assignedEmployee_employer_fax |
string |
|
☐ |
|
assignedEmployee_employer_generalLedgerAccountId |
string |
|
☐ |
|
assignedEmployee_employer_gsm |
string |
|
☐ |
|
assignedEmployee_employer_iban |
string |
|
☐ |
|
assignedEmployee_employer_id |
string |
|
☐ |
|
assignedEmployee_employer_invoiceRemarks |
string |
|
☐ |
|
assignedEmployee_employer_kvk |
string |
|
☐ |
|
assignedEmployee_employer_language |
string |
|
☐ |
|
assignedEmployee_employer_legalFormId |
string |
|
☐ |
|
assignedEmployee_employer_lockedAt |
datetime |
|
☐ |
|
assignedEmployee_employer_logicId |
string |
|
☐ |
|
assignedEmployee_employer_name |
string |
|
☐ |
|
assignedEmployee_employer_paymentConditionId |
string |
|
☐ |
|
assignedEmployee_employer_planningEmail |
string |
|
☐ |
|
assignedEmployee_employer_status |
string |
|
☐ |
|
assignedEmployee_employer_supplyOrderRemarks |
string |
|
☐ |
|
assignedEmployee_employer_tel |
string |
|
☐ |
|
assignedEmployee_employer_type |
string |
|
☐ |
|
assignedEmployee_employer_updatedAt |
datetime |
|
☐ |
|
assignedEmployee_employer_vatIdNumber |
string |
|
☐ |
|
assignedEmployee_employer_vatTariffId |
string |
|
☐ |
|
assignedEmployee_employer_website |
string |
|
☐ |
|
assignedEmployee_employerId |
string |
|
☐ |
|
assignedEmployee_extraFields |
string |
|
☐ |
|
assignedEmployee_grossSalary |
decimal |
|
☐ |
|
assignedEmployee_gsm |
string |
|
☐ |
|
assignedEmployee_id |
string |
|
☐ |
|
assignedEmployee_identityCardExpirationDate |
datetime |
|
☐ |
|
assignedEmployee_identityCardNumber |
string |
|
☐ |
|
assignedEmployee_image_archivedAt |
datetime |
|
☐ |
|
assignedEmployee_image_contentType |
string |
|
☐ |
|
assignedEmployee_image_createdAt |
datetime |
|
☐ |
|
assignedEmployee_image_deletedAt |
datetime |
|
☐ |
|
assignedEmployee_image_directory |
boolean |
|
☐ |
|
assignedEmployee_image_id |
string |
|
☐ |
|
assignedEmployee_image_lockedAt |
datetime |
|
☐ |
|
assignedEmployee_image_name |
string |
|
☐ |
|
assignedEmployee_image_parentId |
string |
|
☐ |
|
assignedEmployee_image_previewUrl |
string |
|
☐ |
|
assignedEmployee_image_size |
int64 |
|
☐ |
|
assignedEmployee_image_updatedAt |
datetime |
|
☐ |
|
assignedEmployee_image_url |
string |
|
☐ |
|
assignedEmployee_independentRegistration |
boolean |
|
☐ |
|
assignedEmployee_limosaExpirationDate |
datetime |
|
☐ |
|
assignedEmployee_limosaNumber |
string |
|
☐ |
|
assignedEmployee_lockedAt |
datetime |
|
☐ |
|
assignedEmployee_name |
string |
|
☐ |
|
assignedEmployee_nationality |
string |
|
☐ |
|
assignedEmployee_nssoIdNumber |
string |
|
☐ |
|
assignedEmployee_nssoPayment |
boolean |
|
☐ |
|
assignedEmployee_nssoPaymentExpirationDate |
datetime |
|
☐ |
|
assignedEmployee_numberOfDependents |
int32 |
|
☐ |
|
assignedEmployee_planningGroup |
string |
|
☐ |
|
assignedEmployee_position |
string |
|
☐ |
|
assignedEmployee_secondment |
boolean |
|
☐ |
|
assignedEmployee_status |
string |
|
☐ |
|
assignedEmployee_statute |
string |
|
☐ |
|
assignedEmployee_subType |
string |
|
☐ |
|
assignedEmployee_surname |
string |
|
☐ |
|
assignedEmployee_tel |
string |
|
☐ |
|
assignedEmployee_type |
string |
|
☐ |
|
assignedEmployee_updatedAt |
datetime |
|
☐ |
|
assignedEmployeeId |
string |
Toegewezen werknemers-ID |
☐ |
|
assignedSupplier__metadata_description |
string |
|
☐ |
|
assignedSupplier__metadata_href |
string |
|
☐ |
|
assignedSupplier__metadata_resource |
string |
|
☐ |
|
assignedSupplier__metadata_resourceTypeId |
string |
|
☐ |
|
assignedSupplier_archivedAt |
datetime |
|
☐ |
|
assignedSupplier_createdAt |
datetime |
|
☐ |
|
assignedSupplier_deletedAt |
datetime |
|
☐ |
|
assignedSupplier_email |
string |
|
☐ |
|
assignedSupplier_extraFields |
string |
|
☐ |
|
assignedSupplier_fax |
string |
|
☐ |
|
assignedSupplier_generalLedgerAccount_archivedAt |
datetime |
|
☐ |
|
assignedSupplier_generalLedgerAccount_code |
string |
|
☐ |
|
assignedSupplier_generalLedgerAccount_createdAt |
datetime |
|
☐ |
|
assignedSupplier_generalLedgerAccount_deletedAt |
datetime |
|
☐ |
|
assignedSupplier_generalLedgerAccount_extraFields |
string |
|
☐ |
|
assignedSupplier_generalLedgerAccount_id |
string |
|
☐ |
|
assignedSupplier_generalLedgerAccount_lockedAt |
datetime |
|
☐ |
|
assignedSupplier_generalLedgerAccount_name |
string |
|
☐ |
|
assignedSupplier_generalLedgerAccount_updatedAt |
datetime |
|
☐ |
|
assignedSupplier_generalLedgerAccountId |
string |
|
☐ |
|
assignedSupplier_gsm |
string |
|
☐ |
|
assignedSupplier_iban |
string |
|
☐ |
|
assignedSupplier_id |
string |
|
☐ |
|
assignedSupplier_invoiceAddress_addressLine1 |
string |
|
☐ |
|
assignedSupplier_invoiceAddress_addressLine2 |
string |
|
☐ |
|
assignedSupplier_invoiceAddress_city |
string |
|
☐ |
|
assignedSupplier_invoiceAddress_country |
string |
|
☐ |
|
assignedSupplier_invoiceAddress_latitude |
double |
|
☐ |
|
assignedSupplier_invoiceAddress_longitude |
double |
|
☐ |
|
assignedSupplier_invoiceAddress_postalCode |
string |
|
☐ |
|
assignedSupplier_invoiceRemarks |
string |
|
☐ |
|
assignedSupplier_kvk |
string |
|
☐ |
|
assignedSupplier_language |
string |
|
☐ |
|
assignedSupplier_legalForm_archivedAt |
datetime |
|
☐ |
|
assignedSupplier_legalForm_createdAt |
datetime |
|
☐ |
|
assignedSupplier_legalForm_deletedAt |
datetime |
|
☐ |
|
assignedSupplier_legalForm_extraFields |
string |
|
☐ |
|
assignedSupplier_legalForm_id |
string |
|
☐ |
|
assignedSupplier_legalForm_legalAbbreviation |
string |
|
☐ |
|
assignedSupplier_legalForm_lockedAt |
datetime |
|
☐ |
|
assignedSupplier_legalForm_name |
string |
|
☐ |
|
assignedSupplier_legalForm_updatedAt |
datetime |
|
☐ |
|
assignedSupplier_legalForm_vatLiable |
boolean |
|
☐ |
|
assignedSupplier_legalFormId |
string |
|
☐ |
|
assignedSupplier_lockedAt |
datetime |
|
☐ |
|
assignedSupplier_logicId |
string |
|
☐ |
|
assignedSupplier_name |
string |
|
☐ |
|
assignedSupplier_paymentConditionId |
string |
|
☐ |
|
assignedSupplier_planningEmail |
string |
|
☐ |
|
assignedSupplier_status |
string |
|
☐ |
|
assignedSupplier_statusDetails_color |
string |
|
☐ |
|
assignedSupplier_statusDetails_name |
string |
|
☐ |
|
assignedSupplier_supplyOrderRemarks |
string |
|
☐ |
|
assignedSupplier_tel |
string |
|
☐ |
|
assignedSupplier_type |
string |
|
☐ |
|
assignedSupplier_updatedAt |
datetime |
|
☐ |
|
assignedSupplier_vatIdNumber |
string |
|
☐ |
|
assignedSupplier_vatTariff_additionalMention |
string |
|
☐ |
|
assignedSupplier_vatTariff_archivedAt |
datetime |
|
☐ |
|
assignedSupplier_vatTariff_category |
string |
|
☐ |
|
assignedSupplier_vatTariff_createdAt |
datetime |
|
☐ |
|
assignedSupplier_vatTariff_deletedAt |
datetime |
|
☐ |
|
assignedSupplier_vatTariff_description |
string |
|
☐ |
|
assignedSupplier_vatTariff_excludedFromFinancialDiscount |
boolean |
|
☐ |
|
assignedSupplier_vatTariff_extraFields |
string |
|
☐ |
|
assignedSupplier_vatTariff_id |
string |
|
☐ |
|
assignedSupplier_vatTariff_inclusive |
boolean |
|
☐ |
|
assignedSupplier_vatTariff_lockedAt |
datetime |
|
☐ |
|
assignedSupplier_vatTariff_name |
string |
|
☐ |
|
assignedSupplier_vatTariff_percentage |
decimal |
|
☐ |
|
assignedSupplier_vatTariff_updatedAt |
datetime |
|
☐ |
|
assignedSupplier_vatTariffId |
string |
|
☐ |
|
assignedSupplier_website |
string |
|
☐ |
|
assignedSupplierId |
string |
Toegewezen leverancier-ID |
☐ |
|
assignedUser__metadata_description |
string |
|
☐ |
|
assignedUser__metadata_href |
string |
|
☐ |
|
assignedUser__metadata_resource |
string |
|
☐ |
|
assignedUser__metadata_resourceTypeId |
string |
|
☐ |
|
assignedUser_archivedAt |
datetime |
|
☐ |
|
assignedUser_createdAt |
datetime |
|
☐ |
|
assignedUser_deletedAt |
datetime |
|
☐ |
|
assignedUser_email |
string |
|
☐ |
|
assignedUser_emailAccount_from |
string |
|
☐ |
|
assignedUser_emailAccountActive |
boolean |
|
☐ |
|
assignedUser_extraFields |
string |
|
☐ |
|
assignedUser_fullName |
string |
|
☐ |
|
assignedUser_id |
string |
|
☐ |
|
assignedUser_locale |
string |
|
☐ |
|
assignedUser_locked |
boolean |
|
☐ |
|
assignedUser_lockedAt |
datetime |
|
☐ |
|
assignedUser_updatedAt |
datetime |
|
☐ |
|
assignedUserId |
string |
Toegewezen gebruikers-ID |
☐ |
|
booked |
boolean |
Geboekt |
☐ |
|
c_metadata_description |
string |
|
☐ |
|
c_metadata_href |
string |
|
☐ |
|
c_metadata_resource |
string |
|
☐ |
|
c_metadata_resourceTypeId |
string |
|
☐ |
|
createdAt |
datetime |
Gemaakt op |
☐ |
|
date |
datetime |
Datum |
☐ |
|
deletedAt |
datetime |
Geschrapt bij |
☐ |
|
description |
string |
Omschrijving |
☐ |
|
enumeration |
boolean |
Opsomming |
☐ |
|
extraFields |
string |
Extra velden |
☐ |
|
fromLocation__metadata_description |
string |
|
☐ |
|
fromLocation__metadata_href |
string |
|
☐ |
|
fromLocation__metadata_resource |
string |
|
☐ |
|
fromLocation__metadata_resourceTypeId |
string |
|
☐ |
|
fromLocation_archivedAt |
datetime |
|
☐ |
|
fromLocation_createdAt |
datetime |
|
☐ |
|
fromLocation_deletedAt |
datetime |
|
☐ |
|
fromLocation_extraFields |
string |
|
☐ |
|
fromLocation_id |
string |
|
☐ |
|
fromLocation_lockedAt |
datetime |
|
☐ |
|
fromLocation_name |
string |
|
☐ |
|
fromLocation_updatedAt |
datetime |
|
☐ |
|
fromLocationId |
string |
Van plaats ID |
☐ |
|
id |
string |
ID |
☐ |
|
lockedAt |
datetime |
Gesloten op |
☐ |
|
logicId |
string |
Logische ID |
☐ |
|
status |
string |
Status |
☐ |
|
supplyOrder__metadata_description |
string |
|
☐ |
|
supplyOrder__metadata_href |
string |
|
☐ |
|
supplyOrder__metadata_resource |
string |
|
☐ |
|
supplyOrder__metadata_resourceTypeId |
string |
|
☐ |
|
supplyOrder_archivedAt |
datetime |
|
☐ |
|
supplyOrder_assignedUser_archivedAt |
datetime |
|
☐ |
|
supplyOrder_assignedUser_createdAt |
datetime |
|
☐ |
|
supplyOrder_assignedUser_deletedAt |
datetime |
|
☐ |
|
supplyOrder_assignedUser_email |
string |
|
☐ |
|
supplyOrder_assignedUser_emailAccountActive |
boolean |
|
☐ |
|
supplyOrder_assignedUser_extraFields |
string |
|
☐ |
|
supplyOrder_assignedUser_fullName |
string |
|
☐ |
|
supplyOrder_assignedUser_id |
string |
|
☐ |
|
supplyOrder_assignedUser_locale |
string |
|
☐ |
|
supplyOrder_assignedUser_locked |
boolean |
|
☐ |
|
supplyOrder_assignedUser_lockedAt |
datetime |
|
☐ |
|
supplyOrder_assignedUser_updatedAt |
datetime |
|
☐ |
|
supplyOrder_assignedUserId |
string |
|
☐ |
|
supplyOrder_completionPercentage |
decimal |
|
☐ |
When reading, only present if requested via 'include' query parameter, otherwise null. |
supplyOrder_createdAt |
datetime |
|
☐ |
|
supplyOrder_deletedAt |
datetime |
|
☐ |
|
supplyOrder_extraFields |
string |
|
☐ |
|
supplyOrder_id |
string |
|
☐ |
|
supplyOrder_lockedAt |
datetime |
|
☐ |
|
supplyOrder_logicId |
string |
|
☐ |
|
supplyOrder_remark |
string |
|
☐ |
|
supplyOrder_status |
string |
|
☐ |
|
supplyOrder_statusDetails_color |
string |
|
☐ |
|
supplyOrder_statusDetails_name |
string |
|
☐ |
|
supplyOrder_type |
string |
|
☐ |
|
supplyOrder_updatedAt |
datetime |
|
☐ |
|
supplyOrderId |
string |
Leveringsbestel-ID |
☐ |
|
toClient__metadata_description |
string |
|
☐ |
|
toClient__metadata_href |
string |
|
☐ |
|
toClient__metadata_resource |
string |
|
☐ |
|
toClient__metadata_resourceTypeId |
string |
|
☐ |
|
toClient_address_addressLine1 |
string |
|
☐ |
|
toClient_address_addressLine2 |
string |
|
☐ |
|
toClient_address_city |
string |
|
☐ |
|
toClient_address_country |
string |
|
☐ |
|
toClient_address_latitude |
double |
|
☐ |
|
toClient_address_longitude |
double |
|
☐ |
|
toClient_address_postalCode |
string |
|
☐ |
|
toClient_archivedAt |
datetime |
|
☐ |
|
toClient_assignedUser_archivedAt |
datetime |
|
☐ |
|
toClient_assignedUser_createdAt |
datetime |
|
☐ |
|
toClient_assignedUser_deletedAt |
datetime |
|
☐ |
|
toClient_assignedUser_email |
string |
|
☐ |
|
toClient_assignedUser_emailAccountActive |
boolean |
|
☐ |
|
toClient_assignedUser_extraFields |
string |
|
☐ |
|
toClient_assignedUser_fullName |
string |
|
☐ |
|
toClient_assignedUser_id |
string |
|
☐ |
|
toClient_assignedUser_locale |
string |
|
☐ |
|
toClient_assignedUser_locked |
boolean |
|
☐ |
|
toClient_assignedUser_lockedAt |
datetime |
|
☐ |
|
toClient_assignedUser_updatedAt |
datetime |
|
☐ |
|
toClient_assignedUserId |
string |
|
☐ |
|
toClient_createdAt |
datetime |
|
☐ |
|
toClient_creditStatus |
string |
|
☐ |
|
toClient_deletedAt |
datetime |
|
☐ |
|
toClient_email |
string |
|
☐ |
|
toClient_extraFields |
string |
|
☐ |
|
toClient_fax |
string |
|
☐ |
|
toClient_followUpDate |
datetime |
|
☐ |
|
toClient_generalLedgerAccount_archivedAt |
datetime |
|
☐ |
|
toClient_generalLedgerAccount_code |
string |
|
☐ |
|
toClient_generalLedgerAccount_createdAt |
datetime |
|
☐ |
|
toClient_generalLedgerAccount_deletedAt |
datetime |
|
☐ |
|
toClient_generalLedgerAccount_extraFields |
string |
|
☐ |
|
toClient_generalLedgerAccount_id |
string |
|
☐ |
|
toClient_generalLedgerAccount_lockedAt |
datetime |
|
☐ |
|
toClient_generalLedgerAccount_name |
string |
|
☐ |
|
toClient_generalLedgerAccount_updatedAt |
datetime |
|
☐ |
|
toClient_generalLedgerAccountId |
string |
|
☐ |
|
toClient_gsm |
string |
|
☐ |
|
toClient_id |
string |
|
☐ |
|
toClient_invoiceAddress_addressLine1 |
string |
|
☐ |
|
toClient_invoiceAddress_addressLine2 |
string |
|
☐ |
|
toClient_invoiceAddress_city |
string |
|
☐ |
|
toClient_invoiceAddress_country |
string |
|
☐ |
|
toClient_invoiceAddress_latitude |
double |
|
☐ |
|
toClient_invoiceAddress_longitude |
double |
|
☐ |
|
toClient_invoiceAddress_postalCode |
string |
|
☐ |
|
toClient_invoiceEmail |
string |
|
☐ |
|
toClient_language |
string |
|
☐ |
|
toClient_legalForm_archivedAt |
datetime |
|
☐ |
|
toClient_legalForm_createdAt |
datetime |
|
☐ |
|
toClient_legalForm_deletedAt |
datetime |
|
☐ |
|
toClient_legalForm_extraFields |
string |
|
☐ |
|
toClient_legalForm_id |
string |
|
☐ |
|
toClient_legalForm_legalAbbreviation |
string |
|
☐ |
|
toClient_legalForm_lockedAt |
datetime |
|
☐ |
|
toClient_legalForm_name |
string |
|
☐ |
|
toClient_legalForm_updatedAt |
datetime |
|
☐ |
|
toClient_legalForm_vatLiable |
boolean |
|
☐ |
|
toClient_legalFormId |
string |
|
☐ |
|
toClient_lockedAt |
datetime |
|
☐ |
|
toClient_name |
string |
|
☐ |
|
toClient_paymentCondition_archivedAt |
datetime |
|
☐ |
|
toClient_paymentCondition_createdAt |
datetime |
|
☐ |
|
toClient_paymentCondition_deletedAt |
datetime |
|
☐ |
|
toClient_paymentCondition_extraFields |
string |
|
☐ |
|
toClient_paymentCondition_id |
string |
|
☐ |
|
toClient_paymentCondition_lockedAt |
datetime |
|
☐ |
|
toClient_paymentCondition_name |
string |
|
☐ |
|
toClient_paymentCondition_purchase |
boolean |
|
☐ |
|
toClient_paymentCondition_sales |
boolean |
|
☐ |
|
toClient_paymentCondition_updatedAt |
datetime |
|
☐ |
|
toClient_paymentConditionId |
string |
|
☐ |
|
toClient_priceGroupId |
string |
|
☐ |
|
toClient_status |
string |
|
☐ |
|
toClient_statusDetails_color |
string |
|
☐ |
|
toClient_statusDetails_name |
string |
|
☐ |
|
toClient_tel |
string |
|
☐ |
|
toClient_title |
string |
|
☐ |
|
toClient_updatedAt |
datetime |
|
☐ |
|
toClient_vatIdNumber |
string |
|
☐ |
|
toClient_vatTariff_additionalMention |
string |
|
☐ |
|
toClient_vatTariff_archivedAt |
datetime |
|
☐ |
|
toClient_vatTariff_category |
string |
|
☐ |
|
toClient_vatTariff_createdAt |
datetime |
|
☐ |
|
toClient_vatTariff_deletedAt |
datetime |
|
☐ |
|
toClient_vatTariff_description |
string |
|
☐ |
|
toClient_vatTariff_excludedFromFinancialDiscount |
boolean |
|
☐ |
|
toClient_vatTariff_extraFields |
string |
|
☐ |
|
toClient_vatTariff_id |
string |
|
☐ |
|
toClient_vatTariff_inclusive |
boolean |
|
☐ |
|
toClient_vatTariff_lockedAt |
datetime |
|
☐ |
|
toClient_vatTariff_name |
string |
|
☐ |
|
toClient_vatTariff_percentage |
decimal |
|
☐ |
|
toClient_vatTariff_updatedAt |
datetime |
|
☐ |
|
toClient_vatTariffId |
string |
|
☐ |
|
toClient_website |
string |
|
☐ |
|
toClientId |
string |
Naar klant-ID |
☐ |
|
toLocation__metadata_description |
string |
|
☐ |
|
toLocation__metadata_href |
string |
|
☐ |
|
toLocation__metadata_resource |
string |
|
☐ |
|
toLocation__metadata_resourceTypeId |
string |
|
☐ |
|
toLocation_archivedAt |
datetime |
|
☐ |
|
toLocation_createdAt |
datetime |
|
☐ |
|
toLocation_deletedAt |
datetime |
|
☐ |
|
toLocation_extraFields |
string |
|
☐ |
|
toLocation_id |
string |
|
☐ |
|
toLocation_lockedAt |
datetime |
|
☐ |
|
toLocation_name |
string |
|
☐ |
|
toLocation_updatedAt |
datetime |
|
☐ |
|
toLocationId |
string |
Naar locatie ID |
☐ |
|
updatedAt |
datetime |
Bijgewerkt op |
☐ |
|
30-09-2023 07:40 Versie 23.0.49-PROD+4237