| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283 |
- UPDATE plm_item
- SET changeuserid=$userid$,
- changedate = current_time,
- unitid=$unitid$,
- isauxunit=$isauxunit$,
- unitgroupid=$unitgroupid$,
- itemname=$itemname$,
- model = $model$,
- spec=$spec$,
- orderminqty=$orderminqty$,
- orderaddqty=$orderaddqty$,
- orderminqty_auxunit= $orderminqty_auxunit$,
- orderaddqty_auxunit= $orderaddqty_auxunit$,
- remarks = $remarks$,
- barcode = $barcode$,
- skucontrol = $skucontrol$,
- batchcontrol = $batchcontrol$,
- grossweight = $grossweight$,
- weight = $weight$,
- height = $height$,
- width = $width$,
- length = $length$,
- delivery = $delivery$,
- istool = $istool$,
- marketprice = $marketprice$,
- standards = $standards$,
- stockstatus2 = $stockstatus2$,
- stockstatus1 = $stockstatus1$,
- warrantyday = $warrantyday$,
- iswuliao = $iswuliao$,
- ismodule = $ismodule$,
- color = $color$,
- cheek=$cheek$,
- delistingstatus=$delistingstatus$,
- packageqty = $packageqty$,
- iswoodproducts=$iswoodproducts$,
- isservice = $isservice$,
- sa_customschemeid=$sa_customschemeid$,
- financeclasstype=$financeclasstype$,
- stockno=$stockno$,
- marketingcategory=$marketingcategory$,
- volume=$volume$,
- widthschemeid=$widthschemeid$,
- lengthschemeid=$lengthschemeid$,
- iscustomsize=$iscustomsize$,
- customprice=$customprice$,
- pricingmetod=$pricingmetod$,
- cheekschemeid=$cheekschemeid$,
- colorschemeid=$colorschemeid$,
- materialschemeid=$materialschemeid$,
- cost=$cost$,
- grossprofit=$grossprofit$,
- saleprice=$saleprice$,
- grossprofitmargin=$grossprofitmargin$,
- soldbase=$soldbase$,
- byname=$byname$,
- rate=$rate$,
- grade=$grade$,
- custamount=$custamount$,
- safeqty=$safeqty$,
- icaddqty=$icaddqty$,
- icminqty=$icminqty$,
- iswriteoff=$iswriteoff$,
- isnegative=$isnegative$,
- ispartorderautocheck=$ispartorderautocheck$,
- islimitemparts=$islimitemparts$,
- itemname_print=$itemname_print$,
- applicablegassource=$applicablegassource$,
- hygienelicensenum=$hygienelicensenum$,
- departmentid=$departmentid$,
- executionstandards=$executionstandards$,
- itemclsnum=$itemclsnum$,
- outplace=$outplace$,
- repairattribute=$repairattribute$,
- shapesize=$shapesize$,
- topclassnum=$topclassnum$,
- aftersalesitemno=$aftersalesitemno$,
- kw=$kw$,
- gysmc=$gysmc$
- WHERE itemid = $itemid$
- and siteid = $siteid$
|
