Summary of the invention
It is lower that the present invention aims to provide a kind of operating cost, the inventory data in the commodity transaction data that the retail trader that can handle general headquarters and various places in real time by main office and different order merchants carry out, the warehouse of various places is gone forward side by side the crudely-made articles amount of money according to the remote sale data handling system of clearing with based on the distributed merchandise sales of this remote sale data handling system, and the centralized management document is manufactured, the remote sale data processing method of the data processing of stock's allotment, credit management, financial process.
The objective of the invention is to realize by following scheme: the remote sale data handling system is characterized in that: this system comprises the Remote Management of Network subsystem realization LAN (Local Area Network) of an online at any time and being connected of public internet, the central server that operating system and relevant database are installed that is located at general headquarters, a plurality ofly be located at general headquarters' workstation that general headquarters are connected with central server by LAN (Local Area Network), a plurality ofly be located at distribution point workstation that various places retail trader place is connected with central server by public internet and be located at the warehouse workstation that the warehouse, various places is connected with central server by public internet with a plurality of; Described relevant database comprises general headquarters' accounts subdata base, a plurality of each distribution point accounts subdata base and uses sale in the above-mentioned subdata base, finance and stock's data to carry out the application management software of associative operation; Each general headquarters' workstation, each distribution point workstation and each warehouse workstation are equipped with the printer by the application management software control of above-mentioned relation type database.
Described each general headquarters' workstation is equipped with the terminal-emulation software of central server, and each general headquarters' workstation is connected with the client/server connected mode with central server by LAN (Local Area Network).
Perhaps, described central server is equipped with the browser simulation software, automatically download this browser simulation software when each general headquarters' workstation is logined central server by LAN (Local Area Network), realize that each general headquarters' workstation is connected with the browser/server connected mode with central server by LAN (Local Area Network).
Described each distribution point workstation and each warehouse workstation are equipped with the terminal-emulation software of central server, and each distribution point workstation is connected with the client/server connected mode with central server by public internet with each warehouse workstation.
Perhaps, described central server is equipped with the browser simulation software, automatically download this browser simulation software when each distribution point workstation and each warehouse workstation are logined central server by public internet, realize that each distribution point workstation is connected with the browser/server connected mode with central server by public internet with each warehouse workstation.
Described central server is connected with public internet by fire wall.
The remote sale data processing method is characterized in that: the remote sale system of employing comprises that the Remote Management of Network subsystem of an online at any time is realized being located at being connected of LAN (Local Area Network) and public internet, one central server that operating system and relevant database are installed of general headquarters, a plurality ofly is located at general headquarters' workstation that general headquarters are connected with central server by LAN (Local Area Network), a plurality of various places retail trader that is located at locates the distribution point workstation that is connected with central server by public internet and is located at the warehouse workstation that the warehouse, various places is connected with central server by public internet with a plurality of; Described relevant database comprises general headquarters' accounts subdata base, a plurality of each distribution point accounts subdata base and uses sale in the above-mentioned subdata base, finance and stock's data to carry out the application management software of associative operation; Each general headquarters' workstation, each distribution point workstation and each warehouse workstation are equipped with the printer by the application management software control of above-mentioned relation type database; The application management software of each general headquarters' workstation by LAN (Local Area Network) and central server relevant database and the character type page of general headquarters' accounts subdata base swap operation order and data relevant with sale, finance and stock; Each distribution point workstation by public internet and central server relevant database application management software and general headquarters' accounts subdata base and the swap operation order of this distribution idea database and sell the character type page of relevant data with this distribution point; Application management software and general headquarters accounts subdata base swap operation order and with this warehouse inventory character type page of relevant data of each warehouse workstation by public internet and central server relevant database; All associative operations that relate to sale, finance and the inventory data of general headquarters' accounts subdata base and each distribution point subdata base focus on by the application management software of central server co-relation type database; Form, document that all each general headquarters' workstations, each distribution point workstation and each warehouse workstation requirement are printed print by the printer of this workstation of application management software control of central server co-relation type database.
After any general headquarters' workstation is realized being connected by LAN (Local Area Network) and central server, can obtain the interface of spendable order of this general headquarters' workstation that the application management software by relevant database provides and the every data item corresponding with each order, this general headquarters' workstation can be selected the order in this interface and import to submit to central server with the character type page that the numerical value composition of the corresponding every data item of this order contains operational order and data relevant with sale, finance and stock and operate accordingly in relevant database; After any distribution point workstation is realized being connected by public internet and central server, can obtain the interface of spendable order of this distribution point workstation that the application management software by relevant database provides and the every data item corresponding with each order, the character type page that this distribution point workstation can select the numerical value composition of the corresponding every data item of order in this interface and input and this order to contain operational order and data relevant with the sale of this distribution point is submitted to central server and is operated accordingly in relevant database; After any warehouse workstation is realized being connected by public internet and central server, can obtain the interface of spendable order of this warehouse workstation that the application management software by relevant database provides and the every data item corresponding with each order, this warehouse workstation can select the order in this interface and import contain operational order with the numerical value composition of the corresponding every data item of this order and with this warehouse inventory the character type page of relevant data submit to central server and in relevant database, operate accordingly.
When the character type page that each general headquarters' workstation, each distribution point workstation and each warehouse workstation are submitted to central server contained more than one order, central server fed back to the workstation of submitting this character type page to the execution result that batch processing mode finishes after the corresponding operation of each order just each order in relevant database.
The client of various places and various places retail trader signing order, described various places retail trader sends the character type page of the data that contain order log on command and sales order by public internet to central server with this distribution point workstation, by the application management software of central server co-relation type database at general headquarters' accounts subdata base and this distribution point accounts subdata base login order; In general headquarters' accounts subdata base, generate the corresponding invoice of withdrawals of this order, send the character type page of the data that contain invoice of withdrawals print command and invoice of withdrawals by public internet to this distribution point workstation, control this invoice of withdrawals of printer prints of this distribution point workstation; The client gives with this invoice of withdrawals in this retail trader, the client holds this invoice of withdrawals after the delivery of cargo of appointment warehouse, this warehouse sends the character type page of the data contain warehouse delivery of cargo log on command and this invoice of withdrawals by public internet to central server with this warehouse workstation, logins this invoice of withdrawals by the application management software of central server co-relation type database at general headquarters' accounts subdata base and picks up goods; This retail trader handles financial formality with regard to this order and this invoice of withdrawals to general headquarters after client's delivery of cargo, send the character type page of the data that contain financial log on command and this order and this invoice of withdrawals by LAN (Local Area Network) to central server by general headquarters' workstation of treasurer's department of general headquarters, do the finance login of this order and this invoice of withdrawals by the application management software of central server co-relation type database at general headquarters' accounts subdata base; In general headquarters' accounts subdata base, generate the corresponding invoice for sales of this order and this invoice of withdrawals, and send the character type page of the data that contain printing invoice order and invoice for sales to the general headquarters workstation of this treasurer's department of general headquarters by LAN (Local Area Network), control this invoice for sales of printer prints of general headquarters' workstation of this treasurer's department of general headquarters.
Client and sales department of general headquarters signing order, sales department of general headquarters sends the character type page of the data that contain general headquarters' order log on command and sales order to central server by LAN (Local Area Network) with general headquarters' workstation of this department, application management software by central server co-relation type database is logined order at general headquarters' accounts subdata base, in general headquarters' accounts subdata base, generate the corresponding invoice of withdrawals of this order, send the character type page of the data that contain invoice of withdrawals print command and invoice of withdrawals by LAN (Local Area Network) to the general headquarters workstation of this department, control general headquarters' work station printer of this department and print this invoice of withdrawals; The client gives with this invoice of withdrawals in this department, the client holds this invoice of withdrawals after the delivery of cargo of appointment warehouse, this warehouse sends the character type page of the data contain warehouse delivery of cargo log on command and this invoice of withdrawals by public internet to central server with this warehouse workstation, logins this invoice of withdrawals by the application management software of central server co-relation type database at general headquarters' accounts subdata base and picks up goods; Sales department of general headquarters handled financial formality with regard to this order and this invoice of withdrawals to general headquarters after the client picked up goods, send the character type page of the data that contain financial log on command and this order and this invoice of withdrawals to central server by LAN (Local Area Network) by general headquarters' workstation of treasurer's department of general headquarters, do the finance login of this order and this invoice of withdrawals at general headquarters' accounts subdata base by the application management software of central server co-relation type database, in general headquarters' accounts subdata base, generate the corresponding invoice for sales of this order and this invoice of withdrawals, and send the character type page of the data that contain printing invoice order and invoice for sales to the general headquarters workstation of this treasurer's department of general headquarters by LAN (Local Area Network), control this invoice for sales of printer prints of general headquarters' workstation of this treasurer's department of general headquarters.
Described application of software data storehouse also comprises the application software of credit control, the application software of this credit control is checked this retail trader and this client's credit rating when this distribution point accounts subdata base of central server is logined order by public internet with this distribution point workstation in retail trader, if report to the police, then point out the order of retail trader's modification login to continue to send the character type page that contains the data of revising log on command and modification by public internet to central server, login order at this distribution point accounts subdata base by the application management software of central server co-relation type database with this distribution point workstation; Then, this order of login in general headquarters' accounts subdata base, at this moment, the application software of this credit control is this retail trader of verification and this client's credit rating once more, if can not pass through, then the application software of this credit control sends the character type page of the data that contain Request Processing order and sales order verification by LAN (Local Area Network) to general headquarters' workstation of credit management department of general headquarters, delivers credit management department of general headquarters and handles this order; This order will be deleted at general headquarters' accounts subdata base and this distribution point accounts subdata base for this order business that will not carry out by credit management department of general headquarters, and stop subsequent operation; For this order business that can consider to grant execution, adjust this retail trader and this client's credit line, call the application software of credit control again and carry out the credit rating verification; Credit management department of general headquarters sends the character type page that contain processing command and deal with data by LAN (Local Area Network) to central server with its general headquarters' workstation, carries out this processing command by the application management software of central server co-relation type database; After the credit rating verification, in general headquarters' accounts subdata base, generate the corresponding invoice of withdrawals of this order and send the character type page of the data that contain invoice of withdrawals print command and invoice of withdrawals to this distribution point workstation by the application management software of central server co-relation type database, control this distribution point workstation of printer of this distribution point workstation and print this invoice of withdrawals by public internet.
Described application of software data storehouse also comprises the application software of credit control, the application software of this credit control is checked this client's credit rating when general headquarters' accounts subdata base of central server is logined order by LAN (Local Area Network) with general headquarters' workstation of this department in sales department of general headquarters, if report to the police, then point out the order of sales department of general headquarters modification login to continue to send the character type page that contains the data of revising log on command and modification by LAN (Local Area Network) to central server, login order at general headquarters' accounts subdata base by the application management software of central server co-relation type database with general headquarters' workstation of this department; Then, the application software of this credit control is this client's of verification credit rating once more, if can not pass through, then the application software of this credit control sends the character type page of the data that contain Request Processing order and sales order verification by LAN (Local Area Network) to general headquarters' workstation of credit management department of general headquarters, delivers credit management department of general headquarters and handles this order; This order will be deleted at general headquarters' accounts subdata base for this order business that will not carry out by credit management department of general headquarters, and stop subsequent operation; For this order business that can consider to grant execution, adjust this client's credit line, call the application software of credit control again and carry out the credit rating verification.Credit management department of general headquarters sends the character type page that contain processing command and deal with data by LAN (Local Area Network) to central server with its general headquarters' workstation, carries out this processing command by the application management software of central server co-relation type database; After the credit rating verification, generate the corresponding invoice of withdrawals of this order and send the character type page of the data that contain invoice of withdrawals print command and invoice of withdrawals to general headquarters' workstation of this department at general headquarters' accounts subdata base by the application management software of central server co-relation type database, control general headquarters' work station printer of this department and print this invoice of withdrawals by LAN (Local Area Network).
The method of the application software check of described credit control or verification distribution point or client's credit rating is:
A. send the character type page that contain credit log on command and credit data by LAN (Local Area Network) to central server with general headquarters' workstation by credit management department of general headquarters, login client's credit line separately of each distribution point and its subordinate's the shop fixtures distribution of selling on credit, fix a point by the application management software of central server co-relation type database at each distribution point accounts subdata base respectively;
B. for this distribution point of each Order Checking or client:
A. the delivery of cargo amount of money of this order>(credit line one current accounts receivable)?
B. is there there the accounts receivable of exceeding the time limit?
C. sell the client on credit and the current period do not come money;
If in above-mentioned three an establishment is arranged, then when check, report to the police, when verification, can not pass through.
Agreeing the client when retail trader returns goods, described various places retail trader sends the character type page that contains Return Application log on command and Return Application data with this distribution point workstation by public internet to central server, application management software by central server co-relation type database is logined the Return Application list at general headquarters' accounts subdata base and this distribution point accounts subdata base, in general headquarters' accounts subdata base, generate the returning note of this Return Application list, send the character type page of the data that contain returning note print command and invoice of withdrawals by public internet to this distribution point workstation, control this returning note of printer prints of this distribution point workstation; The client gives with this returning note in this retail trader, the client holds this returning note behind the appointment warehouse return of goods, this warehouse sends the character type page of the data contain warehouse return of goods log on command and this returning note by public internet to central server with this warehouse workstation, logins this returning note by the application management software of central server co-relation type database at general headquarters' accounts subdata base and returns goods; This retail trader handled financial formality with regard to this Return Application list and this returning note to general headquarters after the client returned goods, send the character type page of the data that contain financial return of goods log on command and this Return Application list and this returning note to central server by LAN (Local Area Network) by general headquarters' workstation of treasurer's department of general headquarters, do the finance login of this Return Application list and this returning note at general headquarters' accounts subdata base by the application management software of central server co-relation type database, in general headquarters' accounts subdata base, generate the correspondence return of goods invoice of this Return Application list and this returning note, and sending the character type page of the data that contain order of return of goods printing invoice and return of goods invoice to the general headquarters workstation of this treasurer's department of general headquarters by LAN (Local Area Network), the printer prints of controlling general headquarters' workstation of this treasurer's department of general headquarters should return of goods invoice.
Agreeing the client when sales department of general headquarters returns goods, sales department of general headquarters sends the character type page that contains general headquarters' return of goods log on command and Return Application data with general headquarters of this department workstation by LAN (Local Area Network) to central server, application management software by central server co-relation type database is logined the Return Application list at general headquarters' accounts subdata base, in general headquarters' accounts subdata base, generate the returning note of this Return Application list, send the character type page of the data that contain invoice of withdrawals print command and invoice of withdrawals, this returning note of printer prints of general headquarters' workstation of sales department of control general headquarters by LAN (Local Area Network) to the general headquarters workstation of this department; The client gives with this returning note in this department, the client holds this returning note behind the appointment warehouse return of goods, this warehouse sends the character type page of the data contain warehouse return of goods log on command and this returning note by public internet to central server with this warehouse workstation, logins this returning note by the application management software of central server co-relation type database at general headquarters' accounts subdata base and returns goods; Sales department of general headquarters handled financial formality with regard to this Return Application list and this returning note to general headquarters after the client returned goods, send the character type of the data that contain financial return of goods log on command and this Return Application list and this returning note to central server by LAN (Local Area Network) by general headquarters' workstation of treasurer's department of general headquarters, do the finance login of this Return Application list and this returning note at general headquarters' accounts subdata base by central server, in general headquarters' accounts subdata base, generate the correspondence return of goods invoice of this Return Application list and this returning note, and sending the character type page of the data that contain order of return of goods printing invoice and return of goods invoice to the general headquarters workstation of this treasurer's department of general headquarters by LAN (Local Area Network), the printer prints of controlling general headquarters' workstation of this treasurer's department of general headquarters should return of goods invoice.
When delivering to the warehouse, various places in the general headquarters warehouse, send to central server by LAN (Local Area Network) with its general headquarters' workstation by storehouse management department of general headquarters and to contain the character type page that moves storehouse application log on command and move the storehouse request for data, application management software by central server co-relation type database moves the storehouse request slip in general headquarters' accounts subdata base login, in general headquarters' accounts subdata base, generate this move the storehouse request slip to move the storehouse single, send to contain to the general headquarters workstation of this department by LAN (Local Area Network) and move the character type page that the storehouse singles print order and move the data of storehouse list, general headquarters' workstation of storehouse management department of control general headquarters is printed this, and to move the storehouse single; Storehouse management department of general headquarters will move the storehouse single cross and give transportation department, transportation department holds and moves the storehouse list from general headquarters' warehouse delivery of cargo, the general headquarters warehouse contains the character type page that warehouse move storehouse log on command and move database data by LAN (Local Area Network) to the central server transmission with its general headquarters' workstation, login this stock that moves the storehouse list by the application management software of central server co-relation type database at general headquarters' accounts subdata base and shift out, actual quantity issued general headquarters warehouse from general headquarters' accounts subdata base is moved into the warehouse, destination accordingly on way location under the library item; After receiving in the warehouse, destination, warehouse workstation with ware-house here contains the character type page that the warehouse moves the storehouse log on command and moves database data by public internet to the central server transmission, logins this stock that moves the storehouse list by the application management software of central server co-relation type database at general headquarters' accounts subdata base and moves into the warehouse, destination by corresponding warehouse in transit.
When delivering to other warehouse in the warehouse, various places, provide accent goods outbound list by storehouse management department of general headquarters, transportation department holds and transfers goods outbound list to pick up goods from the shipping room, the shipping room contains warehouse accent goods outbound log on command and transfers goods to go out the character type page of database data to the central server transmission by public internet with its warehouse workstation, the stock of logining this accent goods outbound list at general headquarters' accounts subdata base by the application management software of central server co-relation type database shifts out, and actual quantity issued shipping room from general headquarters' accounts subdata base is moved into the warehouse, destination accordingly on way location under the library item; After receiving in the warehouse, destination, the warehouse, destination is that the warehouse workstation by ware-house here in warehouse stationed abroad passes through public internet, the warehouse, destination is that the general headquarters' workstation by the general headquarters warehouse in general headquarters warehouse passes through LAN (Local Area Network), send the character type page that contains warehouse accent goods warehouse-in login log on command and shipment data to central server, the stock of logining this accent goods outbound list at general headquarters' accounts subdata base by the application management software of central server co-relation type database moves into the warehouse, destination by corresponding warehouse in transit.
The Remote Management of Network subsystem realization LAN (Local Area Network) of an online at any time of employing of remote sale data handling system of the present invention and being connected of public internet, the central server that operating system and relevant database are installed that is located at general headquarters, a plurality ofly be located at general headquarters' workstation that general headquarters are connected with central server by LAN (Local Area Network), a plurality ofly be located at distribution point workstation that various places retail trader place is connected with central server by public internet and be located at the warehouse workstation that the warehouse, various places is connected with central server by public internet with a plurality of; Guarantee the shared system server in general headquarters, various places retail trader and warehouse, various places from system environments---central server, a cover operating system software, a data library software; For the centralized management decentralized management, provide the assurance of hardware environment.The distribution point workstation that is dispersed in various places is connected exchange message by public internet with central server with the warehouse workstation, and operating cost is lower than rents DDN special line and satellite circuit or use the toll communication mode.Its database software internal separation becomes general headquarters' accounts subdata base, each distribution point accounts subdata base, form the independent environment of operation of general headquarters, various places retail trader, the background process of all sale, finance and inventory data is all carried out on central server, and the form that all each workstation requirements are printed, the printer that document is controlled this workstation by central server print; Realize concentrating and the distributed parallel management of data, real-time property is strong, has strengthened general headquarters to the sale of various places retail trader and the direct management of finance and warehouse inventory, and the efficient height.Two kinds of internetwork connection modes of this system compatible client/server and browser/server are convenient in the new workstation connecting system.Central server is connected with public internet by fire wall, can prevent effectively that other people from disturbing by public internet or the destruction native system, and security of system is good.Above-mentioned remote sale data processing method is utilized application management software, general headquarters accounts subdata base or each the distribution point accounts subdata base swap operation order of each workstation by LAN (Local Area Network) or public internet and the relevant database of central server and the character type page of data relevant with sale, finance and stock; This data exchange ways by character type page tissue, the time of each character type page transmission is short, not only speed is fast, also can prevent loss of data or error code that reasons such as Computer Processing interruption cause, is particularly conducive to the background process at the enterprising line data of central server.After any workstation is realized being connected by network and central server, can obtain the interface of spendable order of this workstation that the application management software by relevant database provides and the every data item corresponding with each order, this workstation can be selected the order in this interface and import to submit to central server with the character type page that the numerical value composition of the corresponding every data item of this order contains operational order and data relevant with sale, finance and stock and operate accordingly in relevant database; Thisly limit the spendable order of each workstation and order the practice of corresponding every data item with each with the interface form, each workstation operator can directly select the order that will use, and fill in each rapidly and order corresponding every data item, formation contains the character type page of operational order and data relevant with sale, finance and stock and submits to central server, make simple to operate, standard; On the one hand simplified operation person's training can prevent operator's violation operation of going beyond one's commission on the other hand again, strengthens level security.The character type page that each workstation is submitted to central server can contain a plurality of orders, and central server finishes the corresponding operation of each order with batch processing mode and just the execution result of each order fed back to the workstation of submitting this character type page to afterwards in relevant database; Make full use of the backstage high speed processing ability of central server, reduce network communication, meet fast job requirement efficiently.Organize the various specific implementation methods of remote sale, finance and inventory data processing by above-mentioned character type page formula data exchange ways, running is independently sold by concrete general headquarters and the various places retail trader of guaranteeing, general headquarters directly manage and monitor operation flow and finance and the stock in the marketing activity of various places retail trader again.And then general headquarters are foundation with instant Exact Number, and the trend that prediction is sold can effectively reduce affiliated institutions' commodity stocks amount, reduce the fund occupancy volume; Reliable database information support is arranged, and general headquarters can grasp the history of each client traffic contact, closely with the relation of ordering goods and discussing; Improve the level of general headquarters to inner and external management.
Embodiment
The structure of an embodiment of remote sale data handling system of the present invention sees also Fig. 1.This system establishes a central server 1 in Xiamen general headquarters; in the LAN (Local Area Network) 2 of general headquarters, comprise the Remote Management of Network subsystem realization LAN (Local Area Network) 2 of an online at any time and being connected of public internet 5; general headquarters also are provided with the fire wall 4 of a protection system data security, and central server 1 is connected with public internet 5 by fire wall 4.The type of central server 1 is selected IBMAS/400 for use.Treasurer's department, sales department, storehouse management department, general headquarters warehouse, credit management department and integrated management department in general headquarters are respectively equipped with general headquarters' workstation 3, in Beijing, various places retail trader places such as Shanghai, Wuhan and Foochow are provided with a distribution point workstation 6 respectively, are respectively equipped with a warehouse workstation 7 in the warehouse of above-mentioned various places.General headquarters' workstation 3, distribution point workstation 6 and warehouse workstation 7 are equipped with PC and printer.
Each general headquarters' workstation 3 is connected with central server 1 by LAN (Local Area Network) 2.Central server 1 compatible two kinds of connected modes.A kind of connected mode is: general headquarters' workstation 3 is equipped with the terminal-emulation software of central server 1, and this general headquarters' workstation 3 is connected with the client/server connected mode with central server 1 by LAN (Local Area Network) 2.Another kind of connected mode is: central server 1 is equipped with the browser simulation software, general headquarters' workstation 3 is downloaded this browser simulation software by LAN (Local Area Network) 2 login central server 1 time automatically, realizes that this general headquarters' workstation 3 is connected with the browser/server connected mode with central server 1 by LAN (Local Area Network) 2.
Each distribution point workstation 6 is connected with central server 1 by public internet 5 with warehouse workstation 7.The also compatible two kinds of connected modes of central server 1.A kind of connected mode is: distribution point workstation 6 or each warehouse workstation 7 are equipped with the terminal-emulation software of central server 1, and this distribution point workstation 6 or warehouse workstation 7 are connected with the client/server connected mode with central server 1 by public internet 5.Another kind of connected mode is: central server 1 is equipped with the browser simulation software, distribution point workstation 6 or warehouse workstation 7 are downloaded this browser simulation software by public internet 5 login central server 1 time automatically, realize that this distribution point workstation 6 or warehouse workstation 7 are connected with the browser/server connected mode with central server 1 by public internet 5.
An one cover operating system and a cover relevant database are installed in the central server 1.This relevant database comprises general headquarters' accounts subdata base, a plurality of each distribution point accounts subdata base and uses sale in the above-mentioned subdata base, finance and stock's data to carry out the application management software of associative operation.The printer of each workstation 3,6,7 is printed by the application management software control of this relevant database.
An embodiment of remote sale data processing method of the present invention carries out networked online treatment to the sale of above-mentioned remote sale data handling system, finance and stock's data.Comprise sales management software, financial management software and stock control software in the application management software of relevant database.Sales management software is provided with a plurality of operational orders and respectively the sale of the distribution point of various places and sales department of general headquarters and the sales data of return of goods activity is carried out typing and processing in general headquarters' accounts subdata base and this distribution point accounts subdata base project.The financial data of the sale of the distribution point of financial management software and various places and sales department of general headquarters and return of goods activity carries out typing and processing in general headquarters' accounts subdata base project.Stock control software respectively is provided with a plurality of operational orders the inventory data of the commodity inbound/outbound process activity in the warehouse of various places and general headquarters warehouse is carried out typing and processing in general headquarters' accounts subdata base project.System specifies each general headquarters' workstation 3, each distribution point workstation 6 and warehouse workstation 7 to use operational order and the authority of general headquarters' accounts subdata base or each distribution point accounts subdata base swap data and the authority of printing document under the management of relevant database of above-mentioned sales management software or financial management software or stock control software.
The application software of credit control is set in the sales management software specially, and the merchandise sales activity data that the shop fixtures of selling on credit, fix a point of the distribution point of various places and sales department of general headquarters is promoted isotype is handled in general headquarters' accounts subdata base and this distribution point accounts subdata base project especially.The method of the application software check of credit control or verification distribution point or client's credit rating is:
A. login client's credit line separately of each distribution point and the shop fixtures distribution of selling on credit, fix a point to the central server transmission order page and page of data by LAN (Local Area Network) with the application operating software of general headquarters' workstation by credit management department of general headquarters;
B. for this distribution point of each Order Checking or client:
A. the delivery of cargo amount of money of this order>(credit line one current accounts receivable)?
B. is there there the accounts receivable of exceeding the time limit?
C. sell the client on credit and the current period do not come money;
If in above-mentioned three an establishment is arranged, then when check, report to the police, when verification, can not pass through.
The application management software of each general headquarters' workstation 3 by LAN (Local Area Network) 2 and central server 1 relevant database and the character type page of general headquarters' accounts subdata base swap operation order and data relevant with sale, finance and stock; Application management software and general headquarters accounts subdata base swap operation order and with this warehouse inventory character type page of relevant data of each warehouse workstation 7 by public internet 5 and central server 1 relevant database; All operation processing in the project of general headquarters' accounts subdata base of the data that each general headquarters' workstation 3 and warehouse workstation 7 take place.The application management software of each distribution point workstation 6 by public internet 5 and central server 1 relevant database and the character type page of general headquarters' accounts subdata base and the swap operation order of this distribution idea database and data relevant with the sale of this distribution point; Then operation processing in the project of general headquarters' accounts subdata base and this distribution point accounts subdata base of the data that each distribution point workstation 6 takes place.All associative operations that relate to sale, finance and the inventory data of general headquarters' accounts subdata base and each distribution point subdata base of each general headquarters' workstation 3, each distribution point workstation 6 and warehouse workstation 7 carry out the backstage by the application management software of central server 1 co-relation type database and focus on.After form, the document that all each general headquarters' workstations 3, each distribution point workstation 6 and each warehouse workstation 7 require to print all needs to generate, submit the character type page that contains printing order and relevant data to by this workstation in general headquarters' accounts subdata base; Printer by this workstation of application management software control of central server 1 co-relation type database prints.
After any general headquarters' workstation 3 passes through LAN (Local Area Network) 2 and central server 1 is realized being connected, can obtain the interface of these general headquarters' workstation 3 spendable orders that the application management software by relevant database provides and the every data item corresponding with each order, this general headquarters' workstation 3 can be selected the order in this interface and import to submit to central server 1 with the character type page that the numerical value composition of the corresponding every data item of this order contains operational order and data relevant with sale, finance and stock and operate accordingly in relevant database.
After any distribution point workstation 6 passes through public internet 5 and central server 1 is realized being connected, can obtain the interface of these distribution point workstation 6 spendable orders that the application management software by relevant database provides and the every data item corresponding with each order, the character type page that this distribution point workstation 6 can select the numerical value composition of the corresponding every data item of order in this interface and input and this order to contain operational order and data relevant with the sale of this distribution point is submitted to central server 1 and is operated accordingly in relevant database.
After any warehouse workstation 7 passes through public internet 5 and central server 1 is realized being connected, can obtain the interface of these warehouse workstation 7 spendable orders that the application management software by relevant database provides and the every data item corresponding with each order, this warehouse workstation 7 can select the order in this interface and import contain operational order with the numerical value composition of the corresponding every data item of this order and with this warehouse inventory the character type page of relevant data submit to central server 1 and in relevant database, operate accordingly.
When the character type page that each general headquarters' workstation 3, each distribution point workstation 6 and each warehouse workstation 7 are submitted to central server 1 contained more than one order, central server 1 fed back to the workstation of submitting this character type page to the execution result that batch processing mode finishes after the corresponding operation of each order just each order in relevant database.
The data processing of controlling with regard to the credit of merchandise sales in the commercial articles remote marketing activity, the return of goods, stock's the data processing and the shop fixtures distribution of selling on credit, fix a point is illustrated respectively below.
(1) the distribution point marketing activity of various places
The flow chart of data processing of the distribution point marketing activity of various places is please referring to Fig. 2.The client of various places and various places retail trader signing order, described various places retail trader sends the character type page of the data that contain order log on command and sales order by public internet 5 to central server 1 with this distribution point workstation 6, and this character type page comprises that order log on command code, request print invoice of withdrawals command code, this distribution Shang dynasty sign indicating number, client codes, type of sale code, O/No., clearing form, commercial product code, commodity amount and commodity price and data item such as deposit, total charge; Application management software by central server 1 co-relation type database is logined order at general headquarters' accounts subdata base and this distribution point accounts subdata base; Generate the corresponding invoice of withdrawals of this order by central server 1 in general headquarters' accounts subdata base, this invoice of withdrawals is logined content and is comprised delivery of cargo storage code, delivery of cargo client codes, invoice of withdrawals numbering, invoice of withdrawals effective date, sales order numbering, commercial product code, commodity amount and data item such as commodity price and total charge in general headquarters' accounts subdata base; Send the character type page of the data that contain invoice of withdrawals print command and invoice of withdrawals by public internet 5 to this distribution point workstation 6 by central server 1, this character type page comprises invoice of withdrawals print command code, this distribution Shang dynasty sign indicating number, client codes, delivery of cargo storage code, pick up goods client codes, invoice of withdrawals numbering, invoice of withdrawals effective date, sales order numbering, commercial product code, commodity amount and data item such as commodity price and total charge; Control this invoice of withdrawals of printer prints of this distribution point workstation 6.
The client gives with this invoice of withdrawals in this retail trader, the client holds this invoice of withdrawals after the delivery of cargo of appointment warehouse, this warehouse sends the character type page of the data that contain warehouse delivery of cargo log on command and this invoice of withdrawals by public internet 5 to central server 1 with this warehouse workstation 7, and this character type page comprises data item such as warehouse delivery of cargo log on command code, this storage code, retail trader's code, client codes, invoice of withdrawals numbering, Date of Delivery, delivery of cargo reason, delivery personnel code, commercial product code, commodity amount and commodity price.Logining this invoice of withdrawals by the application management software of central server 1 co-relation type database at general headquarters' accounts subdata base picks up goods.
This retail trader handles financial formality with regard to this order and this invoice of withdrawals to general headquarters after client's delivery of cargo, general headquarters' workstation 3 by treasurer's department of general headquarters sends the character type page that the data that contain financial log on command and this order and this invoice of withdrawals are asked the printed invoice order in addition by LAN (Local Area Network) 2 to central server 1, and this character type page comprises financial log on command code, request printed invoice command code, this distribution Shang dynasty sign indicating number, client codes, the type of sale code, the sales order numbering, the delivery of cargo storage code, the invoice of withdrawals numbering, clearing form, commercial product code, data item such as commodity amount and commodity price.Do the finance login of this order and this invoice of withdrawals at general headquarters' accounts subdata base by the application management software of central server co-relation type database.Central server 1 generates the corresponding invoice for sales of this order and this invoice of withdrawals in general headquarters' accounts subdata base, and sending the character type page of the data that contain printing invoice order and invoice for sales to general headquarters' workstation 3 of this treasurer's department of general headquarters by LAN (Local Area Network) 2, this character type page comprises code, client codes, type of sale code, date, invoice of withdrawals numbering, sales order numbering, commercial product code, commodity amount and the data item such as commodity price and total charge of printing invoice command code, treasurer's department; Control this invoice for sales of printer prints of general headquarters' workstation 3 of this treasurer's department of general headquarters.
(2) distribution point return of goods activity
The flow chart of data processing of distribution point return of goods activity sees also Fig. 3.At client's requirement of returning goods, agreeing the client when retail trader returns goods, this retail trader sends to central server 1 by public internet 5 with this distribution point workstation 6 and contains the character type page that Return Application log on command and Return Application data are applied for the print return single command in addition, and this character type page comprises Return Application log on command code, application print return single command code, this distribution Shang dynasty sign indicating number, client codes, type of sale code, Return Application odd numbers, return reason, storage code, commercial product code, commodity amount and data item such as commodity price and total charge.Application management software by central server 1 co-relation type database is logined the Return Application list at general headquarters' accounts subdata base and this distribution point accounts subdata base.Generate the returning note of this Return Application list by central server 1 in general headquarters' accounts subdata base, this returning note is logined content and is comprised return of goods storage code, return of goods client codes, Return Application odd numbers, return of goods odd numbers, return reason, returning note effective date, commercial product code, commodity amount and data item such as commodity price and total charge in general headquarters' accounts subdata base.Send the character type page of the data that contain returning note print command and invoice of withdrawals by public internet 5 to this distribution point workstation 6 by central server 1, this character type page comprises returning note print command code, this retail trader's code, client codes, return of goods storage code, return of goods client codes, Return Application odd numbers, return of goods odd numbers, return reason, returning note effective date, commercial product code, commodity amount and data item such as commodity price and total charge; Control this returning note of printer prints of this distribution point workstation 6.
The client gives with this returning note in this retail trader, the client holds this returning note behind the appointment warehouse return of goods, this warehouse sends the character type page of the data that contain warehouse return of goods log on command and this returning note by public internet 5 to central server 1 with this warehouse workstation 7, and this character type page comprises warehouse return of goods log on command code, this storage code, retail trader's code, client codes, former delivery of cargo storage code, the Return Application odd numbers, return of goods odd numbers, return reason, pull date, the personnel's code of receiving, commercial product code, data item such as commodity amount and commodity price and total charge.Logining this returning note by the application management software of central server 1 co-relation type database at general headquarters' accounts subdata base returns goods.
This retail trader handled financial formality with regard to this Return Application list and this returning note to general headquarters after the client returned goods, general headquarters' workstation 3 by treasurer's department of general headquarters sends the character type page that the data that contain financial return of goods log on command and this Return Application list and this returning note are asked the order of print return invoice in addition by LAN (Local Area Network) 2 to central server 1, and this character type page comprises financial return of goods log on command code, the order of request print return invoice, this distribution Shang dynasty sign indicating number, client codes, the type of sale code, the sales order numbering, the delivery of cargo storage code, return of goods storage code, return of goods odd numbers, pull date, return reason, former delivery personnel code, the personnel's code of receiving, clearing form, commercial product code, data item such as commodity amount and commodity price and total charge.Do the finance login of this Return Application list and this returning note at general headquarters' accounts subdata base by the application management software of central server 1 co-relation type database.In general headquarters' accounts subdata base, generate the correspondence return of goods invoice of this Return Application list and this returning note by central server 1, and sending the character type page of the data that contain order of return of goods printing invoice and return of goods invoice by LAN (Local Area Network) 2 to general headquarters' workstation 3 of this treasurer's department of general headquarters by central server 1, this character type page comprises return of goods printing invoice command code, the code of treasurer's department, retail trader's code, client codes, the type of sale code, date, return of goods storage code, return of goods odd numbers, clearing form, commercial product code, data item such as commodity amount and commodity price and total charge; The printer prints of controlling general headquarters' workstation 3 of this treasurer's department of general headquarters should return of goods invoice.
(3) general headquarters' marketing activity
The flow process of general headquarters' marketing activity is please referring to Fig. 4.Client and sales department of general headquarters signing order, sales department of general headquarters prints the character type page of invoice of withdrawals order by LAN (Local Area Network) 2 to the request of data that central server 1 transmission contains general headquarters' order log on command and sales order with general headquarters' workstation 3 of this department, and this character type page comprises general headquarters' order log on command code, request printing invoice of withdrawals command code, this department's code, client codes, type of sale code, O/No., clearing form, commercial product code, commodity amount and commodity price and data item such as deposit, total charge.Application management software by central server 1 co-relation type database is logined order at general headquarters' accounts subdata base.Generate the corresponding invoice of withdrawals of this order by central server 1 in general headquarters' accounts subdata base, this invoice of withdrawals is logined content and is comprised delivery of cargo storage code, delivery of cargo client codes, invoice of withdrawals numbering, invoice of withdrawals effective date, sales order numbering, commercial product code, commodity amount and data item such as commodity price and total charge in general headquarters' accounts subdata base.Send the character type page of the data that contain invoice of withdrawals print command and invoice of withdrawals by LAN (Local Area Network) 2 to general headquarters' workstation 3 of this department by central server 1, this character type page comprises invoice of withdrawals print command code, this division code, client codes, delivery of cargo storage code, delivery of cargo client codes, invoice of withdrawals numbering, invoice of withdrawals effective date, sales order numbering, commercial product code, commodity amount and data item such as commodity price and total charge; Control this invoice of withdrawals of printer prints of general headquarters' workstation 3 of this department.
The client gives with this invoice of withdrawals in this department, the client holds this invoice of withdrawals after the delivery of cargo of appointment warehouse, this warehouse sends the character type page of the data that contain warehouse delivery of cargo log on command and this invoice of withdrawals by public internet 5 to central server 1 with this warehouse workstation 7, and this character type page comprises warehouse delivery of cargo log on command code, this storage code, this division code, client codes, invoice of withdrawals numbering, Date of Delivery, delivery of cargo reason, delivery personnel code, commercial product code, commodity amount and data item such as commodity price and total charge.Logining this invoice of withdrawals by the application management software of central server 1 co-relation type database at general headquarters' accounts subdata base picks up goods.
Sales department of general headquarters handled financial formality with regard to this order and this invoice of withdrawals to general headquarters after the client picked up goods, general headquarters' workstation 3 by treasurer's department of general headquarters sends the character type page that the data that contain financial log on command and this order and this invoice of withdrawals are asked the printed invoice order in addition by LAN (Local Area Network) 2 to central server 1, and this character type page comprises financial log on command code, request printed invoice command code, this distribution Shang dynasty sign indicating number, client codes, the type of sale code, the sales order numbering, the delivery of cargo storage code, the invoice of withdrawals numbering, clearing form, commercial product code, data item such as commodity amount and commodity price and total charge.Do the finance login of this order and this invoice of withdrawals at general headquarters' accounts subdata base by the application management software of central server 1 co-relation type database.Central server 1 generates the corresponding invoice for sales of this order and this invoice of withdrawals in general headquarters' accounts subdata base, and sending the character type page of the data that contain printing invoice order and invoice for sales by LAN (Local Area Network) 2 to general headquarters' workstation 3 of this treasurer's department of general headquarters by central server 1, this character type page comprises code, client codes, type of sale code, client codes, date, invoice of withdrawals numbering, sales order numbering, clearing form, commercial product code, commodity amount and the data item such as commodity price and total charge of printing invoice command code, treasurer's department; Control this invoice for sales of printer prints of general headquarters' workstation 3 of this treasurer's department of general headquarters.
(4) general headquarters' return of goods activity
The flow chart of data processing of general headquarters' return of goods activity sees also Fig. 5.Agreeing the client when sales department of general headquarters returns goods, sales department of general headquarters sends to central server 1 by LAN (Local Area Network) 2 with general headquarters of this department workstation 3 and contains the character type page that general headquarters' return of goods log on command and Return Application data are asked the print return single command in addition, and this character type page comprises general headquarters' return of goods log on command code, request print return single command code, this department's code, client codes, type of sale code, Return Application odd numbers, return reason, storage code, commercial product code, commodity amount and data item such as commodity price and total charge.Application management software by central server 1 co-relation type database is logined the Return Application list at general headquarters' accounts subdata base.Central server 1 generates the returning note of this Return Application list in general headquarters' accounts subdata base, this returning note is logined content and comprised return of goods storage code, return of goods client codes, Return Application odd numbers, return of goods odd numbers, return reason, returning note effective date, commercial product code, commodity amount and data item such as commodity price and total charge in general headquarters' accounts subdata base.Central server 1 sends the character type page of the data that contain invoice of withdrawals print command and invoice of withdrawals to general headquarters' workstation 3 of this department by LAN (Local Area Network) 2, this character type page comprises invoice of withdrawals print command code, this division code, client codes, and page of data comprises return of goods storage code, return of goods client codes, Return Application odd numbers, return of goods odd numbers, return reason, returning note effective date, commercial product code, commodity amount and data item such as commodity price and total charge; This returning note of printer prints of general headquarters' workstation 3 of sales department of control general headquarters.
The client gives with this returning note in this department, the client holds this returning note behind the appointment warehouse return of goods, this warehouse sends the character type page of the data that contain warehouse return of goods log on command and this returning note by public internet 5 to central server 1 with this warehouse workstation 7, and this character type page comprises warehouse return of goods log on command code, this storage code, this division code, client codes, former delivery of cargo storage code, former delivery personnel code, the Return Application odd numbers, return of goods odd numbers, return reason, pull date, the personnel's code of receiving, commercial product code, data item such as commodity amount and commodity price and total charge.Logining this returning note by the application management software of central server 1 co-relation type database at general headquarters' accounts subdata base returns goods.
Sales department of general headquarters handled financial formality with regard to this Return Application list and this returning note to general headquarters after the client returned goods, general headquarters' workstation 3 by treasurer's department of general headquarters sends the character type page that the data that contain financial return of goods log on command and this Return Application list and this returning note are asked the order of print return invoice in addition by LAN (Local Area Network) 2 to central server 1, and this character type page comprises financial return of goods log on command code, request print return invoice command code, this department's code, client codes, the type of sale code, the sales order numbering, former delivery of cargo storage code, former delivery personnel code, return of goods storage code, the Return Application odd numbers, return of goods odd numbers, pull date, return reason, the personnel's code of receiving, clearing form, commercial product code, data item such as commodity amount and commodity price and total charge.Do the finance login of this Return Application list and this returning note at general headquarters' accounts subdata base by central server 1, in general headquarters' accounts subdata base, generate the correspondence return of goods invoice of this Return Application list and this returning note by central server 1, and sending the character type page of the data that contain order of return of goods printing invoice and return of goods invoice by LAN (Local Area Network) 2 to general headquarters' workstation 3 of this treasurer's department of general headquarters by central server 1, this character type page comprises return of goods printing invoice command code, the code of treasurer's department, sales department of general headquarters code, client codes, the type of sale code, date, return of goods storage code, return of goods odd numbers, clearing form, commercial product code, data item such as commodity amount and commodity price and total charge; The printer prints of controlling general headquarters' workstation 3 of this treasurer's department of general headquarters should return of goods invoice.
(5) distribution point sales letter management activity
The distribution point sales letter sees also Fig. 6 with the flow chart of data processing of management activity.The application software of credit control is checked this retail trader and this client's credit rating when this distribution point accounts subdata base of central server 1 is logined order by public internet 5 with this distribution point workstation 6 in retail trader, if report to the police, then point out the order of retail trader's modification login to continue to send the character type page that contains the data of revising log on command and modification by public internet 5 to central server 1, login order at this distribution point accounts subdata base by the application management software of central server 1 co-relation type database with this distribution point workstation 6; Then, this order of login in general headquarters' accounts subdata base, at this moment, the application software of this credit control is this retail trader of verification and this client's credit rating once more, if can not pass through, then the application software of this credit control sends the character type page of the data that contain Request Processing order and sales order verification by LAN (Local Area Network) 2 to general headquarters' workstation 3 of credit management department of general headquarters, delivers credit management department of general headquarters and handles this order.
This order will be deleted at general headquarters' accounts subdata base and this distribution point accounts subdata base for this order business that will not carry out by credit management department of general headquarters, and stop subsequent operation; For this order business that can consider to grant execution, adjust this retail trader and this client's credit line, call the application software of credit control again and carry out the credit rating verification.Credit management department of general headquarters sends the character type page that contain processing command and deal with data by LAN (Local Area Network) 2 to central server 1 with its general headquarters' workstation 3; For what will not carry out, this character type page comprises data item such as deletion order command code, this retail trader's code, client codes, type of sale code, date, sales order numbering; For considering to grant execution, this character type page comprises revises amount command code, this retail trader's code, client codes, type of sale code, date, sales order numbering and new data item such as credit line; Application management software by central server 1 co-relation type database is carried out this processing command.
After the credit rating verification, in general headquarters' accounts subdata base, generate the corresponding invoice of withdrawals of this order and send the character type page of the data that contain invoice of withdrawals print command and invoice of withdrawals to this distribution point workstation 6 by the application management software of central server 1 co-relation type database, control this distribution point workstation of printer of this distribution point workstation 6 and print this invoice of withdrawals by public internet 5.
(6) general headquarters' sales letter management activity
General headquarters' sales letter sees also Fig. 7 with the flow chart of data processing of management activity.The application software of credit control is checked this client's credit rating when general headquarters' accounts subdata base of central server 1 is logined order by LAN (Local Area Network) 2 with general headquarters' workstation 3 of this department in sales department of general headquarters, if report to the police, then point out the order of sales department of general headquarters modification login to continue to send the character type page that contains the data of revising log on command and modification by LAN (Local Area Network) 2 to central server 1, login order at general headquarters' accounts subdata base by the application management software of central server 1 co-relation type database with general headquarters' workstation 3 of this department; Then, the application software of this credit control is this client's of verification credit rating once more, if can not pass through, then the application software of this credit control sends the character type page of the data that contain Request Processing order and sales order verification by LAN (Local Area Network) 2 to general headquarters' workstation 3 of credit management department of general headquarters, delivers credit management department of general headquarters and handles this order.
This order will be deleted at general headquarters' accounts subdata base for this order business that will not carry out by credit management department of general headquarters, and stop subsequent operation; For this order business that can consider to grant execution, adjust this client's credit line, call the application software of credit control again and carry out the credit rating verification.Credit management department of general headquarters sends the character type page that contain processing command and deal with data by LAN (Local Area Network) 2 to central server 1 with its general headquarters' workstation 3, for what will not carry out, this character type page comprises data item such as deletion order command code, client codes, type of sale code, date, sales order numbering; For considering to grant execution, this character type page comprises revises amount command code, this retail trader's code, client codes, type of sale code, date, sales order numbering and new data item such as credit line; Application management software by central server 1 co-relation type database is carried out this processing command.
After the credit rating verification, generate the corresponding invoice of withdrawals of this order and send the character type page of the data that contain invoice of withdrawals print command and invoice of withdrawals to general headquarters' workstation 3 of this department at general headquarters' accounts subdata base by the application management software of central server 1 co-relation type database, control this invoice of withdrawals of printer prints of general headquarters' workstation 3 of this department by LAN (Local Area Network) 2.
(7) general headquarters deliver to the warehouse, various places
General headquarters see also Fig. 8 to the flow chart of data processing of warehouse, various places delivery activity.When delivering to the warehouse, various places in the general headquarters warehouse, sent to contain to move storehouse application log on command and move the storehouse request for data to central server 1 by LAN (Local Area Network) 2 with its general headquarters' workstation 3 by storehouse management department of general headquarters and also have request to print to move the character type page of storehouse single command, this character type page comprises that moving storehouse application log on command code, request prints and move storehouse single command code, this department's code, general headquarters' storage code, the storage code of receiving, move storehouse application odd numbers, move the storehouse date of application, move data item such as storehouse reason, commercial product code, commodity amount and commodity price and total charge; Application management software by central server 1 co-relation type database moves the storehouse request slip in general headquarters' accounts subdata base login.Central server 1 in general headquarters' accounts subdata base, generate this move the storehouse request slip to move the storehouse single, this moves the storehouse and singly comprises this department's code, general headquarters' storage code, the storage code of receiving, moves storehouse application odd numbers, moves the storehouse odd numbers, moves storehouse date of expiration, moves data item such as storehouse reason, commercial product code, commodity amount and commodity price and total charge; Central server 1 sends to contain to general headquarters' workstation 3 of this department by LAN (Local Area Network) 2 and moves the character type page that the storehouse singles print order and move the data of storehouse list, and this character type page comprises that moving the storehouse singles prints command code, this department's code, general headquarters' storage code, the storage code of receiving, moves storehouse application odd numbers, moves the storehouse odd numbers, moves storehouse date of expiration, moves data item such as storehouse reason, commercial product code, commodity amount and commodity price and total charge; General headquarters' workstation 3 of storehouse management department of control general headquarters is printed this and is moved the storehouse list.
Storehouse management department of general headquarters will move the storehouse single cross and give transportation department, transportation department holds and moves the storehouse list from general headquarters' warehouse delivery of cargo, the general headquarters warehouse sends to central server 1 by LAN (Local Area Network) 2 with its general headquarters' workstation 3 and contains the character type page that the warehouse moves the storehouse log on command and moves database data, and this character type page comprises that the warehouse moves storehouse log on command code, general headquarters' storage code, the storage code of receiving, moves storehouse application odd numbers, moves the storehouse odd numbers, moves the storehouse date, moves the storehouse reason, delivery personnel code, transportation department's code, commercial product code, commodity amount and data item such as commodity price and total charge.Login this stock that moves the storehouse list by the application management software of central server 1 co-relation type database at general headquarters' accounts subdata base and shift out, actual quantity issued general headquarters warehouse from general headquarters' accounts subdata base is moved into corresponding warehouse in transit, warehouse, destination---under transportation department's item.
After receiving in the warehouse, destination, send the character type page that contain warehouse entry log on command and move database data by public internet 5 to central server 1 with the warehouse workstation 7 of ware-house here, this character type page comprises warehouse entry log on command code, this storage code, shipping room code, moves the storehouse odd numbers, moves the storehouse date, moves the storehouse reason, delivery personnel code, transportation department's code, the date of receiving, the data item such as personnel's code, commercial product code, commodity amount and commodity price and total charge of receiving.Application management software by central server 1 co-relation type database is logined this stock that moves the storehouse list by corresponding warehouse in transit at general headquarters' accounts subdata base---and transportation department moves into the warehouse, destination.
(8) commodity are alloted between the warehouse
Commodity are alloted movable flow process and are seen also Fig. 9 between the warehouse.Instruction is alloted delivery in the warehouse of various places to other warehouse when general headquarters, provide accent goods outbound list by storehouse management department of general headquarters, transportation department holds and transfers goods outbound list to pick up goods from the shipping room, the shipping room contains warehouse accent goods outbound log on command and transfers goods to go out the character type page of database data to central server 1 transmission by public internet 5 with its warehouse workstation 7, and this character type page comprises warehouse accent goods outbound log on command code, this storage code, the storage code of receiving, transfer goods outbound odd numbers, transfer the goods outbound date, move the storehouse reason, delivery personnel code, transportation department's code, commercial product code, data item such as commodity amount and commodity price and total charge; The stock of logining this accent goods outbound list at general headquarters' accounts subdata base by the application management software of central server 1 co-relation type database shifts out, and actual quantity issued shipping room from general headquarters' accounts subdata base is moved into corresponding warehouse in transit, warehouse, destination---under transportation department's item.
After receiving in the warehouse, destination, the warehouse, destination is that the warehouse workstation 7 by ware-house here in warehouse stationed abroad passes through public internet 5, the warehouse, destination is that the general headquarters' workstation 3 by the general headquarters warehouse in general headquarters warehouse passes through LAN (Local Area Network) 2, send the character type page that contains warehouse accent goods warehouse-in login log on command and shipment data to central server 1, this character type page comprises warehouse accent goods warehouse-in log on command code, this storage code, the shipping room code, transfer goods outbound odd numbers, transfer the goods outbound date, move the storehouse reason, delivery personnel code, transportation department's code, receive the date, the storage code of receiving, the personnel's code of receiving, commercial product code, data item such as commodity amount and commodity price.The stock of logining this accent goods outbound list at general headquarters' accounts subdata base by the application management software of central server 1 co-relation type database is by corresponding warehouse in transit---and transportation department moves into the warehouse, destination.
(9) other
At the real-time typing of aforementioned merchandise sales, the return of goods and inventory data general headquarters' accounts subdata base and after inter-process, inquiry, stat commands that the treasurer's department of general headquarters, sales department, storehouse management department, general headquarters warehouse, credit management department and integrated management department can use general headquarters' workstation 3 of this department to use the application management software of relevant database to provide respectively, check relevant data, sale, the return of goods and inventory data are analyzed, proposed prediction.For example, after the return of goods quantity of total sales volume of a certain kind commodity, a variety of causes added up, integrated management department can suggest improvements to the quality management of these kind commodity, or the decision-making that design is produced is provide advice.After the various kind commodity sales numbers of a certain distribution point, return of goods quantity added up, integrated management department can analyze the total achievement of selling of these distribution point commodity.
Equally, at aforementioned merchandise sales and each distribution point accounts subdata base of return of goods data in real time typing and after inter-process, inquiry, stat commands that the retail trader of various places can use the distribution point workstation 7 of this distribution point to use the application management software of relevant database to provide respectively, check the relevant data of this distribution point and ware-house here, achievement to this distribution point is analyzed, and proposes prediction.