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 receipts based on the recorded date.

End Date

This is the end date of the date range used to select the receipts based on the recorded 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.

Receipts

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.

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.

Line No

The line number of the item in the order.

Movement Date

The date on which the receipt or return happened.

Recorded

The date on which the receipt or return information was entered into PECOS.

Manufacturer

Name of the manufacturer of the item, this may be empty.

Mfr No

Manufacturers Identifier for the item. This may be blank.

Item No

The suppliers Identifier for the Item.

Description

A description of the Item/Service being ordered.

Supplier ID

The internal identifier that make the supplier unique.

Supplier

The name of the supplying organisation.

Receiver ID

The logon identifier of the user recording the receipt.

Receiver Name

The name of the user recording the receipt.

PO Receipt Status

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

Line Receipt Status

Indicating the status of the line, i.e.,
 "Not Required"
 "Not Received"
 "Partially Received"
 "Fully Received"
 "Over Received"

Requested Qty

The number of units of the line item ordered.

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.

Item Price

The price per unit for the ordered item.

Net Price

The item price multiplied by the item Quantity.

Est Tax

The projected estimated value of any tax anticipated on the Invoice. This may vary from that which the supplier calculates.

Est Gross

The sum of the net price and the estimated tax.

Direction (Receipt / Return)

The direction of the movement of the goods either a "Receipt" or "Return" to the supplier.

Reference (RMA / DNOTE)

The reference documentation number such as the Delivery Note number for a "receipt" or for a "return” the Returns Material Authorisation number (RMA).

Document Quality

This is a codification summary for the whole movement which may encompass multiple items if it is a full, partial or over supply/returned. It is blank on “Returns”.

Movement Quality

A codification explaining if the receipt is full, partial or over supplied.

Qty

The quantity of the item received or returned.

Amt

The value of the receipt or return.

Owning Org ID

The internal identifier of the owning organisational group within the buying organisation a 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 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.