µ¥ÀÌÅͺ£À̽º Å×À̺í: 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¸¦ ±¸ÇöÇÏ¿© ¼öÇàµÉ Ưº° 󸮸¦ ³ªÅ¸³»´Â ºñÆ® Ç÷¡±×¸¦ ÁöÁ¤ÇÕ´Ï´Ù. Ãß°¡ Á¤º¸´Â 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 °è´Ü½Ä
IBM copyright