tbl_assets_vendor

-1 rows


Description

Module: Asset & Inventory Management
Purpose: Stores the comprehensive master data for all third-party vendors (suppliers) who provide company assets or related services (e.g., maintenance, licensing).
Data: Contains contact information, tax identification numbers (GST/PAN), banking details for payments, and contract specifics.
Process Usage:
- Used as a foreign key (vendor_id) in asset records to track the source of purchase.
- Provides financial data needed for purchase orders, payments, and tax compliance (GST/PAN).
Key Points:
- Centralized repository for vendor relationship management.
- Essential for procurement, finance, and asset auditing.
Business Impact: Streamlines procurement, payment, and financial compliance related to asset acquisition.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_assets_vendor_id_seq'::regclass)

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for the vendor record.
company_name varchar 200 null

The legal registered name of the vendor’s company.
vendor_name varchar 200 null

A friendly name or contact name for the vendor/supplier.
category_name varchar 200 null

The primary business category or industry of the vendor (e.g., IT Hardware, Software Licensing, Office Supplies).
gst_number varchar 100 √ null

The vendor’s Goods and Services Tax (GST) identification number (Indian tax system).
pan_number varchar 100 √ null

The vendor’s Permanent Account Number (PAN) (Indian tax system).
address_line1 varchar 200 null

Vendor’s primary street address line 1.
address_line2 varchar 200 null

Vendor’s primary street address line 2 (optional).
city_name varchar 200 √ null

The city of the vendor’s primary address.
state_name varchar 200 √ null

The state/province of the vendor’s primary address.
country_name varchar 200 √ null

The country of the vendor’s primary address.
pincode varchar 200 √ null

The postal code/pincode of the vendor’s primary address.
bank_name varchar 60 √ null

The name of the vendor’s bank for payment processing.
bank_account_number varchar 30 √ null

The vendor’s bank account number.
ifsc_code varchar 30 √ null

The Indian Financial System Code for the vendor’s bank branch.
payment_terms varchar 100 √ null

The agreed-upon payment terms (e.g., Net 30, Due upon Receipt, 50% Advance).
contract_start_date date 13 √ null

The start date of the main contract or engagement with this vendor (if applicable).
contract_end_date date 13 √ null

The expiration date of the main contract or engagement with this vendor (if applicable).
is_active bool 1 √ null

Boolean flag: Indicates if the vendor is currently active and approved for use.
remarks varchar 1000 √ null

Any general notes or internal remarks about the vendor relationship.
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_tbl_assets_vendor Primary key Asc id

Relationships

Close relationships within degrees of separation