viw_ai_elematerialsstock.md 6.38 KB

Edit Raw Blame History



viw_ai_elematerialsstock（视图）


是否可更新： NO

定义者： xlyprint@%


字段


#
名称
类型
可空


1
sId
varchar(50)
NO


2
sSlaveId
varchar(50)
NO


3
sBrandsId
varchar(50)
NO


4
sSubsidiaryId
varchar(50)
NO


5
tCreateDate
datetime
NO


6
tUpdateDate
datetime
NO


7
sMakePerson
varchar(50)
NO


8
iOrder
int
NO


9
sParentId
varchar(50)
YES


10
sMaterialsType
varchar(50)
YES


11
sMaterialsNo
varchar(50)
NO


12
sMaterialsName
varchar(100)
NO


13
sMaterialsSortName
varchar(100)
YES


14
sMaterialsShort
varchar(50)
YES


15
sMaterialsUnit
varchar(50)
YES


16
sAuxiliaryUnit
varchar(6)
NO


17
dCoefficient
decimal(18,6)
YES


18
sConversionUnit
varchar(50)
YES


19
dGramWeight
decimal(18,6)
YES


20
bPurchase
bit(1)
NO


21
bReel
bit(1)
NO


22
bSales
bit(1)
NO


23
bCorrugate
bit(1)
NO


24
dPurchasePrice
decimal(18,6)
YES


25
dSalesPrice
decimal(18,6)
YES


26
dRecentPurchasePrice
decimal(18,6)
YES


27
dDesignateSalesPrice
decimal(18,6)
YES


28
dProcurementCycle
decimal(18,6)
YES


29
sSupplyId
varchar(50)
YES


30
bCheck
bit(1)
NO


31
bInvalid
bit(1)
NO


32
sMemo
text
YES


33
bComMaterials
bit(1)
NO


34
sMaterialsStyle
varchar(50)
YES


35
sDefineNo
varchar(50)
YES


36
sDefineNo2
varchar(50)
YES


37
sLocationsName
varchar(255)
YES


38
sWarehouseName
varchar(255)
YES


39
dAuxiliaryQty
decimal(18,6)
YES


40
dMaterialsQty
decimal(18,6)
YES


41
dConversionQty
decimal(18,6)
YES


42
dMaterialsPrice
decimal(18,6)
YES


43
dMaterialsMoney
decimal(18,2)
YES


44
tmakedate
datetime
YES


45
dMinStock
decimal(18,6)
YES


46
dMaxStock
decimal(18,6)
YES


47
dMinStockAuxiliaryQty
decimal(18,6)
YES


48
dMaxStockAuxiliaryQty
decimal(18,6)
YES


49
bQuotation
bit(1)
NO


50
sMtart
varchar(4)
NO


定义
select `xlyweberp_saas_ai`.`elematerials`.`sId` AS `sId`,`xlyweberp_saas_ai`.`elematerials`.`sId` AS `sSlaveId`,`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`.`tCreateDate` AS `tUpdateDate`,`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`.`sismaterialsclassify`.`sName` AS `sMaterialsSortName`,`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`.`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`.`elematerialsstock`.`sMaterialsStyle` AS `sMaterialsStyle`,`xlyweberp_saas_ai`.`elematerialsstock`.`sDefineNo` AS `sDefineNo`,`xlyweberp_saas_ai`.`elematerialsstock`.`sDefineNo2` AS `sDefineNo2`,`xlyweberp_saas_ai`.`sislocation`.`sName` AS `sLocationsName`,`xlyweberp_saas_ai`.`siswarehouse`.`sName` AS `sWarehouseName`,`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`.`tMakeDate` AS `tmakedate`,`xlyweberp_saas_ai`.`elematerialsstock`.`dMinStock` AS `dMinStock`,`xlyweberp_saas_ai`.`elematerialsstock`.`dMaxStock` AS `dMaxStock`,`xlyweberp_saas_ai`.`elematerialsstock`.`dMinStockAuxiliaryQty` AS `dMinStockAuxiliaryQty`,`xlyweberp_saas_ai`.`elematerialsstock`.`dMaxStockAuxiliaryQty` AS `dMaxStockAuxiliaryQty`,`xlyweberp_saas_ai`.`elematerials`.`bQuotation` AS `bQuotation`,`xlyweberp_saas_ai`.`elematerials`.`sMtart` AS `sMtart` from ((((`xlyweberp_saas_ai`.`elematerials` left join `xlyweberp_saas_ai`.`elematerialsstock` on((`xlyweberp_saas_ai`.`elematerialsstock`.`sMaterialsId` = `xlyweberp_saas_ai`.`elematerials`.`sId`))) left join `xlyweberp_saas_ai`.`sismaterialsclassify` on((`xlyweberp_saas_ai`.`sismaterialsclassify`.`sId` = `xlyweberp_saas_ai`.`elematerials`.`sParentId`))) left join `xlyweberp_saas_ai`.`siswarehouse` on((`xlyweberp_saas_ai`.`siswarehouse`.`sId` = `xlyweberp_saas_ai`.`elematerialsstock`.`sWarehouseId`))) left join `xlyweberp_saas_ai`.`sislocation` on((`xlyweberp_saas_ai`.`sislocation`.`sId` = `xlyweberp_saas_ai`.`elematerialsstock`.`sLocationId`)))


说明

暂无人工说明。