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


Å×ÀÌºí ¼³¸í:

ÀÌ Å×ÀÌºí¿¡´Â ´Ù¸¥ ±¹°¡ÀÇ ÅëÈ­¿¡ ´ëÇÑ Á¤º¸°¡ µé¾î ÀÖ½À´Ï´Ù. ¾ËÆÄºª°ú ¼ýÀÚ ÄÚµå´Â ISO 4217 Ç¥ÁØÀ» ÁؼöÇÕ´Ï´Ù.

¿­ ¼³¸í:

¿­ À̸§ ¿­ À¯Çü ¿­ ¼³¸í
SETCCODE INTEGER
NOT NULL
ISO 4217¿¡ µû¸¥ ¼ýÀÚ ÅëÈ­ ÄÚµå.
SETCCURR CHARACTER (3)
NOT NULL
ISO 4217¿¡ µû¸¥ ¾ËÆÄºª ÅëÈ­ ÄÚµå. 1Â÷ ŰÀÔ´Ï´Ù.
SETCEXP INTEGER
NOT NULL
Áö¼ö(10ÀÇ Á¦°ö). ±âº» ÅëÈ­ ´ÜÀ§·Î ³ªÅ¸³»±â À§ÇØ ¼Ò´ÜÀ§ ÅëÈ­(¿¹: ¼¾Æ®)¸¦ °öÇÏ´Â Áö¼ö°ª. ¿¹¸¦ µé¾î, ¼¾Æ® °ª¿¡ 10ÀÇ -2½Â(Áï, 0.01)À» °öÇÏ¿© ´Þ·¯ °ªÀ» ¾òÀ» ¼ö ÀÖ½À´Ï´Ù.
SETCNOTE VARCHAR (40)
NULL
»ç¿ëÀÚ Á¤ÀÇ °¡´É ÀÌ ¿­Àº º¯È¯µÇÁö ¾Ê½À´Ï´Ù. ÀÌ Å×À̺íÀÇ ÅëÈ­¿¡ ´ëÇØ ¼³¸íÇÏ´Â º¯È¯°¡´ÉÇÑ ÅØ½ºÆ®´Â SETCURRDSC Å×ÀÌºí¿¡ ÀúÀåµË´Ï´Ù.

»öÀÎ:

»öÀÎ À̸§ »öÀÎµÈ ¿­ À̸§ »öÀÎ À¯Çü
SQL020206020744680 SETCCURR 1Â÷ Ű

Á¦ÇÑ»çÇ×:

Á¦ÇÑÀÚ À̸§ ¿­ À̸§ Foreign Å×À̺í À̸§ Foreign ¿­ À̸§ Á¦ÇÑÀÚ À¯Çü
¾øÀ½


ÂüÁ¶:

Á¦ÇÑÀÚ À̸§ ÂüÁ¶µÈ ¿­ À̸§ Foreign Å×À̺í À̸§ Foreign ¿­ À̸§ Á¦ÇÑÀÚ À¯Çü
F_136 SETCCURR BUYERPO SETCCURR °è´Ü½Ä
F_167 SETCCURR CALRLOOKUP SETCCURR °è´Ü½Ä
F_175 SETCCURR CALSCALE SETCCURR °è´Ü½Ä
F_268 SETCCURR CPPMN SETCCURR °è´Ü½Ä
F_278 SETCCURR CREDITLINE SETCCURR °è´Ü½Ä
F_284 SETCCURR CURCONVERT TOCURR °è´Ü½Ä
F_285 SETCCURR CURCONVERT FROMCURR °è´Ü½Ä
F_287 SETCCURR CURCVLIST COUNTERVALUECURR °è´Ü½Ä
F_288 SETCCURR CURCVLIST CURRSTR °è´Ü½Ä
F_294 SETCCURR CURFORMAT SETCCURR °è´Ü½Ä
F_295 SETCCURR CURLIST CURRSTR °è´Ü½Ä
F_377 SETCCURR ICTPRICES SETCCURR °è´Ü½Ä
F_418 SETCCURR LISTPRICE CURRENCY °è´Ü½Ä
F_422 SETCCURR LPOPURAMT SETCCURR °è´Ü½Ä
F_426 SETCCURR MANIFEST SETCCURR °è´Ü½Ä
F_473 SETCCURR OFFERPRICE CURRENCY °è´Ü½Ä
F_580 SETCCURR PAYSUMMARY SETCCURR °è´Ü½Ä
F_662 SETCCURR RECEIPT SETCCURR °è´Ü½Ä
F_667 SETCCURR REFUNDMTHD SETCCURR °è´Ü½Ä
F_678 SETCCURR RFQPROD CURRENCY °è´Ü½Ä
F_687 SETCCURR RFQRSPPROD CURRENCY °è´Ü½Ä
F_742 SETCCURR SETCURRDSC SETCCURR °è´Ü½Ä
F_789 SETCCURR STOREENT SETCCURR °è´Ü½Ä
F_800 SETCCURR STORELANG SETCCURR °è´Ü½Ä
F_869 SETCCURR TRDDEPAMT SETCCURR °è´Ü½Ä
F_875 SETCCURR TRDPURAMT SETCCURR °è´Ü½Ä
F_879 SETCCURR TRDREFAMT SETCCURR °è´Ü½Ä
F_898 SETCCURR USERS SETCCURR °è´Ü½Ä
IBM copyright