public.partners
iduuidtenant_iduuidcodecharacter varyingnamecharacter varyingis_customerbooleanis_vendorbooleangstincharacter varying?pancharacter varying?billing_addressjsonbshipping_addressjsonbcontactjsonbcredit_limitnumericpayment_terms_daysintegertds_sectioncharacter varying?is_activebooleancreated_attimestamp with time zoneupdated_attimestamp with time zonecredit_limit_blocksbooleanclassification_iduuid?attributesjsonblegal_nametext?mobile_numbertext?emailtext?address_linetext?citytext?statetext?pincodetext?countrytext?bank_account_notext?bank_ifsctext?bank_nametext?is_msmebooleanmsme_numbertext?is_blockedbooleanblocked_reasontext?gstin_verifiedbooleanpan_verifiedbooleanvendor_ratingnumeric?currencytext?price_list_iduuid?allocation_priorityintegerlead_sourcetext?lead_stagetext?partner_typecharacter varyingstatuscharacter varyingvendor_classificationtext?vendor_classification_iduuid?customer_classification_iduuid?approval_statuscharacter varyingblacklist_reasontext?converted_to_customer_iduuid?pan_numbertext?vat_notext?eori_notext?credit_daysintegerpayment_term_iduuid?commission_pctnumericagent_iduuid?bank_branchtext?contact_notext?secondary_contacttext?secondary_emailtext?secondary_mobiletext?landlinetext?faxtext?addr1text?shipping_addrtext?naturetext?birthdaydate?anniversarydate?anniversary_datedate?wedding_anniversarydate?is_consignment_partnerbooleanis_branchbooleanbranch_store_iduuid?custom_attributesjsonbdeductee_typetext
| id | tenant_id | code | name | is_customer | is_vendor | gstin | pan | billing_address | shipping_address | contact | credit_limit | payment_terms_days | tds_section | is_active | created_at | updated_at | credit_limit_blocks | classification_id | attributes | legal_name | mobile_number | email | address_line | city | state | pincode | country | bank_account_no | bank_ifsc | bank_name | is_msme | msme_number | is_blocked | blocked_reason | gstin_verified | pan_verified | vendor_rating | currency | price_list_id | allocation_priority | lead_source | lead_stage | partner_type | status | vendor_classification | vendor_classification_id | customer_classification_id | approval_status | blacklist_reason | converted_to_customer_id | pan_number | vat_no | eori_no | credit_days | payment_term_id | commission_pct | agent_id | bank_branch | contact_no | secondary_contact | secondary_email | secondary_mobile | landline | fax | addr1 | shipping_addr | nature | birthday | anniversary | anniversary_date | wedding_anniversary | is_consignment_partner | is_branch | branch_store_id | custom_attributes | deductee_type |