viw_mitmaterialscheck.md 8.9 KB

Edit Raw Blame History



viw_mitmaterialscheck（视图）


是否可更新： 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
sFormId
varchar(100)
NO


7
iOrder
int
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
sEmployeeId
varchar(100)
NO


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
sSlaveId
varchar(100)
NO


33
iSlaveOrder
int
NO


34
sMaterialsId
varchar(50)
NO


35
dOriginalAuxiliaryQty
decimal(18,6)
NO


36
dOriginalQty
decimal(18,6)
NO


37
dOriginalMoney
decimal(18,6)
NO


38
dAuxiliaryQty
decimal(18,6)
NO


39
sAuxiliaryUnit
varchar(255)
NO


40
dMaterialsQty
decimal(18,6)
NO


41
dMaterialsPrice
decimal(18,6)
NO


42
dMaterialsMoney
decimal(18,6)
NO


43
dProfitLossAuxiliaryQty
decimal(18,6)
YES


44
dProfitLossQty
decimal(18,6)
YES


45
dProfitLossMoney
decimal(18,6)
YES


46
dProfitLossPrice
decimal(18,6)
YES


47
sSrcId
varchar(100)
NO


48
sSrcSlaveId
varchar(100)
NO


49
sSrcNo
varchar(255)
NO


50
dSrcQty
decimal(18,6)
YES


51
sSlaveMemo
text
YES


52
sBarcode
varchar(255)
YES


53
sDefineNo
varchar(100)
NO


54
sDefineNo2
varchar(100)
NO


55
sWareHouseId
varchar(50)
NO


56
sLocationId
varchar(50)
NO


57
sWareHouseLocationId
varchar(50)
NO


58
sSReserve1
varchar(255)
YES


59
sSReserve2
varchar(255)
YES


60
sSReserve3
varchar(255)
YES


61
sSReserve4
varchar(255)
YES


62
sSReserve5
varchar(255)
YES


63
sSReserve6
varchar(255)
YES


64
dSReserve1
decimal(18,6)
YES


65
dSReserve2
decimal(18,6)
YES


66
dSReserve3
decimal(18,6)
YES


67
iSReserve1
int
YES


68
iSReserve2
int
YES


69
iSReserve3
int
YES


70
tSReserve1
datetime
YES


71
tSReserve2
datetime
YES


72
sMaterialsStyle
varchar(100)
NO


73
iIncrement
int
NO


定义
select `xlyweberp_saas_ai`.`mitmaterialscheckmaster`.`sId` AS `sId`,`xlyweberp_saas_ai`.`mitmaterialscheckmaster`.`sBrandsId` AS `sBrandsId`,`xlyweberp_saas_ai`.`mitmaterialscheckmaster`.`sSubsidiaryId` AS `sSubsidiaryId`,`xlyweberp_saas_ai`.`mitmaterialscheckmaster`.`tCreateDate` AS `tCreateDate`,`xlyweberp_saas_ai`.`mitmaterialscheckmaster`.`sMakePerson` AS `sMakePerson`,`xlyweberp_saas_ai`.`mitmaterialscheckmaster`.`sFormId` AS `sFormId`,`xlyweberp_saas_ai`.`mitmaterialscheckmaster`.`iOrder` AS `iOrder`,`xlyweberp_saas_ai`.`mitmaterialscheckmaster`.`sBillNo` AS `sBillNo`,`xlyweberp_saas_ai`.`mitmaterialscheckmaster`.`sMemo` AS `sMemo`,`xlyweberp_saas_ai`.`mitmaterialscheckmaster`.`bCheck` AS `bCheck`,`xlyweberp_saas_ai`.`mitmaterialscheckmaster`.`tCheckDate` AS `tCheckDate`,`xlyweberp_saas_ai`.`mitmaterialscheckmaster`.`sCheckPerson` AS `sCheckPerson`,`xlyweberp_saas_ai`.`mitmaterialscheckmaster`.`bPrint` AS `bPrint`,`xlyweberp_saas_ai`.`mitmaterialscheckmaster`.`bCopyLimit` AS `bCopyLimit`,`xlyweberp_saas_ai`.`mitmaterialscheckmaster`.`sStatus` AS `sStatus`,`xlyweberp_saas_ai`.`mitmaterialscheckmaster`.`sEmployeeId` AS `sEmployeeId`,`xlyweberp_saas_ai`.`mitmaterialscheckmaster`.`bInvalid` AS `bInvalid`,`xlyweberp_saas_ai`.`mitmaterialscheckmaster`.`sMReserve1` AS `sMReserve1`,`xlyweberp_saas_ai`.`mitmaterialscheckmaster`.`sMReserve2` AS `sMReserve2`,`xlyweberp_saas_ai`.`mitmaterialscheckmaster`.`sMReserve3` AS `sMReserve3`,`xlyweberp_saas_ai`.`mitmaterialscheckmaster`.`sMReserve4` AS `sMReserve4`,`xlyweberp_saas_ai`.`mitmaterialscheckmaster`.`sMReserve5` AS `sMReserve5`,`xlyweberp_saas_ai`.`mitmaterialscheckmaster`.`sMReserve6` AS `sMReserve6`,`xlyweberp_saas_ai`.`mitmaterialscheckmaster`.`dMReserve1` AS `dMReserve1`,`xlyweberp_saas_ai`.`mitmaterialscheckmaster`.`dMReserve2` AS `dMReserve2`,`xlyweberp_saas_ai`.`mitmaterialscheckmaster`.`dMReserve3` AS `dMReserve3`,`xlyweberp_saas_ai`.`mitmaterialscheckmaster`.`iMReserve1` AS `iMReserve1`,`xlyweberp_saas_ai`.`mitmaterialscheckmaster`.`iMReserve2` AS `iMReserve2`,`xlyweberp_saas_ai`.`mitmaterialscheckmaster`.`iMReserve3` AS `iMReserve3`,`xlyweberp_saas_ai`.`mitmaterialscheckmaster`.`tMReserve1` AS `tMReserve1`,`xlyweberp_saas_ai`.`mitmaterialscheckmaster`.`tMReserve2` AS `tMReserve2`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`sId` AS `sSlaveId`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`iOrder` AS `iSlaveOrder`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`sMaterialsId` AS `sMaterialsId`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`dOriginalAuxiliaryQty` AS `dOriginalAuxiliaryQty`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`dOriginalQty` AS `dOriginalQty`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`dOriginalMoney` AS `dOriginalMoney`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`dAuxiliaryQty` AS `dAuxiliaryQty`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`sAuxiliaryUnit` AS `sAuxiliaryUnit`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`dMaterialsQty` AS `dMaterialsQty`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`dMaterialsPrice` AS `dMaterialsPrice`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`dMaterialsMoney` AS `dMaterialsMoney`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`dProfitLossAuxiliaryQty` AS `dProfitLossAuxiliaryQty`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`dProfitLossQty` AS `dProfitLossQty`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`dProfitLossMoney` AS `dProfitLossMoney`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`dProfitLossPrice` AS `dProfitLossPrice`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`sSrcId` AS `sSrcId`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`sSrcSlaveId` AS `sSrcSlaveId`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`sSrcNo` AS `sSrcNo`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`dSrcQty` AS `dSrcQty`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`sSlaveMemo` AS `sSlaveMemo`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`sBarcode` AS `sBarcode`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`sDefineNo` AS `sDefineNo`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`sDefineNo2` AS `sDefineNo2`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`sWareHouseId` AS `sWareHouseId`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`sLocationId` AS `sLocationId`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`sWareHouseLocationId` AS `sWareHouseLocationId`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`sSReserve1` AS `sSReserve1`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`sSReserve2` AS `sSReserve2`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`sSReserve3` AS `sSReserve3`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`sSReserve4` AS `sSReserve4`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`sSReserve5` AS `sSReserve5`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`sSReserve6` AS `sSReserve6`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`dSReserve1` AS `dSReserve1`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`dSReserve2` AS `dSReserve2`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`dSReserve3` AS `dSReserve3`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`iSReserve1` AS `iSReserve1`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`iSReserve2` AS `iSReserve2`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`iSReserve3` AS `iSReserve3`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`tSReserve1` AS `tSReserve1`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`tSReserve2` AS `tSReserve2`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`sMaterialsStyle` AS `sMaterialsStyle`,`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`iIncrement` AS `iIncrement` from (`xlyweberp_saas_ai`.`mitmaterialscheckmaster` join `xlyweberp_saas_ai`.`mitmaterialscheckslave` on((`xlyweberp_saas_ai`.`mitmaterialscheckslave`.`sParentId` = `xlyweberp_saas_ai`.`mitmaterialscheckmaster`.`sId`)))


说明

暂无人工说明。