Å×ÀÌºí ¼³¸í:
ÁÖ¹® Ãâ°í¿¡ ´ëÇØ »ý¼ºµÈ °¢ ÀûÇÏ ¸ñ·Ï(¿î¼Û¹° È®ÀÎ)¸¶´Ù ÇϳªÀÇ ·¹Äڵ尡 ÀÖ½À´Ï´Ù. Ãâ°í°¡ µÎ »óÀÚ·Î ¹¾îÁø °æ¿ì ÀûÇÏ ¸ñ·Ï Å×ÀÌºí¿¡´Â µÎ ÇàÀÌ ÀÖ°Ô µË´Ï´Ù.
¿ ¼³¸í:
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
DATESHIPPED |
TIMESTAMP
NOT NULL |
ÆÐŰÁö°¡ ¿î¼ÛµÈ ³¯Â¥ |
FIELD1 |
VARCHAR (254)
NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É |
LASTUPDATE |
TIMESTAMP
NULL |
¸¶Áö¸·À¸·Î °»½ÅµÈ ½Ã°£¼ÒÀÎ |
MANIFEST_ID |
BIGINT
NOT NULL |
»ý¼ºµÈ °íÀ¯ Ű |
MANIFESTSTATUS |
CHARACTER (1)
NOT NULL, DEFAULT 'S' |
S=¿î¼ÛµÊ P=ÁöºÒµÊ V=¹«È¿. Ãʱ⠻óÅ = S. ÁöºÒÀÌ ½ÃÀÛµÉ ¶§ ÀÌ °ªÀº P·Î ¼³Á¤µÇ¾î ´Ù½Ã 󸮵ÇÁö ¾Êµµ·Ï ÇØ¾ß ÇÕ´Ï´Ù. |
ORDERS_ID |
BIGINT
NOT NULL |
ÀûÇÏ ¸ñ·ÏÀÌ ¼öÇàµÇ´Â ORDERS Å×À̺íÀÇ ORDERS_ID |
ORDRELEASENUM |
INTEGER
NOT NULL |
ÀÌ ÁÖ¹® Ãâ°í¸¦ °íÀ¯ÇÏ°Ô ½Äº°ÇÕ´Ï´Ù. |
PACKAGEID |
CHARACTER (20)
NULL |
ÆÐŰÁö ½Äº°ÀÚ |
PICKUPRECORDID |
CHARACTER (20)
NULL |
ÇȾ÷ ·¹ÄÚµå ½Äº°ÀÚ |
SETCCURR |
CHARACTER (3)
NULL |
¿î¼Û·á ºÎ°ú ÅëÈ |
SHIPMODE_ID |
INTEGER
NULL |
¿î¼Û ¾÷ü |
SHIPPINGCOSTS |
DECIMAL(20,5)
NOT NULL |
¿î¼Û ºñ¿ë |
TRACKINGID |
VARCHAR (40)
NULL |
½Äº°ÀÚ ÃßÀû |
WEIGHT |
DOUBLE
NULL |
ÆÐŰÁöÀÇ Áß·® |
WEIGHTMEASURE |
CHARACTER (16)
NULL |
ÆÐŰÁö Áß·® ÃøÁ¤ ´ÜÀ§ |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
SQL020206020652860 | MANIFEST_ID | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_425 | WEIGHTMEASURE | QTYUNIT | QTYUNIT_ID | °è´Ü½Ä |
F_426 | SETCCURR | SETCURR | SETCCURR | °è´Ü½Ä |
F_427 | SHIPMODE_ID | SHIPMODE | SHIPMODE_ID | °è´Ü½Ä |
F_428 | ORDERS_ID, ORDRELEASENUM | ORDRELEASE | ORDERS_ID, ORDRELEASENUM | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
![]() |