SalesEnquiryValues - Values which relate to a sales enquiry eg hours, cost, margins etc.
Chaild table of SalesEnquires table
Column | Type | Notes |
---|---|---|
EnquiryNo | WHOLE NUMBER | |
MainSystemAcceptedCost | DECIMAL NUMBER | |
MainSystemAcceptedMargin | DECIMAL NUMBER | |
MainSystemAcceptedValue | DECIMAL NUMBER | |
MainSystemQuotedCost | DECIMAL NUMBER | |
MainSystemQuotedMarginVal | DECIMAL NUMBER | |
MainSystemQuotedValue | DECIMAL NUMBER | |
MaintAcceptedCost | DECIMAL NUMBER | |
MaintAcceptedMarginVal | DECIMAL NUMBER | |
MaintAcceptedValue | DECIMAL NUMBER | |
MaintQuotedCost | DECIMAL NUMBER | |
MaintQuotedMarginValue | DECIMAL NUMBER | |
MaintQuotedValue | DECIMAL NUMBER | |
MonitoringAcceptedCost | DECIMAL NUMBER | |
MonitoringAcceptedMargin | DECIMAL NUMBER | |
MonitoringAcceptedValue | DECIMAL NUMBER | |
MonitoringQuotedCost | DECIMAL NUMBER | |
MonitoringQuotedMarginVal | DECIMAL NUMBER | |
MonitoringQuotedValue | DECIMAL NUMBER | |
OptionsAcceptedCost | DECIMAL NUMBER | |
OptionsAcceptedMarginVal | DECIMAL NUMBER | |
OptionsAcceptedValue | DECIMAL NUMBER | |
OptionsQuotedCost | DECIMAL NUMBER | |
OptionsQuotedMarginVal | DECIMAL NUMBER | |
OptionsQuotedValue | DECIMAL NUMBER | |
ServicePremAcceptedCost | DECIMAL NUMBER | |
ServicePremAcceptedMarginVal | DECIMAL NUMBER | |
ServicePremAcceptedValue | DECIMAL NUMBER | |
ServicePremQuotedCost | DECIMAL NUMBER | |
ServicePremQuotedMarginVal | DECIMAL NUMBER | |
ServicePremQuotedValue | DECIMAL NUMBER | |
SigEquipAcceptedMarginVal | DECIMAL NUMBER | |
SigEquipAcceptedValue | DECIMAL NUMBER | |
SigEquipAcceptedcost | DECIMAL NUMBER | |
SigEquipQuotedCost | DECIMAL NUMBER | |
SigEquipQuotedMarginVal | DECIMAL NUMBER | |
SigEquipQuotedValue | DECIMAL NUMBER | |
Deleted | BINARY |