Download - MasterMine Software

Source
MM Field Name
SQLExpression
CA
Potential Units
Coalesce(CA.NUMBER2,0)
CA
Probable Amount
Coalesce(CA.NUMBER1,0)*Coalesce(C
A.Duration,0)/100
CA
CA
CA
Probable Units
DirCode
CreateBy
Coalesce(CA.NUMBER2,0)*Coalesce(C
A.Duration,0)/100
Rtrim(CA.DIRCODE)
Rtrim(CA.CREATEBY)
CA
CA
CreateOn
CreateAt
Coalesce(CA.CREATEON,'NullDate$')
CA.CREATEAT
CA
CA
EndDate
Last User
Coalesce(CA.ENDDATE,'NullDate$')
Rtrim(CA.LASTUSER)
CA
CA
Last Modified
LastTime
Coalesce(CA.LASTDATE,'NullDate$')
CA.LASTTIME
CA
CA
CA
AlarmDate
AlarmTime
AlarmFlag
CA
CA
CA
CA
CA
Color
ContactFile
CAAccountNo
CARecords
Linked OpRecID
Coalesce(CA.ALARMDATE,'NullDate$')
Rtrim(CA.ALARMTIME)
Rtrim(CA.ALARMFLAG)
Rtrim(isnull(nullif(CA.APPTUSER,''),'Blue
'))
Rtrim(CA.DIRCODE)
CA.ACCOUNTNO
CA.RECID
CA.LOPRECID
CH
OnDate
CH
CH
CH
CH
OnDay
OnTime
OnHour
User ID
CH
CH
CH
CH
DaysSince
Activity Type
Result Code
Activity Code
CH
Short Reference
CH
Product
CH
Reference
CH
LogUpdate
Coalesce(CH.OnDate,'NullDate$')
substring(datename(weekday,Coalesce(
CH.OnDate,'NullDate$')),1,3)
CH.OnTime
substring(CH.OnTime,1,2)
Rtrim(CH.USERID)
Datediff(day,Coalesce(CH.OnDate,'NullD
ate$'), getdate())
CH.SRECTYPE
Rtrim(CH.RESULTCODE)
Rtrim(CH.ACTVCODE)
Rtrim(substring(Ltrim(Stuff(CH.REF,Char
index(' (oc:',CH.REF)+1,200*Charindex('
(oc:',CH.REF),' ')),1,ShortRefLen$))
Rtrim(ltrim(Stuff(CH.REF,Charindex('
(oc:',CH.REF)+1,200*Charindex('
(oc:',CH.REF),' ')))
Rtrim(Ltrim(Stuff(CH.REF,Charindex('
(oc:',CH.REF)+1,200*Charindex('
(oc:',CH.REF),' ')))
substring(Ltrim(Stuff(CH.REF,Charindex(
' (oc:',CH.REF)+1,200*Charindex('
(oc:',CH.REF),' ')),1,11)
142
dBase Expression
iif(CA.NUMBER2 Is
Null,0,CA.NUMBER2)
iif(CA.NUMBER1 Is
Null,0,CA.NUMBER1)* iif(CA.duration is
null, 0, CA.duration/100)
iif(CA.NUMBER2 Is
Null,0,CA.NUMBER2)* iif(CA.duration is
null, 0, CA.duration/100)
CA.DIRCODE
CA.CREATEBY
iif(CA.CREATEON Is
Null,#NullDate$#,CA.CREATEON)
CA.CREATEAT
iif(CA.ENDDATE Is
Null,#NullDate$#,CA.ENDDATE)
CA.LASTUSER
iif(CA.LASTDATE Is
Null,#NullDate$#,CA.LASTDATE)
CA.LASTTIME
iif(CA.ALARMDATE Is
Null,#NullDate$#,CA.LASTDATE)
CA.ALARMTIME
CA.ALARMFLAG
CA.APPTUSER
CA.DIRCODE
CA.ACCOUNTNO
CA.RECID
CA.LOPRECID
iif(CH.Ondate is null, #NullDate$#,
CH.ondate)
WeekDay(CH.OnDate)
CH.OnTime
left(CH.OnTime,2)
CH.USERID
date() - iif(CH.OnDate is null,
#NullDate$#, CH.OnDate)
CH.SRECTYPE
CH.RESULTCODE
CH.ACTVCODE
left(iif(CH.REF Like
'%(oc:%',left(CH.REF,instr(CH.REF,'(oc:
')-1),CH.REF),ShortRefLen$)
iif(CH.REF Like
'%(oc:%',left(CH.REF,instr(CH.REF,'(oc:
')-1),CH.REF)
iif(CH.REF Like
'%(oc:%',left(CH.REF,instr(CH.REF,'(oc:
')-1),CH.REF)
left(iif(CH.REF Like
'%(oc:%',left(CH.REF,instr(CH.REF,'(oc:
')-1),CH.REF),instr(CH.REF,':')-1)