Insurance_Transaction_Master
Documentation for the Insurance_Transaction_Master database schema.
Fields
| Field | Data Type | Usage |
|---|---|---|
| anyId | ObjectId | Unique reference to any. |
| insuranceTransactionId | String | Unique reference to insurance Transaction. |
| insuranceCode | String | Stores the insurance code data. |
| manualInsuranceCode | String | Stores the manual insurance code data. |
| insuranceDetails | String | Stores the insurance details data. |
| headId | ObjectId | Unique reference to head. |
| transactionDate | Date | Timestamp/Date for transactionDate. |
| employeeId | ObjectId | Unique reference to employee. |
| monthlyInstallment | Decimal128 | Stores the monthly installment data. |
| lastInsuranceDate | Date | Timestamp/Date for lastInsuranceDate. |
| totalContribution | Decimal128 | Stores the total contribution data. |
| remarks | String | Detailed notes or remarks. |
| 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. |