Wiki source code of Transactions

Content
Hide line numbers
 1: == Transactional Extracts ==
 2: 
 3: These are the set of report extracts, designed to be run at regular intervals, to support organisations create appropriate reporting suites for their own business customers.
 4: The following principles apply to the parameter filters for the Business transaction extracts:\\
 5: 
 6: * The major parameters are:
 7: ** The organisation or part of it that owns the order transactional data
 8: ** The date range for the extraction of the orders, receipts and invoices[[ For more detail see specifying a date range>>doc:Date Ranges]]
 9: * All the other parameters are subservient to these and the defaults:
10: ** The sub-status parameters have been included for some backward compatibility with the previous versions of PECOS reporting. Please note a user can only select one value for a sub-status. Multiple value filtering is best done either in the Interactive Viewer or in Excel, both of which support mechanisms for complex filtering requirements.
11: 
12: The data is intended to be extracted at regular intervals (scheduled by the business) and presented as a table. This layout is intentionally designed to facilitate the Actuate Report viewer to manipulate the data in the extract report and desktop tools such as Excel.
13: 
14: |=Master Report Extract |=Description 
15: |[[Order Level Transactions>>doc:Order level]]|Order version header summary records whose dimensions are the buying organisation and person responsible for the orders and suppliers.
16: Its intention is to allow the organisation to understand the volume and value of the orders being processed within their organisation.
17: The records have order versions to help analyse the variance of committed order values between the versions of the same order.
18: |[[Order Lines Transactions>>doc:Order Lines]]|Order version lines summary records whose dimensions are the buying organisation and person responsible for the orders/requests, commodity category and suppliers.
19: The records have order versions to help analyse the variance of committed order values between the versions of the same order.
20: |[[Order Lines with Financial Transactions>>doc:Order Lines FTC]]|Financial Tracking Code bookings against order version lines whose dimensions are the organisation, buyer and supplier. Each line booking can be split and therefore can appear more than once.
21: The versions also deal with the variance of committed order values between the versions of the same order by posting reversals when the order is superseded.
22: |[[Receipt/Return Transactions>>doc:Receipts or Returns]]|Records of receipts and returns against order lines whose dimensions are the requisitioner, receiver and supplier.
23: |[[Invoiced Order Lines with Financial Transaction>>doc:Invoice Lines]]|Financial Tracking Code bookings against invoice lines whose dimensions are the organisation, requisitioner and supplier, budget and account codes.