Method and device for tracking and inquiring document

Abstract

The invention provides a method for tracking and inquiring a document, comprising the following steps of: step 102, recording the corresponding flowing information between a downstream service document and all upstream documents in a source relation table when the upstream service document flows to generate the downstream service document; step 104, searching the flowing information correspondingto the inquiring information in the source relation table according to the input inquiring information, wherein the flowing information comprises document to be inquired, key field corresponding to the document to be inquired and the corresponding data information of the key field; and step 106, obtaining the corresponding data information of the key field as the inquiring result. The invention also provides a device for tracking and inquiring the document. By recording the source relation, the technical solution of the invention reduces the cost for inquiring the executing condition of the document, obviously simplifies the inquiry and improves the inquiring speed and efficiency.

Description

technical field [0001] The invention relates to the process tracking of business documents in supply chain management, in particular to a method and device for tracking and querying documents. Background technique [0002] In traditional supply chain software, the query of the source relationship between various documents, and the query of the execution of the documents, such as the execution table of inbound and outbound, and the execution table of purchase order, the query of these reports needs to be based on the source and destination of each document. The document number is associated with the data of multiple documents to query, and the query efficiency is low, especially for multi-level related businesses, such as purchase demand analysis->purchase order->purchase order->purchase storage order->purchase return order, etc., need to query For the execution of the purchase order, it is necessary to associate the purchase demand analysis table, the purchase or...

AI Technical Summary

Problems solved by technology

[0016] When the source business table needs to obtain more and more downstream field information, the query statement becomes more and more complex. If the association relationship is not clear later, the probability of error will increase significantly, and the associated query statement and content will become larger and larger , organized into a super large virtual table in memory, and the processing efficiency of the database engine is getting lower and lower

Images