µ¥ÀÌÅͺ£À̽º Å×À̺í: CURFMTDESC


Å×ÀÌºí ¼³¸í:

ÀÌ Å×À̺íÀÇ °¢ ÇàÀº ÅëÈ­ Æ÷¸ËÆÃ ±ÔÄ¢ÀÇ ¾ð¾î Á¾¼Ó ºÎºÐÀ» ³ªÅ¸³À´Ï´Ù. ¿©±â¼­´Â ƯÁ¤ ÅëÈ­, ƯÁ¤ ¾ð¾î·Î ±Ý¾×À» Æ÷¸Ë(Ç¥½ÃÇÒ ¸ñÀûÀ¸·Î)ÇÏ´Â ¹æ¹ý¿¡ ´ëÇØ ¼³¸íÇÕ´Ï´Ù.

¿­ ¼³¸í:

¿­ À̸§ ¿­ À¯Çü ¿­ ¼³¸í
CURRENCYPREFIXNEG VARCHAR (254)
NULL
±Ý¾×ÀÌ À½¼öÀÏ ¶§ »ç¿ëÇÏ´Â Á¢µÎ¾î. ÀÌ ÇÊµå ¹× CURRENCYSUFFIXNEG°¡ ³Î(Null)°ªÀ̸é, NumberFormatÀÇ negativePrefix°¡ »ç¿ëµË´Ï´Ù.
CURRENCYPREFIXPOS VARCHAR (254)
NULL
±Ý¾×ÀÌ ¾ç¼öÀÏ ¶§ »ç¿ëÇÏ´Â Á¢µÎ¾î. ÀÌ ÇÊµå ¹× CURRENCYSUFFIXPOS°¡ ³Î(Null)°ªÀ̸é, NumberFormatÀÇ positivePrefix°¡ »ç¿ëµË´Ï´Ù.
CURRENCYSUFFIXNEG VARCHAR (254)
NULL
±Ý¾×ÀÌ À½¼öÀÏ ¶§ »ç¿ëÇÏ´Â Á¢µÎ¾î. ÀÌ ÇÊµå ¹× CURRENCYPREFIXNEG°¡ ³Î(Null)°ªÀ̸é, NumberFormatÀÇ negativeSuffix°¡ »ç¿ëµË´Ï´Ù.
CURRENCYSUFFIXPOS VARCHAR (254)
NULL
±Ý¾×ÀÌ ¾ç¼öÀÏ ¶§ »ç¿ëÇÏ´Â Á¢¹Ì¾î. ÀÌ ÇÊµå ¹× CURRENCYPREFIXPOS°¡ ³Î(Null)°ªÀ̸é, NumberFormatÀÇ positiveSuffixÀÌ »ç¿ëµË´Ï´Ù.
CURRENCYSYMBOL VARCHAR (254)
NULL
ÅëÈ­ ±âÈ£.
CUSTOMIZEDCURRSTR VARCHAR (254)
NULL
´ëü ÅëÈ­ ÄÚµå. WebSphere Commerce´Â ÀÌ °ªÀ» »ç¿ëÇÏÁö ¾Ê½À´Ï´Ù. °ªÀ» Á¦°øÇϰí JSP ¸ÅÅ©·Î¸¦ ÀÛ¼ºÇÏ¿© ÀÌ Äڵ带 »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.
DESCRIPTION VARCHAR (254)
NULL
ÅëÈ­¿¡ ´ëÇÑ ¼³¸íÀ¸·Î, ÅëÈ­ ¼±Åà ¸ñ·ÏÀÇ °í°´¿¡°Ô Ç¥½ÃÇÏ´Â µ¥ Àû´çÇÕ´Ï´Ù.
DISPLAYLOCALE CHARACTER (16)
NULL
Æ÷¸ËÆÃÀ» ¼öÇàÇÏ´Â µ¥ »ç¿ëµÇ´Â ÅëÈ­ NumberFormat ¿ÀºêÁ§Æ®¸¦ ÀÛ¼ºÇÏ´Â µ¥ »ç¿ëµÇ´Â Java ·ÎÄÉÀÏ. ÀÌ °ªÀÌ ³Î(Null)°ªÀ̸é, LANGUAGE_ID(LANGUAGE Å×À̺í ÂüÁ¶)¿¡ ¿¬°üµÈ ·ÎÄÉÀÏÀÌ »ç¿ëµË´Ï´Ù.
GROUPINGCHAR CHARACTER (1)
NULL
NumberFormat ¿ÀºêÁ§Æ®¿¡ ÀÇÇØ »ç¿ëµÇ´Â ±×·ìÈ­ ¹®ÀÚ. Ãß°¡ Á¤º¸´Â CURFMTDESC Å×À̺í: Á¤º¸¸¦ ÂüÁ¶ÇϽʽÿÀ.
LANGUAGE_ID INTEGER
NOT NULL
¾ð¾î. ¾ð¾î ±¸¼º¿ä¼Ò´Â LANGUAGE Å×À̺íÀ» ÂüÁ¶ÇϽʽÿÀ.
NUMBERPATTERN VARCHAR (254)
NULL
NumberFormat ¿ÀºêÁ§Æ®¿¡ Àû¿ëµÉ ¼ýÀÚ ÆÐÅÏ. ¼ýÀÚ ÆÐÅÏÀº java.text.DecimalFormat Ŭ·¡½º¿¡ ´ëÇÑ JDK ¹®¼­¿¡ ¼³¸íµÇ¾î ÀÖ½À´Ï´Ù. ÀÌ °ªÀÌ ³Î(Null)°ªÀ̸é, NumberFormat ¿ÀºêÁ§Æ®ÀÇ ±âº» ¼ýÀÚ ÆÐÅÏÀÌ »ç¿ëµË´Ï´Ù.
NUMBRUSG_ID INTEGER
NOT NULL, DEFAULT -1
ÀÌ ÅëÈ­ Æ÷¸ËÆÃ ±ÔÄ¢Àº ÇØ´ç »ç¿ë¿¡ ¸Â°Ô ±Ý¾×À» Æ÷¸ËÆÃÇÒ ¶§ »ç¿ëÇØ¾ß ÇÕ´Ï´Ù.
RADIXPOINT CHARACTER (1)
NULL
NumberFormat ¿ÀºêÁ§Æ®¿¡ ´ëÇÑ radix Æ÷ÀÎÆ®. Ãß°¡ Á¤º¸´Â CURFMTDESC Å×À̺í: Á¤º¸¸¦ ÂüÁ¶ÇϽʽÿÀ.
SETCCURR CHARACTER (3)
NOT NULL
ÅëÈ­ ISO 4217 Ç¥ÁØ¿¡ ¸Â´Â ÅëÈ­ ÄÚµå.
STOREENT_ID INTEGER
NOT NULL
ÀÌ Æ÷¸ËÆÃ ±ÔÄ¢ÀÌ ÀϺκÐÀÎ StoreEntity.

»öÀÎ:

»öÀÎ À̸§ »öÀÎµÈ ¿­ À̸§ »öÀÎ À¯Çü
SQL020206020618540 NUMBRUSG_ID, STOREENT_ID, SETCCURR, LANGUAGE_ID 1Â÷ Ű

Á¦ÇÑ»çÇ×:

Á¦ÇÑÀÚ À̸§ ¿­ À̸§ Foreign Å×À̺í À̸§ Foreign ¿­ À̸§ Á¦ÇÑÀÚ À¯Çü
F_290 LANGUAGE_ID LANGUAGE LANGUAGE_ID °è´Ü½Ä
F_291 STOREENT_ID, SETCCURR, NUMBRUSG_ID CURFORMAT STOREENT_ID, SETCCURR, NUMBRUSG_ID °è´Ü½Ä


ÂüÁ¶:

Á¦ÇÑÀÚ À̸§ ÂüÁ¶µÈ ¿­ À̸§ Foreign Å×À̺í À̸§ Foreign ¿­ À̸§ Á¦ÇÑÀÚ À¯Çü
¾øÀ½
IBM copyright