ItemQuotation question

[loader8]

hi guys, i have a question i dont know for what are this 3 colums
from this Table Itemquotation

1- BaseStockAmount
2- FluctuateAmount
3- CurStockAmount

who can help me with that?

what that columns make? or for what are
thx

[kotsh23]

me too i wonder what this 3 columns and the other 3 too
BaseQuot , Quot_LB, Quot_UB

please any idea ?

[Tekno D]

[Devsome]

#moved

[-[Anxi]-]

Originally Posted by kotsh23

me too i wonder what this 3 columns and the other 3 too
BaseQuot , Quot_LB, Quot_UB

please any idea ?

For example

-- do the multiplication -- 200M * 3 = 200M buy > 400M give for
UPDATE _ItemQuotation set BaseQuot='8.5', Quot_LB='8.5', Quot_UB='8.5' where AssocNPC=2077 and RefItemID in (select ID from _RefObjCommon where CodeName128 like 'ITEM_ETC_TRADE_CH%') -- jangan - hotan
UPDATE _ItemQuotation set BaseQuot='8.5', Quot_LB='8.5', Quot_UB='8.5' where AssocNPC=2010 and RefItemID in (select ID from _RefObjCommon where CodeName128 like 'ITEM_ETC_TRADE_KT%') -- hotan - jangan

UPDATE _ItemQuotation set BaseQuot='5', Quot_LB='5', Quot_UB='5' where AssocNPC=2059 and RefItemID in (select ID from _RefObjCommon where CodeName128 like 'ITEM_ETC_TRADE_CH%') -- jangan-downhang
UPDATE _ItemQuotation set BaseQuot='5', Quot_LB='5', Quot_UB='5' where AssocNPC=2010 and RefItemID in (select ID from _RefObjCommon where CodeName128 like 'ITEM_ETC_TRADE_WC%') -- downhang-jangan

UPDATE _ItemQuotation set BaseQuot='5', Quot_LB='5', Quot_UB='5' where AssocNPC=2077 and RefItemID in (select ID from _RefObjCommon where CodeName128 like 'ITEM_ETC_TRADE_WC%') -- downhang-hotan
UPDATE _ItemQuotation set BaseQuot='5', Quot_LB='5', Quot_UB='5' where AssocNPC=2059 and RefItemID in (select ID from _RefObjCommon where CodeName128 like 'ITEM_ETC_TRADE_KT%') -- hotan-downhang