ÀÌ Å×À̺íÀÇ °¢ ÇàÀº ÁÖ¹®ÀÇ 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·Î °öÇÏ¿© °è»êÇÒ ¼ö ÀÖ½À´Ï´Ù. |
AVAILQUANTITY | INTEGER NULL |
ÁöÁ¤µÈ °æ¿ì, ±¸¸ÅÇÒ ¼ö ÀÖ´Â ¼ö·®À» ³ªÅ¸³À´Ï´Ù. |
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¿Í °°½À´Ï´Ù. 1. AllocateInventory ŽºÅ© ¸í·É¿¡ ÀÇÇØ OrderItemÀÌ ³ª´©¾îÁ³À» °æ¿ì, »õ·Î ÀÛ¼ºµÈ OrderItemÀÌ ¿ø·¡ÀÇ OrderItemÀ¸·ÎºÎÅÍ CORRELATIONGROUP °ªÀ» »ó¼ÓÇÕ´Ï´Ù. 2. PREPAREFLAGS ¿ÀÌ "°ßÀû"À» ³ªÅ¸³»¸é, 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 |
ÁöÁ¤µÈ °æ¿ì, OrderItemÀÇ À¯ÇüÀ» ³ªÅ¸³À´Ï´Ù. ALT = ÁÖ¹® Ç׸ñÀÌ ´ëü Ç׸ñÀ» ³ªÅ¸³À´Ï´Ù.(Á¤È®ÇÏ°Ô °í°´ÀÌ ¿äûÇÑ °ÍÀÌ ¾Æ´Ò ¼ö ÀÖ½À´Ï´Ù.) |
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 ¸í·É¿¡ ÀÇÇØ ¼öÇàµÉ Ư¼ö 󸮸¦ ³ªÅ¸³»´Â ´ÙÀ½°ú °°Àº ºñÆ® Ç÷¡±×¸¦ Æ÷ÇÔÇÕ´Ï´Ù. 1 - generated - ÀÌÀü OrderPrepare ¸í·É ½ÇÇà Áß¿¡ OrderItemÀÌ »ý¼ºµÇ¾ú½À´Ï´Ù. ´ÙÀ½ ¹ø¿¡ OrderPrepare ¸í·ÉÀÌ ½ÇÇàµÇ¸é, ¸ÕÀú »ý¼ºµÈ ¸ðµç OrderItemsÀ» Á¦°ÅÇÏ¿© Àû¿ë °¡´ÉÇÑ °æ¿ì Àç»ý¼ºÇÒ ¼ö ÀÖ°Ô ÇÕ´Ï´Ù. 2 = priceOverride - OrderItemÀÇ °¡°ÝÀ» Á÷Á¢ ÀÔ·ÂÇÏ¿´À¸¹Ç·Î, °í°´ ¸í·ÉÀ¸·Î º¯°æµÇÁö ¾Ê½À´Ï´Ù. 4 = fulfillmentCenterOverride - FulfillmentCenter¸¦ Á÷Á¢ ÁöÁ¤ÇßÀ¸¹Ç·Î, °í°´ ¸í·ÉÀ¸·Î º¯°æµÇÁö ¾Ê½À´Ï´Ù. 8 - directCalculationCodeAttachment - CalculationCode´Â Á÷Á¢ OrderItem¿¡ ÷ºÎµÉ ¼ö ÀÖ½À´Ï´Ù. ÀÌ Ç÷¡±×°¡ true°¡ ¾Æ´Ï¸é, ±âº» CalculationCodeCombineMethod´Â Á÷Á¢ Á¢¼ÓÀ» ãÁö ¾Ê½À´Ï´Ù. 16 = shippingChargeByCarrier - ÀÌ OrderItemÀÇ Àå±â ±¸¸Å °è¾àÀº WebSphere Commerce¿¡¼ ¿î¼Û ºñ¿ëÀÌ °è»êµÇÁö ¾ÊÀ½À» ³ªÅ¸³À´Ï´Ù. ¼ºñ½º ¼¾ÅÍÀÇ ¿î¼Û ȸ»ç¿¡¼ °è»êÇÏ°í ºñ¿ëÀ» ºÎ°úÇÒ ¼ö ÀÖ½À´Ï´Ù. 32 = quotation - °ßÀû¿¡¼ OrderItemÀ» °¡Á®¿Ô½À´Ï´Ù. °í°´ ¸í·É¿¡ ÀÇÇØ °¡°ÝÀÌ ÀÚµ¿À¸·Î °»½ÅµÇÁö ¾Ê½À´Ï´Ù. 64 = notConfigured - ÀÌ OrderItem¿¡ ´ëÇÑ °¡°Ý ã¾Æº¸±â¿Í Àç°í ÇÒ´çÀÌ ÀÌ OrderItemÀÇ OICOMPLIST Å×ÀÌºí¿¡ ÀÖ´Â ±¸¼º¿ä¼Ò Ç׸ñÀ» »ç¿ëÇÏ¿© ¼öÇàµÇ¾î¼´Â ¾È µË´Ï´Ù. ÀÌÀü ¹öÀü°úÀÇ È£È¯¼ºÀ» À§ÇØ ÀÌ Ç÷¡±×´Â configurationId ¿ °ªÀÌ ³Î(null)ÀÎ OrderItem¿¡ ´ëÇØ¼´Â ¼³Á¤µÇÁö ¾Ê¾Æµµ µË´Ï´Ù. 128 = autoAdd - OrderItemÀÌ Ãß°¡µË´Ï´Ù. |
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ÀÔ´Ï´Ù). |
SUPPLIERDATA | VARCHAR (254) NULL |
WebSphere Commerce¿¡ ºÐ¸íÇÏÁö ¾Ê½À´Ï´Ù. ÀÌ ¼Ó¼ºÀº °ßÀû°ú ÇÔ²² ¸®Å쵃 ¼ö ÀÖ°í, ¿ÜºÎ ½Ã½ºÅÛ¿¡ ÁÖ¹®ÀÌ Á¦ÃâµÉ ¶§ º¸³»Áý´Ï´Ù. ¿¹¸¦ µé¸é, °ø±ÞÀÚ ºÐ¹è ¼¾ÅÍ ID°¡ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù. |
SUPPLIERPARTNUMBER | VARCHAR (254) NULL |
¾Ë·ÁÁø °æ¿ì, °ø±ÞÀÚ ºÎǰ ¹øÈ£. °í°´¿¡°Ô Ç¥½ÃÇÏ´Â µ¥ Àû´çÇÕ´Ï´Ù. |
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 | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
I172138 | ORDERS_ID, ORDRELEASENUM, STOREENT_ID, FFMCENTER_ID | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
SQL030416035017290 | ORDERITEMS_ID | 1Â÷ Ű |
Á¦ÇÑÁ¶°Ç | ¿ À̸§ | ¿ÜºÎ Å×À̺í À̸§ | ¿ÜºÎ ¿ À̸§ | ]Á¦ÇÑÁ¶°Ç À¯Çü |
---|---|---|---|---|
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 | °è´Ü½Ä |
Á¦ÇÑÁ¶°Ç | ÂüÁ¶µÇ´Â ¿ À̸§ | ¿ÜºÎ Å×À̺í À̸§ | ¿ÜºÎ ¿ À̸§ | ]Á¦ÇÑÁ¶°Ç À¯Çü |
---|---|---|---|---|
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 | °è´Ü½Ä |
F_941 | ORDERITEMS_ID | ORDISTAT | ORDERITMES_ID | °è´Ü½Ä |
F_987 | ORDERITEMS_ID | PATTRVALUE | ORDERITEMS_ID | °è´Ü½Ä |
PREPAREFLAGS ¿
OrderItem°ú ¿¬°üµÈ Ư¼ö 󸮸¦ ³ªÅ¸³»´Â ´ÙÀ½°ú °°Àº ºñÆ® Ç÷¡±×°¡ µé¾î ÀÖ½À´Ï´Ù.
- 1
- generated
ÀÌÀü OrderPrepare ¸í·É ½ÇÇà Áß¿¡ OrderItemÀÌ »ý¼ºµÇ¾ú½À´Ï´Ù. ´ÙÀ½ ¹ø¿¡ OrderPrepare ¸í·ÉÀÌ ½ÇÇàµÇ¸é, ¸ÕÀú »ý¼ºµÈ ¸ðµç OrderItemsÀ» Á¦°ÅÇÏ¿© Àû¿ë °¡´ÉÇÑ °æ¿ì Àç»ý¼ºÇÒ ¼ö ÀÖ°Ô ÇÕ´Ï´Ù.
- 2
- priceOverride
OrderItemÀÇ °¡°ÝÀ» Á÷Á¢ ÀÔ·ÂÇÏ¿´À¸¹Ç·Î, °í°´ ¸í·ÉÀ¸·Î º¯°æµÇÁö ¾Ê½À´Ï´Ù.
- 4
- fulfillmentCenterOverride
FulfillmentCenter¸¦ Á÷Á¢ ÁöÁ¤ÇßÀ¸¹Ç·Î, °í°´ ¸í·ÉÀ¸·Î º¯°æµÇÁö ¾Ê½À´Ï´Ù.
- 8
- directCalculationCodeAttachment
CalculationCode´Â Á÷Á¢ OrderItem¿¡ ÷ºÎµÉ ¼ö ÀÖ½À´Ï´Ù. ÀÌ Ç÷¡±×°¡ true°¡ ¾Æ´Ï¸é, ±âº» CalculationCodeCombineMethod´Â Á÷Á¢ Á¢¼ÓÀ» ãÁö ¾Ê½À´Ï´Ù.
- 16
- shippingChargeByCarrier
ÀÌ OrderItemÀÇ Àå±â ±¸¸Å °è¾àÀº WebSphere Commerce¿¡¼ ¿î¼Û ºñ¿ëÀÌ °è»êµÇÁö ¾ÊÀ½À» ³ªÅ¸³À´Ï´Ù. ¼ºñ½º ¼¾ÅÍÀÇ ¿î¼Û ȸ»ç¿¡¼ °è»êÇÏ°í ºñ¿ëÀ» ºÎ°úÇÒ ¼ö ÀÖ½À´Ï´Ù.
- 32
- quotation
°ßÀû¿¡¼ OrderItemÀ» ¾ò¾ú½À´Ï´Ù. °í°´ ¸í·É¿¡ ÀÇÇØ °¡°ÝÀÌ ÀÚµ¿À¸·Î °»½ÅµÇÁö ¾Ê½À´Ï´Ù.
- 64
- notConfigured
ÀÌ OrderItem¿¡ ´ëÇÑ °¡°Ý Á¶È¸ ¹× Àç°í ÇÒ´çÀÌ OICOMPLIST Å×ÀÌºí¿¡ ÀÖ´Â ±¸¼º¿ä¼Ò Ç׸ñÀ» »ç¿ëÇÏ¿© ¼öÇàµÇÁö ¾Ê¾Ò½À´Ï´Ù. ÀÌ Ç÷¡±×´Â CONFIGURATIONID ¿°ªÀÌ ³Î(Null)°ªÀÎ OrderItem¿¡´Â ¼³Á¤ÇÒ Çʿ䰡 ¾ø½À´Ï´Ù.
- 128
- autoAdd
OrderCalculate ¸í·É¿¡ ÀÇÇØ ÀÌ OrderItemÀÌ ÀÚµ¿À¸·Î ÁÖ¹®¿¡ Ãß°¡µÇ¾ú½À´Ï´Ù. ÀÌ Ç÷¡±×´Â Á¤º¸ Ç¥½Ã Àü¿ëÀ̸ç, °¡°Ý °è»ê¿¡ ¿µÇâÀ» ¹ÌÄ¡Áö ¾Ê½À´Ï´Ù.