public.advances
iduuidtenant_iduuidadvance_nocharacter varyingdirectioncharacter varyingpartner_iduuidadvance_datedateamountnumericgst_ratenumericgst_amountnumericadjusted_amountnumericpayment_modecharacter varyingreferencecharacter varying?statuscharacter varyingjournal_entry_iduuid?notestext?created_byuuid?is_activebooleancreated_attimestamp with time zoneupdated_attimestamp with time zoneext_reftext?so_iduuid?bank_account_iduuid?
| id | tenant_id | advance_no | direction | partner_id | advance_date | amount | gst_rate | gst_amount | adjusted_amount | payment_mode | reference | status | journal_entry_id | notes | created_by | is_active | created_at | updated_at | ext_ref | so_id | bank_account_id |