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

ÀÌ Å×À̺íÀÇ °¢ ÇàÀº 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¸¦ ±¸ÇöÇÏ¿© ¼öÇàµÉ Ưº° 󸮸¦ ³ªÅ¸³»´Â ºñÆ® Ç÷¡±×¸¦ ÁöÁ¤ÇÕ´Ï´Ù. ´ÙÀ½°ú °°ÀÌ CalculationRuleÀ» ´Ù¸¥ CalculationRule¿¡ °áÇÕÇÏ´Â ¹æ¹ýÀ» °áÁ¤Çϱâ À§ÇÑ ±âº» CalculationRuleCombineMethod ±¸Çö¿¡¼­ »ç¿ëµË´Ï´Ù.
0 - ÀÓÀÇÀÇ ±ÔÄ¢¿¡ °áÇÕµÉ ¼ö ÀÖÀ½
1 = notInCombinationWith - "0" ±ÔÄ¢¿¡¸¸ °áÇÕµÉ ¼ö ÀÖÀ½.
2 = inCombinationWith - "1" ±ÔÄ¢¿¡ °áÇÕµÉ ¼ö ¾øÀ½.
ENDDATE TIMESTAMP
NULL
ÀÌ CalculationRule ÁßÁö°¡ Àû¿ëµÇ´Â ½Ã°£.
FIELD1 DECIMAL(20,5)
NULL
»ç¿ëÀÚ Á¤ÀÇ °¡´É.
FIELD2 VARCHAR (254)
NULL
»ç¿ëÀÚ Á¤ÀÇ °¡´É.
FLAGS INTEGER
NOT NULL, DEFAULT 0
CalculationRuleCombineMethod´Â CalculationRuleÀ» ´Ù¸¥ CalculationRules¿¡ °áÇÕÇÏ´Â ¹æ¹ýÀ» °áÁ¤ÇÏ´Â µ¥ »ç¿ëµË´Ï´Ù. ±âº» CalculationRuleCombineMethod¸¦ ±¸ÇöÇÏ¿© ¼öÇàÇÒ Æ¯º° 󸮸¦ ³ªÅ¸³»´Â 1 = restricted ºñÆ® Ç÷¡±×°¡ µé¾î ÀÖ½À´Ï´Ù. 1 = restricted - CalculationRuleÀ» ±ÔÁ¤ÇÏ·Á¸é ¸ÕÀú ƯÁ¤ Á¶°ÇÀÌ ¸¸Á·µÇ¾î¾ß ÇÕ´Ï´Ù. CalculationRuleÀÌ ±ÔÁ¤µÇ´ÂÁö ÆÇº°Çϱâ À§ÇØ CalculationRuleQualifyMethod¸¦ È£ÃâÇÕ´Ï´Ù. Ç÷¡±×°¡ 1ÀÌ ¾Æ´Ï¸é, CalculationRuleÀÌ Ç×»ó ±ÔÁ¤µË´Ï´Ù.
¿¹ 1:
ÇÒÀÎ CalculationRuleÀÇ °æ¿ì, °í°´Àº »óÁ¡¿¡¼­ °í°´ ±×·ìÀ¸·Î ÀνĵǴ ¿¬°üµÈ MemberGroup Áß Çϳª¿¡ ÀÖ¾î¾ß ÇÕ´Ï´Ù(CALRULEMGP ¹× STOREMBRGP ÂüÁ¶).
¿¹ 2:
¿î¼Û CalculationRuleÀÇ °æ¿ì, ¿î¼Û ÁÖ¼Ò, ¿î¼Û ¸ðµå ¹× ¼­ºñ½º ¼¾ÅͰ¡ ShippingJurisdictionGroupCalculationRule Áß Çϳª¿Í ÀÏÄ¡ÇØ¾ß ÇÕ´Ï´Ù(SHIPJCRULE ÂüÁ¶).
¿¹ 3:
¼¼±Ý CalculationRuleÀÇ °æ¿ì, ¿î¼Û ÁÖ¼Ò ¹× ¼­ºñ½º ¼¾ÅͰ¡ TaxJurisdictionGroupCalculationRule Áß Çϳª¿Í ÀÏÄ¡ÇØ¾ß ÇÕ´Ï´Ù(TAXJCRULE ÂüÁ¶).
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 °íÀ¯ »öÀÎ
SQL030416034852510 CALRULE_ID 1Â÷ Ű
Á¦ÇÑÁ¶°Ç:
Á¦ÇÑÁ¶°Ç À̸§ ¿­ À̸§ ¿ÜºÎ Å×À̺í À̸§ ¿ÜºÎ ¿­ À̸§ ]Á¦ÇÑÁ¶°Ç À¯Çü
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 °è´Ü½Ä

´ÙÀ½¿¡ ÀÇÇØ ÂüÁ¶:
Á¦ÇÑÁ¶°Ç À̸§ ÂüÁ¶µÇ´Â ¿­ À̸§ ¿ÜºÎ Å×À̺í À̸§ ¿ÜºÎ ¿­ À̸§ ]Á¦ÇÑÁ¶°Ç À¯Çü
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 °è´Ü½Ä