SalesEnquires - Main table for all sales enquires
Column | Type | Notes |
---|---|---|
Area | TEXT | |
AssignedDate | DATETIME | |
Branch | TEXT | |
CallNumber | WHOLE NUMBER | |
CustomerName | TEXT | |
CustomerNo | TEXT | |
EnquiryNo | WHOLE NUMBER | |
EnteredBy | TEXT | |
EnteredDate | DATETIME | |
EnteredTime | TIME | |
ExpectedOrderDate | DATETIME | |
LostDate | DATETIME | |
LostReason | TEXT | |
PremisesType | TEXT | |
QuoteType | TEXT | |
QuotedDate | DATETIME | |
Rating | WHOLE NUMBER | |
Remarks | TEXT | |
Salesman | TEXT | |
SiteContactType | TEXT | |
SiteID | TEXT | |
SiteName | TEXT | |
SiteSearchName | TEXT | |
Status | TEXT | |
SystemType | TEXT | |
TypeOfWork | TEXT | |
WonDate | DATETIME | |
WonReason | TEXT | |
LastEditDate | DATETIME | |
Deleted | BINARY |