viw_salsalesfollowup.md 6.57 KB

Edit Raw Blame History



viw_salsalesfollowup（视图）


是否可更新： NO

定义者： xlyprint@%


字段


#
名称
类型
可空


1
sId
varchar(100)
NO


2
sBrandsId
varchar(100)
NO


3
sSubsidiaryId
varchar(100)
NO


4
tCreateDate
datetime
NO


5
sMakePerson
varchar(255)
NO


6
iOrder
int
NO


7
sFormId
varchar(100)
NO


8
sBillNo
varchar(255)
NO


9
sManualNo
varchar(255)
YES


10
sMemo
text
YES


11
bCheck
bit(1)
NO


12
tCheckDate
datetime
YES


13
sCheckPerson
varchar(255)
YES


14
bPrint
bit(1)
NO


15
bCopyLimit
bit(1)
NO


16
sStatus
varchar(255)
YES


17
bInvalid
bit(1)
NO


18
sMReserve1
varchar(255)
YES


19
sMReserve2
varchar(255)
YES


20
sMReserve3
varchar(255)
YES


21
sMReserve4
varchar(255)
YES


22
sMReserve5
varchar(255)
YES


23
sMReserve6
varchar(255)
YES


24
dMReserve1
decimal(18,6)
YES


25
dMReserve2
decimal(18,6)
YES


26
dMReserve3
decimal(18,6)
YES


27
iMReserve1
int
YES


28
iMReserve2
int
YES


29
iMReserve3
int
YES


30
tMReserve1
datetime
YES


31
tMReserve2
datetime
YES


32
sCustomerId
varchar(100)
YES


33
sBusinessMemo
text
YES


34
sContacts
varchar(100)
NO


35
sMobile
varchar(100)
NO


36
sFollowUpMemo
text
NO


37
tFollowUpDate
datetime
NO


38
sFollowUpNextMemo
text
NO


39
tFollowUpNextDate
datetime
NO


40
sSrcId
varchar(100)
NO


41
sSrcSlaveId
varchar(100)
NO


42
sSrcNo
varchar(100)
NO


43
sFollowUpPhase
varchar(255)
NO


44
sFollowUpPhaseProgress
varchar(255)
NO


45
sSId
varchar(100)
YES


46
sSlaveBrandsId
varchar(100)
YES


47
sSlaveSubsidiaryId
varchar(100)
YES


48
sSlaveMakePerson
varchar(255)
YES


49
iSlaveOrder
int
YES


50
sParentId
varchar(100)
YES


51
sPicturePath
varchar(255)
YES


52
bDefault
bit(1)
YES


53
sFileName
varchar(255)
YES


54
sSlaveId
varchar(100)
YES


55
iPorder
int
YES


56
sPmemo
text
YES


57
sPReserve1
varchar(255)
YES


58
sPReserve2
varchar(255)
YES


59
sPReserve3
varchar(255)
YES


60
sPReserve4
varchar(255)
YES


61
sPReserve5
varchar(255)
YES


62
sPReserve6
varchar(255)
YES


63
dPReserve1
decimal(18,6)
YES


64
dPReserve2
decimal(18,6)
YES


65
dPReserve3
decimal(18,6)
YES


66
iPReserve1
int
YES


67
iPReserve2
int
YES


68
iPReserve3
int
YES


69
tPReserve1
datetime
YES


70
tPReserve2
datetime
YES


71
sProductId
varchar(100)
YES


72
dProductPrice
decimal(18,6)
YES


73
sProductType
varchar(255)
YES


74
sBussinessType
varchar(255)
YES


75
sProductClassifyId
varchar(100)
YES


76
sProductMemo
text
YES


77
sSlaveSrcSlaveId
varchar(100)
YES


78
sSlaveSrcId
varchar(100)
YES


79
sCustomerName
varchar(255)
YES


80
dChanceMoney
decimal(18,6)
YES


81
dProbability
varchar(255)
YES


82
sCoordinateEmp
varchar(255)
YES


定义
select `m`.`sId` AS `sId`,`m`.`sBrandsId` AS `sBrandsId`,`m`.`sSubsidiaryId` AS `sSubsidiaryId`,`m`.`tCreateDate` AS `tCreateDate`,`m`.`sMakePerson` AS `sMakePerson`,`m`.`iOrder` AS `iOrder`,`m`.`sFormId` AS `sFormId`,`m`.`sBillNo` AS `sBillNo`,`m`.`sManualNo` AS `sManualNo`,`m`.`sMemo` AS `sMemo`,`m`.`bCheck` AS `bCheck`,`m`.`tCheckDate` AS `tCheckDate`,`m`.`sCheckPerson` AS `sCheckPerson`,`m`.`bPrint` AS `bPrint`,`m`.`bCopyLimit` AS `bCopyLimit`,`m`.`sStatus` AS `sStatus`,`m`.`bInvalid` AS `bInvalid`,`m`.`sMReserve1` AS `sMReserve1`,`m`.`sMReserve2` AS `sMReserve2`,`m`.`sMReserve3` AS `sMReserve3`,`m`.`sMReserve4` AS `sMReserve4`,`m`.`sMReserve5` AS `sMReserve5`,`m`.`sMReserve6` AS `sMReserve6`,`m`.`dMReserve1` AS `dMReserve1`,`m`.`dMReserve2` AS `dMReserve2`,`m`.`dMReserve3` AS `dMReserve3`,`m`.`iMReserve1` AS `iMReserve1`,`m`.`iMReserve2` AS `iMReserve2`,`m`.`iMReserve3` AS `iMReserve3`,`m`.`tMReserve1` AS `tMReserve1`,`m`.`tMReserve2` AS `tMReserve2`,`m`.`sCustomerId` AS `sCustomerId`,`m`.`sBusinessMemo` AS `sBusinessMemo`,`m`.`sContacts` AS `sContacts`,`m`.`sMobile` AS `sMobile`,`m`.`sFollowUpMemo` AS `sFollowUpMemo`,`m`.`tFollowUpDate` AS `tFollowUpDate`,`m`.`sFollowUpNextMemo` AS `sFollowUpNextMemo`,`m`.`tFollowUpNextDate` AS `tFollowUpNextDate`,`m`.`sSrcId` AS `sSrcId`,`m`.`sSrcSlaveId` AS `sSrcSlaveId`,`m`.`sSrcNo` AS `sSrcNo`,`m`.`sFollowUpPhase` AS `sFollowUpPhase`,`m`.`sFollowUpPhaseProgress` AS `sFollowUpPhaseProgress`,`s`.`sId` AS `sSId`,`s`.`sBrandsId` AS `sSlaveBrandsId`,`s`.`sSubsidiaryId` AS `sSlaveSubsidiaryId`,`s`.`sMakePerson` AS `sSlaveMakePerson`,`s`.`iOrder` AS `iSlaveOrder`,`s`.`sParentId` AS `sParentId`,`s`.`sPicturePath` AS `sPicturePath`,`s`.`bDefault` AS `bDefault`,`s`.`sFileName` AS `sFileName`,`p`.`sId` AS `sSlaveId`,`p`.`iOrder` AS `iPorder`,`p`.`sMemo` AS `sPmemo`,`p`.`sPReserve1` AS `sPReserve1`,`p`.`sPReserve2` AS `sPReserve2`,`p`.`sPReserve3` AS `sPReserve3`,`p`.`sPReserve4` AS `sPReserve4`,`p`.`sPReserve5` AS `sPReserve5`,`p`.`sPReserve6` AS `sPReserve6`,`p`.`dPReserve1` AS `dPReserve1`,`p`.`dPReserve2` AS `dPReserve2`,`p`.`dPReserve3` AS `dPReserve3`,`p`.`iPReserve1` AS `iPReserve1`,`p`.`iPReserve2` AS `iPReserve2`,`p`.`iPReserve3` AS `iPReserve3`,`p`.`tPReserve1` AS `tPReserve1`,`p`.`tPReserve2` AS `tPReserve2`,`p`.`sProductId` AS `sProductId`,`p`.`dProductPrice` AS `dProductPrice`,`p`.`sProductType` AS `sProductType`,`p`.`sBussinessType` AS `sBussinessType`,`p`.`sProductClassifyId` AS `sProductClassifyId`,`p`.`sProductMemo` AS `sProductMemo`,`p`.`sSrcSlaveId` AS `sSlaveSrcSlaveId`,`p`.`sSrcId` AS `sSlaveSrcId`,`m`.`sCustomerName` AS `sCustomerName`,`m`.`dChanceMoney` AS `dChanceMoney`,`m`.`dProbability` AS `dProbability`,`m`.`sCoordinateEmp` AS `sCoordinateEmp` from ((`xlyweberp_saas_ai`.`salsalesfollowupmaster` `m` left join `xlyweberp_saas_ai`.`salsalesfollowupslave` `s` on((`m`.`sId` = `s`.`sParentId`))) left join `xlyweberp_saas_ai`.`salsalesfollowupproduct` `p` on((`m`.`sId` = `p`.`sParentId`)))


说明

暂无人工说明。