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

ÀÌ Å×À̺íÀÇ ÇàÀº ¿äÀ² ã±â¸¦ ¼öÇàÇÏ¿© ÁÖ¾îÁø OrderItems ¼¼Æ®¿¡ ´ëÇÑ ±Ý¾×À» °è»êÇÏ´Â µ¥ »ç¿ëµÉ ¼ö ÀÖ´Â CalculationScaleÀ» ³ªÅ¸³À´Ï´Ù.

¿­ À̸§ ¿­ À¯Çü ¿­ ¼³¸í
CALMETHOD_ID INTEGER
NOT NULL
OrderItems ¼¼Æ®°¡ ÁÖ¾îÁø CalculationScaleLookupMethod´Â CalculationScaleÀÌ ±Ý¾×À» °è»êÇϱâ À§ÇØ »ç¿ëÇÏ´Â "ã±â ¹øÈ£", "±âº» ±Ý¾×", "°á°ú ½Â¼ö" ¹× Á¤È®ÇÑ Áß·® ¼¼Æ®¸¦ °áÁ¤ÇÕ´Ï´Ù.
CALSCALE_ID INTEGER
NOT NULL
»ý¼ºµÈ °íÀ¯ ½Äº°ÀÚ.
CALUSAGE_ID INTEGER
NOT NULL
ÀÌ CalculationScaleÀÌ Àû¿ëµÇ´Â °è»ê Á¾·ù¸¦ ³ªÅ¸³À´Ï´Ù. ¿¹¸¦ µé¾î, CalculationScale´Â ÇÒÀÎ, ¿î¼Û ºñ¿ë, ÆÇ¸Å¼¼, ¿î¼Û¼¼¿Í °°Àº ±Ý¾× Áß Çϳª¸¦ °è»êÇÏ´Â µ¥ »ç¿ëµË´Ï´Ù.
CODE CHARACTER (30)
NULL
ÀÌ CalculationScaleÀ» °íÀ¯ÇÏ°Ô ½Äº°ÇÏ´Â ¹®ÀÚ¿­·Î ƯÁ¤ CalculationUsage ¹× StoreEntity°¡ ÁÖ¾îÁý´Ï´Ù.
DESCRIPTION VARCHAR (254)
NULL
ÀÌ CalculationScale¿¡ ´ëÇÑ °£·«ÇÑ ¼³¸íÀ¸·Î, CalculationRules ÀÛ¼ºÀÚ°¡ »ç¿ë °¡´ÉÇÑ CalculationScales ¸ñ·Ï¿¡¼­ ¼±ÅÃÇÒ ¼ö ÀÖµµ·Ï ÇØÁÖ´Â »ç¿ëÀÚ ÀÎÅÍÆäÀ̽º·Î Ç¥½ÃÇϱ⿡ ÀûÀýÇÕ´Ï´Ù.
FIELD1 VARCHAR (254)
NULL
»ç¿ëÀÚ Á¤ÀÇ °¡´É.
QTYUNIT_ID CHARACTER (16)
NULL
ÁöÁ¤µÉ °æ¿ì, ÀÌ CalculationScaleÀÇ CalculationRange ¿ÀºêÁ§Æ®¿¡ ´ëÇÑ rangeStart °ªÀÇ Æ¯Á¤ ´ÜÀ§. CalculationScaleLookupMethod´Â ÀÌ ´ÜÀ§·Î "ã±â ¹øÈ£"¸¦ ¸®ÅÏÇØ¾ß ÇÕ´Ï´Ù.
SETCCURR CHARACTER (3)
NULL
ÁöÁ¤µÉ °æ¿ì, ÀÌ CalculationScale¿¡ ´ëÇÑ CalculationRange ¿ÀºêÁ§Æ®ÀÇ rangeStart °ª¿¡ ´ëÇÑ ÅëÈ­. CalculationScaleLookupMethod´Â ÀÌ ÅëÈ­·Î "ã±â ¹øÈ£"¸¦ ¸®ÅÏÇØ¾ß ÇÕ´Ï´Ù. ÀÌ´Â ISO 4217 Ç¥ÁØ¿¡ µû¸¥ ÅëÈ­ ÄÚµåÀÔ´Ï´Ù.
STOREENT_ID INTEGER
NOT NULL
CalculationScaleÀº ÀÌ StoreEntityÀÇ ÀϺÎÀÔ´Ï´Ù.
»öÀÎ:
»öÀÎ À̸§ »öÀÎÈ­µÈ ¿­ À̸§ »öÀÎ À¯Çü
I0000059 CALUSAGE_ID, CODE, STOREENT_ID °íÀ¯ »öÀÎ
SQL030416034853210 CALSCALE_ID 1Â÷ Ű
Á¦ÇÑÁ¶°Ç:
Á¦ÇÑÁ¶°Ç ¿­ À̸§ ¿ÜºÎ Å×À̺í À̸§ ¿ÜºÎ ¿­ À̸§ ]Á¦ÇÑÁ¶°Ç À¯Çü
F_175 SETCCURR SETCURR SETCCURR °è´Ü½Ä
F_176 CALUSAGE_ID CALUSAGE CALUSAGE_ID °è´Ü½Ä
F_177 STOREENT_ID STOREENT STOREENT_ID °è´Ü½Ä
F_178 QTYUNIT_ID QTYUNIT QTYUNIT_ID °è´Ü½Ä
F_179 CALMETHOD_ID CALMETHOD CALMETHOD_ID °è´Ü½Ä

´ÙÀ½¿¡ ÀÇÇØ ÂüÁ¶:
Á¦ÇÑÁ¶°Ç ÂüÁ¶µÇ´Â ¿­ À̸§ ¿ÜºÎ Å×À̺í À̸§ ¿ÜºÎ ¿­ À̸§ ]Á¦ÇÑÁ¶°Ç À¯Çü
F_165 CALSCALE_ID CALRANGE CALSCALE_ID °è´Ü½Ä
F_181 CALSCALE_ID CALSCALEDS CALSCALE_ID °è´Ü½Ä
F_281 CALSCALE_ID CRULESCALE CALSCALE_ID °è´Ü½Ä