| Name | Description | Type | Additional information |
|---|---|---|---|
| idx | integer |
None. |
|
| CustomerIdx | integer |
None. |
|
| custName | string |
None. |
|
| custContact | string |
None. |
|
| custAddress | string |
None. |
|
| ComplainDetails | string |
None. |
|
| addedOn | date |
None. |
|
| addedBy | integer |
None. |
|
| assignedTo | integer |
None. |
|
| assignedOn | date |
None. |
|
| assignedBy | integer |
None. |
|
| isCanceled | boolean |
None. |
|
| isClosed | boolean |
None. |
|
| callTypeIdx | integer |
None. |
|
| customerTypeidx | integer |
None. |
|
| city | string |
None. |
|
| area | string |
None. |
|
| areaMain | string |
None. |
|
| status | string |
None. |
|
| isAccepted | boolean |
None. |
|
| acceptedOn | date |
None. |
|
| isAchieved | boolean |
None. |
|
| notAchievedReason | string |
None. |
|
| hasPurchase | boolean |
None. |
|
| closedBy | integer |
None. |
|
| closedOn | date |
None. |
|
| closingRemarks | string |
None. |
|
| customerRemarks | string |
None. |
|
| rating | string |
None. |
|
| isRejected | boolean |
None. |
|
| rejectionReason | string |
None. |
|
| regionIdx | integer |
None. |
|
| siteTypeIdx | integer |
None. |
|
| isApprovedForIncentive | boolean |
None. |
|
| isAssignedToDesigner | boolean |
None. |
|
| assignedToDesingerIdx | integer |
None. |
|
| designerAssignedOn | date |
None. |
|
| isDesignCompleted | boolean |
None. |
|
| isDesignerAck | boolean |
None. |
|
| isIncentiveRejected | boolean |
None. |
|
| IncentiveRejectionReason | string |
None. |
|
| isIncentiveAppealed | boolean |
None. |
|
| incentiveAppealedOn | date |
None. |
|
| incentiveAppealReason | string |
None. |
|
| isIncentiveAppealApproved | boolean |
None. |
|
| isIncentiveAppealRejected | boolean |
None. |
|
| CallTypeName | string |
None. |
|
| CustomerTypeName | string |
None. |
|
| RegionName | string |
None. |
|
| SiteTypeName | string |
None. |
|
| Designer | string |
None. |