viw_mitmaterialsstoreadjustmoney.md 6.83 KB

Edit Raw Blame History



viw_mitmaterialsstoreadjustmoney（视图）


是否可更新： YES

定义者： xlyprint@%


字段


#
名称
类型
可空


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
sMemo
text
YES


10
bCheck
bit(1)
NO


11
tCheckDate
datetime
YES


12
sCheckPerson
varchar(255)
YES


13
bPrint
bit(1)
NO


14
bCopyLimit
bit(1)
NO


15
sStatus
varchar(255)
YES


16
bInvalid
bit(1)
NO


17
sWareHouseId
varchar(100)
NO


18
sLocationId
varchar(100)
NO


19
sWarehouseLocationId
varchar(100)
NO


20
sMReserve1
varchar(255)
YES


21
sMReserve2
varchar(255)
YES


22
sMReserve3
varchar(255)
YES


23
sMReserve4
varchar(255)
YES


24
sMReserve5
varchar(255)
YES


25
sMReserve6
varchar(255)
YES


26
dMReserve1
decimal(18,6)
YES


27
dMReserve2
decimal(18,6)
YES


28
dMReserve3
decimal(18,6)
YES


29
iMReserve1
int
YES


30
iMReserve2
int
YES


31
iMReserve3
int
YES


32
tMReserve1
datetime
YES


33
tMReserve2
datetime
YES


34
sSlaveId
varchar(100)
NO


35
iSlaveOrder
int
NO


36
sParentId
varchar(100)
NO


37
sMaterialsId
varchar(100)
NO


38
sMaterialsStyle
varchar(255)
NO


39
dAuxiliaryQty
decimal(18,6)
NO


40
sAuxiliaryUnit
varchar(255)
NO


41
dMaterialsQty
decimal(18,6)
NO


42
dConversionQty
decimal(18,6)
NO


43
dMaterialsPrice
decimal(18,6)
NO


44
dMaterialsMoney
decimal(18,6)
NO


45
sSrcSlaveId
varchar(100)
NO


46
sSrcId
varchar(100)
NO


47
sSrcNo
varchar(255)
NO


48
dSrcQty
decimal(18,6)
YES


49
sSlaveMemo
text
YES


50
sTaxId
varchar(100)
YES


51
dMaterialsNoTaxPrice
decimal(18,6)
YES


52
dMaterialsNoTaxMoney
decimal(18,6)
YES


53
dMaterialsTaxMoney
decimal(18,6)
YES


54
dMaterialsTaxForeignMoney
decimal(18,6)
YES


55
dMaterialsForeignMoney
decimal(18,6)
YES


56
sBarcode
varchar(255)
YES


57
sOrderId
varchar(100)
NO


58
sOrderNo
varchar(255)
NO


59
sWorkOrderId
varchar(100)
NO


60
sWorkOrderNo
varchar(255)
NO


61
sWorkOrderControlId
varchar(100)
NO


62
dReelAuxiliaryQty
decimal(18,6)
YES


63
sSReserve1
varchar(255)
YES


64
sSReserve2
varchar(255)
YES


65
sSReserve3
varchar(255)
YES


66
sSReserve4
varchar(255)
YES


67
sSReserve5
varchar(255)
YES


68
sSReserve6
varchar(255)
YES


69
dSReserve1
decimal(18,6)
YES


70
dSReserve2
decimal(18,6)
YES


71
dSReserve3
decimal(18,6)
YES


72
iSReserve1
int
YES


73
iSReserve2
int
YES


74
iSReserve3
int
YES


75
tSReserve1
datetime
YES


76
tSReserve2
datetime
YES


77
sDefineNo
varchar(255)
NO


78
sDefineNo2
varchar(255)
NO


79
sSalveWareHouseId
varchar(100)
NO


80
sSlaveLocationId
varchar(100)
NO


81
sVoucherBillNo
varchar(255)
NO


82
sVoucherBillId
varchar(255)
NO


83
sSlaveWarehouseLocationId
varchar(100)
NO


定义
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`.`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`.`sWareHouseId` AS `sWareHouseId`,`m`.`sLocationId` AS `sLocationId`,`m`.`sWarehouseLocationId` AS `sWarehouseLocationId`,`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`,`s`.`sId` AS `sSlaveId`,`s`.`iOrder` AS `iSlaveOrder`,`s`.`sParentId` AS `sParentId`,`s`.`sMaterialsId` AS `sMaterialsId`,`s`.`sMaterialsStyle` AS `sMaterialsStyle`,`s`.`dAuxiliaryQty` AS `dAuxiliaryQty`,`s`.`sAuxiliaryUnit` AS `sAuxiliaryUnit`,`s`.`dMaterialsQty` AS `dMaterialsQty`,`s`.`dConversionQty` AS `dConversionQty`,`s`.`dMaterialsPrice` AS `dMaterialsPrice`,`s`.`dMaterialsMoney` AS `dMaterialsMoney`,`s`.`sSrcSlaveId` AS `sSrcSlaveId`,`s`.`sSrcId` AS `sSrcId`,`s`.`sSrcNo` AS `sSrcNo`,`s`.`dSrcQty` AS `dSrcQty`,`s`.`sSlaveMemo` AS `sSlaveMemo`,`s`.`sTaxId` AS `sTaxId`,`s`.`dMaterialsNoTaxPrice` AS `dMaterialsNoTaxPrice`,`s`.`dMaterialsNoTaxMoney` AS `dMaterialsNoTaxMoney`,`s`.`dMaterialsTaxMoney` AS `dMaterialsTaxMoney`,`s`.`dMaterialsTaxForeignMoney` AS `dMaterialsTaxForeignMoney`,`s`.`dMaterialsForeignMoney` AS `dMaterialsForeignMoney`,`s`.`sBarcode` AS `sBarcode`,`s`.`sOrderId` AS `sOrderId`,`s`.`sOrderNo` AS `sOrderNo`,`s`.`sWorkOrderId` AS `sWorkOrderId`,`s`.`sWorkOrderNo` AS `sWorkOrderNo`,`s`.`sWorkOrderControlId` AS `sWorkOrderControlId`,`s`.`dReelAuxiliaryQty` AS `dReelAuxiliaryQty`,`s`.`sSReserve1` AS `sSReserve1`,`s`.`sSReserve2` AS `sSReserve2`,`s`.`sSReserve3` AS `sSReserve3`,`s`.`sSReserve4` AS `sSReserve4`,`s`.`sSReserve5` AS `sSReserve5`,`s`.`sSReserve6` AS `sSReserve6`,`s`.`dSReserve1` AS `dSReserve1`,`s`.`dSReserve2` AS `dSReserve2`,`s`.`dSReserve3` AS `dSReserve3`,`s`.`iSReserve1` AS `iSReserve1`,`s`.`iSReserve2` AS `iSReserve2`,`s`.`iSReserve3` AS `iSReserve3`,`s`.`tSReserve1` AS `tSReserve1`,`s`.`tSReserve2` AS `tSReserve2`,`s`.`sDefineNo` AS `sDefineNo`,`s`.`sDefineNo2` AS `sDefineNo2`,`s`.`sWareHouseId` AS `sSalveWareHouseId`,`s`.`sLocationId` AS `sSlaveLocationId`,`s`.`sVoucherBillNo` AS `sVoucherBillNo`,`s`.`sVoucherBillId` AS `sVoucherBillId`,`s`.`sWarehouseLocationId` AS `sSlaveWarehouseLocationId` from (`xlyweberp_saas_ai`.`mitmaterialsstoreadjustmoneymaster` `m` join `xlyweberp_saas_ai`.`mitmaterialsstoreadjustmoneyslave` `s` on((`s`.`sParentId` = `m`.`sId`)))


说明

暂无人工说明。