Å×ÀÌºí ¼³¸í:
ÀÌ Å×À̺íÀÇ °¢ ÇàÀº ÁÖ¹®ÀÇ 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 | °è´Ü½Ä |
![]() |