invantive documentation
Invantive Support ForumsLog In / Sign Up

CostExpenseAttachments: Simplicate itgen_spe_costexpenseattachments_plural

read only REST

  • Catalog: Simplicate
  • Schema: Costs
  • Label: itgen_spe_costexpenseattachments_plural

Fetches the expenses of employees

Can only retrieve data.

API Source

  • Endpoint: /costs/expense
  • Operation: get /costs/expense

Table Columns

The columns of the table CostExpenseAttachments 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_status_description varchar2 Approval Status Description
approval_status_label varchar2 Approval Status Label
costtype_budgeted_amount double Cost Type Budgeted Amount
costtype_costtype_blocked char Cost Type Blocked
costtype_costtype_id varchar2 Cost Type ID
costtype_costtype_is_attachment_allowed char itgen_spe_costtype_costtype_is_attachment_allowed
costtype_costtype_is_unit_tariff char itgen_spe_costtype_costtype_is_unit_tariff
costtype_costtype_label varchar2 itgen_spe_costtype_costtype_label
costtype_costtype_tariff double itgen_spe_costtype_costtype_tariff
costtype_costtype_unit_name varchar2 itgen_spe_costtype_costtype_unit_name
costtype_id varchar2 Cost Type ID
costtype_label varchar2 Cost Type Label
costtype_purchase_margin double Cost Type Purchase Margin
costtype_purchase_tariff double Cost Type Purchase Tariff
costtype_tariff double Cost Type Tariff
date varchar2 Date
default_costtype_blocked char itgen_spe_default_costtype_blocked
default_costtype_id varchar2 itgen_spe_default_costtype_id
default_costtype_is_attachment_allowed char itgen_spe_default_costtype_is_attachment_allowed
default_costtype_is_unit_tariff char itgen_spe_default_costtype_is_unit_tariff
default_costtype_label varchar2 itgen_spe_default_costtype_label
default_costtype_tariff double itgen_spe_default_costtype_tariff
default_costtype_unit_name varchar2 itgen_spe_default_costtype_unit_name
employee_amount double Employee Amount
employee_declarable varchar2 Employee Declarable
employee_employee_id varchar2 Employee ID
employee_id varchar2 Employee ID
employee_name varchar2 Employee Name
employee_person_id varchar2 Employee Person ID Added in order to comply with the original sales/sales responsible_employee response
employee_tariff double Employee Tariff
file_hash varchar2 itgen_spe_file_hash
file_name varchar2 itgen_spe_file_name
id varchar2 ID
invoice_comments varchar2 Invoice Comments
invoice_composition_type varchar2 Invoice Composition Type
invoice_contact_id varchar2 Invoice Contact ID
invoice_created varchar2 Invoice Created
invoice_created_at varchar2 Invoice Created at
invoice_date varchar2 Invoice Date
invoice_id varchar2 Invoice ID
invoice_invoice_number varchar2 Invoice Number
invoice_my_organization_profile_id varchar2 itgen_spe_invoice_my_organization_profile_id
invoice_my_organization_profile_id_2 varchar2 itgen_spe_invoice_my_organization_profile_id_2
invoice_my_organization_profile_organization_id varchar2 itgen_spe_invoice_my_organization_profile_organization_id
invoice_my_organization_profile_organization_name varchar2 itgen_spe_invoice_my_organization_profile_organization_name
invoice_my_organization_profile_organization_relation_number varchar2 itgen_spe_invoice_my_organization_profile_organization_relation_number
invoice_organization_id varchar2 itgen_spe_invoice_organization_id
invoice_organization_id_2 varchar2 itgen_spe_invoice_organization_id_2
invoice_organization_name varchar2 itgen_spe_invoice_organization_name
invoice_organization_relation_number varchar2 itgen_spe_invoice_organization_relation_number
invoice_payment_term_days int64 itgen_spe_invoice_payment_term_days
invoice_payment_term_id varchar2 itgen_spe_invoice_payment_term_id
invoice_payment_term_method varchar2 itgen_spe_invoice_payment_term_method
invoice_payment_term_name varchar2 itgen_spe_invoice_payment_term_name
invoice_person_full_name varchar2 itgen_spe_invoice_person_full_name
invoice_person_id varchar2 itgen_spe_invoice_person_id
invoice_person_id_2 varchar2 itgen_spe_invoice_person_id_2
invoice_person_relation_number varchar2 itgen_spe_invoice_person_relation_number
invoice_project_has_register_mileage_enabled char itgen_spe_invoice_project_has_register_mileage_enabled
invoice_project_id varchar2 itgen_spe_invoice_project_id
invoice_project_id_2 varchar2 itgen_spe_invoice_project_id_2
invoice_project_name varchar2 itgen_spe_invoice_project_name
invoice_project_organization_id varchar2 itgen_spe_invoice_project_organization_id
invoice_project_organization_name varchar2 itgen_spe_invoice_project_organization_name
invoice_project_organization_relation_number varchar2 itgen_spe_invoice_project_organization_relation_number
invoice_project_person_full_name varchar2 itgen_spe_invoice_project_person_full_name
invoice_project_person_id varchar2 itgen_spe_invoice_project_person_id
invoice_project_person_relation_number varchar2 itgen_spe_invoice_project_person_relation_number
invoice_project_project_manager_amount double itgen_spe_invoice_project_project_manager_amount
invoice_project_project_manager_declarable varchar2 itgen_spe_invoice_project_project_manager_declarable
invoice_project_project_manager_employee_id varchar2 itgen_spe_invoice_project_project_manager_employee_id
invoice_project_project_manager_id varchar2 itgen_spe_invoice_project_project_manager_id
invoice_project_project_manager_name varchar2 itgen_spe_invoice_project_project_manager_name
invoice_project_project_manager_person_id varchar2 itgen_spe_invoice_project_project_manager_person_id Added in order to comply with the original sales/sales responsible_employee response
invoice_project_project_manager_tariff double itgen_spe_invoice_project_project_manager_tariff
invoice_project_project_number varchar2 itgen_spe_invoice_project_project_number
invoice_reference varchar2 Invoice Reference
invoice_reminder_next_action varchar2 itgen_spe_invoice_reminder_next_action
invoice_reminder_paused char itgen_spe_invoice_reminder_paused
invoice_reminder_set_disabled char itgen_spe_invoice_reminder_set_disabled
invoice_reminder_set_label varchar2 itgen_spe_invoice_reminder_set_label
invoice_reminder_status varchar2 itgen_spe_invoice_reminder_status
invoice_sending_method varchar2 itgen_spe_invoice_sending_method
invoice_simplicate_url varchar2 itgen_spe_invoice_simplicate_url
invoice_status varchar2 Invoice Status
invoice_status_2 varchar2 itgen_spe_invoice_status_2
invoice_subject varchar2 Invoice Subject
invoice_subscription_cycle_end_date varchar2 itgen_spe_invoice_subscription_cycle_end_date
invoice_subscription_cycle_is_invoiced char itgen_spe_invoice_subscription_cycle_is_invoiced
invoice_subscription_cycle_start_date varchar2 itgen_spe_invoice_subscription_cycle_start_date
invoice_timeline_email_address varchar2 itgen_spe_invoice_timeline_email_address
invoice_total_excluding_vat double itgen_spe_invoice_total_excluding_vat
invoice_total_including_vat double itgen_spe_invoice_total_including_vat
invoice_total_outstanding double itgen_spe_invoice_total_outstanding
invoice_total_vat double itgen_spe_invoice_total_vat
invoice_updated_at varchar2 itgen_spe_invoice_updated_at
is_billable char Is Billable
note varchar2 Note
project_has_register_mileage_enabled char itgen_spe_project_has_register_mileage_enabled
project_id varchar2 Project ID
project_name varchar2 Project Name
project_organization_id varchar2 Project Organisation ID
project_organization_name varchar2 Project Organisation Name
project_organization_relation_number varchar2 itgen_spe_project_organization_relation_number
project_person_full_name varchar2 Project Person Full Name
project_person_id varchar2 Project Person ID
project_person_relation_number varchar2 itgen_spe_project_person_relation_number
project_project_manager_amount double Project Manager Amount
project_project_manager_declarable varchar2 Project Manager Declarable
project_project_manager_employee_id varchar2 Project Manager Employee ID
project_project_manager_id varchar2 Project Manager ID
project_project_manager_name varchar2 Project Manager Name
project_project_manager_person_id varchar2 Project Manager Person ID Added in order to comply with the original sales/sales responsible_employee response
project_project_manager_tariff double Project Manager Tariff
project_project_number varchar2 Project Number
purchase_margin double Purchase Margin
purchase_price_total double Purchase Price Total
purchase_price_unit double Purchase Unit Price
service_id varchar2 Service ID
service_purchase_end_date varchar2 itgen_spe_service_purchase_end_date
service_purchase_start_date varchar2 itgen_spe_service_purchase_start_date
tariff double Tariff
total_price double Total Price

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: