viw_salsalesprintplan.md 11.9 KB

Edit Raw Blame History



viw_salsalesprintplan（视图）


是否可更新： YES

定义者： xlyprint@%


字段


#
名称
类型
可空


1
sId
varchar(100)
NO


2
sBrandsId
varchar(100)
NO


3
sSubsidiaryId
varchar(100)
NO


4
iOrder
int
NO


5
sCustomerId
varchar(100)
NO


6
sContacts
varchar(255)
YES


7
sPhone
varchar(255)
YES


8
tDeliverDate
datetime
YES


9
sSalesManId
varchar(255)
YES


10
sProductTechnologyVer
varchar(255)
YES


11
sGetPayId
varchar(255)
YES


12
tGetPayDate
datetime
YES


13
sConsignee
varchar(255)
YES


14
sConsigneeMobile
varchar(255)
YES


15
sDeliverId
varchar(100)
YES


16
sProvince
varchar(255)
YES


17
sCity
varchar(255)
YES


18
sArea
varchar(255)
YES


19
sDeliverTo
varchar(255)
YES


20
sManualNo
varchar(255)
YES


21
sCustomerOrderNo
varchar(255)
YES


22
sCurrency
varchar(255)
YES


23
dCurrencyRate
decimal(18,6)
YES


24
sProductId
varchar(100)
NO


25
dProductQty
decimal(18,6)
NO


26
dProductPrice
decimal(18,6)
NO


27
dProductMoney
decimal(18,6)
NO


28
sProductInfo
text
YES


29
sMaterialsMemo
text
YES


30
sProcessMemo
text
YES


31
sSrcSlaveId
varchar(100)
NO


32
sSrcId
varchar(100)
NO


33
sSrcNo
varchar(255)
NO


34
dSrcQty
decimal(18,6)
YES


35
dProductPQty
decimal(18,6)
YES


36
iProductStick
int
YES


37
bProductInStoreComplete
bit(1)
NO


38
bDeliverComplete
bit(1)
NO


39
bDeliverNotifyComplete
bit(1)
NO


40
bOutsideProcessComplete
bit(1)
NO


41
bCheckingComplete
bit(1)
NO


42
sQualityRequireMemo
text
YES


43
sPackRequireMemo
text
YES


44
sSlaveMemo
text
YES


45
sTaxId
varchar(100)
YES


46
dProductNoTaxPrice
decimal(18,6)
YES


47
dProductNoTaxMoney
decimal(18,6)
YES


48
dProductTaxMoney
decimal(18,6)
YES


49
dProductTaxForeignMoney
decimal(18,6)
YES


50
dProductForeignMoney
decimal(18,6)
YES


51
dProductInStoreQty
decimal(18,6)
NO


52
dDeliverNotifyQty
decimal(18,6)
NO


53
dDeliverQty
decimal(18,6)
NO


54
dCheckingQty
decimal(18,6)
NO


55
dReceiptMoney
decimal(18,6)
NO


56
dOutsideProcessQty
decimal(18,6)
NO


57
sWebOrderNo
varchar(255)
NO


58
sWebOrderId
varchar(100)
NO


59
sBarcode
varchar(255)
YES


60
dGiveQty
decimal(18,6)
NO


61
dPresentQty
decimal(18,6)
NO


62
sProductTechnologyId
varchar(100)
YES


63
sOrderId
varchar(100)
NO


64
sOrderSlaveId
varchar(100)
NO


65
sOrderNo
varchar(255)
NO


66
sMReserve1
varchar(255)
YES


67
sMReserve2
varchar(255)
YES


68
sMReserve3
varchar(255)
YES


69
sMReserve4
varchar(255)
YES


70
sMReserve5
varchar(255)
YES


71
sMReserve6
varchar(255)
YES


72
dMReserve1
decimal(18,6)
YES


73
dMReserve2
decimal(18,6)
YES


74
dMReserve3
decimal(18,6)
YES


75
iMReserve1
int
YES


76
iMReserve2
int
YES


77
iMReserve3
int
YES


78
tMReserve1
datetime
YES


79
tMReserve2
datetime
YES


80
sMakePerson
varchar(255)
NO


81
bQlyComplete
bit(1)
NO


82
dSampleQty
decimal(18,6)
NO


83
dQlyQty
decimal(18,6)
NO


84
tCompleteDate
datetime
YES


85
sColorMemo
text
YES


86
sParam1
varchar(255)
NO


87
sParam2
varchar(255)
NO


88
sParam3
varchar(255)
NO


89
sParam4
varchar(255)
NO


90
sParam5
varchar(255)
NO


91
sPartsStyle
varchar(255)
NO


92
dLeftSide
decimal(18,6)
YES


93
dSkip
decimal(18,6)
YES


94
sPaperDirection
varchar(100)
YES


95
dPaper
decimal(18,6)
YES


96
dMeters
decimal(18,6)
YES


97
bCutting
bit(1)
NO


98
dOutSideDiameter
decimal(18,6)
YES


99
dDiameter
decimal(18,6)
YES


100
dCombineQty
decimal(18,6)
NO


101
bReceiptComplete
bit(1)
NO


102
bAdvanceComplete
bit(1)
NO


103
sFormId
varchar(100)
NO


104
bCheck
bit(1)
NO


105
sBillNo
varchar(255)
NO


106
bInvalid
bit(1)
NO


107
tCreateDate
datetime
NO


108
tCheckDate
datetime
YES


109
sCheckPerson
varchar(255)
YES


110
bPrint
bit(1)
NO


111
bCopyLimit
bit(1)
NO


112
dCostMoney
decimal(18,6)
YES


113
dCostPrice
decimal(18,6)
YES


114
sUnTaskFormId
varchar(100)
NO


115
tSrcDate
datetime
YES


116
sNoFormat
varchar(255)
NO


117
sMemo
varchar(255)
YES


118
bDevComplete
bit(1)
NO


119
sSlaveId
varchar(100)
NO


120
sSlaveMakePerson
varchar(255)
NO


121
iSlaveOrder
int
NO


122
sParentId
varchar(100)
NO


123
sFollowUpPhase
varchar(255)
NO


124
sEmployeeId
varchar(100)
NO


125
sSlaveSlaveMemo
text
NO


126
sSReserve1
varchar(255)
YES


127
sSReserve2
varchar(255)
YES


128
sSReserve3
varchar(255)
YES


129
sSReserve4
varchar(255)
YES


130
sSReserve5
varchar(255)
YES


131
sSReserve6
varchar(255)
YES


132
dSReserve1
decimal(18,6)
YES


133
dSReserve2
decimal(18,6)
YES


134
dSReserve3
decimal(18,6)
YES


135
iSReserve1
int
YES


136
iSReserve2
int
YES


137
iSReserve3
int
YES


138
tSReserve1
datetime
YES


139
tSReserve2
datetime
YES


140
tStartDate
datetime
YES


141
tEndDate
datetime
YES


142
sFileId
varchar(100)
NO


143
sFileMakePerson
varchar(255)
NO


144
iFileOrder
int
NO


145
sFileParentId
varchar(100)
NO


146
sPicturePath
varchar(255)
YES


147
bDefault
bit(1)
NO


148
sFileName
varchar(255)
NO


定义
select `m`.`sId` AS `sId`,`m`.`sBrandsId` AS `sBrandsId`,`m`.`sSubsidiaryId` AS `sSubsidiaryId`,`m`.`iOrder` AS `iOrder`,`m`.`sCustomerId` AS `sCustomerId`,`m`.`sContacts` AS `sContacts`,`m`.`sPhone` AS `sPhone`,`m`.`tDeliverDate` AS `tDeliverDate`,`m`.`sSalesManId` AS `sSalesManId`,`m`.`sProductTechnologyVer` AS `sProductTechnologyVer`,`m`.`sGetPayId` AS `sGetPayId`,`m`.`tGetPayDate` AS `tGetPayDate`,`m`.`sConsignee` AS `sConsignee`,`m`.`sConsigneeMobile` AS `sConsigneeMobile`,`m`.`sDeliverId` AS `sDeliverId`,`m`.`sProvince` AS `sProvince`,`m`.`sCity` AS `sCity`,`m`.`sArea` AS `sArea`,`m`.`sDeliverTo` AS `sDeliverTo`,`m`.`sManualNo` AS `sManualNo`,`m`.`sCustomerOrderNo` AS `sCustomerOrderNo`,`m`.`sCurrency` AS `sCurrency`,`m`.`dCurrencyRate` AS `dCurrencyRate`,`m`.`sProductId` AS `sProductId`,`m`.`dProductQty` AS `dProductQty`,`m`.`dProductPrice` AS `dProductPrice`,`m`.`dProductMoney` AS `dProductMoney`,`m`.`sProductInfo` AS `sProductInfo`,`m`.`sMaterialsMemo` AS `sMaterialsMemo`,`m`.`sProcessMemo` AS `sProcessMemo`,`m`.`sSrcSlaveId` AS `sSrcSlaveId`,`m`.`sSrcId` AS `sSrcId`,`m`.`sSrcNo` AS `sSrcNo`,`m`.`dSrcQty` AS `dSrcQty`,`m`.`dProductPQty` AS `dProductPQty`,`m`.`iProductStick` AS `iProductStick`,`m`.`bProductInStoreComplete` AS `bProductInStoreComplete`,`m`.`bDeliverComplete` AS `bDeliverComplete`,`m`.`bDeliverNotifyComplete` AS `bDeliverNotifyComplete`,`m`.`bOutsideProcessComplete` AS `bOutsideProcessComplete`,`m`.`bCheckingComplete` AS `bCheckingComplete`,`m`.`sQualityRequireMemo` AS `sQualityRequireMemo`,`m`.`sPackRequireMemo` AS `sPackRequireMemo`,`m`.`sSlaveMemo` AS `sSlaveMemo`,`m`.`sTaxId` AS `sTaxId`,`m`.`dProductNoTaxPrice` AS `dProductNoTaxPrice`,`m`.`dProductNoTaxMoney` AS `dProductNoTaxMoney`,`m`.`dProductTaxMoney` AS `dProductTaxMoney`,`m`.`dProductTaxForeignMoney` AS `dProductTaxForeignMoney`,`m`.`dProductForeignMoney` AS `dProductForeignMoney`,`m`.`dProductInStoreQty` AS `dProductInStoreQty`,`m`.`dDeliverNotifyQty` AS `dDeliverNotifyQty`,`m`.`dDeliverQty` AS `dDeliverQty`,`m`.`dCheckingQty` AS `dCheckingQty`,`m`.`dReceiptMoney` AS `dReceiptMoney`,`m`.`dOutsideProcessQty` AS `dOutsideProcessQty`,`m`.`sWebOrderNo` AS `sWebOrderNo`,`m`.`sWebOrderId` AS `sWebOrderId`,`m`.`sBarcode` AS `sBarcode`,`m`.`dGiveQty` AS `dGiveQty`,`m`.`dPresentQty` AS `dPresentQty`,`m`.`sProductTechnologyId` AS `sProductTechnologyId`,`m`.`sOrderId` AS `sOrderId`,`m`.`sOrderSlaveId` AS `sOrderSlaveId`,`m`.`sOrderNo` AS `sOrderNo`,`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`.`sMakePerson` AS `sMakePerson`,`m`.`bQlyComplete` AS `bQlyComplete`,`m`.`dSampleQty` AS `dSampleQty`,`m`.`dQlyQty` AS `dQlyQty`,`m`.`tCompleteDate` AS `tCompleteDate`,`m`.`sColorMemo` AS `sColorMemo`,`m`.`sParam1` AS `sParam1`,`m`.`sParam2` AS `sParam2`,`m`.`sParam3` AS `sParam3`,`m`.`sParam4` AS `sParam4`,`m`.`sParam5` AS `sParam5`,`m`.`sPartsStyle` AS `sPartsStyle`,`m`.`dLeftSide` AS `dLeftSide`,`m`.`dSkip` AS `dSkip`,`m`.`sPaperDirection` AS `sPaperDirection`,`m`.`dPaper` AS `dPaper`,`m`.`dMeters` AS `dMeters`,`m`.`bCutting` AS `bCutting`,`m`.`dOutSideDiameter` AS `dOutSideDiameter`,`m`.`dDiameter` AS `dDiameter`,`m`.`dCombineQty` AS `dCombineQty`,`m`.`bReceiptComplete` AS `bReceiptComplete`,`m`.`bAdvanceComplete` AS `bAdvanceComplete`,`m`.`sFormId` AS `sFormId`,`m`.`bCheck` AS `bCheck`,`m`.`sBillNo` AS `sBillNo`,`m`.`bInvalid` AS `bInvalid`,`m`.`tCreateDate` AS `tCreateDate`,`m`.`tCheckDate` AS `tCheckDate`,`m`.`sCheckPerson` AS `sCheckPerson`,`m`.`bPrint` AS `bPrint`,`m`.`bCopyLimit` AS `bCopyLimit`,`m`.`dCostMoney` AS `dCostMoney`,`m`.`dCostPrice` AS `dCostPrice`,`m`.`sUnTaskFormId` AS `sUnTaskFormId`,`m`.`tSrcDate` AS `tSrcDate`,`m`.`sNoFormat` AS `sNoFormat`,`m`.`sMemo` AS `sMemo`,`m`.`bDevComplete` AS `bDevComplete`,`s`.`sId` AS `sSlaveId`,`s`.`sMakePerson` AS `sSlaveMakePerson`,`s`.`iOrder` AS `iSlaveOrder`,`s`.`sParentId` AS `sParentId`,`s`.`sFollowUpPhase` AS `sFollowUpPhase`,`s`.`sEmployeeId` AS `sEmployeeId`,`s`.`sMemo` AS `sSlaveSlaveMemo`,`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`.`tStartDate` AS `tStartDate`,`s`.`tEndDate` AS `tEndDate`,`f`.`sId` AS `sFileId`,`f`.`sMakePerson` AS `sFileMakePerson`,`f`.`iOrder` AS `iFileOrder`,`f`.`sParentId` AS `sFileParentId`,`f`.`sPicturePath` AS `sPicturePath`,`f`.`bDefault` AS `bDefault`,`f`.`sFileName` AS `sFileName` from ((`xlyweberp_saas_ai`.`salsalesprintplanmaster` `m` join `xlyweberp_saas_ai`.`salsalesprintplanslave` `s` on((`m`.`sId` = `s`.`sParentId`))) join `xlyweberp_saas_ai`.`salsalesprintplanfile` `f` on((`m`.`sId` = `f`.`sParentId`)))


说明

暂无人工说明。