viw_accexpenseentrybusiness.md 4.58 KB

Edit Raw Blame History Permalink



viw_accexpenseentrybusiness (view)


Updatable: YES


Columns


#
Name
Type
Null


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


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


Narrative

No human-written narrative yet.