RMS Oi Buyer Orders To Approve

Uniquely identifies a user session opening the report.

Holds the purchase order no that meets the filter criteria.

Holds the translated name of the order supplier.

Holds the not before date of the purchase order.

Holds the not after date of the purchase order.

Holds the end of week date of the open to buy.

Holds the total cost of the order. Declared as NUMBER(*,4) to allow greater number of digits for the precision because it holds a total value.

Holds the total retail of the order. Declared as NUMBER(*,4) to allow greater number of digits for the precision because it holds a total value.

Holds the currency code the total_cost and total_retail are expressed in.

Holds the ID of the person created the purchase order.

Holds any user comment. Oracle Retail target column COMMENT_DESC on RMS_OI_BUYER_ORDERS_TO_APPROVE.

Purchase order status Oracle Retail target column STATUS on RMS_OI_BUYER_ORDERS_TO_APPROVE.

This field contains a description for the PO status.

Contains the vendor number who will provide the merchandise specified in the order.

Contains the department number for orders limited to a single department and will be Null for orders involving items in more than one department.

Department name Oracle Retail target column DEPT_NAME on RMS_OI_BUYER_ORDERS_TO_APPROVE.

Contains the value associated with the PO_TYPE for the order.

This field contains a description for the specific order type.

A number that is used to reference the master order number from which child records were created. Orders with the same Master_PO number are grouped together using the same delivery date.

Contains the date the order was created within the system.

Contains the total number of items ordered. Declared as NUMBER(*,4) to allow greater number of digits for the precision because it holds a total value.

Indicates if the order has more than one unit of measure.

Markup is the difference between the cost of a good or service and its selling price. Declared as NUMBER(*,4) to allow greater number of digits for the precision because it holds a value based on the total.

Holds the date time stamp of the most recent update by the last_update_id.

Holds the Oracle user-id of the user who most recently updated this record.