viw_cahcostchange.md 3.12 KB

Edit Raw Blame History



viw_cahcostchange（视图）


是否可更新： YES

定义者： xlyprint@%


字段


#
名称
类型
可空


1
sSlaveId
varchar(100)
NO


2
iSlaveOrder
int
NO


3
sParentId
varchar(100)
NO


4
sAccountNo
varchar(255)
NO


5
dMoney
decimal(18,6)
NO


6
sId
varchar(100)
NO


7
sBrandsId
varchar(100)
NO


8
sSubsidiaryId
varchar(100)
NO


9
tCreateDate
datetime
NO


10
sMakePerson
varchar(255)
NO


11
iOrder
int
NO


12
sFormId
varchar(100)
NO


13
sBillNo
varchar(255)
NO


14
sManualNo
varchar(255)
YES


15
sMemo
text
YES


16
bCheck
bit(1)
NO


17
tCheckDate
datetime
YES


18
sCheckPerson
varchar(255)
YES


19
bPrint
bit(1)
NO


20
bCopyLimit
bit(1)
NO


21
sStatus
varchar(255)
YES


22
bInvalid
bit(1)
NO


23
sMReserve1
varchar(255)
YES


24
sMReserve2
varchar(255)
YES


25
sMReserve3
varchar(255)
YES


26
sMReserve4
varchar(255)
YES


27
sMReserve5
varchar(255)
YES


28
sMReserve6
varchar(255)
YES


29
dMReserve1
decimal(18,6)
YES


30
dMReserve2
decimal(18,6)
YES


31
dMReserve3
decimal(18,6)
YES


32
iMReserve1
int
YES


33
iMReserve2
int
YES


34
iMReserve3
int
YES


35
tMReserve1
datetime
YES


36
tMReserve2
datetime
YES


37
sWorkOrderId
varchar(100)
NO


38
sWorkOrderNo
varchar(255)
NO


39
sCostCenterId
varchar(100)
NO


定义
select `s`.`sId` AS `sSlaveId`,`s`.`iOrder` AS `iSlaveOrder`,`s`.`sParentId` AS `sParentId`,`s`.`sAccountNo` AS `sAccountNo`,`s`.`dMoney` AS `dMoney`,`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`.`sWorkOrderId` AS `sWorkOrderId`,`m`.`sWorkOrderNo` AS `sWorkOrderNo`,`m`.`sCostCenterId` AS `sCostCenterId` from (`xlyweberp_saas_ai`.`cahcostchangemaster` `m` join `xlyweberp_saas_ai`.`cahcostchangeslave` `s` on((`m`.`sId` = `s`.`sParentId`)))


说明

暂无人工说明。