Please enable JavaScript to view this site.

Navigation: Schema: Costs > Tables

Costs_DataAttachmentsExpense

Fetches the expenses of employees

Catalog: Simplicate

Schema: Costs

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: /costs/expense

Insert Simplicate API URL: /costs/expense

Update Simplicate API URL: /costs/expense

Delete Simplicate API URL: /costs/expense

Field Selection Method: NotRequired

Base Path: data[*].attachments[*]

Select Simplicate API Operation: get /costs/expense

Table Function Columns

The columns of the table function Costs_DataAttachmentsExpense are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

amount

float

Amount

 

approval_status_description

string

Approval Status Description

 

approval_status_label

string

Approval Status Label

 

costtype_budgeted_amount

float

Cost Type Budgeted Amount

 

costtype_costtype_blocked

boolean

Cost Type Blocked

 

costtype_costtype_id

string

Cost Type ID

 

costtype_costtype_is_attachment_allowed

boolean

 

 

costtype_costtype_is_unit_tariff

boolean

 

 

costtype_costtype_label

string

 

 

costtype_costtype_tariff

float

 

 

costtype_costtype_unit_name

string

 

 

costtype_id

string

Cost Type ID

 

costtype_label

string

Cost Type Label

 

costtype_purchase_margin

float

Cost Type Purchase Margin

 

costtype_purchase_tariff

float

Cost Type Purchase Tariff

 

costtype_tariff

float

Cost Type Tariff

 

date

string

Date

 

employee_amount

float

Employee Amount

 

employee_declarable

string

Employee Declarable

 

employee_employee_id

string

Employee ID

 

employee_id

string

Employee ID

 

employee_name

string

Employee Name

 

employee_person_id

string

Employee Person ID

 

employee_tariff

float

Employee Tariff

 

file_hash

string

 

 

file_name

string

 

 

id

string

ID

 

invoice_comments

string

Invoice Comments

 

invoice_composition_type

string

Invoice Composition Type

 

invoice_contact_id

string

Invoice Contact ID

 

invoice_created_at

string

Invoice Created at

 

invoice_created

string

Invoice Created

 

invoice_date

string

Invoice Date

 

invoice_id

string

Invoice ID

 

invoice_invoice_number

string

Invoice Number

 

invoice_my_organization_profile_id_1

string

 

 

invoice_my_organization_profile_id

string

 

 

invoice_my_organization_profile_organization_id

string

 

 

invoice_my_organization_profile_organization_name

string

 

 

invoice_organization_id_1

string

 

 

invoice_organization_id

string

 

 

invoice_organization_name

string

 

 

invoice_payment_term_days

int64

 

 

invoice_payment_term_id

string

 

 

invoice_payment_term_method

string

 

 

invoice_payment_term_name

string

 

 

invoice_person_full_name

string

 

 

invoice_person_id_1

string

 

 

invoice_person_id

string

 

 

invoice_project_id_1

string

 

 

invoice_project_id

string

 

 

invoice_project_name

string

 

 

invoice_project_organization_id

string

 

 

invoice_project_organization_name

string

 

 

invoice_project_person_full_name

string

 

 

invoice_project_person_id

string

 

 

invoice_project_project_manager_amount

float

 

 

invoice_project_project_manager_declarable

string

 

 

invoice_project_project_manager_employee_id

string

 

 

invoice_project_project_manager_id

string

 

 

invoice_project_project_manager_name

string

 

 

invoice_project_project_manager_person_id

string

 

 

invoice_project_project_manager_tariff

float

 

 

invoice_project_project_number

string

 

 

invoice_project_separate_invoice_recipient_is_separate_invoice_recipient

boolean

 

 

invoice_reference

string

Invoice Reference

 

invoice_reminder_next_action

string

 

 

invoice_reminder_paused

boolean

 

 

invoice_reminder_set_disabled

boolean

 

 

invoice_reminder_set_id

string

 

 

invoice_reminder_set_label

string

 

 

invoice_sending_method

string

 

 

invoice_simplicate_url

string

 

 

invoice_status_1

string

 

 

invoice_status

string

Invoice Status

 

invoice_subject

string

Invoice Subject

 

invoice_subscription_cycle_end_date

string

 

 

invoice_subscription_cycle_is_invoiced

boolean

 

 

invoice_subscription_cycle_start_date

string

 

 

invoice_timeline_email_address

string

 

 

invoice_total_excluding_vat

float

 

 

invoice_total_including_vat

float

 

 

invoice_total_outstanding

float

 

 

invoice_total_vat

float

 

 

invoice_updated_at

string

 

 

is_billable

boolean

Is Billable

 

note

string

Note

 

project_id

string

Project ID

 

project_name

string

Project Name

 

project_organization_id

string

Project Organization ID

 

project_organization_name

string

Project Organization Name

 

project_person_full_name

string

Project Person Full Name

 

project_person_id

string

Project Person ID

 

project_project_manager_amount

float

Project Manager Amount

 

project_project_manager_declarable

string

Project Manager Declarable

 

project_project_manager_employee_id

string

Project Manager Employee ID

 

project_project_manager_id

string

Project Manager ID

 

project_project_manager_name

string

Project Manager Name

 

project_project_manager_person_id

string

Project Manager Person ID

 

project_project_manager_tariff

float

Project Manager Tariff

 

project_project_number

string

Project Number

 

project_separate_invoice_recipient_is_separate_invoice_recipient

boolean

Project Separate Invoice Recipient

 

purchase_margin

float

Purchase Margin

 

purchase_price_total

float

Purchase Price Total

 

purchase_price_unit

float

Purchase Unit Price

 

service_id

string

Service ID

 

service_purchase_end_date

string

 

 

service_purchase_start_date

string

 

 

tariff

float

Tariff

 

total_price

float

Total Price

 

 

15-06-2022 20:27 Version 22.0.232-PROD+3445