ExpenseCostsById: Simplicate Expense Costs by ID
read only REST
- Catalog:
Simplicate - Schema:
Costs - Label: Expense Costs by ID
Fetches a single expense for an employee
Can only retrieve data.
API Source
- Endpoint:
/costs/expense/{id} - Operation:
get /costs/expense/{id}
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
id |
`` | The template's id |
Table Columns
The columns of the table ExpenseCostsById 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 |
|---|---|---|---|---|---|
amount |
double |
Amount | |||
approval_ |
varchar2 |
Approval Status Description | |||
approval_ |
varchar2 |
Approval Status Label | |||
costtype_ |
double |
Cost Type Budgeted Amount | |||
costtype_ |
char |
Cost Type Blocked | |||
costtype_ |
varchar2 |
Cost Type ID | |||
costtype_ |
char |
itgen_spe_costtype_costtype_is_attachment_allowed | |||
costtype_ |
char |
itgen_spe_costtype_costtype_is_unit_tariff | |||
costtype_ |
varchar2 |
itgen_spe_costtype_costtype_label | |||
costtype_ |
double |
itgen_spe_costtype_costtype_tariff | |||
costtype_ |
varchar2 |
itgen_spe_costtype_costtype_unit_name | |||
costtype_ |
varchar2 |
Cost Type ID | |||
costtype_ |
varchar2 |
Cost Type Label | |||
costtype_ |
double |
Cost Type Purchase Margin | |||
costtype_ |
double |
Cost Type Purchase Tariff | |||
costtype_ |
double |
Cost Type Tariff | |||
date |
varchar2 |
Date | |||
default_ |
char |
itgen_spe_default_costtype_blocked | |||
default_ |
varchar2 |
itgen_spe_default_costtype_id | |||
default_ |
char |
itgen_spe_default_costtype_is_attachment_allowed | |||
default_ |
char |
itgen_spe_default_costtype_is_unit_tariff | |||
default_ |
varchar2 |
itgen_spe_default_costtype_label | |||
default_ |
double |
itgen_spe_default_costtype_tariff | |||
default_ |
varchar2 |
itgen_spe_default_costtype_unit_name | |||
employee_ |
double |
Employee Amount | |||
employee_ |
varchar2 |
Employee Declarable | |||
employee_ |
varchar2 |
Employee ID | |||
employee_ |
varchar2 |
Employee ID | |||
employee_ |
varchar2 |
Employee Name | |||
employee_ |
varchar2 |
Employee Person ID | Added in order to comply with the original sales/sales responsible_employee response | ||
employee_ |
double |
Employee Tariff | |||
id |
varchar2 |
ID | |||
invoice_ |
varchar2 |
Invoice Comments | |||
invoice_ |
varchar2 |
Invoice Composition Type | |||
invoice_ |
varchar2 |
Invoice Contact ID | |||
invoice_ |
varchar2 |
Invoice Created | |||
invoice_ |
varchar2 |
Invoice Created at | |||
invoice_ |
varchar2 |
Invoice Date | |||
invoice_ |
varchar2 |
Invoice ID | |||
invoice_ |
varchar2 |
Invoice Number | |||
invoice_ |
varchar2 |
itgen_spe_invoice_my_organization_profile_id | |||
invoice_ |
varchar2 |
itgen_spe_invoice_my_organization_profile_id_2 | |||
invoice_ |
varchar2 |
itgen_spe_invoice_my_organization_profile_organization_id | |||
invoice_ |
varchar2 |
itgen_spe_invoice_my_organization_profile_organization_name | |||
invoice_ |
varchar2 |
itgen_spe_invoice_my_organization_profile_organization_relation_number | |||
invoice_ |
varchar2 |
itgen_spe_invoice_organization_id | |||
invoice_ |
varchar2 |
itgen_spe_invoice_organization_id_2 | |||
invoice_ |
varchar2 |
itgen_spe_invoice_organization_name | |||
invoice_ |
varchar2 |
itgen_spe_invoice_organization_relation_number | |||
invoice_ |
int64 |
itgen_spe_invoice_payment_term_days | |||
invoice_ |
varchar2 |
itgen_spe_invoice_payment_term_id | |||
invoice_ |
varchar2 |
itgen_spe_invoice_payment_term_method | |||
invoice_ |
varchar2 |
itgen_spe_invoice_payment_term_name | |||
invoice_ |
varchar2 |
itgen_spe_invoice_person_full_name | |||
invoice_ |
varchar2 |
itgen_spe_invoice_person_id | |||
invoice_ |
varchar2 |
itgen_spe_invoice_person_id_2 | |||
invoice_ |
varchar2 |
itgen_spe_invoice_person_relation_number | |||
invoice_ |
char |
itgen_spe_invoice_project_has_register_mileage_enabled | |||
invoice_ |
varchar2 |
itgen_spe_invoice_project_id | |||
invoice_ |
varchar2 |
itgen_spe_invoice_project_id_2 | |||
invoice_ |
varchar2 |
itgen_spe_invoice_project_name | |||
invoice_ |
varchar2 |
itgen_spe_invoice_project_organization_id | |||
invoice_ |
varchar2 |
itgen_spe_invoice_project_organization_name | |||
invoice_ |
varchar2 |
itgen_spe_invoice_project_organization_relation_number | |||
invoice_ |
varchar2 |
itgen_spe_invoice_project_person_full_name | |||
invoice_ |
varchar2 |
itgen_spe_invoice_project_person_id | |||
invoice_ |
varchar2 |
itgen_spe_invoice_project_person_relation_number | |||
invoice_ |
double |
itgen_spe_invoice_project_project_manager_amount | |||
invoice_ |
varchar2 |
itgen_spe_invoice_project_project_manager_declarable | |||
invoice_ |
varchar2 |
itgen_spe_invoice_project_project_manager_employee_id | |||
invoice_ |
varchar2 |
itgen_spe_invoice_project_project_manager_id | |||
invoice_ |
varchar2 |
itgen_spe_invoice_project_project_manager_name | |||
invoice_ |
varchar2 |
itgen_spe_invoice_project_project_manager_person_id | Added in order to comply with the original sales/sales responsible_employee response | ||
invoice_ |
double |
itgen_spe_invoice_project_project_manager_tariff | |||
invoice_ |
varchar2 |
itgen_spe_invoice_project_project_number | |||
invoice_ |
varchar2 |
Invoice Reference | |||
invoice_ |
varchar2 |
itgen_spe_invoice_reminder_next_action | |||
invoice_ |
char |
itgen_spe_invoice_reminder_paused | |||
invoice_ |
char |
itgen_spe_invoice_reminder_set_disabled | |||
invoice_ |
varchar2 |
itgen_spe_invoice_reminder_set_label | |||
invoice_ |
varchar2 |
itgen_spe_invoice_reminder_status | |||
invoice_ |
varchar2 |
itgen_spe_invoice_sending_method | |||
invoice_ |
varchar2 |
itgen_spe_invoice_simplicate_url | |||
invoice_ |
varchar2 |
Invoice Status | |||
invoice_ |
varchar2 |
itgen_spe_invoice_status_2 | |||
invoice_ |
varchar2 |
Invoice Subject | |||
invoice_ |
varchar2 |
itgen_spe_invoice_subscription_cycle_end_date | |||
invoice_ |
char |
itgen_spe_invoice_subscription_cycle_is_invoiced | |||
invoice_ |
varchar2 |
itgen_spe_invoice_subscription_cycle_start_date | |||
invoice_ |
varchar2 |
itgen_spe_invoice_timeline_email_address | |||
invoice_ |
double |
itgen_spe_invoice_total_excluding_vat | |||
invoice_ |
double |
itgen_spe_invoice_total_including_vat | |||
invoice_ |
double |
itgen_spe_invoice_total_outstanding | |||
invoice_ |
double |
itgen_spe_invoice_total_vat | |||
invoice_ |
varchar2 |
itgen_spe_invoice_updated_at | |||
is_ |
char |
Is Billable | |||
note |
varchar2 |
Note | |||
project_ |
char |
itgen_spe_project_has_register_mileage_enabled | |||
project_ |
varchar2 |
Project ID | |||
project_ |
varchar2 |
Project Name | |||
project_ |
varchar2 |
Project Organisation ID | |||
project_ |
varchar2 |
Project Organisation Name | |||
project_ |
varchar2 |
itgen_spe_project_organization_relation_number | |||
project_ |
varchar2 |
Project Person Full Name | |||
project_ |
varchar2 |
Project Person ID | |||
project_ |
varchar2 |
itgen_spe_project_person_relation_number | |||
project_ |
double |
Project Manager Amount | |||
project_ |
varchar2 |
Project Manager Declarable | |||
project_ |
varchar2 |
Project Manager Employee ID | |||
project_ |
varchar2 |
Project Manager ID | |||
project_ |
varchar2 |
Project Manager Name | |||
project_ |
varchar2 |
Project Manager Person ID | Added in order to comply with the original sales/sales responsible_employee response | ||
project_ |
double |
Project Manager Tariff | |||
project_ |
varchar2 |
Project Number | |||
purchase_ |
double |
Purchase Margin | |||
purchase_ |
double |
Purchase Price Total | |||
purchase_ |
double |
Purchase Unit Price | |||
service_ |
varchar2 |
Service ID | |||
service_ |
varchar2 |
itgen_spe_service_purchase_end_date | |||
service_ |
varchar2 |
itgen_spe_service_purchase_start_date | |||
tariff |
double |
Tariff | |||
total_ |
double |
Total Price |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: