Å×ÀÌºí ¼³¸í:
ÀÌ Å×À̺íÀÇ °¢ ÇàÀº OrderAdjustment¸¦ ³ªÅ¸³À´Ï´Ù.
¿ ¼³¸í:
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
AMOUNT |
DECIMAL(20,5)
NULL, DEFAULT 0 |
ÁÖ¹® ÅëÈ(ORDERS.CURRENCY)·Î µÈ OrderAdjustment ±Ý¾×. ÀÌ´Â °ü·ÃµÈ OrderItemAdjustmentsÀÇ ÇÕÀÔ´Ï´Ù. |
CALCODE_ID |
INTEGER
NULL |
ÀÖÀ» °æ¿ì ¹× ¾ÆÁ÷ Á¸ÀçÇÒ °æ¿ì, OrderAdjustment¸¦ ÀÛ¼ºÇÏ´Â µ¥ »ç¿ëµÈ CalculationCode. |
CALUSAGE_ID |
INTEGER
NULL |
ÀÖÀ» °æ¿ì ¹× ¾ÆÁ÷ Á¸ÀçÇÒ °æ¿ì, OrderAdjustment¸¦ ÀÛ¼ºÇÏ´Â µ¥ »ç¿ëµÈ CalculationCodeÀÇ CalculationUsage. |
DISPLAYLEVEL |
INTEGER
NOT NULL, DEFAULT 0 |
ÀÌ OrderAdjustmentÀÇ °ªÀº ´ÙÀ½ °¢ Ç׸ñ°ú ÇÔ²² Ç¥½ÃµË´Ï´Ù. 0 = ÁÖ¹® Ç׸ñ 1 = ÁÖ¹® 2 = »óǰ 3 = Ç׸ñ 4 = Àå±â ±¸¸Å °è¾à ÀÌ °ªÀº ÁÖ·Î CALCODE.DISPLAYLEVEL¿¡¼ º¹»çµË´Ï´Ù. |
ORDADJUST_ID |
BIGINT
NOT NULL |
»ý¼ºµÈ °íÀ¯ Ű |
ORDERS_ID |
BIGINT
NOT NULL |
OrderAdjustment°¡ ÀϺκÐÀÎ ÁÖ¹®. |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
I0000171 | ORDERS_ID | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
SQL020206020704750 | ORDADJUST_ID | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_490 | ORDERS_ID | ORDERS | ORDERS_ID | °è´Ü½Ä |
F_491 | CALCODE_ID | CALCODE | CALCODE_ID | °è´Ü½Ä |
F_492 | CALUSAGE_ID | CALUSAGE | CALUSAGE_ID | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_486 | ORDADJUST_ID | ORDADJDSC | ORDADJUST_ID | °è´Ü½Ä |
F_488 | ORDADJUST_ID | ORDADJTXEX | ORDADJUST_ID | °è´Ü½Ä |
F_521 | ORDADJUST_ID | ORDIADJUST | ORDADJUST_ID | °è´Ü½Ä |
F_704 | ORDADJUST_ID | RMAIADJCRD | ORDADJUST_ID | °è´Ü½Ä |
F_810 | ORDADJUST_ID | SUBORDADJ | ORDADJUST_ID | °è´Ü½Ä |
![]() |