viw_salsample.md 6.38 KB

Edit Raw Blame History



viw_salsample (view)


VIEW


Updatable: YES

Definer: xlyprint@%


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
sCustomerId
varchar(100)
NO


10
sMemo
text
YES


11
bCheck
bit(1)
NO


12
tCheckDate
datetime
YES


13
sCheckPerson
varchar(255)
YES


14
bCopyLimit
bit(1)
NO


15
sCurrency
varchar(255)
YES


16
dCurrencyRate
decimal(18,6)
YES


17
sStatus
varchar(255)
YES


18
bInvalid
bit(1)
NO


19
sMReserve1
varchar(255)
YES


20
sMReserve2
varchar(255)
YES


21
sMReserve3
varchar(255)
YES


22
sMReserve4
varchar(255)
YES


23
sMReserve5
varchar(255)
YES


24
sMReserve6
varchar(255)
YES


25
dMReserve1
decimal(18,6)
YES


26
dMReserve2
decimal(18,6)
YES


27
dMReserve3
decimal(18,6)
YES


28
iMReserve1
int
YES


29
iMReserve2
int
YES


30
iMReserve3
int
YES


31
tMReserve1
datetime
YES


32
tMReserve2
datetime
YES


33
sSlaveId
varchar(100)
NO


34
iSlaveOrder
int
NO


35
sProductId
varchar(100)
NO


36
dProductQty
decimal(18,6)
NO


37
dProductPrice
decimal(18,6)
NO


38
dProductMoney
decimal(18,6)
NO


39
sSrcSlaveId
varchar(100)
NO


40
sSrcId
varchar(100)
NO


41
sSrcNo
varchar(255)
NO


42
dSrcQty
decimal(18,6)
YES


43
sTaxId
varchar(100)
YES


44
sSReserve1
varchar(255)
YES


45
sSReserve2
varchar(255)
YES


46
sSReserve3
varchar(255)
YES


47
sSReserve4
varchar(255)
YES


48
sSReserve5
varchar(255)
YES


49
sSReserve6
varchar(255)
YES


50
dSReserve1
decimal(18,6)
YES


51
dSReserve2
decimal(18,6)
YES


52
dSReserve3
decimal(18,6)
YES


53
iSReserve1
int
YES


54
iSReserve2
int
YES


55
iSReserve3
int
YES


56
tSReserve1
datetime
YES


57
tSReserve2
datetime
YES


Definition
select `xlyweberp_saas_ai`.`salsamplemaster`.`sId` AS `sId`,`xlyweberp_saas_ai`.`salsamplemaster`.`sBrandsId` AS `sBrandsId`,`xlyweberp_saas_ai`.`salsamplemaster`.`sSubsidiaryId` AS `sSubsidiaryId`,`xlyweberp_saas_ai`.`salsamplemaster`.`tCreateDate` AS `tCreateDate`,`xlyweberp_saas_ai`.`salsamplemaster`.`sMakePerson` AS `sMakePerson`,`xlyweberp_saas_ai`.`salsamplemaster`.`iOrder` AS `iOrder`,`xlyweberp_saas_ai`.`salsamplemaster`.`sFormId` AS `sFormId`,`xlyweberp_saas_ai`.`salsamplemaster`.`sBillNo` AS `sBillNo`,`xlyweberp_saas_ai`.`salsamplemaster`.`sCustomerId` AS `sCustomerId`,`xlyweberp_saas_ai`.`salsamplemaster`.`sMemo` AS `sMemo`,`xlyweberp_saas_ai`.`salsamplemaster`.`bCheck` AS `bCheck`,`xlyweberp_saas_ai`.`salsamplemaster`.`tCheckDate` AS `tCheckDate`,`xlyweberp_saas_ai`.`salsamplemaster`.`sCheckPerson` AS `sCheckPerson`,`xlyweberp_saas_ai`.`salsamplemaster`.`bCopyLimit` AS `bCopyLimit`,`xlyweberp_saas_ai`.`salsamplemaster`.`sCurrency` AS `sCurrency`,`xlyweberp_saas_ai`.`salsamplemaster`.`dCurrencyRate` AS `dCurrencyRate`,`xlyweberp_saas_ai`.`salsamplemaster`.`sStatus` AS `sStatus`,`xlyweberp_saas_ai`.`salsamplemaster`.`bInvalid` AS `bInvalid`,`xlyweberp_saas_ai`.`salsamplemaster`.`sMReserve1` AS `sMReserve1`,`xlyweberp_saas_ai`.`salsamplemaster`.`sMReserve2` AS `sMReserve2`,`xlyweberp_saas_ai`.`salsamplemaster`.`sMReserve3` AS `sMReserve3`,`xlyweberp_saas_ai`.`salsamplemaster`.`sMReserve4` AS `sMReserve4`,`xlyweberp_saas_ai`.`salsamplemaster`.`sMReserve5` AS `sMReserve5`,`xlyweberp_saas_ai`.`salsamplemaster`.`sMReserve6` AS `sMReserve6`,`xlyweberp_saas_ai`.`salsamplemaster`.`dMReserve1` AS `dMReserve1`,`xlyweberp_saas_ai`.`salsamplemaster`.`dMReserve2` AS `dMReserve2`,`xlyweberp_saas_ai`.`salsamplemaster`.`dMReserve3` AS `dMReserve3`,`xlyweberp_saas_ai`.`salsamplemaster`.`iMReserve1` AS `iMReserve1`,`xlyweberp_saas_ai`.`salsamplemaster`.`iMReserve2` AS `iMReserve2`,`xlyweberp_saas_ai`.`salsamplemaster`.`iMReserve3` AS `iMReserve3`,`xlyweberp_saas_ai`.`salsamplemaster`.`tMReserve1` AS `tMReserve1`,`xlyweberp_saas_ai`.`salsamplemaster`.`tMReserve2` AS `tMReserve2`,`xlyweberp_saas_ai`.`salsampleslave`.`sId` AS `sSlaveId`,`xlyweberp_saas_ai`.`salsampleslave`.`iOrder` AS `iSlaveOrder`,`xlyweberp_saas_ai`.`salsampleslave`.`sProductId` AS `sProductId`,`xlyweberp_saas_ai`.`salsampleslave`.`dProductQty` AS `dProductQty`,`xlyweberp_saas_ai`.`salsampleslave`.`dProductPrice` AS `dProductPrice`,`xlyweberp_saas_ai`.`salsampleslave`.`dProductMoney` AS `dProductMoney`,`xlyweberp_saas_ai`.`salsampleslave`.`sSrcSlaveId` AS `sSrcSlaveId`,`xlyweberp_saas_ai`.`salsampleslave`.`sSrcId` AS `sSrcId`,`xlyweberp_saas_ai`.`salsampleslave`.`sSrcNo` AS `sSrcNo`,`xlyweberp_saas_ai`.`salsampleslave`.`dSrcQty` AS `dSrcQty`,`xlyweberp_saas_ai`.`salsampleslave`.`sTaxId` AS `sTaxId`,`xlyweberp_saas_ai`.`salsampleslave`.`sSReserve1` AS `sSReserve1`,`xlyweberp_saas_ai`.`salsampleslave`.`sSReserve2` AS `sSReserve2`,`xlyweberp_saas_ai`.`salsampleslave`.`sSReserve3` AS `sSReserve3`,`xlyweberp_saas_ai`.`salsampleslave`.`sSReserve4` AS `sSReserve4`,`xlyweberp_saas_ai`.`salsampleslave`.`sSReserve5` AS `sSReserve5`,`xlyweberp_saas_ai`.`salsampleslave`.`sSReserve6` AS `sSReserve6`,`xlyweberp_saas_ai`.`salsampleslave`.`dSReserve1` AS `dSReserve1`,`xlyweberp_saas_ai`.`salsampleslave`.`dSReserve2` AS `dSReserve2`,`xlyweberp_saas_ai`.`salsampleslave`.`dSReserve3` AS `dSReserve3`,`xlyweberp_saas_ai`.`salsampleslave`.`iSReserve1` AS `iSReserve1`,`xlyweberp_saas_ai`.`salsampleslave`.`iSReserve2` AS `iSReserve2`,`xlyweberp_saas_ai`.`salsampleslave`.`iSReserve3` AS `iSReserve3`,`xlyweberp_saas_ai`.`salsampleslave`.`tSReserve1` AS `tSReserve1`,`xlyweberp_saas_ai`.`salsampleslave`.`tSReserve2` AS `tSReserve2` from (`xlyweberp_saas_ai`.`salsamplemaster` join `xlyweberp_saas_ai`.`salsampleslave` on((`xlyweberp_saas_ai`.`salsamplemaster`.`sId` = `xlyweberp_saas_ai`.`salsampleslave`.`sParentId`)))


Narrative

No human-written narrative yet.