ProjectCustomFields: Simplicate Project Custom Fields |
Fetches all projects
Catalog: Simplicate
Schema: Projects
Label: Project Custom Fields
This is a read-only table function. The Simplicate API may not support changing the data or the Invantive SQL driver for Simplicate does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Simplicate API.
Select Simplicate API URL: /projects/project
Insert Simplicate API URL: /projects/project
Update Simplicate API URL: /projects/project
Delete Simplicate API URL: /projects/project
Field Selection Method: NotRequired
Base Path: data[*].custom_fields[*]
Select Simplicate API Operation: get /projects/project
Table Function Columns
The columns of the table function ProjectCustomFields are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
abnormal_address |
boolean |
Abnormal Address |
☐ |
|
abnormal_contact_id |
string |
Abnormal Contact ID |
☐ |
|
abnormal_organization_id |
string |
Abnormal Organization ID |
☐ |
|
abnormal_person_id |
string |
Abnormal Person ID |
☐ |
|
billable |
boolean |
Billable |
☐ |
|
budget_costs_value_budget |
float |
|
☐ |
|
budget_costs_value_spent |
float |
|
☐ |
|
budget_hours_amount_budget |
float |
|
☐ |
|
budget_hours_amount_spent |
float |
|
☐ |
|
budget_hours_value_budget |
float |
|
☐ |
|
budget_hours_value_spent |
float |
|
☐ |
|
budget_total_value_budget |
float |
|
☐ |
|
budget_total_value_invoiced |
float |
|
☐ |
|
budget_total_value_spent |
float |
|
☐ |
|
can_register_mileage |
boolean |
Can Register Mileage |
☐ |
|
contact_id_1 |
string |
|
☐ |
|
contact_id |
string |
Contact ID |
☐ |
|
contact_organization_id |
string |
Contact Organization ID |
☐ |
|
contact_organization_name |
string |
Contact Organization Name |
☐ |
|
contact_person_full_name |
string |
Contact Person Full Name |
☐ |
|
contact_person_id |
string |
Contact Person ID |
☐ |
|
created_at |
string |
Created at |
☐ |
|
created |
string |
Created |
☐ |
|
custom_field_group_id |
string |
Custom Field Group ID |
☐ |
|
custom_field_group_model_id |
string |
Custom Field Group Model ID |
☐ |
|
custom_field_group_model_label |
string |
Custom Field Group Model Label |
☐ |
|
custom_field_group_name |
string |
Custom Field Group Name |
☐ |
|
custom_field_group_position |
string |
Custom Field Group Position |
☐ |
|
custom_field_group_type |
string |
Custom Field Group Type |
☐ |
|
divergent_payment_term_days |
int64 |
Divergent Payment Term (days) |
☐ |
|
divergent_payment_term_id |
string |
Divergent Payment Term ID |
☐ |
|
divergent_payment_term_method |
string |
Divergent Payment Term Method |
☐ |
|
divergent_payment_term_name |
string |
Divergent Payment Term Name |
☐ |
|
end_date |
string |
End Date |
☐ |
|
filterable |
boolean |
Filterable |
☐ |
|
hours_rate_type |
string |
Hours Rate Type |
☐ |
|
id_1 |
string |
|
☐ |
|
id |
string |
ID |
☐ |
|
invoice_reference |
string |
Invoice Reference |
☐ |
|
is_invoice_approval |
boolean |
Is Invoice Approval |
☐ |
|
is_reverse_billing |
boolean |
Is Reverse Billing |
☐ |
|
label |
string |
Label |
☐ |
|
modified |
string |
Modified |
☐ |
|
my_organization_profile_id_1 |
string |
|
☐ |
|
my_organization_profile_id |
string |
My Organization Profile ID |
☐ |
|
my_organization_profile_organization_id |
string |
|
☐ |
|
my_organization_profile_organization_name |
string |
|
☐ |
|
name_1 |
string |
|
☐ |
|
name |
string |
Name |
☐ |
|
note |
string |
Note |
☐ |
|
organization_id_1 |
string |
|
☐ |
|
organization_id |
string |
Organization ID |
☐ |
|
organization_name |
string |
Organization Name |
☐ |
|
person_full_name |
string |
Person Full Name |
☐ |
|
person_id_1 |
string |
|
☐ |
|
person_id |
string |
Person ID |
☐ |
|
position |
int64 |
Position |
☐ |
|
project_manager_amount |
float |
|
☐ |
|
project_manager_declarable |
string |
|
☐ |
|
project_manager_employee_id |
string |
|
☐ |
|
project_manager_id |
string |
|
☐ |
|
project_manager_name |
string |
|
☐ |
|
project_manager_person_id |
string |
|
☐ |
|
project_manager_tariff |
float |
|
☐ |
|
project_number |
string |
Project Number |
☐ |
|
project_status_color |
string |
Project Status Color |
☐ |
|
project_status_id |
string |
Project Status ID |
☐ |
|
project_status_label |
string |
Project Status Label |
☐ |
|
render_type |
string |
Render Type |
☐ |
|
searchable |
boolean |
Searchable |
☐ |
|
separate_invoice_recipient_contact_id |
string |
|
☐ |
|
separate_invoice_recipient_contact_organization_id |
string |
|
☐ |
|
separate_invoice_recipient_contact_organization_name |
string |
|
☐ |
|
separate_invoice_recipient_contact_person_full_name |
string |
|
☐ |
|
separate_invoice_recipient_contact_person_id |
string |
|
☐ |
|
separate_invoice_recipient_is_separate_invoice_recipient |
boolean |
|
☐ |
|
separate_invoice_recipient_organization_id |
string |
|
☐ |
|
separate_invoice_recipient_organization_name |
string |
|
☐ |
|
separate_invoice_recipient_person_full_name |
string |
|
☐ |
|
separate_invoice_recipient_person_id |
string |
|
☐ |
|
simplicate_url |
string |
Simplicate URL |
☐ |
|
start_date |
string |
Start Date |
☐ |
|
timeline_email_address |
string |
Timeline Email Address |
☐ |
|
type |
string |
Type |
☐ |
|
updated_at |
string |
Updated at |
☐ |
|
value_type |
string |
Value Type |
☐ |
|
value |
string |
Value |
☐ |
|
15-06-2022 20:27 Version 22.0.232-PROD+3445