Transaction field

A transaction field can be used to index a report that contains pages of records with one or more columns of sorted data and it is not practical to store every value in the database. For example, each page of a general ledger report contains up to 80 transaction records. Each record contains a unique value, such as a transaction number. The records in the report are sorted on the transaction number. Rather than storing every transaction number in the database (perhaps hundreds of thousands of rows), you can segment the report into groups of pages (say, 100 pages in a group), extract the beginning and ending transaction number for each group of pages, and store the values in the database. To retrieve the segment of the report that contains a specific transaction number, a user specifies a transaction number. Content Manager OnDemand compares the transaction number with the beginning and ending values stored in the database and retrieves the segment that matches the query.