µ¥ÀÌÅͺ£À̽º Å×À̺í: ORDERITEMS


Å×ÀÌºí ¼³¸í:

ÀÌ Å×À̺íÀÇ °¢ ÇàÀº ÁÖ¹®ÀÇ OrderItemÀ» ³ªÅ¸³À´Ï´Ù.

¿­ ¼³¸í:

¿­ À̸§ ¿­ À¯Çü ¿­ ¼³¸í
ADDRESS_ID BIGINT
NULL
ÀÖÀ» °æ¿ì, ÀÌ OrderItem¿¡ ´ëÇÑ ¿î¼Û ÁÖ¼Ò.
ALLOCADDRESS_ID BIGINT
NULL
ÀÌ OrderItem¿¡ ´ëÇÑ Àç°í°¡ ÇÒ´çµÇ°Å³ª ¹é¿À´õµÉ ¶§ »ç¿ëµÇ´Â ¿î¼Û ÁÖ¼Ò
ALLOCATIONGROUP BIGINT
NULL
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à
ALLOCFFMC_ID INTEGER
NULL
ÀÌ OrderItemÀÇ Àç°í°¡ ÇÒ´çµÇ°Å³ª ¹é¿À´õµÇ´Â ¼­ºñ½º ¼¾ÅÍ
ALLOCQUANTITY INTEGER
NOT NULL, DEFAULT 0
ÀÌ OrderItem¿¡ ´ëÇØ ÇÒ´çµÇ°Å³ª ¹é¿À´õµÈ ¼ö·®. BASEITEM.QUANTITYMEASURE ´ÜÀ§ÀÇ ¼ö·®Àº ITEMSPC_ID·Î ÁöÁ¤µÈ Ç׸ñÀÇ BaseItem¿¡ ´ëÇØ ÀÌ °ªÀ» BASEITEM.QUANTITYMULTIPLE·Î °öÇÏ¿© °è»êÇÒ ¼ö ÀÖ½À´Ï´Ù.
BASECURRENCY CHARACTER (3)
NULL
BASEPRICEÀÇ ÅëÈ­.
BASEPRICE DECIMAL(20,5)
NULL
PRICE°¡ OrderItem ÅëÈ­¿Í ´Ù¸¥ ÅëÈ­·ÎºÎÅÍ º¯È¯µÈ °æ¿ì, BASEPRICE´Â PRICE¿¡ µµ´ÞÇϱâ À§ÇØ º¯È¯µÈ °¡°ÝÀÔ´Ï´Ù.
CATENTRY_ID BIGINT
NULL
ÀÖÀ» °æ¿ì, ±¸ÀÔÇÏ´Â »óǰÀÇ CatalogEntry.
COMMENTS VARCHAR (254)
NULL
¼±¹°¿¡ ´ëÇÑ Àλç¿Í °°Àº °í°´À¸·ÎºÎÅÍÀÇ ¼³¸í.
CONFIGURATIONID VARCHAR (128)
NULL
¿ÜºÎ »óǰ ±¸¼ºÀÚ°¡ Á¦°øÇÑ ½Äº°ÀÚ. ÀÌ ½Äº°ÀÚ´Â OICOMPLIST Å×ÀÌºí¿¡ ÀúÀåµÈ ÁÖ¹® Ç׸ñ ±¸¼º¿ä¼ÒÀÇ ¸ñ·ÏÀ» ³ªÅ¸³À´Ï´Ù.
CORRELATIONGROUP BIGINT
NULL
ÀϹÝÀûÀ¸·Î ÀÌ ½Äº°ÀÚ´Â ORDERITEMS_ID¿Í °°Áö¸¸,AllocateInventory ŽºÅ© ¸í·É¿¡ ÀÇÇØ OrderItemÀÌ ³ª´©¾îÁ³À» °æ¿ì, »õ·Î ÀÛ¼ºµÈ OrderItemÀÌ ¿ø·¡ÀÇ OrderItemÀ¸·ÎºÎÅÍ CORRELATIONGROUP °ªÀ» »ó¼ÓÇÕ´Ï´Ù.
CURRENCY CHARACTER (10)
NULL
BASEPRICE°¡ ¾Æ´Ñ OrderItem ±Ý¾×ÀÇ ÅëÈ­. ÀÌ´Â Order(ORDER.CURRENCY)ÀÇ ÅëÈ­¿Í µ¿ÀÏÇÕ´Ï´Ù. ISO 4217 Ç¥ÁØ¿¡ ¸Â´Â ÅëÈ­ ÄÚµå.
DESCRIPTION VARCHAR (254)
NULL
OrderItem¿¡ ´ëÇÑ ±â¾ïÇϱâ ÁÁÀº ¼³¸íÀ¸·Î °í°´¿¡°Ô Ç¥½ÃÇÏ´Â µ¥ Àû´çÇÕ´Ï´Ù. ÀÌ·± °æ¿ì¿¡´Â CatalogEntry ¼³¸íÀÌ Ç¥½ÃµÇ±â ¶§¹®¿¡, ÀÌ Çʵå´Â ÀϹÝÀûÀ¸·Î CATENTRY_ID°¡ ³Î(Null)°ªÀÌ¸é ³Î(Null)°ªÀÔ´Ï´Ù.
ESTAVAILTIME TIMESTAMP
NULL
ÀÌ OrderItemÀ» ÃæÁ·ÇÒ ¸¸Å­ ÃæºÐÇÑ Àç°í°¡ ÀÖÀ» ¶§¿¡ ´ëÇÑ ÃßÁ¤Ä¡. ÀÌ ÃßÁ¤Ä¡¿¡´Â ¿î¼Û ¿É¼ÂÀº Æ÷ÇÔµÇÁö ¾Ê½À´Ï´Ù.
FFMCENTER_ID INTEGER
NULL
¾Ë·ÁÁ® ÀÖ´Â °æ¿ì, »óǰÀÌ ¿î¼ÛµÉ FulfillmentCenter.
FIELD1 INTEGER
NULL
»ç¿ëÀÚ Á¤ÀÇ °¡´É
FIELD2 VARCHAR (254)
NULL
»ç¿ëÀÚ Á¤ÀÇ °¡´É
FULFILLMENTSTATUS CHARACTER (4)
NOT NULL, DEFAULT 'INT'
OrderItemÀÇ ¼­ºñ½º ¼¾ÅÍ »óÅÂ.
INT = ¾ÆÁ÷ ¼­ºñ½º ¼¾ÅÍ¿¡ Ãâ°íµÇÁö ¾ÊÀ½
OUT = ¼­ºñ½º ¼¾ÅÍ¿¡ Ãâ°íµÊ
SHIP = ¿î¼Û È®ÀÎ
INVENTORYSTATUS CHARACTER (4)
NOT NULL, DEFAULT 'NALC'
ÀÌ OrderItemÀÇ Àç°í ÇÒ´ç »óÅÂ.
NALC = Àç°í°¡ ÇÒ´çµÇÁöµµ ¹é¿À´õµÇÁöµµ ¾ÊÀ½
BO = Àç°í°¡ ¹é¿À´õµÊ
ALLC = Àç°í°¡ ÇÒ´çµÊ
FUL = Àç°í°¡ ¼­ºñ½º ¼¾ÅÍ¿¡ Ãâ°íµÊ
ITEMSPC_ID BIGINT
NULL
»ç¿ë °¡´É Àç°í·ÎºÎÅÍ ÇÒ´çµÇ¾î °í°´¿¡°Ô ¿î¼ÛµÉ ÁöÁ¤µÈ Ç׸ñ
LASTALLOCUPDATE TIMESTAMP
NULL
ÀÌ OrderItem¿¡ ´ëÇØ Àç°í°¡ È®ÀÎ(¹ÌÇÒ´ç OrderItem), ÇÒ´ç ¶Ç´Â ¹é¿À´õµÈ °¡Àå ÃÖ±Ù ½Ã°£
LASTCREATE TIMESTAMP
NULL
ÀÌ OrderItemÀÌ ÀÛ¼ºµÈ ½Ã°£.
LASTUPDATE TIMESTAMP
NULL
¹ÌÁö¸·À¸·Î ÀÌ OrderItemÀÌ °»½ÅµÈ ½Ã°£. Àç°í °ü·Ã Á¤º¸¸¦ º¯°æÇصµ ÀÌ ½Ã°£¼ÒÀÎÀº °»½ÅµÇÁö ¾Ê½À´Ï´Ù(LASTALLOCUPDATE ¿­ ÂüÁ¶).
LINEITEMTYPE CHARACTER (4)
NULL
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à
MEMBER_ID BIGINT
NOT NULL
OrderItemÀÇ °í°´(ÁÖ¹®ÀÇ °í°´°ú µ¿ÀÏÇÔ)
NEEDEDQUANTITY INTEGER
NOT NULL, DEFAULT 0
¼­ºñ½º ¼¾ÅÍ¿¡¼­ Çʼö ¼ö·®. CATENTRY°¡ ³Î(Null)°ªÀÎ °æ¿ì CATENTSHIP.QUANTITYMEASURE¿¡¼­ BASEITEM.QUANTITYMEASURE·Î º¯È¯ÇÑ CATENTSHIP.NOMINALQUANTITY¸¦ BASEITEM.QUANTITYMULTIPLE·Î QUANTITYȸ ³ª´©¾î ±ÙÁ¢ÇÑ Á¤¼ö·Î ¹Ý¿Ã¸²ÇÑ °ªÀÔ´Ï´Ù.
OFFER_ID BIGINT
NULL
ÀÖÀ» °æ¿ì ¹× ¾ÆÁ÷ Á¸ÀçÇÒ °æ¿ì, PRICE¸¦ È®º¸ÇÑ ÆÇ¸Å ¼³Á¤.
ORDERITEMS_ID BIGINT
NOT NULL
»ý¼ºµÈ °íÀ¯ Ű
ORDERS_ID BIGINT
NOT NULL
ÀÌ OrderItemÀÌ ÀϺκÐÀÎ ÁÖ¹®.
ORDRELEASENUM INTEGER
NULL
°ü·Ã OrderRelease(ÀÖ´Â °æ¿ì)
OUTPUTQ_ID BIGINT
NULL
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à
PARTNUM VARCHAR (64)
NULL
»óǰÀÇ CatalogEntry(CATENTRY.PARTNUMBER)¿¡ ´ëÇÑ ºÎǰ ¹øÈ£.
PREPAREFLAGS INTEGER
NOT NULL, DEFAULT 0
OrderPrepare ¸í·É¿¡ ÀÇÇØ ¼öÇàµÉ Ư¼ö 󸮸¦ ³ªÅ¸³»´Â ºñÆ® Ç÷¡±×°¡ µé¾î ÀÖ½À´Ï´Ù. Ãß°¡ Á¤º¸´Â ORDERITEMS Å×À̺í: Á¤º¸¸¦ ÂüÁ¶ÇϽʽÿÀ.
PRICE DECIMAL(20,5)
NULL
»óǰÀÇ ¸í¸ñ»ó ¼ö·®¿¡ ´ëÇÑ °¡°Ý(CATENTSHIP.NOMINALQUANTITY).
PROMISEDAVAILTIME TIMESTAMP
NULL
ÁÖ¹®ÀÌ Á¦ÃâµÇ¸é(OrderProcess ¸í·ÉÀ» »ç¿ëÇÏ¿©), EstAvailTimeÀ¸·Î ¼³Á¤µË´Ï´Ù. CSR°¡ °í°´¿¡°Ô ÇÑ ±¸µÎ È®¾àÀ» ¹Ý¿µÇÏ¿© À̸¦ ¼öµ¿À¸·Î °»½ÅÇÒ ¼ö ÀÖ´õ¶óµµ ÀϹÝÀûÀ¸·Î Á¦ÃâµÇ°í ³ª¸é °»½ÅµÇÁö ¾Ê½À´Ï´Ù.
QUANTITY DOUBLE
NOT NULL
QUANTITY¿¡ CATENTSHIP.NOMINALQUANTITY¸¦ °öÇÑ °á°ú´Â CATENTSHIP.QUANTITYMULTIPLEÀÇ ¹è¼öÀ̾î¾ß Çϸç, CATENTSHIP.QUANTITYMEASURE¿¡ ÁöÁ¤µÈ ´ÜÀ§·Î ½ÇÁ¦ ÆÇ¸ÅµÇ´Â ¼ö·®À» ³ªÅ¸³À´Ï´Ù.
SHIPCHARGE DECIMAL(20,5)
NULL
CURRENCY¿¡ ÁöÁ¤µÈ ÅëÈ­·Î ÀÌ OrderItem¿¡ ¿¬°üµÈ ¿î¼Û °æºñ.
SHIPMODE_ID INTEGER
NULL
¾Ë·ÁÁ® ÀÖ´Â °æ¿ì, ShippingMode.
SHIPPINGOFFSET INTEGER
NOT NULL, DEFAULT 0
ÁÖ¹®ÀÌ Á¦ÃâµÇ°í Àç°í°¡ ÇÒ´çµÈ ÈÄ ÀÌ Ç׸ñÀ» ¿î¼ÛÇÏ´Â µ¥ °É¸®´Â ¿¹»ó ÃÊ ¼ö
SHIPTAXAMOUNT DECIMAL(20,5)
NULL
CURRENCY¿¡ ÁöÁ¤µÈ ÅëÈ­·Î ÀÌ OrderItem¿¡ ¿¬°üµÈ ÃÑ ¿î¼Û¼¼.
STATUS CHARACTER (1)
NOT NULL
ÁÖ¹®ÀÇ ¸ðµç OrderItemÀº ÁÖ¹® »óÅ »çº»À» º¸À¯ÇÕ´Ï´Ù. ORDERS Å×À̺íÀÇ STATUS ¿­ ¼³¸íÀ» ÂüÁ¶ÇϽʽÿÀ.
STOREENT_ID INTEGER
NOT NULL
ÁÖ¹®ÀÌ ÀϺκÐÀÎ StoreEntity(ÀÌ OrderItemÀÌ ÀϺκÐÀÓ). STATUS°¡ Q°¡ ¾Æ´Ò °æ¿ì ÀϹÝÀûÀ¸·Î StoreÀÔ´Ï´Ù(QÀ̸é StoreGroupÀÔ´Ï´Ù).
TAXAMOUNT DECIMAL(20,5)
NULL
CURRENCY¿¡ ÁöÁ¤µÈ ÅëÈ­·Î ÀÌ OrderItem¿¡ ¿¬°üµÈ ÃÑ ¸ÅÃâ¾× ¼¼±Ý.
TERMCOND_ID BIGINT
NULL
ÁÖ¹® Ç׸ñÀÇ °¡°ÝÀ» °áÁ¤ÇÑ TermAndCondition(¾Ë·ÁÁø °æ¿ì).
TIMERELEASED TIMESTAMP
NULL
ÀÌ OrderItemÀÌ ¼­ºñ½º ¼¾ÅÍ¿¡ Ãâ°íµÈ ½Ã°£
TIMESHIPPED TIMESTAMP
NULL
ÀÌ OrderItemÀÌ ¿î¼ÛÀ» À§ÇØ ÀûÇÏ ¸ñ·Ï¿¡ ÀÛ¼ºµÈ ½Ã°£
TOTALADJUSTMENT DECIMAL(20,5)
NULL, DEFAULT 0
CURRENCY¿¡ ÁöÁ¤µÈ ÅëÈ­·Î ÀÌ OrderItem¿¡ ´ëÇÑ ÃÑ OrderItemAdjustments ±Ý¾×.
TOTALPRODUCT DECIMAL(20,5)
NULL, DEFAULT 0
PRICE x QUANTITY.
TRACKDATE TIMESTAMP
NULL
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à
TRACKNUMBER VARCHAR (64)
NULL
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à
TRADING_ID BIGINT
NULL
ÀÌ OederItem¿¡ Àû¿ëµÇ´Â °¡°Ý(°¡°Ý ÆÇº° ¹æ½Ä Æ÷ÇÔ)À» °áÁ¤ÇÏ´Â TermAndCondition ¿ÀºêÁ§Æ®¸¦ °áÁ¤ÇÏ´Â TradingAgreement(¾Ë·ÁÁø °æ¿ì)

»öÀÎ:

»öÀÎ À̸§ »öÀÎµÈ ¿­ À̸§ »öÀÎ À¯Çü
I0000173 ORDERITEMS_ID, TIMERELEASED, TIMESHIPPED, INVENTORYSTATUS °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ
I172145 ORDERS_ID, ORDRELEASENUM, STOREENT_ID, FFMCENTER_ID °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ
SQL020206020706200 ORDERITEMS_ID 1Â÷ Ű

Á¦ÇÑ»çÇ×:

Á¦ÇÑÀÚ À̸§ ¿­ À̸§ Foreign Å×À̺í À̸§ Foreign ¿­ À̸§ Á¦ÇÑÀÚ À¯Çü
F_496 ORDERS_ID ORDERS ORDERS_ID °è´Ü½Ä
F_497 TERMCOND_ID TERMCOND TERMCOND_ID °è´Ü½Ä
F_498 TRADING_ID TRADING TRADING_ID °è´Ü½Ä
F_499 ALLOCADDRESS_ID ADDRESS ADDRESS_ID °è´Ü½Ä
F_500 ALLOCFFMC_ID FFMCENTER FFMCENTER_ID °è´Ü½Ä
F_501 OUTPUTQ_ID OUTPUTQ OUTPUTQ_ID °è´Ü½Ä
F_502 ITEMSPC_ID ITEMSPC ITEMSPC_ID °è´Ü½Ä
F_503 ADDRESS_ID ADDRESS ADDRESS_ID °è´Ü½Ä
F_504 MEMBER_ID MEMBER MEMBER_ID °è´Ü½Ä
F_505 CATENTRY_ID CATENTRY CATENTRY_ID °è´Ü½Ä
F_506 OFFER_ID OFFER OFFER_ID °è´Ü½Ä
F_507 STOREENT_ID STOREENT STOREENT_ID °è´Ü½Ä
F_508 FFMCENTER_ID FFMCENTER FFMCENTER_ID °è´Ü½Ä
F_509 SHIPMODE_ID SHIPMODE SHIPMODE_ID °è´Ü½Ä
SQL020206021149990 ORDERS_ID, ORDRELEASENUM ORDRELEASE ORDERS_ID, ORDRELEASENUM °è´Ü½Ä


ÂüÁ¶:

Á¦ÇÑÀÚ À̸§ ÂüÁ¶µÈ ¿­ À̸§ Foreign Å×À̺í À̸§ Foreign ¿­ À̸§ Á¦ÇÑÀÚ À¯Çü
F_125 ORDERITEMS_ID BKORDALLOC ORDERITEMS_ID °è´Ü½Ä
F_126 ORDERITEMS_ID BKORDITEM ORDERITEMS_ID °è´Ü½Ä
F_261 ORDERITEMS_ID CPITMAP ORDERITEMS_ID °è´Ü½Ä
F_476 ORDERITEMS_ID OICOMPLIST ORDERITEMS_ID °è´Ü½Ä
F_520 ORDERITEMS_ID ORDIADJUST ORDERITEMS_ID °è´Ü½Ä
F_523 ORDERITEMS_ID ORDICALCD ORDERITEMS_ID °è´Ü½Ä
F_524 ORDERITEMS_ID ORDIMEEXTN ORDERITEMS_ID °è´Ü½Ä
F_526 ORDERITEMS_ID ORDIOFFER ORDERITEMS_ID °è´Ü½Ä
F_527 ORDERITEMS_ID ORDIPROF ORDERITEMS_ID °è´Ü½Ä
F_528 ORDERITEMS_ID ORDITAX ORDERITEMS_ID °è´Ü½Ä
F_531 ORDERITEMS_ID ORDITRD ORDERITEMS_ID °è´Ü½Ä
F_545 ORDERITEMS_ID ORDPICKHST ORDERITEMS_ID °è´Ü½Ä
F_549 ORDERITEMS_ID ORDSHIPHST ORDERITEMS_ID °è´Ü½Ä
F_654 ORDERITEMS_ID RABACKALLO ORDERITEMS_ID °è´Ü½Ä
F_710 ORDERITEMS_ID RMAITEM ORDERITEMS_ID °è´Ü½Ä
F_827 ORDERITEMS_ID TCPITMAP ORDERITEMS_ID °è´Ü½Ä
F_870 ORDERITEMS_ID TRDDEPAMT ORDERITEMS_ID °è´Ü½Ä
F_876 ORDERITEMS_ID TRDPURAMT ORDERITEMS_ID °è´Ü½Ä
IBM copyright