viw_elematerialsstock.md 8.36 KB

Edit Raw Blame History



viw_elematerialsstock（视图）


是否可更新： NO

定义者： xlyprint@%


字段


#
名称
类型
可空


1
sId
varchar(50)
NO


2
sMaterialsId
varchar(50)
NO


3
sBrandsId
varchar(50)
NO


4
sSubsidiaryId
varchar(50)
NO


5
tCreateDate
datetime
NO


6
sMakePerson
varchar(50)
NO


7
iOrder
int
NO


8
sParentId
varchar(50)
YES


9
sMaterialsType
varchar(50)
YES


10
sMaterialsNo
varchar(50)
NO


11
sMaterialsName
varchar(100)
NO


12
sMaterialsShort
varchar(50)
YES


13
sMaterialsUnit
varchar(50)
YES


14
sAuxiliaryUnit
varchar(6)
NO


15
dCoefficient
decimal(18,6)
YES


16
sConversionUnit
varchar(50)
YES


17
sComputeId
varchar(50)
YES


18
bInverse
bit(1)
NO


19
sReComputeId
varchar(50)
YES


20
sAutoComputeId
varchar(50)
YES


21
sConversionComputeId
varchar(50)
YES


22
sReConversionComputeId
varchar(50)
YES


23
dGramWeight
decimal(18,6)
YES


24
bPurchase
bit(1)
NO


25
bReel
bit(1)
NO


26
bSales
bit(1)
NO


27
bCorrugate
bit(1)
NO


28
dPurchasePrice
decimal(18,6)
YES


29
dSalesPrice
decimal(18,6)
YES


30
dRecentPurchasePrice
decimal(18,6)
YES


31
dDesignateSalesPrice
decimal(18,6)
YES


32
dProcurementCycle
decimal(18,6)
YES


33
sSupplyId
varchar(50)
YES


34
bCheck
bit(1)
NO


35
bInvalid
bit(1)
NO


36
sMemo
text
YES


37
bComMaterials
bit(1)
NO


38
sMReserve1
varchar(50)
YES


39
sMReserve2
varchar(50)
YES


40
sMReserve3
varchar(50)
YES


41
sMReserve4
varchar(50)
YES


42
sMReserve5
varchar(50)
YES


43
sMReserve6
varchar(50)
YES


44
dMReserve1
decimal(18,6)
YES


45
dMReserve2
decimal(18,6)
YES


46
dMReserve3
decimal(18,6)
YES


47
iMReserve1
int
YES


48
iMReserve2
int
YES


49
iMReserve3
int
YES


50
tMReserve1
datetime
YES


51
tMReserve2
datetime
YES


52
sSlaveId
varchar(50)
YES


53
sMaterialsStyle
varchar(50)
YES


54
sDefineNo
varchar(50)
YES


55
sDefineNo2
varchar(50)
YES


56
sWarehouseId
varchar(50)
YES


57
sLocationId
varchar(50)
YES


58
sWarehouseLocationId
varchar(50)
YES


59
dAuxiliaryQty
decimal(18,6)
YES


60
dMaterialsQty
decimal(18,6)
YES


61
dConversionQty
decimal(18,6)
YES


62
dMaterialsPrice
decimal(18,6)
YES


63
dMaterialsMoney
decimal(18,2)
YES


64
tInventoryDate
datetime
YES


65
dMinStock
decimal(18,6)
YES


66
dMaxStock
decimal(18,6)
YES


67
sFormId
varchar(50)
YES


68
dMinStockAuxiliaryQty
decimal(18,6)
YES


69
dMaxStockAuxiliaryQty
decimal(18,6)
YES


70
bQuotation
bit(1)
YES


71
bShow
decimal(1,0)
NO


定义
select `xlyweberp_saas_ai`.`elematerials`.`sId` AS `sId`,`xlyweberp_saas_ai`.`elematerials`.`sId` AS `sMaterialsId`,`xlyweberp_saas_ai`.`elematerials`.`sBrandsId` AS `sBrandsId`,`xlyweberp_saas_ai`.`elematerials`.`sSubsidiaryId` AS `sSubsidiaryId`,`xlyweberp_saas_ai`.`elematerials`.`tCreateDate` AS `tCreateDate`,`xlyweberp_saas_ai`.`elematerials`.`sMakePerson` AS `sMakePerson`,`xlyweberp_saas_ai`.`elematerials`.`iOrder` AS `iOrder`,`xlyweberp_saas_ai`.`elematerials`.`sParentId` AS `sParentId`,`xlyweberp_saas_ai`.`elematerials`.`sMaterialsType` AS `sMaterialsType`,`xlyweberp_saas_ai`.`elematerials`.`sMaterialsNo` AS `sMaterialsNo`,`xlyweberp_saas_ai`.`elematerials`.`sMaterialsName` AS `sMaterialsName`,`xlyweberp_saas_ai`.`elematerials`.`sMaterialsShort` AS `sMaterialsShort`,`xlyweberp_saas_ai`.`elematerials`.`sMaterialsUnit` AS `sMaterialsUnit`,`xlyweberp_saas_ai`.`elematerials`.`sAuxiliaryUnit` AS `sAuxiliaryUnit`,`xlyweberp_saas_ai`.`elematerials`.`dCoefficient` AS `dCoefficient`,`xlyweberp_saas_ai`.`elematerials`.`sConversionUnit` AS `sConversionUnit`,`xlyweberp_saas_ai`.`elematerials`.`sComputeId` AS `sComputeId`,`xlyweberp_saas_ai`.`elematerials`.`bInverse` AS `bInverse`,`xlyweberp_saas_ai`.`elematerials`.`sReComputeId` AS `sReComputeId`,`xlyweberp_saas_ai`.`elematerials`.`sAutoComputeId` AS `sAutoComputeId`,`xlyweberp_saas_ai`.`elematerials`.`sConversionComputeId` AS `sConversionComputeId`,`xlyweberp_saas_ai`.`elematerials`.`sReConversionComputeId` AS `sReConversionComputeId`,`xlyweberp_saas_ai`.`elematerials`.`dGramWeight` AS `dGramWeight`,`xlyweberp_saas_ai`.`elematerials`.`bPurchase` AS `bPurchase`,`xlyweberp_saas_ai`.`elematerials`.`bReel` AS `bReel`,`xlyweberp_saas_ai`.`elematerials`.`bSales` AS `bSales`,`xlyweberp_saas_ai`.`elematerials`.`bCorrugate` AS `bCorrugate`,`xlyweberp_saas_ai`.`elematerials`.`dPurchasePrice` AS `dPurchasePrice`,`xlyweberp_saas_ai`.`elematerials`.`dSalesPrice` AS `dSalesPrice`,`xlyweberp_saas_ai`.`elematerials`.`dRecentPurchasePrice` AS `dRecentPurchasePrice`,`xlyweberp_saas_ai`.`elematerials`.`dDesignateSalesPrice` AS `dDesignateSalesPrice`,`xlyweberp_saas_ai`.`elematerials`.`dProcurementCycle` AS `dProcurementCycle`,`xlyweberp_saas_ai`.`elematerials`.`sSupplyId` AS `sSupplyId`,`xlyweberp_saas_ai`.`elematerials`.`bCheck` AS `bCheck`,`xlyweberp_saas_ai`.`elematerials`.`bInvalid` AS `bInvalid`,`xlyweberp_saas_ai`.`elematerials`.`sMemo` AS `sMemo`,`xlyweberp_saas_ai`.`elematerials`.`bComMaterials` AS `bComMaterials`,`xlyweberp_saas_ai`.`elematerials`.`sMReserve1` AS `sMReserve1`,`xlyweberp_saas_ai`.`elematerials`.`sMReserve2` AS `sMReserve2`,`xlyweberp_saas_ai`.`elematerials`.`sMReserve3` AS `sMReserve3`,`xlyweberp_saas_ai`.`elematerials`.`sMReserve4` AS `sMReserve4`,`xlyweberp_saas_ai`.`elematerials`.`sMReserve5` AS `sMReserve5`,`xlyweberp_saas_ai`.`elematerials`.`sMReserve6` AS `sMReserve6`,`xlyweberp_saas_ai`.`elematerials`.`dMReserve1` AS `dMReserve1`,`xlyweberp_saas_ai`.`elematerials`.`dMReserve2` AS `dMReserve2`,`xlyweberp_saas_ai`.`elematerials`.`dMReserve3` AS `dMReserve3`,`xlyweberp_saas_ai`.`elematerials`.`iMReserve1` AS `iMReserve1`,`xlyweberp_saas_ai`.`elematerials`.`iMReserve2` AS `iMReserve2`,`xlyweberp_saas_ai`.`elematerials`.`iMReserve3` AS `iMReserve3`,`xlyweberp_saas_ai`.`elematerials`.`tMReserve1` AS `tMReserve1`,`xlyweberp_saas_ai`.`elematerials`.`tMReserve2` AS `tMReserve2`,if((ifnull(`xlyweberp_saas_ai`.`elematerialsstock`.`sId`,'') = ''),`xlyweberp_saas_ai`.`elematerials`.`sId`,`xlyweberp_saas_ai`.`elematerialsstock`.`sId`) AS `sSlaveId`,`xlyweberp_saas_ai`.`elematerialsstock`.`sMaterialsStyle` AS `sMaterialsStyle`,`xlyweberp_saas_ai`.`elematerialsstock`.`sDefineNo` AS `sDefineNo`,`xlyweberp_saas_ai`.`elematerialsstock`.`sDefineNo2` AS `sDefineNo2`,`xlyweberp_saas_ai`.`elematerialsstock`.`sWarehouseId` AS `sWarehouseId`,`xlyweberp_saas_ai`.`elematerialsstock`.`sLocationId` AS `sLocationId`,`xlyweberp_saas_ai`.`elematerialsstock`.`sWarehouseLocationId` AS `sWarehouseLocationId`,`xlyweberp_saas_ai`.`elematerialsstock`.`dAuxiliaryQty` AS `dAuxiliaryQty`,`xlyweberp_saas_ai`.`elematerialsstock`.`dMaterialsQty` AS `dMaterialsQty`,`xlyweberp_saas_ai`.`elematerialsstock`.`dConversionQty` AS `dConversionQty`,`xlyweberp_saas_ai`.`elematerialsstock`.`dMaterialsPrice` AS `dMaterialsPrice`,`xlyweberp_saas_ai`.`elematerialsstock`.`dMaterialsMoney` AS `dMaterialsMoney`,`xlyweberp_saas_ai`.`elematerialsstock`.`tInventoryDate` AS `tInventoryDate`,`xlyweberp_saas_ai`.`elematerialsstock`.`dMinStock` AS `dMinStock`,`xlyweberp_saas_ai`.`elematerialsstock`.`dMaxStock` AS `dMaxStock`,`xlyweberp_saas_ai`.`elematerialsstock`.`sFormId` AS `sFormId`,`xlyweberp_saas_ai`.`elematerialsstock`.`dMinStockAuxiliaryQty` AS `dMinStockAuxiliaryQty`,`xlyweberp_saas_ai`.`elematerialsstock`.`dMaxStockAuxiliaryQty` AS `dMaxStockAuxiliaryQty`,`xlyweberp_saas_ai`.`elematerialsstock`.`bQuotation` AS `bQuotation`,ifnull(`xlyweberp_saas_ai`.`elematerialsstock`.`bShow`,0) AS `bShow` from (`xlyweberp_saas_ai`.`elematerials` left join `xlyweberp_saas_ai`.`elematerialsstock` on((`xlyweberp_saas_ai`.`elematerialsstock`.`sMaterialsId` = `xlyweberp_saas_ai`.`elematerials`.`sId`)))


说明

暂无人工说明。