EmployeeExpenseAttachments : Simplicate itgen_spe_employeeexpenseattachments_plural
read only REST
- Catalogue :
Simplicate - Schéma :
Hours - Étiquette : itgen_spe_employeeexpenseattachments_plural
Récupère les notes de frais des employés
Permet uniquement de récupérer des données.
Source de l'API
- Point de terminaison :
/hours/employeeexpense - Opération :
get /hours/employeeexpense
Colonnes de table
Les colonnes de la table EmployeeExpenseAttachments sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.
| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
amount |
double |
Amount | |||
approval_ |
varchar2 |
Description du statut d'approbation | |||
approval_ |
varchar2 |
Étiquette de statut d'approbation | |||
costtype_ |
double |
Type de coût Montant prévu au budget | |||
costtype_ |
char |
Type de coût : bloqué | |||
costtype_ |
varchar2 |
ID du type de coût | |||
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 |
ID du type de coût | |||
costtype_ |
varchar2 |
Étiquette de type de coût | |||
costtype_ |
double |
Type de coût Marge sur achats | |||
costtype_ |
double |
Type de coût : Tarif d'achat | |||
costtype_ |
double |
Type de coût Tarif | |||
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 |
Montant par employé | |||
employee_ |
varchar2 |
Déclarable par l’employé | |||
employee_ |
varchar2 |
ID d'employé | |||
employee_ |
varchar2 |
ID d'employé | |||
employee_ |
varchar2 |
Nom de l’employé | |||
employee_ |
varchar2 |
Numéro d'identification de l’employé | Ajouté afin de respecter la réponse originale sales/sales responsible_employee | ||
employee_ |
double |
Barème salarial de l’employé | |||
file_ |
varchar2 |
itgen_spe_file_hash | |||
file_ |
varchar2 |
itgen_spe_file_name | |||
id |
varchar2 |
ID | |||
invoice_ |
varchar2 |
Remarques sur la facture | |||
invoice_ |
varchar2 |
Type de composition de la facture | |||
invoice_ |
varchar2 |
Référence de la facture | |||
invoice_ |
varchar2 |
Facture créée | |||
invoice_ |
varchar2 |
Facture créée le | |||
invoice_ |
varchar2 |
Date de facture | |||
invoice_ |
varchar2 |
ID Facture | |||
invoice_ |
varchar2 |
Numéro de facture | |||
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 | Ajouté afin de respecter la réponse originale sales/sales responsible_employee | ||
invoice_ |
double |
itgen_spe_invoice_project_project_manager_tariff | |||
invoice_ |
varchar2 |
itgen_spe_invoice_project_project_number | |||
invoice_ |
varchar2 |
Référence de la facture | |||
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 |
Statut de la facture | |||
invoice_ |
varchar2 |
itgen_spe_invoice_status_2 | |||
invoice_ |
varchar2 |
Objet de la facture | |||
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 |
Est facturable | |||
note |
varchar2 |
Note | |||
project_ |
char |
itgen_spe_project_has_register_mileage_enabled | |||
project_ |
varchar2 |
Identifiant du projet | |||
project_ |
varchar2 |
Nom de projet | |||
project_ |
varchar2 |
Identifiant de l'organisation du projet | |||
project_ |
varchar2 |
Nom de l'organisme responsable du projet | |||
project_ |
varchar2 |
itgen_spe_project_organization_relation_number | |||
project_ |
varchar2 |
Nom complet de la personne en charge du projet | |||
project_ |
varchar2 |
Identifiant de la personne en charge du projet | |||
project_ |
varchar2 |
itgen_spe_project_person_relation_number | |||
project_ |
double |
Montant du chef de projet | |||
project_ |
varchar2 |
Chef de projet (poste à déclarer) | |||
project_ |
varchar2 |
Chef de projet - Numéro d’employé | |||
project_ |
varchar2 |
Référence du chef de projet | |||
project_ |
varchar2 |
Nom du chef de projet | |||
project_ |
varchar2 |
Identifiant du chef de projet | Ajouté afin de respecter la réponse originale sales/sales responsible_employee | ||
project_ |
double |
Tarif pour les chefs de projet | |||
project_ |
varchar2 |
Numéro de Projet | |||
purchase_ |
double |
Marge d'achat | |||
purchase_ |
double |
Prix d'achat total | |||
purchase_ |
double |
Prix unitaire d'achat | |||
service_ |
varchar2 |
ID du service | |||
service_ |
varchar2 |
itgen_spe_service_purchase_end_date | |||
service_ |
varchar2 |
itgen_spe_service_purchase_start_date | |||
tariff |
double |
Tariff | |||
total_ |
double |
Prix Total |
Notes de Version
Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :