Å×ÀÌºí ¼³¸í:
ÀÌ Å×À̺íÀÇ °¢ ÇàÀº OrderItems ¼¼Æ®ÀÇ ±Ý¾×¿¡ µµ´ÞÇÏ´Â ¹æ¹ýÀ» Á¤ÀÇÇÏ´Â CalculationRuleÀ» ³ªÅ¸³À´Ï´Ù.
¿ ¼³¸í:
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
CALCODE_ID |
INTEGER
NOT NULL |
CalculationRuleÀÌ ÀϺÎÀÎ CalculationCode |
CALMETHOD_ID |
INTEGER
NOT NULL |
OrderItems ¼¼Æ®¿¡ ´ëÇÑ ±Ý¾× °á°ú¸¦ °è»êÇÏ´Â CalculationRuleCalculateMethod. |
CALMETHOD_ID_QFY |
INTEGER
NOT NULL |
CalculationRuleCalculateMethod·Î º¸³»¾ß ÇÏ´Â OrderItems ¼¼Æ®¸¦ °áÁ¤ÇÏ´Â CalculationRuleQualifyMethod. |
CALRULE_ID |
INTEGER
NOT NULL |
»ý¼ºµÈ °íÀ¯ ½Äº°ÀÚ. |
COMBINATION |
INTEGER
NOT NULL, DEFAULT 2 |
±âº» CalculationRuleCombineMethod¸¦ ±¸ÇöÇÏ¿© ¼öÇàµÉ Ưº° 󸮸¦ ³ªÅ¸³»´Â ºñÆ® Ç÷¡±×¸¦ ÁöÁ¤ÇÕ´Ï´Ù. Ãß°¡ Á¤º¸´Â CALRULE Å×À̺í: Á¤º¸¸¦ ÂüÁ¶ÇϽʽÿÀ. |
ENDDATE |
TIMESTAMP
NULL |
ÀÌ CalculationRule ÁßÁö°¡ Àû¿ëµÇ´Â ½Ã°£. |
FIELD1 |
DECIMAL(20,5)
NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É |
FIELD2 |
VARCHAR (254)
NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É |
FLAGS |
INTEGER
NOT NULL, DEFAULT 0 |
CalculationRuleCombineMethod´Â CalculationRuleÀ» ´Ù¸¥ CalculationRules¿¡ °áÇÕÇÏ´Â ¹æ¹ýÀ» °áÁ¤ÇÏ´Â µ¥ »ç¿ëµË´Ï´Ù. Ãß°¡ Á¤º¸´Â CALRULE Å×À̺í: Á¤º¸¸¦ ÂüÁ¶ÇϽʽÿÀ. |
IDENTIFIER |
INTEGER
NOT NULL, DEFAULT 1 |
ÀÌ CalculationRule¸¦ ÇØ´ç CalculationCode¿Í ÇÔ²² °íÀ¯ÇÏ°Ô ½Äº°ÇÕ´Ï´Ù. |
SEQUENCE |
DOUBLE
NOT NULL, DEFAULT 0 |
µ¿ÀÏÇÑ CalculationCode¿¡ ´ëÇÑ CalculationRulesÀº ³·Àº °ª¿¡¼ ³ôÀº °ªÀ¸·Î 󸮵˴ϴÙ. |
STARTDATE |
TIMESTAMP
NULL |
ÀÌ CalculationRuleÀÌ Àû¿ëµÇ´Â ½Ã°£. |
TAXCGRY_ID |
INTEGER
NULL |
TaxType CalculationUsagesÀÇ °æ¿ì, ÀÌ CalculationRuleÀÌ Àû¿ëµÇ´Â TaxCategory. |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
I0000058 | CALCODE_ID, IDENTIFIER | °íÀ¯ »öÀÎ |
SQL020206020557750 | CALRULE_ID | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_169 | CALCODE_ID | CALCODE | CALCODE_ID | °è´Ü½Ä |
F_170 | TAXCGRY_ID | TAXCGRY | TAXCGRY_ID | °è´Ü½Ä |
F_171 | CALMETHOD_ID_QFY | CALMETHOD | CALMETHOD_ID | °è´Ü½Ä |
F_172 | CALMETHOD_ID | CALMETHOD | CALMETHOD_ID | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_174 | CALRULE_ID | CALRULEMGP | CALRULE_ID | °è´Ü½Ä |
F_280 | CALRULE_ID | CRULESCALE | CALRULE_ID | °è´Ü½Ä |
F_751 | CALRULE_ID | SHPJCRULE | CALRULE_ID | °è´Ü½Ä |
F_820 | CALRULE_ID | TAXJCRULE | CALRULE_ID | °è´Ü½Ä |
![]() |