Download - MasterMine Software

Source
PK
PK
PK
PK
MM Field Name
Task Begin Date
Task End Date
Task PctDone
Task Notes
PK
Task Notes2
PK
Task Notes3
PK
Task Notes4
PK
PK
PK
PF
PF
PF
PF
Task Notes5
PKAccountNo
TaskRecords
PFRectype
Detail Item
Detail Reference
Detail Notes
PF
Detail Notes2
PF
Detail Notes3
PF
Detail Notes4
PF
PF
Detail Notes5
Sync
PF
PF
PF
PF
PT
PT
PT
PT
PT
PT
PT
PI
PI
PI
PI
PI
PI
PI
Detail CreatedOn
Linked Doc
Whole Link
DetailRecords
PTRectype
Team Member
Department
Title
Role
PTAccountNo
TeamRecords
PIRectype
Issue
Issue Priority
Issue Status
Issue Start
Issue User
Issue Notes
PI
Issue Notes2
PI
Issue Notes3
SQLExpression
PK.STARTDATE
PK.CLOSEBY
PK.CLOSEAMT
udfDBO$.udfMMStripHTML(PK.NOTES)
substring(udfDBO$.udfMMStripHTML(P
K.NOTES),254,253)
substring(udfDBO$.udfMMStripHTML(P
K.NOTES),507,253)
substring(udfDBO$.udfMMStripHTML(P
K.NOTES),760,253)
substring(udfDBO$.udfMMStripHTML(P
K.NOTES),1013,253)
PK.ACCOUNTNO
PK.RECID
Rtrim(PF.RECTYPE)
Rtrim(PF.FNAME)
Rtrim(PF.FVALUE)
udfDBO$.udfMMStripHTML(PF.NOTES)
substring(udfDBO$.udfMMStripHTML(PF
.NOTES),254,253)
substring(udfDBO$.udfMMStripHTML(PF
.NOTES),507,253)
substring(udfDBO$.udfMMStripHTML(PF
.NOTES),760,253)
substring(udfDBO$.udfMMStripHTML(PF
.NOTES),1013,253)
substring(PF.LINKEDDOC,8,1)
convert(datetime,substring(PF.LINKEDD
OC,23,8))
substring(PF.LINKEDDOC,47,30)
PF.LINKEDDOC
PF.RECID
Rtrim(PT.RECTYPE)
Rtrim(PT.CONTACT)
Rtrim(PT.COMPANY)
Rtrim(PT.NAME)
Rtrim(PT.STATUS)
PT.ACCOUNTNO
PT.RECID
Rtrim(PI.RECTYPE)
Rtrim(PI.COMPANY)
Rtrim(PI.STAGE)
Rtrim(PI.STATUS)
PI.STARTDATE
Rtrim(PI.USERID)
udfDBO$.udfMMStripHTML(PI.NOTES)
substring(udfDBO$.udfMMStripHTML(PI.
NOTES),254,253)
substring(udfDBO$.udfMMStripHTML(PI.
NOTES),507,253)
151
dBase Expression
PK.STARTDATE
PK.CLOSEBY
PK.CLOSEAMT
PK.NOTES
mid(PK.NOTES,254)
mid(PK.NOTES,507)
mid(PK.NOTES,760)
mid(PK.NOTES,1013)
PK.ACCOUNTNO
PK.RECID
PF.RECTYPE
PF.FNAME
PF.FVALUE
PF.NOTES
mid(PF.NOTES,254)
mid(PF.NOTES,507)
mid(PF.NOTES,760)
mid(PF.NOTES,1013)
mid(PF.LINKEDDOC,8,1)
iif(isdate(format(mid(PF.LINKEDDOC,2
3,8),'####/##/##')),datevalue(format(mid
(PF.LINKEDDOC,23,8),'####/##/##')),#
NullDate$#)
mid(PF.LINKEDDOC,47)
PF.LINKEDDOC
PF.RECID
PT.RECTYPE
PT.CONTACT
PT.COMPANY
PT.NAME
PT.STATUS
PT.ACCOUNTNO
PT.RECID
PI.RECTYPE
PI.COMPANY
PI.STAGE
PI.STATUS
PI.STARTDATE
PI.USERID
PI.NOTES
mid(PI.NOTES,254)
mid(PI.NOTES,507)