viw_purpurchaseinstoretvoucher.md 6.63 KB

Edit Raw Blame History



viw_purpurchaseinstoretvoucher（视图）


是否可更新： YES

定义者： xlyprint@%


字段


#
名称
类型
可空


1
iIncrement
int
NO


2
sId
varchar(100)
NO


3
sBrandsId
varchar(100)
NO


4
sSubsidiaryId
varchar(100)
NO


5
tCreateDate
datetime
NO


6
sMakePerson
varchar(255)
NO


7
iOrder
int
NO


8
sFormId
varchar(100)
NO


9
sBillNo
varchar(255)
NO


10
sSupplyId
varchar(100)
NO


11
sContacts
varchar(255)
YES


12
sPhone
varchar(255)
YES


13
tDeliverDate
datetime
YES


14
sPurchaseManId
varchar(100)
YES


15
sGetPayId
varchar(100)
YES


16
tGetPayDate
datetime
YES


17
sConsignee
varchar(255)
YES


18
sConsigneeMobile
varchar(255)
YES


19
sDeliverId
varchar(100)
YES


20
sProvince
varchar(255)
YES


21
sCity
varchar(255)
YES


22
sArea
varchar(255)
YES


23
sDeliverTo
varchar(255)
YES


24
sManualNo
varchar(255)
YES


25
sMemo
text
YES


26
bCheck
bit(1)
NO


27
tCheckDate
datetime
YES


28
sCheckPerson
varchar(255)
YES


29
bPrint
bit(1)
NO


30
bCopyLimit
bit(1)
NO


31
dAdvanceMoney
decimal(18,6)
YES


32
tAdvanceDate
datetime
YES


33
dRealAdvanceMoney
decimal(18,6)
NO


34
sCurrency
varchar(255)
YES


35
dCurrencyRate
decimal(18,6)
YES


36
sStatus
varchar(255)
YES


37
bInvalid
bit(1)
NO


38
sWareHouseId
varchar(100)
NO


39
sLocationId
varchar(100)
NO


40
sWareHouseLocationId
varchar(100)
NO


41
sMReserve1
varchar(255)
YES


42
sMReserve2
varchar(255)
YES


43
sMReserve3
varchar(255)
YES


44
sMReserve4
varchar(255)
YES


45
sMReserve5
varchar(255)
YES


46
sMReserve6
varchar(255)
YES


47
dMReserve1
decimal(18,6)
YES


48
dMReserve2
decimal(18,6)
YES


49
dMReserve3
decimal(18,6)
YES


50
iMReserve1
int
YES


51
iMReserve2
int
YES


52
iMReserve3
int
YES


53
tMReserve1
datetime
YES


54
tMReserve2
datetime
YES


55
iVouchermark
int
NO


定义
select `xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`iIncrement` AS `iIncrement`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`sId` AS `sId`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`sBrandsId` AS `sBrandsId`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`sSubsidiaryId` AS `sSubsidiaryId`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`tCreateDate` AS `tCreateDate`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`sMakePerson` AS `sMakePerson`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`iOrder` AS `iOrder`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`sFormId` AS `sFormId`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`sBillNo` AS `sBillNo`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`sSupplyId` AS `sSupplyId`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`sContacts` AS `sContacts`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`sPhone` AS `sPhone`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`tDeliverDate` AS `tDeliverDate`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`sPurchaseManId` AS `sPurchaseManId`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`sGetPayId` AS `sGetPayId`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`tGetPayDate` AS `tGetPayDate`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`sConsignee` AS `sConsignee`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`sConsigneeMobile` AS `sConsigneeMobile`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`sDeliverId` AS `sDeliverId`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`sProvince` AS `sProvince`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`sCity` AS `sCity`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`sArea` AS `sArea`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`sDeliverTo` AS `sDeliverTo`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`sManualNo` AS `sManualNo`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`sMemo` AS `sMemo`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`bCheck` AS `bCheck`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`tCheckDate` AS `tCheckDate`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`sCheckPerson` AS `sCheckPerson`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`bPrint` AS `bPrint`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`bCopyLimit` AS `bCopyLimit`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`dAdvanceMoney` AS `dAdvanceMoney`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`tAdvanceDate` AS `tAdvanceDate`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`dRealAdvanceMoney` AS `dRealAdvanceMoney`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`sCurrency` AS `sCurrency`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`dCurrencyRate` AS `dCurrencyRate`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`sStatus` AS `sStatus`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`bInvalid` AS `bInvalid`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`sWareHouseId` AS `sWareHouseId`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`sLocationId` AS `sLocationId`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`sWareHouseLocationId` AS `sWareHouseLocationId`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`sMReserve1` AS `sMReserve1`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`sMReserve2` AS `sMReserve2`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`sMReserve3` AS `sMReserve3`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`sMReserve4` AS `sMReserve4`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`sMReserve5` AS `sMReserve5`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`sMReserve6` AS `sMReserve6`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`dMReserve1` AS `dMReserve1`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`dMReserve2` AS `dMReserve2`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`dMReserve3` AS `dMReserve3`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`iMReserve1` AS `iMReserve1`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`iMReserve2` AS `iMReserve2`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`iMReserve3` AS `iMReserve3`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`tMReserve1` AS `tMReserve1`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`tMReserve2` AS `tMReserve2`,`xlyweberp_saas_ai`.`purpurchaseinstoremaster`.`iVouchermark` AS `iVouchermark` from `xlyweberp_saas_ai`.`purpurchaseinstoremaster`


说明

暂无人工说明。