viw_cahrevenuechange.md 3.05 KB

Edit Raw Blame History



viw_cahrevenuechange (view)


Updatable: YES


Columns


#
Name
Type
Null


1
sId
varchar(100)
NO


2
sBrandsId
varchar(100)
NO


3
sSubsidiaryId
varchar(100)
NO


4
tCreateDate
datetime
NO


5
sMakePerson
varchar(255)
NO


6
iOrder
int
NO


7
sFormId
varchar(100)
NO


8
sBillNo
varchar(255)
NO


9
sManualNo
varchar(255)
YES


10
sMemo
text
YES


11
bCheck
bit(1)
NO


12
tCheckDate
datetime
YES


13
sCheckPerson
varchar(255)
YES


14
bPrint
bit(1)
NO


15
bCopyLimit
bit(1)
NO


16
sStatus
varchar(255)
YES


17
bInvalid
bit(1)
NO


18
sMReserve1
varchar(255)
YES


19
sMReserve2
varchar(255)
YES


20
sMReserve3
varchar(255)
YES


21
sMReserve4
varchar(255)
YES


22
sMReserve5
varchar(255)
YES


23
sMReserve6
varchar(255)
YES


24
dMReserve1
decimal(18,6)
YES


25
dMReserve2
decimal(18,6)
YES


26
dMReserve3
decimal(18,6)
YES


27
iMReserve1
int
YES


28
iMReserve2
int
YES


29
iMReserve3
int
YES


30
tMReserve1
datetime
YES


31
tMReserve2
datetime
YES


32
sWorkOrderId
varchar(100)
NO


33
sWorkOrderNo
varchar(255)
NO


34
sCostCenterId
varchar(100)
NO


35
sSlaveId
varchar(100)
NO


36
iSlaveorder
int
NO


37
sParentId
varchar(100)
NO


38
sAccountNo
varchar(255)
NO


39
dMoney
decimal(18,6)
NO


Definition
select `m`.`sId` AS `sId`,`m`.`sBrandsId` AS `sBrandsId`,`m`.`sSubsidiaryId` AS `sSubsidiaryId`,`m`.`tCreateDate` AS `tCreateDate`,`m`.`sMakePerson` AS `sMakePerson`,`m`.`iOrder` AS `iOrder`,`m`.`sFormId` AS `sFormId`,`m`.`sBillNo` AS `sBillNo`,`m`.`sManualNo` AS `sManualNo`,`m`.`sMemo` AS `sMemo`,`m`.`bCheck` AS `bCheck`,`m`.`tCheckDate` AS `tCheckDate`,`m`.`sCheckPerson` AS `sCheckPerson`,`m`.`bPrint` AS `bPrint`,`m`.`bCopyLimit` AS `bCopyLimit`,`m`.`sStatus` AS `sStatus`,`m`.`bInvalid` AS `bInvalid`,`m`.`sMReserve1` AS `sMReserve1`,`m`.`sMReserve2` AS `sMReserve2`,`m`.`sMReserve3` AS `sMReserve3`,`m`.`sMReserve4` AS `sMReserve4`,`m`.`sMReserve5` AS `sMReserve5`,`m`.`sMReserve6` AS `sMReserve6`,`m`.`dMReserve1` AS `dMReserve1`,`m`.`dMReserve2` AS `dMReserve2`,`m`.`dMReserve3` AS `dMReserve3`,`m`.`iMReserve1` AS `iMReserve1`,`m`.`iMReserve2` AS `iMReserve2`,`m`.`iMReserve3` AS `iMReserve3`,`m`.`tMReserve1` AS `tMReserve1`,`m`.`tMReserve2` AS `tMReserve2`,`m`.`sWorkOrderId` AS `sWorkOrderId`,`m`.`sWorkOrderNo` AS `sWorkOrderNo`,`m`.`sCostCenterId` AS `sCostCenterId`,`s`.`sId` AS `sSlaveId`,`s`.`iOrder` AS `iSlaveorder`,`s`.`sParentId` AS `sParentId`,`s`.`sAccountNo` AS `sAccountNo`,`s`.`dMoney` AS `dMoney` from (`cahrevenuechangemaster` `m` join `cahrevenuechangeslave` `s` on((`m`.`sId` = `s`.`sParentId`)))


Narrative

No human-written narrative yet.