viw_zsgd_lld_materialanalysis.md 3.81 KB

Edit Raw Blame History



viw_zsgd_lld_materialanalysis (view)


VIEW


Updatable: NO

Definer: xlyprint@%


Columns


#
Name
Type
Null


1
sId
varchar(100)
NO


2
sBillNo
varchar(255)
NO


3
tCreateDate
datetime
NO


4
sCustomerName
varchar(255)
YES


5
sProductName
varchar(100)
YES


6
sMaterialsId
varchar(100)
NO


7
lldsMaterialsId
varchar(100)
YES


8
sMaterialsStyle
varchar(255)
NO


9
lldsMaterialsName
varchar(100)
YES


10
sMaterialsName
varchar(100)
YES


11
iOrder
int
YES


12
dAuxiliaryQty
decimal(18,6)
NO


13
LldQty
decimal(40,6)
YES


14
LldsMaterialsStyle
varchar(255)
YES


15
dProductQty
decimal(18,6)
NO


16
dDifQty
decimal(41,6)
YES


17
sProductId
varchar(100)
NO


18
sCustomerId
varchar(100)
NO


19
sBrandsId
varchar(100)
NO


20
sSubsidiaryId
varchar(100)
NO


21
sSlaveId
varchar(100)
NO


22
dMaterialsMoney
decimal(18,6)
NO


23
dMaterialsPrice
decimal(18,6)
NO


24
bSlaveBillComplete
bit(1)
YES


25
bBillComplete
bit(1)
NO


26
tBillCompleteDate
datetime
YES


27
sLossMemo
text
YES


28
iChangeType
int
NO


29
bInvalid
bit(1)
NO


30
bCheck
bit(1)
NO


Definition
select `xlyweberp_saas_ai`.`sgd`.`sId` AS `sId`,`xlyweberp_saas_ai`.`sgd`.`sBillNo` AS `sBillNo`,`xlyweberp_saas_ai`.`sgd`.`tCreateDate` AS `tCreateDate`,`e`.`sCustomerName` AS `sCustomerName`,`ep`.`sProductName` AS `sProductName`,`xlyweberp_saas_ai`.`sgd`.`sMaterialsId` AS `sMaterialsId`,`xlyweberp_saas_ai`.`lld`.`lldsMaterialsId` AS `lldsMaterialsId`,`xlyweberp_saas_ai`.`sgd`.`sMaterialsStyle` AS `sMaterialsStyle`,`em1`.`sMaterialsName` AS `lldsMaterialsName`,`em`.`sMaterialsName` AS `sMaterialsName`,`em`.`iOrder` AS `iOrder`,`xlyweberp_saas_ai`.`sgd`.`dAuxiliaryQty` AS `dAuxiliaryQty`,`xlyweberp_saas_ai`.`lld`.`LldQty` AS `LldQty`,`xlyweberp_saas_ai`.`lld`.`LldsMaterialsStyle` AS `LldsMaterialsStyle`,`xlyweberp_saas_ai`.`sgd`.`dProductQty` AS `dProductQty`,(`xlyweberp_saas_ai`.`lld`.`LldQty` - `xlyweberp_saas_ai`.`sgd`.`dAuxiliaryQty`) AS `dDifQty`,`xlyweberp_saas_ai`.`sgd`.`sProductId` AS `sProductId`,`xlyweberp_saas_ai`.`sgd`.`sCustomerId` AS `sCustomerId`,`xlyweberp_saas_ai`.`sgd`.`sBrandsId` AS `sBrandsId`,`xlyweberp_saas_ai`.`sgd`.`sSubsidiaryId` AS `sSubsidiaryId`,`xlyweberp_saas_ai`.`sgd`.`sSlaveId` AS `sSlaveId`,`xlyweberp_saas_ai`.`sgd`.`dMaterialsMoney` AS `dMaterialsMoney`,`xlyweberp_saas_ai`.`sgd`.`dMaterialsPrice` AS `dMaterialsPrice`,`xlyweberp_saas_ai`.`sgd`.`bSlaveBillComplete` AS `bSlaveBillComplete`,`xlyweberp_saas_ai`.`sgd`.`bBillComplete` AS `bBillComplete`,`xlyweberp_saas_ai`.`sgd`.`tBillCompleteDate` AS `tBillCompleteDate`,`xlyweberp_saas_ai`.`sgd`.`sLossMemo` AS `sLossMemo`,`xlyweberp_saas_ai`.`sgd`.`iChangeType` AS `iChangeType`,`xlyweberp_saas_ai`.`sgd`.`bInvalid` AS `bInvalid`,`xlyweberp_saas_ai`.`sgd`.`bCheck` AS `bCheck` from (((((`xlyweberp_saas_ai`.`viw_mftworkordermaterials` `sgd` left join `xlyweberp_saas_ai`.`viw_zlldgroupby_sgdandsmaterialsid` `lld` on((`xlyweberp_saas_ai`.`sgd`.`sSlaveId` = `xlyweberp_saas_ai`.`lld`.`sWorkOrderMaterialsTbId`))) left join `xlyweberp_saas_ai`.`elecustomer` `e` on((`xlyweberp_saas_ai`.`sgd`.`sCustomerId` = `e`.`sId`))) left join `xlyweberp_saas_ai`.`eleproduct` `ep` on((`xlyweberp_saas_ai`.`sgd`.`sProductId` = `ep`.`sId`))) left join `xlyweberp_saas_ai`.`elematerials` `em` on((`xlyweberp_saas_ai`.`sgd`.`sMaterialsId` = `em`.`sId`))) left join `xlyweberp_saas_ai`.`elematerials` `em1` on((`xlyweberp_saas_ai`.`lld`.`lldsMaterialsId` = `em1`.`sId`)))


Narrative

No human-written narrative yet.