public.vendor_bills
iduuidtenant_iduuidbill_numbercharacter varyingvendor_invoice_numbercharacter varyingvendor_iduuidpo_iduuid?statuscharacter varyingbill_datedatedue_datedate?subtotalnumerictax_totalnumerictds_sectioncharacter varying?tds_ratenumerictds_amountnumericgrand_totalnumericnet_payablenumericnotestext?created_byuuid?is_activebooleancreated_attimestamp with time zoneupdated_attimestamp with time zonecurrency_codecharacter varying?exchange_ratenumeric?fc_grand_totalnumeric?cgst_amountnumericsgst_amountnumericigst_amountnumericgst_typecharacter varyingvendor_gstintext?itc_eligiblebooleanrcm_applicablebooleanis_importbooleantax_applicablebooleangrn_iduuid?match_statuscharacter varyingthree_way_matchbooleanprice_variance_pctnumericqty_variance_pctnumericexpense_accounttext?inventory_accounttext?payment_termstext?party_doc_notext?party_doc_datedate?header_remarktext?ext_reftext?journal_entry_iduuid?
| id | tenant_id | bill_number | vendor_invoice_number | vendor_id | po_id | status | bill_date | due_date | subtotal | tax_total | tds_section | tds_rate | tds_amount | grand_total | net_payable | notes | created_by | is_active | created_at | updated_at | currency_code | exchange_rate | fc_grand_total | cgst_amount | sgst_amount | igst_amount | gst_type | vendor_gstin | itc_eligible | rcm_applicable | is_import | tax_applicable | grn_id | match_status | three_way_match | price_variance_pct | qty_variance_pct | expense_account | inventory_account | payment_terms | party_doc_no | party_doc_date | header_remark | ext_ref | journal_entry_id |
|---|