KR20020019718A - Method for Managing Database according to Order on Fashion supply Chain Management System - Google Patents

Abstract

PURPOSE: A method for operating a database according to an order in integrated fashion commodity management system is provided to systematically manage partial delivery or split delivery generated in physical distribution. CONSTITUTION: A purchaser selects desired commodities at an on-line shopping mall and orders the selected commodities through a terminal capable of inputting an order of a commodity(S100). An on-line shopping mall server receives the order and grants an order number to it(S110). The shopping mall server creates an order master table for the order and order detail tables for the commodities of the order(S120). The shopping mall server confirms whether the commodity price is inputted for the order(S130). If the commodity price is inputted for the order, the shopping mall server delivers the commodities to the purchaser and creates commodity delivery tables to manage delivery information(S140). Then the shopping mall server updates the order master table and the order detail tables(S150).

Description

Method for Managing Database according to Order on Fashion supply Chain Management System}

The present invention relates to a method for operating a database for each order in the integrated fashion product supply chain management system, an order that can systematically manage the partial or partial delivery of order products occurring in the bulk logistics process of Business-to-Business e-commerce. It is about the database operation method.

Recently, as the Internet becomes more popular, electronic commerce through the Internet has become a new commerce method in addition to the conventional offline market transactions. Electronic commerce refers to the act of buying and selling goods through the Internet or PC communication, and broadly encompasses the purchase, ordering, and advertisement of goods and services through a computer communication network. The biggest advantage of such e-commerce is that there is no time and space constraints, so it is less troublesome to go directly to the store, and the transaction price is mainly settled by credit card. In addition, there is no cost of distribution or building rent, and it is likened to the state-of-the-art golden fishing grounds in that all Internet subscribers in the world are potential customers. This electronic commerce method is characterized in that the transaction between a seller who has opened a shopping mall homepage in a worldwide communication network called the Internet and a buyer who wants to enter a shopping mall to purchase a product is performed by computer communication.

The Internet shopping mall method utilizes recently developed communication protocol, multimedia, and multitasking technology, and does not require the wide store and management personnel as in the conventional market transaction, and it is easy to find the desired product without the trouble of the buyer. Is attracting much attention from operators. One of the most important success factors of the internet shopping mall business is effective public relations. In other words, if the shopping mall promotion is actively conducted extensively, the number of users entering and exiting will increase, and as a result, the product purchase rate will increase accordingly.

The online shopping mall via the Internet merely implements a function of a retailer that sells a finished product from a retailer to a consumer online among the functions of the existing offline market. Conventional markets not only have business-to-customers currently implemented on the Internet, but also have business-to-business functions that connect wholesalers, retailers, manufacturers, and distributors. It cannot be implemented in shopping malls via the Internet.

However, the existing offline market has a weak infrastructure for informatization compared to the transaction size and logistics size. Internet shopping malls, which are growing steadily, started from the beginning based on information infrastructure, but the existing offline market has a lot of difficulty in moving its form online. Thus, despite the significant increase in the costs and time required for production and sales, the costs of complex distribution networks, and inventory management, the traditional offline market still remains behind existing correlations, with the informatization behind. .

The biggest problem in bringing the existing offline market online is that it is difficult to install the equipment for building the information infrastructure in the existing offline market, and it is difficult to implement the characteristics or characteristics that have been maintained for each offline market online and independently. It is not feasible for a company to bring an existing offline market online due to technical or capital problems, and even if it is successful online, it was impossible to maintain and manage it continuously.

In the existing off-line market, the market that deals with fashion-related products has a short product cycle due to the nature of fashion-related products. Therefore, the integrated management system through computerization in the supply of raw materials, the collection of fashion-related information, and the ordering and delivery of goods between wholesale and retail markets is necessary. Construction has long been required. However, as described above, it is true that the existing offline market is not difficult to implement as an online shopping mall, but it is very difficult to maintain original characteristics and characteristics.

1 is an exemplary diagram for explaining a problem occurring in a bulk logistics process of a business-to-business electronic commerce.

In the mass logistics process of business-to-business e-commerce, there is still a solution to systematically manage these orders when various items are requested in one order or when orders exceeding the daily supply are available. It is not proposed until.

According to the purchase order 10 of the buyer, 10 goods A and 20 goods B were ordered to the supplier 1, 30 goods C and 40 goods D were respectively ordered to the supplier 2. First, since there are two suppliers to supply goods for one order, there is a problem of partial delivery in which the time for delivering goods for each supplier varies.

With respect to the buyer's order, the supplier 1's supply history (11) shows that since supplier 1 has 30 products A and 0 products B, all of the buyer's order quantity can be immediately delivered to product A. , Item B must be secured in order to be shipped. Here, there is a problem of partial delivery in which the delivery time is different for each product.

In the supplier supply history 12 of the supplier 2, since the supplier 2 has 20 commodities C and 10 commodities D, only a part of the buyer order quantity can be delivered. Suppose a supply contract with buyers and suppliers 1 and 2 has been concluded on an order, and all of the daily supply is delivered only to the buyer shown in Fig. 1, supplier 2 first delivers 20 for goods C and the rest Ten more will be shipped later, so delivery of the quantity of commodity C is completed at least twice. In the case of commodity D, ten items are delivered first, and the remaining thirty are delivered later, so that delivery of the order quantity of commodity D is completed at least three times. In order to deliver all the order quantity for each product, there is a problem of divided delivery of dividing the order quantity several times.

An object of the present invention is to solve the above problems, the order in the integrated fashion product supply chain management system that can systematically manage the partial delivery or partial delivery of order products occurring in the bulk logistics process of Business-to-Business e-commerce The purpose is to provide database management methods. The purpose of the database operation method for each order according to the present invention is to manage mass logistics smoothly by managing orders, goods, and delivery status in a hierarchical structure from receipt of product order to delivery completion.

1 is an exemplary diagram illustrating a problem occurring in a bulk logistics process of a business-to-business e-commerce,

Figure 2 is a flow chart showing the overall process of the database operation method for each order in the integrated fashion product supply chain management system according to an embodiment of the present invention,

3 is a schematic diagram showing a relationship between an order master table, an order detail table, and a delivery table generated in a database created by an order-specific database operating method according to an embodiment of the present invention;

4 is a table illustrating a detailed schema of an order master table, an order detail table, and a delivery table generated by an order-specific database operating method according to an embodiment of the present invention.

5 is a table illustrating field-specific specifications of an order master table, an order detail table, and a delivery table generated by an order-specific database operating method according to an embodiment of the present invention.

6 is an exemplary diagram illustrating an embodiment of the present invention implemented in a fashion product supply chain in which an existing offline fashion product market is established through an online network.

7A and 7B are exemplary views illustrating an example of outputting a terminal screen in a process of confirming purchase order by a purchaser according to an embodiment of the present invention.

In order to achieve the above object, the order-specific database operation method in the fashion product supply chain integrated management system according to the present invention, in the fashion product supply chain integrated management system that established the existing offline fashion product market online network, (A) receiving a product order input through a terminal; (B) generating an order master table and an order detail table for each order product in a database for the orders received in the step (a), and setting the order status of each table to an initial value; (C) approving and changing the order status of the order detail table generated in step (b) by confirming whether or not the price of the goods is deposited for each order product, and approving delivery of the order goods; (D) generating a delivery table for each divided delivery for each ordered product delivered in the step (c), storing the divided delivery quantity, and setting an order state as an initial value; (E) changing the order status of the delivery table generated in step (d) by receiving information on the delivery status; And updating the order state of the order detail table using the changed order state of the delivery table in step (e), and updating the order state of the order master table using the order state.

Hereinafter, with reference to the accompanying drawings will be described in detail a preferred embodiment of the present invention.

Prior to the detailed description, terms used below are summarized to describe a method for operating a database for each order in the integrated fashion product supply chain management system according to the present invention.

'Partial delivery' means that when the delivery date is different for each order within the same order, each order is shipped separately for each delivery date.

"Split delivery" means that when the current inventory for the ordered product is smaller than the order quantity, each part of the order quantity is delivered on different dates to fill the order quantity.

'Order status' represents the processing status for orders, goods, and delivery. Several products can be ordered within the same order, with partial delivery for each product. In order to reflect the above-described situation in the system, the order status means processing status by partial delivery or partial delivery of each order, each ordered product, and each ordered product.

Figure 2 is a flow chart showing the overall process of the order-by-order database operating method in one embodiment fashion fashion supply chain integrated management system according to the present invention.

In the ordering of the product (S100), the buyer who selects the product to purchase in the online shopping mall orders the product through a terminal capable of inputting a product order. A terminal for receiving an order for a product is a PC, an Internet phone, or an IMT2000 terminal connected to the Internet.

In step S110 of receiving an order, an online shopping mall server receives an order input through a terminal and assigns an order number.

Generating the order master table and the order detail table (S120) is a step of creating a table in the database for the order received in step S110. One order master table is created by one order, and several order detail tables are generated for each product included in one order. When two kinds of goods A and B are ordered in one order as in FIG. 3, only one order master table is generated, but two order detail tables are generated. Therefore, since the order detail table is generated, the number of tables generated and the stored product information are determined by the order information stored in the order master table, the order detail table is dependent on the order master table. The order master table manages order information, including order number, order date, order information and recipient information, and the order detail table provides detailed order number, order number, order date, product information and order information. It manages product information, including information about the recipient and information about the recipient, etc., which are illustrated in FIGS. 4 and 5.

After creating the order master table and the order detail table, inputting the order information in the fields of each table, and setting the order status field of each table as the initial value, the initial value of each table is 'receiving'.

The step (S130) of checking whether or not the payment for the product price is a step of checking whether the product price is deposited for each order or for each ordered product.

The step S130 is a step corresponding to the case of adopting the most common electronic commerce payment method that operates by receiving the goods price first and shipping the goods, and the payment method is operated by depositing or credit transaction after confirming the goods delivery. In the case of a method, the step may be omitted or replaced. Credit transactions can be divided into credit transactions using credit cards or bills and credit transactions by credit. In particular, in the case of credit transactions due to trauma, the payment of goods payment is replaced with a step of confirming whether the credit transaction by credit is approved by searching the supplier's preset items.

Before depositing the product price in step S130, the orderer may cancel the order. An order can be canceled for one order or for each product included in the order. In the case of a canceled order or order product, the order status in the order detail table is changed to 'cancel order request' or 'cancel order completion'.

When the product price is received in step S130, the order status field of the order detail table is changed to 'deposit confirmation'.

Generating the product delivery / delivery table (S140) is a step of generating a delivery table for managing the delivery information, and delivers the goods to the buyer confirmed the goods payment in step S130.

A plurality of shipping tables is created for one order detail table. That is, as many delivery tables as the number of times that the divided delivery is made for one product are generated. As shown in FIG. 3, when two deliveries are performed for the goods A, two delivery tables are generated. Therefore, since the generation of the delivery table, the number of generated tables, and the stored delivery information are determined by the product information stored in the order detail table, the delivery table is dependent on the order detail table. Product information managed by the order detail table and delivery information managed by the delivery table are illustrated in FIGS. 4 and 5. The delivery table manages delivery information including a product delivery number, detailed order number, delivery information, product information, orderer information, and recipient information.

After order information is input into the fields of each delivery table generated by the split delivery, the order status field of the table is set to an initial value, and the initial value of each table is 'delivery'.

The order status field of the delivery table generated in step S140 is changed to 'delivery completed', 'payment completed' or 'settlement completed' by receiving delivery information. The delivery information is input at the time of shipment or at the time of receipt of the goods, and changes the order status of the delivery table.

In the step S150 of updating the order detail table and the order master table, if any one of the order status fields of each delivery table is changed in step S140, the order status field of the order detail table, which is the upper table thereof, is updated. The order status field of the order master table is updated by using the order status field of the updated order detail table.

An example of a rule that updates the order status field of the parent table is as follows: If all of the order status fields in each delivery table that depend on the order detail table are 'delivery completed', the order status field in the order detail table is updated to 'delivery complete', and the order status field in one delivery table is 'delivering' If 'or' before delivery ', the order status field in the order detail table remains' shipping'.

If all the order status fields in each order detail table that depend on the order master table are 'delivery completed', the order status field in the order master table is updated to 'Deposit' and the order status field in any order detail table is' 'Delivery', the order status field in the order master table remains 'received'. Detailed update rules will be described with reference to FIGS. 4 and 5.

3 is a schematic diagram showing a relationship between an order master table, an order detail table, and a delivery table generated by an order-specific database operating method according to an embodiment of the present invention.

The order master table manages order information such as order number and order date and time. The product information, which is the product order contents, is managed by the order detail table. As shown in Figure 3, the order of the order number K was received on January 1, 2000, the goods ordered A 100 and B 50. These orders produce one order master table and two order detail tables.

The delivery table manages delivery information of an ordered product. As illustrated in FIG. 3, 100 items A, which are the contents of the order number K, were delivered on January 1, 2000 and 70 on January 2, 2000. With this delivery information, two delivery tables were created for each order detail table.

As shown in FIG. 3, the delivery table is dependent on the order detail table, and the order detail table is dependent on the order master table.

4 is a table illustrating a detailed schema of an order master table, an order detail table, and a delivery table generated by an order-specific database operating method according to an embodiment of the present invention, and FIG. 5 is a table illustrating field-specific specifications.

The order master table is composed of a plurality of fields as shown in FIG. 4 to manage order information including order number, order date, order status, order type, order information, and recipient information. Order number in the ODID field, order date in the ODDATE field, order status in the ODSTATE field, order type in the BUY_TYPE field, orderer information in the BUYER_NAME field, the orderer's name in the BUYER_PHONE field, the orderer's phone number, BUYER_EMAIL The orderer's email address is stored in the field, and the recipient's name is displayed in the RECV_NAME field, the recipient's phone number in the RECV_PHONE field, the recipient's address in the RECV_ADDRL field, the recipient's postal code in the RECV_POST field, and the message delivered in the RECV_MSG field. Is stored. Other fields include the orderer's ID, store code, payee's cell phone, prepaid amount, brief memo or return / replacement order.

The order detail table includes a plurality of fields as shown in FIG. 4 to manage product information including detailed order number, order number, order date, order status, product information, order information and recipient information. Consists of The detailed order number is stored in the SEQ field, the product information is stored in the PRODUCT_CODE field, the product quantity in the PRODUCT_NUM field, the product price in the PRODUCT_PRICE field, the product size in the OPTION_SIZE field, and the product color in the OPTION_COLOR field. Other fields include orderer's ID, store code, credit status, short note, return / replacement order, date of deposit or remaining quantity.

The shipping table is shown in FIG. 4 to manage shipping information including a shipping number, a detailed order number, order date, order status, delivery information, product information, order information and recipient information. It consists of a number of fields. The delivery number is stored in the NUM field, the delivery information is stored in the PRODUCT_NUM field, the quantity left in the REMAIN_NUM field, and the waybill number in the TRANSFER_NUM field. In addition, it includes fields such as the quantity that can be returned, the amount calculation at the time of settlement, the orderer's ID, the store code, or the settlement of fees. Details of each field are as shown in the table of FIG. 5.

In FIG. 4, the order master table and the order detail table use the same order number, and the order detail table and the delivery table use the same detail order number. Thus, retrieving several order detail tables subordinate to one order master table or retrieving several delivery tables subordinate to one order detail table is searched using the order number or detail order number.

Figure 6 is an exemplary view showing an embodiment of the present invention implemented in a fashion product supply chain built on the existing offline fashion product market online network.

The buyer orders the goods using the online shopping mall, and deposits the goods price (S200). The online shopping mall where buyers order products is an existing offline fashion product market built on an online network. The existing market remains on-line as it is, and the order and management functions are transferred online. The commodity price is shown only in the case of unpaid pass, but in addition, commerce can be established by credit transaction. The integrated management system that receives the order in step S200 generates an order master table and an order detail table for the order.

The integrated management system checks whether the buyer pays for the goods (S210). In this embodiment, it is assumed that commerce occurs based on a prepayment for each order or product. Therefore, the payment of goods payment is confirmed through the banking network connected to the integrated management system. In step S210, the order status field of the order detail table is changed.

On the day of each supplier, the order statement is printed and the supplier delivers the order statement and the waybill (S220, S230). In consideration of the characteristics of the existing offline market to which the present invention is applied, the existing offline market is difficult to establish a network such as LAN in the market itself due to various problems. The order history received through the shopping mall is printed and delivered to the supplier. However, in the offline market where a network can be established or a network has already been established with a LAN or the like, the steps S220 and S230 are replaced by transmitting the order contents to the terminal of the supplier. In the case of ordering goods from a supplier by a single order, each supplier shall send an order statement for the ordered goods. In step S220, a delivery table is generated.

Carries the ordered goods to the storage for goods delivery (S240). The process of collecting goods to be delivered by order.

Check the product history and quantity, receive the waybill, and seal the product (S250). This is the process generally performed in the delivery of goods. To find out if an order is partly delivered, check the quantity of the item currently being delivered.

The goods that have been checked in the waiting delivery vehicle are loaded, and when a certain time, the delivery vehicle departs toward the retailer (S260 and S270).

The delivery result is input to the integrated management system (S280). When the product details and the quantity checked in step S250 are input, the order status field of the delivery table is changed from 'before delivery' to 'during delivery'. For orders with partial delivery, a delivery table corresponding to the remaining quantity is created in the corresponding order detail table, and the order status field of the generated delivery table is 'before delivery'. For example, if the order volume is 100 and 20 ships in a single shipment, a shipping table for 80 deliveries will be created, and if 30 delivers in 2 deliveries, 50 deliveries will remain. The table is created. Therefore, three delivery tables are subordinate to the order detail table of the product.

When the ordered product is delivered to the buyer, the buyer receives and confirms the ordered product (S290, S300). When the delivery operation is completed by the confirmation operation, the delivery confirmation result is input to the integrated management system. As a result, the order status field of the delivery table is changed to 'delivery completed'. The integrated management system also updates the order master table and the order detail table.

7A and 7B are exemplary views illustrating an example of outputting a terminal screen in a process of confirming purchase order by a purchaser according to an embodiment of the present invention.

According to the present invention, the purchaser, supplier or integrated system administrator can monitor the entire process from order reception to delivery completion. In FIG. 7, the purchaser checks the order of his order. In FIGS. 7A and 7B, the buyer drills down from the comprehensive information on the order to the detailed information to display the order history. It is an exemplary figure which shows the process of confirmation.

FIG. 7A illustrates a screen displaying a process of processing a first order among buyers' orders.

Order-specific output screen 20 is a screen outputting the order history currently ordered by the buyer.

The detailed product-specific output screen 21 is a screen for outputting detailed product-specific details of the order corresponding to the order number 2000061400803_688_test.

The delivery history output screens 22 and 23 are screens for outputting delivery details of products corresponding to product codes NNN-503 and NNN-003, respectively.

Figure 7b shows a screen outputting the processing of the entire order of the buyer.

Order-specific output screen 30 is a screen outputting the order history currently ordered by the buyer.

The delivery history output screen 31 is a screen for outputting detailed product-specific details of all products ordered by the buyer.

As described above, according to the method for operating the database for each order in the integrated fashion product supply chain management system according to the present invention, the partial delivery or partial delivery of the ordered goods generated in the bulk logistics process of the business-to-business e-commerce systematically Can be managed by The database operation method for each order according to the present invention can manage the bulk logistics smoothly by managing the order, goods, and delivery status in a hierarchical structure from the receipt of the product order to the completion of delivery. That is, the purchaser, supplier or integrated system manager can monitor the comprehensive processing status of the individual orders to the detailed processing status, so that problems occurring in the bulk logistics process can be checked and processed from time to time.

Claims (7)

In the integrated fashion product supply chain management system that established the existing offline fashion product market as an online network, (A) receiving a product order input through a terminal; (B) generating an order master table and an order detail table for each order product in a database for the orders received in the step (a), and setting the order status of each table to an initial value; (C) approving and changing the order status of the order detail table generated in step (b) by confirming whether or not the price of the goods is deposited for each order product, and approving delivery of the order goods; (D) generating a delivery table for each divided delivery for each ordered product delivered in the step (c), storing the divided delivery quantity, and setting an order state as an initial value; (E) changing the order status of the delivery table generated in step (d) by receiving information on the delivery status; And And (f) updating the order status of the order detail table using the changed order status of the delivery table in step (e), and updating the order status of the order master table using the order status. How to operate database by order in integrated supply chain management system. The method of claim 1, In step (b), the order detail table is generated for each ordered product when two or more items are included in the same order and are partially delivered, and the fashion product supply chain is integrated. How to operate database by order in management system. The method of claim 1, In the step (b), the order information stored in the order master table, the order number, order date and time, order status, type of order, information about the orderer and the recipient information, the goods stored in the order detail table The information is detailed order number, order number, order date and time, order status, product information, order information and recipient information. In step (d), the delivery information stored in the delivery table includes a delivery number, a detailed order number, order date, order status, delivery information, product information, orderer information, and recipient information. Order database operation method in the fashion product supply chain integrated management system, characterized in that the. The method of claim 1, In the step (c), confirming whether or not the payment of the goods price and approving the delivery for each order product, characterized in that it includes the case of depositing the price of each order goods to the designated account or credited transaction How to operate a database for each order in the integrated fashion product supply chain management system. The method of claim 1, In the step (d), the delivery table is generated when the same order goods are divided delivery, and has a property dependent on the order detail table, characterized in that the order database operating method in the integrated fashion product supply chain management system . The method of claim 1, In the step (e), the information on the delivery status is received at the time of product shipment or receipt of goods, the database operation method for each order in the integrated fashion product supply chain management system, characterized in that to change the order status of the delivery table . The method of claim 1, In the step (f), the order status of the order detail table is updated by judging the order status of each delivery table subordinate to the order detail table according to a predetermined rule, The order status of the order master table, the order-specific database operation method in the fashion product supply chain integrated management system, characterized in that for updating the order status of each order detail table subordinate to the order master table by a predetermined rule.