Parameter

Description

Organisation

This will default to the highest level of buying organisation and will be used to restrict the data extracted. The report requester will be able to select a lower level group within their organisation tree and thus filtering the order data extract.

Start Date

This is the start date of the date range used to select the orders based on the Purchase order date.

End Date

This is the end date of the date range used to select the orders based on the Purchase order date.

Number of Days to Extract

Used to calculate a moveable date range every time the report job runs.

• Start date will be set to (Run date - Number of days to extract)
• End date will be set to the Run date

This assumes that the Extract Up to and Including (End date) has No Value entered.

If a value is entered for the Extract Up to and Including (End date) then the date range becomes a Fixed Range. 

Extract Up to and Including

If a value is entered for the Extract Up to and Including (End date) then the date range becomes a Fixed Range used in conjunction with the Number of Days to Extract.

Budget or Account Code Filter

A string part or all of the account code for the posting of a budget reference code. The system will prompt for the type of match.

Order Issued Status

The default is "Issued", but the user can select “In Edit”, “In Approval”, “Withdrawn” or “All” from dropdown list, (Withdrawn are for requisitions that were never issued after being submitted and returned to the requisitioner).

Order Status

"All" is the default and the user is presented with a list.

Order Receipt Status

"All" is the default and the user is presented with a list.

Line level FTC

Derivation

Requisition No

The Identifier that the system assigns to make each requisition unique.

Requisition Type

Requisition, Standard Order, Public Template or Private Template. 

Grouping Name (Rec Req)

If the field is not empty it is an identifier of a template from which the order has been generated.

Original PO No

The Internal number Identifier that the system assigns to the first version of the order and can be used to group all versions of an order.

PO No

The Identifier that the system assigns to make each order unique within your organisation. Subsequent version adds a numeric suffix to the Original Purchase Order Number.

Version

This is the sequence number of the version of an order.

Posting Type

When an order version is Approved the values are the positive for all the lines unless this is the last version when all the live lines are by default cancelled. The previous version is "superseded" and the values on the line relate to the live lines being withdrawn.

Line No

The line number of the item in the order.

PO Date

The date on which the Purchase Order (version) has been issued. If the order is still a request awaiting approval then the date will be the date of submission for approval or if not submitted then this will be the date the requisition has been created.

Required Date

When the order items are required.

Item No

The suppliers Identifier for the Item.

Description

A description of the Item/Service being ordered.

Item Classification

The commodity/service category applied to the Item. This is usually based on the UNSPSC taxonomy.

Non-Cat Item

Indicating if the item is a Catalogue or Non-Catalogue purchase.

Supplier ID

The internal identifier that make the supplier unique.

Supplier

The name of the supplying organisation.

Source

The system can load Orders/Requisitions either online or through a background process when they have been created elsewhere.

Requisitioner Name

The Name of the user looked up from the username (sign on identifier) of the person who raised the requisition/order.

Delivery Name

The name entered into the Delivery Name field on the order.

Requisitioner ID

The user name (sign on identifier) of the person who raised the requisition/order.

Buy-For ID

The username identifier of the User on whose part the requisitioner has raised the order.

Currency

The ISO Currency Code in which the order is raised.

Qty

The number of units of the line item ordered.

Item Price

The price per unit for the ordered item.

Net Price

The item price multiplied by the item Quantity.

Net Acc Code Commitment

The value to be posted against the account code (Net Price* line% split for the code).
The value will be positive when the status is approved however if superseded (or cancelled) the postings will be reversals (-ve) of the original amounts. This is because the version will appear twice the second being the negative values.

Order Issued Status

The Orders can be
  "In Edit": either not yet submitted or it has been returned to the approver.
 "In Approval" submitted for approval but not yet turned into an order or returned to the requisitioner.
 "Issued" This version has been committed represents the values the time of the PO date.
 "Withdrawn" A version that having been returned to the requisitioner is cancelled.

Order Status

A status that reflect the processing of the order.

Receipt Status

 This reflects the overall status of any receipts that have been made against the order.

Received Qty

Were the receipt is to be recorded in the units ordered this is the quantity of receipts for this line item.

Returned Qty

Were the receipt is to be recorded in the units ordered this is the quantity of returns for this line item.

Received Amt

Were the receipt is to be recorded against the value ordered this is the value of receipts for this line item.

Returned Amt

Were the receipt is to be recorded against the value ordered this is the quantity of returns for this line item.

UOM

The unit of measure code that the item is ordered in. Usually a subset of the ISO standard for measure. E.g., ‘EA’ for each or ‘KG’ for Kilo etc.

Owning Org ID

The internal identifier of the owning organisational group within the buying organisational tree that owns the order. This Identifier will allow the renaming of organisational nodes.

Owning Organisation

The name of the organisational group within the buying organisational tree that owns the Order.

Full Parentage

The full path with the organisation tree of the organisational group. This is done by the concatenating the identifiers of the parents of the owning group together. E.g., "A.B.C” this allows the filtering/grouping of data into higher levels within the organisation.

Method Key

The Internal Identifier of the account method used to describe the account code segments.

Method

The organisation’s title for the account method used to describe the account code segments.

Line %

The proportion of the net price to be posted to the account code.

Account Code

The Account Code against which the value will be posted.

Segment n(1-10)

10 Fields that show the individual value of components of the account code string.

Segment n(1-10) Description

The description associated with an individual value of component of the account code string.

Budget Ref

The short identifier used with the business to identify a budget.

Line Reference

The line reference within the budget.

Budget Code

The budget account code string used to group the posting

The heading should display the names of the segments referred to in the budget code e.g., Cost-Centre-Expense-Code.

Budget Period End

The date of the end of the budget period to which this applies.

Period Name

The name of the budget period e.g., Jan 2013.