ÀÌ Å×À̺íÀÇ ÇàÀº ¿äÀ² ã±â¸¦ ¼öÇàÇÏ¿© ÁÖ¾îÁø 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 | °è´Ü½Ä |