| FACT |
ERP |
FIELD NAME |
Definition |
| Purchase Orders |
AP21 |
Purchase Order Number |
Unique chronological number generated by the system at the time a Purchase Order is raised. |
| Purchase Orders |
AP21 |
Production Order Number |
Unique chronological number generated by the system at the time a Production Order is raised. |
| Purchase Orders |
AP21 |
Order Date |
The date the Purchase Order was raised |
| Purchase Orders |
AP21 |
Shipment Date (Purchase Order) |
The date entered into the named field in the Purchase Order |
| Purchase Orders |
AP21 |
Original Due Date |
The field capturing the original due date entered into the Purchase Order |
| Purchase Orders |
AP21 |
Due Date |
The current Due Date entered into the Purchase Order. Purchase Orders are linked to the Calendar by this Due Date field. |
| Purchase Orders |
AP21 |
Order Status |
Displays the Purchase Order Status Name in the Order eg. Confirmed, Not Confirmed |
| Purchase Orders |
AP21 |
Order Type |
Displays the Purchase Order Type Name in the Order eg. Bulk Fabric |
| Purchase Orders |
AP21 |
Shipment Type |
Displays the Shipment Type Name in the Order eg. Air, Road, Sea |
| Purchase Orders |
AP21 |
Order Category |
Displays the Purchase Order Category Name in the Order eg. External |
| Purchase Orders |
AP21 |
Order Classification |
Displays the Order Classification of the Order. Eg Cancelled, Completed, Receipted |
| Purchase Orders |
AP21 |
Style Has Price History |
A flag to denote if a style has price history - Y or N |
| Purchase Orders |
AP21 |
Supplier Units Per Carton |
Privides the count of the number of units in the carton as packed by the supplier |
| Purchase Orders |
AP21 |
UOM |
Units of Measure as entered into the Purchase Order |
| Purchase Orders |
AP21 |
Shipment Fiscal Year |
The Shipment Date as it applies to the Fiscal Year |
| Purchase Orders |
AP21 |
Shipment Fiscal Quarter |
The Shipment Date as it applies to the Fiscal Quarter |
| Purchase Orders |
AP21 |
Shipment Fiscal Month |
The Shipment Date as it applies to the Fiscal Month |
| Purchase Orders |
AP21 |
Shipment Fiscal Week Year |
The Shipment Date as it applies to the Fiscal Week Year |
| Purchase Orders |
AP21 |
Due Fiscal Year |
The Due Date as it applies to the Fiscal Year |
| Purchase Orders |
AP21 |
Due Fiscal Quarter |
The Due Date as it applies to the Fiscal Quarter |
| Purchase Orders |
AP21 |
Purchase Order Number Alpha |
The Purchase Order Number represented as a text |
| Purchase Orders |
AP21 |
Due Fiscal Month |
The Due Date as it applies to the Fiscal Month |
| Purchase Orders |
AP21 |
Due Fiscal Week Year |
The Due Date as it applies to the Fiscal Week Year |
| Purchase Orders |
AP21 |
Special Instructions |
Any Special Instructions as noted in the Purchase Order 'special instructions' field |
| Purchase Orders |
AP21 |
Shipment Number |
The Shipment Number as it relates to the selected Purchase Order |
| Purchase Orders |
AP21 |
Shipment Date (Shipment) |
The Shipment Date from Shipments as it relates to the selected Purchase Order |
| Purchase Orders |
AP21 |
Shipment Expected Departure Date |
The Shipment Expected Departure Date as it relates to the selected Purchase Order |
| Purchase Orders |
AP21 |
Shipment Expected Arrival Date |
The Shipment Expected Arrival Date as it relates to the selected Purchase Order |
| Purchase Orders |
AP21 |
Shipment Status |
The Shipment Status as it relates to the selected Purchase Order |
| Purchase Orders |
AP21 |
Shipment Departure Port |
The Shipment Departure Port as it relates to the selected Purchase Order |
| Purchase Orders |
AP21 |
Shipment Arrival Port |
The Shipment Arrival Port as it relates to the selected Purchase Order |
| Purchase Orders |
AP21 |
Standard Unit Cost |
The Standard Unit Cost as entered into the Purchase Order (usually the landed cost) |
| Purchase Orders |
AP21 |
Unit Price |
The Unit Price as entered into the Purchase Order (usually the FOB cost) |
| Purchase Orders |
AP21 |
Units Per Carton |
The number of units per Carton as it relates to the selected Purchase Order |
| Purchase Orders |
AP21 |
Has On Order Units |
Flag to filter Purchase Orders with an Active status, 'Y' or 'N' |
| Purchase Orders |
AP21 |
Original Order Units |
The sum of the number of units entered into the Original Order |
| Purchase Orders |
AP21 |
Order Units |
The sum of the number of units currently entered into the Order |
| Purchase Orders |
AP21 |
On Order Units |
The sum of the number of units showing as On Order where 'has on order units' = 'Y' |
| Purchase Orders |
AP21 |
Received Units |
The sum of the number of units showing as Received against the Purchase Order. Please note, Receipts are linked to the calendar by the PO Due date. |
| Purchase Orders |
AP21 |
Invoiced Units |
The sum of the number of units showing as Invoiced against the Purchase Order |
| Purchase Orders |
AP21 |
Original Order Units Var |
The Variance between the number of units entered against the Original Order compared to the number of units entered against what is showing as Order Units after Receipts where PO status is 'Active' |
| Purchase Orders |
AP21 |
Cancelled Units |
The sum of units that have been Cancelled after Receipts |
| Purchase Orders |
AP21 |
Original Order Cost $ |
The sum of the number of units entered into the Original Order * Standard Unit Cost in the Purchase Order |
| Purchase Orders |
AP21 |
Order Cost $ |
The sum of the number of units currently entered into the Order * Standard Unit Cost in the Purchase Order |
| Purchase Orders |
AP21 |
On Order Cost $ |
The sum of the number of units showing as On Order where 'has on order units' = 'Y' * Standard Unit Cost in the Purchase Order |
| Purchase Orders |
AP21 |
Received Cost $ |
The sum of the number of units showing as Received against the Purchase Order * Standard Unit Cost in the Purchase Order |
| Purchase Orders |
AP21 |
Invoiced Cost $ |
The sum of the number of units showing as Invoiced against the Purchase Order * Standard Unit Cost in the Purchase Order |
| Purchase Orders |
AP21 |
Original Order Cost $ Var |
The Variance between the number of units entered against the Original Order compared to the number of units entered against what is showing as Order Units after Receipts where PO status is 'Active' * Standard Unit Cost in the Purchase Order |
| Purchase Orders |
AP21 |
Cancelled Cost $ |
The sum of units that have been Cancelled after Receipts * Standard Unit Cost in the Purchase Order |
| Purchase Orders |
AP21 |
Original Order Retail $ |
The sum of the number of units entered into the Original Order * Current Retail price from Price History ex GST |
| Purchase Orders |
AP21 |
Order Retail $ |
The sum of the number of units currently entered into the Order * Current Retail price from Price History ex GST |
| Purchase Orders |
AP21 |
On Order Retail $ |
The sum of the number of units showing as On Order where 'has on order units' = 'Y' * Current Retail price from Price History ex GST |
| Purchase Orders |
AP21 |
Received Retail $ |
The sum of the number of units showing as Received against the Purchase Order * Current Retail price from Price History ex GST. Please note, Receipts are linked to the calendar by the PO Due date. |
| Purchase Orders |
AP21 |
Invoiced Retail $ |
The sum of the number of units showing as Invoiced against the Purchase Order * Current Retail price from Price History ex GST |
| Purchase Orders |
AP21 |
Original Order Retail $ Var |
The Variance between the number of units entered against the Original Order compared to the number of units entered against what is showing as Order Units after Receipts where PO status is 'Active' * Current Retail price from Price History ex GST |
| Purchase Orders |
AP21 |
Cancelled Retail $ |
The sum of units that have been Cancelled after Receipts * Current Retail price from Price History ex GST |
| Purchase Orders |
AP21 |
On Order Orig Retail $ |
The sum of the number of units showing as On Order where 'has on order units' = 'Y' * Original Retail Price from Price History ex GST |
| Purchase Orders |
AP21 |
Received Orig Retail $ |
The sum of the number of units showing as Received against the Purchase Order * Original Retail Price from Price History ex GST. Please note, Receipts are linked to the calendar by the PO Due date. |
| Purchase Orders |
AP21 |
On Order First Margin $ |
Calculation of the On Order First Margin using Original Retail Price at the time of the Purchase Order and the Standard Units Cost in the Purchase order |
| Purchase Orders |
AP21 |
Received First Margin $ |
Calculation of the Received First Margin using Original Retail Price at the time of the Purchase Order and the Standard Units Cost in the Purchase order. Please note, Receipts are linked to the calendar by the PO Due date. |
| Purchase Orders |
AP21 |
On Order First Margin % |
Calculation of the On Order First Margin as a % of the On Order Orig Retail $ |
| Purchase Orders |
AP21 |
Received First Margin % |
Calculation of the Received First Margin as a % of the Received Orig Retail $ |
| Purchase Orders |
AP21 |
On Order Avg Purchase Price |
The Average Purchasing Price of the On Order Value (On Order Retail $ / On Order Units) |
| Purchase Orders |
AP21 |
Received Avg Purchase Price |
The Average Purchasing Price of the Received Value (Received Retail $ / Received Units) |
| Purchase Orders |
AP21 |
On Order Due $ |
The sum of the number of units showing as On Order where 'has on order units' = 'Y' * Purchase Order Unit Cost |
| Purchase Orders |
AP21 |
Original Order Due $ |
The sum of the number of units entered into the Original Order * Purchase Order Unit Cost |
| Purchase Orders |
AP21 |
Production Order Qty |
The quantity showing against the Production Order linked to this Purchase Order number |
| Purchase Orders |
AP21 |
Production Order Status |
The status showing in Production Order linked to this Purchase Order number |
| Purchase Orders |
AP21 |
Order Cost $ (Local Currency) |
The sum of the number of Original Order units * Unit price in local currency |
| Purchase Orders |
AP21 |
Original Order Units (All) |
The sum of the number of units entered into the Original Order. This is not linked to the calendar, as such showing All values |
| Purchase Orders |
AP21 |
Order Units (All) |
The sum of the number of units currently entered into the Order. This is not linked to the calendar, as such showing All values |
| Purchase Orders |
AP21 |
On Order Units (All) |
The sum of the number of units showing as On Order where 'has on order units' = 'Y'. This is not linked to the calendar, as such showing All values |
| Purchase Orders |
AP21 |
Received Units (All) |
The sum of the number of units showing as Received against the Purchase Order. This is not linked to the calendar, as such showing All values |
| Purchase Orders |
AP21 |
Invoiced Units (All) |
The sum of the number of units showing as Invoiced against the Purchase Order. This is not linked to the calendar, as such showing All values |
| Purchase Orders |
AP21 |
Original Order Units Var (All) |
The Variance between the number of units entered against the Original Order compared to the number of units entered against what is showing as Order Units after Receipts where PO status is 'Active'. This is not linked to the calendar, as such showing All values |
| Purchase Orders |
AP21 |
Cancelled Units (All) |
The sum of units that have been Cancelled after Receipts. This is not linked to the calendar, as such showing All values |
| Purchase Orders |
AP21 |
Original Order Cost $ (All) |
The sum of the number of units entered into the Original Order * Standard Unit Cost in the Purchase Order. This is not linked to the calendar, as such showing All values |
| Purchase Orders |
AP21 |
Order Cost $ (All) |
The sum of the number of units currently entered into the Order * Standard Unit Cost in the Purchase Order. This is not linked to the calendar, as such showing All values |
| Purchase Orders |
AP21 |
On Order Cost $ (All) |
The sum of the number of units showing as On Order where 'has on order units' = 'Y' * Standard Unit Cost in the Purchase Order. This is not linked to the calendar, as such showing All values |
| Purchase Orders |
AP21 |
Received Cost $ (All) |
The sum of the number of units showing as Received against the Purchase Order * Standard Unit Cost in the Purchase Order. This is not linked to the calendar, as such showing All values |
| Purchase Orders |
AP21 |
Invoiced Cost $ (All) |
The sum of the number of units showing as Invoiced against the Purchase Order * Standard Unit Cost in the Purchase Order. This is not linked to the calendar, as such showing All values |
| Purchase Orders |
AP21 |
Original Order Cost $ Var (All) |
The Variance between the number of units entered against the Original Order compared to the number of units entered against what is showing as Order Units after Receipts where PO status is 'Active' * Standard Unit Cost in the Purchase Order. This is not linked to the calendar, as such showing All values |
| Purchase Orders |
AP21 |
Cancelled Cost $ (All) |
The sum of units that have been Cancelled after Receipts * Standard Unit Cost in the Purchase Order. This is not linked to the calendar, as such showing All values |
| Purchase Orders |
AP21 |
Original Order Retail $ (All) |
The sum of the number of units entered into the Original Order * Current Retail price from Price History ex GST. This is not linked to the calendar, as such showing All values |
| Purchase Orders |
AP21 |
Order Retail $ (All) |
The sum of the number of units currently entered into the Order * Current Retail price from Price History ex GST. This is not linked to the calendar, as such showing All values |
| Purchase Orders |
AP21 |
On Order Retail $ (All) |
The sum of the number of units showing as On Order where 'has on order units' = 'Y' * Current Retail price from Price History ex GST. This is not linked to the calendar, as such showing All values |
| Purchase Orders |
AP21 |
Received Retail $ (All) |
The sum of the number of units showing as Received against the Purchase Order * Current Retail price from Price History ex GST. This is not linked to the calendar, as such showing All values. Please note, Receipts are linked to the calendar by the PO Due date. |
| Purchase Orders |
AP21 |
Invoiced Retail $ (All) |
The sum of the number of units showing as Invoiced against the Purchase Order * Current Retail price from Price History ex GST. This is not linked to the calendar, as such showing All values. |
| Purchase Orders |
AP21 |
Original Order Retail $ Var (All) |
The Variance between the number of units entered against the Original Order compared to the number of units entered against what is showing as Order Units after Receipts where PO status is 'Active' * Current Retail price from Price History ex GST. This is not linked to the calendar, as such showing All values |
| Purchase Orders |
AP21 |
Cancelled Retail $ (All) |
The sum of units that have been Cancelled after Receipts * Current Retail price from Price History ex GST. This is not linked to the calendar, as such showing All values |
| Purchase Orders |
AP21 |
On Order Orig Retail $ (All) |
The sum of the number of units showing as On Order where 'has on order units' = 'Y' * Original Retail Price from Price History ex GST. This is not linked to the calendar, as such showing All values |
| Purchase Orders |
AP21 |
Received Orig Retail $ (All) |
The sum of the number of units showing as Received against the Purchase Order * Original Retail Price from Price History ex GST. This is not linked to the calendar, as such showing All values. Please note, Receipts are linked to the calendar by the PO Due date. |
| Purchase Orders |
AP21 |
On Order First Margin $ (All) |
Calculation of the On Order First Margin using Original Retail Price at the time of the Purchase Order and the Standard Units Cost in the Purchase order. This is not linked to the calendar, as such showing All values |
| Purchase Orders |
AP21 |
Received First Margin $ (All) |
Calculation of the Received First Margin using Original Retail Price at the time of the Purchase Order and the Standard Units Cost in the Purchase order. This is not linked to the calendar, as such showing All values |
| Purchase Orders |
AP21 |
On Order First Margin % (All) |
Calculation of the On Order First Margin as a % of the On Order Orig Retail $. This is not linked to the calendar, as such showing All values |
| Purchase Orders |
AP21 |
Received First Margin % (All) |
Calculation of the Received First Margin as a % of the Received Orig Retail $. This is not linked to the calendar, as such showing All values |
| Purchase Orders |
AP21 |
On Order Avg Purchase Price (All) |
The Average Purchasing Price of the On Order Value (On Order Retail $ / On Order Units). This is not linked to the calendar, as such showing All values |
| Purchase Orders |
AP21 |
Received Avg Purchase Price (All) |
The Average Purchasing Price of the Received Value (Received Retail $ / Received Units). This is not linked to the calendar, as such showing All values. Please note, Receipts are linked to the calendar by the PO Due date. |
| Purchase Orders |
AP21 |
On Order Due $ (All) |
The sum of the number of units showing as On Order where 'has on order units' = 'Y' * Purchase Order Unit Cost. This is not linked to the calendar, as such showing All values |
| Purchase Orders |
AP21 |
Original Order Due $ (All) |
The sum of the number of units entered into the Original Order * Purchase Order Unit Cost. This is not linked to the calendar, as such showing All values |
| Purchase Orders |
AP21 |
# Purchase Orders |
A distinct count or the number of Purchase Order Numbers |
| Purchase Orders |
AP21 |
# Purchase Orders On Order |
A distinct count or the number of Purchase Order Numbers classified as "On Order" |
| Purchase Orders |
AP21 |
# Purchase Orders (All) |
A distinct count or the number of Purchase Order Numbers. This is not linked to the calendar, as such showing All values |
| Purchase Orders |
AP21 |
# Purchase Orders On Order (All) |
A distinct count or the number of Purchase Order Numbers classified as "On Order". This is not linked to the calendar, as such showing All values |
| Purchase Orders |
AP21 |
Received Date |
There is no Receipt date captured within the Purchase Order Module. Refer to Received values under Stock Movements for this information. Received values report against the Purchase Order Due Date. |
