viw_ai_salsalesinvoice.md 2.82 KB

Edit Raw Blame History



viw_ai_salsalesinvoice（视图）


是否可更新： YES

定义者： xlyprint@%


字段


#
名称
类型
可空


1
sId
varchar(100)
NO


2
sSubsidiaryId
varchar(100)
NO


3
tCreateDate
datetime
NO


4
tUpdateDate
datetime
NO


5
sMakePerson
varchar(255)
NO


6
iOrder
int
NO


7
sSlaveId
varchar(100)
NO


8
sProductName
varchar(100)
NO


9
sCustomerName
varchar(255)
NO


10
sBillNo
varchar(255)
NO


11
dProductMoney
decimal(18,6)
NO


12
dProductPrice
decimal(18,6)
NO


13
dProductQty
decimal(18,6)
NO


14
sSrcNo
varchar(255)
NO


15
sSlaveMemo
text
YES


16
sOrderNo
varchar(255)
NO


17
sWorkOrderNo
varchar(255)
NO


18
dTotalMoney
decimal(18,6)
NO


19
sBrandsId
varchar(100)
NO


定义
select `xlyweberp_saas_ai`.`salsalesinvoicemaster`.`sId` AS `sId`,`xlyweberp_saas_ai`.`salsalesinvoicemaster`.`sSubsidiaryId` AS `sSubsidiaryId`,`xlyweberp_saas_ai`.`salsalesinvoicemaster`.`tCreateDate` AS `tCreateDate`,`xlyweberp_saas_ai`.`salsalesinvoicemaster`.`tCreateDate` AS `tUpdateDate`,`xlyweberp_saas_ai`.`salsalesinvoicemaster`.`sMakePerson` AS `sMakePerson`,`xlyweberp_saas_ai`.`salsalesinvoicemaster`.`iOrder` AS `iOrder`,`xlyweberp_saas_ai`.`salsalesinvoiceslave`.`sId` AS `sSlaveId`,`xlyweberp_saas_ai`.`eleproduct`.`sProductName` AS `sProductName`,`xlyweberp_saas_ai`.`elecustomer`.`sCustomerName` AS `sCustomerName`,`xlyweberp_saas_ai`.`salsalesinvoicemaster`.`sBillNo` AS `sBillNo`,`xlyweberp_saas_ai`.`salsalesinvoiceslave`.`dProductMoney` AS `dProductMoney`,`xlyweberp_saas_ai`.`salsalesinvoiceslave`.`dProductPrice` AS `dProductPrice`,`xlyweberp_saas_ai`.`salsalesinvoiceslave`.`dProductQty` AS `dProductQty`,`xlyweberp_saas_ai`.`salsalesinvoiceslave`.`sSrcNo` AS `sSrcNo`,`xlyweberp_saas_ai`.`salsalesinvoiceslave`.`sSlaveMemo` AS `sSlaveMemo`,`xlyweberp_saas_ai`.`salsalesinvoiceslave`.`sOrderNo` AS `sOrderNo`,`xlyweberp_saas_ai`.`salsalesinvoiceslave`.`sWorkOrderNo` AS `sWorkOrderNo`,`xlyweberp_saas_ai`.`salsalesinvoiceslave`.`dTotalMoney` AS `dTotalMoney`,`xlyweberp_saas_ai`.`salsalesinvoicemaster`.`sBrandsId` AS `sBrandsId` from (((`xlyweberp_saas_ai`.`salsalesinvoicemaster` join `xlyweberp_saas_ai`.`salsalesinvoiceslave` on((`xlyweberp_saas_ai`.`salsalesinvoiceslave`.`sParentId` = `xlyweberp_saas_ai`.`salsalesinvoicemaster`.`sId`))) join `xlyweberp_saas_ai`.`elecustomer` on((`xlyweberp_saas_ai`.`salsalesinvoicemaster`.`sCustomerId` = `xlyweberp_saas_ai`.`elecustomer`.`sId`))) join `xlyweberp_saas_ai`.`eleproduct` on((`xlyweberp_saas_ai`.`salsalesinvoiceslave`.`sProductId` = `xlyweberp_saas_ai`.`eleproduct`.`sId`)))


说明

暂无人工说明。