PriceTCCustomPriceList ¸ÊÇÎ(Business Edition)

TERMCOND
¿­ À̸§
¿­ À¯Çü ¿­ ¼³¸í
trading_id BigInt,
³Î(Null)°ªÀÌ ¾Æ´Ô
1Â÷ Ű. °Å·¡ °è¾à(TRADING) Å×ÀÌºí¿¡ ´ëÇÑ foreign key
termcond_id BigInt,
³Î(Null)°ªÀÌ ¾Æ´Ô
1Â÷ Ű ID.
tcSubType_id Char(64) ±ÔÁ¤ À¯Çü. TCSUBTYPE Å×ÀÌºí¿¡ ´ëÇÑ foreign key
¿­ °ªÀº PriceTCCustomPriceListÀ̾î¾ß ÇÕ´Ï´Ù.
mandatory Á¤¼ö,
±âº»°ª 0
0 - ¾Æ´Ï¿À
1 - ¿¹(Çù»ó Áß Âü°¡ÀÚ°¡ ÀÌ ±ÔÁ¤¿¡ ´ëÇØ ÀÀ´äÇØ¾ß ÇÕ´Ï´Ù.)
changeable Á¤¼ö,
±âº»°ª 0
0 - ¾Æ´Ï¿À
1 - ¿¹(Âü°¡ÀÚ°¡ ±ÔÁ¤À» º¯°æÇÒ ¼ö ÀÖ½À´Ï´Ù.)
timeCreated TimeStamp ÀÛ¼ºµÈ ½Ã°£
timeUpdated TimeStamp °»½ÅµÈ ½Ã°£
elementData LongVarChar,
±âº»°ª ³Î(Null)
 
StringField1 VarChar (3000)  
StringField2 VarChar (254)  
StringField3 VarChar (254)  
IntegerField1 Á¤¼ö productSetId. PRODUCTSET Å×ÀÌºí¿¡ ´ëÇÑ foreign key
IntegerField2 Á¤¼ö  
IntegerField3 Á¤¼ö  
FloatField1 Double  
FloatField2 Double  
FloatField3 Double  
BigIntField1 BigInt priceListId
BigIntField2 BigInt  
BigIntField3 BigInt  
DecimalField1 Decimal (20,5)  
DecimalField2 Decimal (20,5)  
DecimalField3 Decimal (20,5)  
TimeField1 TimeStamp  
TimeField2 TimeStamp  
TimeField3 TimeStamp  
IBM copyright