Å×ÀÌºí ¼³¸í:
ÁÖ¹® ÁöºÒ ¶Ç´Â ¹Ýǰ ¹æ¹ý Å×ÀÌºí¿¡´Â °¢ ÁÖ¹®º°·Î ¼±ÅÃÇÑ ÁÖ¹® ÁöºÒ ¹æ¹ýÀÌ ¼ö·ÏµÇ¾î ÀÖ½À´Ï´Ù. ÀÌ Å×À̺íÀº ÁÖ¹®¿¡ ´ëÇØ û±¸ ¶Ç´Â ȯºÒµÈ ½ÇÁ¦ ±Ý¾×À» ÃßÀûÇÏ´Â µ¥¿¡µµ »ç¿ëµË´Ï´Ù.
¿ ¼³¸í:
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
ACCOUNT_ID |
BIGINT
NULL |
ºñÁî´Ï½º °èÁ¤ ID. ACCOUNT Å×À̺íÀÇ Foreign key. |
ACTUALAMOUNT |
DECIMAL(20,5)
NULL |
ÀÌ ÁÖ¹®¿¡ ´ëÇØ ó¸® ¶Ç´Â ȯºÒµÈ ½ÇÁ¦ ±Ý¾×. ȯºÒÀÇ °æ¿ì ÀÌ ±Ý¾×Àº À½¼öÀÔ´Ï´Ù. ÀÌ ±à¸ÆÀº ÁÖ¹® ÅëÈ¿Í °°Àº ÅëÈ·Î µÇ¾î ÀÖ½À´Ï´Ù. |
BIGINTFIELD1 |
BIGINT
NULL |
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à |
BIGINTFIELD2 |
BIGINT
NULL |
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à |
BIGINTFIELD3 |
BIGINT
NULL |
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à |
BUYERPO_ID |
BIGINT
NULL |
ÁÖ¹®¿¡ ´ëÇØ ÁöÁ¤µÈ ±¸¸ÅÀÚ ±¸¸Å ÁÖ¹® ¹øÈ£¸¦ ³ªÅ¸³»´Â BuyerPOÀÇ ID BUYERPO Å×À̺íÀÇ foreign key. |
CHARGEAMOUNT |
DECIMAL(20,5)
NULL |
»óÁ¡ ±âº» ÅëÈ·Î º¯È¯µÈ ½ÇÁ¦ ±Ý¾× |
CHARGEAMTCURR |
CHARACTER (3)
NULL |
CHARGEAMOUNT ¿¿¡ ´ëÇÑ ÅëÈ. ISO 4217 Ç¥ÁØ¿¡ ¸Â´Â ÅëÈ ÄÚµå. |
CHARGETIME |
TIMESTAMP
NULL |
ºñ¿ëÀÌ °»½ÅµÈ ½Ã°£ |
CREDITLINE_ID |
BIGINT
NULL |
PayMethod°¡ "LOC"ÀÎ ±¸¸Å¿¡ ´ëÇÑ ºñ¿ëÀ» ÃßÀûÇϱâ À§ÇÑ ½Å¿ë Çѵµ ID. CREDITLINE Å×À̺íÀÇ foreign key. |
DECIMALFIELD1 |
DECIMAL(20,5)
NULL |
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à |
DECIMALFIELD2 |
DECIMAL(20,5)
NULL |
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à |
DECIMALFIELD3 |
DECIMAL(20,5)
NULL |
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à |
ENDDATE |
TIMESTAMP
NULL |
Á¾·á ³¯Â¥. ±âº» DoPayment ±¸ÇöÀº ÀÌ ¿À» »ç¿ëÇÏ¿© ½Å¿ë Ä«µå ¸¸±â ³¯Â¥¸¦ º¸À¯ÇÕ´Ï´Ù. |
MAXAMOUNT |
DECIMAL(20,5)
NULL |
ÁöºÒ ÃÖ´ë Çã¿ë¾×. |
ORDERS_ID |
BIGINT
NOT NULL |
ÁÖ¹® ID. ORDERS Å×À̺íÀÇ foreign key. |
PAYDEVICE |
CHARACTER (64)
NOT NULL |
ÁöºÒ ÀåÄ¡ ½Äº°ÀÚ. ±âº» DoPayment ±¸Çö¿¡¼´Â ÀÌ ¿¿¡ ½Å¿ë Ä«µå ¹øÈ£¸¦ ÀúÀåÇÕ´Ï´Ù. WebSphere Commerce ±¸¼º ÆÄÀÏ¿¡¼ PDIEncrypt°¡ "on"À¸·Î ¼³Á¤µÇ¾î ÀÖÀ¸¸é ¼ýÀÚ°¡ ¾Ïȣȵ˴ϴÙ. |
PAYMETHOD |
CHARACTER (5)
NOT NULL |
5ÀÚ±îÁöÀÇ ÁÖ¹® ÁöºÒ ¹æ¹ý. ÁÖ¹® ÁöºÒÀ» ó¸®ÇÏ´Â µ¥ Payment Manager¸¦ »ç¿ëÇÒ °æ¿ì, ÀÌ¿¿¡´Â "PSRVR"À̶ó´Â ´Ü¾î°¡ µé¾î ÀÖ½À´Ï´Ù. "LOC"Àº CreditLineÀ» »ç¿ëÇÑ ÁöºÒÀ» ³ªÅ¸³»´Â µ¥ »ç¿ëµË´Ï´Ù. |
PAYSUMMARY_ID |
BIGINT
NULL |
ÀÌ ÁöºÒÀÌ ¼ÓÇÏ´Â ÁöºÒ Á¤º¸ ¿ä¾à Ç׸ñÀ» ³ªÅ¸³À´Ï´Ù. PaymentSummaryGenerate ¸í·ÉÀ» ½ÇÇàÇÏ¿© ÁöºÒ Á¤º¸ ¿ä¾à Ç׸ñÀÌ ÀÛ¼ºµÉ ¶§ ÀÌ Çʵ尡 °»½ÅµË´Ï´Ù. |
POLICY_ID |
BIGINT
NULL |
ÀÌ ±¸¸Å¿¡ »ç¿ëµÇ´Â ÁöºÒ Á¤Ã¥À» ³ªÅ¸³»´Â ÁöºÒ Á¤Ã¥ ID |
REFUNDNUMBER |
BIGINT
NOT NULL, DEFAULT 0 |
ÀÌ Ç׸ñÀÌ È¯ºÒ Ç׸ñÀ» ³ªÅ¸³»´Â °æ¿ì ȯºÒ ¹øÈ£ (ȯºÒÀÇ °æ¿ì RMA(return merchandise authorization) ID¸¦ ȯºÒ ¹øÈ£·Î »ç¿ëÇϽʽÿÀ). |
RMA_ID |
BIGINT
NULL |
ÁÖ¹®¿¡ ´ëÇØ ¹ÝǰÇÒ °æ¿ìÀÇ RMA ID. RMA Å×À̺íÀÇ foreign key. |
STARTDATE |
TIMESTAMP
NULL |
½ÃÀÛ ³¯Â¥. DoPayment ±¸Çö¿¡¼´Â ÀÚ½ÅÀÌ ÀÌ ¿À» »ç¿ëÇÕ´Ï´Ù (ÀÌ ¿Àº ±âº» DoPayment ±¸Çö¿¡¼´Â »ç¿ëµÇÁö ¾Ê½À´Ï´Ù). |
STATUS |
INTEGER
NULL, DEFAULT 0 |
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à |
STRINGFIELD1 |
VARCHAR (254)
NULL |
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à |
STRINGFIELD2 |
VARCHAR (254)
NULL |
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à |
STRINGFIELD3 |
VARCHAR (254)
NULL |
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à |
STRINGFIELD4 |
VARCHAR (254)
NULL |
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à |
TRADING_ID |
BIGINT
NULL |
°Å·¡ Àμö¿¡ ´ëÇÑ ID. ÀϹÝÀûÀ¸·Î ¹Ýǰ Ç׸ñ¿ëÀ¸·Î¸¸ »ç¿ëµË´Ï´Ù. °Å·¡ Å×ÀÌºí¿¡ Foreign key. |
XMLDATA |
LONG VARCHAR
NULL |
ÁöºÒ 󸮽à »ý¼ºµÈ ÁÖ¹® XML (±âº» DebitAccount ŽºÅ© ¸í·É ±¸Çö¿¡¼ »ç¿ë) |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
SQL020206020711250 | ORDERS_ID, PAYMETHOD, PAYDEVICE, REFUNDNUMBER | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_535 | RMA_ID | RMA | RMA_ID | °è´Ü½Ä |
F_536 | POLICY_ID | POLICY | POLICY_ID | °è´Ü½Ä |
F_537 | PAYSUMMARY_ID | PAYSUMMARY | PAYSUMMARY_ID | °è´Ü½Ä |
F_538 | BUYERPO_ID | BUYERPO | BUYERPO_ID | °è´Ü½Ä |
F_539 | TRADING_ID | TRADING | TRADING_ID | °è´Ü½Ä |
F_540 | CREDITLINE_ID | CREDITLINE | CREDITLINE_ID | °è´Ü½Ä |
F_541 | ACCOUNT_ID | ACCOUNT | ACCOUNT_ID | °è´Ü½Ä |
F_542 | ORDERS_ID | ORDERS | ORDERS_ID | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
![]() |