viw_sgdsemigoodsmatch.md
17.5 KB
viw_sgdsemigoodsmatch (view)
- Updatable: YES
Columns
| # | Name | Type | Null |
|---|---|---|---|
| 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 | dSkip |
decimal(18,6) |
YES |
| 93 | sPaperDirection |
varchar(100) |
YES |
| 94 | dPaper |
decimal(18,6) |
YES |
| 95 | dMeters |
decimal(18,6) |
YES |
| 96 | bCutting |
bit(1) |
NO |
| 97 | dOutSideDiameter |
decimal(18,6) |
YES |
| 98 | dDiameter |
decimal(18,6) |
YES |
| 99 | dCombineQty |
decimal(18,6) |
NO |
| 100 | bReceiptComplete |
bit(1) |
NO |
| 101 | bAdvanceComplete |
bit(1) |
NO |
| 102 | bCheck |
bit(1) |
NO |
| 103 | bInvalid |
bit(1) |
NO |
| 104 | sBillNo |
varchar(255) |
NO |
| 105 | sSlaveId |
varchar(100) |
NO |
| 106 | iSlaveOrder |
int |
NO |
| 107 | sParentId |
varchar(100) |
NO |
| 108 | sSlaveCustomerId |
varchar(100) |
NO |
| 109 | sSlaveContacts |
varchar(255) |
YES |
| 110 | sSlavePhone |
varchar(255) |
YES |
| 111 | tSlaveDeliverDate |
datetime |
YES |
| 112 | sSlaveSalesManId |
varchar(255) |
YES |
| 113 | sSlaveProductTechnologyVer |
varchar(255) |
YES |
| 114 | sSlaveGetPayId |
varchar(255) |
YES |
| 115 | tSlaveGetPayDate |
datetime |
YES |
| 116 | sSlaveConsignee |
varchar(255) |
YES |
| 117 | sSlaveConsigneeMobile |
varchar(255) |
YES |
| 118 | sSlaveDeliverId |
varchar(100) |
YES |
| 119 | sSlaveProvince |
varchar(255) |
YES |
| 120 | sSlaveCity |
varchar(255) |
YES |
| 121 | sSlaveArea |
varchar(255) |
YES |
| 122 | sSlaveDeliverTo |
varchar(255) |
YES |
| 123 | sSlaveManualNo |
varchar(255) |
YES |
| 124 | sSlaveCustomerOrderNo |
varchar(255) |
YES |
| 125 | sSlaveCurrency |
varchar(255) |
YES |
| 126 | dSlaveCurrencyRate |
decimal(18,6) |
YES |
| 127 | sSlaveProductId |
varchar(100) |
NO |
| 128 | dSlaveProductQty |
decimal(18,6) |
NO |
| 129 | dSlaveProductPrice |
decimal(18,6) |
NO |
| 130 | dSlaveProductMoney |
decimal(18,6) |
NO |
| 131 | sSlaveProductInfo |
text |
YES |
| 132 | sSlaveMaterialsMemo |
text |
YES |
| 133 | sSlaveProcessMemo |
text |
YES |
| 134 | sSlaveSrcSlaveId |
varchar(100) |
NO |
| 135 | sSlaveSrcId |
varchar(100) |
NO |
| 136 | sSrcNo |
varchar(255) |
NO |
| 137 | dSrcQty |
decimal(18,6) |
YES |
| 138 | dProductPQtySlave |
decimal(18,6) |
YES |
| 139 | iSlaveProductStick |
int |
YES |
| 140 | bSlaveProductInStoreComplete |
bit(1) |
NO |
| 141 | bSlaveDeliverComplete |
bit(1) |
NO |
| 142 | bSlaveDeliverNotifyComplete |
bit(1) |
NO |
| 143 | bSlaveOutsideProcessComplete |
bit(1) |
NO |
| 144 | bSlaveCheckingComplete |
bit(1) |
NO |
| 145 | sSlaveQualityRequireMemo |
text |
YES |
| 146 | sSlavePackRequireMemo |
text |
YES |
| 147 | sSlaveSlaveMemo |
text |
YES |
| 148 | sSlaveTaxId |
varchar(100) |
YES |
| 149 | dSlaveProductNoTaxPrice |
decimal(18,6) |
YES |
| 150 | dSlaveProductNoTaxMoney |
decimal(18,6) |
YES |
| 151 | dSlaveProductTaxMoney |
decimal(18,6) |
YES |
| 152 | dSlaveProductTaxForeignMoney |
decimal(18,6) |
YES |
| 153 | dSlaveProductForeignMoney |
decimal(18,6) |
YES |
| 154 | dSlaveProductInStoreQty |
decimal(18,6) |
NO |
| 155 | dSlaveDeliverNotifyQty |
decimal(18,6) |
NO |
| 156 | dSlaveDeliverQty |
decimal(18,6) |
NO |
| 157 | dSlaveCheckingQty |
decimal(18,6) |
NO |
| 158 | dSlaveReceiptMoney |
decimal(18,6) |
NO |
| 159 | dSlaveOutsideProcessQty |
decimal(18,6) |
NO |
| 160 | sSlaveWebOrderNo |
varchar(255) |
NO |
| 161 | sSlaveWebOrderId |
varchar(100) |
NO |
| 162 | sSlaveBarcode |
varchar(255) |
YES |
| 163 | dSlaveGiveQty |
decimal(18,6) |
NO |
| 164 | dSlavePresentQty |
decimal(18,6) |
NO |
| 165 | sSlaveProductTechnologyId |
varchar(100) |
YES |
| 166 | sSlaveOrderId |
varchar(100) |
NO |
| 167 | sSlaveOrderNo |
varchar(255) |
NO |
| 168 | sSlaveOrderSlaveId |
varchar(100) |
NO |
| 169 | sSlaveSReserve1 |
varchar(255) |
YES |
| 170 | sSlaveSReserve2 |
varchar(255) |
YES |
| 171 | sSlaveSReserve3 |
varchar(255) |
YES |
| 172 | sSlaveSReserve4 |
varchar(255) |
YES |
| 173 | sSlaveSReserve5 |
varchar(255) |
YES |
| 174 | sSlaveSReserve6 |
varchar(255) |
YES |
| 175 | dSlaveSReserve1 |
decimal(18,6) |
YES |
| 176 | dSlaveSReserve2 |
decimal(18,6) |
YES |
| 177 | dSlaveSReserve3 |
decimal(18,6) |
YES |
| 178 | iSlaveSReserve1 |
int |
YES |
| 179 | iSlaveSReserve2 |
int |
YES |
| 180 | iSlaveSReserve3 |
int |
YES |
| 181 | tSlaveSReserve1 |
datetime |
YES |
| 182 | tSlaveSReserve2 |
datetime |
YES |
| 183 | sSlaveMakePerson |
varchar(255) |
NO |
| 184 | bSlaveQlyComplete |
bit(1) |
NO |
| 185 | dSlaveSampleQty |
decimal(18,6) |
NO |
| 186 | dSlaveQlyQty |
decimal(18,6) |
NO |
| 187 | tSlaveCompleteDate |
datetime |
YES |
| 188 | sSlaveColorMemo |
text |
YES |
| 189 | sSlaveParam1 |
varchar(255) |
NO |
| 190 | sSlaveParam2 |
varchar(255) |
NO |
| 191 | sSlaveParam3 |
varchar(255) |
NO |
| 192 | sSlaveParam4 |
varchar(255) |
NO |
| 193 | sSlaveParam5 |
varchar(255) |
NO |
| 194 | sSlavePartsStyle |
varchar(255) |
NO |
| 195 | dSlaveLeftSide |
decimal(18,6) |
YES |
| 196 | dSlaveSkip |
decimal(18,6) |
YES |
| 197 | sSlavePaperDirection |
varchar(100) |
YES |
| 198 | dSlavePaper |
decimal(18,6) |
YES |
| 199 | dSlaveMeters |
decimal(18,6) |
YES |
| 200 | bSlaveCutting |
bit(1) |
NO |
| 201 | dSlaveOutSideDiameter |
decimal(18,6) |
YES |
| 202 | dSlaveDiameter |
decimal(18,6) |
YES |
| 203 | dSlaveCombineQty |
decimal(18,6) |
NO |
| 204 | bSlaveReceiptComplete |
bit(1) |
NO |
| 205 | bSlaveAdvanceComplete |
bit(1) |
NO |
| 206 | iIncrement |
int |
NO |
Definition
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`.`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`,`s`.`sId` AS `sSlaveId`,`s`.`iOrder` AS `iSlaveOrder`,`s`.`sParentId` AS `sParentId`,`s`.`sCustomerId` AS `sSlaveCustomerId`,`s`.`sContacts` AS `sSlaveContacts`,`s`.`sPhone` AS `sSlavePhone`,`s`.`tDeliverDate` AS `tSlaveDeliverDate`,`s`.`sSalesManId` AS `sSlaveSalesManId`,`s`.`sProductTechnologyVer` AS `sSlaveProductTechnologyVer`,`s`.`sGetPayId` AS `sSlaveGetPayId`,`s`.`tGetPayDate` AS `tSlaveGetPayDate`,`s`.`sConsignee` AS `sSlaveConsignee`,`s`.`sConsigneeMobile` AS `sSlaveConsigneeMobile`,`s`.`sDeliverId` AS `sSlaveDeliverId`,`s`.`sProvince` AS `sSlaveProvince`,`s`.`sCity` AS `sSlaveCity`,`s`.`sArea` AS `sSlaveArea`,`s`.`sDeliverTo` AS `sSlaveDeliverTo`,`s`.`sManualNo` AS `sSlaveManualNo`,`s`.`sCustomerOrderNo` AS `sSlaveCustomerOrderNo`,`s`.`sCurrency` AS `sSlaveCurrency`,`s`.`dCurrencyRate` AS `dSlaveCurrencyRate`,`s`.`sProductId` AS `sSlaveProductId`,`s`.`dProductQty` AS `dSlaveProductQty`,`s`.`dProductPrice` AS `dSlaveProductPrice`,`s`.`dProductMoney` AS `dSlaveProductMoney`,`s`.`sProductInfo` AS `sSlaveProductInfo`,`s`.`sMaterialsMemo` AS `sSlaveMaterialsMemo`,`s`.`sProcessMemo` AS `sSlaveProcessMemo`,`s`.`sSrcSlaveId` AS `sSlaveSrcSlaveId`,`s`.`sSrcId` AS `sSlaveSrcId`,`s`.`sSrcNo` AS `sSrcNo`,`s`.`dSrcQty` AS `dSrcQty`,`s`.`dProductPQty` AS `dProductPQtySlave`,`s`.`iProductStick` AS `iSlaveProductStick`,`s`.`bProductInStoreComplete` AS `bSlaveProductInStoreComplete`,`s`.`bDeliverComplete` AS `bSlaveDeliverComplete`,`s`.`bDeliverNotifyComplete` AS `bSlaveDeliverNotifyComplete`,`s`.`bOutsideProcessComplete` AS `bSlaveOutsideProcessComplete`,`s`.`bCheckingComplete` AS `bSlaveCheckingComplete`,`s`.`sQualityRequireMemo` AS `sSlaveQualityRequireMemo`,`s`.`sPackRequireMemo` AS `sSlavePackRequireMemo`,`s`.`sSlaveMemo` AS `sSlaveSlaveMemo`,`s`.`sTaxId` AS `sSlaveTaxId`,`s`.`dProductNoTaxPrice` AS `dSlaveProductNoTaxPrice`,`s`.`dProductNoTaxMoney` AS `dSlaveProductNoTaxMoney`,`s`.`dProductTaxMoney` AS `dSlaveProductTaxMoney`,`s`.`dProductTaxForeignMoney` AS `dSlaveProductTaxForeignMoney`,`s`.`dProductForeignMoney` AS `dSlaveProductForeignMoney`,`s`.`dProductInStoreQty` AS `dSlaveProductInStoreQty`,`s`.`dDeliverNotifyQty` AS `dSlaveDeliverNotifyQty`,`s`.`dDeliverQty` AS `dSlaveDeliverQty`,`s`.`dCheckingQty` AS `dSlaveCheckingQty`,`s`.`dReceiptMoney` AS `dSlaveReceiptMoney`,`s`.`dOutsideProcessQty` AS `dSlaveOutsideProcessQty`,`s`.`sWebOrderNo` AS `sSlaveWebOrderNo`,`s`.`sWebOrderId` AS `sSlaveWebOrderId`,`s`.`sBarcode` AS `sSlaveBarcode`,`s`.`dGiveQty` AS `dSlaveGiveQty`,`s`.`dPresentQty` AS `dSlavePresentQty`,`s`.`sProductTechnologyId` AS `sSlaveProductTechnologyId`,`s`.`sOrderId` AS `sSlaveOrderId`,`s`.`sOrderNo` AS `sSlaveOrderNo`,`s`.`sOrderSlaveId` AS `sSlaveOrderSlaveId`,`s`.`sSReserve1` AS `sSlaveSReserve1`,`s`.`sSReserve2` AS `sSlaveSReserve2`,`s`.`sSReserve3` AS `sSlaveSReserve3`,`s`.`sSReserve4` AS `sSlaveSReserve4`,`s`.`sSReserve5` AS `sSlaveSReserve5`,`s`.`sSReserve6` AS `sSlaveSReserve6`,`s`.`dSReserve1` AS `dSlaveSReserve1`,`s`.`dSReserve2` AS `dSlaveSReserve2`,`s`.`dSReserve3` AS `dSlaveSReserve3`,`s`.`iSReserve1` AS `iSlaveSReserve1`,`s`.`iSReserve2` AS `iSlaveSReserve2`,`s`.`iSReserve3` AS `iSlaveSReserve3`,`s`.`tSReserve1` AS `tSlaveSReserve1`,`s`.`tSReserve2` AS `tSlaveSReserve2`,`s`.`sMakePerson` AS `sSlaveMakePerson`,`s`.`bQlyComplete` AS `bSlaveQlyComplete`,`s`.`dSampleQty` AS `dSlaveSampleQty`,`s`.`dQlyQty` AS `dSlaveQlyQty`,`s`.`tCompleteDate` AS `tSlaveCompleteDate`,`s`.`sColorMemo` AS `sSlaveColorMemo`,`s`.`sParam1` AS `sSlaveParam1`,`s`.`sParam2` AS `sSlaveParam2`,`s`.`sParam3` AS `sSlaveParam3`,`s`.`sParam4` AS `sSlaveParam4`,`s`.`sParam5` AS `sSlaveParam5`,`s`.`sPartsStyle` AS `sSlavePartsStyle`,`s`.`dLeftSide` AS `dSlaveLeftSide`,`s`.`dSkip` AS `dSlaveSkip`,`s`.`sPaperDirection` AS `sSlavePaperDirection`,`s`.`dPaper` AS `dSlavePaper`,`s`.`dMeters` AS `dSlaveMeters`,`s`.`bCutting` AS `bSlaveCutting`,`s`.`dOutSideDiameter` AS `dSlaveOutSideDiameter`,`s`.`dDiameter` AS `dSlaveDiameter`,`s`.`dCombineQty` AS `dSlaveCombineQty`,`s`.`bReceiptComplete` AS `bSlaveReceiptComplete`,`s`.`bAdvanceComplete` AS `bSlaveAdvanceComplete`,`s`.`iIncrement` AS `iIncrement` from (`sgdsemigoodsmatchmaster` `m` join `sgdsemigoodsmatchslave` `s` on((`s`.`sParentId` = `m`.`sId`)))
Narrative
No human-written narrative yet.