ÇöÀç Àç°í ÇÒ´ç°ú Àç°í°¡ ÀÖ´Â »óǰÀÇ ¼ö·É »óŸ¦ °ËÅäÇÏ·Á¸é ÀÌ º¸°í¼¸¦ »ç¿ëÇϽʽÿÀ.
¿É¼Ç: SKU, ¼ºñ½º ¼¾ÅÍ
Á¤·Ä ±âÁØ: SKU
±×·ì ±âÁØ: ¼ºñ½º ¼¾ÅÍ, SKU
ÂüÁ¶µÈ ¿ À̸§ | Å×À̺í À̸§ | ¿ À̸§ |
---|---|---|
SKU | ITEMSPC | PARTNUMBER |
¼³¸í | BASEITMDSC | SHORTDESCRIPTION |
¼ºñ½º ¼¾ÅÍ | FFMCENTDS | DISPLAYNAME |
¼ö·® ´ÜÀ§ | QTYUNITDSC | DESCRIPTION |
»çÀÌÆ®ÀÇ ¼ö·® | sum(RECEIPT.QTYONHAND + RECEIPT.QTYINKITS) | |
ó¸® ¼ö·® | sum(RECEIPT.QTYINPROCESS) | |
¼ö·® ¿¹¾à | ITEMFFMCTR | QTYRESERVED |
ÁÖ¹®°¡´É ¼ö·® | sum(RECEIPT.QTYONHAND - RECEIPT.QTYINPROCESS) - (ITEMFFMCTR.QTYRESERVED + ITEMFFMCTR.QTYALLOCBACKORDER) | |
ÇÒ´ç ¹é¿À´õ ¼ö·® | ITEMFFMCTR | QTYALLOCBACKORDER |
¹é¿À´õ ¼ö·® | ITEMFFMCTR | QTYBACKORDERED |
ÃÖÁ¾ ¼ö·É ³¯Â¥ | max(RECEIPT.RECEIPTDATE) |
![]() |