viw_eleproductprices.md 6.61 KB

Edit Raw Blame History



viw_eleproductprices (view)


VIEW


Updatable: YES

Definer: xlyprint@%


Columns


#
Name
Type
Null


1
iIncrement
int
NO


2
sId
varchar(100)
NO


3
sBillNo
varchar(50)
YES


4
sBrandsId
varchar(100)
NO


5
sSubsidiaryId
varchar(100)
NO


6
tCreateDate
datetime
NO


7
sMakePerson
varchar(255)
NO


8
iOrder
int
NO


9
sCustomerId
varchar(100)
NO


10
sProductId
varchar(255)
NO


11
sMemo
text
YES


12
bInvalid
bit(1)
NO


13
sMReserve1
varchar(255)
YES


14
sMReserve2
varchar(255)
YES


15
sMReserve3
varchar(255)
YES


16
sMReserve5
varchar(255)
YES


17
sMReserve4
varchar(255)
YES


18
sMReserve6
varchar(255)
YES


19
dMReserve1
decimal(18,6)
YES


20
dMReserve2
decimal(18,6)
YES


21
dMReserve3
decimal(18,6)
YES


22
iMReserve1
int
YES


23
iMReserve2
int
YES


24
iMReserve3
int
YES


25
tMReserve1
datetime
YES


26
tMReserve2
datetime
YES


27
bStartMark
bit(1)
NO


28
sFormId
varchar(255)
YES


29
tCheckDate
datetime
YES


30
sCheckPerson
varchar(255)
YES


31
sStatus
varchar(255)
YES


32
bCheck
bit(1)
YES


33
sSlaveId
varchar(100)
NO


34
sParentId
varchar(100)
NO


35
dProductPrice
decimal(24,13)
NO


36
dQuotationPrice
decimal(24,13)
NO


37
tQuotationDate
datetime
YES


38
sSlaveMemo
varchar(2000)
YES


39
dQuoRate
decimal(18,6)
YES


40
dQuoPrice
decimal(24,13)
NO


41
dBeginQty
decimal(18,0)
NO


42
dEndQty
decimal(18,0)
NO


43
sCurrency
varchar(255)
YES


44
sEvaluateNo
varchar(255)
YES


45
sState
varchar(3)
NO


46
dQuoMaterialsPrice
decimal(24,13)
NO


47
dAssistMaterialsPrice
decimal(24,13)
NO


48
dQuoPrintPrice
decimal(24,13)
NO


49
dQuoPrintAfterPrice
decimal(24,13)
NO


50
dQuoManualPrice
decimal(24,13)
NO


51
dQuoFreightPrice
decimal(24,13)
NO


Definition
select `xlyweberp_saas_ai`.`eleproductpricemaster`.`iIncrement` AS `iIncrement`,`xlyweberp_saas_ai`.`eleproductpricemaster`.`sId` AS `sId`,`xlyweberp_saas_ai`.`eleproductpricemaster`.`sBillNo` AS `sBillNo`,`xlyweberp_saas_ai`.`eleproductpricemaster`.`sBrandsId` AS `sBrandsId`,`xlyweberp_saas_ai`.`eleproductpricemaster`.`sSubsidiaryId` AS `sSubsidiaryId`,`xlyweberp_saas_ai`.`eleproductpricemaster`.`tCreateDate` AS `tCreateDate`,`xlyweberp_saas_ai`.`eleproductpricemaster`.`sMakePerson` AS `sMakePerson`,`xlyweberp_saas_ai`.`eleproductpricemaster`.`iOrder` AS `iOrder`,`xlyweberp_saas_ai`.`eleproductpricemaster`.`sCustomerId` AS `sCustomerId`,`xlyweberp_saas_ai`.`eleproductpricemaster`.`sProductId` AS `sProductId`,`xlyweberp_saas_ai`.`eleproductpricemaster`.`sMemo` AS `sMemo`,`xlyweberp_saas_ai`.`eleproductpricemaster`.`bInvalid` AS `bInvalid`,`xlyweberp_saas_ai`.`eleproductpricemaster`.`sMReserve1` AS `sMReserve1`,`xlyweberp_saas_ai`.`eleproductpricemaster`.`sMReserve2` AS `sMReserve2`,`xlyweberp_saas_ai`.`eleproductpricemaster`.`sMReserve3` AS `sMReserve3`,`xlyweberp_saas_ai`.`eleproductpricemaster`.`sMReserve5` AS `sMReserve5`,`xlyweberp_saas_ai`.`eleproductpricemaster`.`sMReserve4` AS `sMReserve4`,`xlyweberp_saas_ai`.`eleproductpricemaster`.`sMReserve6` AS `sMReserve6`,`xlyweberp_saas_ai`.`eleproductpricemaster`.`dMReserve1` AS `dMReserve1`,`xlyweberp_saas_ai`.`eleproductpricemaster`.`dMReserve2` AS `dMReserve2`,`xlyweberp_saas_ai`.`eleproductpricemaster`.`dMReserve3` AS `dMReserve3`,`xlyweberp_saas_ai`.`eleproductpricemaster`.`iMReserve1` AS `iMReserve1`,`xlyweberp_saas_ai`.`eleproductpricemaster`.`iMReserve2` AS `iMReserve2`,`xlyweberp_saas_ai`.`eleproductpricemaster`.`iMReserve3` AS `iMReserve3`,`xlyweberp_saas_ai`.`eleproductpricemaster`.`tMReserve1` AS `tMReserve1`,`xlyweberp_saas_ai`.`eleproductpricemaster`.`tMReserve2` AS `tMReserve2`,`xlyweberp_saas_ai`.`eleproductpricemaster`.`bStartMark` AS `bStartMark`,`xlyweberp_saas_ai`.`eleproductpricemaster`.`sFormId` AS `sFormId`,`xlyweberp_saas_ai`.`eleproductpricemaster`.`tCheckDate` AS `tCheckDate`,`xlyweberp_saas_ai`.`eleproductpricemaster`.`sCheckPerson` AS `sCheckPerson`,`xlyweberp_saas_ai`.`eleproductpricemaster`.`sStatus` AS `sStatus`,`xlyweberp_saas_ai`.`eleproductpricemaster`.`bCheck` AS `bCheck`,`xlyweberp_saas_ai`.`eleproductpriceslave`.`sId` AS `sSlaveId`,`xlyweberp_saas_ai`.`eleproductpriceslave`.`sParentId` AS `sParentId`,`xlyweberp_saas_ai`.`eleproductpriceslave`.`dProductPrice` AS `dProductPrice`,`xlyweberp_saas_ai`.`eleproductpriceslave`.`dQuotationPrice` AS `dQuotationPrice`,`xlyweberp_saas_ai`.`eleproductpriceslave`.`tQuotationDate` AS `tQuotationDate`,`xlyweberp_saas_ai`.`eleproductpriceslave`.`sSlaveMemo` AS `sSlaveMemo`,`xlyweberp_saas_ai`.`eleproductpriceslave`.`dQuoRate` AS `dQuoRate`,`xlyweberp_saas_ai`.`eleproductpriceslave`.`dQuoPrice` AS `dQuoPrice`,`xlyweberp_saas_ai`.`eleproductpriceslave`.`dBeginQty` AS `dBeginQty`,`xlyweberp_saas_ai`.`eleproductpriceslave`.`dEndQty` AS `dEndQty`,`xlyweberp_saas_ai`.`eleproductpriceslave`.`sCurrency` AS `sCurrency`,`xlyweberp_saas_ai`.`eleproductpriceslave`.`sEvaluateNo` AS `sEvaluateNo`,(case when (`xlyweberp_saas_ai`.`eleproductpricemaster`.`bInvalid` = 1) then '已作废' when (`xlyweberp_saas_ai`.`eleproductpricemaster`.`sStatus` = 0) then '未审核' when (`xlyweberp_saas_ai`.`eleproductpricemaster`.`sStatus` = 1) then '已审核' when (`xlyweberp_saas_ai`.`eleproductpricemaster`.`sStatus` = 2) then '审批中' when (`xlyweberp_saas_ai`.`eleproductpricemaster`.`sStatus` = 4) then '已驳回' else '未审核' end) AS `sState`,`xlyweberp_saas_ai`.`eleproductpriceslave`.`dQuoMaterialsPrice` AS `dQuoMaterialsPrice`,`xlyweberp_saas_ai`.`eleproductpriceslave`.`dAssistMaterialsPrice` AS `dAssistMaterialsPrice`,`xlyweberp_saas_ai`.`eleproductpriceslave`.`dQuoPrintPrice` AS `dQuoPrintPrice`,`xlyweberp_saas_ai`.`eleproductpriceslave`.`dQuoPrintAfterPrice` AS `dQuoPrintAfterPrice`,`xlyweberp_saas_ai`.`eleproductpriceslave`.`dQuoManualPrice` AS `dQuoManualPrice`,`xlyweberp_saas_ai`.`eleproductpriceslave`.`dQuoFreightPrice` AS `dQuoFreightPrice` from (`xlyweberp_saas_ai`.`eleproductpricemaster` join `xlyweberp_saas_ai`.`eleproductpriceslave` on((`xlyweberp_saas_ai`.`eleproductpricemaster`.`sId` = `xlyweberp_saas_ai`.`eleproductpriceslave`.`sParentId`)))


Narrative

No human-written narrative yet.