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 that uniquely identifies 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 |
9 |
Yes |
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. |
order_type_desc |
varchar2250 |
1 |
1 |
Not used in RWMS. |
order_types |
order_types_desc |
null |
null |
Yes |
The description for the given 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 will be Null for orders involving 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 vendor number 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 or not quality control will be 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 the order amount should be placed into. |
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 |
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. |
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 can not be shipped by the supplier. Represents the greatest 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 |
Indicates the Alphanumeric representation of Term Name which acts as the Term code in Oracle Financials. |
freight_terms |
varchar230 |
0 |
1 |
Description is not available. |
ordhead |
freight_terms |
varchar2 |
30 |
No |
Indicator that references what freight terms are 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 or not 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), 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, '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 that will be applied to the order. Some examples are 'C'alculated or 'F'lat rate |
backhaul_type_desc |
varchar240 |
0 |
1 |
Not used in RWMS. |
code_detail |
code_desc |
varchar2 |
40 |
No |
The description for the given backhaul type. |
backhaul_allowance |
number20_4 |
0 |
1 |
Not used in RWMS. |
ordhead |
backhaul_allowance |
number |
20 |
No |
This field will contain 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 of the given 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'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). |
purchase_type_desc |
varchar240 |
0 |
1 |
Description is not available. |
code_detail |
code_desc |
varchar2 |
40 |
No |
Contains the description of the given 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 include 'W' - Worksheet, 'S' - Submitted, 'A' - Approved, '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 |
null |
No |
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. |
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 that is 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 of the given 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 include city, factory, or origin. |
fob_title_pass_code_desc |
varchar240 |
0 |
1 |
Not used in RWMS. |
code_detail |
code_desc |
varchar2 |
40 |
No |
Contains the description of the given 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. 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 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. |
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 only available 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 given 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 only available 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 given 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 only available 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 given 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 only available 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 given 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 will be stored on 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 only available 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 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. |
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 within Retek, this field will always default 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 of 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 only required 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 will hold 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 |
Any 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
|