SAL_Employee_PerquisiteTrn
Documentation for the SAL_Employee_PerquisiteTrn database schema.
Fields
| Field | Data Type | Usage |
|---|---|---|
| uisiteTransactionId | ObjectId | Unique reference to uisite Transaction. |
| employeeId | ObjectId | Unique reference to employee. |
| perquisiteId | ObjectId | Unique reference to perquisite. |
| transactionDate | Date | Timestamp/Date for transactionDate. |
| totalValue | Number | Stores the total value data. |
| amountReceived | Number | Monetary or numeric value. |
| taxableAmount | Number | Monetary or numeric value. |
| insertedUserId | ObjectId | Unique reference to inserted User. |
| updatedByUserId | ObjectId | Unique reference to updated By User. |
| insertedDateId | ObjectId | Unique reference to inserted Date. |
| updatedDateId | ObjectId | Unique reference to updated Date. |
| timestamp | Date | Timestamp/Date for timestamp. |