viw_agvpalletno.md 4.35 KB

Edit Raw Blame History Permalink



viw_agvpalletno（视图）


是否可更新： NO

定义者： xlyprint@%


字段


#
名称
类型
可空


1
sId
varchar(100)
NO


2
iOrder
int
YES


3
tCreateDate
datetime
NO


4
sMakePerson
varchar(100)
NO


5
sPalletNo
varchar(255)
NO


6
sPalletLocate
varchar(255)
YES


7
sMReserve1
varchar(255)
YES


8
sMReserve2
varchar(255)
YES


9
sMReserve3
varchar(255)
YES


10
sMReserve4
varchar(255)
YES


11
sMReserve5
varchar(255)
YES


12
sMReserve6
varchar(255)
YES


13
dMReserve1
decimal(18,6)
YES


14
dMReserve2
decimal(18,6)
YES


15
dMReserve3
decimal(18,6)
YES


16
iMReserve1
int
YES


17
iMReserve2
int
YES


18
iMReserve3
int
YES


19
tMReserve1
datetime
YES


20
tMReserve2
datetime
YES


21
sBrandsId
varchar(100)
NO


22
sSubsidiaryId
varchar(100)
NO


23
sFormId
varchar(100)
YES


24
bPalletStatus
bit(1)
NO


25
tCheckDate
datetime
YES


26
sCheckPerson
varchar(255)
YES


27
bInvalid
bit(1)
NO


28
sSlaveId
varchar(100)
YES


29
sParentId
varchar(100)
YES


30
sMaterialsId
varchar(255)
YES


31
sOrderNo
varchar(255)
YES


32
sWorkOrderNo
varchar(1000)
YES


33
sProductId
varchar(1000)
YES


34
sPartName
varchar(1000)
YES


35
sProcessId
varchar(1000)
YES


36
sDefineNo1
varchar(1000)
YES


37
sDefineNo2
varchar(1000)
YES


38
sBarcode
varchar(255)
YES


定义
select `xlyweberp_saas_ai`.`agvpalletno`.`sId` AS `sId`,`xlyweberp_saas_ai`.`agvpalletno`.`iOrder` AS `iOrder`,`xlyweberp_saas_ai`.`agvpalletno`.`tCreateDate` AS `tCreateDate`,`xlyweberp_saas_ai`.`agvpalletno`.`sMakePerson` AS `sMakePerson`,`xlyweberp_saas_ai`.`agvpalletno`.`sPalletNo` AS `sPalletNo`,`xlyweberp_saas_ai`.`agvpalletno`.`sPalletLocate` AS `sPalletLocate`,`xlyweberp_saas_ai`.`agvpalletno`.`sMReserve1` AS `sMReserve1`,`xlyweberp_saas_ai`.`agvpalletno`.`sMReserve2` AS `sMReserve2`,`xlyweberp_saas_ai`.`agvpalletno`.`sMReserve3` AS `sMReserve3`,`xlyweberp_saas_ai`.`agvpalletno`.`sMReserve4` AS `sMReserve4`,`xlyweberp_saas_ai`.`agvpalletno`.`sMReserve5` AS `sMReserve5`,`xlyweberp_saas_ai`.`agvpalletno`.`sMReserve6` AS `sMReserve6`,`xlyweberp_saas_ai`.`agvpalletno`.`dMReserve1` AS `dMReserve1`,`xlyweberp_saas_ai`.`agvpalletno`.`dMReserve2` AS `dMReserve2`,`xlyweberp_saas_ai`.`agvpalletno`.`dMReserve3` AS `dMReserve3`,`xlyweberp_saas_ai`.`agvpalletno`.`iMReserve1` AS `iMReserve1`,`xlyweberp_saas_ai`.`agvpalletno`.`iMReserve2` AS `iMReserve2`,`xlyweberp_saas_ai`.`agvpalletno`.`iMReserve3` AS `iMReserve3`,`xlyweberp_saas_ai`.`agvpalletno`.`tMReserve1` AS `tMReserve1`,`xlyweberp_saas_ai`.`agvpalletno`.`tMReserve2` AS `tMReserve2`,`xlyweberp_saas_ai`.`agvpalletno`.`sBrandsId` AS `sBrandsId`,`xlyweberp_saas_ai`.`agvpalletno`.`sSubsidiaryId` AS `sSubsidiaryId`,`xlyweberp_saas_ai`.`agvpalletno`.`sFormId` AS `sFormId`,`xlyweberp_saas_ai`.`agvpalletno`.`bPalletStatus` AS `bPalletStatus`,`xlyweberp_saas_ai`.`agvpalletno`.`tCheckDate` AS `tCheckDate`,`xlyweberp_saas_ai`.`agvpalletno`.`sCheckPerson` AS `sCheckPerson`,`xlyweberp_saas_ai`.`agvpalletno`.`bInvalid` AS `bInvalid`,`xlyweberp_saas_ai`.`agvpalletnoitem`.`sId` AS `sSlaveId`,`xlyweberp_saas_ai`.`agvpalletnoitem`.`sParentId` AS `sParentId`,`xlyweberp_saas_ai`.`agvpalletnoitem`.`sMaterialsId` AS `sMaterialsId`,`xlyweberp_saas_ai`.`agvpalletnoitem`.`sOrderNo` AS `sOrderNo`,`xlyweberp_saas_ai`.`agvpalletnoitem`.`sWorkOrderNo` AS `sWorkOrderNo`,`xlyweberp_saas_ai`.`agvpalletnoitem`.`sProductId` AS `sProductId`,`xlyweberp_saas_ai`.`agvpalletnoitem`.`sPartName` AS `sPartName`,`xlyweberp_saas_ai`.`agvpalletnoitem`.`sProcessId` AS `sProcessId`,`xlyweberp_saas_ai`.`agvpalletnoitem`.`sDefineNo1` AS `sDefineNo1`,`xlyweberp_saas_ai`.`agvpalletnoitem`.`sDefineNo2` AS `sDefineNo2`,`xlyweberp_saas_ai`.`agvpalletnoitem`.`sBarcode` AS `sBarcode` from (`xlyweberp_saas_ai`.`agvpalletno` left join `xlyweberp_saas_ai`.`agvpalletnoitem` on((`xlyweberp_saas_ai`.`agvpalletno`.`sId` = `xlyweberp_saas_ai`.`agvpalletnoitem`.`sParentId`)))


说明

暂无人工说明。