ProjectCustomFields: Simplicate Project Custom Fields
read only REST
- Catalog:
Simplicate - Schema:
Projects - Label: Project Custom Fields
Fetches all projects
Can only retrieve data.
API Source
- Endpoint:
/projects/project - Operation:
get /projects/project
Table Columns
The columns of the table ProjectCustomFields are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
abnormal_ |
char |
Abnormal Address | |||
abnormal_ |
varchar2 |
Abnormal Contact ID | |||
abnormal_ |
varchar2 |
Abnormal Organisation ID | |||
abnormal_ |
varchar2 |
Abnormal Person ID | |||
billable |
char |
Billable | |||
budget_ |
double |
itgen_spe_budget_costs_value_budget | |||
budget_ |
double |
itgen_spe_budget_costs_value_spent | |||
budget_ |
double |
itgen_spe_budget_hours_amount_budget | |||
budget_ |
double |
itgen_spe_budget_hours_amount_spent | |||
budget_ |
double |
itgen_spe_budget_hours_value_budget | |||
budget_ |
double |
itgen_spe_budget_hours_value_spent | |||
budget_ |
double |
itgen_spe_budget_total_value_budget | |||
budget_ |
double |
itgen_spe_budget_total_value_invoiced | |||
budget_ |
double |
itgen_spe_budget_total_value_spent | |||
can_ |
char |
Can Register Mileage | |||
contact_ |
varchar2 |
Contact ID | |||
contact_ |
varchar2 |
itgen_spe_contact_id_2 | |||
contact_ |
varchar2 |
Contact Organisation ID | |||
contact_ |
varchar2 |
Contact Organisation Name | |||
contact_ |
varchar2 |
itgen_spe_contact_organization_relation_number | |||
contact_ |
varchar2 |
Contact Person Full Name | |||
contact_ |
varchar2 |
Contact Person ID | |||
contact_ |
varchar2 |
itgen_spe_contact_person_relation_number | |||
copied_ |
char |
itgen_spe_copied_from_project_has_register_mileage_enabled | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_id | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_name | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_organization_id | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_organization_name | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_organization_relation_number | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_person_full_name | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_person_id | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_person_relation_number | |||
copied_ |
double |
itgen_spe_copied_from_project_project_manager_amount | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_project_manager_declarable | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_project_manager_employee_id | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_project_manager_id | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_project_manager_name | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_project_manager_person_id | Added in order to comply with the original sales/sales responsible_employee response | ||
copied_ |
double |
itgen_spe_copied_from_project_project_manager_tariff | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_project_number | |||
created |
varchar2 |
Created | |||
created_ |
varchar2 |
Created at | |||
custom_ |
varchar2 |
Custom Field Group ID | |||
custom_ |
varchar2 |
Custom Field Group Model ID | |||
custom_ |
varchar2 |
Custom Field Group Model Label | |||
custom_ |
varchar2 |
Custom Field Group Name | |||
custom_ |
varchar2 |
Custom Field Group Position | |||
custom_ |
varchar2 |
Custom Field Group Type | |||
divergent_ |
int64 |
Divergent Payment Term (days) | |||
divergent_ |
varchar2 |
Divergent Payment Term ID | |||
divergent_ |
varchar2 |
Divergent Payment Term Method | |||
divergent_ |
varchar2 |
Divergent Payment Term Name | |||
end_ |
varchar2 |
End Date | |||
filterable |
char |
Filterable | |||
hours_ |
varchar2 |
Hours Rate Type | |||
id |
varchar2 |
ID | |||
id_2 |
varchar2 |
itgen_spe_id_2 | |||
invoice_ |
varchar2 |
Invoice Reference | |||
is_ |
char |
Is Invoice Approval | |||
is_ |
char |
Is Reverse Billing | |||
label |
varchar2 |
Label | |||
mandatory |
char |
itgen_spe_mandatory | |||
modified |
varchar2 |
Modified | |||
my_ |
varchar2 |
My Organisation Profile ID | |||
my_ |
varchar2 |
itgen_spe_my_organization_profile_id_2 | |||
my_ |
varchar2 |
itgen_spe_my_organization_profile_organization_id | |||
my_ |
varchar2 |
itgen_spe_my_organization_profile_organization_name | |||
my_ |
varchar2 |
itgen_spe_my_organization_profile_organization_relation_number | |||
name |
varchar2 |
Name | |||
name_2 |
varchar2 |
itgen_spe_name_2 | |||
note |
varchar2 |
Note | |||
organization_ |
varchar2 |
Organisation ID | |||
organization_ |
varchar2 |
itgen_spe_organization_id_2 | |||
organization_ |
varchar2 |
Organisation Name | |||
organization_ |
varchar2 |
itgen_spe_organization_relation_number | |||
person_ |
varchar2 |
Person Full Name | |||
person_ |
varchar2 |
Person ID | |||
person_ |
varchar2 |
itgen_spe_person_id_2 | |||
person_ |
varchar2 |
itgen_spe_person_relation_number | |||
position |
int64 |
Position | |||
project_ |
double |
itgen_spe_project_manager_amount | |||
project_ |
varchar2 |
itgen_spe_project_manager_declarable | |||
project_ |
varchar2 |
itgen_spe_project_manager_employee_id | |||
project_ |
varchar2 |
itgen_spe_project_manager_id | |||
project_ |
varchar2 |
itgen_spe_project_manager_name | |||
project_ |
varchar2 |
itgen_spe_project_manager_person_id | Added in order to comply with the original sales/sales responsible_employee response | ||
project_ |
double |
itgen_spe_project_manager_tariff | |||
project_ |
varchar2 |
Project Number | |||
project_ |
varchar2 |
Project Status Colour | |||
project_ |
varchar2 |
Project Status ID | |||
project_ |
varchar2 |
Project Status Label | |||
render_ |
varchar2 |
Render Type | |||
searchable |
char |
Searchable | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_contact_id | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_contact_organization_id | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_contact_organization_name | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_contact_organization_relation_number | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_contact_person_full_name | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_contact_person_id | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_contact_person_relation_number | |||
separate_ |
char |
itgen_spe_separate_invoice_recipient_is_separate_invoice_recipient | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_organization_id | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_organization_name | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_organization_relation_number | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_person_full_name | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_person_id | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_person_relation_number | |||
simplicate_ |
varchar2 |
Simplicate URL | |||
start_ |
varchar2 |
Start Date | |||
timeline_ |
varchar2 |
Timeline Email Address | |||
type |
varchar2 |
Type | |||
updated_ |
varchar2 |
Updated at | |||
value |
varchar2 |
Value | |||
value_ |
varchar2 |
Value Type |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: