Preferred embodiment is described in detail
The present invention realizes a kind of seller's managed inventory based on the internet (" VMI ") system. The VMI system makes client's cost reduction by shifting the stock control responsibility onto the 3rd side or manager. The manager can be the service of many companies, makes these companies can discuss better transaction, improves supplier's responsiveness, thereby plays a part effective customer care person.
The present invention makes the manager monitor the client stock through internet and WWW cheapness. The present invention utilizes the technology of WWW, by tracking inventory, and when the needs product automatic contact supplier, manufacturer or dealer thoroughly reform stock control. Keep system with the labour-intensive type quantity in stock of current arrangement and compare, this can bring labour's minimizing.
Fig. 1 is the block diagram of explanation main hardware part of the present invention. As shown in Figure 1, the present invention utilizes the architecture of client/server to consist of communicating by letter between client's inventory system and the manager. The client tracks stock of operation on the available client inventory system 130 proposes to order goods specially, and with other client connections.
Client computer can comprise the combination (plug-in that for example works at browser) of client software (such as the application program of writing with Visual Basic, JAVA or C), business software (such as can be by the webpage of Web-browser access) or client software and business software. The example of applicable commercial browser comprises the Internet resources manager of Microsoft (Redmond, Washington) exploitation and the omniselector of Netscape's (Mountain View, california) exploitation.
Client's inventory system 130 can allow artificial inventory tracking, semi-automatic inventory tracking, perhaps distributes the stock with automatic system. This does not limit the present invention just as an example, and preferred embodiment of the present invention comprises the hand-held device that is equipped with bar code scanning, such as the Palm VII type machine of Palm Computer Corp.. This device is before article are sold or when selling, and the bar code related with each oddment or other signs can obtain scanning, perhaps input this system. During each scan articles, the counting that capable of regulating the present invention keeps is with the degree that correctly tracks inventory. Then, can print the reciever special tags that comprises product points for attention and other information to the article after each scanning.
Consider that other stock's methods of selling have comprised, but be not limited to the interface of the present invention and vending machine. Except certain goods and materials or certain group goods and materials were periodically restocked, vending machine did not need people's interaction just can accurately track inventory. Among the soft good embodiment, vending machine can comprise security measures. In the preferred embodiment, vending machine can comprise security measures, prevents that illegal goods and materials from selling. These security measures can comprise, but are not limited to, and utilize identity card, personal identity number (" PIN ") and biometric system. The vending machine of outfit security system can be one by one or is limited by group and use specific goods and materials. Vending machine also can be equipped with label machine, and points for attention or other information can be attached on the packing of dispensing articles.
Perhaps, can make goods and materials secret room or other memory blocks be equipped with radio frequency identification (RFID) entrance, as shown in Figure 5. RFID entrance (square frame 500) be similar to airport security personnel metal detector except the RFID label can be to its detection or scanning during by entrance on the structure. The present invention can monitor the identifier of RFID label that comprises the identifier of distributing to the individual, so that can monitor and enter the stock district, and can follow the tracks of the individual article of taking away, and need not directly interaction of user.
A preferred embodiment of the present invention also can be followed the tracks of the granting of each product, and can require additional information when providing product. This does not limit the present invention just as an example, if the doctor provides medicine to patient, the present invention also can require the patient identifier symbol, again is stored in Consultation room and take out the gauze bandage bag from stock, and then the present invention may not request the patient identifier symbol. The present invention can produce with the patient identifier symbol granting historical report of various products, can help supplier and manufacturer to understand preferably typical recipient's income, nationality, race or other demographic informations. The present invention is confined to demographic information with this report, can not comprise individual specific information in this report.
Another example of the present invention is to allow doctor or other staff's portability hand-held device, and uses this hand-held device to write prescription when talking with patient. This hand-held device can connect by wireless or wired mode the local inventory management system, and automatically provides ethical goods by vending machine in due course. Perhaps, can be on nurse's work station demonstration information, the medicine that indication is taken out from stock. Inventory count can suitably be successively decreased when medicine took out by the vending machine granting or from stock, and can carry out new order when needed.
When selling stock, client's inventory system 130 can be followed the tracks of goods and materials utilization custom, to determine minimum tolerance at hand. Can study consumption information to different times, the present invention can set up stock according to the data of collecting and consume model. Along with foundation and the improvement of model, the present invention can revise the minimum inventories thresholding, with the utilization of reflection expection. When the stock approached the thresholding that calculates or stipulate, client's inventory system 130 can be automatically from the new goods and materials of server 100 requests. The goods and materials request can comprise much information, and this just comprises, rather than place restrictions in; For example, the urgency of request, the client accepts wish, bill information and the shipment information of other trade marks or scale.
When server 100 is received supply of material request, can be from some manufacturers, supplier or dealer 120 (" dealer 120 ") request quotation. Dealer 120 provides and can supply replying of the information such as amount, price, estimated time of delivery. Then, but the optimum value of the various factors related with client requests is found out in replying of each dealer 120 of server 100 automatic Evaluation. When selecting the replying of a suitable dealer 120, server 100 can arrange payment and the shipment of client's inventory system 130 goods and materials of asking automatically.
Communication between client's inventory system 130, server 100 and the dealer 120 can realize by the whole bag of tricks, these methods comprise super this transportation protocol of side (" HTTP "), FTP " FTP "), simple letter transportation protocol (" SMTP ") or other correlation techniques, but this just comprises, rather than places restrictions on.
Although buy and account for the major part work of keeping the stock, preferred embodiment of the present invention also can be convenient to the communication between the client, and the source of Information Communication is provided, and encourages client connection. The present invention is convenient to make the client to other shop vendor-logo products, equipment or superfluous stock, promotes client's communication. The present invention is propagated information by the existing equipment that the client is provided can orders goods and the latest list of other stocks. The present invention can by the prospect that allows manager and client creation and issue explanation new regulation, regulations, formality, generation income or the information that other clients pay close attention to, promote client's communication.
Client's inventory system 130 can be used as the main source of client and interaction of the present invention. The client can deposit clause, catalogue, stock information etc. at server 100, and this system can communicate by letter with server 100, with the information that obtains requiring.
Fig. 2 draws a preferred embodiment of server 100, and the relation between the application service that data storage, Web server and server 100 provide is described. All fire wall 210 can be at first passed through in the communication of client computer. Fire wall 210 representatives are used for preventing the soft and hardware combination of unauthorized access Web server 220, database server 230 and application server 240 stored data.
As indicated above, client computer can be communicated by letter with the present invention by variety of protocol (comprising HTTP). The software that Web server 220 representatives can adopt HTTP or other agreements to receive and send messages. The example of this software comprises the (Redmond of Microsoft, Washington) internet information servers, (the Mountain View of Netscape of exploitation, california) the Appache server of the enterprise servers of exploitation and Apache software creation company (Forest Hill, Maryland) exploitation.
During client requests information, Web server 220 judges that client requests is the requirement preliminary treatment, still only simply requires to satisfy the data of this request. In the former situation, will ask the application server of passing 240; Latter Web server 220 can directly be communicated by letter with database server 230.
The commercially available database software of database server 230 representatives is such as the microsoft sql server of Microsoft (Redmond, Washington) exploitation, Oradle 8i or other similar software of Oracle company (Redwood Snores, california) exploitation. Database server 230 can be deposited initial data, such as client's inventory information, customer address, sellers' name, sellers' product rank and other similar information. This information can be issued client computer by Web server 220, and perhaps application server 240 can be explained the information of depositing according to storehouse server 230 before transmission.
Application server 240 can comprise the trading rules of association of the present invention, is used in the client is sent decryption before the data of database server 230. The information of depositing except decryption storehouse 230 is for the client computer, application server 240 also can monitor stock's degree of database server 230 reflections, according to the information contact sellers from database server 230, when receiving new stock, adjust inventory information, and provide the shop that promotes data server 230 equipment of depositing or product to the shop required service of reselling.
Web server 220, database server 230 and application server 240 represent respectively the software that can move at same computer or a plurality of computer. In addition, application server 240 can be realized as one group of trading rules in that database server 230 is interior.
Another explanation of the present invention is to set forth the present invention by a series of functional specifications. This information comprises the purpose that can reach realization, and is set forth in the pattern of thinking best when submitting this specification to. Although following functional specification is set forth the invention preferred embodiment, should be with the elaboration in this functional specification when being restricted the present invention.
For fear of confusion, this functional specification adopts following predicate.
Client-refer to by the product seller of the present invention. The client can have the relation of " open account ", to exempt credit card and COD shipment problem.
Link supplier-known remittance for the proceeds can be carried out in the joint account APS, so distinguish, obscures with other sellers that avoid concluding the business with the present invention. By whether adopting inventory tracking of the present invention and account software, thereby whether its database has inquiry, the online internet link of order handling and the usefulness of making out the bill is made difference to dealer, manufacturer or other sellers (being referred to as " supplier ").
If artificial supplier-supplier is by the invention provides goods or service, but track inventory by manual interface, this supplier is called " artificial supplier " at term. Keep the open account relation between supplier or the artificial supplier with linking, with the complexity of avoiding paying.
The supplier that non-link supplier-not and the present invention link.
The article of product-sell through the present invention.
Client's product inventory-be at the detailed list of goods of given curstomer`s site maintenance.
Except above-mentioned General Definition, this functional specification is also stipulated some systemic-functions. These systemic-functions can be a kind of in following total subsystem classification.
Interactive-as to be applicable to manual interface and the correlation function of the amount of tracking inventory counting, stock rate of consumption, crucial order product etc. Interactive processing is based on WWW or PC (client computer one server).
Process-can produce the cyclical process of ordering goods and carrying out invoice and relevant treatment night, comprise with distributor's stock carry out interaction through pin system.
Associating-in the more indoor processing of carrying out of collective's office of new database. Comprising calculating, client data management and other such processing.
Sell-with the present invention comprehensive link supplier. Industrial standard Enterprise Resources Planning (ERP) software and business finance software can be tied together, supplier provides complete transaction system for link.
Database design-the can be used for database scheme of preferred embodiment of the present invention.
The present invention on the whole, and functional specification has defined the pattern that comprises and the function of detailed webpage and other user interface sections that will be used for system scope particularly. Webpage among the present invention, application window, program screen and issued transaction must be observed common rule. These rules comprise the following, but are not limited.
The client can not watch, inquire about, upgrade or change with any method another client's data. Issued transaction can be opposed IP address or other specific identity usefulness with the send out page cross check of the Customer ID that enters, to guarantee executing rule. For this security procedure, can only could change client IP address or other unique identifiers by the addressable function of company clerk.
Link supplier can not see the data that belong to another link supplier.
Can set by account's foundation and editing and processing the systematic parameter of client's option. The personnel that only have authorization identifiers can access this processing. The starting stage identifier is only supplied with the company clerk.
Generally reflect data variation by transaction logging or issued transaction resume, this record or resume can be by client or dealer's access, and the company clerk with suitable safe level is also addressable.
Relating to the script that the function that changes data can be used as server side carries out rather than carries out by the logic of client computer. In general, the script of this server side can adopt the logic flow that is similar to Fig. 3. As shown in Figure 3, the client software that moves on the customer equipment can produce the page that contains the data of being upgraded by the WWW, and the described page is sent to described Web server (frame 300).
When Web server was received from the page of customer equipment, the present invention can try to process the change of described page request. If should change successfully by (frame 320), the present invention can send the page of affirmation back to or produce the affirmation information that will show customer equipment, and suitable transaction logging occurs.
If change unsuccessfully, the present invention makes retry count increase progressively 1 (frame 340). If retry count is less than or equal to 3, the present invention makes great efforts to do appropriate change to frame 310 repeating transmission clients' change (frame 370). The super meter of retry count 3 (frames 350), the present invention then makes and shows the page that contains error code or other feedback informations on the customer equipment. This page also can comprise the means (frame 360) that original customer data changes and again propose described change.
But client software also exists data to connect between the described client software of periodic authentication and the server as a part of the present invention. This software can obtain according to logic shown in Figure 4 accurately data connection monitoring. Shown in frame 400, client software can send order or other network test orders of one or more TCP/IP, and the server that checking is worked as a part of the present invention also has at a high speed connection.
Connect if detect express network, the present invention can proceed normal operating (frame 410). Do not detect express network and connect, then this connection (frame 420) is set up in the present invention's examination again. Connect (frame 430) if can set up express network, the present invention proceeds normal operating (frame 410) again. Can not set up this connection, then the present invention sets up the lower network connection of speed, connects (frame 440) such as Dial-up Network. Connect if can set up than slow network, the present invention proceeds normal operating, comprises that periodically the try reconstruct express network connects (frame 410).
Connect if can not set up than slow network, then client software is with replacing user interface and replacement function display application or the page (frame 460). This replacement function can comprise the storage of native product consumption information, local inventory is followed the tracks of be connected dialing or other interim modes that connects and known supplier's limited reordering (frame 470). Countless client functionalities according to connecting are try reconstruct high speed or slow network connection (frame 480) periodically. Rebuild when connecting (frame 490), client computer can send product and consume scanning information to the server that works as a part of the present invention.
Except inventory tracking was used, the present invention also can utilize express network to connect client computer is sent new product quotation or special the distribution, is shown to the user. During with new product input product table or similar structures, the present invention can make and occur this product on the client computer. In the preferred embodiment, the present invention allows the product of its concern of customer selecting, and the present invention only shows the product that meets its concern of customer selecting, and the present invention only shows new product or the special lot that meets the previous standard of client. This standard can comprise, but does not place restrictions in, the classification of manufacturer, the trade name of product, specific product model, common product rank and can be for the amount of amount or each shipment unit.
The client computer that shows this information makes the client can be by squeezing into order, button click or other graphic interface unit or indicating the concern of product with described client computer interaction. If the client expresses the concern to distinguishing products, client computer can be set up the client and is once ordered goods or the configuration cycles order.
Except permission user logging product utilization situation with to new stock or the new product order, client software is demonstration advertisement capable of circulation also, is used for other purposes. Typical client software screen also comprises additional information and product SKU section, ID section, doctor ID section and sells consultant's section of contact, and such section is not limited.
The client is during directly with the client software interaction, and client software can arrange cursor by fixing on approximately product SKU section. In product SKU section cursor is set and makes the product identifiers that client software can be prepared to accept automatically or population is inputted, such as the bar code label through the scanning of wedge shape bar code scanner.
When the input product identifier, client software can be to each product identifiers or product identifiers group request ID. ID is that each employee or the employee in this tissue organizes the unique identifiers of setting up. Can be by the active users interface (such as keyboard, touch screen or figure disc, but not limited), or by the passive user interface (barcode recognizer of wearing such as Biometrical identification device, relevant employee, but not limited), or by the RFID label that the employee wears, input this identifier. Can with ID and password combination, set up safer inventory status notification system.
Available subscribers ID follows the tracks of the personnel of article that take away from stock, but also can carry out other tracking or other control. For example, when the employee takes expensive product or control thing away from stock, can require extra checking and approving. The present invention can identify when taking this stock away, and client software can require extra identifier (being called doctor ID) as checking and approving. Client software even allow any user to input the doctor ID of some stocks, other stocks then require doctor ID and associated cryptographic. Some uses available biometrics or other clear and definite identifiers replace doctor ID or doctor ID encrypted code.
When client software had been inputted suitable inventory tracking data, the present invention can send this data to server. When receiving these data, server sends confirmation to client computer. If do not receive confirmation in the scheduled time, the present invention can retransmit the inventory tracking data. Send out unsuccessful if connect test mass, the present invention is in accordance with being similar to the processing shown in Fig. 3. Client software allows to carry out extra stock scanning, waits for simultaneously the affirmation from client computer.
Except record inventory scan information, client software also makes the addressable variety of option of client. This option can comprise, and does not receive the page but be not subjected to this to place restrictions on administration page, the inventory status inquiry page and stock. Administration page makes authorize clients can set up, edit or remove ID, doctor ID, its account's group and account specific information. The page of information such as containing client's product inventory record, order state can be retrieved and be shown to inventory status inquiry page or leaf.
Can send the page that contains client's specific information and be stored in the on-the-spot special-purpose identifying information in the customer equipment by client software, start the inventory status inquiry. In the preferred embodiment, the server that receives this request can be selected from client's product inventory record sheet the record of suitably on-the-spot special use and user-specific information. Server can produce the page or the screen that contains client's product inventory information, wherein comprises the information from some tables. Following table 1 provides column example and the table example that can extract data and the section name that shows on the typical stock inquiry screen.
The column title | The source table | The source section |
Explanation | Product | Explanation |
Product | Client's product inventory | Product |
Quantity in stock | Client's product inventory | Standing crop |
The ordering place | Client's product inventory |
ROP
|
Reorder level | Client's product inventory |
ROQ
|
Active state | Client's product inventory | State |
Table 1
The advantage that the present invention surpasses prior art is to have the stock of simplification to add the again function of warehousing of new article or article. Packing list that special coding can be provided for the link supplier of client's shipment, and the client can automatic or manual input this be encoded to client software. Client software can confirm to belong to client's packing list number, and guarantees that this inventory is no more than once the loan of client. Input invalid or effective packing list can make client software show error message.
If input effective packing list, client software can load and transport content from integrated data store or supplier data library searching, and automatically upgrades client's product inventory information, receives stock with reflection. Then, client software shows the information of confirming that the stock successfully changes, and makes the client return homepage.
Also can search page or leaf by the accesses of guest software product. Product is searched page or leaf makes the user can select to search type, if suitable, also can select to search parameter and search parameter value (being referred to as " searching standard "). As an example, do not limit the present invention, product is searched page or leaf can search according to particular manufacturer and certain classification product the client. Customer selecting when suitably searching standard, client software can be passed to server with this standard of searching. Server interrogates product and description of product database, and send the product that meets or search standard near the client back to.
If the user has selected illustrative to search, server can be selected data fit or near the record of explanatory text that the user inputs from the similar table of product table or other. User's selected parameter is searched, and then server selects section to meet or near the product table record of user's search request. Select in order to accelerate these, server can be compiled often index of the section of searching of explanation, manufactory, product rank, ProductName and other.
When selecting suitably to record, server can send these records and show to client software. Client software can provide this record with various forms, comprises column or sheet format, but not limited. Table 2 is listed available example column name, exemplary source table name, source section name and additional function client software when showing this record.
The column title | The source table | The source section |
Explanation | Product | Cutline |
Product IDs | Product | Product IDs |
Manufacturer | Product | Manufacturer |
Manufacturer's item number | Product | Manufacturer's item number |
Product type | Product | Product type |
The product rank | Produce | The product rank |
The verification availability | Nothing | Form action section |
Insert inventory planning | Nothing | Form action section |
Table 2
As shown in table 2, client software makes client's energy verification product availability and library programming is added product. In the preferred embodiment, what client software can make demonstration respectively records this function. Among another embodiment, record can have the verification hurdle or other select control, thereby but makes the availability of client's verification various article and library programming is added various article.
During client's verification product availability, the present invention searches link supplier stock, and decision can supply amount, actual occupy-place, estimated time of delivery etc. When in stock, client software makes client's energy ordering products.
When customer selecting increased product to library programming, client software can from client requests again inventory parameters and other parameters, then send adequate information to server. Server can be to client's product inventory or is similarly shown to add suitable project, thereby starts inventory tracking by the present invention.
Client software also makes the client obtain call there, E-mail or other contact from selling the consultant. In the preferred embodiment, the client can select product or supplier, and client software can be inquired server, to determine selected product or supplier's sale consultant. Then, can provide dialog box or other interaction interfaces to the user, the query user confirms association request. In case association request is confirmed, client software just makes server similarly show to deposit solicited message at relationship record table or other.
In the preferred embodiment, the project of server periodic scan relationship record table. When finding the request of new request or dont answer, server sends notice to supplier, remind described supplier to have this request, described notice comprises client's E-mail address, phone number, Fax number or other contact details, also comprises other about the information of client and product.
Although the present invention can monitor the use of looking stock, and automatically order when needed new stock, the needs of the parameter anticipated values outer stock of client beyond also can be according to the present invention. As an example, do not limit the present invention, if the present invention is used for hospital, and hold the Olympic Games near the residing city of this hospital or its, hospital administrators can be predicted the goods and materials commonly used that need to order extra quantity. Client software can make the client can carry out fast this order.
The client can by button click or interactive with graphic interface or physical interface, start this order. In the preferred embodiment, product or product group selection that the client can comprise from library programming, perhaps the client can search product by being similar to previously described interface. As indicated above, but client's specified value advances quantity in stock again, and client software can use this amount by agreement when the extra stock of client requests. Client software also can provide the amount of grasping at hand, helps the client to make astute buying judgement. According to this information, the client can revise size of order before proposing order.
Client software can send to server client's order, in case when receiving client's order, server just can start to order goods fulfils processing.
Server also can be ordered goods automatically according to customer requirement. Server periodic scan client product tablet menu monitors the consumption of stock. When stock reduced, server can be predicted ordinary articles, and orders suitable amount, and server is ordered first the amount of restriction, with restriction client expense. Server can consume according to the client domination of custom, increases the size of order of normal ordering products. Server also can make up history and utilize feature, in order to automatically consider to consume season pattern or other stages consumption pattern.
When proposing to order goods, but server query link supplier stock, to determine the ability of each supplier's performance of the contract. Process when respectively ordering goods, server can calculate shipping charges usefulness, and the one or more suppliers that select the energy Cost meet customer need with economizing. When identifying qualified supplier, propose to order goods, can judge according to client's regulation or server, comprise quick deliver goods and other options.
The server APS of supplier's invoice can also being entered item in an account produces client's invoice according to supplier's invoice, with client's invoice accounts receivable system of entering item in an account. Server can also further combine with automated payment system, thus Limit exploitation ticket and other expenses.
Except the client orders goods the relevant function, server also provides management function. As an example, not limiting the present invention, is not that client's user can be registered as the client by the interface that server is provided. This interface allows the user to use prescribed transactions title, type of transaction, functional manager or general manager, actual address, address, specific address, one or more phone number, employee's title and credit information etc.
When the user proposed these information, the certain address of server, phone number and postcode were all effective separately, and all need to column fill out. If confirm unsuccessfully, server provides the data entry page face with invalid data, thus the correction of reduced data.
Server and client software also allow client and supplier to change various information, as an example, do not limit the present invention, supplier can change price, increases or removes sellers and product, addendum or remove contact, watch account's situation and open invoice, and carry out other this type of functions. The client can adjust quantity in stock counting, and with the reflection auditing result, payment and contact details are upgraded in addendum or remove employee and employee information, watch account balance and pay, and carry out other this type of functions.
Link supplier can also utilize many above-mentioned key elements. Realize that link of the present invention supplier can track inventory, the client of real-time inventory information to expection is provided, accept electronic order service, tabulation is selected/is packed in generation, follow the tracks of to order goods and to fulfil processings (comprise follow the tracks of in the order each article pack into which container), produce bar code and be equipped with table and each pallet loading mark, and produce invoice.
The present invention also provides other advantages above prior art for link supplier. As an example, do not limit the present invention, can be according to previous order resume, before ordered goods interval, safety stock etc., the requirement of prediction link supplier inventory, thus reduce total inventory investment. The present invention also makes link supplier can follow the tracks of processing and the shipping condition of each product in the order, thereby higher customer service is provided. The present invention also makes manager or other persons of having the right sign electronically to buying order form, invoice, other bills or ordering documentation, and the recipient's electronics that is fit to is sent this document.
In order to reach above-mentioned functions, preferred embodiment of the present invention comprises following list structure. Comprising following list structure is in order to realize and mode the best, should not to be restricted the present invention.
Table name-client computer control
But explanation and function-Ben Biao the machine of table reside at client computer. It can be stored and contain remote side administration online and one or more records of the required control data of offline functionality. These records can pass to by the SQL database from Web server the renewal applet of this control and upgrade. Also provide the control to the processing that moves on the local computer even its objective is off-line, and can automatically reconnect.
Column (section) title | Explanation |
Customer ID | Customer ID-the meet Customer ID of customer data in the Web server SQL database |
The IP address | This is the IP address of the machine |
The DSL port | Access path or port (such as COM2) when existing DSL to connect, the machine are zero during without the DSL circuit |
The dialing port | Access path when having dial-up connection or port (such as COm3), the machine are zero during without dial-up connection |
The dial-up connection phone | The phone number that software is dialled is used for setting up the dial-up connection to web server system. Be zero during without dial-up connection. |
The dialing callback | The phone number of dial user's line makes Web server recyclable. |
Table name-client computer error log
The explanation of table and function-this table comprise the mistake of processing that starts on the client computer and produce resume. It can provide and check tracking, observes the processing capacity good degree, and the position of the error condition that records serious error condition and do not need the client is shown is provided. Its data can be not processed, but can be stored, and observes for system manager and manager.
Column (section) title | Explanation | Duan Tezheng and index |
Make mistakes the date | The error log input item date | Index-with the time juxtaposition of makeing mistakes |
Make mistakes the time | The time of error log input item | Index-with makeing mistakes the date |
Caller | Produce the program name of error log cuit | |
Error message | The error message that caller produces | |
The user is visual | It is "Yes" that the user watches when also showing information on the page or leaf, is "No" during internal information only. | |
Data draw off | Cause the data (if existence) of mistake | |
Table name-system errors record
Explanation and function-this table of table can comprise the resume that client computer one side begins mistake that this processing produces. This table can provide and check tracking, observes the processing capacity good degree, and the position of recording serious and non-serious mistake is provided. These data make system manager, programmer and manager can monitor that automatic nothing directly keeps processing. System errors record can be with the data dictionary/segment structure that is similar to client's error log table.
Column (section) title | Explanation | Duan Tezheng and index |
Make mistakes the date | The error log input item date | Index-with the time juxtaposition of makeing mistakes |
Make mistakes the time | The time of error log input item | Index-with makeing mistakes the date |
Caller | Produce the program name of error log cuit | |
Error message | The error message that caller produces | |
The user is visual | It is "Yes" that the user watches when also showing information on the page or leaf, is "No" during internal information only. | |
Data draw off | Cause the data (if existence) of mistake | |
Table name-systematic parameter
Explanation and the function-parameter of storage system scope in common table of table.
Column (section) title | Explanation | Duan Tezheng and index |
PARAM_ID
| The identifier parameter | Master index |
VAR1
| The 1st variable | |
VAR2
| The 2nd variable | |
VAR3
| The 3rd variable | |
Table name-Client application
The explanation of table and function-this table can have the data dictionary that is similar to client's table, can be used for temporarily depositing not approval and the untreated application data that client/client application page or leaf can propose. When processing application, can be from the suitable record of this list deletion.
Column (section) title | Explanation | Duan Tezheng and index |
See that the client shows | | |
Table name-member application
The available data dictionary that is similar to the opening membership table of the explanation of table and function-this table, and can temporarily deposit not approval and the untreated application data that client/client application page or leaf can propose. Can be from the suitable record of this list deletion when processing application.
Column (section) title | Explanation | Duan Tezheng and index |
See the opening membership table | | |
Table name-client
The explanation of table and function-can in permanent table, deposit the unique identifier of each client. Activation record is in the customer care resume. Can link the 3rd side and use, to obtain credit term, to be made out the bill and shipment, phone and other financial datas in the address.
Column (section) title | Explanation | Remarks | Duan Tezheng and index |
The client | The identification client | Unique identifier (account number); Meet the client's table in the A/R system | Master index |
Title | The professional name of opening | See opening membership table doctor data | Index |
Sell the consultant | Identification is assigned to account's sale consultant | | Index |
IP address 1 | The IP address that is used for link and identification client office computer | Can there be the multi-section computer in larger office | |
IP address 2 | The IP address that is used for link and identification client office computer | Can there be the multi-section computer in larger office | |
IP address 3 | Be used for link and identification | Larger office can have | |
| The IP address of client office computer | The multi-section computer | |
IP address 4 | The IP address that is used for link and identification client office computer | Can there be the multi-section computer in larger office | |
The discount code | Which identify with the receipts valency of discount code to this client | The code of necessary usefulness in the discount code table | Index |
Actual address | The street address of opening | | |
Actual country | The country one belongs to of opening | | |
Actual postcode | The open for business postcode at place, actual place | | |
The shipment arrival address | The shipment arrival address | | |
Shipment arrives country | Shipment arrives country | | |
Shipment arrival place mail coding | Shipment arrival place mail coding | | |
The letters address | Letters address (except shipment) | Only be used for printed matter and file (can be the mailbox that UPS and FedEx can not send to) | |
Receipts letter country | Letters address the country one belongs to | | |
The letters postcode | The postcode of letters address | | |
The keeper | Client's keeper, manager etc. | | |
Table name-opening member
The record of the explanation of table and function-this table energy chain prostitution family table, and can deposit each doctor of work or opening or the data under other health professionals.
Column (section) title | Explanation | Remarks | Duan Tezheng and index |
The client | The client of opening member association | Must be in client's table | Index-with member's name juxtaposition |
Member's name | The health professional of link client table or doctor's name | Form unique record key with the client hurdle | Use the client hurdle |
The member street corner | Member's street corner (for example functional manager) | | |
Member's Post address | Member's independent address | | |
Member's letter the country one belongs to | Member's letters address the country one belongs to | | |
Member's letter postcode | The coding of member's letter mail | | |
Member's license number | Member's license number | | |
Member's license off period | Member's license off period | | |
Member's grade 1 | One-level member | | |
Member's grade 2 | The secondary member | | |
Member's grade 3 | Three grades of members | | |
Member's class 4 | Level Four member | | |
Member's note | Text/remarks section | | |
New date | Increase this member's date in the table | | |
The last date | The movable date of last | | |
Table name-discount code
The explanation of table and function-can comprise unique price of discounting was collected or allowed in representative to each client decimal system numerical value. Any amount of client can be with a discount code. When changing the related decimal system extreme value of given code, can cause the change with whole clients' of this yard covering price. If the discount value of the regulation of the client's of given product discount code is greater than permissible value, the present invention can limit the maximum-discount valency.
Column (section) title | Explanation | Remarks | Duan Tezheng and index |
The discount code | The discount code | Identify specific discount, be numbered 10,20,30 etc., take insertion from now on into account, for example 14 | Master index |
The discount value | Value is advanced by institute discounted ten | | |
Note | The text chunk of a certain discount code of note | | |
Table name-client's product inventory
The explanation of table and function-deposit holdings in client office. Each client/SKU combination has a record, comprises whole data of using in the past or next order cycle time will be used. Permanent table. In client's product inventory issued transaction table, recording activity.
Column (section) title | Explanation | Remarks | Duan Tezheng and index |
The client | The identification client | | Index-with product hurdle juxtaposition |
Product | The product of identification curstomer`s site | | Index with the client hurdle |
Standing crop | This client's article standing crop | | |
ROP
| An amount of placing an order again | When standing crop drops to this amount that is equal to or less than, product is started new the order | |
ROQ
| The amount of ordering goods | During " startup " product, this amount is adopted in order handling | |
State | The article active state | Numerical value: movable (default, the normal setting); (continue to use stock, without further ordering goods without ordering goods; Need not (not accept the product consumption | Index |
The explanation of table name-product table and function-regulation any time point can supply product sold. Comprise no longer movable product. Each product/SKU/ Item Number there is a record.
Column (section) title | Explanation | Remarks | Duan Tezheng and index |
Product IDs | Identification product, SKU also are " Item Numbers " | | Master index |
Short explanation | The short explanation that occurs on most printouts and the screen | | Index |
Long explanation | The long explanation that supplemental instruction is used | | Every word is separately indexed |
Manufacturer | The company that manufactures a product must be in manufacturer's table | | Index |
Manufacturer's Item Number | The product identifiers of manufacturer | | Index |
State | The article state | Value: movable (default, the conventional consumption); Without order goods (accept and consume scanning, without ordering goods); Need not (do not accept and consume scanning, inertia, discarded or inactive) | |
The product rank | The production marketing rank | | Index |
The product group | Product at the same level | | Index |
Product line | The financial report class of product | | Index |
Sell Start Date | It is new to process this product | Do not carry out before this date | |
| The date of ordering goods | Order goods (thereby there is no new product) | |
Sell the Close Date | Can not process the new last date of ordering goods of this product | This date or do not order goods thereafter (product of stopping using) | |
Product picture | The bit map picture of product picture | JPEG or GIF | |
Table name-manufacturer
Whole manufacturers that the explanation of table and function-this table are deposited contained product in the product table are as the reference proof list of product.
Column (section) title | Explanation | Remarks | Duan Tezheng and index |
The ID of manufacturer | Manufacturer is called for short | | Master index |
Manufacturer name | The regular business name of manufacturer | | Index |
Add the date | Manufacturer enters to show the date | | |
Table name-order
The explanation of table and function-deposit by the order of processing night and/or the rush order processing produces, then download it to the dealer. As order form " stem ". The order details table of series of articles is deposited in link. Without keeping the placement file table. The order of each generation and download has a record.
Column (section) title | Explanation | Remarks | Duan Tezheng and index |
Job number | Job number, the unique identifier of order | Produced by order handling, job number is increased progressively the systematic parameter hurdle | Master index |
Order goods the date | Produce the date of ordering goods | | Index |
The order time | Produce the time of ordering goods | | |
The order source | How to produce order | The source is: automatically-process night manually-artificial on client office terminal | |
| | The order of input | |
The client | The client who orders goods | | Index |
Link supplier | Download the link supplier of order form | | Index |
The order state | The order state only illustrates nearest state, and order is imagined | The PLACD-that value: GEN-produces is downloaded to supplier S_BILIED_ supplier the Med-e-Track C_BILLED_ system that draws a bill is transformed into client's invoice with supplier's invoice | Index |
The state date | The date that state changes | | |
The shipment arrival address | The address that shipment will arrive comes across the order data of download | | |
ORDER_PRODUCT_
TOTAL
| Only be the product order total value, do not contain the expenses such as tax, shipment | | |
Table name-order details
The explanation of table and function-the deposit series of articles details of order table. Every a series for articles of ordering goods has a record.
Column (section) title | Explanation | Remarks | Duan Tezheng and index |
Order details manifest unit | Order unit under this detail records | | Index-with order series number hurdle juxtaposition |
The order series number | The order series number | Form unique identifier by order details goods unit number hurdle | |
Product | The product identifiers of ordered article | | Index |
Size of order | Ordered product volume | | |
Shipping amount | The containment and transport of objects amount is reflected in to upload and processes supplier's invoice/packing list | | |
Client unit's valency | Will be to the price of client's charge | | |
Client unit's sale tax | Sale tax when the client is charged | | |
The product order subtotal | Value=size of order * client unit valency | | |
Product shipment subtotal | Value=shipping amount * client unit valency | | |
Link supplier unit costs | Link is for merchant's valency of paying of article for this reason | | |
Link supplier products shipment subtotal | Value=shipping amount * link supplier unit costs | | |
Table name-link supplier
Each link supplier, i.e. dealer that the explanation of table and function-deposit and set are entered web. Now link, there is a record in each supplier who has linked when entering Med-e-Track. Activation record is kept resume in link supplier. At SOLOMAN account's account payable subsystem the account is linked to supplier's table.
Column (section) name | Explanation | Remarks |
Supplier | Supplier's ID | Unique identifier |
Supplier IP address | The IP address that link is processed occurs | |
The open date | Set up and start the date of relation | |
Table name-supplier's invoice
Invoice/packing list that the explanation of table and function-deposit are uploaded from link supplier. Record stem as invoice. Given order can have multiple invoice. Be linked to the supplier's invoice details table with the series of articles details. The invoice reflection of uploading from the dealer has been loaded and transported and for generation of the order of client's invoice. The invoice data of uploading also passes to account's account payable module of Solomon IV software, is used for uniting payment/tracking. Client's invoice of the generation in this table and record also passes to account's account due module.
Column (section) title | Explanation | Remarks | Duan Tezheng and index |
Interdepartment invoice ID | The interdepartment invoice identifier that system produces | Guarantee when supplier's invoice design/number is similar that invoice identification is unique | |
Order goods | The order odd numbers of shipment/bill invoice | | |
Supplier's invoice | Invoice identifier from supplier | The invoice data of uploading | |
Supplier's date of invoice | Supplier's date of invoice of uploading | | |
Supplier's invoice time | Supplier's invoice time of uploading | The invoice time can not appear in the supplier database | |
The AP date | Supplier's invoice data is charged to the date of AP table | | |
The AP time | Supplier's invoice data is charged to the time of AP table | | |
Client's invoice | Process the invoice ID that produces night, be used for opening the shipment bill to the client | Referring to now that process night moves, produces this separate invoice number | |
Client's date of invoice | Process the client's date of invoice that produces night | | |
Client's invoice time | Client's invoice produces the time of processing | | |
The AR date | Time | | |
Shipment | Shipping file number | Can tell from invoice number | The packing list data retrieval |
| | | With this segment index |
Shipment is via mode | Handling technigue, for example, land UPS | | |
Table name-interdepartment invoice shipment details
The explanation of table and function-this table comprise the shipment information that the affiliated child shipments of interdepartment invoice is used. Each carton that contains the affiliated shipment voucher of invoice has a record. Link interdepartment invoice table.
Column (section) name | Remarks |
Interdepartment invoice ID | |
Packaging carton ID | ID is in the same place with invoice, comprises unique Record ID |
Tracker number | |
Table name-supplier's invoice details
The explanation of table and function-originally be accompanied with the grade details of series of articles, be used for uploading invoice from link supplier/dealer. The grade details of some series of articles is used for upgrading the order data, is used for the article of supporting that quick order status poll and traceback are ordered goods.
Column (section) name | Explanation | Remarks |
Interdepartment invoice ID | The interdepartment invoice symbolic identifier | |
The interdepartment invoice series number | The series number of interdepartment invoice | With the interdepartment invoice identifier together, form unique key |
The shipment product | The product of shipment | |
Shipping amount | Shipping amount | |
The unit valency | Supplier's unit valency | |
Unit tax | Sale tax (if existence) | |
The expansion valency | Numerical value=shipping amount * unit valency | Product subtotal only |
The series tax amounts to | Numerical value=shipping amount * unit tax | |
The total metering of series | Expansion valency+total serial tax | |
Table name-supplier's expense
The explanation of table and function-deposit each link supplier's in the payment system price. Each link supplier and SKU permanent table have a record. Activation record is kept resume in supplier's expense.
Column (section) title | Explanation | Remarks | Duan Tezheng and index |
Table name-supplier's expense is kept resume
The change that the explanation of table and function-record carry out supplier's expense record. When given record upgraded, each becomes for the group section a record.
Column (section) title | Explanation | Remarks | Duan Tezheng and index |
Table name-product is kept resume
The change that the explanation of table and function-record carry out the product table. When upgrading given record, each changes section a record.
Column (section) title | Explanation | Remarks | Duan Tezheng and index |
Table name-product rank
The explanation of table and the rank of function-effective product of regulation are as reference table.
Column (section) name | Explanation |
The product level code | The code that the product rank is used is described |
Explanation | The text of product level code/illustrate name |
Table name-product group
Explanation and the effective product group of function-regulation of table are as reference table.
Column (section) name | Explanation |
The product group code | The code that the product group is used is described |
Explanation | The text of product group code/illustrate name |
Table name-product line
The explanation of table and function-stipulate effective product line, as reference table.
Column (section) name | Explanation |
The product line code | The code that product line is used is described |
Explanation | The text of product line code/illustrate name |
Table name-visitor's note product inventory issued transaction
The explanation of table and function-for the issued transaction resume of changing client's product tablet menu data activity, it is that the record stock is movable that each change record has a record, main application, although produce issued transaction, be used for change state, ROP, ROQ and note value, the i.e. value of non-standing crop. Each issued transaction only affects a data segment. Transaction code indicates to carry out what renewal/change activity, thereby indicates which data segment of renewal.
Column (section) name | Explanation | Remarks |
Transaction number | The unique identifier of each issued transaction, non-effective number | Function class is like verification number |
The issued transaction date | Issued transaction is carried out the date | |
Transaction time | Issued transaction is carried out the time | |
Issued transaction ID | The issued transaction identification code | Value: TBD |
Product | Affect the product identifiers of article | |
Quantity | | |
The client | The client of inventory Data Update/variation | |
ID | The user finishes transaction | |
BEFORE_VALUE
| The data segment value before the new element more | |
AFTER_VALUE
| The data segment value after the new element more | |
Table name-relationship record
The explanation of table and function-this table are inputted and are followed the tracks of it by the issued transaction of receiving from consultant's request function, in order to follow the tracks of and management.
Column (section) name | Explanation |
Sell consultant ID | Sell the ID in consultant's table |
The request date | The client sends the date of request |
Request time | The client sends the time of request |
Table name-client's user
The explanation of table and function-this table are deposited the information about each user in the curstomer`s site. Two class users are arranged: supervisor and employee. The user who only has supervisor's power can increase new user. This client's webpage hardwired is so that client's user can keep related with correct client.
Column (section) title | Explanation | Remarks | Duan Tezheng and index |
Explanation and function-this table of table name-sale consultant table are deposited relevant each sale consultant's data, are a kind of reference table basically.
Column (section) name | Explanation |
Sell consultant ID | Unique identifier * records key |
The consultant is called for short | Be used for screen, the abbreviation of report, catchword, name initial |
The full name of consultant | Consultant's name |
Consultant's surname | Consultant's surname |
It will be understood by those skilled in the art that the present invention can carry out stock's tracing and managing by the combination of artificial, semi-automatic and automated process. The present invention also makes the manager make a big purchase in large quantities and to utilize and promotes and other special prices, thereby reduces inventory carrying cost. In addition, the present invention is by accurately simulating and the prediction inventory requirements, and minimizing must remain on the quantity in stock in storehouse. The present invention also further can observe new equipment for the client provides, and the ability of the equipment etc. of superfluous stock, renovation is bought and sold in mutually intercommunication.
Although disclose in detail and illustrate preferred embodiment of the present invention and various alternative embodiment here, but can knowing on its form and the details, those skilled in the art can do various changes, comprise the present invention is used for health care field in addition, and do not depart from the spirit and scope of the invention.