PgHero
INSERT INTO "bill_details" ("actual_clinician_share", "amount", "anesthetist_charge", "anesthetist_id", "bed_category_id", "bill_category_id", "bill_detail_date", "bill_id", "billing_status", "ceo_discount", "cgst_amount", "cgst_percentage", "clinician_id", "corporate_category_id", "corporate_covered_amount", "corporate_id", "corporate_share", "created_at", "created_by", "credit_note_referal_id", "cs_mig_status", "cssd_pack_id", "department_clinician_id", "department_service_group_id", "disc_perc_mast_amt", "disc_perc_tpa_amt", "discipline_id", "discount_1mg_ip_percentage", "discount_1mg_op_percentage", "discount_amount", "discount_percentage", "dissc_amount", "doctor_share_amount", "drug_prescription_detail_id", "free_bed_days", "from_date", "has_ip_deposit_adjustment", "has_prior_approval", "has_seen", "healthcare_institution_id", "igst_amount", "igst_percentage", "insurance_id", "inventory_transaction_id", "is_applied_final_discount", "is_cancelled", "is_checked", "is_discount_in_percentage", "is_external", "is_fullfilled", "is_internal", "is_luxury_tax", "is_original", "is_return_after_settlement", "is_waive_off", "item_with_detail_id", "line_item_type", "location_id", "master_item_disc", "mg_status", "narration", "net_amount", "new_tpa_disc", "not_covered_in_package", "old_c_amount", "package_covered_amount", "package_covered_quantity", "package_item_id", "parent_id", "patient_id", "patient_share", "patient_share_credit_adjusted", "patient_type", "performed_clinician_charge", "performed_clinician_id", "pharmacy_bill_without_payment", "quantity", "rate_varies", "referal_clinician_id", "reference_1", "reference_2", "reference_3", "reference_clinician_id", "referral_source_id", "referral_type", "refferal_category_id", "remarks", "return_after_discharge_remark", "return_reason", "selling_price", "service_id", "service_rendered_date", "service_request_detail_id", "sgst_amount", "sgst_percentage", "source_type_name", "station_id", "station_name", "station_unit_id", "status", "surgeon_fee_percentage", "surgery_bill_detail_id", "tax_amount", "tax_profile_id", "taxable_amount", "to_date", "tpa_disc", "trustee_disc", "trustee_disc_amount", "unit_price", "updated_at", "updated_by", "visit_id", "waive_off_amount", "waive_off_bill", "waive_off_percentage") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116) RETURNING "id"

Total Time ms

Loading...

Average Time ms

Loading...

Calls

Loading...

Tables

Name Rows Indexes
bill_details 701937
  • id PRIMARY
  • bill_id
  • item_with_detail_id
  • location_id
  • narration
  • patient_id
  • reference_1
  • reference_3
  • service_id
  • service_request_detail_id
  • service_request_detail_id
  • service_request_detail_id
  • service_request_detail_id
  • station_id