public.customer_invoices
iduuidtenant_iduuidinvoice_numbercharacter varyingcustomer_iduuidso_iduuid?statuscharacter varyinginvoice_datedatedue_datedate?subtotalnumerictax_totalnumericgrand_totalnumericnotestext?created_byuuid?is_activebooleancreated_attimestamp with time zoneupdated_attimestamp with time zoneplace_of_supplycharacter varying?tcs_ratenumerictcs_amountnumericresponsible_person_iduuid?currency_codecharacter varying?exchange_ratenumeric?fc_grand_totalnumeric?cgst_amountnumericsgst_amountnumericigst_amountnumericgst_typecharacter varyingreverse_chargebooleanpayment_modetext?payment_term_iduuid?dispatch_iduuid?store_iduuid?channel_iduuid?sale_typecharacter varyingpo_notext?ext_reftext?tcs_sectiontext?journal_entry_iduuid?irntext?ack_notext?ack_datetimestamp with time zone?signed_qr_codetext?einvoice_statuscharacter varyingeinvoice_jsonjsonb?einvoice_errortext?ewb_notext?ewb_datetimestamp with time zone?ewb_valid_uptotimestamp with time zone?posted_attimestamp with time zone?posted_byuuid?
| id | tenant_id | invoice_number | customer_id | so_id | status | invoice_date | due_date | subtotal | tax_total | grand_total | notes | created_by | is_active | created_at | updated_at | place_of_supply | tcs_rate | tcs_amount | responsible_person_id | currency_code | exchange_rate | fc_grand_total | cgst_amount | sgst_amount | igst_amount | gst_type | reverse_charge | payment_mode | payment_term_id | dispatch_id | store_id | channel_id | sale_type | po_no | ext_ref | tcs_section | journal_entry_id | irn | ack_no | ack_date | signed_qr_code | einvoice_status | einvoice_json | einvoice_error | ewb_no | ewb_date | ewb_valid_upto | posted_at | posted_by |