ClaimStateById |
Find one
Catalog: Robaws
Schema: ClaimStates
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/claim-states/{id}
Insert Robaws API URL: /api/v2/claim-states/{id}
Update Robaws API URL: /api/v2/claim-states/{id}
Delete Robaws API URL: /api/v2/claim-states/{id}
Field Selection Method: NotRequired
Select Robaws API Operation: get /api/v2/claim-states/{id}
Table Function Columns
The columns of the table function ClaimStateById are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
archivedAt |
datetime |
|
☐ |
|
createdAt |
datetime |
|
☐ |
|
deletedAt |
datetime |
|
☐ |
|
endDate |
datetime |
End Date |
☐ |
|
id |
string |
ID |
☐ |
|
logicId |
string |
Logical ID |
☐ |
|
project_archivedAt |
datetime |
|
☐ |
|
project_checkInAtWork |
string |
|
☐ |
|
project_client_address_addressLine1 |
string |
|
☐ |
|
project_client_address_addressLine2 |
string |
|
☐ |
|
project_client_address_city |
string |
|
☐ |
|
project_client_address_country |
string |
|
☐ |
|
project_client_address_latitude |
double |
|
☐ |
|
project_client_address_longitude |
double |
|
☐ |
|
project_client_address_postalCode |
string |
|
☐ |
|
project_client_archivedAt |
datetime |
|
☐ |
|
project_client_assignedUserId |
string |
|
☐ |
|
project_client_createdAt |
datetime |
|
☐ |
|
project_client_deletedAt |
datetime |
|
☐ |
|
project_client_email |
string |
|
☐ |
|
project_client_fax |
string |
|
☐ |
|
project_client_generalLedgerAccount_archivedAt |
datetime |
|
☐ |
|
project_client_generalLedgerAccount_code |
string |
|
☐ |
|
project_client_generalLedgerAccount_createdAt |
datetime |
|
☐ |
|
project_client_generalLedgerAccount_deletedAt |
datetime |
|
☐ |
|
project_client_generalLedgerAccount_id |
string |
|
☐ |
|
project_client_generalLedgerAccount_name |
string |
|
☐ |
|
project_client_generalLedgerAccount_updatedAt |
datetime |
|
☐ |
|
project_client_generalLedgerAccountId |
string |
|
☐ |
|
project_client_gsm |
string |
|
☐ |
|
project_client_id |
string |
|
☐ |
|
project_client_invoiceAddress_addressLine1 |
string |
|
☐ |
|
project_client_invoiceAddress_addressLine2 |
string |
|
☐ |
|
project_client_invoiceAddress_city |
string |
|
☐ |
|
project_client_invoiceAddress_country |
string |
|
☐ |
|
project_client_invoiceAddress_latitude |
double |
|
☐ |
|
project_client_invoiceAddress_longitude |
double |
|
☐ |
|
project_client_invoiceAddress_postalCode |
string |
|
☐ |
|
project_client_invoiceEmail |
string |
|
☐ |
|
project_client_language |
string |
|
☐ |
|
project_client_legalForm_archivedAt |
datetime |
|
☐ |
|
project_client_legalForm_createdAt |
datetime |
|
☐ |
|
project_client_legalForm_deletedAt |
datetime |
|
☐ |
|
project_client_legalForm_id |
string |
|
☐ |
|
project_client_legalForm_legalAbbreviation |
string |
|
☐ |
|
project_client_legalForm_name |
string |
|
☐ |
|
project_client_legalForm_updatedAt |
datetime |
|
☐ |
|
project_client_legalForm_vatLiable |
boolean |
|
☐ |
|
project_client_legalFormId |
string |
|
☐ |
|
project_client_name |
string |
|
☐ |
|
project_client_paymentCondition_archivedAt |
datetime |
|
☐ |
|
project_client_paymentCondition_createdAt |
datetime |
|
☐ |
|
project_client_paymentCondition_deletedAt |
datetime |
|
☐ |
|
project_client_paymentCondition_id |
string |
|
☐ |
|
project_client_paymentCondition_name |
string |
|
☐ |
|
project_client_paymentCondition_purchase |
boolean |
|
☐ |
|
project_client_paymentCondition_sales |
boolean |
|
☐ |
|
project_client_paymentCondition_updatedAt |
datetime |
|
☐ |
|
project_client_paymentConditionId |
string |
|
☐ |
|
project_client_status |
string |
|
☐ |
|
project_client_statusDetails_color |
string |
|
☐ |
|
project_client_statusDetails_name |
string |
|
☐ |
|
project_client_tel |
string |
|
☐ |
|
project_client_title |
string |
|
☐ |
|
project_client_updatedAt |
datetime |
|
☐ |
|
project_client_vatIdNumber |
string |
|
☐ |
|
project_client_vatTariff_additionalMention |
string |
|
☐ |
|
project_client_vatTariff_archivedAt |
datetime |
|
☐ |
|
project_client_vatTariff_category |
string |
|
☐ |
|
project_client_vatTariff_createdAt |
datetime |
|
☐ |
|
project_client_vatTariff_deletedAt |
datetime |
|
☐ |
|
project_client_vatTariff_description |
string |
|
☐ |
|
project_client_vatTariff_id |
string |
|
☐ |
|
project_client_vatTariff_name |
string |
|
☐ |
|
project_client_vatTariff_percentage |
decimal |
|
☐ |
|
project_client_vatTariff_updatedAt |
datetime |
|
☐ |
|
project_client_vatTariffId |
string |
|
☐ |
|
project_client_website |
string |
|
☐ |
|
project_clientContact_archivedAt |
datetime |
|
☐ |
|
project_clientContact_createdAt |
datetime |
|
☐ |
|
project_clientContact_deletedAt |
datetime |
|
☐ |
|
project_clientContact_email |
string |
|
☐ |
|
project_clientContact_gsm |
string |
|
☐ |
|
project_clientContact_id |
string |
|
☐ |
|
project_clientContact_name |
string |
|
☐ |
|
project_clientContact_position |
string |
|
☐ |
|
project_clientContact_surname |
string |
|
☐ |
|
project_clientContact_tel |
string |
|
☐ |
|
project_clientContact_title |
string |
|
☐ |
|
project_clientContact_updatedAt |
datetime |
|
☐ |
|
project_clientContactId |
string |
|
☐ |
|
project_clientId |
string |
|
☐ |
|
project_clientReference |
string |
|
☐ |
|
project_createdAt |
datetime |
|
☐ |
|
project_date |
datetime |
|
☐ |
|
project_deletedAt |
datetime |
|
☐ |
|
project_distance |
int32 |
|
☐ |
|
project_endClient_address_addressLine1 |
string |
|
☐ |
|
project_endClient_address_addressLine2 |
string |
|
☐ |
|
project_endClient_address_city |
string |
|
☐ |
|
project_endClient_address_country |
string |
|
☐ |
|
project_endClient_address_latitude |
double |
|
☐ |
|
project_endClient_address_longitude |
double |
|
☐ |
|
project_endClient_address_postalCode |
string |
|
☐ |
|
project_endClient_archivedAt |
datetime |
|
☐ |
|
project_endClient_assignedUserId |
string |
|
☐ |
|
project_endClient_createdAt |
datetime |
|
☐ |
|
project_endClient_deletedAt |
datetime |
|
☐ |
|
project_endClient_email |
string |
|
☐ |
|
project_endClient_fax |
string |
|
☐ |
|
project_endClient_generalLedgerAccount_archivedAt |
datetime |
|
☐ |
|
project_endClient_generalLedgerAccount_code |
string |
|
☐ |
|
project_endClient_generalLedgerAccount_createdAt |
datetime |
|
☐ |
|
project_endClient_generalLedgerAccount_deletedAt |
datetime |
|
☐ |
|
project_endClient_generalLedgerAccount_id |
string |
|
☐ |
|
project_endClient_generalLedgerAccount_name |
string |
|
☐ |
|
project_endClient_generalLedgerAccount_updatedAt |
datetime |
|
☐ |
|
project_endClient_generalLedgerAccountId |
string |
|
☐ |
|
project_endClient_gsm |
string |
|
☐ |
|
project_endClient_id |
string |
|
☐ |
|
project_endClient_invoiceAddress_addressLine1 |
string |
|
☐ |
|
project_endClient_invoiceAddress_addressLine2 |
string |
|
☐ |
|
project_endClient_invoiceAddress_city |
string |
|
☐ |
|
project_endClient_invoiceAddress_country |
string |
|
☐ |
|
project_endClient_invoiceAddress_latitude |
double |
|
☐ |
|
project_endClient_invoiceAddress_longitude |
double |
|
☐ |
|
project_endClient_invoiceAddress_postalCode |
string |
|
☐ |
|
project_endClient_invoiceEmail |
string |
|
☐ |
|
project_endClient_language |
string |
|
☐ |
|
project_endClient_legalForm_archivedAt |
datetime |
|
☐ |
|
project_endClient_legalForm_createdAt |
datetime |
|
☐ |
|
project_endClient_legalForm_deletedAt |
datetime |
|
☐ |
|
project_endClient_legalForm_id |
string |
|
☐ |
|
project_endClient_legalForm_legalAbbreviation |
string |
|
☐ |
|
project_endClient_legalForm_name |
string |
|
☐ |
|
project_endClient_legalForm_updatedAt |
datetime |
|
☐ |
|
project_endClient_legalForm_vatLiable |
boolean |
|
☐ |
|
project_endClient_legalFormId |
string |
|
☐ |
|
project_endClient_name |
string |
|
☐ |
|
project_endClient_paymentCondition_archivedAt |
datetime |
|
☐ |
|
project_endClient_paymentCondition_createdAt |
datetime |
|
☐ |
|
project_endClient_paymentCondition_deletedAt |
datetime |
|
☐ |
|
project_endClient_paymentCondition_id |
string |
|
☐ |
|
project_endClient_paymentCondition_name |
string |
|
☐ |
|
project_endClient_paymentCondition_purchase |
boolean |
|
☐ |
|
project_endClient_paymentCondition_sales |
boolean |
|
☐ |
|
project_endClient_paymentCondition_updatedAt |
datetime |
|
☐ |
|
project_endClient_paymentConditionId |
string |
|
☐ |
|
project_endClient_status |
string |
|
☐ |
|
project_endClient_statusDetails_color |
string |
|
☐ |
|
project_endClient_statusDetails_name |
string |
|
☐ |
|
project_endClient_tel |
string |
|
☐ |
|
project_endClient_title |
string |
|
☐ |
|
project_endClient_updatedAt |
datetime |
|
☐ |
|
project_endClient_vatIdNumber |
string |
|
☐ |
|
project_endClient_vatTariff_additionalMention |
string |
|
☐ |
|
project_endClient_vatTariff_archivedAt |
datetime |
|
☐ |
|
project_endClient_vatTariff_category |
string |
|
☐ |
|
project_endClient_vatTariff_createdAt |
datetime |
|
☐ |
|
project_endClient_vatTariff_deletedAt |
datetime |
|
☐ |
|
project_endClient_vatTariff_description |
string |
|
☐ |
|
project_endClient_vatTariff_id |
string |
|
☐ |
|
project_endClient_vatTariff_name |
string |
|
☐ |
|
project_endClient_vatTariff_percentage |
decimal |
|
☐ |
|
project_endClient_vatTariff_updatedAt |
datetime |
|
☐ |
|
project_endClient_vatTariffId |
string |
|
☐ |
|
project_endClient_website |
string |
|
☐ |
|
project_endClientContact_archivedAt |
datetime |
|
☐ |
|
project_endClientContact_createdAt |
datetime |
|
☐ |
|
project_endClientContact_deletedAt |
datetime |
|
☐ |
|
project_endClientContact_email |
string |
|
☐ |
|
project_endClientContact_gsm |
string |
|
☐ |
|
project_endClientContact_id |
string |
|
☐ |
|
project_endClientContact_name |
string |
|
☐ |
|
project_endClientContact_position |
string |
|
☐ |
|
project_endClientContact_surname |
string |
|
☐ |
|
project_endClientContact_tel |
string |
|
☐ |
|
project_endClientContact_title |
string |
|
☐ |
|
project_endClientContact_updatedAt |
datetime |
|
☐ |
|
project_endClientContactId |
string |
|
☐ |
|
project_endClientId |
string |
|
☐ |
|
project_id |
string |
|
☐ |
|
project_logicId |
string |
|
☐ |
|
project_nssoDeclarationOfWorks |
string |
|
☐ |
|
project_planningName |
string |
|
☐ |
|
project_siteAddress_addressLine1 |
string |
|
☐ |
|
project_siteAddress_addressLine2 |
string |
|
☐ |
|
project_siteAddress_city |
string |
|
☐ |
|
project_siteAddress_country |
string |
|
☐ |
|
project_siteAddress_latitude |
double |
|
☐ |
|
project_siteAddress_longitude |
double |
|
☐ |
|
project_siteAddress_postalCode |
string |
|
☐ |
|
project_siteManager_archivedAt |
datetime |
|
☐ |
|
project_siteManager_createdAt |
datetime |
|
☐ |
|
project_siteManager_deletedAt |
datetime |
|
☐ |
|
project_siteManager_email |
string |
|
☐ |
|
project_siteManager_fullName |
string |
|
☐ |
|
project_siteManager_id |
string |
|
☐ |
|
project_siteManager_locked |
boolean |
|
☐ |
|
project_siteManager_updatedAt |
datetime |
|
☐ |
|
project_siteManagerId |
string |
|
☐ |
|
project_siteNssoIdNumber |
string |
|
☐ |
|
project_status |
string |
|
☐ |
|
project_statusDetails_color |
string |
|
☐ |
|
project_statusDetails_name |
string |
|
☐ |
|
project_updatedAt |
datetime |
|
☐ |
|
projectId |
string |
Project ID |
☐ |
|
startDate |
datetime |
Start Date |
☐ |
|
status |
string |
Status |
☐ |
|
totalExclVat |
decimal |
|
☐ |
|
totalInclVat |
decimal |
|
☐ |
|
totalRevision |
decimal |
|
☐ |
|
updatedAt |
datetime |
|
☐ |
|
17-06-2022 11:59 Version 22.1.46-BETA+3385