tbl_currencymaster

9 rows


Description

Module: General Details
Purpose: Stores currency master details.
Data: One row is created for each currency.
Process Usage:
- Maintains a list of currencies used in the system.
- Captures currency full name and related metadata.
Key Points:
- Used in financial transactions and reporting.
- Most columns are reserved for future use or internal code logic.
Business Impact: Ensures consistency and proper identification of currencies across applications.

Columns

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

Primary key
Format: BIGSERIAL (auto-increment)
Used as: Unique identifier for each currency record.
currencyabbreviationsname varchar 500 √ null

Currency Abbreviation
Format: VARCHAR(500)
Meaning: Short name or abbreviation of currency (e.g., USD, INR).
Usage: Not currently used in code.
currencyfullname varchar 500 √ null

Currency Full Name
Format: VARCHAR(500)
Meaning: Full name of the currency (e.g., United States Dollar).
Usage: Main reference for display in reports and forms.
currencyhtmlcode varchar 500 √ null

HTML Code
Format: VARCHAR(500)
Meaning: Reserved for HTML display of currency.
Usage: Not currently used in code.
currencysymbolimage varchar 500 √ null

Currency Symbol Image
Format: VARCHAR(500)
Meaning: Reserved for storing symbol image path.
Usage: Not currently used in code.
currencydescription varchar 500 √ null

Currency Description
Format: VARCHAR(500)
Meaning: Additional notes about currency.
Usage: Not currently used in code.
currencystatus bool 1 √ null

Currency Status
Format: BOOLEAN
Meaning: Reserved for active/inactive flag.
Usage: Not currently used in code.
createdby varchar 50 √ null

Created By
Format: VARCHAR(50)
Meaning: User who created the record.
Usage: Not currently used in code.
createddate timestamp 29,6 √ null

Created Date
Format: TIMESTAMP
Meaning: Record creation date.
Usage: Not currently used in code.
modifiedby varchar 50 √ null

Modified By
Format: VARCHAR(50)
Meaning: User who last modified the record.
Usage: Not currently used in code.
modifieddate timestamp 29,6 √ null

Modified Date
Format: TIMESTAMP
Meaning: Last modification date.
Usage: Not currently used in code.
comp1 varchar 500 √ null

Reserved Column
Not used in code.
comp2 varchar 500 √ null

Company Country
Format: VARCHAR(500)
Meaning: Stores the country of the company associated with this currency.
comp3 varchar 500 √ null

Reserved Column
Not used in code.
comp4 varchar 500 √ null

Reserved Column
Not used in code.
comp5 int8 19 √ null

Reserved Column
Not used in code.
comp6 int8 19 √ null

Reserved Column
Not used in code.
comp7 numeric 0 √ null

Reserved Column
Not used in code.
comp8 numeric 0 √ null

Reserved Column
Not used in code.
comp9 bool 1 √ null

Reserved Column
Not used in code.
comp10 timestamp 29,6 √ null

Reserved Column
Not used in code.
comp11 timestamp 29,6 √ null

Reserved Column
Not used in code.

Indexes

Constraint Name Type Sort Column(s)
tbl_currencymaster_pk_currencymaster Primary key Asc currencyid

Relationships

Close relationships within degrees of separation