viw_hmwxjy2.md 3.36 KB

Edit Raw Blame History Permalink



viw_hmwxjy2（视图）


是否可更新： YES

定义者： xlyprint@%


字段


#
名称
类型
可空


1
sId
varchar(100)
NO


2
工单号
varchar(255)
NO


3
客户名称
varchar(255)
NO


4
外协单号
varchar(255)
NO


5
产品名称
varchar(100)
NO


6
dAuxiliaryQty
decimal(18,6)
NO


7
已确认数
decimal(18,6)
NO


8
发外工序
varchar(100)
NO


9
规格
varchar(255)
NO


10
采购单位
varchar(255)
NO


11
单价
decimal(18,6)
NO


12
金额
decimal(18,6)
NO


13
税码
varchar(255)
NO


14
不含税单价
decimal(18,6)
YES


15
不含税金额
decimal(18,6)
YES


16
税额
decimal(18,6)
YES


17
iOrder
int
NO


18
bCopyLimit
bit(1)
NO


19
bCheck
bit(1)
NO


20
bInStoreComplete
bit(1)
NO


21
tCreateDate
datetime
NO


22
sSupplyId
varchar(100)
NO


23
sCustomerId
varchar(100)
NO


24
sProductId
varchar(100)
NO


25
sProcessId
varchar(100)
NO


26
sPurchaseManId
varchar(100)
YES


27
sGetPayId
varchar(100)
YES


28
sSrcSlaveId
varchar(100)
NO


29
sFormId
varchar(100)
NO


30
sParentId
varchar(100)
NO


31
sSrcId
varchar(100)
NO


32
sSlaveId
varchar(100)
NO


33
sTaxId
varchar(100)
YES


34
iTestType
int
NO


定义
select `b`.`sId` AS `sId`,`a`.`sSrcNo` AS `工单号`,`c`.`sCustomerName` AS `客户名称`,`b`.`sBillNo` AS `外协单号`,`f`.`sProductName` AS `产品名称`,`a`.`dAuxiliaryQty` AS `dAuxiliaryQty`,`j`.`dAuxiliaryQty` AS `已确认数`,`e`.`sProcessName` AS `发外工序`,`a`.`sMaterialsStyle` AS `规格`,`a`.`sAuxiliaryUnit` AS `采购单位`,`a`.`dMaterialsPrice` AS `单价`,`a`.`dMaterialsMoney` AS `金额`,`d`.`sName` AS `税码`,`a`.`dMaterialsNoTaxPrice` AS `不含税单价`,`a`.`dMaterialsNoTaxMoney` AS `不含税金额`,`a`.`dMaterialsTaxMoney` AS `税额`,`a`.`iOrder` AS `iOrder`,`b`.`bCopyLimit` AS `bCopyLimit`,`b`.`bCheck` AS `bCheck`,`a`.`bInStoreComplete` AS `bInStoreComplete`,`b`.`tCreateDate` AS `tCreateDate`,`b`.`sSupplyId` AS `sSupplyId`,`a`.`sCustomerId` AS `sCustomerId`,`a`.`sProductId` AS `sProductId`,`a`.`sProcessId` AS `sProcessId`,`b`.`sPurchaseManId` AS `sPurchaseManId`,`b`.`sGetPayId` AS `sGetPayId`,`a`.`sSrcSlaveId` AS `sSrcSlaveId`,`b`.`sFormId` AS `sFormId`,`a`.`sParentId` AS `sParentId`,`a`.`sSrcId` AS `sSrcId`,`a`.`sId` AS `sSlaveId`,`a`.`sTaxId` AS `sTaxId`,`e`.`iTestType` AS `iTestType` from ((((((`xlyweberp_saas_ai`.`opsoutsideprocessslave` `a` join `xlyweberp_saas_ai`.`opsoutsideprocessmaster` `b`) join `xlyweberp_saas_ai`.`elecustomer` `c`) join `xlyweberp_saas_ai`.`sistax` `d`) join `xlyweberp_saas_ai`.`eleprocess` `e`) join `xlyweberp_saas_ai`.`eleproduct` `f`) join `xlyweberp_saas_ai`.`opsoutsideinstoreslave` `j`) where ((`a`.`sParentId` = `b`.`sId`) and (`a`.`sCustomerId` = `c`.`sId`) and (`a`.`sTaxId` = `d`.`sId`) and (`a`.`sProcessId` = `e`.`sId`) and (`a`.`sProductId` = `f`.`sId`) and (`a`.`sSrcNo` = `j`.`sWorkOrderNo`) and (`a`.`sProductId` = `j`.`sProductId`) and (`a`.`sCustomerId` = `j`.`sCustomerId`))


说明

暂无人工说明。