Å×ÀÌºí ¼³¸í:
ÀÌ Å×À̺íÀÇ °¢ ÇàÀº »óÁ¡ÀÇ InventoryAdjustmentCode ¶Ç´Â »óÁ¡ ±×·ìÀÇ »óÁ¡À» Á¤ÀÇÇÕ´Ï´Ù. °¢ ÄÚµå´Â InventoryAdjustmentÀÇ ÀÌÀ¯(±úÁü, À¯½Ç ¶Ç´Â ãÀ½)¸¦ ³ªÅ¸³À´Ï´Ù.
¿ ¼³¸í:
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
ADJUSTCODE |
CHARACTER (4)
NOT NULL |
ƯÁ¤ StoreEntity¿¡ ´ëÇØ ÀÌ InventoryAdjustmentCode¸¦ °íÀ¯ÇÏ°Ô ½Äº°ÇÏ´Â ÄÚµå·Î¼, InventoryAdjustments ¹× InventoryAdjustmentCode¸¦ °ü¸®ÇÏ´Â »ç¿ëÀÚ ÀÎÅÍÆäÀ̽º·Î Ç¥½ÃÇϱ⿡ ÀûÇÕÇÕ´Ï´Ù. |
INVADJCODE_ID |
BIGINT
NOT NULL |
»ý¼ºµÈ 1Â÷ Ű |
LASTUPDATE |
TIMESTAMP
NULL |
¸¶Áö¸·À¸·Î ÀÌ InventoryAdjustmentCode°¡ °»½ÅµÈ ½Ã°£ |
MARKFORDELETE |
INTEGER
NULL, DEFAULT 0 |
InventoryAdjustmentCode¸¦ »èÁ¦ÇÒ °ÍÀÎÁö ¿©ºÎ¸¦ ³ªÅ¸³À´Ï´Ù. 0 = »èÁ¦µÇÁö ¾ÊÀ½. Àç°í Á¶Á¤¿¡ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù. 1 = »èÁ¦ Ç¥½Ã. Àç°í Á¶Á¤¿¡ »ç¿ëÇÒ ¼ö ¾ø½À´Ï´Ù. µ¥ÀÌÅͺ£À̽º Á¤¸® À¯Æ¿¸®Æ¼¸¦ ÂüÁ¶ÇϽʽÿÀ. |
STOREENT_ID |
INTEGER
NOT NULL |
InventoryAdjustmentCode¿¡ ´ëÇÑ »óÁ¡ ¶Ç´Â StoreGroup. InventoryAdjustmentCode´Â ÁöÁ¤µÈ »óÁ¡ ¶Ç´Â ÁöÁ¤µÈ StoreGroupÀÇ ¸ðµç »óÁ¡¿¡¼ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù. |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
I0000135 | ADJUSTCODE, STOREENT_ID | °íÀ¯ »öÀÎ |
SQL020206020642250 | INVADJCODE_ID | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_388 | STOREENT_ID | STOREENT | STOREENT_ID | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_390 | INVADJCODE_ID | INVADJDESC | INVADJCODE_ID | °è´Ü½Ä |
F_391 | INVADJCODE_ID | INVADJUST | INVADJCODE_ID | °è´Ü½Ä |
![]() |