| Name | Description | Type | Additional information |
|---|---|---|---|
| ExpenseReportID | integer |
None. |
|
| ExpenseReportTypeID | integer |
None. |
|
| ExpenseReportTypeName | string |
None. |
|
| TravelDate | string |
None. |
|
| TravelItinerary | string |
None. |
|
| ReferenceID | string |
None. |
|
| ReceiptReferenceID | integer |
None. |
|
| TravelRequestID | integer |
None. |
|
| TravelReferenceID | string |
None. |
|
| AccountTypeID | integer |
None. |
|
| AdvanceAmount | decimal number |
None. |
|
| ApprovedAccountTypeID | integer |
None. |
|
| TotalExpenseAmountInINR | string |
None. |
|
| TotalAsPerPolicyAllowAmountInINR | decimal number |
None. |
|
| TotalApprovedAmountInINR | decimal number |
None. |
|
| IsDisclaimer | boolean |
None. |
|
| IsOverLimit | boolean |
None. |
|
| IsRejected | boolean |
None. |
|
| IsMailSent | boolean |
None. |
|
| ExpenseReportSubmitOn | string |
None. |
|
| ExpenseReportStatusID | integer |
None. |
|
| PendingForApprovalLevelID | integer |
None. |
|
| ManagerActionedBy | integer |
None. |
|
| ManagerActionedOn | date |
None. |
|
| CFApproverBy | integer |
None. |
|
| CFApproverOn | date |
None. |
|
| PaymentProcessedBy | integer |
None. |
|
| PaymentProcessedOn | date |
None. |
|
| PaymentExcelDocumentID | integer |
None. |
|
| IsRevertForApproval | boolean |
None. |
|
| PaidTo | integer |
None. |
|
| PaidToVendor | boolean |
None. |
|
| AssignedToID | integer |
None. |
|
| LastExcelDownloadedOn | date |
None. |
|
| IsActive | boolean |
None. |
|
| LastPendingStatusOn | date |
None. |
|
| ExpenseReportReSubmitOn | date |
None. |
|
| CreatedOn | date |
None. |
|
| UpdatedOn | date |
None. |
|
| CreatedBy | integer |
None. |
|
| UpdatedBy | integer |
None. |
|
| Comments | string |
None. |
|
| TechComments | string |
None. |
|
| UserLocationID | integer |
None. |
|
| IsLocked | boolean |
None. |
|
| LockedBy | integer |
None. |
|
| LockedOn | date |
None. |
|
| Ageing | integer |
None. |
|
| ExpenseReportStatusName | string |
None. |
|
| StartDate | date |
None. |
|
| EndDate | date |
None. |
|
| Travelfrom | integer |
None. |
|
| Editable | integer |
None. |
|
| IsLDA | boolean |
None. |
|
| UserID | integer |
None. |
|
| AuthToken | string |
None. |