This is root element of this document which contains name space definitions for the document elements.
Description is not available.
This field contains the type of location in the location field. Valid values are S - Physical Store, V - Virtual Store, 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 total number of items ordered for the SKU to this location.
Description is not available.
Description is not available.
Unique alphanumeric value to identify the reference item. Not used in RWMS.
This field contains the type of location in the location field. Valid values are 'S' -Store, 'W' -Warehouse
This field contains the actual physical location that item will be ordered to. This field may contain a store or a physical warehouse.
Indicates the store type of the physical_location store. Only populated if physical_location_type is 'S'.
Valid values are: 'C' = company store, 'F' = franchise store.
Indicates if the physical_location store is stock-holding or not. Only populated if physical_location_type is 'S'.
Valid values are: 'Y' = yes, 'N' = no.
Description is not available.
Holds the original transaction unit of measure to
be passed on to the store system. It is only used for customer direct
orders coming from the order management system. All quantities on the
payload are expressed in item.s standard unit of measure.
This field contains the unit cost for the Item/Location on the order, including discounts (deal/bracket/allowance), but not landed cost components. This field is stored in order currency.
The identifier of the country into which the items on the order are being imported.
Supplier pack size for this order/item. Description is not available.
The date before which the item can not be shipped by the supplier.
The date after which the item can not be shipped by the supplier.
Contains the location at which the order will be picked up, if the order is a 'Pickup' order.
Not used in RWMS.
This field indicates whether the packing method of the item in the container is flat or hanging. Valid values for this field are stored in the 'PKMT' code.
This column will be used to determine how order quantities will be rounded to Case, Layer and Pallet.
Not used by RMS.
Not used by RMS.
Not used by RMS.
Not used by RMS.
Not used by RMS.
A reference number to link the item on the transfer to any purchase orders that have been created to allow the from location (ie warehouse) on the transfer to fulfill the transfer quantity to the to location (ie store) on the transfer.
Description is not available.
Indicates the basis for the cost of the Item/Location on the order. Valid values include 'NORM' - Normal Supplier Cost, 'DEAL' - Cost Based on a Deal, 'BRKT' - Cost Based on a Bracket, 'MANL' - User Specified or Manual Override Cost, 'CONT' - Costs retrieved from the Contract, 'ALLW' - Cost Based on an Allowance
Date that the item on the PO is expected to be available to ship from the PO location to another location.
Description is not available.
Indicates the type of document this message is for. Valid value is 'P' for purchase order.
Contains the number to uniquely identify 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.
The description for the order type. Not used in RWMS.
Contains the department number for orders limited to a single department and will be Null for orders involving items in more than one department.
Not used in RWMS.
Contains the number associated with the buyer for the order.
Contains the name of the authorized buyer.
Contains the vendor number who will provide the merchandise specified in the order.
Contains the ad number associated with the order to provide a link between the order dialog and the promotions dialog.
Contains a description of the promotion. This value comes from RPM.
Determines whether or not quality control will be required when items for this order are received. Valid values are 'Y' and 'N'.
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.
Indicates the Alphanumeric representation of Term Name which acts as the Term code in Oracle Financials.
Description is not available.
This field indicates whether or not the order is generated for a customer.
Indicates how the purchase order will be paid. Valid options are LC (Letter of Credit), WT (Wire Transfer), OA (Open Account).
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 'C'alculated or 'F'lat rate
The description of the backhaul type. Not used in RWMS.
This field contains the backhaul allowance value. Not used in RWMS.
The method used to ship the items on the purchase order from the country of origin to the country of import.
Contains the description for the shipping method.
Indicates what's included in the supplier's cost of the item. Valid values include C (Cost), CI (Cost and Insurance), CIF (Cost, Insurance and Freight), FOB (Free on Board).
Contains the description for the purchase type.
Indicates the current status of the order. Valid values include 'W' - Worksheet, 'S' - Submitted, 'A' - Approved, 'C' - Closed
Code indicating the payment terms for freight charges associated with the order. Valid values inlude: '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 description of the given shipment payment method. Not used in RWMS.
Contains the code indicating the type of the location that is responsible for the transportation of the order.
Not used in RWMS.
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.
Contains the description for fob_title_pass_code. Not used in RWMS.
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.
Contains the vendor's 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 Retek order when the order is created on-line.
The rate of exchange used for the purchase order between the order and primary currencies.
The factory at which the items on the purchase order are made. This field is only available when the system is running Import functionality.
Contains the description of the factory. Not used in RWMS.
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.
Not used in RWMS.
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.
Contains the description of the discharge port. Not used in RWMS.
The port from which the items on the purchase order are shipped. This field is only available when the system is running Import functionality.
Contains the description of the lading port. Not used in RWMS.
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. Not used in RWMS.
Contains a description for the specific PO_TYPE.
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 Retek, this field will always default to the currency of the supplier, but it can be overwritten.
Contains the contract number associated with this order. Not used in RWMS.
Contains the location at which the order will be picked up, if the order is a 'Pickup' order.
Contains the reference number for the Pickup order. Not used in RWMS.
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.
Miscellaneous comments attached to the purchase order.
This field holds the master customer order number from OMS.
This field holds the number from OMS related to the fulfillment details.
One or more fulfillment orders could relate back to a single customer order in OMS.
Description is not available.
This type can hold a number of digits count 12 and fraction digit count of 4.
This type can hold a number of digits count 20 and fraction digit count of 10.
This type can hold a string of max length of 25 characters.
This type can hold a string of max length of 250 characters.
This type can hold a string of max length of 5 characters.
This type can hold a string of max length of 10 characters.
This type can hold a string of max length of 160 characters.
This type can hold a string of max length of 2 characters.
This type can hold a number of digits count 4.
This type can hold a string of max length of 2000 characters.
This type can hold a string of max length of 30 characters.
This type can hold a number of digits count 6.
This type can hold a string of max length of 3 characters.
This type can hold a string of max length of 120 characters.
This type can hold a string of max length of 15 characters.
This type can hold a string of max length of 6 characters.
This type can hold a string of max length of 4 characters.
This type can hold a string of max length of 40 characters.
This type can hold a string of max length of 45 characters.
This type can hold a number of digits count 20.
This type can hold a number of digits count 20 and fraction digit count of 4.
This type can hold a string of max length of 50 characters.
This type can hold a number of digits count 10.
This type can hold a number of digits count 1.
This type can hold a string of max length of 1 characters.
This type can hold a string of max length of 150 characters.
This type can hold a string of max length of 240 characters.
This type can hold a string of max length of 9 characters.
This type can hold a string of max length of 12 characters.
This type can hold a string of max length of 48 characters.
This type can hold a number of digits count 12.