Dimension Business Unit Inventory

A role-playing dimension based on PS_D_BUSINESS_UNIT for Inventory Business Unit.

PS_D_BUSINESS_UNIT

Dimension Day Inventory Date

A role-playing dimension based on PS_D_DAY for Inventory Date.

PS_D_DAY

Dimension Day Snapshot Date

A role-playing dimension based on dimension day for snapshot date.

PS_D_DAY

Dimension Item

Contains information about inventory and non-inventory items. An inventory item is a tangible commodity that is physically stocked in inventory.

PS_D_INV_ITEM

Fact Inventory Compliance

Contains information about plan compliance at inventory levels. It captures daily inventory quantities And compares planned inventory quantity versus actual inventory quantity.

PS_F_SCP_INVENTORY

Actual Ending Quantity

Inventory on-hand quantity of a specific item held in a specific inventory location at the end of the day.

INV_ONHAND_QTY

Ending Inventory Deviation

Ending inventory deviation. The difference between the planned ending quantity and the actual ending quantity.

[Planned Ending Quantity]-[Actual Ending Quantity]

Planned Ending Quantity

Master production plan quantity of a specific item that is to be held in a specific inventory location at the end of the day.

PROD_PLAN_QTY

Dimension Business Unit

The business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Business Unit Inventory

A role-playing dimension based on PS_D_BUSINESS_UNIT for Inventory Business Unit.

PS_D_BUSINESS_UNIT

Dimension Business Unit Inventory From

A role-playing dimension based on PS_D_BUSINESS_UNIT for Inventory From Business Unit.

PS_D_BUSINESS_UNIT

Dimension Business Unit Inventory To

A role-playing dimension based on PS_D_BUSINESS_UNIT for Inventory To Business Unit.

PS_D_BUSINESS_UNIT

Dimension Carrier

Contains information about carriers the organization uses to move freight.

PS_D_CARRIER

Dimension Day Transfer Dimension Ship Date

A role-playing dimension based on PS_D_DAY for Transfer Ship Date.

PS_D_DAY

Dimension Item

Contains information about inventory and non-inventory items. An inventory item is a tangible commodity that is physically stocked in inventory.

PS_D_INV_ITEM

Fact Inventory Transfer Compliance

Plan compliance for inter-unit transfers. This shows planned transfer quantity versus actual transfer quantity.

PS_F_SCP_TRANSFERS

Actual Transfer Quantity

Actual transferred quantity. The ***planned*** quantity of an item that was to be transferred according to the transfer order.

TRANSFERRED_QTY

Planned Transfer Quantity

Deployment plan quantity. The quantity of an item ***actually*** transferred according to the transfer order.

DEPL_PLAN_QTY

Transfer Quantity Deviation

Transfer quantity deviation. The difference between the planned transfer quantity and the actual transfer quantity.

[Planned Transfer Quantity]-[Actual Transfer Quantity]

Dimension Business Unit Manufacturing

A role-playing dimension based on PS_D_BUSINESS_UNIT for Manufacturing Business Unit.

PS_D_BUSINESS_UNIT

Dimension Day Manufacturing Production Date

A role-playing dimension based on PS_D_DAY for Manufacturing Production Date.

PS_D_DAY

Dimension Item

Contains information about inventory and non-inventory items. An inventory item is a tangible commodity that is physically stocked in inventory.

PS_D_INV_ITEM

Dimension Work Center

Contains information about Manufacturing Work Center. A work center is the business unit that represents manufacturing production area.

PS_D_WORK_CENTER

Fact Production Compliance

Contains information about production plan compliance. It captures the quantities and costs associated with production in accordance with a specific work order.

PS_F_SCP_PRODN

Actual Production Quantity

Actual production quantity. The quantity of product produced compared to the work order quantity.

ACTUAL_PROD_QTY

Actual Unit Cost

Actual unit cost amount in transaction currency. The activity-based cost of production associated with the work order item.

ACTUAL_UNIT_COST

Planned Production Quantity

Planned production quantity. The planned quantity of a product that was to be produced compared to the work order quantity.

PLAN_PROD_QTY

Production Cost Deviation

Production cost deviation. The difference between the planned production cost and the actual production cost.

([Planned Production Quantity]−[Actual Production Quantity])*Actual Unit Cost

Production Quantity Deviation

Production quantity deviation. The difference between the planned production quantity and the actual production quantity.

[Planned Production Quantity] −[Actual Production Quantity]

Dimension Business Unit Manufacturing

A role-playing dimension based on PS_D_BUSINESS_UNIT for Manufacturing Business Unit.

PS_D_BUSINESS_UNIT

Dimension Day Manufacturing Production Date

This is a role-playing dimension based on PS_D_DAY for Manufacturing Production Date.

PS_D_DAY

Dimension Work Center

Contains information about a Manufacturing Work Center. A work center is the business unit that represents manufacturing production area.

PS_D_WORK_CENTER

Fact Production Capacity Compliance

Contains information about capacity plan compliance. It captures the daily capacity utilization associated with production at a specific work center.

PS_F_SCP_CAPACITY

Actual Utilized Capacity

Quantity of product that was actually produced by a particular work center.

ACTUAL_UTIL_CAP

Capacity Utilization Deviation

Production capacity utilization deviation. It is the difference between the planned utilized capacity and the actual utilized capacity.

[Planned Utilized Capacity]-[Actual Utilized Capacity]

Percentage of Capacity Utilization Deviation

Capacity utilization deviation as a percentage of the planned utilized capacity.

([Planned Utilized Capacity]-[Actual Utilized Capacity])/NULLIF ([Planned Utilized Capacity], 0)

Planned Production Capacity

Theoretical maximum quantity of product that can be produced by a particular work center.

PLAN_PROD_CAP

Planned Utilized Capacity

Planned quantity of product that was to be produced by a particular work center.

PLAN_UTIL_CAP

Dimension Business Unit Inventory

This is a role-playing dimension based on PS_D_BUSINESS_UNIT for Inventory Business Unit.

PS_D_BUSINESS_UNIT

Dimension Business Unit PO (business unit purchase order)

This is a role-playing dimension based on PS_D_BUSINESS_UNIT for Purchase Order Business Unit.

PS_D_BUSINESS_UNIT

Dimension Day Purchase Order Ship Date

This is a role-playing dimension based on PS_D_DAY for Purchase Order Ship Date.

PS_D_DAY

Dimension Item

Contains information about inventory and non-inventory items. An inventory item is a tangible commodity that is physically stocked in inventory.

PS_D_INV_ITEM

Dimension Supplier

Includes information about suppliers such as name and address.

PS_D_SUPPLIER

Fact Purchasing Compliance

Contains information about purchasing plan compliance. It captures the quantities and costs associated with purchase orders.

PS_F_SCP_PURCHASNG

Actual Purchase Order Quantity

Quantity of an item purchased according to the purchase order line.

PO_QTY

Actual Voucher Cost

Final cost associated with the purchased item.

VCHR_PAID_AMT

Actual Voucher Quantity

Final quantity received and approved for payment or voucher.

VCHR_QTY

Planned Purchase Order Quantity

Planned quantity of an item that was to be purchased.

PLAN_PO_QTY

Purchase Cost Deviation

Difference between the planned purchase order cost and the actual purchase order cost.

([Planned Purchase Order Quantity]-[Actual Purchase Order Quantity])*[Purchase Order Price]

Purchase Order Price

Purchase order price amount in transaction currency. It is the price of an item purchased according to the purchase order line.

PO_PRICE

Purchase Order Price (Base)

Purchase order price amount in base currency. It is the price of an item purchased according to the purchase order line.

PO_PRICE_BSE

Purchase Quantity Deviation

Difference between the planned purchase order quantity and the actual purchase order quantity.

[Planned Purchase Order Quantity]-[Actual Purchase Order Quantity]

Receipt Accepted Quantity

Accepted quantity on the purchase order receipt.

RCPT_ACPT_QTY

Receipt Received Quantity

Received quantity on the purchase order receipt.

RCPT_RCVD_QTY

Receipt Rejected Quantity

Rejected quantity on the purchase order receipt.

RCPT_RJCT_QTY

Planned Purchase Order Quantity

Planned purchase order quantity. It is the planned quantity of an item that was to be purchased.

PLAN_PO_QTY

Dimension Bucket

A role-playing dimension based on PS_D_BUSINESS_UNIT for Inventory Business Unit.

PS_D_BUSINESS_UNIT

Dimension Business Unit Inventory

A role-playing dimension based on PS_D_DAY for Inventory Date.

PS_D_DAY

Dimension Business Unit Order Management

A role-playing dimension based on dimension day for snapshot date.

PS_D_DAY

Dimension Carrier

This dimension contains information about carriers the organization uses to move freight.

PS_D_INV_ITEM

Dimension Channel

Contains information about sales and purchasing channels. A channel is the avenue through which transactions are completed. Channels include telephone, internet (web sites, e-mail), mail response, and face-to-face interaction.

PS_D_CHANNEL

Dimension Customer

Contains information for entities that can participate in business relationships.

PS_D_CUSTOMER

Dimension Customer Shipped

A role-playing dimension based on PS_D_CUSTOMER for Shipped Customers.

PS_D_CUSTOMER

Dimension Day Actual Ship Date

A role-playing dimension based on PS_D_DAY for Actual Ship Date.

PS_D_DAY

Dimension Day Bucket End Date

A role-playing dimension based on PS_D_DAY for Bucket End Date.

PS_D_DAY

Dimension Day Bucket Start Date

A role-playing dimension based on PS_D_DAY for Bucket Start Date.

PS_D_DAY

Dimension Item

Contains information about inventory and non-inventory items. An inventory item is a tangible commodity that is physically stocked in inventory.

PS_D_INV_ITEM

Dimension Product

Contains information about products that are offered for sale.

PS_D_PRODUCT

Fact Sales Actual

Contains information about the actual product quantities shipped against sales orders.

PS_F_SCPSLS_ACTUAL

Shipped Quantity

Sales order shipped quantity. It is the quantity of product shipped.

SO_SHIPPED_QTY

Dimension Bucket

This dimension stores information about the supply chain forecast time bucket.

PS_D_BUCKET

Dimension Business Unit Inventory

A role-playing dimension based on PS_D_BUSINESS_UNIT for Inventory Business Unit.

PS_D_BUSINESS_UNIT

Dimension Customer

Contains information about entities that can participate in business relationships.

PS_D_CUSTOMER

Dimension Day Bucket End Date

A role-playing dimension based on PS_D_DAY for Bucket End Date.

PS_D_DAY

Dimension Day Bucket Start Date

A role-playing dimension based on PS_D_DAY for Bucket Start Date.

PS_D_DAY

Dimension Item

Contains information about inventory and non-inventory items. An inventory item is a tangible commodity that is physically stocked in inventory.

PS_D_INV_ITEM

Fact Sales Forecast

Contains information about product quantities associated with shipments against sales orders.

PS_F_SCP_SLS_FCST

Forecast Quantity

The forecast sales quantity.

ENT_FCST_QTY

Dimension Customer

Contains information about entities that can participate in business relationships.

PS_D_CUSTOMER

Dimension Day Required Date

A role-playing dimension based on PS_D_DAY for Requested Date.

PS_D_DAY

Dimension Item

Contains information about inventory and non-inventory items. An inventory item is a tangible commodity that is physically stocked in inventory.

PS_D_INV_ITEM

Fact Sales Actual

Contains information about actual product quantities associated with shipments against sales orders.

PS_F_SCPSLS_ACTUAL

Fact Sales Forecast

Contains information about product quantities associated with shipments against sales orders.

PS_F_SCP_SLS_FCST

Fact Sales Order Line

Contains information as to what products and quantities are required for sales orders.

PS_F_SO_LINE

Order Fulfillment Compliance

Contains information about actual, planned, and requested quantities and ship dates associated with sales orders.

Based on the previous three fact folders.

Actual Ship Quantity

Sales order shipped quantity. It is the quantity of product shipped against the sales order line.

Fact Sales Actual. Shipped Quantity

Actual to Plan Quantity Deviation

Difference between the actual quantity and the planned quantity.

[Actual Ship Quantity]- [Planned Ship Quantity]

Actual to Plan Time Deviation

Difference between the actual ship date and the planned ship date.

[Actual Ship Date]-[Planned Ship Date]

Actual to Request Quantity Deviation

Difference between the actual quantity and the requested quantity.

[Actual Ship Quantity]-[Requested Ship Quantity]

Actual to Request Time Deviation

D difference between the actual ship date and the requested ship date.

[Actual Ship Date]-[Requested Ship Date]

Planned Ship Quantity

Forecast quantity.

Fact Sales Forecast.Forecast Quantity

Requested Ship Quantity

Quantity ordered by the customer.

Fact Sales Order Line.Ordered Quantity

Dimension Business Unit

Business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Day Snapshot Date

A role-playing dimension based on dimension day for snapshot date.

PS_D_DAY

Dimension Inventory Location

Contains information about location of items in inventory.

PS_D_INV_LOCATION

Dimension Item

Contains information about inventory and non-inventory items. An inventory item is a tangible commodity that is physically stocked in inventory.

PS_D_INV_ITEM

Dimension Lot

Contains information about the quantity of inventory items produced as a group or otherwise collected into an identifiable unit.

PS_D_LOT

Dimension Pattern Year

The pattern year dimension. This contains information on fiscal years.

PS_D_PATTERN_YEAR

Fact History Sum Ledger

Contains information about Inventory History Sum Ledger, which is a historical record of all transactions.

PS_F_HIST_SUM_LEDG

Ledger Summary Amount

Inventory ledger summary amount in base currency. This number represents the net amount posted during the accounting period.

INV_LDGR_SUM_AMT

Ledger Summary Quantity

Inventory ledger summary quantity. The net transaction quantity from all transactions for an item.

INV_LDGR_SUM_QTY

Dimension Business Unit

Business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Day Snapshot Date

A role-playing dimension based on dimension day for snapshot date.

PS_D_DAY

Dimension Inventory Location

Contains information about the location of items in inventory.

PS_D_INV_LOCATION

Dimension Item

Contains information about inventory and non-inventory items. An inventory item is a tangible commodity that is physically stocked in inventory.

PS_D_INV_ITEM

Dimension Lot

Contains information about the quantity of inventory items produced as a group or otherwise collected into an identifiable unit.

PS_D_LOT

Fact Inventory Cycle Count

This fact includes information about Inventory Cycle Count. It provides for analysis of inventory information at events in which inventory was counted and how often those count events occurred.

PS_F_INV_CYCLE_CNT

Absolute Adjusted Cost

Absolute adjusted cost amount in transaction currency. It is the amount per unit, derived by dividing the total cost by the unit quantity.

IN_ABSADJ_CST

Absolute Adjusted Quantity

Total quantity counted for the item.

IN_ABSADJS_QTY

Adjusted Cost

Adjusted cost amount in transaction currency. It is the amount per unit, derived by dividing the total cost by the unit quantity.

IN_ADJSTD_CST

Unit Cost

Unit cost amount in transaction currency. It is the amount per unit, derived by dividing the total cost by the unit quantity.

IN_UNIT_CST

Dimension Business Unit

Business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Day Snapshot Date

A role-playing dimension based on dimension day for snapshot date.

PS_D_DAY

Dimension Day Transaction Date

A role-playing dimension based on dimension day for transaction date.

PS_D_DAY

Dimension Inventory Location

Contains information about the location of items in inventory.

PS_D_INV_LOCATION

Dimension Inventory Status Type

Contains information about all supply chain inventory statuses.

PS_D_INVST_REASON

Dimension Item

Contains information about inventory and non-inventory items. An inventory item is a tangible commodity that is physically stocked in inventory.

PS_D_INV_ITEM

Dimension Lot

Contains information about the quantity of inventory items produced as a group or otherwise collected into an identifiable unit.

PS_D_LOT

Dimension Pattern Year

The pattern year dimension. Contains information about fiscal years.

PS_D_PATTERN_YEAR

Dimension Reason Code

Contains the explanation of the purpose for a transaction.

PS_D_REASON_CODE

Dimension Unit of Measure

The unit of measure dimension. A standard of basic quantity or increment by which something is divided, counted, or described

PS_D_UOM

Fact Inventory Ledger

This fact includes information about Inventory Ledger It provides for analysis of inventory ledgers in regard to primary UOM quantities, UOM unit costs, extended costs, etc.

PS_F_INV_LDGR

Ledger Extended Cost

Ledger extended cost amount or price value of an inventory transaction for an inventory item in transaction currency.

INV_LDGEXTCST

Primary Unit of Measure (UOM) Cost

Primary UOM unit cost amount in transaction currency. It is the amount per unit, derived by dividing the total cost by the unit quantity.

INV_PRUOM_COST

Primary UOM Quantity

Available quantity, which can consist of the on-hand balance minus commitments, reservations, and back orders.

INV_PRUOM_QTY

Dimension Business Unit

Business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Day Snapshot Date

A role-playing dimension based on dimension day for snapshot date.

PS_D_DAY

Dimension Inventory Location

Contains information about the location of items in inventory.

PS_D_INV_LOCATION

Dimension Item

Contains information about inventory and non-inventory items. An inventory item is a tangible commodity that is physically stocked in inventory.

PS_D_INV_ITEM

Dimension Lot

Contains information about the quantity of inventory items produced as a group or otherwise collected into an identifiable unit.

PS_D_LOT

Fact Inventory Cycle Count

This fact folder includes information about Inventory Cycle Count. It provides for analysis of inventory information at events in which inventory was counted and how often those count events occurred.

PS_F_INV_CYCLE_CNT

Fact Inventory Transaction

This fact folder includes information about Inventory Transactions. It provides for analysis of inventory transaction information, such as demand, received, issued, quantity on hand, back order, purchase order, work order received, and helps evaluate item cost and quantity on-hand cost.

PS_F_INV_TRANS

Inventory Weekly Transactions

This complex folder includes information about the weekly inventory transactions, such as weekly demand.

See the two fact folders above.

Demand Cost

The cost of the quantity demanded.

IN_DMND_COST

Demand Quantity

This is the demand quantity

IN_DMND_QTY

Inter Unit Transfer Cost

Inter unit transfer cost amount in transaction currency.

IN_IUT_COST

Inter Unit Transfer Quantity

This is the quantity transferred between units.

IN_IUT_TFR_QTY

Issued Cost

Issued cost amount in transaction currency.

IN_ISS_COST

Issued Quantity

This is quantity issued.

IN_ISS_QTY

On Hand Amount

On-hand amount in transaction currency.

IN_ONHND_AMT

On Hand Quantity

Number of units that are physically in stock.

IN_ONHND_QTY

Quantity Backordered

Number of units backordered for inventory in primary units of measure.

IN_QTY_ON_BKORD

Quantity Future Commit

Quantity specified on the sales order whose requested shipment date is beyond the standard commitment period that has been specified in the inventory constants for that branch. The inventory constant is a default setting for the standard commitment period in the Inventory system.

IN_QTYFTCMT

Quantity Hard Commit

Number of units committed to a specific location and lot.

IN_QTYHRDCMT

Quantity in Inspection

Quantity currently being inspected. This quantity has been received, but it is not considered on hand.

IN_QTY_IN_INSPCTN

Quantity in Transit

The quantity currently in transit to the warehouse from the supplier.

IN_QTY_IN_TRANSIT

Quantity Inbound Warehouse

Quantity in the primary UOM that is added to the location detail after confirming a putaway or replenishment suggestion.

IN_QTYINBNDWH

Quantity On Hand

Number of units that is physically in stock.

IN_ONHND_QTY

Quantity on Loan

Quantity of an item that is being used by manufacturing but will be replaced.

IN_QTY_ON_LN

Quantity on Purchase Order

Number of units in primary UOMs specified on the purchase order for inventory.

IN_QTY_ON_PO

Quantity on Work Order

Number of units in primary UOMs specified on the work order for inventory.

IN_QTY_ON_WO

Quantity Other Purchases

Quantity that appears on documents, such as bid requests, which are not formal commitments on the part of an organization to buy.

IN_QTY_OTHER_PURC

Quantity Outbound Warehouse

Quantity in the primary UOM that is expected to be removed from the location after confirming a picking or replenishment suggestion.

IN_QTYOTBNDWH

Quantity Soft Commit

Number of units in the primary UOM needed by sales orders or work orders, but not committed to a specific location.

IN_QTYSFTCMT

Quantity Work Order Hard Commit

Number of units in the primary UOM committed to work orders to a specific location and lot.

IN_WO_HRDCMT

Quantity Work Order Soft Commit

Number of units in the primary UOM needed by work orders, but not committed to a specific location.

IN_WO_SFTCMT

Quantity1 in Other Primary Units

The quantity 1 in another primary unit of measure. This quantity (of two) can be specified as additional offsets (subtractions from on hand) in the determination of available quantities for sale.

IN_QTY1_OTH_PRI

Quantity2 in Other Primary Units

The quantity 2 in another primary unit of measure. This quantity (of two) can be specified as additional offsets (subtractions from on hand) in the determination of available quantities for sale.

IN_QTY2_OTH_PRI

Received Cost

Received cost amount in transaction currency.

IN_RCVD_COST

Received Quantity

Number of units received.

IN_RCVD_QTY

Unit Cost

Unit cost amount in transaction currency.

IN_UNIT_COST

Demand Cost

This is the demand cost.

IN_DMND_COST

Demand Quantity

This is the demand quantity.

IN_DMND_QTY

Inter Unit Transfer Cost

Inter unit transfer cost amount in transaction currency.

IN_IUT_COST

Inter Unit Transfer Quantity

The quantity transferred between units.

IN_IUT_TFR_QTY

Issued Cost

Issued cost amount in transaction currency.

IN_ISS_COST

Issued Quantity

The issued quantity.

IN_ISS_QTY

On Hand Amount

On-hand amount in transaction currency.

IN_ONHND_AMT

On Hand Quantity

Number of units that is physically in stock.

IN_ONHND_QTY

Quantity Backordered

Number of units on back order for inventory in primary UOM.

IN_QTY_ON_BKORD

Quantity Future Commit

Quantity specified on the sales order whose requested shipment date is beyond the standard commitment period that is specified in the inventory constants for that branch. This is a default setting for the standard commitment period in the Inventory system.

IN_QTYFTCMT

Quantity Hard Commit

Number of units committed to a specific location and lot.

IN_QTYHRDCMT

Quantity in Inspection

Quantity currently being inspected. This quantity was received but is not considered on hand.

IN_QTY_IN_INSPCTN

Quantity in Transit

Quantity currently in transit to the warehouse from the supplier.

IN_QTY_IN_TRANSIT

Quantity Inbound Warehouse

Quantity in the primary UOM that is expected to be added to the location detail after confirming a putaway or replenishment suggestion.

IN_QTYINBNDWH

Quantity On Hand

Number of units that is physically in stock.

IN_ONHND_QTY

Quantity on Loan

Quantity of an item that is being used by manufacturing but will be replaced.

IN_QTY_ON_LN

Quantity on Purchase Order

The number of units specified on the purchase order for inventory in primary units of measure.

IN_QTY_ON_PO

Quantity on Work Order

Number of units in primary units of measure specified on the work order for inventory.

IN_QTY_ON_WO

Quantity Other Purchases

Quantity that appears on documents, such as bid requests, which are not formal commitments on the part of organization to buy.

IN_QTY_OTHER_PURC

Quantity Outbound Warehouse

Quantity in the primary UOM that is expected to be removed from the location after confirming a picking or replenishment suggestion.

IN_QTYOTBNDWH

Quantity Soft Commit

Number of units in the primary UOM needed by sales orders or work orders but not committed to a specific location.

IN_QTYSFTCMT

Quantity Work Order Hard Commit

The number of units committed to work orders to a specific location and lot in the primary unit of measure.

IN_WO_HRDCMT

Quantity Work Order Soft Commit

Number of units in the primary unit of measure needed by work orders, but not committed to a specific location.

IN_WO_SFTCMT

Quantity1 in Other Primary Units

The quantity 1 in another primary UOM. This quantity (of two) can be specified as additional offsets (subtractions from on hand) in the determination of available quantities for sale.

IN_QTY1_OTH_PRI

Quantity2 in Other Primary Units

The quantity 2 in another primary UOM. This quantity (of two) can be specified as additional offsets (subtractions from on-hand) in the determination of available quantities for sale.

IN_QTY2_OTH_PRI

Received Cost

Received cost amount in transaction currency.

IN_RCVD_COST

Received Quantity

Number of units received.

IN_RCVD_QTY

Unit Cost

Unit cost amount in transaction currency.

IN_UNIT_COST

Dimension Business Unit

Business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Day Snapshot Date

A role-playing dimension based on dimension day for snapshot date.

PS_D_DAY

Dimension Inventory Location

Contains information about the location of items in inventory.

PS_D_INV_LOCATION

Dimension Item

Contains information about inventory and non-inventory items. An inventory item is a tangible commodity that is physically stocked in inventory.

PS_D_INV_ITEM

Dimension Lot

Contains information about the quantity of inventory items produced as a group or otherwise collected into an identifiable unit.

PS_D_LOT

Fact Physical Inventory

This fact folder includes information about Physical Inventory facts. It provides for analysis of physical inventory information such as open, received, hold and rejected quantity by inventory location, item and date.

PS_F_PHYSICAL_INV

Hold Quantity

Inventory quantity that is on hold.

IN_HOLD_QTY

Open Quantity

Inventory quantity that is open for transaction.

IN_OPEN_QTY

Rejected Quantity

Inventory quantity that is rejected.

IN_RJCTD_QTY

Restricted Quantity

Inventory quantity that is restricted and not available for transaction.

IN_RSTRCTDQTY

Dimension Business Unit

Business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Inventory Location

Contains information about location of items in inventory.

PS_D_INV_LOCATION

Dimension Item

Contains information about inventory and non-inventory items. An inventory item is a tangible commodity that is physically stocked in inventory.

PS_D_INV_ITEM

Dimension Lot

Contains information about the quantity of inventory items produced as a group or otherwise collected into an identifiable unit.

PS_D_LOT

Fact Inventory Cycle Count

This fact folder includes information about Inventory Cycle Count. It provides for analysis of inventory information at events in which inventory was counted and how often those count events occurred.

PS_F_INV_CYCLE_CNT

Dimension Inventory Transaction

This fact folder includes information about Inventory Transactions. It provides for analysis of inventory transaction information such as demand, received, issued, quantity on hand, backorder, purchase order, work order received and helps evaluate item cost and quantity onhand cost.

PS_F_INV_TRANS

Inventory Accuracy

Includes information about the accuracy of the inventory transactions.

See the two fact folders above.

Absolute Adjusted Quantity

Total quantity counted for the item.

Fact Inventory Cycle Count.Absolute Adjusted Quantity

Accuracy Percent

Percentage of the accuracy with which the onhand inventory has been adjusted against the transactions.

Inventory Accuracy.Quantity Count/NVL (Inventory Accuracy.On Hand Quantity,0)/100

Average Accuracy

Average count of the accuracy with which the onhand inventory has been adjusted against the transactions.

(Inventory Accuracy.Quantity Count/( DECODE(Inventory Accuracy.Quantity On Hand,0,1) ) )/( DECODE(Inventory Accuracy.Cycle Event Count,0,1) )

Cycle Event Count

Distinct count of the cycle events for a particular set of inventory.

COUNT_DISTINCT(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT(Inventory Accuracy.Inventory Item Sid,Inventory Accuracy.Inventory Location Sid),Inventory Accuracy.Lot Sid),Inventory Accuracy.Business Unit Sid),Inventory Accuracy.Cycle Count Number),Inventory Accuracy.Store Unit Number))

Quantity Count

Absolute value of the quantity adjusted for a particular transaction.

SUM(Inventory Accuracy.Absolute Adjusted Quantity)

Quantity On Hand

Number of units that is physically in stock.

SUM(Inventory Accuracy.Quantity On Hand)

Dimension Business Unit

Business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Cost Type

This dimension table stores information about cost types (i.e. The types of the work order production costs.

PS_D_COST_TYPE

Dimension Item

Contains information about inventory and non-inventory items. An inventory item is a tangible commodity that is physically stocked in inventory.

PS_D_INV_ITEM

Dimension Item Component Item

A role-playing dimension based on PS_D_INV_ITEM for a component item.

PS_D_INV_ITEM

Dimension Parent Child Relationship

Contains information relating to the parent child relationship between work order items

PS_D_PRNT_CHLD_REL

Fact Work Order Production Cost

This fact table stores information about work order production costs. It provides for analysis of work orders and their associated costs.

PS_F_PRDN_COST

Actual Amount

This is the actual amount to produce a given quantity of units.

ACTUAL_AMT

Actual Units Primary

This is the actual number of work order units that can be produced in a given period.

ACT_UNITS

Completed Amount

This is the completed amount to produce a given quantity of units.

COMPLETED_AMT

Completed Units Primary

This is the completed number of work order units that can be produced in a given period.

COMPLETED_UNITS

Current Amount

This is the current amount to produce a given quantity of units.

CURRENT_AMT

Current Units Primary

This is the current number of work order units that can be produced in a given period.

CURRENT_UNITS

Planned Amount

This is the planned amount to produce a given quantity of units.

PLANNED_AMT

Planned Units Primary

This is the planned number of work order units that can be produced in a given period.

PLANNED_UNITS

Scrapped Amount

This is the parent scrap cost amount to produce a given quantity of units.

SCRAPPED_AMT

Scrapped Units Primary

This is the scrapped number of work order units that can be produced in a given period.

SCRAPPED_UNITS

Standard Amount

This is the standard amount to produce a given quantity of units.

STD_AMT

Standard Units Primary

This is the standard number of work order units that can be produced in a given period.

STD_UNITS

Dimension Business Unit

Business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Dispatch Group

This dimension table stores information about Dispatch Groups. A category code used to group work centers within an overall business unit.

For example, you can use this code to group similar machines operating out of several work centers that report to one business unit.

PS_D_DISPTCH_GRP

Dimension Prime Load

This dimension table stores information about Prime Load. This is a code that determines if a work center is machine or labor intensive. The system also uses prime load codes in Resource Requirements Planning and Capacity Requirements Planning calculations to develop load profiles.

Valid codes are:

L - Run labor hours only

M - Machine hours only

B - Run labor plus setup labor hours

C - Machine plus setup hours

O - Other (will not generate resource units)

PS_D_PRIME_LOAD_CD

Dimension Work Center

Contains Supply Chain Planning-related manufacturing work center information.

PS_D_WORK_CENTER

Fact Work Center Master

This fact folder stores information about Work center master fact It provides for analysis of work centers (also known as production areas).

PS_F_WRKCNTR_MST

Daily Capacity

The daily capacity level at which a production line usually operates.

DAILY_CAPACITY

Dimension Business Unit

Business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Shift Code

Contains information about manufacturing shift codes.

PS_D_SHIFT_CD

Dimension Work Center

Contains information about the Supply Chain Planning-related manufacturing work center.

PS_D_WORK_CENTER

Dimension Work Date

Contains information about manufacturing work dates.

PS_D_WORKDATE

Fact Work Center Resource Unit

This fact table stores information related to the work center resource unit. It provides for analysis of resource data as it pertains to work centers (also known as production areas).

PS_F_WRKCNTRESUT

Resource Unit

Capacity of a work center on a given day.

RESOURCE_UNIT

Dimension AB Master Originator

A role-playing dimension based on PS_D_AB_MASTER for transaction originator.

PS_D_AB_MASTER

Dimension Business Unit

Business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Business Unit Composite

The composite business unit dimension. Composite business units are the top-level groupings of the business units that capture attributes such as default currency and fiscal calendar.

PS_D_BUS_UNIT_COMP

Dimension Category 02

A user-defined code from 00/W2 that indicates the type or category of a work order.

PS_D_CATEGORY_02

Dimension Category 03

A user-defined code from 00/W3 that indicates the type or category of the work order.

PS_D_CATEGORY_03

Dimension Day Work Order Assigned Date

a role-playing dimension based on PS_D_DAY for the Work Order Assigned Date.

PS_D_DAY

Dimension Day Work Order Completed Date

A role-playing dimension based on PS_D_DAY for Work Order Completed Date.

PS_D_DAY

Dimension Day Work Order Ordered Date

A role-playing dimension based on PS_D_DAY for Work Order Ordered Date.

PS_D_DAY

Dimension Day Work Order Requested Date

A role-playing dimension based on PS_D_DAY for Work Order Requested Date.

PS_D_DAY

Dimension Day Work Order Started Date

A role-playing dimension based on PS_D_DAY for Work Order Started Date.

PS_D_DAY

Dimension Item

Contains information about inventory and non-inventory items. An inventory item is a tangible commodity that is physically stocked in inventory.

PS_D_INV_ITEM

Dimension Phase

Contains information relating to the work order phase.

PS_D_PHASE

Dimension Planner

Manufacturing manager or planner.

PS_D_PLANNER

Dimension Supervisor

This dimension table stores information about the Manufacturing Supervisor

PS_D_SUPERVISOR

Dimension Variance Flag

Contains the manufacturing variance flag.

A “1” in this field indicates that work order activity has run against this work order in update mode. A “2” in this field indicates that the appropriate variances have been calculated for this work order and then reported to the general ledger.

PS_D_VARIANCE_FLAG

Dimension Work Order Status

Contains information relating to all work order statuses.

PS_D_WO_STATUS

Dimension Work Order Type

This dimension table stores information about Work Order Types. This is a user-defined code from 00/TY that indicates the classification of a work order or engineering change order.

PS_D_WO_TYPE

Fact Work Order Master

This fact table stores information about the work order master. It provides for analysis of work orders and associated dates and quantities.

PS_F_WO_MASTER

Ordered Quantity (Primary UOM)

Quantity ordered for the work order. This quantity is in the primary UOM.

QTY_ORDERED_PR

Scrapped Quantity (Primary UOM)

Quantity scrapped for the work order. This quantity is in the primary UOM.

QTY_SCRAPPED_PR

Shipped Quantity (Primary UOM)

Quantity shipped for the work order. This quantity is in the primary UOM.

QTY_SHIPPED_PR

Dimension Business Unit

Business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Component By Product

A code that distinguishes standard components or ingredients from co-products, by-products, and intermediates. Co-products are (concurrent) end items as the result of a process. By-products are items that can be produced at any step of a process, but were not planned. Intermediate products are items defined as a result of a step but are automatically consumed in the following step.

Generally, intermediates are nonstock items and are only defined steps with a pay-point for reporting purposes. Standard components (Discrete Manufacturing) or ingredients (Process Manufacturing) are consumed during the production process. Valid values are:

• C - Co-products

• B - By-products

• I - Intermediate products

• Blank - Standard components or ingredients

PS_D_CO_BY_PRDCT

Dimension From Grade

This dimension table stores information about From Grade. A user-defined code from 40/LG that indicates the minimum acceptable grade for an item.

PS_D_FROM_GRADE

Dimension Item

Contains information about inventory and non-inventory items. An inventory item is a tangible commodity that is physically stocked in inventory.

PS_D_INV_ITEM

Dimension Item Component Item

A role-playing dimension based on PS_D_INV_ITEM for component item.

PS_D_INV_ITEM

Dimension Line Type

This dimension table stores information about line types.

A code that controls how the system processes lines on a transaction. It controls the systems with which the transaction interacts, such as General Ledger, Job Cost, Accounts Payable, Accounts Receivable, and Inventory Management. It also specifies the conditions under which a line prints on reports, and it is included in calculations.

Codes include the following:

• S - Stock item

• J - Job cost

• N - Nonstock item

• F - Freight

• T - Text information

• M - Miscellaneous charges and credits

• W - Work order

PS_D_LN_TYP

Dimension Order Type

Contains all supply chain order types.

PS_D_ORD_TYP

Dimension Work Order Type

A user-defined code from 00/TY that indicates the classification of a work order or engineering change order.

PS_D_WO_TYPE

Fact Work Order Parts List

This fact table stores information about the work order parts list.

PS_F_WO_PARTLIST

From Potency

A number that indicates the minimum potency or percentage of active ingredients acceptable for an item.

FROM_POTENCY

Part List Quantity Available

Quantity of components, ingredients, co-product, or by-product issued or completed.

PL_QTY_AVAIL

Part List Quantity Ordered Primary

Quantity of components, ingredients, co-products, or by-products ordered for a work order.

PL_QTY_ORDERED

To Potency

A number that indicates the maximum acceptable potency or percentage of active ingredients for an item.

TO_POTENCY

Dimension Business Unit

Business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Day Work Order Routing Completed Date

Stores the work order routing completed date.

A role-playing dimension based on Dimension Day for work order routing completed date.

PS_D_DAY

Dimension Day Work Order Routing Ordered Date

Stores the work order routing ordered date.

A role-playing dimension based on Dimension Day for work order routing ordered date.

PS_D_DAY

Dimension Day Work Order Routing Requested Date

Stores the work order routing requested date.

A role-playing dimension based on Dimension Day for work order routing requested date.

PS_D_DAY

Dimension Day Work Order Routing Started Date

Stores the work order routing start date.

A role-playing dimension based on Dimension Day for work order routing started date.

PS_D_DAY

Dimension Operation Type

A user-defined code from 30/OT that indicates the type of operation.

Valid values include:

• A - Alternate routing

• TT - Travel time

• IT - Idle time

• T - Text

PS_D_OPERTN_TYPE

Dimension Time Basis Code

Stores the manufacturing time basis codes. Time basis codes identify the time basis or rate to be used for machine or labor hours entered for every routing step.

PS_D_TMEBASIS_CD

Dimension Work Center

Contains information relating to the supply chain planning-related manufacturing work center.

PS_D_WORK_CENTER

Fact Work Order Routing

This fact table stores information about work order. It provides for analysis of work order routing information such as queue time, run time, and labor time.

PS_F_WO_ROUTING

Actual Run Labor Hours

Actual number of labor hours reported for a work order.

ACTUAL_RUN_LABOR

Actual Run Machine Hours

Actual number of machine hours reported for a work order.

ACTUAL_RUN_MACHINE

Actual Setup Labor Hours

Actual number of hours needed to set up machines for a work order.

ACTUAL_SETUP_HOURS

Standard Move Hours

Standard number of hours required to move units for a work order.

STD_MOVE_HOURS

Standard Queue Hours

Standard number of hours an item sits in a queue before being worked on at a work center.

STD_QUE_HOURS

Standard Run Labor Hours

Standard number of labor hours needed for a work order.

STD_RUN_LABOR

Standard Run Machine Hours

Standard number of hours a machine will run for a work order.

STD_RUN_MACHINE

Standard Setup Labor Hours

Standard number of hours needed to set up machines for a work order.

STD_SETUP_LABOR

Dimension Business Unit

The business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Hour Type

This dimension table stores information about hour. A code that indicates the type of time entered.

Valid values are:

• 1 - Run Labor Hours

• 2 - Setup Labor Hours

• 3 - Machine Hours

• 4 - Quantities Completed

• 5 - Quantities Scrapped

• 9 - Miscellaneous (such as piece rate bonus)

PS_D_HOUR_TYPE

Dimension Item

Contains information about inventory and non-inventory items. An inventory item is a tangible commodity that is physically stocked in inventory.

PS_D_INV_ITEM

Dimension Shift Code

Contains information about manufacturing shift codes.

PS_D_SHIFT_CD

Dimension Work Center

Contains information about the supply chain planning-related manufacturing work center.

PS_D_WORK_CENTER

Dimension Work Date

Contains information about manufacturing work dates

PS_D_WORKDATE

Fact Work Order Time Transaction

This fact table stores information about work order time transaction fact. It provides for analysis of time transactions as they pertain to work orders.

PS_F_WO_TIME_TR

Hours Worked

Capacity of a work center on a given day.

HOURS_WORKED

Transaction Quantity Shipped

The transaction quantity shipped.

TRANS_QTY_SHIPPED

Dimension Business Unit

Business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Day Work Order Completed Date

A role-playing dimension based on PS_D_DAY for Work Order Completed Date.

PS_D_DAY

Dimension Day Work Order Ordered Date

A role-playing dimension based on PS_D_DAY for Work Order Ordered Date.

PS_D_DAY

Dimension Day Work Order Started Date

A role-playing dimension based on PS_D_DAY for Work Order Started Date.

PS_D_DAY

Dimension Item

Contains information about inventory and non-inventory items. An inventory item is a tangible commodity that is physically stocked in inventory.

PS_D_INV_ITEM

Dimension Order Type

Contains information about all supply chain order types.

PS_D_ORD_TYP

Dimension Work Order Status

Contains information about all work order statuses.

PS_D_WO_STATUS

Fact Work Order Master

This fact table stores information on Work order master. It provides for analysis of work orders and associated dates and quantities.

PS_F_WO_MASTER

Cycle Time

Contains information for the cycle time report.

The above fact folder.

Work Order Cycle Time

Number of days it takes to complete a work order.

Cycle Time.Work Order Completed Day Date-Cycle Time.Work Order Started Day Date

Completed Work Orders

Count of the work order document number.

COUNT (Cycle Time.Document_Number)

Completed Work Order (WO)

Cycle Time. Order Type ID = ‘WO’ and Cycle Time. Work Order Status Id = ‘99’

Dimension Business Unit

Business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Day Work Order Ordered Date

A role-playing dimension based on PS_D_DAY for Work Order Ordered Date.

PS_D_DAY

Dimension Item

Contains information about inventory and non-inventory items. An inventory item is a tangible commodity that is physically stocked in inventory.

PS_D_INV_ITEM

Dimension Order Type

Contains information about all supply chain order types.

PS_D_ORD_TYP

Dimension Parent Child Relationship

Contains information about the parent-child relationship between work order items.

PS_D_PRNT_CHLD_REL

Dimension Variance Flag

Contains information about the manufacturing variance flag.

PS_D_VARIANCE_FLAG

Dimension Work Order Status

Contains information about all work order statuses.

PS_D_WO_STATUS

Dimension Work Order Type

Contains information about work order types.

PS_D_WO_TYPE

Fact Work Order Master

This fact table stores information on Work order master. It provides for analysis of work orders and associated dates and quantities.

PS_F_WO_MASTER

Work Order Production Cost

This fact table stores information on work order production costs. It provides for analysis of work orders and their associated costs.

PS_F_PRDN_COST

Average Manufacturing Cost

This complex folder provides information for the average manufacturing cost report.

From the two fact folders above.

Rework Cost

This complex folder provides information for the rework cost report.

Product Failure

This complex folder provides information for the product failure percentage report.

Average Manufacturing Cost.Actual Amount

Actual amount in transaction currency to produce a given quantity of units.

Fact Work Order Production Cost.Actual Amount

Average Manufacturing Cost.Completed Amount

Completed amount in transaction currency to produce a given quantity of units.

Fact Work Order Production Cost.Completed Amount

Average Manufacturing Cost.Current Amount

Current amount in transaction currency to produce a given quantity of units.

Fact Work Order Production Cost.Current Amount

Average Manufacturing Cost.Planned Amount

Planned amount in transaction currency to produce a given quantity of units.

Fact Work Order Production Cost.Planned Amount

Average Manufacturing Cost.Scrapped Amount

Parent scrap cost amount in transaction currency to produce a given quantity of units.

Fact Work Order Production Cost.Scrapped Amount

Average Manufacturing Cost.Standard Amount

Standard amount in transaction currency to produce a given quantity of units.

Fact Work Order Production Cost.Standard Amount

Product Failure.Completed Units Primary

Completed number of work order units that can be produced in a given period.

Fact Work Order Production Cost.Completed Units Primary

Product Failure.Product Failure by Item & Branch Plant

Percentage of product failure for an item.

Product Failure.Scrapped Units Primary/(Product Failure.Completed Units Primary+Product Failure.Scrapped Units Primary)

Product Failure.Scrapped Units Primary

Scrapped number of work order units that can be produced in a given period.

Fact Work Order Production Cost.Scrapped Units Primary

Rework Cost.Actual Amount

Actual amount in transaction currency to produce a given quantity of units.

Fact Work Order Production Cost.Actual Amount

Rework Cost.Completed Amount

Completed amount in transaction currency to produce a given quantity of units.

Fact Work Order Production Cost.Completed Amount

Rework Cost.Current Amount

Current amount in transaction currency to produce a given quantity of units.

Fact Work Order Production Cost.Current Amount

Rework Cost.Planned Amount

Planned amount in transaction currency to produce a given quantity of units.

Fact Work Order Production Cost.Planned Amount

Rework Cost.Scrapped Amount

Parent scrap cost amount in transaction currency to produce a given quantity of units.

Fact Work Order Production Cost.Scrapped Amount

Rework Cost.Standard Amount

Standard amount in transaction currency to produce a given quantity of units.

Fact Work Order Production Cost.Standard Amount

Rework Cost.Actual Amount

Actual amount in transaction currency to produce a given quantity of units.

Fact Work Order Production Cost.Actual Amount

Average Manufacturing Cost.Completed WO

Average Manufacturing Cost.Order Type Id = ‘WO’ and Average Manufacturing Cost.Work Order Status Id = ‘99’

Rework Cost.Variance Flag

Rework Cost.Variance Flag Id = '3'

Rework Cost.Rework Work Order Type

Rework Cost.Work Order Type Id = 'R'

Rework Cost.Completed WO

Rework Cost.Order Type Id = 'WO' AND Rework Cost.Work Order Status Id = '99'

Product Failure.Completed WO

Product Failure.Order Type Id = 'WO' AND Product Failure.Work Order Status Id = '99'

Dimension Day Work Order Requested Date

A role-playing dimension based on PS_D_DAY for Work Order Requested Date.

PS_D_DAY

Dimension Order Type

Contains information about supply chain order types.

PS_D_ORD_TYP

Dimension Work Order Status

This dimension table stores information about all work order statuses

PS_D_WO_STATUS

Dimension Work Order Type

This dimension table stores information about work order types

PS_D_WO_TYPE

Fact Work Order Master

This fact table stores information about the work order. It provides for analysis of work orders and associated dates and quantities.

PS_F_WO_MASTER

Requested Vs (versus) Closed Work Orders

This complex folder provides information for the Requested Versus Closed Work Orders Report.

From the fact folder above.

Closed Percent

Number used for calculating the closed rate percentage metric.

Requested Vs Closed Work Orders.Number of Work Orders Closed*1.01

Number of Work Orders Closed

Count of work orders with a status of closed.

COUNT(Requested Vs Closed Work Orders.Document Number) where Requested Vs Closed Work Orders."Work Order Status Id" = '99'

Number of Work Orders Open

Count of work orders with a status of open.

COUNT(Requested Vs Closed Work Orders.Document Number) where Requested Vs Closed Work Orders."Work Order Status Id" <> '99'

Number of Work Orders Requested

Count of work orders with a status of requested.

COUNT(Requested Vs Closed Work Orders.Document Number)

Requested Percent

Number used for calculating the closed rate percentage metric.

Requested Vs Closed Work Orders.Number of Work Orders Requested*1.01

Dimension Business Unit

Business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Business Unit PO

A role-playing dimension based on PS_D_BUSINESS_UNIT for Purchase Order Business Unit.

PS_D_BUSINESS_UNIT

Dimension Buyer

Includes information on the buyer, the person who placed the purchase orders.

PS_D_BUYER

Dimension Day Snapshot Date

A role-playing dimension based on dimension day for snapshot date.

PS_D_DAY

Dimension Item

Contains information about inventory and non-inventory items. An inventory item is a tangible commodity that is physically stocked in inventory.

PS_D_INV_ITEM

Dimension Match Rule

Contains information about matching rules defined in the Accounts Payable (AP) module to match AP invoices and purchase orders.

PS_D_MATCH_RULE

Dimension Match Status

Contains information about all match statuses available when vouchers are compared with purchase orders and receiving documents to ensure that the organization pays for what it ordered and received.

PS_D_MTCH_STATUS

Dimension Supplier

This dimension includes information on suppliers. These vendors provide the products on the purchase orders.

PS_D_SUPPLIER

Fact Matching Analysis

This fact includes match analysis facts. It provides for analysis of invoice data with respect to vouchers at the voucher line level of detail.

PS_F_MTCH_ANLYS

Number of Voucher Lines

Number of voucher lines. A distinct count of Voucher ID and Voucher Line ID.

COUNT (DISTINCT VCHR_ID, VCHR_LINE_ID)

Number of Vouchers

Number of vouchers. A distinct count of the Voucher ID.

COUNT (DISTINCT VCHR_ID)

Voucher Line Amount

Voucher line amount in transaction currency.

VCHR_LINE_AMT

Voucher Line Amount (Base)

Voucher line amount in base currency.

VCHR_LINE_BSE_AMT

Dimension Business Unit

Business unit dimension.

PS_D_BUSINESS_UNIT

Business Unit PO

A role-playing dimension based on PS_D_BUSINESS_UNIT for Purchase Order Business Unit.

PS_D_BUSINESS_UNIT

Dimension Buyer

This dimension includes information on buyers, the person who placed the purchase orders.

PS_D_BUYER

Dimension Channel

Contains information about sales and purchasing channels. A channel is the avenue through which transactions are completed. Channels include telephone, internet (web sites, e-mail), mail response, and face-to-face interaction.

PS_D_CHANNEL

Dimension Day Snapshot Date

A role-playing dimension based on dimension day for snapshot date.

PS_D_DAY

Dimension Department

Contains information about the entities in an organization. The dimension includes several attributes about a department, such as description, company code, location, and budget.

PS_D_DEPT

Dimension Item

Contains information about inventory and non-inventory items. An inventory item is a tangible commodity that is physically stocked in inventory.

PS_D_INV_ITEM

Dimension Origin

Contains information about origin codes. Origin codes identify places in the system from which transactions originate.

PS_D_ORIGIN

Dimension Supplier

This dimension includes information on suppliers, those vendors who provided the products on the purchase orders.

PS_D_SUPPLIER

Fact Procurement Cycle Time Analysis

This fact includes Procurement Cycle Time Lead Time Analysis facts. It provides for pipeline analysis of a purchase order line as it moves through ordering, receiving, and payment processes.

PS_F_PROC_CTLT

Actual Lead Time

Actual lead-time that is quoted by suppliers.

ACTUAL_LEAD_TM

Days Approval To Dispatch

Time in days from approval to dispatch.

DAYS_APPRVL_TO_DSP

Days Receipt To Voucher

Time in days from receipt to voucher.

DAYS_RCPT_TO_VCHR

Days Request To Approval

Time in days from request to approval.

DAYS_REQ_TO_APPRVL

Days Voucher To Payment

Time in days from voucher to payment.

DAYS_VCHR_TO_PYMT

Expected Lead Time

Expected lead-time that is quoted by suppliers.

EXPECTED_LEAD_TM

Dimension Order Type

Contains information about all supply chain order types.

PS_D_ORD_TYP

Dimension Reason Code

Contains information about reason codes that explain the purpose of a transaction.

PS_D_REASON_CODE

Fact Purchase Order Disposition

This fact includes information on Purchase Order. It provides for analysis of purchase order units moved from purchase order line items for reasons such as broken and wrong item. It helps in acquiring accurate units and amounts for given items.

PS_F_PO_DISP

Units

Number of units that are disposed of.

UNITS

Dimension Business Unit

Business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Business Unit General Ledger

The general ledger business unit dimension is a role-playing dimension based on the business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Business Unit Inventory

A role-playing dimension based on PS_D_BUSINESS_UNIT for Inventory Business Unit.

PS_D_BUSINESS_UNIT

Dimension Business Unit PO

A role-playing dimension based on PS_D_BUSINESS_UNIT for Purchase Order Business Unit.

PS_D_BUSINESS_UNIT

Dimension Buyer

This dimension includes information on buyers, the person(s) who placed the purchase orders.

PS_D_BUYER

Dimension Cancel Status

Contains information about all supply chain cancel statuses.

PS_D_CNCL_STATUS

Dimension Channel

Contains information about sales and purchasing channels. A channel is the avenue through which transactions are completed. Channels include telephone, internet (web sites, e-mail), mail response, and face-to-face interaction.

PS_D_CHANNEL

Dimension Day Purchase Order Date

A role-playing dimension based on PS_D_DAY for Purchase Order Date.

PS_D_DAY

Dimension Day Snapshot Date

A role-playing dimension based on dimension day for snapshot date.

PS_D_DAY

Dimension Department

Contains information about organizational entities in an organization. The dimension includes several attributes about a department, such as description, company code, location, and budget.

PS_D_DEPT

Dimension Item

Contains information about inventory and non-inventory items. An inventory item is a tangible commodity that is physically stocked in inventory.

PS_D_INV_ITEM

Dimension Purchase Order Status

Contains information about where a purchase order is in its life cycle.

PS_D_PO_STATUS

Dimension Supplier

This dimension includes information on the suppliers who provided the products on the purchase orders.

PS_D_SUPPLIER

Dimension Unit of Measure

The unit of measure dimension. A standard of basic quantity or increment by which something is divided, counted, or described

PS_D_UOM

Fact Purchase Order Distribution

This fact includes Purchase Order (PO) Distribution facts. It provides for analysis of purchase order information at a purchase order distribution line level of detail.

PS_F_PO_DIST

Purchase Order (PO) Freight Amount

PO freight amount in transaction currency.

FRGHT_AMT

PO Freight Amount (Base)

PO freight amount in base currency.

FRGHT_BSE_AMT

PO Merchant Amount

PO merchandise amount in transaction currency.

MRCHN_AMT

PO Merchant Amount (Base)

PO merchandise amount in base currency.

MRCHN_BSE_AMT

PO Order Quantity

Quantity ordered for the PO.

PO_QTY_ORD

PO Sales Tax Amount

PO sales tax amount in transaction currency.

SALESTAX_AMT

PO Sales Tax Amount (Base)

PO sales tax amount in base currency.

SLSTAX_BSE_AMT

Dimension AB Master Ship To

Contains the address book (AB) master dimension for JD Edwards EnterpriseOne. It is equivalent to F0101 in the JD Edwards EnterpriseOne source system. This table stores all the records from the F0101 table, related phone information from the F0115 table, and address information

PS_D_AB_MASTER

Dimension Account

Contains details about an account that represents a ChartField.

PS_V_ACCOUNT

Dimension Business Unit Inventory

A role-playing dimension based on PS_D_BUSINESS_UNIT for Inventory Business Unit.

PS_D_BUSINESS_UNIT

Dimension Business Unit PO

A role-playing dimension based on PS_D_BUSINESS_UNIT for Purchase Order Business Unit.

PS_D_BUSINESS_UNIT

Dimension Buyer

This dimension includes information on buyers the people who placed the purchase orders.

PS_D_BUYER

Dimension Cancel Status

Contains information about all supply chain cancel statuses.

PS_D_CNCL_STATUS

Dimension Contract

Contains information about details of the contract information entered with customers.

PS_D_CA

Dimension Day GL Date

A role-playing dimension based on dimension day for GL Date.

PS_D_DAY

Dimension Day Original Delivery Date

A role-playing dimension based on PS_D_DAY for Original Delivery Date.

PS_D_DAY

Dimension Day Promised Delivery Date

A role-playing dimension based on PS_D_DAY for Promised Delivery Date.

PS_D_DAY

Dimension Day Purchase Order Date

A role-playing dimension based on PS_D_DAY for Purchase Order Date.

PS_D_DAY

Dimension Day Request Date

A role-playing dimension based on day dimension.

PS_D_DAY

Dimension Day Snapshot Date

A role-playing dimension based on dimension day for snapshot date.

PS_D_DAY

Dimension Item

Contains information about inventory and non-inventory items. An inventory item is a tangible commodity that is physically stocked in inventory.

PS_D_INV_ITEM

Dimension Last Status

Specifies the last step in the processing cycle that this order line has successfully completed.

PS_D_LAST_STAT

Dimension Line Type

This dimension table stores information on Line Types

A code that controls how the system processes lines on a transaction. It controls the systems with which the transaction interfaces, such as General Ledger, Job Cost, Accounts Payable, Accounts Receivable, and Inventory Management. It also specifies the conditions under which a line prints on reports, and it is included in calculations.

Codes include the following:

• S - Stock item

• J - Job cost

• N - Nonstock item

• F - Freight

• T - Text information

• M - Miscellaneous charges and credits

• W - Work order

PS_D_LN_TYP

Dimension Lot

Contains information about the quantity of inventory items produced as a group or otherwise collected into an identifiable unit.

PS_D_LOT

Dimension Next Status

Contains information about process cycle statuses that will occur next.

PS_D_LAST_STAT

Dimension Order Type

Stores information about all supply chain order types

PS_D_ORD_TYP

Dimension Pattern Day

The pattern day dimension. Stores data about dates and the associated fiscal patterns.

PS_D_PATTERN_DAY

Dimension Purchase Order Status

Contains information about where a purchase order is within its life cycle.

PS_D_PO_STATUS

Dimension Subledger

Contains information about sub ledger. Sub ledger is used to group the accounting information in various ways.

PS_D_SUBLEDGER

Dimension Supplier

This dimension includes information about suppliers who provided the products on the purchase orders.

PS_D_SUPPLIER

Fact Purchase Order Line

This fact table stores information about Purchase Order Line facts. It provides for analysis of purchase order information at a purchase order line level of detail.

PS_F_PO_LINE

Average PO Price

Average price of the units on the purchase order.

[Ordered Amount] / [Ordered Quantity]

Days PO Outstanding

Number of days that the purchase order has been outstanding before moving on to the next status or phase.

DAYS_PO_OUTST

Number of POs

Count of purchase orders.

COUNT_DISTINCT(PO Order Company||PO Order Number||PO Order Type Sid||PO Order Suffix||Line Number)

Ordered Amount

Total amount for the units ordered on that purchase order.

F_PO_LINE.UNITS_ORDERED * F_PO_LINE.UNIT_COST_BSE

PO Line Changes To Amount

Number of changes to the amount

CHANGS_TO_AMT

PO Line Changes To Quantity

Number of changes to quantity

CHANGS_TO_QTY

PO Line Extended Price

The extended price for each purchase order line. It is derived from the unit cost multiplied by the number of units.

LN_EXT_PRC

PO Line Extended Price (Base)

The extended price for each purchase order line in base currency. It is derived from the unit cost multiplied by the number of units.

LN_EXT_PRC_BSE

PO Line Extended Price (Foreign)

Extended price amount in foreign currency. It is derived from the unit cost multiplied by the number of units.

LN_EXTPRC_BSE_FRGN

PO Line On Hold Amount

The cost of the quantity on hold for the purchase order line.

ON_HOLD_AMT

PO Line On Hold Amount (Base)

The cost of the quantity on hold for the purchase order line in base currency.

ON_HLD_BS_AMT

PO Line Open Amount

Open amount in transaction currency associated with a purchase order in open purchase order line status.

OPEN_AMT

PO Line Open Amount (Base)

Open amount in base currency associated with a purchase order in open purchase order line status.

OPEN_BSE_AMT

PO Line Open Amount (Foreign)

Open amount in foreign currency associated with a purchase order in open purchase order line status.

OPEN_AMT_FRGN

PO Line Received Amount

Received amount in transaction currency.

RCVD_AMT

PO Line Received Amount (Base)

Received amount in base currency.

RCVD_BS_AMT

PO Line Received Amount (Foreign)

Received amount in foreign currency.

RCVD_FRGN_AMT

PO Line Relieved Amount

Relieved amount for purchase order line.

LN_RLVD_AMT

PO Line Relieved Amount (Base)

Relieved amount for purchase order line in base currency.

LN_RLVD_BSE_AMT

PO Line Unit Cost

Unit cost amount, as purchased from the supplier, excluding freight, taxes, discounts, and other factors that might modify the actual unit cost when the item is received.

UNIT_COST

PO Line Unit Cost (Base)

Unit cost amount in base currency, as purchased from the supplier, excluding freight, taxes, discounts, and other factors that might modify the actual unit cost when the item is received.

UNIT_COST_BSE

PO Line Unit Cost (Foreign)

Unit cost amount in foreign currency, as purchased from the supplier, excluding freight, taxes, discounts, and other factors that might modify the actual unit cost when the item is received.

UNIT_COST_FRGN

PO Line Units On Hold Quantity

Number of units on hold for the purchase order line.

UNITS_ON_HOLD

PO Line Units Open Quantity

Number of units open for the purchase order line.

UNITS_OPEN

PO Line Units Ordered Quantity

Number of units ordered by the customer.

UNITS_ORDERED

Po Line Units Received Quantity

Number of units received by the entities that placed the purchase orders.

UNITS_RECV

PO Line Units Relieved Quantity

Units that have been relieved from the total number of committed units.

UNITS_RELVD

Dimension Account

Details of an account that represents a ChartField. Rick: check answer to question later in this doc.

PS_V_ACCOUNT

Dimension Business Unit Account

Business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Day General Ledger (GL) Date

A role-playing dimension based on dimension day for GL Date

PS_D_DAY

Dimension Order Type

Contains information about all supply chain order types.

PS_D_ORD_TYP

Fact Purchase Order Line Multiple Accounts

Contains information about purchase order line facts that are distributed against multiple accounts.

PS_F_PO_LN_MACT

On Hold Amount

On-hold amount in transaction currency.

ON_HLD_AMT

On Hold Amount (Base)

On-hold amount in base currency.

ON_HLD_BSE_AMT

On Hold Quantity

Number of units on hold.

UNITS_ON_HLD

Open Amount

Open amount in transaction currency associated with a purchase order in open purchase order line status.

OPN_AMT

Open Amount (Base)

The open amount in base currency associated with a purchase order in open purchase order line status.

OPN_BSE_AMT

Open Quantity

Number of units associated with a purchase order in open purchase order line status.

UNITS_OPN

Ordered Quantity

Quantity ordered by the customer expressed in the primary stocking unit of measure.

UNITS_ORDERED

Received Amount

Received amount in transaction currency.

RCVD_AMT

Received Amount (Base)

Received amount in base currency.

RCVD_BSE_AMT

Received Quantity

Number of units received.

UNITS_RECV

Relieved Amount

Relieved amount in transaction currency.

LN_AMT_RELIEVED

Relieved Quantity

Number of units relieved.

UNITS_RELVD

Dimension Account

Details of an account that represents a ChartField.

PS_V_ACCOUNT

Dimension Business Unit

Business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Business Unit Account

A role-playing dimension based on Dimension Business Unit for account business unit.

PS_D_BUSINESS_UNIT

Dimension Contract

Contains contract information entered with customers.

PS_D_CA

Dimension Day GL Date

A role-playing dimension based on dimension day for GL Date.

PS_D_DAY

Dimension Day Order Date

A role-playing dimension based on Dimension Day for Order Date.

PS_D_DAY

Dimension Day Original Promised Delivery Date

A role-playing dimension based on PS_D_DAY for Original Promised Delivery Date.

PS_D_DAY

Dimension Day Promised Delivery Date

A role-playing dimension based on PS_D_DAY for Promised Delivery Date.

PS_D_DAY

Dimension Day Received Date

A role-playing dimension based on PS_D_DAY for Received Date.

PS_D_DAY

Dimension Day Request Date

A role-playing dimension based on day dimension.

PS_D_DAY

Dimension Inventory Location

Contains information about location of items in inventory.

PS_D_INV_LOCATION

Dimension Item

Contains information about inventory and non-inventory items. An inventory item is a tangible commodity that is physically stocked in inventory.

PS_D_INV_ITEM

Dimension Last Status

Specifies the last step in the processing cycle that this order line has successfully completed.

PS_D_LAST_STAT

Dimension Line Type

A code that controls how the system processes lines on a transaction. It controls the systems with which the transaction interfaces, such as General Ledger, Job Cost, Accounts Payable, Accounts Receivable, and Inventory Management. It also specifies the conditions under which a line prints on reports, and it is included in calculations.

Codes include the following:

• S - Stock item

• J - Job cost

• N - Nonstock item

• F - Freight

• T - Text information

• M - Miscellaneous charges and credits

• W - Work order

PS_D_LN_TYP

Dimension Lot

Contains information about the quantity of inventory items produced as a group or otherwise collected into an identifiable unit.

PS_D_LOT

Dimension Next Status

Contains information about process cycle statuses that will occur next.

PS_D_LAST_STAT

Dimension Order Type

Contains information about all supply chain order types.

PS_D_ORD_TYP

Dimension Pattern Day

Stores data about dates and the associated fiscal patterns.

PS_D_PATTERN_DAY

Dimension Subledger

Contains information about sub ledgers, which are used to group the accounting information in various ways.

PS_D_SUBLEDGER

Dimension Supplier

This dimension includes information about suppliers who provided the products about the purchase orders.

PS_D_SUPPLIER

Fact Purchase Order Receipt

This fact includes information about Purchase order Receipts. It provides for analysis of purchase order receipts and vouchers.

PS_F_PO_RCPT

Adjusted Quantity

Number of units adjusted for a PO.

RCPT_UNITS_ADJSTD

Amount Paid To Date

Total amount paid to date for the PO receipt in transaction currency.

RCPT_AMT_PD_TD

Amount Paid To Date (Foreign)

Total amount paid to date for the PO receipt in foreign currency.

AMT_PD_TD_FRGN

Average PO Price

Average price of the units on the purchase order line.

[Ordered Amount] / [Ordered Quantity]

Average Voucher Price

Average price of the units on the voucher corresponding to the purchase order line.

[Voucher Amount] / [Voucher Quantity]

Closed Amount

This is the total amount closed for the PO receipt in transaction currency.

RCPT_AMT_CLSD

Closed Amount (Foreign)

Total amount closed for the PO receipt in foreign currency.

AMT_CLSD_FRGN

Closed Quantity

Number of units closed for a PO.

RCPT_UNITS_CLSD

Cost Variance Amount

Cost variance amount in transaction currency.

CST_VAR_AMT

Cost Variance Amount (Base)

Cost variance amount in base currency.

CST_VAR_AMT_BSE

Lead Time

The purchase order lead-time.

PO_LEAD_TM

Lead Time Level

The standard lead-time level for the items on the purchase order.

PO_LEAD_TM_LVL

Lead Time Planned

The planned purchase order lead-time.

PO_LEAD_TM_PLN

Open Amount

Open amount in transaction currency associated with a PO in open purchase order line status.

RCPT_AMT_OPN

Open Amount (Foreign)

Open amount in foreign currency associated with a PO in open purchase order line status.

AMT_OPN_FRGN

Open Quantity

Number of units associated with a PO in open purchase order line status.

RCPT_UNITS_OPN

Order Unit Cost Variance

Used to calculate the purchase price variance metric.

ORD_UNIT_CST_VRNC

Ordered Amount

Total amount for the units corresponding to a purchase order receipt.

[Ordered Quantity] * F_PO_RCPT.UNIT_CST_BSE

Ordered Quantity

Quantity ordered by the customer expressed in the primary stocking unit of measure.

RCPT_UNITS_ORDED

Over Invoiced Amount

Difference between the amounts on the voucher and the invoice, where the invoice amount exceeds the voucher amount.

[Voucher Amount] Filter by <[Voucher Amount] > [Ordered Amount] >

Percent Over Invoiced Amount

Percentage of the difference between the amounts on the voucher and the invoice, where the invoice amount exceeds the voucher amount.

[Over Invoiced Amount]/ [Voucher Amount]

Percent Under Invoiced Amount

Percentage of the amount between the amounts on the voucher and the invoice where the voucher amount exceeds the invoice amount.

[Under Invoiced Amount]) / [Voucher Amount]

Purchase Price Variance

Purchase price variance in transaction currency.

PURCH_PRICE_VAR

Purchase Price Variance (Base)

Purchase price variance in base currency.

BASE_PUR_PRC_VAR

Quantity Paid To Date

Number of units paid to date for a PO.

RCPT_UNITS_PD_TD

Received Amount

Received amount in transaction currency.

RCPT_AMT_RCVD

Received Amount (Foreign)

Received amount in foreign currency.

AMT_RCVD_FRGN

Received Quantity

Number of units received for purchase orders.

RCPT_UNITS_RCVD

Rejected Quantity

Number of units rejected for purchase orders.

RCPT_UNITS_RJCTD

Returned Amount

Total amount of the returned quantity on a purchase order receipt.

[Returned Quantity]*[Unit Cost (Base)]

Returned Quantity

Number of units returned for purchase orders.

RCPT_UNITS_RTRND

Reworked Quantity

Number of units reworked for purchase orders.

RCPT_UNITS_RWRKD

Scrapped Quantity

Number of units scrapped for purchase orders.

RCPT_UNITS_SCRPD

Standard Unit Cost

The cost of one item as purchased from the supplier at the order receipt level. This cost excludes freight, taxes, discounts, and other factors that might modify the actual unit cost recorded when the item is received.

STD_UNIT_CST

Standard Unit Cost Variance

Variance between receipt unit cost and standard unit cost in transaction currency.

STD_UNIT_CST_VRNC

Stocked Quantity

Number of units stocked for purchase orders.

RCPT_UNITS_STCKD

Tax Amount

Tax amount in transaction currency.

TAX_AMT

Tax Amount (Foreign)

Tax amount in foreign currency.

TAX_AMT_FRGN

Under Invoiced Amount

Difference between the amounts on the voucher and the invoice when the voucher amount exceeds the invoice amount.

[Voucher Amount] Filter by <[Voucher Amount] < [Ordered Amount] >

Unit Cost

Unit cost in transaction currency, as purchased from the supplier, excluding freight, taxes, discounts, and other factors that might modify the actual unit cost when the item is received.

RCPT_UNIT_CST

Unit Cost (Base)

Unit cost in base currency, as purchased from the supplier, excluding freight, taxes, discounts, and other factors that might modify the actual unit cost when the item is received.

UNIT_CST_BSE

Unit Cost (Foreign)

Unit cost in foreign currency, as purchased from the supplier, excluding freight, taxes, discounts, and other factors that might modify the actual unit cost when the item is received.

UNIT_CST_FRGN

Voucher Amount

Total amount paid to date on a voucher for a purchase order receipt.

[Amount Paid To Date]

Dimension Account

This dimension includes details of an account that represents a ChartField.

PS_V_ACCOUNT

Dimension Business Unit Account

Business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Order Type

Contains information about all supply chain order types

PS_D_ORD_TYP

Dimension Subledger

Contains information about sub ledger. A sub ledger is used to group the accounting information in various ways.

PS_D_SUBLEDGER

Fact Purchase Order Receipt and Voucher Multiple Accounts

Contains information about purchase order receipts that are distributed across multiple accounts.

PS_F_PO_RCPT_MACT

Closed Amount

Total amount closed for the PO receipt in transaction currency.

RCPT_AMT_CLSD

Closed Amount (Base)

Total amount closed for the PO receipt in base currency.

AMT_CLSD_BSE

Closed Amount (Foreign)

Total amount closed for the PO receipt in foreign currency.

AMT_CLSD_FRGN

Closed Quantity

Number of units closed for a PO.

RCPT_UNS_CLSD

Open Amount

Open amount in transaction currency associated with a purchase order in open purchase order line status.

RCPT_AMT_OPEN

Open Amount (Base)

Open amount in base currency associated with a purchase order that is in open purchase order line status.

AMT_OPEN_BSE

Open Amount (Foreign)

Open amount in foreign currency associated with a PO in open purchase order line status.

AMT_OPEN_FRGN

Open Quantity

Number of units associated with a purchase order in open purchase order line status.

RCPT_UNS_OPEN

Ordered Quantity

Quantity ordered by the customer expressed in the primary stocking unit of measure.

RCPT_UNS_ORDED

Paid To Date Amount

Amount paid to date in transaction currency.

RCPT_AMT_PD_TD

Paid To Date Amount (Base)

Amount paid to date in base currency.

AMT_PD_TD_BSE

Paid To Date Amount (Foreign)

Amount paid to date in foreign currency.

AMT_PD_TD_FRGN

Paid to Date Quantity

Number of received units that c corresponds to what has been paid to date.

RCPT_UNS_PD_TDE

Received Amount

Received amount in transaction currency.

RCPT_AMT_RCVD

Received Amount (Base)

Received amount in base currency.

AMT_RECVD_BSE

Received Amount (Foreign)

Received amount in foreign currency.

AMT_RECVD_FRGN

Received Quantity

Number of units received.

RCPT_UNS_RCVD

Tax Amount

Tax amount in transaction currency.

TAX_AMT

Tax Amount (Base)

This is the tax amount in base currency.

TAX_AMT_BSE

Tax Amount (Foreign)

Tax amount in foreign currency.

TAX_AMT_FRGN

Dimension Account

This dimension includes details of an account that represents a ChartField.

PS_V_ACCOUNT

Dimension Business Unit General Ledger

A role-playing dimension based on the business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Business Unit Inventory

A role-playing dimension based on PS_D_BUSINESS_UNIT for Inventory Business Unit.

PS_D_BUSINESS_UNIT

Dimension Business Unit PO

A role-playing dimension based on PS_D_BUSINESS_UNIT for Purchase Order Business Unit.

PS_D_BUSINESS_UNIT

Dimension Cancel Status

Includes information about all supply chain cancel statuses.

PS_D_CNCL_STATUS

Dimension Carrier

Contains information about carriers the organization uses to move freight.

PS_D_CARRIER

Dimension Channel

Contains information about sales and purchasing channels. A channel is the avenue through which transactions are completed. Channels include telephone, Internet (web sites, e-mail), mail response, and face-to-face interaction.

PS_D_CHANNEL

Dimension Day Snapshot Date

A role-playing dimension based on dimension day for snapshot date.

PS_D_DAY

Dimension Delivery Status

Contains information about all supply chain delivery statuses.

PS_D_DLVRY_STATUS

Dimension Item

Contains information about inventory and non-inventory items. An inventory item is a tangible commodity that is physically stocked in inventory.

PS_D_INV_ITEM

Dimension Purchase Order Status

Contains information about where a purchase order is in its life cycle.

PS_D_PO_STATUS

Dimension Receipt Status

Contains information about all receipt statuses as defined within the receiving life cycle.

PS_D_RECV_STATUS

Dimension Ship Receipt Completion Status

Contains information about ship receipt completion statuses.

PS_D_COMP_STATUS

Dimension Supplier

This dimension includes information about suppliers who provided the products on the purchase orders.

PS_D_SUPPLIER

Fact Purchase Order Ship Receipt

This fact includes information about Purchase Order Receipts. It provides for analysis of purchase order received shipment information at a receipt line shipment level of detail.

PS_F_PO_SHIP_RCPT

Accepted Amount

Amount accepted for a received line in transaction currency.

PO_ACPTD_AMT

Accepted Amount (Base)

Amount accepted for a received line in base currency.

PO_ACPTD_BSE_AMT

Accepted Quantity

Quantity accepted for purchase orders.

PO_ACCPTD_QTY

Inspected Amount

Amount inspected for a received shipment line in transaction currency.

PO_INSP_AMT

Inspected Amount (Base)

Amount inspected for a received shipment line in base currency.

PO_INSP_BS_AMT

Inspected Quantity

Quantity inspected for purchase orders.

PO_INSPCTD_QTY

Number of PO Shipments

Total number of purchase order shipments.

Count (*) − Counts all of the columns in the PO Ship Receipt table.

PO Counter

Counter for the purchase orders to be able to increment the purchase orders.

1

PO Price

PO price in transaction currency.

PO_PRICE

PO Price (Base)

PO price in base currency.

PO_PRICE_BSE

Received Amount

Amount received for a shipment line in transaction currency.

PO_RCVD_AMT

Received Amount (Base)

Amount received for a shipment line in base currency.

PO_RCVD_BSE_AMT

Received Quantity

Number of units received for purchase orders.

PO_RCVD_QTY

Rejected Amount

Amount rejected for a received shipment line in transaction currency.

PO_RJCT_AMT

Rejected Amount (Base)

Amount rejected for a received shipment line in base currency.

PO_RJCT_BSE_AMT

Rejected Quantity

Quantity rejected for purchase orders.

PO_RJCTD_QTY

Standard Unit Cost

Cost of one unit at the order receipt level as purchased from the supplier, excluding freight, taxes, discounts, and other factors that might modify the actual unit cost recorded when the item is received.

STD_UNIT_COST

Standard Unit Cost Variance

Variance between receipt unit cost and standard unit cost.

STD_UNIT_CST_VAR

Unit Cost

Cost of one item at order receipt as purchased from the supplier, excluding freight, taxes, discounts, and other factors that might modify the actual unit cost when receipt is recorded.

RCPT_UNIT_COST

Dimension Business Unit

Business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Business Unit PO

A role-playing dimension based on PS_D_BUSINESS_UNIT for Purchase Order Business Unit.

PS_D_BUSINESS_UNIT

Dimension Buyer

This dimension includes information about the person who placed the purchase orders.

PS_D_BUYER

Dimension Day Snapshot Date

A role-playing dimension based on dimension day for snapshot date.

PS_D_DAY

Dimension Department

Contains information about the organizational entities in an organization. The dimension includes several attributes about a department, such as description, company code, location, and budget.

PS_D_DEPT

Dimension Item

Contains information about inventory and non-inventory items. An inventory item is a tangible commodity that is physically stocked in inventory.

PS_D_INV_ITEM

Dimension Order Type

Contains information about all supply chain order types

PS_D_ORD_TYP

Dimension Origin

Contains information about origin codes. Origin codes identify places in the system from which transactions originate.

PS_D_ORIGIN

Dimension Person

Represents the most current personal information of both employees and non-employees of an organization.

PS_D_PERSON

Dimension Requisition Line Status

Identifies the state of a line item being requisitioned.

PS_D_REQLN_STATUS

Dimension Requisition Status

Contains information about all requisition statuses as defined within the item requisition life cycle.

PS_D_REQ_STATUS

Fact Requisition Analysis

This fact includes Requisition Analysis facts. It provides for pipeline analysis of a requisition line as it moves through the requisition, ordering, receiving and payment processes.

PS_F_REQN_ANLYSIS

Days Approval To Dispatch

Number of days between the date the requisition was approved and the last purchase order dispatch date.

DAYS_APPRVL_TO_DSP

Days Dispatch To Receipt

Number of days between the purchase order dispatch date and the date the material was received.

DAYS_DSP_TO_RCPT

Days Receipt To Voucher

Number of days between the date the material was received and the last associated voucher.

DAYS_RCPT_TO_VCHR

Days Required To Approval

Number of days between the creation date of the requisition and the date of its approval.

DAYS_REQ_TO_APPRVL

Days Voucher To Payment

Number of days between the voucher date and the last associated payment date.

DAYS_VCHR_TO_PYMT

Dimension Business Unit

Business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Business Unit PO

A role-playing dimension based on PS_D_BUSINESS_UNIT for Purchase Order Business Unit.

PS_D_BUSINESS_UNIT

Dimension Buyer

This dimension includes information about the person who placed the purchase orders.

PS_D_BUYER

Dimension Day Snapshot Date

A role-playing dimension based on dimension day for snapshot date.

PS_D_DAY

Dimension Department

Contains information about the organizational entities in an organization. The dimension includes several attributes about a department, such as description, company code, location, and budget.

PS_D_DEPT

Dimension Item

Contains information about inventory and non-inventory items. An inventory item is a tangible commodity that is physically stocked in inventory.

PS_D_INV_ITEM

Dimension Order Type

Contains information about all supply chain order types

PS_D_ORD_TYP

Dimension Origin

Contains information about origin codes. Origin codes identify places in the system from which transactions originate.

PS_D_ORIGIN

Dimension Person

Represents the most current personal information of both employees and non-employees of an organization.

PS_D_PERSON

Dimension Requisition Line Status

Identifies the state of a line item being requisitioned.

PS_D_REQLN_STATUS

Dimension Requisition Status

Contains information about all requisition statuses as defined within the item requisition life cycle.

PS_D_REQ_STATUS

Dimension Unit of Measure

The unit of measure dimension. A standard of basic quantity or increment by which something is divided, counted, or described

PS_D_UOM

Fact Requisition Line

This fact table stores Requisition line level. It provides for analysis of requisitions at a requisition line level of detail.

PS_F_REQN

Merchant Amount

Requisition merchandise amount in transaction currency.

MERCH_AMT

Merchant Amount (Base)

Requisition merchandise amount in base currency.

MERCH_AMT_BSE

Requisition Price

Price requested on the requisition in transaction currency.

REQ_PRICE

Requisition Price (Base)

Price requested on the requisition in base currency.

REQ_PRICE_BSE

Requisition Quantity

Quantity requested on the requisition.

REQ_QTY

Requisition Quantity (Standard)

Quantity requested on the requisition in the standard unit of measure.

REQ_QTY_STD

Dimension Business Unit

Business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Business Unit General Ledger

A role-playing dimension based on the business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Business Unit PO

A role-playing dimension based on PS_D_BUSINESS_UNIT for Purchase Order Business Unit.

PS_D_BUSINESS_UNIT

Dimension Buyer

This dimension includes information about buyers who placed the purchase orders.

PS_D_BUYER

Dimension Cancel Status

Contains information about all supply chain cancel statuses.

PS_D_CNCL_STATUS

Dimension Carrier

Contains information about carriers the organization uses to move freight.

PS_D_CARRIER

Dimension Day Purchase Order Date

This is a role-playing dimension based on PS_D_DAY for Purchase Order Date.

PS_D_DAY

Dimension Day Received Date

This is a role-playing dimension based on PS_D_DAY for Received Date.

PS_D_DAY

Dimension Day RTV (Return to Vendor) Date

This is a role-playing dimension based on PS_D_DAY for RTV Date.

PS_D_DAY

Dimension Day Snapshot Date

A role-playing dimension based on dimension day for snapshot date.

PS_D_DAY

Dimension Item

Contains information about inventory and non-inventory items. An inventory item is a tangible commodity that is physically stocked in inventory.

PS_D_INV_ITEM

Dimension Purchase Order Status

Contains information about where a purchase order is with regard to its life cycle.

PS_D_PO_STATUS

Dimension Receive Line Status

Identifies the state of a line item being received.

PS_D_RECLN_STATUS

Dimension Return Reason

Contains information about all return reason statuses regarding supply chain.

PS_D_RTRN_REASON

Dimension Return To Vendor Line Status

Contains information about all return to vendor (RTV) line statuses.

PS_D_RTVLN_STATUS

Dimension Return To Vendor Status

Contains information about all RTV statuses.

PS_D_RTV_STATUS

Dimension Ship To

Contains information about ship to locations.

PS_D_SHIPTO

Dimension Supplier

This dimension includes information about suppliers provided the products on the purchase orders.

PS_D_SUPPLIER

Dimension Unit of Measure

A standard of basic quantity or increment by which something is divided, counted, or described

PS_D_UOM

Fact Return To Vendor

This fact includes Return to Vendor line level facts. It provides for analysis of returns to vendors at a return to vendor line level of detail.

PS_F_RTV

PO Price

PO price in transaction currency.

PO_PRICE

PO Price (Base)

PO price in base currency.

PO_PRICE_BSE

Returned Amount

PO returned amount in transaction currency.

PO_RET_AMT

Returned Amount (Base)

PO returned amount in base currency.

PO_RET_BSE_AMT

Returned Quantity

Number of items returned.

PO_QTY_RTND

Dimension Business Unit

Business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Business Unit General Ledger

A role-playing dimension based on the business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Business Unit Inventory

A role-playing dimension based on PS_D_BUSINESS_UNIT for Inventory Business Unit.

PS_D_BUSINESS_UNIT

Dimension Business Unit PO

A role-playing dimension based on PS_D_BUSINESS_UNIT for Purchase Order Business Unit.

PS_D_BUSINESS_UNIT

Dimension Buyer

This dimension includes information about buyers who placed the purchase orders.

PS_D_BUYER

Dimension Cancel Status

Contains information about all supply chain cancel statuses

PS_D_CNCL_STATUS

Dimension Carrier

Contains information about carriers the organization uses to move freight.

PS_D_CARRIER

Dimension Channel

Contains information about sales and purchasing channels. A channel is the avenue through which transactions are completed. Channels include telephone, Internet (Web sites, e-mail), mail response and face-to-face interaction.

PS_D_CHANNEL

Dimension Day Purchase Order Date

A role-playing dimension based on PS_D_DAY for Purchase Order Date.

PS_D_DAY

Dimension Day Purchase Order Due Date

A role-playing dimension based on Dimension Day for purchase order due date.

PS_D_DAY

Dimension Day Received Date

A role-playing dimension based on PS_D_DAY for Received Date.

PS_D_DAY

Dimension Day RTV Date

A role-playing dimension based on PS_D_DAY for RTV Date.

PS_D_DAY

Dimension Day RTV Ship Date

A role-playing dimension based on PS_D_DAY for RTV ship date.

PS_D_DAY

Dimension Day Snapshot Date

A role-playing dimension based on dimension day for snapshot date.

PS_D_DAY

Dimension Department

Contains information about the organizational entities in an organization. The dimension includes several attributes about a department, such as description, company code, location, and budget.

PS_D_DEPT

Dimension Item

Contains information about inventory and non-inventory items. An inventory item is a tangible commodity that is physically stocked in inventory.

PS_D_INV_ITEM

Dimension Purchase Order Status

Contains information about where a purchase order is with regard to its life cycle.

PS_D_PO_STATUS

Dimension Receive Line Status

Identifies the state of a line item being received.

PS_D_RECLN_STATUS

Dimension Return Reason

Contains information about all return reason statuses regarding supply chain.

PS_D_RTRN_REASON

Dimension Return To Vendor Line Status

Contains information about all return to vendor (RTV) line statuses.

PS_D_RTVLN_STATUS

Dimension Return To Vendor Status

Contains information about all return to vendor (RTV) statuses.

PS_D_RTV_STATUS

Dimension Ship To

Contains information about ship to locations.

PS_D_SHIPTO

Dimension Supplier

Information about suppliers who provided the products on the purchase orders.

PS_D_SUPPLIER

Dimension Unit of Measure

A standard of basic quantity or increment by which something is divided, counted, or described.

PS_D_UOM

Fact Return To Vendor Distribution

Stores return to vendor shipping line level facts. It provides for analysis of returns to vendors at a shipping line level of detail.

PS_F_RTV_DIST

PO Price

PO price in transaction currency.

PO_PRICE

PO Price (Base)

PO price in base currency.

PO_PRICE_BSE

PO Quantity Returned

Number of items returned.

PO_QTY_RTND

PO Return Amount

PO returned amount in transaction currency.

PO_RET_AMT

PO Return Amount (Base)

PO returned amount in base currency.

PO_RET_BSE_AMT

Dimension Account

This dimension includes details of an account that represents a ChartField.

PS_V_ACCOUNT

Dimension Business Unit

Business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Business Unit Account

A role-playing dimension based on Dimension Business Unit for account business unit.

PS_D_BUSINESS_UNIT

Dimension Business Unit General Ledger

The general ledger business unit dimension is a role-playing dimension based on the business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Business Unit Inventory

A role-playing dimension based on PS_D_BUSINESS_UNIT for Inventory Business Unit.

PS_D_BUSINESS_UNIT

Dimension Business Unit PO

A role-playing dimension based on PS_D_BUSINESS_UNIT for Purchase Order Business Unit.

PS_D_BUSINESS_UNIT

Dimension Buyer

This dimension includes information on the person who placed the purchase orders.

PS_D_BUYER

Dimension Cancel Status

Contains information about all supply chain cancel statuses

PS_D_CNCL_STATUS

Dimension Carrier

Contains information about carriers the organization uses to move freight.

PS_D_CARRIER

Dimension Channel

Contains information about sales and purchasing channels. A channel is the avenue through which transactions are completed. Channels include telephone, internet (web sites, e-mail), mail response, and face-to-face interaction.

PS_D_CHANNEL

Dimension Completion Status

Includes a list of completion statuses that can be associated with an enrollment.

PS_D_CMPLTN_STAT

Dimension Contract

Contains the details of the contract information entered with customers.

PS_D_CA

Dimension Day

The date dimension

PS_D_DAY

Dimension Delivery Status

Includes information about all delivery statuses regarding supply chain

PS_D_DLVRY_STATUS

Dimension Inventory Location

Contains information about location of items in inventory.

PS_D_INV_LOCATION

Dimension Item

Contains information about inventory and non-inventory items. An inventory item is a tangible commodity that is physically stocked in inventory.

PS_D_INV_ITEM

Dimension Last Status

Specifies the last step in the processing cycle that this order line has successfully completed.

PS_D_LAST_STAT

Dimension Line Type

A code that controls how the system processes lines on a transaction. It controls the systems with which the transaction interfaces, such as General Ledger, Job Cost, Accounts Payable, Accounts Receivable, and Inventory Management. It also specifies the conditions under which a line prints on reports, and it is included in calculations.

Codes include the following:

• S - Stock item

• J - Job cost

• N - Nonstock item

• F - Freight

• T - Text information

• M - Miscellaneous charges and credits

• W - Work order

PS_D_LN_TYP

Dimension Lot

Contains information about the quantity of inventory items produced as a group or otherwise collected into an identifiable unit.

PS_D_LOT

Dimension Next Status

Includes information about process cycle statuses that will occur next.

PS_D_LAST_STAT

Dimension Order Type

Stores information about all supply chain order types.

PS_D_ORD_TYP

Dimension Purchase Order Status

Includes information about where a purchase order is within its life cycle.

PS_D_PO_STATUS

Dimension Receive Line Status

Identifies the state of a line item being received.

PS_D_RECLN_STATUS

Dimension Ship To

Includes information about ship to locations.

PS_D_SHIPTO

Dimension Subledger

Includes information about sub ledger. Sub ledger is used to group the accounting information in various ways.

PS_D_SUBLEDGER

Dimension Supplier

This dimension includes information about suppliers who provided the products on the purchase orders.

PS_D_SUPPLIER

Fact Purchase Order Line

This fact table stores information about Purchase Order Line facts. It provides for analysis of purchase order information at a purchase order line level of detail.

PS_F_PO_LINE

Fact Purchase Order Receipt

This fact includes information about Purchase order Receipts. It provides for analysis of purchase order receipts and vouchers.

PS_F_PO_RCPT

Fact Purchase Order Ship Receipt

This fact includes information about Purchase Order. It provides for analysis of purchase order received shipment information at a receipt line shipment level of detail.

PS_F_PO_SHIP_RCPT

Dimension Business Unit AP

The accounts payable business unit dimension is a role-playing dimension based on the business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Business Unit General Ledger

The general ledger business unit dimension is a role-playing dimension based on the business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Day Snapshot Date

A role-playing dimension based on dimension day for snapshot date.

PS_D_DAY

Dimension Supplier

This dimension includes information about suppliers who provided the products on the purchase orders.

PS_D_SUPPLIER

Fact Voucher

This fact folder includes information about Voucher Fact.

It provides for analysis of accounts payable information and related detailed spending information at a voucher level of detail.

PS_F_VCHR

Payment Amount

Represents the payment amount in transaction currency.

PYMNT_AMT

Payment Amount (Base)

Represent the payment amount in base currency.

PYMNT_AMT_BSE

Payment Count

The payment count

PYMNT_CNT

Payment Discount Amount

Represents the payment discount amount in transaction currency.

PYMNT_DIS_AMT

Payment Discount Amount (Base)

Represents the payment discount amount in base currency.

PYMNT_DIS_BSE

Dimension Account

This dimension includes details of an account that represents a ChartField.

PS_V_ACCOUNT

Dimension AP Document Type

Includes details about various AP document types, such as payables prepayments, payables adjustments, and payables accruals.

PS_D_AP_DOC_TYPE

Dimension Business Unit

Business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Business Unit Account

Business unit dimension. A role-playing dimension based on Dimension Business Unit for account business unit.

PS_D_BUSINESS_UNIT

Dimension Business Unit AP

The accounts payable business unit dimension is a role-playing dimension based on the business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Buyer

This dimension includes information about buyers who placed the purchase orders.

PS_D_BUYER

Dimension Contract

Contains the details of the contract information entered with customers.

PS_D_CA

Dimension Day Invoice Date

A role-playing dimension based on dimension day for Invoice Date

PS_D_DAY

Dimension Item

Contains information about inventory and non-inventory items. An inventory item is a tangible commodity that is physically stocked in inventory.

PS_D_INV_ITEM

Dimension Ledger

Includes the ID and description of ledgers that are defined based on templates. Detailed information about JD Edwards EnterpriseOne ledger type, such as AA-Actual Amount and BA-Budgeting Amount are also stored.

PS_D_LEDGER

Dimension Line Type

A code that controls how the system processes lines on a transaction. It controls the systems with which the transaction interfaces, such as General Ledger, Job Cost, Accounts Payable, Accounts Receivable, and Inventory Management. It also specifies the conditions under which a line prints on reports, and it is included in calculations.

Codes include the following:

• S - Stock item

• J - Job cost

• N - Nonstock item

• F - Freight

• T - Text information

• M - Miscellaneous charges and credits

• W - Work order

PS_D_LN_TYP

Dimension Order Type

Stores information about all supply chain order types

PS_D_ORD_TYP

Dimension Pattern Day Journal

A role-playing dimension based on the pattern day dimension.

PS_D_PATTERN_DAY

Dimension Payment Method

Includes the details about various methods of payment such as check, cash, and credit card.

PS_D_PYMNT_MTHD

Dimension Supplier

This dimension includes information about suppliers. The vendors who provided the products on the purchase orders.

PS_D_SUPPLIER

Fact Voucher Line

This fact folder provides for analysis of accounts payable information and related detailed spending information at a voucher line level of detail.

PS_F_VCHR_LN

Cost Variance

Cost variance amount in transaction currency.

CST_VRNC

Cost Variance (Base)

Cost variance amount in base currency.

BASE_CST_VRNC

Line Unit Cost