viw_sgdsemigoodsmatchbillprocess.md
13.9 KB
viw_sgdsemigoodsmatchbillprocess（视图）
- 是否可更新： 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 | sSlaveSrcNo |
varchar(255) |
NO |
| 34 | dSlaveSrcQty |
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 | sSReserve1 |
varchar(255) |
YES |
| 67 | sSReserve2 |
varchar(255) |
YES |
| 68 | sSReserve3 |
varchar(255) |
YES |
| 69 | sSReserve4 |
varchar(255) |
YES |
| 70 | sSReserve5 |
varchar(255) |
YES |
| 71 | sSReserve6 |
varchar(255) |
YES |
| 72 | dSReserve1 |
decimal(18,6) |
YES |
| 73 | dSReserve2 |
decimal(18,6) |
YES |
| 74 | dSReserve3 |
decimal(18,6) |
YES |
| 75 | iSReserve1 |
int |
YES |
| 76 | iSReserve2 |
int |
YES |
| 77 | iSReserve3 |
int |
YES |
| 78 | tSReserve1 |
datetime |
YES |
| 79 | tSReserve2 |
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 | bCheck |
bit(1) |
NO |
| 104 | bInvalid |
bit(1) |
NO |
| 105 | sBillNo |
varchar(255) |
NO |
| 106 | sFormId |
varchar(100) |
NO |
| 107 | tCreateDate |
datetime |
NO |
| 108 | bBillOutside |
bit(1) |
NO |
| 109 | iIncrement |
int |
NO |
| 110 | sSlaveId |
varchar(100) |
NO |
| 111 | iSlaveOrder |
int |
NO |
| 112 | sParentId |
varchar(100) |
NO |
| 113 | sControlId |
varchar(100) |
NO |
| 114 | sType |
varchar(255) |
NO |
| 115 | sProcessId |
varchar(100) |
NO |
| 116 | sMaterialsId |
varchar(100) |
NO |
| 117 | sMaterialsTbId |
varchar(100) |
YES |
| 118 | sSlaveSrcId |
varchar(100) |
NO |
| 119 | sProcessRequire |
text |
YES |
| 120 | dManualQty |
decimal(18,6) |
YES |
| 121 | dManualWidth |
decimal(18,6) |
YES |
| 122 | dManualLength |
decimal(18,6) |
YES |
| 123 | dManualValue |
decimal(18,6) |
YES |
| 124 | sMachineId |
varchar(100) |
YES |
| 125 | dHour |
decimal(18,6) |
YES |
| 126 | sKnifeMouldId |
varchar(100) |
YES |
| 127 | sNewOld |
varchar(255) |
YES |
| 128 | bSlaveOutside |
bit(1) |
NO |
| 129 | dOutsideQty |
decimal(18,6) |
YES |
| 130 | dSlaveOutsideProcessQty |
decimal(18,6) |
YES |
| 131 | dProcessInQty |
decimal(18,6) |
YES |
| 132 | dLossQty |
decimal(18,6) |
YES |
| 133 | dAdjustLossQty |
decimal(18,6) |
YES |
| 134 | dRate |
decimal(18,6) |
YES |
| 135 | dProcessOutQty |
decimal(18,6) |
YES |
| 136 | dProcessQty |
decimal(18,6) |
NO |
| 137 | dProductionReportQty |
decimal(18,6) |
NO |
| 138 | bProductionReportComplete |
bit(1) |
NO |
| 139 | dPriorProductReportQty |
decimal(18,6) |
YES |
| 140 | bProductionComplete |
bit(1) |
NO |
| 141 | dProductionQty |
decimal(18,6) |
NO |
| 142 | dProcessMoney |
decimal(18,6) |
YES |
| 143 | dCostProcessMoney |
decimal(18,6) |
YES |
| 144 | dDifficultEasy |
decimal(18,6) |
YES |
| 145 | tStartDate |
datetime |
YES |
| 146 | tEndDate |
datetime |
YES |
| 147 | sNextId |
varchar(100) |
YES |
| 148 | bLastProcess |
bit(1) |
NO |
| 149 | sSlaveProcessMemo |
text |
YES |
| 150 | sPReserve1 |
varchar(255) |
YES |
| 151 | sPReserve2 |
varchar(255) |
YES |
| 152 | sPReserve3 |
varchar(255) |
YES |
| 153 | sPReserve4 |
varchar(255) |
YES |
| 154 | sPReserve5 |
varchar(255) |
YES |
| 155 | sPReserve6 |
varchar(255) |
YES |
| 156 | dPReserve1 |
decimal(18,6) |
YES |
| 157 | dPReserve2 |
decimal(18,6) |
YES |
| 158 | dPReserve3 |
decimal(18,6) |
YES |
| 159 | iPReserve1 |
int |
YES |
| 160 | iPReserve2 |
int |
YES |
| 161 | iPReserve3 |
int |
YES |
| 162 | tPReserve1 |
datetime |
YES |
| 163 | tPReserve2 |
datetime |
YES |
| 164 | sSlaveMakePerson |
varchar(255) |
NO |
| 165 | sSrcControlId |
varchar(100) |
NO |
| 166 | sSrcProcessTbId |
varchar(100) |
NO |
| 167 | bOutSideComplete |
bit(1) |
NO |
| 168 | bSlaveQlyComplete |
bit(1) |
NO |
| 169 | dSlaveSampleQty |
decimal(18,6) |
NO |
| 170 | dSlaveQlyQty |
decimal(18,6) |
NO |
| 171 | dAdjustRate |
decimal(18,6) |
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 `sSlaveSrcNo`,`m`.`dSrcQty` AS `dSlaveSrcQty`,`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`.`sSReserve1` AS `sSReserve1`,`m`.`sSReserve2` AS `sSReserve2`,`m`.`sSReserve3` AS `sSReserve3`,`m`.`sSReserve4` AS `sSReserve4`,`m`.`sSReserve5` AS `sSReserve5`,`m`.`sSReserve6` AS `sSReserve6`,`m`.`dSReserve1` AS `dSReserve1`,`m`.`dSReserve2` AS `dSReserve2`,`m`.`dSReserve3` AS `dSReserve3`,`m`.`iSReserve1` AS `iSReserve1`,`m`.`iSReserve2` AS `iSReserve2`,`m`.`iSReserve3` AS `iSReserve3`,`m`.`tSReserve1` AS `tSReserve1`,`m`.`tSReserve2` AS `tSReserve2`,`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`.`bCheck` AS `bCheck`,`m`.`bInvalid` AS `bInvalid`,`m`.`sBillNo` AS `sBillNo`,`m`.`sFormId` AS `sFormId`,`m`.`tCreateDate` AS `tCreateDate`,`m`.`bBillOutside` AS `bBillOutside`,`s`.`iIncrement` AS `iIncrement`,`s`.`sId` AS `sSlaveId`,`s`.`iOrder` AS `iSlaveOrder`,`s`.`sParentId` AS `sParentId`,`s`.`sControlId` AS `sControlId`,`s`.`sType` AS `sType`,`s`.`sProcessId` AS `sProcessId`,`s`.`sMaterialsId` AS `sMaterialsId`,`s`.`sMaterialsTbId` AS `sMaterialsTbId`,`s`.`sSrcId` AS `sSlaveSrcId`,`s`.`sProcessRequire` AS `sProcessRequire`,`s`.`dManualQty` AS `dManualQty`,`s`.`dManualWidth` AS `dManualWidth`,`s`.`dManualLength` AS `dManualLength`,`s`.`dManualValue` AS `dManualValue`,`s`.`sMachineId` AS `sMachineId`,`s`.`dHour` AS `dHour`,`s`.`sKnifeMouldId` AS `sKnifeMouldId`,`s`.`sNewOld` AS `sNewOld`,`s`.`bOutside` AS `bSlaveOutside`,`s`.`dOutsideQty` AS `dOutsideQty`,`s`.`dOutsideProcessQty` AS `dSlaveOutsideProcessQty`,`s`.`dProcessInQty` AS `dProcessInQty`,`s`.`dLossQty` AS `dLossQty`,`s`.`dAdjustLossQty` AS `dAdjustLossQty`,`s`.`dRate` AS `dRate`,`s`.`dProcessOutQty` AS `dProcessOutQty`,`s`.`dProcessQty` AS `dProcessQty`,`s`.`dProductionReportQty` AS `dProductionReportQty`,`s`.`bProductionReportComplete` AS `bProductionReportComplete`,`s`.`dPriorProductReportQty` AS `dPriorProductReportQty`,`s`.`bProductionComplete` AS `bProductionComplete`,`s`.`dProductionQty` AS `dProductionQty`,`s`.`dProcessMoney` AS `dProcessMoney`,`s`.`dCostProcessMoney` AS `dCostProcessMoney`,`s`.`dDifficultEasy` AS `dDifficultEasy`,`s`.`tStartDate` AS `tStartDate`,`s`.`tEndDate` AS `tEndDate`,`s`.`sNextId` AS `sNextId`,`s`.`bLastProcess` AS `bLastProcess`,`s`.`sProcessMemo` AS `sSlaveProcessMemo`,`s`.`sPReserve1` AS `sPReserve1`,`s`.`sPReserve2` AS `sPReserve2`,`s`.`sPReserve3` AS `sPReserve3`,`s`.`sPReserve4` AS `sPReserve4`,`s`.`sPReserve5` AS `sPReserve5`,`s`.`sPReserve6` AS `sPReserve6`,`s`.`dPReserve1` AS `dPReserve1`,`s`.`dPReserve2` AS `dPReserve2`,`s`.`dPReserve3` AS `dPReserve3`,`s`.`iPReserve1` AS `iPReserve1`,`s`.`iPReserve2` AS `iPReserve2`,`s`.`iPReserve3` AS `iPReserve3`,`s`.`tPReserve1` AS `tPReserve1`,`s`.`tPReserve2` AS `tPReserve2`,`s`.`sMakePerson` AS `sSlaveMakePerson`,`s`.`sSrcControlId` AS `sSrcControlId`,`s`.`sSrcProcessTbId` AS `sSrcProcessTbId`,`s`.`bOutSideComplete` AS `bOutSideComplete`,`s`.`bQlyComplete` AS `bSlaveQlyComplete`,`s`.`dSampleQty` AS `dSlaveSampleQty`,`s`.`dQlyQty` AS `dSlaveQlyQty`,`s`.`dAdjustRate` AS `dAdjustRate` from (`xlyweberp_saas_ai`.`sgdsemigoodsmatchbillmaster` `m` join `xlyweberp_saas_ai`.`sgdsemigoodsmatchbillprocess` `s` on((`s`.`sParentId` = `m`.`sId`)))
说明
暂无人工说明。