 |
Claims  |
|
|
What is claimed is:
1. A data processing network for which a plurality of product selling
enterprises, a plurality of product planning and selling enterprises, a
plurality of product processing and manufacturing enterprises and a
plurality of material selling enterprises subscribe, comprising:
a database for gathering and accumulating data retained separately by said
plurality of product selling enterprises for independently selling
products, by said plurality of product planning and selling enterprises
for independently planning and selling said products, by said plurality of
product processing and manufacturing enterprises for independently
processing and manufacturing said products and by said plurality of
material selling enterprises for independently planning, manufacturing and
selling materials of said products;
a plurality of first terminals, provided in each of said plurality of
product selling enterprises, for:
inputting business history data on products to be actually sold,
inputting one of retrieval instructions as to the business history data,
data on manufacturing and selling said products and data on products in
stock,
sending the input data and retrieval instructions,
receiving retrieved business history data, data on manufacturing and
selling said products and data on products in stock, and
outputting the received data;
a plurality of second terminals, provided in each of the plurality of
product planning and selling enterprises, for:
inputting said business history data on products to be actually sold, said
data on manufacturing and selling said products and said data on products
in stock,
inputting one of retrieval instructions as to data for use in planning the
products, data for use in planning the materials, data on manufacturing
and selling the products to be actually sold, the data on products in
stock, data on the materials in stock, business history data on the
products and business history data on the materials,
sending the input data and the retrieval instructions,
receiving retrieved data for use in planning the products, data for use in
planning the materials, data on manufacturing and selling products to be
actually sold, data on products in stock, data on materials in stock,
business history data on the products and business history data on the
materials and
outputting the received data;
a plurality of third terminals, provided in each of said plurality of
product processing and manufacturing enterprises, for:
inputting retrieval instructions as to the data on manufacturing and
selling the products to be actually sold,
sending the input retrieval instructions,
receiving retrieved data on manufacturing and selling the products to be
actually sold and
outputting the received data;
a plurality of fourth terminals, provided in each of said plurality of
material selling enterprises, for:
inputting data on manufacturing materials to be used as goods, the data on
materials in stock, the business history data on the materials,
inputting one of retrieval instructions as to the data for use in planning
the products, the data for use in planning the materials, the data on
manufacturing materials to be used as goods, the data on materials in
stock and the business history data on the materials,
sending the input data and the retrieval instructions,
receiving retrieved data for use in planning the products, data for use in
planning the materials, data on manufacturing materials to be used as
goods, data on materials in stock and business history data on the
materials, and
outputting the received data; and
control means, connected to said database and connected to said plurality
of first to fourth terminals through a communication line, for:
storing data sent from said first to fourth terminals, and
retrieving data instructed by said database in accordance with the
retrieval instructions sent from one of said first to fourth terminals;
and
said database including:
a plan data database for storing at least the data for use in planning the
products and the data for use in planning the materials;
a product database for storing at least data on producing and selling the
products to be actually sold and data on products in stock;
a material database for storing at least the data on manufacturing the
materials to be used as goods, and the data on materials in stock; and
a business history database for storing at least the business history data
on the products and the business history data on the materials.
2. The apparatus according to claim 1, further comprising a fifth terminal,
connected to said control means, for inputting the data for use in
planning the products and the data for use in planning the materials.
3. The apparatus according to claim 1, wherein said control means includes
means for sending the retrieved data to predetermined terminals and for
processing the retrieved data to send the processed data to remaining
terminals.
4. The apparatus according to claim 1, wherein said products are dresses
and said materials are textile raw materials.
5. The apparatus according to claim 4, wherein said plan data database
includes;
an apparel plan database for storing data for use in planning and
manufacturing the dresses; and
a textile plan database for storing related data for use in planning and
manufacturing the textile.
6. The apparatus according to claim 4, wherein said product database
includes:
an apparel design database for storing design data as to what types of
dresses are made;
an apparel goods database for storing data on manufacturing and selling
dresses to be actually sold; and
an apparel stock database for storing data on goods in stock.
7. The apparatus according to claim 6, wherein the data stored in said
apparel goods database includes data as to what types of dresses are made,
what types of textile raw materials are prepared and what sewing process
is carried out.
8. The apparatus according to claim 4, wherein said material database
includes:
a textile design database for storing design data as to what patterns of
textile are made;
a textile goods database for storing data for use in manufacturing the
textile to be used as goods; and
a textile stock database for storing data on the textile in stock.
9. The apparatus according to claim 4, wherein said business history
database includes:
an apparel receiving and issuing order database for storing business
history data on the apparel; and
a textile receiving and issuing order database for storing business history
data on the textile.
10. The apparatus according to claim 1, wherein said products are bags and
shoes, and said materials are leather.
11. The apparatus according to claim 10, wherein said plan data database
includes:
a bag and shoes plan database for storing data for use in planning and
manufacturing the bags and the shoes; and
a leather plan database for storing related data for use in planning and
manufacturing the leather.
12. The apparatus according to claim 10, wherein said product database
includes:
a bag and shoes design database for storing design data as to what types of
bags and shoes are manufactured;
a bag and shoes goods database for storing data on producing and selling
bags and shoes to be actually sold; and
a bag and shoes stock database for storing data on goods in stock.
13. The apparatus according to claim 12, wherein data stored in said bag
and shoes goods database includes data as to what types of bags and shoes
are manufactured, what types of leather are prepared and what sewing
process is carried out.
14. The apparatus according to claim 10, wherein said material database
includes:
a leather design database for storing design data as to what patterns and
colors of leather are manufactured;
a leather goods database for storing data for use in manufacturing the
leather to be used as goods; and
a leather stock database for storing data on the leather in stock.
15. The apparatus according to claim 10, wherein said business history
database includes: a bag and shoes receiving and issuing order database
for storing business history data on the bags and the shoes; and a leather
receiving and issuing order database for storing business history data on
the leather. |
|
 |
|
 |
Claims |
|
|
|
Description |
|
|
BACKGROUND OF THE INVENTION
1. Field of the Invention
The present invention relates to a data service network system opened to,
for example, an apparel industry and, particular to a data processor using
a database integrated by a computer network for electrically processing
data relating to various types of business transactions ranging from the
manufacture of materials to the sales of dresses or bags in a clothing
industry and a bag industry.
2. Description of the Related Art
In order to rationalize business transactions of issuing or receiving
orders in the filed of the clothing industry, A VAN (Value-Added Network)
has recently been widely used in connection with mainly sportswear. For
example, an ASNET of Asics Corporation using FENICS (trademark) is known.
The ASNET is mainly designed to grasp the state of the sales at the shops
and that of the stock.
Other than the above network, several data networks have been tried.
However, the main purpose of using such data networks is that slip
processing on issuing and receiving orders is electronically performed to
rapidly send the slip through a communication network.
Therefore, even if such a data network is formed, the use of such the
network, in many cases, is limited to the improvement of efficiency of
sending slips on issuing and receiving orders.
The reason can be explained as follows:
The processes ranging from the manufacture of materials to the sales of
dresses are shared by many enterprises (companies). Data necessary for
business activity is dispersively kept in each company. In actuality, even
in the company, a person in charge of each business activity holds
business data, and there is no system in which each data is systematically
connected and used.
Due to this, in the apparel industry dealing with the clothes, which are
produced in many types of goods and a small quantity, particularly
high-quality woman's dresses, though the sale cycle of the clothes as
products is short (for example, two or three months), it takes
considerably much time to perform the process, which is from the plan of,
yarn, raw material and the dress, the manufacture of the member of raw
material to sewing for producing the dresses (for example, one and half
year).
Therefore, there is a large time-lag between the time when the dress is
planned and the time when the dress is actually sold. Due to this, the
trend expected at the time of planning the dresses is different from the
trend at the time of actually selling the dresses, a large number of goods
are returned and a large number of stocked goods are often increased.
Conversely, if the trend expected at the time of planning the dresses
agrees with the trend at the time of actually selling the dresses, such
dresses are sold out soon. Therefore, even if such dresses are
additionally manufactured, in the present state, the additional
manufacture of the dresses does not meet the time when the dresses are
selling well.
Therefore, if it is possible to integrate various types of data relating to
the manufacture of the material to the sales of the finished goods, which
the companies individually possess, into one database system as
considering the systematic use of data, and to form a data work system,
which can be mutually used among the companies, on condition that the
business secret is kept, high-grade data service can be realized.
Therefore, it is obvious that time-lag and the number of the stocked goods
and the number of returned goods can be reduced and that the additional
manufacture can be performed at the time when goods are selling well as
checking the sales trend.
The above-motioned points can be applied to the case of in a bag and shoes
industries dealing with products, which are produced in many types of
goods and a small quantity in the same case as in the apparel industry.
SUMMARY OF THE INVENTION
In consideration of the above-mentioned problems, the present invention has
been made, and an object of the present invention is that various types of
data relating to the manufacture of the material to the sales of the
finished goods, which the companies individually possess, is integrated
into one database system as considering the systematic use of data, and
that a data work system, which can be mutually used among the companies,
is formed on condition that the business secret is kept, thereby realizing
high-grade data service.
According to a first aspect of the present invention, there is provided a
data processing apparatus using an integrated database, comprising an
integrated database for storing data of a series of business of planning,
manufacturing and selling products produced in many types of goods and a
small quantity and their material; and control means, connected to the
integrated database and connected to each terminal of a plurality of
different subscribers performing the series of business of planning,
manufacturing and selling products and their material to be accessible to
each other through a communication line, for suitably retrieving various
data necessary for supporting the business from the integrated database in
accordance with the business requirement of each terminal, and for
outputting data to the terminal to satisfy the requirement, and wherein
the integrated database includes a plan data database for storing at least
data necessary for planning and manufacturing the product and data
necessary for planning and manufacturing the material; a product database
for storing at least data of the production and sales of the product to be
actually sold and data of goods stock of the product; a material database
for storing at least data of the manufacture of material to be used as
goods and stock data of material; and a business history database for
storing at least business history data of the product and business history
data of material.
According to a second aspect of the invention, there is provided a data
processing network using an integrated database, comprising a first
terminal provided in each of a plurality of subscribers selling products
produced in many types of goods and a small quantity; a second terminal
provided in each of a plurality of subscribers planning and selling the
products; a third terminal provided in each of a plurality of subscribers
processing and manufacturing the products; a fourth terminal provided in
each of a plurality of subscribers planning, manufacturing and selling
material of the products; an integrated database for storing data of a
series of business of planning, manufacturing, and selling the products
and material; and control means, connected to the integrated database and
connected to the first to fourth terminals of a plurality of different
subscribers performing the series of business of planning, manufacturing
and selling products and their material to as to be accessible to each
other through a communication line, for suitably retrieving various data
necessary for supporting the business from the integrated database in
accordance with the business requirement of each terminal, and for
outputting data to the terminal to satisfy the requirement, and wherein
the integrated database includes a plan data database for storing at least
data necessary for planning and manufacturing the product and data
necessary for planning and manufacturing the material; a product database
for storing at least data of the production and sales of the product to be
actually sold and data of goods stock of the product; a material database
for storing at least data of the manufacture of material to be used as
goods and stock data of material; and a business history database for
storing at least business history data of the product and business history
data of material.
According to a third aspect of the invention, there is provided a method
for processing data by use of an integrated database, comprising the steps
of forming an integrated database for storing data of a series of business
of planning, manufacturing and selling products produced in many types of
goods and a small quantity and their material; providing a terminal,
connected to the integrated database, for performing the series of
business of planning, manufacturing and selling the products and their
material to a plurality of different subscribers; and suitably retrieving
various data necessary for supporting the business from the integrated
database in accordance with the business requirement of each terminal, and
outputting data to the terminal to satisfy the requirement, and wherein
the integrated database includes a plan data database for storing at least
data necessary for planning and manufacturing the product and data
necessary for planning and manufacturing the material; a product database
for storing at least data of the production and sales of the product to be
actually sold and data of goods stock of the product; a material database
for storing at least data of the manufacture of material to be used as
goods and stock data of material; and a business history database for
storing at least business history data of the product and business history
data of material.
In other words, according to the present invention, there is formed a data
service network in which an integrated database in which various business
data dispersively kept in each part in an apparel industry including plan,
manufacture, and sales relating to a dress as a product and textile raw
material as material is integrated is provided as the nucleus. Then, when
a business instruction is sent from each terminal provided in a plurality
of different subscribers performing the series of business such as a
plurality of sales companies, that of apparel manufacturers, that of
sewing companies or that of textile companies, a database management
system, which is connected to each terminal to be accessible to each other
through a public telephone line, suitably retrieves various data necessary
for supporting the business from a plurality of databases of the
integrated database, and outputs data to satisfy the terminal.
Additional objects and advantages of the invention will be set forth in the
description which follows, and in part will be obvious from the
description, or may be learned by practice of the invention. The objects
and advantages of the invention may be realized and obtained by means of
the instrumentalities and combinations particularly pointed out in the
appended claims.
BRIEF DESCRIPTION OF THE DRAWINGS
The accompanying drawings, which are incorporated in and constitute a part
of the specification, illustrate presently preferred embodiments of the
invention, and together with the general description given above and the
detailed description of the preferred embodiments given below, serve to
explain the principles of the invention.
FIG. 1 is a view showing the structure of a first embodiment of the present
invention in case that the present invention is applied to an apparel
industry;
FIG. 2 is a view showing the outline of data processing by data service
company;
FIG. 3 is a view showing the structure of an integrated database;
FIG. 4 is a flow chart conceptually showing a process of issuing an order
of dresses and a process of supplying dresses, including the processes
ranging from the manufacture of raw material to the sales of the dresses;
FIG. 5 is a flow chart showing steps S1 to S3 of FIG. 4 in more detail;
FIG. 6 is a flow chart showing steps S5 to S7 of FIG. 4 in more detail;
FIG. 7 is a flow chart showing steps S7 to S10 of FIG. 4 in more detail in
a post-dying case;
FIG. 8 is a flow chart showing steps S7 to S10 of FIG. 4 in more detail in
a pre-dying case;
FIG. 9 is a flow chart showing steps S11 to S13 of FIG. 4 in more detail;
FIG. 10 is a flow chart showing steps S4 to S2 of FIG. 4 in more detail;
FIG. 11 is a view explaining how the plan of the dress and that of raw
material are supported by the integrated data base;
FIG. 12 is a view showing the structure of the present invention in a case
that the present invention is applied to a bag (or shoes) industry; and
FIG. 13 is a view showing the structure of an integrated database in a case
that the present invention is applied to the bag (or shoes) industry.
DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS
Embodiments of the present invention will be explained with reference to
the drawings.
FIG. 1 is a view showing the structure of a first embodiment of the present
invention in a case that the present invention is applied to the apparel
industry. In FIG. 1, a data service company 50 is distributed among a
plurality of apparel manufacturers (A, B, C, . . . ) 10, a plurality of
textile companies (A, B, C, . . . ) 20, a plurality of sewing companies
(A, B, C, . . . ) 30, and a plurality of sales companies (A, B, C, . . . )
40, and thereby a data offering service network is expanded. Also, in the
data offering service network, other companies such as a distribution
company and a dying company, which are related to the above-mentioned
companies, can be connected.
In the data service company 50, there is provided a host computer
(integrated database management system) 52 including a computer hardware
and software. The host computer 52 is connected to the apparel
manufacturers 10, the textile companies 20, sewing companies 30, and sales
companies 40 through a public telephone line by use of modems 51A, 51B,
51C, and 51D in order to perform the data communication between the
respective companies and to retrieve and output data from an integrated
database (DB) 53 to be detailed later. Moreover, a work station level
terminal 54 including a keyboard, a high resolution display, a printer, is
connected to the host computer 52, and a scanner 55 is connected to the
terminal 54.
Each apparel manufacturer 10 has a data terminal 12 connected to the host
computer 52 of the data service company 50 by a modem 11. The terminal 12
is a work station level terminal including a keyboard, a high resolution
display, a printer. For example, goods data is displayed on a display
screen 13 by characters, and image data of a textile can be displayed
thereon. Also, a superimposing process can be performed so as to match a
design of a dress prepared by a design CAD.
Each textile company 20 plans the textile and instructs the production of
the textile. Then, similar to the apparel manufacturers 10, in the textile
company 20, there is provided a terminal 22, which is connected to the
host computer 52 of the data service company 50 through the public
telephone line by use of a modem 21A. In the terminal 22, the
superimposing process cannot be performed unlike the terminal 12 of the
apparel company 10, however, a change of a design of the textile, and the
preparation of the textile can be performed.
Moreover, each textile company 20 has production company groups (A, B, C, .
. . ) 60, as their subsidiary companies, including a textile dying company
61, a yarn company 62, a weaving company 63, a textile raw material
company 64, which are related to each textile company 20 through the
public telephone line by use of a modem 21B, and which carry out the
actual production of the textiles. The respective companies 61, 62, 63, 64
have modems 611, 621, 631, 641 and terminals 612, 622, 632, 642. The
textile companies 20 transmit instruction of production to these
production companies on-line, and thereby a real time production is
carried out. In the figure, one company of each type of the production
companies 61 to 64 is typically shown. However, in actuality, each type of
the production companies 61 to 64 often includes a plurality of companies.
Similarly, there is provided a terminal 32, which is connected to the host
computer 52 of the data service company 50 through the public telephone
line by use of a modem 31 in each of sewing companies 30. Also, there is
provided a terminal 42, which is connected to the host computer 52 of the
data service company 50 through the public telephone line by use of a
modem 41A in each of sales companies 40. Moreover, each sales company 40
has shops 70, which actually sells dresses, as a subsidiary. Each shop
also has a modem 71 and a terminal 72, so that sales can be transmitted to
the sales company on-line. In other words, in this case, the terminal 72
of each shop 70 has a POS terminal function.
As shown in FIG. 2, the data service company 50 collects enterprise data of
each of the apparel manufacturers 10, the textile companies 20, sewing
companies 30, sales companies 40, and, depending on the case, production
company groups 60 and shops 70 in the network constructed among these
companies. Then, the data service company 50 processes data to be
converted to second data, and adds general data (e.g., weather forecast,
etc.) to the second data to be converted to third data. In this case,
enterprise data can be classified into general public data (.alpha.),
designated enterprise (customer) public data (.beta.), and subscriber
private data (.gamma.). General public data (.alpha.) is data whose public
offering of data can be recognized by a company, which is a data source.
Designated enterprise public data (.beta.) is data, which may be open to
only companies having a business transaction with the company, which is
the data source. Private data (y) is private data of the company which
cannot be leaked to the other companies. Therefore, when the data service
company 50 offers enterprise data (first data) to each company
(subscriber), it is needed that the range of data available be managed or
data security be maintained. In this embodiment, there is used a method in
which a subscriber is specified by an ID and a password to maintain
security. Or, there may be used a method in which data is offered in the
form of second or third data whose source is made unclear without offering
raw data.
The data service company 50 offers the following services:
1. Data servicing for Apparel Manufacturers
(1) Sales result of self-company: a transaction result counted at real
time;
(2) Entire sales result of the apparel manufacturers in the network: data
of sales (including transactions) result counted by the network;
(3) Entire sales result of the sales related companies in the network: data
of sales counted by the terminal (POS terminal) 72 of each shop 70;
(4) Trend data: Trend data in domestic and overseas;
(5) Data of production companies in the network: introduction data of the
business and goods of the production companies participated in the
network; and
(6) General market and shop front research.
Particularly, security of above services (1), (2), and (3) is needed.
2. Data servicing for sales related companies
(1) Sales result of self-company: a transaction result counted at real time
by the terminal (POS terminal) 72 of each shop 70 belonging to the
self-company;
(2) Entire sales result of the sales related companies in the network:
sales data counted by the terminal (POS terminal) 72 of each shop 70 in
the network;
(3) Trend data: Trend data in domestic and overseas;
(4) General market and shop front research; and
(5) Introduction of the apparel manufacturers in the network: introduction
data of the goods of the apparel manufacturers participating in the
network and brand names.
Particularly, security of above services (1) and (2) is needed.
3. Data servicing for textile plan
(1) General data: data of other than the fashion such as politics, economy,
culture and customs, weather, environment, etc.;
(2) Trend data in clothes: technical data of color, textile, and style;
(3) Consumer data: data of customers;
(4) Market data: market data of other than consumer data;
(5) Data of sales result: sales data of self-company and other companies;
and
(6) Other data.
Particularly, security of above services (3), (4), and (5) is needed.
As shown in FIG. 3, the integrated database (DB) 53 of the data service
company 50 available for obtaining the above-mentioned services comprises
a production data DB 531, a plan data DB 532, an apparel DB 533, a textile
DB 534, a transaction DB 535, a management support DB 536, and a work DB
537.
The production data DB 531 comprises a sewing DB 531A, a sewing production
management DB 531B, a member DB 531C, and a member production management
DB 531D. The sewing DB 531A is a database in which various data of product
processes of manufacturing dresses is stored. The sewing production
management DB 531B is a database in which data of a working load sate of
each sewing company is stored. The member DB 531C is a database in which
various processing data necessary for manufacturing textiles is stored.
The member production management DB 531D is a database in which data of a
process load state of each of the production companies such as the yarn
company, dying company, sewing company is stored. It is noted that other
various data relating to the manufacturing process of sub-materials such
as buttons, ribbons, etc., dyestuffs, process ability, and the like is
stored in the production data DB 531.
The plan data DB 532 comprises an apparel plan DB 532A, a textile plan DB
532B, and a general data DB 532C. The apparel plan DB 532A is a database
in which necessary data for planing and manufacturing the apparel is
stored.
The textile plan DB 532B is a database in which necessary data for planing
and manufacturing textiles is stored. For example, data necessary for
producing the textiles such as a goods code, necessary material,
processing step, company dealing in textiles, security level, and the
like, is stored in the textile plan DB 532B. In this case, the security
level is data showing the classification of general public data (.alpha.),
designated enterprise public data (.beta.), and subscriber private data
(.gamma.). Therefore, if designated enterprise public data (.beta.) is
set, data for specifying the designated subscriber is of course recorded.
The textile company 20 makes the production plan based on data retrieved
from the textile plan DB 532B, and instructs the production company group
60 of their subsidiary to start the production of the textile.
The general data DB 532C is a database in which various types of data of
the daily life such as life style, moves, the mass media, that is, data of
other than data directly concerning to the dresses and textiles, is
stored. In the general data DB 532C, there is also stored general data
such as a stock market, movement of exchange, the production of silk in a
foreign producing center, the production of wool and the like.
The apparel DB 533 comprises an apparel design DB 533A, an apparel goods DB
533B, an apparel stock DB 533C. The apparel DB 533 is a database, which is
expanded in more detail to concentrate on the manufacture of the dresses.
The apparel design DB 533A is a database in which design data of what
dress is designed is stored. The apparel goods DB 533B is a database in
which data relating to the production and sales of goods is stored. In
this case, it is the goods, that is, the dresses, which are actually
manufactured, exhibited to be on sale. In other words, the dresses, which
are designed from the designs stored in the apparel design DB 533A, and
produced on a commercial basis. That is, the goods to which a goods code
is added to be ready to be on sale. The above-mentioned includes data of
what dress is designed, what textile is used, and what sewing process is
carried out. The apparel stock DB 533C is a database in which goods in
stock are stored. In this case, goods in stock include the stock, which
the sales company 40 or apparel manufacturer 10 has, and goods in process,
which the sewing company 30 has.
Regarding data of these apparel goods DB 533B and apparel stock DB 533C,
similar to the textile plan DB 532B, the access of each subscriber is
needed to be limited in accordance with the security level. That is, it is
needed that the security is fully considered and that the necessary data
is obtained. For example, an ID number of the company is used as a key,
and the security must be maintained based on the individual data of the
company relating to what business transaction the company has.
The textile DB 534 is a database, which is expanded in more detail to
concentrate on the manufacture of the textiles. The textile DB 534
comprises a textile design DB 534A, a textile goods DB 534B, and a textile
stock DB 534C. The textile design DB 534A is a database in which design
data of what pattern of textile is manufactured is stored. For example,
the textile DB 534A stores an item code and static image data of the
textile are stored item by item of the registered textiles. The textile
goods DB 534B is a database in which various data necessary for
manufacturing the textile for goods, such as a price, a production result,
etc. is stored. More specifically, the textile goods DB 534B stores an
item code and data relating to the textile such as a selling period,
target season, color, pattern, raw material, type of weaving, condition of
order, standard price, company dealing in the textile, etc., item by item
as character data. The textile stock DB 534C is a database storing data of
the stock of the textile company 20, and goods in process of each of the
textile dying company 61, yarn company 62, weaving company 63, and the
stock of the apparel manufacturer 10. Similar to the apparel stock DB
533C, it is needed that necessary data is fetched from the ID number and
the record of the mutual business relation in the range, which does not
deviate from the security level, in accordance with the security set item
by item.
The transaction DB 535 carries out a due date management and an electronic
settlement of accounts. The transaction DB 535 comprises an apparel
receiving and issuing order DB 535A, an apparel physical distribution
management DB 535B, a textile receiving and issuing order DB 535C, and a
textile physical distribution management DB 535D. The apparel receiving
and issuing order DB 535A is a database in which transaction history data
of the apparel is stored. The textile receiving and issuing order DB 535C
is a database in which transaction history data of the textile is stored.
The textile receiving and issuing order DB 535C sequentially inputs and
renews the quantity of the textiles every time when the order is received
and issued or canceled every item code. Also, the security level relating
to business result data of the textile is recorded therein.
The management support DB 536 is used to serve second data, which is
various types of data necessary for the actual management plane or
management decision, and which is obtained by processing various types of
databases, and process data, that is, third data, which the data service
company 50 analyzes in their own analysis method, in other words, data
whose source becomes unclear. The management support DB 536 comprises an
apparel sales analysis DB 536A, a textile sales analysis DB 536B, an
enterprise data DB 536C, and a business estimation DB 536D. The apparel
sales analysis DB 536A is a database storing data of which the sales of
the apparel is analyzed. The textile sales analysis DB 536B is a database
storing which of the sales of the textile are analyzed. The enterprise
data DB 536C is a database storing data of the business state of each
enterprise and the transaction state.
The work DB 537 is a database to be used as a work memory for temporarily
storing various data, which is necessary when the host computer 52
(integrated database management system) executes various processes.
According to the above-mentioned structure, the following will explain how
the integrated data base 53 supports a process of issuing an order of
dresses and a process of supplying dresses, including the processes
ranging from the manufacture of raw material to the sales of the dresses.
FIG. 4 is a flow chart conceptually showing the process of issuing an order
of dresses and the process of supplying dresses, including the processes
ranging from the manufacture of raw material to the sales of the dresses.
In accordance with issue order processing by the shop 70 (step S1), the
sales company 40 asks the apparel manufacturer 10 to make arrangements for
the purchase of dress through data service company 50 (integrated DB 53)
(step S2).
The apparel manufacturer 10 negotiates with the sales company 40 and
receives the order of the dress through data service company 50
(integrated DB 53) (step S3). Then, if there is the stock of the dress
(step S4), the apparel manufacturer 10 ships the dress to the sales
company. If there is no stock of the dress, the apparel manufacturer 10
checks the stock of the raw material (step S5). If there is no stock of
the raw material, the apparel manufacturer negotiates with the textile
company 20 about issuing the order of the raw material through data
service company 50 (integrated DB 53) (step S6).
The textile company 20 negotiates with the apparel manufacturer 10 about
receiving the order of the raw material through data service company 50
(integrated DB 53) (step S7). If the negotiation is concluded, the textile
company 20 asks the textile dying company 61, yarn company 62, and weaving
company 63 to make arrangements for processing (step 8). If the raw
material is completed, processing for shipping raw material such as
transmission of necessary data to the apparel manufacturer 10 through data
service company 50 (integrated DB 53) is performed (step S9), and the
completed raw material is shipped to the apparel manufacturer 10.
If the apparel manufacturer 10 receives the raw material and data from the
textile company 20, necessary processing for supplying raw material is
performed (step S10). Then, the apparel manufacturer 10 negotiates with
the sewing company 30 through the data service company 50 (integrated DB
53) (step S11).
The sewing company 30 sews the dress by use of the raw material supplied
from the apparel manufacturer 10 in accordance with processing data sent
through the data service company 50 (integrated DB 53) (step S12). If the
dress is completed, processing for shipping the dress, such as
transmission of necessary data to the apparel manufacturer 10 through the
data service company 50 (integrated DB 53), is performed and the completed
dress is shipped to the apparel manufacturer 10.
If the apparel manufacturer 10 receives dress and data from the sewing
company 30, the apparel manufacturer 10 performs necessary processing for
supplying dress and processing for shipping dress to the sales company 40
(step S13). Then, dress is sent to the sales company 40 and necessary data
is sent to the sales company 40 through the data service company 50
(integrated DB 53).
If the sales company 40 receives the dress and data from the apparel
manufacturer 10, the sales company 40 performs necessary processing for
supplying dress and carries the dress to the shop 70 by which the dress is
ordered, and the dress is sold at the shop 70 (step S14).
The above steps S1 to S3 will be explained in more detail with reference to
FIG. 5 as follows:
Data of the sales activity of each shop 70 is inputted and recorded in the
terminal 72 having the POS terminal function (step S21). Data is stored in
a local database of the corresponding shop 70, and is used in the sales
management of the shop 70, financial management, analysis of good seller
dress and that of bad seller dress, etc.
Each shop 70 checks the sales activity every fixed pe | | |
