Update_NC_OrderStatus ¸Þ½ÃÁö´Â WebSphere Commerce ÁÖ¹®¿¡ ´ëÇÑ »óÅ Á¤º¸¸¦ Æ÷ÇÔÇÏ´Â Àιٿîµå ¸Þ½ÃÁöÀÔ´Ï´Ù. ¹é¿£µå ÀÀ¿ëÇÁ·Î±×·¥Àº ÀÌ ¸Þ½ÃÁö¸¦ »ý¼ºÇÏ¿© WebSphere Commerce Àιٿîµå ¸Þ½ÃÁö Å¥·Î º¸³»¸ç, ¿©±â¼ WebSphere Commerce ½Ã½ºÅÛÀÌ ¸Þ½ÃÁö¸¦ ¹Þ½À´Ï´Ù. WebSphere Commerce OrderStatus ¸í·ÉÀº »õ ÁÖ¹® »óÅ Á¤º¸·Î ORDSTAT ¹× ORDISTAT Å×À̺íÀ» °»½ÅÇÕ´Ï´Ù.
Update_NC_OrderStatus ¸Þ½ÃÁö´Â XML ¸Þ½ÃÁö Æ÷¸ËÀ» »ç¿ëÇϸç Update_NC_OrderStatus_10.dtd¸¦ µû¸¨´Ï´Ù.
´ÙÀ½ Å×ÀÌºí¿¡¼´Â Update_NC_OrderStatus ¸Þ½ÃÁöÀÇ Æ÷¸Ë¿¡ ´ëÇØ ¼³¸íÇÕ´Ï´Ù. µ¥ÀÌÅͺ£À̽º ¿¿¡ ´ëÇÑ ¼³¸íÀº Å×ÀÌºí¿¡ ¿¬°üµÈ ¸µÅ©¸¦ µû¸£½Ê½Ã¿À. ¸í½ÃµÇ¾î ÀÖÁö ¾Ê´Â ÇÑ, ¸ðµç Çʵå´Â ¼±ÅÃÀûÀÔ´Ï´Ù. INT, BIGINT ¹× DOUBLE À¯ÇüÀÇ µ¥ÀÌÅͺ£À̽º Çʵ忡 ´ëÇÑ XML ¸Þ½ÃÁöÀÇ ÅÂ±× °ª ±æÀÌ´Â °¢°¢ CHAR(10), CHAR(19) ¹× CHAR(16)À̾î¾ß ÇÕ´Ï´Ù.
¼öÁØ | Çʵå À̸§ | ¼³¸í | Å×À̺í À̸§ | ¿ À̸§ | ÁÖ |
---|---|---|---|---|---|
1 | OrderStatus Header |
¾øÀ½ | ¾øÀ½ | ¾øÀ½ | |
1.1 | OrderNumber ByBackend |
ORDSTAT | OSMORDER | ¹é¿£µå ½Ã½ºÅÛ¿¡ ÀÇÇØ »ý¼ºµÈ ÁÖ¹® ÂüÁ¶ ¹øÈ£ | |
1.2 | OrderNumber ByNC
|
Çʼö | ORDSTAT | ORDERS_ID | WebSphere Commerce ÁÖ¹® ÂüÁ¶ ¹øÈ£. ÀÌ´Â ORDERS Å×ÀÌºí¿¡¼ ORDERS_ID ¿À» ÂüÁ¶ÇÏ´Â foreign keyÀÔ´Ï´Ù. |
1.3 | OrderNumber ByBuyer |
¾øÀ½ | ¾øÀ½ | ¾øÀ½ | |
1.4 | TotalPriceInfo | ¾øÀ½ | ¾øÀ½ | ¾øÀ½ | |
1.4.A1 | currency | ¼Ó¼º | ORDSTAT | OSCPCUR | °¡°Ý Ç¥½Ã ´ÜÀ§°¡ µÇ´Â ÅëÈ. ÅëÈ Æ÷¸ËÀº ISO 4217 Ç¥ÁØÀ» µû¶ó¾ß ÇÕ´Ï´Ù. |
1.4.1 | TotalNetPrice | ORDSTAT | OSPRTOT | ÁÖ¹®ÀÇ ÃÑ »óǰ °¡°Ý | |
1.4.2 | TotalTaxPrice | ORDSTAT | OSTXTOT | ÁÖ¹®ÀÇ ÃÑ ¼¼±Ý | |
1.4.3 | TotalShippingPrice | ORDSTAT | OSSHTOT | ÁÖ¹®ÀÇ ÃÑ ¿î¼Û °æºñ | |
1.4.4 | TotalTaxOn ShippingPrice |
ORDSTAT | OSSHTXTOT | ÁÖ¹®ÀÇ ¿î¼Û °æºñ¿¡ ´ëÇÑ ÃÑ ¼¼±Ý | |
1.5 | RequisitionerID | ¾øÀ½ | ¾øÀ½ | ¾øÀ½ | |
1.5.A1 | type | ¼Ó¼º | ¾øÀ½ | ¾øÀ½ | ¾øÀ½ |
1.6 | Status | ORDSTAT | OSSTATUS | ÁÖ¹®ÀÇ »óÅ | |
1.7 | DateTime Reference |
¾øÀ½ | ¾øÀ½ | ¾øÀ½ | |
1.7.1 | PlacedDate | ORDSTAT | OSPLTIME | Á¦ÃâµÈ ÁÖ¹® ½Ã°£¼ÒÀÎ | |
1.7.2 | PlacedTime | ¾øÀ½ | ¾øÀ½ | ¾øÀ½ | |
1.7.3 | LastUpdateDate | ¾øÀ½ | ¾øÀ½ | ¾øÀ½ | |
1.7.4 | LastUpdateTime | ORDSTAT | OSUPDTIME | ÁÖ¹®¿¡ ´ëÇÑ ¸¶Áö¸· °»½Å ½Ã°£¼ÒÀÎ | |
1.8 | ShipDate Reference |
¾øÀ½ | ¾øÀ½ | ¾øÀ½ | |
1.8.1 | Requested ShipDate |
ORDSTAT | OSRSTIME | ¿äûµÈ ¿î¼Û ½Ã°£¼ÒÀÎ | |
1.8.2 | Scheduled ShipDate |
ORDSTAT | OSSSTIME | °èȹµÈ ¿î¼Û ½Ã°£¼ÒÀÎ | |
1.8.3 | Actual ShipDate |
ORDSTAT | OSASTIME | ½ÇÁ¦ ¿î¼Û ½Ã°£¼ÒÀÎ | |
1.9 | CustomerField | ù ¹øÂ° ¹ß»ý | ORDSTAT | FIELD1 | »ç¿ëÀÚ Á¤ÀÇ¿ëÀ¸·Î ¿¹¾à |
1.9 | CustomerField | µÎ ¹øÂ° ¹ß»ý | ORDSTAT | FIELD2 | »ç¿ëÀÚ Á¤ÀÇ¿ëÀ¸·Î ¿¹¾à |
1.9 | CustomerField | ¼¼ ¹øÂ° ¹ß»ý | ORDSTAT | FIELD3 | »ç¿ëÀÚ Á¤ÀÇ¿ëÀ¸·Î ¿¹¾à |
1.10 | UserData | ¾øÀ½ | ¾øÀ½ | ¾øÀ½ | |
2 | OrderStatusItem | ¾øÀ½ | ¾øÀ½ | ¾øÀ½ | |
2.1 | OrderNumber ByBackend |
ORDISTAT |
OSMORDER | ¹é¿£µå ½Ã½ºÅÛ ÁÖ¹® ¹øÈ£ | |
2.2 | ItemNumber ByBackend |
ORDISTAT | OIMITEM | ¹é¿£µå ½Ã½ºÅÛ ÁÖ¹® Ç׸ñ ¹øÈ£ |
|
2.3 | OrderNumber ByNC |
Çʼö | ORDISTAT | ORDERS_ID | WebSphere Commerce ÁÖ¹® ÂüÁ¶ ¹øÈ£. ÀÌ´Â ORDERS Å×ÀÌºí¿¡¼ ORDERS_ID ¿À» ÂüÁ¶ÇÏ´Â foreign keyÀÔ´Ï´Ù. |
2.4 | ItemNumber ByNC |
ORDISTAT | ORDER ITMES_ID |
WebSphere Commerce Ç׸ñ ÂüÁ¶ ¹øÈ£. À̰ÍÀº ORDERITEMS Å×ÀÌºí¿¡¼ ORDERITEMS_ID¸¦ ÂüÁ¶ÇÏ´Â foreign keyÀÔ´Ï´Ù. | |
2.5 | ¼ö·® | ORDISTAT | OIQTCONFIRM | È®ÀÎµÈ Ç׸ñ ¼ö·® | |
2.6 | ItemUnitPrice | ORDISTAT | OIUNPRC | ´Ü°¡ ´Ü°¡ |
|
2.7 | TotalPriceInfo | ¾øÀ½ | ¾øÀ½ | ¾øÀ½ | |
2.7.A1 | currency | ¼Ó¼º | ORDISTAT | OICPCUR | Ç׸ñ °¡°ÝÀÌ Ç¥½ÃµÇ´Â ÅëÈ. ÅëÈ Æ÷¸ËÀº ISO 4217 Ç¥ÁØÀ» µû¶ó¾ß ÇÕ´Ï´Ù. |
2.7.1 | TotalNetPrice | ORDISTAT |
OIPRTOT | Ç׸ñÀÇ ÃÑ °¡°Ý | |
2.7.2 | TotalTaxPrice | ORDISTAT | OITXTOT | Ç׸ñ¿¡ ´ëÇÑ ÃÑ ¼¼±Ý | |
2.7.3 | TotalShippingPrice | ORDISTAT |
OISHTOT | Ç׸ñÀÇ ÃÑ ¿î¼Û °æºñ | |
2.7.4 | TotalTaxOn ShippingPrice |
ORDISTAT |
OISHTXTOT | Ç׸ñ¿¡ ´ëÇÑ ¿î¼Û °æºñÀÇ ÃÑ ¼¼±Ý | |
2.8 | Status | ORDISTAT | OISTATUS | ÁÖ¹® Ç׸ñ »óÅ | |
2.9 | DateTime Reference |
¾øÀ½ | ¾øÀ½ | ¾øÀ½ | |
2.9.1 | PlacedDate | ORDISTAT | OIPLTIME | Á¦ÃâµÈ ÁÖ¹® Ç׸ñ ½Ã°£¼ÒÀÎ | |
2.9.2 | PlacedTime | ¾øÀ½ | ¾øÀ½ | ¾øÀ½ | |
2.9.3 | LastUpdateDate | ¾øÀ½ | ¾øÀ½ | ¾øÀ½ | |
2.9.4 | LastUpdateTime | ¾øÀ½ | ¾øÀ½ | ¾øÀ½ | |
2.10 | ShipDate Reference |
¾øÀ½ | ¾øÀ½ | ¾øÀ½ | |
2.10.1 | Requested ShipDate |
ORDISTAT | OIRSTIME | ¿äûµÈ ¿î¼Û ½Ã°£¼ÒÀÎ | |
2.10.2 | Scheduled ShipDate |
ORDISTAT | OISSDATE | °èȹµÈ ¿î¼Û ½Ã°£¼ÒÀÎ | |
2.10.3 | Actual ShipDate |
ORDISTAT | OIASTIME | ½ÇÁ¦ ¿î¼Û ½Ã°£¼ÒÀÎ | |
2.11 | Instruction | ORDISTAT | OICMNT | ÁÖ¹® Ç׸ñ¿¡ ´ëÇÑ ±¸¸ÅÀÚ ¼³¸í. ¿¹¸¦ µé¾î, ±¸¸ÅÀÚ´Â ÁÖ¹®ÇÑ ¼±¹°¿¡ ¸Þ½ÃÁö¸¦ Æ÷ÇÔ½Ãų ¼ö ÀÖ½À´Ï´Ù. | |
2.12 | CustomerField | ù ¹øÂ° ¹ß»ý | ¾øÀ½ | ¾øÀ½ | »ç¿ëÀÚ Á¤ÀÇ¿ëÀ¸·Î ¿¹¾à |
2.12 | CustomerField | µÎ ¹øÂ° ¹ß»ý | ¾øÀ½ | ¾øÀ½ | »ç¿ëÀÚ Á¤ÀÇ¿ëÀ¸·Î ¿¹¾à |
2.12 | CustomerField | ¼¼ ¹øÂ° ¹ß»ý | ¾øÀ½ | ¾øÀ½ | »ç¿ëÀÚ Á¤ÀÇ¿ëÀ¸·Î ¿¹¾à |
2.13 | UserData | ¾øÀ½ | ¾øÀ½ | ¾øÀ½ |
![]() |