Class: SalesCommissionNetBaseDetail
- Inherits:
-
ApplicationRecord
- Object
- ActiveRecord::Base
- ApplicationRecord
- SalesCommissionNetBaseDetail
- Includes:
- Models::Auditable
- Defined in:
- app/models/sales_commission_net_base_detail.rb
Overview
== Schema Information
Table name: sales_commission_net_base_details
Database name: primary
id :integer not null, primary key
cogs :float
commission_date :date not null
currency :string not null
customer_name :string not null
gl_date :date not null
profit :float
rank :integer not null
rate :float
reference_number :string not null
removed :boolean default(FALSE), not null
sales :float
sales_code :string not null
total :float
created_at :datetime not null
updated_at :datetime not null
company_id :integer not null
creator_id :integer
customer_id :integer not null
emp_comp_id :integer not null
employee_id :integer not null
reference_id :integer not null
sales_commission_id :integer not null
updater_id :integer
Indexes
index_sales_commission_net_base_details_on_commission_date (commission_date)
index_sales_commission_net_base_details_on_company_id (company_id)
index_sales_commission_net_base_details_on_customer_id (customer_id)
index_sales_commission_net_base_details_on_emp_comp_id (emp_comp_id)
index_sales_commission_net_base_details_on_employee_id (employee_id)
index_sales_commission_net_base_details_on_gl_date (gl_date)
index_sales_commission_net_base_details_on_reference_id (reference_id)
index_sales_commission_net_base_details_on_reference_number (reference_number)
index_sales_commission_net_base_details_on_sales_code (sales_code)
sc_id_commission_date (sales_commission_id,commission_date)
sc_id_company_id (sales_commission_id,company_id)
Constant Summary
Constants included from Models::Auditable
Models::Auditable::ALWAYS_IGNORED
Method Summary
Methods included from Models::Auditable
#all_skipped_columns, #audit_reference_data, #creator, #should_not_save_version, #stamp_record, #updater
Methods inherited from ApplicationRecord
ransackable_associations, ransackable_attributes, ransackable_scopes, ransortable_attributes, #to_relation