ORDER_CREATE_ITM010_DATA

ÁÖ¹® ÀÛ¼º ¸Þ½ÃÁö¿¡´Â 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 ÆÇ¸ÅÀÚ »ç¿ëÀÚ Á¤ÀÇ¿ëÀ¸·Î ¿¹¾à

°ü·Ã °³³ä

°ü·ÃµÈ ÂüÁ¶

IBM copyright