api_headinvoice


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('api_headinvoice_id_seq'::regclass)
api_detailinvoice.head_invoice_id api_detailinvoice_head_invoice_id_dcd83054_fk_api_headi R
deleted timestamptz 35,6 √ null
invoice_number float8 17,17 √ null
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
from_date timestamptz 35,6 √ null
to_date timestamptz 35,6 √ null
total_amount float8 17,17 null
exchange_rate float8 17,17 √ null
total_travels float8 17,17 null
total_travels_directs float8 17,17 null
total_appraisal float8 17,17 null
total_handling float8 17,17 null
total_materials float8 17,17 null
total_custody_cpv float8 17,17 null
total_custody_vault float8 17,17 null
total_custody_personal_atm float8 17,17 null
total_pieces float8 17,17 null
total_fixed_costs_packing float8 17,17 null
total_vigilant float8 17,17 null
total_atm_supply float8 17,17 null
total_atm_failure_1_2_levels float8 17,17 null
company_contact_id int4 10 √ null
api_companycontact.id api_headinvoice_company_contact_id_afc2640f_fk_api_compa R
contract_id int4 10 √ null
api_contract.id api_headinvoice_contract_id_24da26be_fk_api_contract_id R
employee_id int4 10 √ null
api_employee.id api_headinvoice_employee_id_114c1b3a_fk_api_employee_id R
office_id int4 10 √ null
api_office.id api_headinvoice_office_id_54d49f40_fk_api_office_id R
serviceorder_id int4 10 √ null
api_serviceorder.id api_headinvoice_serviceorder_id_563ec370_fk_api_serviceorder_id R
type_service_order_id int4 10 √ null
api_typeserviceorder.id api_headinvoice_type_service_order_i_05a086a1_fk_api_types R
currency_id int4 10 √ null
api_currency.id api_headinvoice_currency_id_c5f87d56_fk_api_currency_id R
due_date timestamptz 35,6 √ null
tax_exempt bool 1 null
tax_rate float8 17,17 √ null
total_disccount float8 17,17 √ null
total_tax_amount float8 17,17 √ null
file_uploaded varchar 100 √ null
fuel_charge float8 17,17 null
total_fuel_charge float8 17,17 null
total_vouchers float8 17,17 null
total_cost_appraisal float8 17,17 null
total_cost_handling float8 17,17 null
total_amount_chest float8 17,17 null
total_insurance_chest float8 17,17 null
total_qty_chest float8 17,17 null
total_cost_materials float8 17,17 null
total_travels_points float8 17,17 null
product_and_service_id int4 10 √ null
api_productandservice.id api_headinvoice_product_and_service__03dba5ce_fk_api_produ R
total_cost_travels float8 17,17 null

Indexes

Constraint Name Type Sort Column(s)
api_headinvoice_pkey Primary key Asc id
api_headinvoice_company_contact_id_afc2640f Performance Asc company_contact_id
api_headinvoice_contract_id_24da26be Performance Asc contract_id
api_headinvoice_currency_id_c5f87d56 Performance Asc currency_id
api_headinvoice_employee_id_114c1b3a Performance Asc employee_id
api_headinvoice_office_id_54d49f40 Performance Asc office_id
api_headinvoice_product_and_service_id_03dba5ce Performance Asc product_and_service_id
api_headinvoice_serviceorder_id_563ec370 Performance Asc serviceorder_id
api_headinvoice_type_service_order_id_05a086a1 Performance Asc type_service_order_id

Relationships

Close relationships within degrees of separation