SAL_TaxChallan_Master
Documentation for the SAL_TaxChallan_Master database schema.
Fields
| Field | Data Type | Usage |
|---|---|---|
| anyId | ObjectId | Unique reference to any. |
| challanId | String | Unique reference to challan. |
| monthId | ObjectId | Unique reference to month. |
| yearId | ObjectId | Unique reference to year. |
| financialYearId | ObjectId | Unique reference to financial Year. |
| quarterNumber | Number | Stores the quarter number data. |
| serialNumber | Number | Stores the serial number data. |
| incomeTaxPaid | Number | Unique reference to income Tax Paid. |
| surchargePaid | Number | Unique reference to surcharge Paid. |
| educationCessPaid | Number | Unique reference to education Cess Paid. |
| interestPaid | Number | Unique reference to interest Paid. |
| penaltyPaid | Number | Unique reference to penalty Paid. |
| otherAmount | Number | Monetary or numeric value. |
| totalAmount | Number | Monetary or numeric value. |
| natureOfPayment | String | Timestamp/Date for natureOfPayment. |
| paymentMode | String | Stores the payment mode data. |
| bankChallanNumber | Number | Stores the bank challan number data. |
| bankChallanDate | Date | Timestamp/Date for bankChallanDate. |
| transactionVoucherNumber | Number | Stores the transaction voucher number data. |
| transactionVoucherDate | Date | Timestamp/Date for transactionVoucherDate. |
| chequeNumber | Number | Stores the cheque number data. |
| chequeDate | Date | Timestamp/Date for chequeDate. |
| drawnOn | String | Stores the drawn on data. |
| bankId | ObjectId | Unique reference to bank. |
| taxDeductedFrom | String | Stores the tax deducted from 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. |