viw_hmwxjy.md 3.01 KB

Edit Raw Blame History Permalink



viw_hmwxjy (view)


Updatable: NO


Columns


#
Name
Type
Null


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
已确认数
int
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


Definition
select distinct `b`.`sId` AS `sId`,`a`.`sSrcNo` AS `工单号`,`c`.`sCustomerName` AS `客户名称`,`b`.`sBillNo` AS `外协单号`,`f`.`sProductName` AS `产品名称`,`a`.`dAuxiliaryQty` AS `dAuxiliaryQty`,0 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 (((((`opsoutsideprocessslave` `a` join `opsoutsideprocessmaster` `b`) join `elecustomer` `c`) join `sistax` `d`) join `eleprocess` `e`) join `eleproduct` `f`) 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`))


Narrative

No human-written narrative yet.