ÁÖ¹® ÀÛ¼º ¸Þ½ÃÁö¿¡´Â ORDER_CREATE_ITM010_DATA ¼¼±×¸ÕÆ®°¡ Æ÷ÇԵ˴ϴÙ. ÀÌ µ¥ÀÌÅÍ ¼¼±×¸ÕÆ®´Â ÁÖ¹® ÀÛ¼º ¸Þ½ÃÁö¿¡ ´ëÇØ Ç׸ñ ¶Ç´Â »óǰ ¿î¼Û ½ºÆåÀ¸·Î ±¸¼ºµË´Ï´Ù.
ORDER_CREATE_ITM010_DATA¿¡ ´ëÇÑ ÇÊµå ¼Ò½º ¹× Æ÷¸ËÀº ´ÙÀ½ Å×ÀÌºí¿¡ ¼³¸íµÇ¾î ÀÖ½À´Ï´Ù. ÇÊµå ±æÀÌ´Â ´ÙÀ½ Å×ÀÌºí¿¡ ³ª¿Í ÀÖ½À´Ï´Ù. µ¥ÀÌÅͺ£À̽º ¿¿¡ ´ëÇÑ ¼³¸íÀº ¿¬°üµÈ Å×ÀÌºí¿¡ ´ëÇÑ ¸µÅ©¸¦ µû¸£½Ê½Ã¿À.
Çʵå À̸§ | Çʵå À¯Çü | Å×À̺í À̸§ | ¿ À̸§ | ÁÖ |
---|---|---|---|---|
NC_ITM010 VersionNumber |
CHAR (2) | ¾øÀ½ | ¾øÀ½ | 01 °íÁ¤°ª. |
NC_Item LineNumber |
CHAR(3) | ¾øÀ½ | ¾øÀ½(¼øÂ÷ ¹øÈ£·Î »ý¼ºµÊ) | ¾øÀ½ |
NC_Item RefNumber |
CHAR (10) | ORDERITEMS | ORDERITEMS_ID | ³»ºÎÀûÀ¸·Î »ý¼ºµÈ °íÀ¯ ¿î¼Ûó ÂüÁ¶ ¹øÈ£. 1Â÷ ŰÀÔ´Ï´Ù. |
NC_Item ProductRefNumber |
CHAR (10) | ORDERITEMS | CATENTRY_ID | Ç׸ñ ¶Ç´Â »óǰ ÂüÁ¶ ¹øÈ£. foreign key°¡ ¾Æ´Õ´Ï´Ù. |
NC_Item ProductNumber |
CHAR (64) | CATENTRY | PARTNUMBER | Ç׸ñ SKU ¶Ç´Â »óǰ ¹øÈ£ |
NC_Item Product ShortDescription |
CHAR (254) | CATENTDESC | SHORTDESCRIPTION | À̸§À» Æ÷ÇÔÇÑ Ç׸ñ ¶Ç´Â »óǰ¿¡ ´ëÇÑ °£´ÜÇÑ ¼³¸í |
NC_Item UnitPrice |
CHAR (16) | ORDERITEMS | PRICE | Ç׸ñÀÇ ´Ü°¡ |
NC_Item CurrencyType |
CHAR (10) | ORDERITEMS | CURRENCY | °¡°Ý Ç¥½Ã ´ÜÀ§°¡ µÇ´Â ÅëÈ. ÅëÈ Æ÷¸ËÀº ISO 4217 Ç¥ÁØÀ» µû¶ó¾ß ÇÕ´Ï´Ù. |
NC_Item ProductQuantity |
CHAR (10) | ORDERITEMS | QUANTITY | ÁÖ¹®ÇÑ ¼ö·® |
NC_Item ShipToAddr RefNum |
CHAR (10) | ORDERITEMS | ADDRESS_ID | ¿î¼Û ÁÖ¼Ò¿¡ ´ëÇÑ ÁÖ¼Ò ÂüÁ¶ ¹øÈ£ |
NC_Item ShipMode RefNum |
CHAR (10) | ORDERITEMS | SHIPMODE_ID | ÆÇ¸ÅÀÚ ¿î¼Û ¹æ¹ý ÂüÁ¶ ¹øÈ£ |
NC_ItemState | CHAR(1) | ORDERITEMS | STATUS | ÁÖ¹® »óÅÂ: P - º¸·ù »óÅ C - ÀÌÀü »óÅ X - Ãë¼ÒµÊ I - Àç°í °»½Å º¸·ù(¿î¼Ûó´Â ´õ ÀÌ»ó º¸·ù »óŰ¡ ¾Æ´Ô) M - ÀÎÁõ Áغñ(¿î¼Ûó¿¡¼ Àç°í °»½ÅÀ» Àü´ÞÇÔ) |
NC_Item ShipTo LastName |
CHAR (30) | ADDRESS | LASTNAME | ¿î¼Û ¹ÞÀ» »ç¶÷ÀÇ ¼º |
NC_Item ShipTo MiddleName |
CHAR (30) | ADDRESS | MIDDLENAME | ¿î¼Û ¹ÞÀ» »ç¶÷ÀÇ Áß°£ À̸§ |
NC_Item ShipTo FirstName |
CHAR (30) | ADDRESS | FIRSTNAME | ¿î¼Û ¹ÞÀ» »ç¶÷ÀÇ À̸§ |
NC_Item ShipToAddr1 |
CHAR (50) | ADDRESS | ADDRESS1 | ¿î¼Û ¹ÞÀ» »ç¶÷ÀÇ ÁÖ¼Ò Çà 1 |
NC_Item ShipToAddr2 |
CHAR (50) | ADDRESS | ADDRESS2 | ¿î¼Û ¹ÞÀ» »ç¶÷ÀÇ ÁÖ¼Ò Çà 2 |
NC_Item ShipToAddr3 |
CHAR (50) | ADDRESS | ADDRESS3 | ¿î¼Û ¹ÞÀ» »ç¶÷ÀÇ ÁÖ¼Ò Çà 3 |
NC_Item ShipToCity |
CHAR (30) | ADDRESS | CITY | ¿î¼Û ¹ÞÀ» »ç¶÷ÀÇ ½Ã/±º/±¸ À̸§ |
NC_Item ShipToState |
CHAR (20) | ADDRESS | STATE | ¿î¼Û ¹ÞÀ» »ç¶÷ÀÌ °ÅÁÖÇÏ´Â ½Ã/µµ ¶Ç´Â ÀÌ¿¡ »óÀÀÇÏ´Â ¾àÀÚ |
NC_Item ShipToCountry |
CHAR (30) | ADDRESS | COUNTRY | ¿î¼Û ¹ÞÀ» »ç¶÷ÀÇ ±¹°¡/Áö¿ª |
NC_Item ShipToZipCode |
CHAR (20) | ADDRESS | ZIPCODE | ¿î¼Û ¹ÞÀ» »ç¶÷ÀÇ ¿ìÆí¹øÈ£ ¶Ç´Â ÀÌ¿¡ »óÀÀÇÏ´Â °Í |
NC_Item ShipToEmail1 |
CHAR (254) | ADDRESS | EMAIL1 | ¿î¼Û ¹ÞÀ» »ç¶÷ÀÇ 1Â÷ ÀüÀÚ ¿ìÆí ¶Ç´Â URL ÁÖ¼Ò |
NC_Item ShipToEmail2 |
CHAR (254) | ADDRESS | EMAIL2 | ¿î¼Û ¹ÞÀ» »ç¶÷ÀÇ 2Â÷ ÀüÀÚ ¿ìÆí ¶Ç´Â URL ÁÖ¼Ò |
NC_Item ShipToPhone1 |
CHAR (30) | ADDRESS | PHONE1 | ¿î¼Û ¹ÞÀ» »ç¶÷ÀÇ ÀüȹøÈ£ 1 |
NC_Item ShipToPhone2 |
CHAR (30) | ADDRESS | PHONE2 | ¿î¼Û ¹ÞÀ» »ç¶÷ÀÇ ÀüȹøÈ£ 2 |
NC_Item ShipToFax |
CHAR (30) | ADDRESS | FAX1 | ¿î¼Û ¹ÞÀ» »ç¶÷ÀÇ ÆÑ½º ¹øÈ£ |
NC_Item ShippingCarrier |
CHAR (30) | SHIPMODE | CARRIER | Federal Express¿Í °°Àº ¿î¼Ûȸ»ç ½Äº°ÀÚ |
NC_Item ShippingMethod |
CHAR (30) | SHIPMODE | CODE | FedEx Express Ư¼Û°ú °°Àº ¿î¼Ûȸ»ç ¼ºñ½º ¿î¼Û ¹æ¹ý |
NC_Item ShipToComment |
CHAR (254) | ORDERITEMS | COMMENTS | ¼±¹°¿¡ ´ëÇÑ Àλç¿Í °°Àº ±¸¸ÅÀڷκÎÅÍÀÇ ¸Þ½ÃÁö |
NC_Item Creation Timestamp |
CHAR (64) | ORDERITEMS | LASTCREATE | ¿î¼Ûó Ç׸ñÀÌ ÀÛ¼ºµÈ ³¯Â¥ ¹× ½Ã°£ |
NC_Item °»½Å Timestamp |
CHAR (64) | ORDERITEMS | LASTUPDATE | ¿î¼Ûó Ç׸ñÀÌ ¸¶Áö¸·À¸·Î °»½ÅµÈ ³¯Â¥ ¹× ½Ã°£ |
NC_Item CustField1 |
CHAR (10) | ORDERITEMS | FIELD1 | ÆÇ¸ÅÀÚ »ç¿ëÀÚ Á¤ÀÇ¿ëÀ¸·Î ¿¹¾à |
NC_Item CustField2 |
CHAR (254) | ORDERITEMS | FIELD2 | ÆÇ¸ÅÀÚ »ç¿ëÀÚ Á¤ÀÇ¿ëÀ¸·Î ¿¹¾à |
![]() |