Vendor and Supplier¶

Vendor and supplier table stores information about Company with whom an organisation deal like Buyer or seller company.

venSupId: Primary key for the table.

companyName: Name of the vendor company.

companyPhoneNo: Phone number of the vendor company.

companyCountryCode: Country code of the vendor company.

companyTaxNo: Tax/GST number of the vendor company.

companyWebsite: Website of the vendor company.

companyBillingAddress: Billing address of the vendor company. This address will be used in all the documents.

companyShippingAddress: Other address of the vendor company.

orgId: Foreign key of Organisation table. This field stores the information of the organisation who created the vendor company.

type: Type of the vendor company like Buyer, seller or CHA etc from Organization's perspective.

tags: Array of tags for organisation's internal reference.

Vendor company must always belongs any one organisation.

One vendor company can have multiple contacts associated to it.