Download User Manual - MasterMine Software

Source
MM Field Name
SQLExpression
CS
CS
CS
CS
CS
CSLastModified
CSAccountNo
CSRecords
CSHasNotes
CSNotes
CS
CSNotes2
CS
CSNotes3
CS
CSNotes4
CS
CSNotes5
CX
CX
CX
CX
Contact
Company
Main or Supp
Contact
Last Name
Coalesce(CS.LastDate,'NullDate$')
CS.ACCOUNTNO
CS.RECID
CS.STATUS
udfDBO$.udfMMStripHTML(CS.NOTES)
substring(udfDBO$.udfMMStripHTML(C
S.NOTES),254,253)
substring(udfDBO$.udfMMStripHTML(C
S.NOTES),507,253)
substring(udfDBO$.udfMMStripHTML(C
S.NOTES),760,253)
substring(udfDBO$.udfMMStripHTML(C
S.NOTES),1013,253)
rtrim(CX.CONTACT)//rtrim(CS.CONTAC
T)
Rtrim(CX.COMPANY)
CX
CX
CX
Dept/Ref
Title
Secr
CX
Email Address
CX
CX
CX
Email MergeCodes
Phone
Extension
CX
Merge Codes
CX
Address
CX
Address Filled
CX
Address2
CX
Address2 Filled
CX
Address3
CX
Address3 Filled
CX
City
'Main'//'Supp'
Rtrim(CX.LASTNAME)
rtrim(CX.DEPARTMENT)//rtrim(CS.CON
TSUPREF)
rtrim(CX.TITLE)//rtrim(CS.TITLE)
Rtrim(CX.SECR)
udfDBO$.udfMMPrimaryEmail(CX.ACC
OUNTNO)//udfDBO$.udfMMSuppContE
mail(CS.RecID)
udfDBO$.udfMMPEmailMergecodes(CX.
ACCOUNTNO)//udfDBO$.udfMMSuppE
mailMerge(CS.RecID)
rtrim(CX.PHONE1)//rtrim(CS.PHONE)
rtrim(CX.EXT1)//rtrim(CS.EXT)
rtrim(CX.MERGECODES)//rtrim(substrin
g(CS.MERGECODES,2,20))
rtrim(CX.ADDRESS1)//rtrim(CS.ADDRE
SS1)
rtrim(CX.ADDRESS1)//rtrim(Coalesce(nu
llif(CS.ADDRESS1,''), CX.ADDRESS1))
rtrim(CX.ADDRESS2)//rtrim(CS.ADDRE
SS2)
rtrim(CX.ADDRESS2)//rtrim(coalesce(su
bstring(CS.ADDRESS2,1,datalength(CS.
ADDRESS2+CS.ADDRESS1)),space(as
cii(CS.ADDRESS1)/ascii(CS.ADDRESS
1)),CX.ADDRESS2))
rtrim(CX.ADDRESS3)//rtrim(CS.ADDRE
SS3)
rtrim(CX.ADDRESS3)//rtrim(coalesce(su
bstring(CS.ADDRESS3,1,datalength(CS.
ADDRESS3+CS.ADDRESS1)),space(as
cii(CS.ADDRESS1)/ascii(CS.ADDRESS
1)),CX.ADDRESS3))
rtrim(CX.CITY)//rtrim(Coalesce(nullif(CS.
City,''), CX.City))
161
dBase Expression
iif(CS.LASTDATE is null,
#NullDate$#,CS.LastDate)
CS.ACCOUNTNO
CS.RECID
CS.STATUS
CS.NOTES
mid(CS.NOTES,254)
mid(CS.NOTES,507)
mid(CS.NOTES,760)
mid(CS.NOTES,1013)
CX.CONTACT//CS.CONTACT
CX.COMPANY
'Main'//'Supp'
CX.LASTNAME
trim(CX.DEPARTMENT)//trim(CS.CON
TSUPREF)
trim(CX.TITLE)//trim(CS.TITLE)
CX.SECR
CX.PHONE1//CS.PHONE
CX.EXT1//CS.EXT
CX.MERGECODES//mid(CS.MERGEC
ODES,2,20)
CX.ADDRESS1//CS.ADDRESS1
CX.Address1//iif(CS.ADDRESS1 is Null,
CX.ADDRESS1, CS.ADDRESS1)
CX.ADDRESS2//CS.ADDRESS2
CX.Address2//iif(CS.ADDRESS1 is Null,
CX.ADDRESS2, CS.ADDRESS2)
CX.ADDRESS3//CS.ADDRESS3
CX.Address3//iif(CS.ADDRESS1 is Null,
CX.ADDRESS3, CS.ADDRESS3)
CX.CITY//IIF(CS.CITY is null, CX.CITY,
CS.CITY)