Ordhead

Contains the number that uniquely identifies an order within the system.

Indicates the type of order and which Open To Buy bucket will be updated. Valid values include: N/B - Non Basic ARB - Automatic Reorder of Basic BRB - Buyer Reorder of Basic.

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

Contains the number associated with the buyer for the order.

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

Supplier address sequence number differentiates supplier address within the same type.

This field contains the type of location in the location field. Valid values are: Valid values are S (Store) or W (Warehouse).

This field contains the location all items on the order will be delivered to if populated. i.e. It will mean a single location order.

Contains the ad number associated with the order to provide a link between the order dialog and the promotions dialog.

Determines whether or not quality control will be required when items for this order are received. Valid values are Y and N.

Contains the date the order was created within the system.

Contains the first date that delivery of the order will be accepted.

Contains the last date that delivery of the order will be accepted.

This field contains the OTB budget bucket the order amount should be placed into.

The date before which the items on the purchase order can not be shipped by the supplier. Represents the earliest earliest ship date of all the items on the order.

The date after which the items on the purchase order can not be shipped by the supplier. Represents the greatest latest ship date of all the items on the order.

Contains the date when the order is closed.

Indicator identifying the sales terms for the order. These terms specify when payment is due and if any discounts exist for early payment.

Indicator that references what freight terms are related to the order.

Indicates where the order originated. Valid values include: 0 - Current System Generated (used by automatic replenishment), 1 - Past System Generated, 2 - Manual, 3 - Buyer Worksheet, 4 - Consignment Sales Generated PO, 5 - Vendor Generated, 6 - AIP Generated PO, 7 - SIM Generated PO, 8 - Allocation Generated PO, 9 - Consignment Transfer Generated PO, 10 - Consignment Ownership Generated PO. Values are defined by code_type 'OROR'.

Indicates how the purchase order will be paid. Valid options are LC (Letter of Credit), WT (Wire Transfer), OA (Open Account).

This field contains the type of backhaul allowance that will be applied to the order. Some examples are Calculated or Flat rate

This field will contain the backhaul allowance value.

The method used to ship the items on the purchase order from the country of origin to the country of import. Valid values include 10 (Vessel, Non-container), 11 (Vessel, Container), 12 (Border Water-borne (Only Mexico and Canada)), 20 (Rail, Non-container), 21 (Rail, Container), 30 (Truck, Non-container), 31 (Truck, Container), 32 (Auto), 33 (Pedestrian), 34 (Road, other, includes foot and animal borne), 40 (Air, Non-container), 41 (Air, Container), 50 (Mail), 60 (Passenger, Hand carried), 70 (Fixed Transportation Installation), 80 (Not used at this time).

Indicates whats included in the suppliers cost of the item. Valid values include C (Cost), CI (Cost and Insurance), CIF (Cost, Insurance and Freight), FOB (Free on Board).

W - Worksheet Oracle Retail target column STATUS on ORDHEAD.

Contains the date that the order was originally approved.

Indicates where the order was approved. It will be the user ID of the person approving the order for all orders manually approved on-line and will contain Replen for orders automatically approved in the replenishment process.

Code indicating the payment terms for freight charges associated with the order. Valid values include: CC - Collect CF - Collect Freight Credited Back to Customer DF - Defined by Buyer and Seller MX - Mixed PC - Prepaid but Charged to Customer PO - Prepaid Only PP - Prepaid by Seller.

Contains the code indicating the type of the location that is responsible for the transportation of the order.

User entered field describing the code for the location responsible for the transportation of the order.

Indicator used to determine where the title for goods is passed from the vendor to the purchaser. Examples include city, factory, or origin.

User entered field describing the code where the title of the merchandise is to be passed. Could be a city name, factory name, or place of origin.

This field indicates whether or not the order has been sent via EDI. This field can only contain a Y if the EDI_PO_IND = Y.

Indicates whether or not the order will be transmitted to the supplier via an Electronic Data Exchange transaction. Valid values are: Y = Submit via EDI N = Do not use EDI

Indicates if the purchase order is an import order. Valid values are Y (Yes) and N (No).

The identifier of the country into which the items on the order are being imported.

Indicates that a buyer generated purchase order has been acknowledged by the vendor with a separate EDI transaction.

Indicator to determine if the order should be included in on-order calculations. Valid values include Yes (include the order in the on-order calculations), No (do not include the order in the on-order calculations).

Contains the vendors unique identifying number for an order. These orders may have originated by the vendor through the EDI process or this number can be associated to a Oracle Retail order when the order is created on-line.

The exchange rate used for converting between the order currency and currency of the locations in the order. It is provided when the order and location currencies are different.

The factory at which the items on the purchase order are made. This field is only available when the system is running Import functionality.

The agent that is used in the purchase of the items on the purchase order. This field is only available when the system is running Import functionality.

The port at which the items on the purchase order will enter the country of import. This field is only available when the system is running Import functionality.

The port from which the items on the purchase order are shipped. This field is only available when the system is running Import functionality.

The number of the contract with a shipper that will give specific freight rates. This field is only available when the system is running Import functionality.

Contains the value associated with the PO_TYPE for the order.

This field indicated whether or not a supplier has agreed to break an order into separate boxes so that the boxes can be sent directly to stores.

Contains the currency code for the order. When creating an order within Oracle Retail, this field will always default to the currency of the supplier, but it can be overwritten.

Contains a code for the reason why the order was rejected during the automatic replenishment approval process. Valid values include: VM (Vendor minimum not met), NC (Negative cost calculated on an item), UOM (UOM convert error due to incomplete data).

This is an optional field which contains the contract number associated with this order.

Contains the revision number (rev_no) of the last version of the order that was sent to the supplier. The revision is held on the order revisions tables (ordhead_rev, ordsku_rev, ordloc_rev, and alloc_rev) and can be identified where the rev_no = last_sent_rev_no and origin_ind = V (version rather than revision).

This column will store the original order number from which the split orders were generated from. It will be for references purposes only. The purpose is to allow users a means of grouping orders that were split from an original super order. The original order, once split, will however be removed from the system.

Contains the location at which the order will be picked up, if the order is a Pickup order.

Contains the reference number of the Pickup order.

Contains the date when the order can be picked up from the Supplier. This field is only required if the Purchase Type of the order is Pickup.

This column will hold the date and time of the receiving appointment at the warehouse.

Any miscellaneous comments attached to the purchase order.

Partner 1 Type Oracle Retail target column PARTNER_TYPE_1 on ORDHEAD.

Additional Partner 1 Oracle Retail target column PARTNER1 on ORDHEAD.

Partner 2 Type Oracle Retail target column PARTNER_TYPE_2 on ORDHEAD.

Additional Partner 2 Oracle Retail target column PARTNER2 on ORDHEAD.

Partner 3 Type Oracle Retail target column PARTNER_TYPE_3 on ORDHEAD.

Additional Partner 3 Oracle Retail target column PARTNER3 on ORDHEAD.

Optional item used to restrict a purchase order of a specific item, in the same way location is used. No need for FK on this field, so will not impact purging (as for location).

Valid values are IMporter and EXporter. This is the default importer/exporter assigned to the supplier of the Puchase order.

This identifies the importer/exporter assigned to the supplier. This should reference the WH.WH folumn with foreign key created.

This column will hold the clearing zone id.

This is the default routing location for the import order. FK on OUTLOC.OUTLOC_ID.

This field holds the supplier / supplier site from where the goods are delivered.

When the value is Y , this field ensures that the order supplier and the delivery supplier are different.

This column contains the franchise order number for which the purchase order was created.

This column holds the user ID of the user who created the record.

This column holds the record creation date.

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.

Holds the user-id of the user who most recently updated this record. This field is required by the database.

Holds the date time stamp of the most recent update by the last_update_id. This field is required by the database.

This column contains a sequence generated key for each customer order.

Indicates the currency against which the exchange rate has been captured on the entity. Valid values are: P (Primary) or L (Local) currency.

Indicates the store review status for the orders.Valid values are: 'PEN' - Pending, 'COMP' - Complete, 'EXP' - Expired, defined in code detail with code type 'STRS'.