Name of the table: BITasks
| Field names | Description |
| PK_BITaskID | Internal unique reference |
| FK_BICompanyID | Internal unique reference |
| FK_BIAlternativeID | Internal unique reference |
| ProjectID | Project no. |
| ProjectName | Project name |
| DateStart | Start Date |
| DateExpiration | Expiration date |
| TaskSubject | Task object |
| IsScheduled | Is planned (or not) |
| TaskType | Task type |
| TaskTypeName | Name of the task category |
| TaskStatus | Task status 1 = to do 2 = in progress 3 = finished 4 = cancelled 5 = for information |
| WithSales | A sale took place at this meeting (or not) |
| NextSalesMeeting | Next date for the sale |
| SalespersonLoginName | Seller's login |
| SalespersonLastname | Seller's last name |
| SalespersonFirstname | Seller's first name |
| DateUpdatedBISynchTasks | Date of the last update of this record in the BI |
| DateCreatedBISynchTasks | Date of creation of this record in the BI |
| BIDeletedTasks | Data deleted from the database (or not) |
Comments
0 comments
Article is closed for comments.