viw_accexpenseentrybusiness.md 5.45 KB

Edit Raw Blame History



viw_accexpenseentrybusiness（视图）


是否可更新： YES

定义者： xlyprint@%


字段


#
名称
类型
可空


1
sId
varchar(100)
YES


2
sBrandsId
varchar(100)
YES


3
sSubsidiaryId
varchar(100)
YES


4
tCreateDate
datetime
NO


5
sMakePerson
varchar(255)
YES


6
sFormId
varchar(100)
YES


7
iOrder
int
NO


8
sBillNo
varchar(255)
YES


9
sMemo
text
YES


10
bCheck
bit(1)
NO


11
tCheckDate
datetime
YES


12
sCheckPerson
varchar(255)
YES


13
bPrint
bit(1)
NO


14
bCopyLimit
bit(1)
NO


15
sStatus
varchar(255)
YES


16
bInvalid
bit(1)
NO


17
sCostPeriod
varchar(255)
YES


18
iIncrement
int
NO


19
sSlaveId
varchar(100)
YES


20
sParentId
varchar(100)
YES


21
iSlaveOrder
int
NO


22
dOtherOperateMoney
decimal(18,6)
NO


23
dMainBusinessCostMoney
decimal(18,6)
NO


24
dAdministrativeExpenses
decimal(18,6)
NO


25
dAssetsImpairmentloss
decimal(18,6)
NO


26
dCreditImpairmentloss
decimal(18,6)
NO


27
dTaxMoney
decimal(18,6)
NO


28
dSellingExpenses
decimal(18,6)
NO


29
dFinancialExpenses
decimal(18,6)
NO


30
dRDExpenses
decimal(18,6)
NO


31
dOtherbusinessCostMoney
decimal(18,6)
NO


32
dGainsIncomeloss
decimal(18,6)
NO


33
dInvestmentIncomeloss
decimal(18,6)
NO


34
dOtherIncome
decimal(18,6)
NO


35
dDisposalIncomeloss
decimal(18,6)
NO


36
dNonbusinessIncome
decimal(18,6)
NO


37
dNonBusinessExpenditure
decimal(18,6)
NO


38
iPeople
int
NO


39
dElectricityFees
decimal(18,6)
NO


定义
select `xlyweberp_saas_ai`.`accexpenseentrybusinessmaster`.`sId` AS `sId`,`xlyweberp_saas_ai`.`accexpenseentrybusinessmaster`.`sBrandsId` AS `sBrandsId`,`xlyweberp_saas_ai`.`accexpenseentrybusinessmaster`.`sSubsidiaryId` AS `sSubsidiaryId`,`xlyweberp_saas_ai`.`accexpenseentrybusinessmaster`.`tCreateDate` AS `tCreateDate`,`xlyweberp_saas_ai`.`accexpenseentrybusinessmaster`.`sMakePerson` AS `sMakePerson`,`xlyweberp_saas_ai`.`accexpenseentrybusinessmaster`.`sFormId` AS `sFormId`,`xlyweberp_saas_ai`.`accexpenseentrybusinessmaster`.`iOrder` AS `iOrder`,`xlyweberp_saas_ai`.`accexpenseentrybusinessmaster`.`sBillNo` AS `sBillNo`,`xlyweberp_saas_ai`.`accexpenseentrybusinessmaster`.`sMemo` AS `sMemo`,`xlyweberp_saas_ai`.`accexpenseentrybusinessmaster`.`bCheck` AS `bCheck`,`xlyweberp_saas_ai`.`accexpenseentrybusinessmaster`.`tCheckDate` AS `tCheckDate`,`xlyweberp_saas_ai`.`accexpenseentrybusinessmaster`.`sCheckPerson` AS `sCheckPerson`,`xlyweberp_saas_ai`.`accexpenseentrybusinessmaster`.`bPrint` AS `bPrint`,`xlyweberp_saas_ai`.`accexpenseentrybusinessmaster`.`bCopyLimit` AS `bCopyLimit`,`xlyweberp_saas_ai`.`accexpenseentrybusinessmaster`.`sStatus` AS `sStatus`,`xlyweberp_saas_ai`.`accexpenseentrybusinessmaster`.`bInvalid` AS `bInvalid`,`xlyweberp_saas_ai`.`accexpenseentrybusinessmaster`.`sCostPeriod` AS `sCostPeriod`,`xlyweberp_saas_ai`.`accexpenseentrybusinessmaster`.`iIncrement` AS `iIncrement`,`xlyweberp_saas_ai`.`accexpenseentrybusinessslave`.`sId` AS `sSlaveId`,`xlyweberp_saas_ai`.`accexpenseentrybusinessslave`.`sParentId` AS `sParentId`,`xlyweberp_saas_ai`.`accexpenseentrybusinessslave`.`iOrder` AS `iSlaveOrder`,`xlyweberp_saas_ai`.`accexpenseentrybusinessslave`.`dOtherOperateMoney` AS `dOtherOperateMoney`,`xlyweberp_saas_ai`.`accexpenseentrybusinessslave`.`dMainBusinessCostMoney` AS `dMainBusinessCostMoney`,`xlyweberp_saas_ai`.`accexpenseentrybusinessslave`.`dAdministrativeExpenses` AS `dAdministrativeExpenses`,`xlyweberp_saas_ai`.`accexpenseentrybusinessslave`.`dAssetsImpairmentloss` AS `dAssetsImpairmentloss`,`xlyweberp_saas_ai`.`accexpenseentrybusinessslave`.`dCreditImpairmentloss` AS `dCreditImpairmentloss`,`xlyweberp_saas_ai`.`accexpenseentrybusinessslave`.`dTaxMoney` AS `dTaxMoney`,`xlyweberp_saas_ai`.`accexpenseentrybusinessslave`.`dSellingExpenses` AS `dSellingExpenses`,`xlyweberp_saas_ai`.`accexpenseentrybusinessslave`.`dFinancialExpenses` AS `dFinancialExpenses`,`xlyweberp_saas_ai`.`accexpenseentrybusinessslave`.`dRDExpenses` AS `dRDExpenses`,`xlyweberp_saas_ai`.`accexpenseentrybusinessslave`.`dOtherbusinessCostMoney` AS `dOtherbusinessCostMoney`,`xlyweberp_saas_ai`.`accexpenseentrybusinessslave`.`dGainsIncomeloss` AS `dGainsIncomeloss`,`xlyweberp_saas_ai`.`accexpenseentrybusinessslave`.`dInvestmentIncomeloss` AS `dInvestmentIncomeloss`,`xlyweberp_saas_ai`.`accexpenseentrybusinessslave`.`dOtherIncome` AS `dOtherIncome`,`xlyweberp_saas_ai`.`accexpenseentrybusinessslave`.`dDisposalIncomeloss` AS `dDisposalIncomeloss`,`xlyweberp_saas_ai`.`accexpenseentrybusinessslave`.`dNonbusinessIncome` AS `dNonbusinessIncome`,`xlyweberp_saas_ai`.`accexpenseentrybusinessslave`.`dNonBusinessExpenditure` AS `dNonBusinessExpenditure`,`xlyweberp_saas_ai`.`accexpenseentrybusinessslave`.`iPeople` AS `iPeople`,`xlyweberp_saas_ai`.`accexpenseentrybusinessslave`.`dElectricityFees` AS `dElectricityFees` from (`xlyweberp_saas_ai`.`accexpenseentrybusinessslave` join `xlyweberp_saas_ai`.`accexpenseentrybusinessmaster` on((`xlyweberp_saas_ai`.`accexpenseentrybusinessmaster`.`sId` = `xlyweberp_saas_ai`.`accexpenseentrybusinessslave`.`sParentId`)))


说明

暂无人工说明。