SAL_IncomeTaxCalculation_Master
Documentation for the SAL_IncomeTaxCalculation_Master database schema.
Fields
| Field | Data Type | Usage |
|---|---|---|
| anyId | ObjectId | Unique reference to any. |
| transactionCode | String | Stores the transaction code data. |
| date | Date | Timestamp/Date for date. |
| employeeId | ObjectId | Unique reference to employee. |
| ddoId | ObjectId | Unique reference to ddo. |
| financialYearId | ObjectId | Unique reference to financial Year. |
| rentPaid | Number | Unique reference to rent Paid. |
| drawnSalary | Number | Stores the drawn salary data. |
| perquisites | Number | Stores the perquisites data. |
| profitInLieu | Number | Stores the profit in lieu data. |
| grossSalary | Number | Stores the gross salary data. |
| hraAllowance | Number | Stores the hra allowance data. |
| conveyanceAllowance | Number | Stores the conveyance allowance data. |
| standardDeduction | Number | Stores the standard deduction data. |
| entertainmentAllowance | Number | Stores the entertainment allowance data. |
| employmentTax | Number | Stores the employment tax data. |
| incomeFromHouseProperty | Number | Stores the income from house property data. |
| otherIncome | Number | Stores the other income data. |
| deductionUnder6A | Number | Stores the deduction under6 a data. |
| deductionUnderOtherSections | Number | Stores the deduction under other sections data. |
| totalDeductions | Number | Stores the total deductions data. |
| netGrossIncome | Number | Stores the net gross income data. |
| tax | Number | Stores the tax data. |
| surchargeAmount | Number | Monetary or numeric value. |
| cessAmount | Number | Monetary or numeric value. |
| reliefUnderSection89 | Number | Stores the relief under section89 data. |
| totalTax | Number | Stores the total tax data. |
| paidTax | Number | Unique reference to paid Tax. |
| totalTaxPayableOrReturnable | Number | Stores the total tax payable or returnable data. |
| insertedUserId | ObjectId | Unique reference to inserted User. |
| updatedUserId | ObjectId | Unique reference to updated User. |
| insertedDateId | ObjectId | Unique reference to inserted Date. |
| updatedDateId | ObjectId | Unique reference to updated Date. |
| timestamp | Date | Timestamp/Date for timestamp. |