Å×ÀÌºí ¼³¸í:
ÀÌ Å×À̺íÀÇ ¹Ýǰ »óǰ ±ÇÇÑ(RMA)¿ë ÄÁÅ×À̳ÊÀÔ´Ï´Ù.
¿ ¼³¸í:
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
COMMENTS |
VARCHAR (254)
NULL |
RMA Àüü¿¡ Àû¿ëµÇ´Â ¼³¸í |
CURRENCY |
CHARACTER (3)
NULL |
RMA ³»ÀÇ ¸ðµç ±Ý¾×¿¡ ´ëÇÑ ÅëÈ. RMA¿¡ Ãß°¡µÈ ¸ðµç Ç׸ñÀº µ¿ÀÏÇÑ ÅëÈ °ªÀ» °¡Áý´Ï´Ù. ISO 4217 Ç¥ÁØ¿¡ ¸Â´Â ÅëÈ ÄÚµå. |
FFMCENTER_ID |
INTEGER
NULL |
¹ÝǰµÈ Ç׸ñÀÌ ¿î¼ÛµÉ ¼ºñ½º ¼¾ÅÍ. |
INUSE |
CHARACTER (1)
NOT NULL, DEFAULT 'N' |
WebSphere Commerce ¾×¼¿·¯·¹ÀÌÅͰ¡ ·¹Äڵ带 »ç¿ë ÁßÀ¸·Î Ç¥½ÃÇÏ´Â µ¥ »ç¿ëÇÕ´Ï´Ù. CSRÀÌ ¹Ýǰ º¯°æ ³ëÆ®ºÏÀ» ¿¾î¼ ¹ÝǰÀ» ÆíÁýÇÒ ¶§, INUSE ¿Àº RMA°¡ »ç¿ë ÁßÀÓÀ» Ç¥½ÃÇϱâ À§ÇØ Y·Î ¼³Á¤µË´Ï´Ù. ÀÏ´Ü Á¾·áµÇ¸é, ¿Àº NÀ¸·Î ¼³Á¤µË´Ï´Ù. |
LASTUPDATE |
TIMESTAMP
NOT NULL |
¸¶Áö¸·À¸·Î °»½ÅµÈ ½Ã°£¼ÒÀÎ |
MEMBER_ID |
BIGINT
NOT NULL |
¹ÝǰÀ» ¿äûÇÏ´Â ±¸¼º¿ø. °í°´ ¼ºñ½º ¿µ¾÷´ëÇ¥±â RMA¸¦ ÀÛ¼ºÇÑ °æ¿ì, °í°´ ¼ºñ½º ¿µ¾÷´ëÇ¥¿¡°Ô ¿¬°áÇÑ ±¸¼º¿øÀÔ´Ï´Ù. |
ORGENTITY_ID |
BIGINT
NULL |
±¸¸Å Á¶Á÷ |
POLICY_ID |
BIGINT
NULL |
RefundPaymentMethod Á¤Ã¥ ID |
PREPARED |
CHARACTER (1)
NOT NULL, DEFAULT 'N' |
ReturnPrepare ¸í·ÉÀÌ RMA¿¡ ´ëÇØ ½ÇÇàµÈ ¸¶Áö¸· ¸í·ÉÀ̾ú´ÂÁö ÁöÁ¤ÇÕ´Ï´Ù. |
REFUNDAGAINSTORDID |
BIGINT
NULL |
¹ÝǰÀ» ´ëº¯ ó¸®ÇÒ ÁÖ¹® ID |
RMA_ID |
BIGINT
NOT NULL |
»ý¼ºµÈ °íÀ¯ Ű |
RMADATE |
TIMESTAMP
NOT NULL |
RMA°¡ ÀÛ¼ºµÈ ½Ã°£ |
STATUS |
CHARACTER (3)
NOT NULL, DEFAULT 'PRC' |
RMAÀÇ »óÅ´ ´ÙÀ½°ú °°½À´Ï´Ù. PRC = °í°´ÀÌ ÆíÁý Áß EDT = °í°´ ¼ºñ½º ¿µ¾÷´ëÇ¥°¡ ÆíÁý Áß PND = º¸·ù Áß APP = ½ÂÀÎµÊ CLO = Á¾·á CAN = Ãë¼Ò |
STORE_ID |
INTEGER
NOT NULL |
RMA°¡ ó¸® ÁßÀÎ »óÁ¡ÀÇ ID |
TOTALCREDIT |
DECIMAL(20,5)
NULL, DEFAULT 0 |
CURRENCY ¿¿¡ ÁöÁ¤µÈ ÅëÈ ´ÜÀ§ÀÇ ÃÑ ½Å¿ë Çѵµ. ÀÌ ±Ý¾×ÀÌ ³Î(Null)°ªÀÎ °æ¿ì, ÃÑ ±Ý¾×À» ¾Ë ¼ö ¾ø½À´Ï´Ù. |
TRADING_ID |
BIGINT
NULL |
ÀÌ RMA ó¸®ÀÇ ´ë»óÀÌ µÇ´Â °Å·¡ °è¾àÀÇ ID. ÀÌ ID´Â ½ÂÀÎ, ºñ¿ë, ȯºÒ ÁöºÒ Á¤Ã¥À» °áÁ¤ÇÕ´Ï´Ù. |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
I0000213 | RMA_ID, RMADATE | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
I836145 | RMA_ID, STATUS | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
SQL020206020736310 | RMA_ID | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_694 | ORGENTITY_ID | ORGENTITY | ORGENTITY_ID | °è´Ü½Ä |
F_695 | POLICY_ID | POLICY | POLICY_ID | °è´Ü½Ä |
F_696 | TRADING_ID | TRADING | TRADING_ID | °è´Ü½Ä |
F_697 | STORE_ID | STORE | STORE_ID | °è´Ü½Ä |
F_698 | MEMBER_ID | MEMBER | MEMBER_ID | °è´Ü½Ä |
F_699 | FFMCENTER_ID | FFMCENTER | FFMCENTER_ID | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_535 | RMA_ID | ORDPAYMTHD | RMA_ID | °è´Ü½Ä |
F_673 | RMA_ID | REFUNDMTHD | RMA_ID | °è´Ü½Ä |
F_700 | RMA_ID | RMAAUTHLOG | RMA_ID | °è´Ü½Ä |
F_702 | RMA_ID | RMACHARGE | RMA_ID | °è´Ü½Ä |
F_713 | RMA_ID | RMAITEM | RMA_ID | °è´Ü½Ä |
F_718 | RMA_ID | RMATAX | RMA_ID | °è´Ü½Ä |
F_730 | RMA_ID | RTNRECEIPT | RMA_ID | °è´Ü½Ä |
F_881 | RMA_ID | TRDREFAMT | RMA_ID | °è´Ü½Ä |
![]() |