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


Å×ÀÌºí ¼³¸í:

±¸ÀÔ ÇѰè Å×À̺í

¿­ ¼³¸í:

¿­ À̸§ ¿­ À¯Çü ¿­ ¼³¸í
CATENTRY_ID BIGINT
NOT NULL
ÆÇ¸Å¿ëÀ¸·Î Á¦°øµÈ CatalogEntry
CURRENCY CHARACTER (3)
NULL
ÃÖ¼Ò ¶Ç´Â ÃÖ´ë ±Ý¾×ÀÇ ÅëÈ­. ISO 4217 Ç¥ÁØ¿¡ ¸Â´Â ÅëÈ­ ÄÚµå.
CURRENTAMOUNT DECIMAL(20,5)
NULL
ÇöÀç ±¸ÀÔ ÃѰè
CURRENTQUANTITY DOUBLE
NULL
ÇöÀç ±¸ÀÔ ¼ö·®
LIMITTYPE CHARACTER (1)
NOT NULL
ÇѰèÀÇ À¯ÇüÀ» Ç¥½ÃÇÕ´Ï´Ù.
0 = ¼ö·®º° ¶Ç´Â 1 = ÃѰ躰.
MAXAMOUNT DECIMAL(20,5)
NULL
ÃÖ´ë ±¸ÀÔ ÃѰè
MAXQUANTITY DOUBLE
NULL
ÃÖ´ë ±¸ÀÔ ¼ö·®
MINAMOUNT DECIMAL(20,5)
NULL
ÃÖ¼Ò ±¸ÀÔ ÃѰè
MINQUANTITY DOUBLE
NULL
ÃÖ¼Ò ±¸ÀÔ ¼ö·®
PURCHASELT_ID BIGINT
NOT NULL
³»ºÎ ÂüÁ¶ ¹øÈ£ ¹× 1Â÷ Ű
TERMCOND_ID BIGINT
NOT NULL
±ÔÁ¤ ID
TRADEPOSCN_ID BIGINT
NOT NULL
±¸ÀÔ ÇѰè´Â ÀÌ TradingPositionContainerÀÇ ºÎºÐÀÔ´Ï´Ù.

»öÀÎ:

»öÀÎ À̸§ »öÀÎµÈ ¿­ À̸§ »öÀÎ À¯Çü
I0000194 TERMCOND_ID, TRADEPOSCN_ID, CATENTRY_ID °íÀ¯ »öÀÎ
SQL020206020727940 PURCHASELT_ID 1Â÷ Ű

Á¦ÇÑ»çÇ×:

Á¦ÇÑÀÚ À̸§ ¿­ À̸§ Foreign Å×À̺í À̸§ Foreign ¿­ À̸§ Á¦ÇÑÀÚ À¯Çü
F_630 CATENTRY_ID CATENTRY CATENTRY_ID °è´Ü½Ä
F_631 TRADEPOSCN_ID TRADEPOSCN TRADEPOSCN_ID °è´Ü½Ä
F_632 TERMCOND_ID TERMCOND TERMCOND_ID °è´Ü½Ä


ÂüÁ¶:

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