tbl_form24qcustomfields

-1 rows


Description

Module: Payroll Compliance - Form 24Q Challan Details
Purpose: Stores the detailed information about the tax amount (TDS) deducted from employee salaries and subsequently deposited to the government, on a month-by-month, challan-by-challan basis, for inclusion in the quarterly Form 24Q compliance filing.
Data: Captures the breakdown of the deposited tax amount (TDS, Cess, Interest, Fee, Penalty), the deposit mode, bank details (BSR Code, Challan Serial No.), and the verification details.
Process Usage:
- Used to generate Annexure 2 (Challan Details) of the quarterly Form 24Q return.
- Tracks the complete payment lifecycle from salary deduction to government deposit.
Key Points:
- Each record relates to a single tax challan deposit for a specific month/year.
- Crucial for statutory compliance verification and preventing errors in tax credit allocation.
Business Impact: Essential for accurate and timely submission of quarterly TDS returns and for ensuring employees receive the correct tax credit.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for a single tax challan deposit record.
verifiedname varchar 50 √ null

The name of the person verifying the Form 24Q filing (e.g., the employer/deductor).
designation varchar 50 √ null

The designation of the verifying person.
place varchar 50 √ null

The place where the form is being verified/filed.
serialno int4 10 √ null

The serial number or index of the challan within the quarterly return.
month int4 10 √ null

The payroll month (1-12) to which the deducted tax amount applies.
year int4 10 √ null

The payroll year to which the deducted tax amount applies.
taxdeductionwithouteducationcess numeric 0 √ null

The principal amount of TDS (Tax Deducted at Source) deposited, excluding Education Cess.
educationcess numeric 0 √ null

The amount of Education Cess and Secondary & Higher Education Cess deposited.
interest numeric 0 √ null

The amount of Interest paid for late deposit of the TDS.
fee numeric 0 √ null

The amount of late filing fee paid (if any).
penalty numeric 0 √ null

The amount of penalty paid (if any).
totalamountdeposited numeric 0 √ null

The grand total amount deposited via this single challan (TDS + Cess + Interest + Fee + Penalty).
modeofdeposit varchar 10 √ null

The method of deposit (e.g., E-Payment, Cheque, Cash).
bsrcodereceipt int4 10 √ null

The Bank Serial Number (BSR) Code of the bank branch where the tax was deposited.
challanserialnumber varchar 20 √ null

The unique Challan Identification Number (CIN) or Challan Serial Number.
amountdepositdate date 13 √ null

The date on which the tax amount was deposited to the government treasury (Challan date).
minorhead int4 10 √ null

The minor head of the challan (e.g., typically 200 for TDS on salaries).
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_form24qcustomfields_pk__tbl_form__3214ec0725b0c3a5 Primary key Asc id

Relationships

Close relationships within degrees of separation