viw_salsalesdevfollowup.md 7.15 KB

Edit Raw Blame History



viw_salsalesdevfollowup（视图）


是否可更新： YES

定义者： xlyprint@%


字段


#
名称
类型
可空


1
iIncrement
int
NO


2
sId
varchar(100)
NO


3
sBrandsId
varchar(100)
NO


4
sSubsidiaryId
varchar(100)
NO


5
tCreateDate
datetime
NO


6
sMakePerson
varchar(255)
NO


7
iOrder
int
NO


8
sFormId
varchar(100)
NO


9
sBillNo
varchar(255)
NO


10
sManualNo
varchar(255)
YES


11
sMemo
text
YES


12
bCheck
bit(1)
NO


13
tCheckDate
datetime
YES


14
sCheckPerson
varchar(255)
YES


15
bPrint
bit(1)
NO


16
bCopyLimit
bit(1)
NO


17
sStatus
varchar(255)
YES


18
bInvalid
bit(1)
NO


19
sMReserve1
varchar(255)
YES


20
sMReserve2
varchar(255)
YES


21
sMReserve3
varchar(255)
YES


22
sMReserve4
varchar(255)
YES


23
sMReserve5
varchar(255)
YES


24
sMReserve6
varchar(255)
YES


25
dMReserve1
decimal(18,6)
YES


26
dMReserve2
decimal(18,6)
YES


27
dMReserve3
decimal(18,6)
YES


28
iMReserve1
int
YES


29
iMReserve2
int
YES


30
iMReserve3
int
YES


31
tMReserve1
datetime
YES


32
tMReserve2
datetime
YES


33
sCustomerId
varchar(100)
YES


34
sProductClassifyId
varchar(100)
YES


35
dDevMoney
decimal(18,6)
NO


36
sContacts
varchar(100)
NO


37
sMobile
varchar(100)
NO


38
sBussinessType
varchar(255)
NO


39
sDevMemo
text
YES


40
sSrcId
varchar(255)
NO


41
sSrcSlaveId
varchar(255)
NO


42
sProductId
varchar(100)
NO


43
dProductQty
decimal(18,6)
NO


44
dDevCostMoney
decimal(18,6)
NO


45
sMaterialsMemo
text
YES


46
sProcessMemo
text
YES


47
sFollowUpPhase
varchar(255)
NO


48
iSlaveOrder
int
NO


49
sSlaveId
varchar(100)
NO


50
sPicturePath
varchar(255)
YES


51
bDefault
bit(1)
NO


52
sFileName
varchar(255)
NO


53
sOrderWay
varchar(255)
NO


54
sProductType
varchar(255)
NO


55
sSizeSource
varchar(255)
NO


56
sBoxStructure
varchar(255)
NO


57
sPaperMaterial
varchar(255)
NO


58
sFilePath
varchar(255)
NO


定义
select `xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`iIncrement` AS `iIncrement`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`sId` AS `sId`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`sBrandsId` AS `sBrandsId`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`sSubsidiaryId` AS `sSubsidiaryId`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`tCreateDate` AS `tCreateDate`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`sMakePerson` AS `sMakePerson`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`iOrder` AS `iOrder`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`sFormId` AS `sFormId`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`sBillNo` AS `sBillNo`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`sManualNo` AS `sManualNo`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`sMemo` AS `sMemo`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`bCheck` AS `bCheck`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`tCheckDate` AS `tCheckDate`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`sCheckPerson` AS `sCheckPerson`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`bPrint` AS `bPrint`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`bCopyLimit` AS `bCopyLimit`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`sStatus` AS `sStatus`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`bInvalid` AS `bInvalid`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`sMReserve1` AS `sMReserve1`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`sMReserve2` AS `sMReserve2`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`sMReserve3` AS `sMReserve3`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`sMReserve4` AS `sMReserve4`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`sMReserve5` AS `sMReserve5`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`sMReserve6` AS `sMReserve6`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`dMReserve1` AS `dMReserve1`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`dMReserve2` AS `dMReserve2`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`dMReserve3` AS `dMReserve3`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`iMReserve1` AS `iMReserve1`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`iMReserve2` AS `iMReserve2`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`iMReserve3` AS `iMReserve3`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`tMReserve1` AS `tMReserve1`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`tMReserve2` AS `tMReserve2`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`sCustomerId` AS `sCustomerId`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`sProductClassifyId` AS `sProductClassifyId`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`dDevMoney` AS `dDevMoney`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`sContacts` AS `sContacts`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`sMobile` AS `sMobile`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`sBussinessType` AS `sBussinessType`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`sDevMemo` AS `sDevMemo`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`sSrcId` AS `sSrcId`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`sSrcSlaveId` AS `sSrcSlaveId`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`sProductId` AS `sProductId`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`dProductQty` AS `dProductQty`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`dDevCostMoney` AS `dDevCostMoney`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`sMaterialsMemo` AS `sMaterialsMemo`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`sProcessMemo` AS `sProcessMemo`,`xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`sFollowUpPhase` AS `sFollowUpPhase`,`xlyweberp_saas_ai`.`salsalesdevfollowupslave`.`iOrder` AS `iSlaveOrder`,`xlyweberp_saas_ai`.`salsalesdevfollowupslave`.`sId` AS `sSlaveId`,`xlyweberp_saas_ai`.`salsalesdevfollowupslave`.`sPicturePath` AS `sPicturePath`,`xlyweberp_saas_ai`.`salsalesdevfollowupslave`.`bDefault` AS `bDefault`,`xlyweberp_saas_ai`.`salsalesdevfollowupslave`.`sFileName` AS `sFileName`,`xlyweberp_saas_ai`.`salsalesdevfollowupslave`.`sOrderWay` AS `sOrderWay`,`xlyweberp_saas_ai`.`salsalesdevfollowupslave`.`sProductType` AS `sProductType`,`xlyweberp_saas_ai`.`salsalesdevfollowupslave`.`sSizeSource` AS `sSizeSource`,`xlyweberp_saas_ai`.`salsalesdevfollowupslave`.`sBoxStructure` AS `sBoxStructure`,`xlyweberp_saas_ai`.`salsalesdevfollowupslave`.`sPaperMaterial` AS `sPaperMaterial`,`xlyweberp_saas_ai`.`salsalesdevfollowupslave`.`sFilePath` AS `sFilePath` from (`xlyweberp_saas_ai`.`salsalesdevfollowupmaster` join `xlyweberp_saas_ai`.`salsalesdevfollowupslave` on((`xlyweberp_saas_ai`.`salsalesdevfollowupslave`.`sParentId` = `xlyweberp_saas_ai`.`salsalesdevfollowupmaster`.`sId`)))


说明

暂无人工说明。