tbl_financialyear

1 rows


Description

Module: Core/Payroll Management - Financial Year Master
Purpose: Defines and tracks the official start and end dates, status, and control parameters for each financial year (FY) used by the organization for accounting, payroll, and compliance reporting.
Data: Stores the FY period, the company/SBU it applies to, and control flags indicating if the FY is active, running, or closed.
Process Usage:
- Period Control: Used to validate dates and determine the current active financial cycle for transactional processing.
- Year-End/Year-Begin: Essential for executing year-end closing procedures and setting up the new fiscal period.
Key Points:
- Crucial for statutory compliance, especially tax and TDS returns, which are tied to the financial year.
- The FYRunning flag manages the active status of the current working year.
Business Impact: Ensures consistent and accurate reporting and calculation across all finance and payroll modules.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
financialyearid serial 10 √ nextval('tbl_financialyear_financialyearid_seq'::regclass)
tbl_employeeselectedtdsslab.financialyearid Implied Constraint R
tbl_financialyear.financialyearid fk_tbl_financialyear_tbl_financialyear R
tbl_tds_master.financialyearid Implied Constraint R
tbl_financialyear.financialyearid fk_tbl_financialyear_tbl_financialyear R

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this financial year record.
companyid int8 19 null

FK: public.tbl_company.id
Meaning: The company entity to which this financial year definition applies.
yeartype int4 10 null

Defines the type or classification of the year (e.g., 1= Financial Year, 2= Calendar Year, etc.).
fystartdate timestamp 29,6 null

The official start date of the financial year (e.g., April 1st).
fyenddate timestamp 29,6 null

The official end date of the financial year (e.g., March 31st).
fyearstatus bool 1 √ null

Boolean flag: Indicates the long-term status of the record (e.g., Active/Inactive).
fyclosedate timestamp 29,6 √ null

The actual date when the financial year was formally closed in the system.
fypersonid varchar 20 √ null

FK: public.tbl_employee.employeeid
Meaning: The Employee ID of the person who initiated or approved the closing/finalization of the financial year.
fyrunning bool 1 √ null

Boolean flag: Indicates if this is the currently active, running financial year where transactions are being processed.
sbuid int4 10 √ null

FK: public.tbl_SBU.id
Meaning: The Strategic Business Unit (SBU) to which this financial year definition applies (allows for multiple fiscal calendars within one company).
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)
tbl_financialyear_pk_tbl_financialyear Primary key Asc financialyearid

Relationships

Close relationships within degrees of separation