invantive documentation
Forum di supporto InvantiveAccedi / Registrati

payslip: Odoo itgen_odoo_payslip

read only per partition

  • Catalogo: Odoo
  • Schema: hr
  • Etichetta: itgen_odoo_payslip

Pay Slip

È possibile solo recuperare i dati.

Colonne della tabella

Di seguito sono riportate le colonne della tabella payslip. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati Label Required Marks Documentation
activity_calendar_event_id varchar2
activity_calendar_event_id_label varchar2
activity_date_deadline datetime Next Activity Deadline
activity_exception_decoration varchar2 Activity Exception Decoration Type of the exception activity on record.
activity_exception_icon varchar2 Icon Icon to indicate an exception activity.
activity_ids varchar2
activity_state varchar2 Activity State Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities.
activity_summary varchar2 Next Activity Summary
activity_type_icon varchar2 Activity Type Icon Font awesome icon e.g. fa-tasks
activity_type_id varchar2
activity_type_id_label varchar2
activity_user_id varchar2
activity_user_id_label varchar2
attendance_count int32 Attendance Count
basic_wage numeric Basic Wage
company_id varchar2
company_id_label varchar2
compute_date datetime Computed On
contract_domain_ids varchar2
contract_id varchar2
contract_id_label varchar2
country_code varchar2 Codice della nazione The ISO country code in two chars.You can use this field for quick search.
country_id varchar2
country_id_label varchar2
create_date datetime Creato il
create_uid varchar2
create_uid_label varchar2
credit_note boolean Nota di credito Indicates this payslip has a refund of another
currency_id varchar2
currency_id_label varchar2
date datetime Date Account Keep empty to use the period of the validation(Payslip) date.
date_from datetime From
date_to datetime To
department_id varchar2
department_id_label varchar2
display_name varchar2 Nome visualizzato
edited boolean Edited
email_cc varchar2 Email cc
employee_id varchar2
employee_id_label varchar2
gross_wage numeric Salario lordo
has_message boolean Has Message
has_negative_net_to_report boolean Has Negative Net To Report
has_refund_slip boolean Has Refund Slip
id int32 ID
input_line_ids varchar2
is_regular boolean Is Regular
is_superuser boolean Is Superuser
job_id varchar2
job_id_label varchar2
journal_id varchar2
journal_id_label varchar2
line_ids varchar2
message_attachment_count int32 Numero di allegati
message_follower_ids varchar2
message_has_error boolean Message Delivery error If checked, some messages have a delivery error.
message_has_error_counter int32 Number of errors Number of messages with delivery error
message_has_sms_error boolean SMS Delivery error If checked, some messages have a delivery error.
message_ids varchar2
message_is_follower boolean Is Follower
message_main_attachment_id varchar2
message_main_attachment_id_label varchar2
message_needaction boolean Action Needed If checked, new messages require your attention.
message_needaction_counter int32 Numero di azioni Number of messages which requires an action
message_partner_ids varchar2
move_id varchar2
move_id_label varchar2
my_activity_date_deadline datetime My Activity Deadline
name varchar2 Payslip Name
negative_net_to_report_amount numeric Negative Net To Report Amount
negative_net_to_report_display boolean Negative Net To Report Display
negative_net_to_report_message varchar2 Negative Net To Report Message
net_wage numeric Salario netto
normal_wage int32 Normal Wage
note varchar2 Nota interna
number varchar2 Reference
paid boolean Made Payment Order ?
payslip_run_id varchar2
payslip_run_id_label varchar2
planning_slot_count int32 Planning Slot Count
queued_for_pdf boolean Queued For Pdf
salary_attachment_count int32 Salary Attachment count
salary_attachment_ids varchar2
state varchar2 Status * When the payslip is created the status is 'Draft' * If the payslip is under verification, the status is 'Waiting'. * If the payslip is confirmed then status is set to 'Done'. * When user cancel payslip the status is 'Rejected'.
struct_id varchar2 Defines the rules that have to be applied to this payslip, according to the contract chosen.If the contract is empty, this field isn't mandatory anymore and all the valid rules of the structures of the employee's contracts will be applied.
struct_id_label varchar2 Defines the rules that have to be applied to this payslip, according to the contract chosen.If the contract is empty, this field isn't mandatory anymore and all the valid rules of the structures of the employee's contracts will be applied.
struct_type_id varchar2
struct_type_id_label varchar2
sum_worked_hours numeric Sum Worked Hours Total hours of attendance and time off (paid or not)
wage_type varchar2 Wage Type
warning_message varchar2 Warning Message
website_message_ids varchar2 Website communication history
worked_days_line_ids varchar2
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: