Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For PODesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
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 |
null |
Yes |
Indicates the type of document this message is for. Valid value is P for purchase order. |
order_no |
varchar210 |
1 |
1 |
Description is not available. |
ordhead |
order_no |
varchar2 |
10 |
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 |
|
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 |
Not used in RWMS. |
order_types |
order_types_desc |
null |
null |
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 |
Description is not available. |
ordhead |
buyer |
number |
4 |
No |
Contains the number associated with the buyer for the order. |
buyer_name |
varchar2120 |
0 |
1 |
Description is not available. |
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 |
varchar2 |
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 |
null |
null |
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 |
Description is not available. |
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 |
Description is not available. |
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 |
Not used in RWMS. |
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. |
ordhead |
cust_order |
varchar2 |
1 |
Yes |
This field indicates whether the order is generated for a customer. |
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 |
varchar240 |
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_desc |
varchar2 |
40 |
No |
Indicates how the purchase order will be paid. Valid options are LC (letter of credit), WT (wire transfer), and OA (open account). |
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 |
varchar240 |
0 |
1 |
Not used in RWMS. |
code_detail |
code_desc |
varchar2 |
40 |
No |
The description of the backhaul type. |
backhaul_allowance |
number20_4 |
0 |
1 |
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 |
varchar240 |
0 |
1 |
Description is not available. |
code_detail |
code_desc |
varchar2 |
40 |
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 |
varchar240 |
0 |
1 |
Description is not available. |
code_detail |
code_desc |
varchar2 |
40 |
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 |
null |
null |
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 |
null |
|
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 |
varchar240 |
0 |
1 |
Not used in RWMS. |
code_detail |
code_desc |
null |
null |
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_desc |
varchar2 |
2 |
No |
Contains the code indicating the type of the location responsible for the transportation of the order. |
fob_trans_res_code_desc |
varchar240 |
0 |
1 |
Not used in RWMS. |
code_detail |
code_desc |
varchar2 |
40 |
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 |
varchar240 |
0 |
1 |
Not used in RWMS. |
code_detail |
code_desc |
varchar2 |
40 |
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 |
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 |
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 |
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 |
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 |
Description is not available. |
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 |
Not used in RWMS. |
ordhead |
contract_no |
null |
null |
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 |
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 |
Description is not available. |
ordhead |
comment_desc |
varchar2 |
2000 |
No |
Miscellaneous comments attached to the purchase order. |
PODtl
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
ExtOfPODesc:ExtOfPODesc
|
*
|
0
|
1
|
Provide an extension hook to customize PODesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
LocOfPODesc:LocOfPODesc
|
*
|
0
|
1
|
Provide an extension hook to localize PODesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|