ÀÌ Å×À̺íÀÇ °¢ ÇàÀº 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 | °è´Ü½Ä |