XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for PODesc in RMS application. |
RMS's Table Name |
RMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RMS's Column Length |
Is Column Required in RMS's API? |
RMS's API Description |
doc_type |
varchar21 |
1 |
1 |
Indicates the type of document this message is for. Valid value is 'P' for purchase order. |
n/a |
n/a |
null |
1 |
Yes |
Indicates the type of document this message is for. Valid value is P for purchase order. |
order_no |
varchar212 |
1 |
1 |
Contains the number to uniquely identify an order within the system. |
ordhead |
order_no |
varchar2 |
12 |
Yes |
Contains the number to uniquely identify an order within the system. |
order_type |
varchar29 |
1 |
1 |
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. |
ordhead |
order_type |
varchar2 |
3 |
Yes |
Indicates the type of order and the Open To Buy bucket that will be updated. Valid values include N/B (non basic), ARB (automatic reorder of basic), and BRB (buyer reorder of basic). |
order_type_desc |
varchar2250 |
1 |
1 |
The description for the order type. Not used in RWMS. |
order_types |
order_types_desc |
Varchar2 |
250 |
Yes |
The description for the order type. |
dept |
number4 |
0 |
1 |
Contains the department number for orders limited to a single department and will be Null for orders involving items in more than one department. |
ordhead |
dept |
number |
4 |
No |
Contains the department number for orders limited to a single department and is null for orders including items in more than one department. |
dept_name |
varchar2120 |
0 |
1 |
Not used in RWMS. |
deps |
dept_name |
varchar2 |
120 |
No |
Contains the name of the department. |
buyer |
number4 |
0 |
1 |
Contains the number associated with the buyer for the order. |
ordhead |
buyer |
number |
4 |
No |
Contains the number associated with the buyer for the order. |
buyer_name |
varchar2120 |
0 |
1 |
Contains the name of the authorized buyer. |
buyer |
buyer_name |
varchar2 |
120 |
No |
Contains the name of the authorized buyer. |
supplier |
varchar210 |
1 |
1 |
Contains the vendor number who will provide the merchandise specified in the order. |
ordhead |
supplier |
Number |
10 |
Yes |
Contains the number for the vendor who will provide the merchandise specified in the order. |
promotion |
number10 |
0 |
1 |
Contains the ad number associated with the order to provide a link between the order dialog and the promotions dialog. |
ordhead |
promotion |
number |
10 |
No |
Contains the ad number associated with the order to provide a link between the order dialog and the promotions dialog. |
prom_desc |
varchar2160 |
0 |
1 |
Contains a description of the promotion. This value comes from RPM. |
rpm_promo |
description |
Varchar2 |
640 |
Yes |
Contains a description of the promotion. This value comes from RPM. |
qc_ind |
varchar21 |
1 |
1 |
Determines whether or not quality control will be required when items for this order are received. Valid values are 'Y' and 'N'. |
ordhead |
qc_ind |
varchar2 |
1 |
Yes |
Determines whether quality control is required when items for this order are received. Valid values are Y and N. |
not_before_date |
xs:dateTime |
0 |
1 |
Contains the first date that delivery of the order will be accepted. |
ordhead |
not_before_date |
RIBDate |
* |
No |
Contains the first date that delivery of the order will be accepted. |
not_after_date |
xs:dateTime |
0 |
1 |
Contains the last date that delivery of the order will be accepted. |
ordhead |
not_after_date |
RIBDate |
* |
No |
Contains the last date that delivery of the order will be accepted. |
otb_eow_date |
xs:dateTime |
0 |
1 |
This field contains the OTB budget bucket the order amount should be placed into. |
ordhead |
otb_eow_date |
RIBDate |
* |
No |
This field contains the OTB budget bucket into which the order amount should be placed. |
earliest_ship_date |
xs:dateTime |
0 |
1 |
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. |
ordhead |
earliest_ship_date |
RIBDate |
* |
No |
Represents the earliest earliest ship date of all the items on the order. |
latest_ship_date |
xs:dateTime |
0 |
1 |
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. |
ordhead |
latest_ship_date |
RIBDate |
* |
No |
The date after which the items on the purchase order cannot be shipped by the supplier. Represents the latest ship date of all the items on the order. |
close_date |
xs:dateTime |
0 |
1 |
Contains the date when the order is closed. |
ordhead |
close_date |
RIBDate |
* |
No |
Contains the date when the order is closed. |
terms |
varchar215 |
1 |
1 |
Indicator identifying the sales terms for the order. These terms specify when payment is due and if any discounts exist for early payment. |
ordhead |
terms |
varchar2 |
15 |
Yes |
Indicator identifying the sales terms for the order. These terms specify when payment is due and if any discounts exist for early payment. |
terms_code |
varchar250 |
1 |
1 |
Indicates the Alphanumeric representation of Term Name which acts as the Term code in Oracle Financials. |
terms |
terms_code |
varchar2 |
50 |
Yes |
The alphanumeric representation of Term Name, which acts as the Term Code in Oracle financials applications. |
freight_terms |
varchar230 |
0 |
1 |
Description is not available. |
ordhead |
freight_terms |
varchar2 |
30 |
No |
Indicator that references the freight terms related to the order. |
cust_order |
varchar21 |
1 |
1 |
This field indicates whether or not the order is generated for a customer. |
n/a |
n/a |
n/a |
n/a |
No |
n/a |
payment_method |
varchar26 |
0 |
1 |
Indicates how the purchase order will be paid. Valid options are LC (Letter of Credit), WT (Wire Transfer), OA (Open Account). |
ordhead |
payment_method |
varchar2 |
6 |
No |
Indicates how the purchase order will be paid. Valid options are LC (letter of credit), WT (wire transfer), and OA (Open Account). |
payment_method_desc |
varchar2250 |
0 |
1 |
Indicates how the purchase order will be paid. Valid options are 'LC' - Letter of Credit, 'WT' - Wire Transfer, 'OA' - Open Account. |
code_detail |
code_desc |
varchar2 |
250 |
No |
Contains payment method desc. |
backhaul_type |
varchar26 |
0 |
1 |
This field contains the type of backhaul allowance that will be applied to the order. Some examples are 'C'alculated or 'F'lat rate |
ordhead |
backhaul_type |
varchar2 |
6 |
No |
This field contains the type of backhaul allowance applied to the order, for example, C (calculated) or F (flat) rate. |
backhaul_type_desc |
varchar2250 |
0 |
1 |
The description of the backhaul type. Not used in RWMS. |
code_detail |
code_desc |
varchar2 |
250 |
No |
The description of the backhaul type. |
backhaul_allowance |
number20_4 |
0 |
1 |
This field contains the backhaul allowance value. Not used in RWMS. |
ordhead |
backhaul_allowance |
number |
20 |
No |
This field contains the backhaul allowance value. |
ship_method |
varchar26 |
0 |
1 |
The method used to ship the items on the purchase order from the country of origin to the country of import. |
ordhead |
ship_method |
varchar2 |
6 |
No |
The method used to ship the items on the purchase order from the country of origin to the country of import. |
ship_method_desc |
varchar2250 |
0 |
1 |
Contains the description for the shipping method. |
code_detail |
code_desc |
varchar2 |
250 |
No |
Contains the description for the shipping method. |
purchase_type |
varchar26 |
0 |
1 |
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). |
ordhead |
purchase_type |
varchar2 |
6 |
No |
Indicates what is included in the supplier's cost of the item. Valid values include C (cost), CI (cost and insurance), CIF (cost, insurance, and freight), and FOB (free on board). |
purchase_type_desc |
varchar2250 |
0 |
1 |
Contains the description for the purchase type. |
code_detail |
code_desc |
varchar2 |
250 |
No |
Contains the description for the purchase type. |
status |
varchar21 |
1 |
1 |
Indicates the current status of the order. Valid values include 'W' - Worksheet, 'S' - Submitted, 'A' - Approved, 'C' - Closed |
ordhead |
status |
Varchar2 |
1 |
Yes |
Indicates the current status of the order. Valid values are W (worksheet), S (submitted), A (approved), and C (closed). |
ship_pay_method |
varchar22 |
0 |
1 |
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. |
ordhead |
ship_pay_method |
Varchar2 |
2 |
No |
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), and PP (prepaid by seller). |
ship_pay_method_desc |
varchar2250 |
0 |
1 |
Contains the description of the given shipment payment method. Not used in RWMS. |
code_detail |
code_desc |
Varchar2 |
250 |
No |
Contains the description of the given shipment payment method. |
fob_trans_res |
varchar22 |
0 |
1 |
Contains the code indicating the type of the location that is responsible for the transportation of the order. |
ordhead |
fob_trans_res |
varchar2 |
2 |
No |
Contains the code indicating the type of the location responsible for the transportation of the order. |
fob_trans_res_code_desc |
varchar2250 |
0 |
1 |
Not used in RWMS. |
code_detail |
code_desc |
varchar2 |
250 |
No |
Contains the description for fob_trans_res_code. |
fob_trans_res_desc |
varchar2250 |
0 |
1 |
User entered field describing the code for the location responsible for the transportation of the order. |
ordhead |
fob_trans_res_desc |
varchar2 |
250 |
No |
User entered field describing the code for the location responsible for the transportation of the order. |
fob_title_pass |
varchar22 |
0 |
1 |
Indicator used to determine where the title for goods is passed from the vendor to the purchaser. Examples include city, factory, or origin. |
ordhead |
fob_title_pass |
varchar2 |
2 |
No |
Indicator used to determine where the title for goods is passed from the vendor to the purchaser. Examples are city, factory, and origin. |
fob_title_pass_code_desc |
varchar2250 |
0 |
1 |
Contains the description for fob_title_pass_code. Not used in RWMS. |
code_detail |
code_desc |
varchar2 |
250 |
No |
Contains the description for fob_title_pass_code. |
fob_title_pass_desc |
varchar2250 |
0 |
1 |
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. |
ordhead |
fob_title_pass_desc |
varchar2 |
250 |
No |
User entered field describing the code where the title of the merchandise is to be passed. This could be a city name, factory name, or place of origin. |
vendor_order_no |
varchar215 |
0 |
1 |
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. |
ordhead |
vendor_order_no |
varchar2 |
15 |
No |
Contains the vendor's unique number to identify the order. The vendor may have originated the order through the EDI process, or this number can be associated to an Oracle Retail order when the order is created online. |
exchange_rate |
number20_10 |
0 |
1 |
The rate of exchange used for the purchase order between the order and primary currencies. |
ordhead |
exchange_rate |
number |
20 |
No |
The rate of exchange used for the purchase order between the order and primary currencies. |
factory |
varchar210 |
0 |
1 |
The factory at which the items on the purchase order are made. This field is only available when the system is running Import functionality. |
ordhead |
factory |
varchar2 |
10 |
No |
The factory at which the items on the purchase order are made. This field is available only when the system is running Import functionality. |
factory_desc |
varchar2240 |
0 |
1 |
Contains the description of the factory. Not used in RWMS. |
partner |
partner_desc |
varchar2 |
240 |
No |
Contains the description of the factory. |
agent |
varchar210 |
0 |
1 |
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. |
ordhead |
agent |
varchar2 |
10 |
No |
The agent that is used in the purchase of the items on the purchase order. This field is available only when the system is running Import functionality. |
agent_desc |
varchar2240 |
0 |
1 |
Not used in RWMS. |
partner |
partner_desc |
varchar2 |
240 |
No |
Contains the description of the partner. |
discharge_port |
varchar25 |
0 |
1 |
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. |
ordhead |
discharge_port |
varchar2 |
5 |
No |
The port at which the items on the purchase order will enter the country of import. This field is available only when the system is running Import functionality. |
discharge_port_desc |
varchar2150 |
0 |
1 |
Contains the description of the discharge port. Not used in RWMS. |
outloc |
outloc_desc |
varchar2 |
150 |
No |
Contains the description of the discharge port. |
lading_port |
varchar25 |
0 |
1 |
The port from which the items on the purchase order are shipped. This field is only available when the system is running Import functionality. |
ordhead |
lading_port |
varchar2 |
5 |
No |
The port from which the items on the purchase order are shipped. This field is available only when the system is running Import functionality. |
lading_port_desc |
varchar2150 |
0 |
1 |
Contains the description of the lading port. Not used in RWMS. |
outloc |
outloc_desc |
varchar2 |
150 |
No |
Contains the description of the lading port. |
bill_to_id |
varchar25 |
0 |
1 |
Indicates the ID of the bill-to-address, which will be stored on the OUTLOC table under the outloc_type 'BT'. |
ordhead |
bill_to_id |
varchar2 |
5 |
No |
Indicates the ID of the bill-to-address, which is stored in the OUTLOC table under the outloc_type BT. |
freight_contract_no |
varchar210 |
0 |
1 |
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. |
ordhead |
freight_contract_no |
varchar2 |
10 |
No |
The number of the contract with a shipper that will give specific freight rates. This field is available only when the system is running Import functionality. |
po_type |
varchar24 |
0 |
1 |
Contains the value associated with the PO_TYPE for the order. Not used in RWMS. |
ordhead |
po_type |
varchar2 |
4 |
No |
Contains the value associated with the PO_TYPE for the order. |
po_type_desc |
varchar2120 |
0 |
1 |
Contains a description for the specific PO_TYPE. |
po_type |
po_type_desc |
varchar2 |
120 |
No |
Contains a description for the specific PO_TYPE. |
pre_mark_ind |
varchar21 |
1 |
1 |
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. |
ordhead |
pre_mark_ind |
varchar2 |
1 |
Yes |
This field indicates whether a supplier has agreed to break an order into separate boxes so that the boxes can be sent directly to stores. |
currency_code |
varchar23 |
1 |
1 |
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. |
ordhead |
currency_code |
varchar2 |
3 |
Yes |
Contains the currency code for the order. When creating an order, this field always defaults to the currency of the supplier, but it can be overwritten. |
contract_no |
number6 |
0 |
1 |
Contains the contract number associated with this order. Not used in RWMS. |
ordhead |
contract_no |
Number |
6 |
No |
Contains the contract number associated with this order. |
pickup_loc |
varchar2250 |
0 |
1 |
Contains the location at which the order will be picked up, if the order is a 'Pickup' order. |
ordhead |
pickup_loc |
varchar2 |
250 |
No |
Contains the location at which the order will be picked up, if the order is a Pickup order. |
pickup_no |
varchar225 |
0 |
1 |
Contains the reference number for the Pickup order. Not used in RWMS. |
ordhead |
pickup_no |
varchar2 |
25 |
No |
Contains the reference number for the Pickup order. |
pickup_date |
xs:dateTime |
0 |
1 |
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'. |
ordhead |
pickup_date |
RIBDate |
* |
No |
Contains the date when the order can be picked up from the supplier. This field is required only if the purchase type of the order is Pickup. |
app_datetime |
xs:dateTime |
0 |
1 |
This column will hold the date and time of the receiving appointment at the warehouse. |
ordhead |
app_datetime |
RIBDate |
* |
No |
This column contains the date and time of the receiving appointment at the warehouse. |
comment_desc |
varchar22000 |
0 |
1 |
Miscellaneous comments attached to the purchase order. |
ordhead |
comment_desc |
varchar2 |
2000 |
No |
Miscellaneous comments attached to the purchase order. |
cust_order_nbr |
varchar248 |
0 |
1 |
This field holds the master customer order number from OMS. |
ordcust |
customer_order_no |
varchar2 |
48 |
No |
This column contains the master customer order number from the Order Management System. |
fulfill_order_nbr |
varchar248 |
0 |
1 |
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. |
ordcust |
fulfill_order_no |
varchar2 |
48 |
No |
This contains the number from OMS related to the fulfillment details. One or more fulfillment orders could relate back to a single customer order in OMS. |
PODtl
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|