viw_mitmaterialsinit.md 6.62 KB

Edit Raw Blame History



viw_mitmaterialsinit（视图）


是否可更新： YES

定义者： 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
sMemo
text
YES


10
bCheck
bit(1)
NO


11
tCheckDate
datetime
YES


12
sCheckPerson
varchar(255)
YES


13
bPrint
bit(1)
NO


14
bCopyLimit
bit(1)
NO


15
sStatus
varchar(255)
YES


16
sWareHouseId
varchar(100)
NO


17
sLocationId
varchar(100)
NO


18
sWareHouseLocationId
varchar(100)
NO


19
sEmployeeId
varchar(100)
NO


20
bInvalid
bit(1)
NO


21
sMReserve1
varchar(255)
YES


22
sMReserve2
varchar(255)
YES


23
sMReserve3
varchar(255)
YES


24
sMReserve4
varchar(255)
YES


25
sMReserve5
varchar(255)
YES


26
sMReserve6
varchar(255)
YES


27
dMReserve1
decimal(18,6)
YES


28
dMReserve2
decimal(18,6)
YES


29
dMReserve3
decimal(18,6)
YES


30
iMReserve1
int
YES


31
iMReserve2
int
YES


32
iMReserve3
int
YES


33
tMReserve1
datetime
YES


34
tMReserve2
datetime
YES


35
iIncrement
int
NO


36
sSlaveId
varchar(100)
NO


37
iSlaveOrder
int
NO


38
sSlaveMakePerson
varchar(255)
YES


39
sParentId
varchar(100)
NO


40
sMaterialsId
varchar(100)
NO


41
sMaterialsStyle
varchar(100)
NO


42
dOriginalAuxiliaryQty
decimal(18,6)
NO


43
dOriginalQty
decimal(18,6)
NO


44
dOriginalMoney
decimal(18,6)
NO


45
dAuxiliaryQty
decimal(18,6)
NO


46
sAuxiliaryUnit
varchar(255)
NO


47
dMaterialsQty
decimal(18,6)
NO


48
dConversionQty
decimal(18,6)
NO


49
dMaterialsPrice
decimal(18,6)
NO


50
dMaterialsMoney
decimal(18,6)
NO


51
dProfitLossAuxiliaryQty
decimal(18,6)
YES


52
dProfitLossQty
decimal(18,6)
YES


53
dProfitLossMoney
decimal(18,6)
YES


54
dProfitLossPrice
decimal(18,6)
YES


55
sSrcSlaveId
varchar(100)
NO


56
sSrcId
varchar(100)
NO


57
sSrcNo
varchar(255)
NO


58
dSrcQty
decimal(18,6)
YES


59
sSlaveMemo
text
YES


60
sBarcode
varchar(255)
YES


61
sDefineNo
varchar(100)
NO


62
sDefineNo2
varchar(100)
NO


63
sSlaveWareHouseId
varchar(100)
NO


64
sSlaveLocationId
varchar(100)
NO


65
sSlaveWareHouseLocationId
varchar(100)
NO


66
sSlaveSReserve1
varchar(255)
YES


67
sSlaveSReserve2
varchar(255)
YES


68
sSlaveSReserve3
varchar(255)
YES


69
sSlaveSReserve4
varchar(255)
YES


70
sSlaveSReserve5
varchar(255)
YES


71
sSlaveSReserve6
varchar(255)
YES


72
dSlaveSReserve1
decimal(18,6)
YES


73
dSlaveSReserve2
decimal(18,6)
YES


74
dSlaveSReserve3
decimal(18,6)
YES


75
iSlaveSReserve1
int
YES


76
iSlaveSReserve2
int
YES


77
iSlaveSReserve3
int
YES


78
tSlaveSReserve1
datetime
YES


79
tSlaveReserve2
datetime
YES


80
tCurrDate
datetime
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`.`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`.`sWareHouseId` AS `sWareHouseId`,`m`.`sLocationId` AS `sLocationId`,`m`.`sWareHouseLocationId` AS `sWareHouseLocationId`,`m`.`sEmployeeId` AS `sEmployeeId`,`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`,`s`.`iIncrement` AS `iIncrement`,`s`.`sId` AS `sSlaveId`,`s`.`iOrder` AS `iSlaveOrder`,`s`.`sMakePerson` AS `sSlaveMakePerson`,`s`.`sParentId` AS `sParentId`,`s`.`sMaterialsId` AS `sMaterialsId`,`s`.`sMaterialsStyle` AS `sMaterialsStyle`,`s`.`dOriginalAuxiliaryQty` AS `dOriginalAuxiliaryQty`,`s`.`dOriginalQty` AS `dOriginalQty`,`s`.`dOriginalMoney` AS `dOriginalMoney`,`s`.`dAuxiliaryQty` AS `dAuxiliaryQty`,`s`.`sAuxiliaryUnit` AS `sAuxiliaryUnit`,`s`.`dMaterialsQty` AS `dMaterialsQty`,`s`.`dConversionQty` AS `dConversionQty`,`s`.`dMaterialsPrice` AS `dMaterialsPrice`,`s`.`dMaterialsMoney` AS `dMaterialsMoney`,`s`.`dProfitLossAuxiliaryQty` AS `dProfitLossAuxiliaryQty`,`s`.`dProfitLossQty` AS `dProfitLossQty`,`s`.`dProfitLossMoney` AS `dProfitLossMoney`,`s`.`dProfitLossPrice` AS `dProfitLossPrice`,`s`.`sSrcSlaveId` AS `sSrcSlaveId`,`s`.`sSrcId` AS `sSrcId`,`s`.`sSrcNo` AS `sSrcNo`,`s`.`dSrcQty` AS `dSrcQty`,`s`.`sSlaveMemo` AS `sSlaveMemo`,`s`.`sBarcode` AS `sBarcode`,`s`.`sDefineNo` AS `sDefineNo`,`s`.`sDefineNo2` AS `sDefineNo2`,`s`.`sWareHouseId` AS `sSlaveWareHouseId`,`s`.`sLocationId` AS `sSlaveLocationId`,`s`.`sWareHouseLocationId` AS `sSlaveWareHouseLocationId`,`s`.`sSReserve1` AS `sSlaveSReserve1`,`s`.`sSReserve2` AS `sSlaveSReserve2`,`s`.`sSReserve3` AS `sSlaveSReserve3`,`s`.`sSReserve4` AS `sSlaveSReserve4`,`s`.`sSReserve5` AS `sSlaveSReserve5`,`s`.`sSReserve6` AS `sSlaveSReserve6`,`s`.`dSReserve1` AS `dSlaveSReserve1`,`s`.`dSReserve2` AS `dSlaveSReserve2`,`s`.`dSReserve3` AS `dSlaveSReserve3`,`s`.`iSReserve1` AS `iSlaveSReserve1`,`s`.`iSReserve2` AS `iSlaveSReserve2`,`s`.`iSReserve3` AS `iSlaveSReserve3`,`s`.`tSReserve1` AS `tSlaveSReserve1`,`s`.`tSReserve2` AS `tSlaveReserve2`,`s`.`tCurrDate` AS `tCurrDate` from (`xlyweberp_saas_ai`.`mitmaterialsinitmaster` `m` join `xlyweberp_saas_ai`.`mitmaterialsinitslave` `s` on((`s`.`sParentId` = `m`.`sId`)))


说明

暂无人工说明。