Å×ÀÌºí ¼³¸í:
ÀÌ Å×À̺íÀº ¹Ýǰ »óǰ ±ÇÇÑ(RMA)¿ë ¹Ýǰ ¶Ç´Â ´ëº¯¿¡ ´ëÇÑ Ç׸ñ Á¤º¸¸¦ ÀúÀåÇÕ´Ï´Ù.
¿ ¼³¸í:
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
ADJUSTMENT |
DECIMAL(20,5)
NOT NULL, DEFAULT 0 |
°í°´ ¼ºñ½º ¿µ¾÷´ëÇ¥°¡ ´ëº¯ ±Ý¾×¿¡ ´ëÇØ Àû¿ëÇØ¾ß ÇÒ ¸ðµç Á¶Á¤ |
ADJUSTMENTCREDIT |
DECIMAL(20,5)
NOT NULL, DEFAULT 0 |
¿ø·¡ÀÇ ÁÖ¹®À» ÅëÇØ ´ëº¯ ó¸®µÉ Á¶Á¤ |
CATENTRY_ID |
BIGINT
NOT NULL |
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à |
COMMENTS |
VARCHAR (254)
NULL |
RMA Ç׸ñ¿¡ Àû¿ëµÇ´Â ¼³¸í |
CREDITAMOUNT |
DECIMAL(20,5)
NOT NULL, DEFAULT 0 |
ÀÌ Ç׸ñÀÇ ´ëº¯ ±Ý¾×(CURRENCY·Î ÁöÁ¤µÇ´Â ÅëÈ ´ÜÀ§). ÀÌ ±Ý¾×ÀÌ ³Î(Null)°ªÀÎ °æ¿ì, ´ëº¯ ±Ý¾×À» ¾Ë ¼ö ¾ø½À´Ï´Ù. |
CREDITDATE |
TIMESTAMP
NULL |
´ëº¯ÀÌ ½ÃÀÛµÈ ³¯Â¥ |
CURRENCY |
CHARACTER (3)
NOT NULL |
ÀÌ Ç׸ñ¿¡ ´ëÇØ ÁöÁ¤µÈ ±Ý¾×ÀÇ ÅëÈ ISO 4217 Ç¥ÁØ¿¡ ¸Â´Â ÅëÈ ÄÚµå. |
INVQUANTITY |
INTEGER
NOT NULL, DEFAULT 0 |
Àç°í ¼ö·® ´ÜÀ§ |
ITEMSPC_ID |
BIGINT
NOT NULL |
Àç°í Ç׸ñÀÇ µ¿Àϼº |
LASTUPDATE |
TIMESTAMP
NULL |
¸¶Áö¸·À¸·Î °»½ÅµÈ ½Ã°£¼ÒÀÎ |
MEMBER_ID |
BIGINT
NOT NULL |
RMA Ç׸ñ ·¹Äڵ带 ÀÛ¼ºÇÑ ±¸¼º¿ø ID |
ORDERITEMS_ID |
BIGINT
NULL |
ITEMSPC_IDÀÇ ±âÃʰ¡ µÇ´Â OrderItem |
QUANTITY |
DOUBLE
NOT NULL |
QUANTITY¿¡ CATENTSHIP.NOMINALQUANTITY¸¦ °öÇÑ °á°ú´Â CATENTSHIP.QUANTITYMULTIPLEÀÇ ¹è¼öÀ̾î¾ß Çϸç, CATENTSHIP.QUANTITYMEASURE¿¡ ÁöÁ¤µÈ ´ÜÀ§·Î ½ÇÁ¦ ÆÇ¸ÅµÇ´Â ¼ö·®À» ³ªÅ¸³À´Ï´Ù. |
REFUNDORREPLACE |
CHARACTER (3)
NOT NULL |
RMA Ç׸ñÀÌ È¯ºÒµÉ °ÍÀÎÁö ´ëüµÉ °ÍÀÎÁö ¿©ºÎ¸¦ ÁöÁ¤ÇÕ´Ï´Ù(REF(ȯºÒ) ¶Ç´Â REP(´ëü)). ÀÌ´Â ´ëº¯ÀÌ ³»ºÎÀûÀ¸·Î 󸮵ǴÂÁö ¿ÜºÎÀûÀ¸·Î 󸮵ǴÂÁö ¿©ºÎ, ÀͽºÃ¼ÀÎÁö(exchange) Á¤º¸°¡ ¼öÁýµÇ´ÂÁö ¿©ºÎ¿¡ ¿µÇâÀ» ÁÝ´Ï´Ù. REF¸¸ À¯È¿ÇÕ´Ï´Ù. |
RMA_ID |
BIGINT
NOT NULL |
RMAItemÀÌ ÀϺÎÀÎ RMA. |
RMAITEM_ID |
BIGINT
NOT NULL |
»ý¼ºµÈ °íÀ¯ Ű |
RTNREASON_ID |
INTEGER
NOT NULL |
¹ÝǰµÉ Ç׸ñÀÇ ¹Ýǰ ÀÌÀ¯ |
STATUS |
CHARACTER (3)
NULL, DEFAULT 'PND' |
´ÙÀ½°ú °°Àº RMAItem »óÅÂ: PND = º¸·ù Áß APP = ÀÚµ¿ÀûÀ¸·Î ½ÂÀÎµÊ MAN = ¼öµ¿À¸·Î ½ÂÀÎµÊ |
TAXAMOUNT |
DECIMAL(20,5)
NULL |
ȯºÒµÉ ¼¼±Ý¾×(CURRENCY·Î ÁöÁ¤µÇ´Â ÅëÈ ´ÜÀ§). ÀÌ ±Ý¾×ÀÌ ³Î(Null)°ªÀÎ °æ¿ì, ¼¼±ÝÀ» ¾Ë ¼ö ¾ø½À´Ï´Ù. |
TOTALCREDIT |
DECIMAL(20,5)
NOT NULL, DEFAULT 0 |
RMA Ç׸ñÀÇ ÃÑ ´ëº¯ |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
I0000215 | RMA_ID, RMAITEM_ID | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
I837145 | ORDERITEMS_ID, RMAITEM_ID, STATUS, RMA_ID | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
SQL020206020737910 | RMAITEM_ID | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_708 | CATENTRY_ID | CATENTRY | CATENTRY_ID | °è´Ü½Ä |
F_709 | MEMBER_ID | MEMBER | MEMBER_ID | °è´Ü½Ä |
F_710 | ORDERITEMS_ID | ORDERITEMS | ORDERITEMS_ID | °è´Ü½Ä |
F_711 | ITEMSPC_ID | ITEMSPC | ITEMSPC_ID | °è´Ü½Ä |
F_712 | RTNREASON_ID | RTNREASON | RTNREASON_ID | °è´Ü½Ä |
F_713 | RMA_ID | RMA | RMA_ID | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_703 | RMAITEM_ID | RMACHARGE | RMAITEM_ID | °è´Ü½Ä |
F_705 | RMAITEM_ID | RMAIADJCRD | RMAITEM_ID | °è´Ü½Ä |
F_706 | RMAITEM_ID | RMAIDNYRSN | RMAITEM_ID | °è´Ü½Ä |
F_716 | RMAITEM_ID | RMAITEMCMP | RMAITEM_ID | °è´Ü½Ä |
![]() |