viw_departmentalbudget.md 6.72 KB

Edit Raw Blame History



viw_departmentalbudget (view)


Updatable: YES


Columns


#
Name
Type
Null


1
sId
varchar(100)
NO


2
sBrandsId
varchar(100)
NO


3
sSubsidiaryId
varchar(100)
NO


4
iIncrement
int
NO


5
tCreateDate
datetime
NO


6
sMakePerson
varchar(255)
NO


7
sFormId
varchar(100)
NO


8
sCustomerId
varchar(100)
YES


9
iOrder
int
NO


10
sBillNo
varchar(255)
NO


11
bCheck
bit(1)
NO


12
tCheckDate
datetime
YES


13
sCheckPerson
varchar(255)
YES


14
sYear
varchar(100)
NO


15
sMemo
text
YES


16
bInvalid
bit(1)
NO


17
sMReserve1
varchar(255)
YES


18
sMReserve2
varchar(255)
YES


19
sMReserve3
varchar(255)
YES


20
sMReserve4
varchar(255)
YES


21
sMReserve5
varchar(255)
YES


22
sMReserve6
varchar(255)
YES


23
dMReserve1
decimal(18,6)
YES


24
dMReserve2
decimal(18,6)
YES


25
dMReserve3
decimal(18,6)
YES


26
iMReserve1
int
YES


27
iMReserve2
int
YES


28
iMReserve3
int
YES


29
tMReserve1
datetime
YES


30
tMReserve2
datetime
YES


31
sSlaveId
varchar(100)
NO


32
iSlaveOrder
int
NO


33
sExpenseCategoryId
varchar(100)
NO


34
sExpenseCategory
varchar(100)
NO


35
sExpenseDetail
varchar(100)
NO


36
sDetailMemo
text
YES


37
dSumBudget
decimal(18,6)
NO


38
dJanuaryBudget
decimal(18,6)
NO


39
dFebruaryBudget
decimal(18,6)
NO


40
dMarchBudget
decimal(18,6)
NO


41
dAprilBudget
decimal(18,6)
NO


42
dMayBudget
decimal(18,6)
NO


43
dJuneBudget
decimal(18,6)
NO


44
dJulyBudget
decimal(18,6)
NO


45
dAugustBudget
decimal(18,6)
NO


46
dSeptemberBudget
decimal(18,6)
NO


47
dOctoberBudget
decimal(18,6)
NO


48
dNovemberBudget
decimal(18,6)
NO


49
dDecemberBudget
decimal(18,6)
NO


50
ssMemo
text
YES


51
sSReserve1
varchar(255)
YES


52
sSReserve2
varchar(255)
YES


53
sSReserve3
varchar(255)
YES


54
sSReserve4
varchar(255)
YES


55
sSReserve5
varchar(255)
YES


56
sSReserve6
varchar(255)
YES


57
dSReserve1
decimal(18,6)
YES


58
dSReserve2
decimal(18,6)
YES


59
dSReserve3
decimal(18,6)
YES


60
iSReserve1
int
YES


61
iSReserve2
int
YES


62
iSReserve3
int
YES


63
tSReserve1
datetime
YES


64
tSReserve2
datetime
YES


65
sDepartName
varchar(100)
NO


66
sDepartId
varchar(100)
NO


Definition
select `departmentalbudgetmaster`.`sId` AS `sId`,`departmentalbudgetmaster`.`sBrandsId` AS `sBrandsId`,`departmentalbudgetmaster`.`sSubsidiaryId` AS `sSubsidiaryId`,`departmentalbudgetmaster`.`iIncrement` AS `iIncrement`,`departmentalbudgetmaster`.`tCreateDate` AS `tCreateDate`,`departmentalbudgetmaster`.`sMakePerson` AS `sMakePerson`,`departmentalbudgetmaster`.`sFormId` AS `sFormId`,`departmentalbudgetmaster`.`sCustomerId` AS `sCustomerId`,`departmentalbudgetmaster`.`iOrder` AS `iOrder`,`departmentalbudgetmaster`.`sBillNo` AS `sBillNo`,`departmentalbudgetmaster`.`bCheck` AS `bCheck`,`departmentalbudgetmaster`.`tCheckDate` AS `tCheckDate`,`departmentalbudgetmaster`.`sCheckPerson` AS `sCheckPerson`,`departmentalbudgetmaster`.`sYear` AS `sYear`,`departmentalbudgetmaster`.`sMemo` AS `sMemo`,`departmentalbudgetmaster`.`bInvalid` AS `bInvalid`,`departmentalbudgetmaster`.`sMReserve1` AS `sMReserve1`,`departmentalbudgetmaster`.`sMReserve2` AS `sMReserve2`,`departmentalbudgetmaster`.`sMReserve3` AS `sMReserve3`,`departmentalbudgetmaster`.`sMReserve4` AS `sMReserve4`,`departmentalbudgetmaster`.`sMReserve5` AS `sMReserve5`,`departmentalbudgetmaster`.`sMReserve6` AS `sMReserve6`,`departmentalbudgetmaster`.`dMReserve1` AS `dMReserve1`,`departmentalbudgetmaster`.`dMReserve2` AS `dMReserve2`,`departmentalbudgetmaster`.`dMReserve3` AS `dMReserve3`,`departmentalbudgetmaster`.`iMReserve1` AS `iMReserve1`,`departmentalbudgetmaster`.`iMReserve2` AS `iMReserve2`,`departmentalbudgetmaster`.`iMReserve3` AS `iMReserve3`,`departmentalbudgetmaster`.`tMReserve1` AS `tMReserve1`,`departmentalbudgetmaster`.`tMReserve2` AS `tMReserve2`,`departmentalbudgetslave`.`sId` AS `sSlaveId`,`departmentalbudgetslave`.`iOrder` AS `iSlaveOrder`,`departmentalbudgetslave`.`sExpenseCategoryId` AS `sExpenseCategoryId`,`departmentalbudgetslave`.`sExpenseCategory` AS `sExpenseCategory`,`departmentalbudgetslave`.`sExpenseDetail` AS `sExpenseDetail`,`departmentalbudgetslave`.`sDetailMemo` AS `sDetailMemo`,`departmentalbudgetslave`.`dSumBudget` AS `dSumBudget`,`departmentalbudgetslave`.`dJanuaryBudget` AS `dJanuaryBudget`,`departmentalbudgetslave`.`dFebruaryBudget` AS `dFebruaryBudget`,`departmentalbudgetslave`.`dMarchBudget` AS `dMarchBudget`,`departmentalbudgetslave`.`dAprilBudget` AS `dAprilBudget`,`departmentalbudgetslave`.`dMayBudget` AS `dMayBudget`,`departmentalbudgetslave`.`dJuneBudget` AS `dJuneBudget`,`departmentalbudgetslave`.`dJulyBudget` AS `dJulyBudget`,`departmentalbudgetslave`.`dAugustBudget` AS `dAugustBudget`,`departmentalbudgetslave`.`dSeptemberBudget` AS `dSeptemberBudget`,`departmentalbudgetslave`.`dOctoberBudget` AS `dOctoberBudget`,`departmentalbudgetslave`.`dNovemberBudget` AS `dNovemberBudget`,`departmentalbudgetslave`.`dDecemberBudget` AS `dDecemberBudget`,`departmentalbudgetslave`.`sMemo` AS `ssMemo`,`departmentalbudgetslave`.`sSReserve1` AS `sSReserve1`,`departmentalbudgetslave`.`sSReserve2` AS `sSReserve2`,`departmentalbudgetslave`.`sSReserve3` AS `sSReserve3`,`departmentalbudgetslave`.`sSReserve4` AS `sSReserve4`,`departmentalbudgetslave`.`sSReserve5` AS `sSReserve5`,`departmentalbudgetslave`.`sSReserve6` AS `sSReserve6`,`departmentalbudgetslave`.`dSReserve1` AS `dSReserve1`,`departmentalbudgetslave`.`dSReserve2` AS `dSReserve2`,`departmentalbudgetslave`.`dSReserve3` AS `dSReserve3`,`departmentalbudgetslave`.`iSReserve1` AS `iSReserve1`,`departmentalbudgetslave`.`iSReserve2` AS `iSReserve2`,`departmentalbudgetslave`.`iSReserve3` AS `iSReserve3`,`departmentalbudgetslave`.`tSReserve1` AS `tSReserve1`,`departmentalbudgetslave`.`tSReserve2` AS `tSReserve2`,`departmentalbudgetmaster`.`sDepartName` AS `sDepartName`,`departmentalbudgetmaster`.`sDepartId` AS `sDepartId` from (`departmentalbudgetmaster` join `departmentalbudgetslave` on((`departmentalbudgetmaster`.`sId` = `departmentalbudgetslave`.`sParentId`)))


Narrative

No human-written narrative yet.