public.sales_orders

iduuidtenant_iduuidso_numbercharacter varyingcustomer_iduuidwarehouse_iduuid?statuscharacter varyingorder_datedateexpected_datedate?subtotalnumerictax_totalnumericgrand_totalnumericnotestext?created_byuuid?is_activebooleancreated_attimestamp with time zoneupdated_attimestamp with time zonequotation_iduuid?responsible_person_iduuid?cgst_amountnumericsgst_amountnumericigst_amountnumericgst_typecharacter varying?credit_limit_exceededbooleancredit_overridebooleancredit_override_byuuid?credit_override_attimestamp with time zone?credit_override_reasontext?approved_byuuid?agent_iduuid?commission_pctnumericcommission_amountnumericbuyer_po_notext?ext_reftext?project_iduuid?priorityinteger?ship_to_address_iduuid?ship_to_texttext?sale_typecharacter varyingchannel_iduuid?currencycharacter varyingexchange_ratenumericorder_discount_pctnumericorder_discount_amountnumericadvance_amountnumericadvance_modetext?advance_reftext?attachmentsjsonbmeasurements_jsonjsonb?freight_chargenumericpacking_chargenumericother_chargenumericround_offnumericmeasurementstext?

id	tenant_id	so_number	customer_id	warehouse_id	status	order_date	expected_date	subtotal	tax_total	grand_total	notes	created_by	is_active	created_at	updated_at	quotation_id	responsible_person_id	cgst_amount	sgst_amount	igst_amount	gst_type	credit_limit_exceeded	credit_override	credit_override_by	credit_override_at	credit_override_reason	approved_by	agent_id	commission_pct	commission_amount	buyer_po_no	ext_ref	project_id	priority	ship_to_address_id	ship_to_text	sale_type	channel_id	currency	exchange_rate	order_discount_pct	order_discount_amount	advance_amount	advance_mode	advance_ref	attachments	measurements_json	freight_charge	packing_charge	other_charge	round_off	measurements