ÀÌ Å×À̺íÀÇ °¢ ÇàÀº TaxCategory¸¦ ³ªÅ¸³À´Ï´Ù.
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
---|---|---|
CALCULATIONSEQ | DOUBLE NOT NULL, DEFAULT 0 |
¼¼±ÝÀº CALCULATIONSEQÀÇ ¿À¸§Â÷¼øÀ¸·Î °è»êµË´Ï´Ù. |
DISPLAYSEQ | DOUBLE NOT NULL, DEFAULT 0 |
»ç¿ëÀÚ ÀÎÅÍÆäÀ̽º´Â ÀÌ Çʵ带 »ç¿ëÇÏ¿© ÁÖ¹®¿¡ Ç¥½ÃÇÒ ¼¼±ÝÀÇ ¼ø¼¸¦ Á¦¾îÇÒ ¼ö ÀÖ½À´Ï´Ù. |
DISPLAYUSAGE | INTEGER NOT NULL, DEFAULT 0 |
´ÙÀ½°ú °°ÀÌ PriceDataBean°ú °ü·ÃµÈ ÀÌ ¼¼±Ý Ä«Å×°í¸®¸¦ ÁöÁ¤ÇÕ´Ï´Ù. 0 = °è»êµÇÁö ¾ÊÀ½, 1 = °è»êµÊ. PriceDataBeanÀº »óǰ °¡°Ý°ú ÇÔ²² Ç¥½ÃµÇ¾î¾ß ÇÏ´Â ¼¼±ÝÀ» ±¸ÇÏ´Â µ¥ »ç¿ëµÉ ¼ö ÀÖ½À´Ï´Ù. |
FIELD1 | DECIMAL(20,5) NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É. |
FIELD2 | DECIMAL(20,5) NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É. |
FIELD3 | VARCHAR (254) NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É. |
MARKFORDELETE | INTEGER NOT NULL, DEFAULT 0 |
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à.. |
NAME | CHARACTER (15) NULL |
StoreEntity°ú ÇÔ²² ÀÌ TaxCategory¸¦ ½Äº°ÇÏ´Â À̸§. |
STOREENT_ID | INTEGER NOT NULL |
TaxCategory°¡ ÀϺÎÀÎ StoreEntity. |
TAXCGRY_ID | INTEGER NOT NULL |
»ý¼ºµÈ 1Â÷ Ű. |
TAXTYPE_ID | INTEGER NOT NULL |
ÀÌ ¼¼±ÝÄ«Å×°í¸®ÀÇ ¼¼±ÝÀ¯Çü. |
»öÀÎ À̸§ | »öÀÎÈµÈ ¿ À̸§ | »öÀÎ À¯Çü |
---|---|---|
I0000244 | NAME, STOREENT_ID | °íÀ¯ »öÀÎ |
SQL030416035124290 | TAXCGRY_ID | 1Â÷ Ű |
Á¦ÇÑÁ¶°Ç | ¿ À̸§ | ¿ÜºÎ Å×À̺í À̸§ | ¿ÜºÎ ¿ À̸§ | ]Á¦ÇÑÁ¶°Ç À¯Çü |
---|---|---|---|---|
F_816 | STOREENT_ID | STOREENT | STOREENT_ID | °è´Ü½Ä |
F_817 | TAXTYPE_ID | TAXTYPE | TAXTYPE_ID | °è´Ü½Ä |
Á¦ÇÑÁ¶°Ç | ÂüÁ¶µÇ´Â ¿ À̸§ | ¿ÜºÎ Å×À̺í À̸§ | ¿ÜºÎ ¿ À̸§ | ]Á¦ÇÑÁ¶°Ç À¯Çü |
---|---|---|---|---|
F_162 | TAXCGRY_ID | CALCODTXEX | TAXCGRY_ID | °è´Ü½Ä |
F_170 | TAXCGRY_ID | CALRULE | TAXCGRY_ID | °è´Ü½Ä |
F_489 | TAXCGRY_ID | ORDADJTXEX | TAXCGRY_ID | °è´Ü½Ä |
F_529 | TAXCGRY_ID | ORDITAX | TAXCGRY_ID | °è´Ü½Ä |
F_552 | TAXCGRY_ID | ORDTAX | TAXCGRY_ID | °è´Ü½Ä |
F_717 | TAXCGRY_ID | RMATAX | TAXCGRY_ID | °è´Ü½Ä |
F_815 | TAXCGRY_ID | SUBORDTAX | TAXCGRY_ID | °è´Ü½Ä |
F_818 | TAXCGRY_ID | TAXCGRYDS | TAXCGRY_ID | °è´Ü½Ä |