XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for PODesc in RWMS application. |
RWMS's Table Name |
RWMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RWMS's Column Length |
Is Column Required in RWMS's API? |
RWMS's API Description |
doc_type |
varchar21 |
1 |
1 |
Indicates the type of document this message is for. Valid value is 'P' for purchase order. |
po |
doc_type |
varchar2 |
1 |
No |
Populates doc_type in PO table. Uses default of "P" if value is null. |
order_no |
varchar212 |
1 |
1 |
Contains the number to uniquely identify an order within the system. |
po |
po_nbr |
varchar2 |
12 |
Yes |
Unique Purchase Order identifier. |
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. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
order_type_desc |
varchar2250 |
1 |
1 |
The description for the order type. Not used in RWMS. |
n/a |
n/a |
varchar2 |
250 |
Yes |
Not used by RWMS. |
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. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
dept_name |
varchar2120 |
0 |
1 |
Not used in RWMS. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
buyer |
number4 |
0 |
1 |
Contains the number associated with the buyer for the order. |
n/a |
n/a |
* |
* |
No |
Not used in RWMS |
buyer_name |
varchar2120 |
0 |
1 |
Contains the name of the authorized buyer. |
po |
buyer_code |
varchar2 |
120 |
No |
A code representing the originator of a PO. |
supplier |
varchar210 |
1 |
1 |
Contains the vendor number who will provide the merchandise specified in the order. |
po |
vendor_nbr |
varchar2 |
10 |
Yes |
An identifier that uniquely identifies a vendor. |
promotion |
number10 |
0 |
1 |
Contains the ad number associated with the order to provide a link between the order dialog and the promotions dialog. |
n/a |
n/a |
number |
10 |
No |
Not used by RWMS. |
prom_desc |
varchar2160 |
0 |
1 |
Contains a description of the promotion. This value comes from RPM. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
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'. |
n/a |
n/a |
* |
* |
Yes |
Not used by RWMS. |
not_before_date |
xs:dateTime |
0 |
1 |
Contains the first date that delivery of the order will be accepted. |
po |
deliv_not_before_date |
RIBDate |
* |
No |
Date before which PO should not be accepted |
not_after_date |
xs:dateTime |
0 |
1 |
Contains the last date that delivery of the order will be accepted. |
po |
deliv_not_after_date |
RIBDate |
* |
No |
The latest date on which the delivery of an order is to be made. |
otb_eow_date |
xs:dateTime |
0 |
1 |
This field contains the OTB budget bucket the order amount should be placed into. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
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. |
n/a |
n/a |
RIBDate |
* |
No |
Not used by RWMS. |
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. |
n/a |
n/a |
RIBDate |
* |
No |
Not used by RWMS. |
close_date |
xs:dateTime |
0 |
1 |
Contains the date when the order is closed. |
n/a |
n/a |
RIBDate |
* |
No |
Not used by RWMS. |
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. |
n/a |
n/a |
* |
* |
Yes |
Not used by RWMS. |
terms_code |
varchar250 |
1 |
1 |
Indicates the Alphanumeric representation of Term Name which acts as the Term code in Oracle Financials. |
n/a |
n/a |
* |
* |
Yes |
Not used by RWMS. |
freight_terms |
varchar230 |
0 |
1 |
Description is not available. |
po |
shipping_terms |
varchar2 |
30 |
No |
Populate shipping_terms in PO table. A user defined code. |
cust_order |
varchar21 |
1 |
1 |
This field indicates whether or not the order is generated for a customer. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
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). |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
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. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
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 |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
backhaul_type_desc |
varchar2250 |
0 |
1 |
The description of the backhaul type. Not used in RWMS. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
backhaul_allowance |
number20_4 |
0 |
1 |
This field contains the backhaul allowance value. Not used in RWMS. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
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. |
po |
transportation_mode |
varchar2 |
120 |
No |
Transportation mode the po is on. |
ship_method_desc |
varchar2250 |
0 |
1 |
Contains the description for the shipping method. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
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). |
n/a |
n/a |
* |
* |
No |
Not used by RWMS |
purchase_type_desc |
varchar2250 |
0 |
1 |
Contains the description for the purchase type. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS |
status |
varchar21 |
1 |
1 |
Indicates the current status of the order. Valid values include 'W' - Worksheet, 'S' - Submitted, 'A' - Approved, 'C' - Closed |
po |
status |
varchar2 |
1 |
No |
Populates status in PO table. Uses default of "A" if value is not available. |
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. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
ship_pay_method_desc |
varchar2250 |
0 |
1 |
Contains the description of the given shipment payment method. Not used in RWMS. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
fob_trans_res |
varchar22 |
0 |
1 |
Contains the code indicating the type of the location that is responsible for the transportation of the order. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
fob_trans_res_code_desc |
varchar2250 |
0 |
1 |
Not used in RWMS. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
fob_trans_res_desc |
varchar2250 |
0 |
1 |
User entered field describing the code for the location responsible for the transportation of the order. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
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. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
fob_title_pass_code_desc |
varchar2250 |
0 |
1 |
Contains the description for fob_title_pass_code. Not used in RWMS. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
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. |
n/a |
n/a |
|
|
No |
Not used by RWMS. |
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. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
exchange_rate |
number20_10 |
0 |
1 |
The rate of exchange used for the purchase order between the order and primary currencies. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
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. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
factory_desc |
varchar2240 |
0 |
1 |
Contains the description of the factory. Not used in RWMS. |
n/a |
n/a |
|
|
No |
Not used by RWMS. |
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. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
agent_desc |
varchar2240 |
0 |
1 |
Not used in RWMS. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
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. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
discharge_port_desc |
varchar2150 |
0 |
1 |
Contains the description of the discharge port. Not used in RWMS. |
n/a |
n/a |
varchar2 |
150 |
No |
Not used by RWMS. |
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. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
lading_port_desc |
varchar2150 |
0 |
1 |
Contains the description of the lading port. Not used in RWMS. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
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'. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
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. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
po_type |
varchar24 |
0 |
1 |
Contains the value associated with the PO_TYPE for the order. Not used in RWMS. |
n/a |
n/a |
* |
( |
No |
Not used by RWMS. |
po_type_desc |
varchar2120 |
0 |
1 |
Contains a description for the specific PO_TYPE. |
po |
po_type |
varchar2 |
120 |
No |
Purchase Order 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. |
po |
preassigned_flag |
varchar2 |
1 |
No |
Populates preassigned_flag in PO table. Uses default of "N" if value is not available |
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. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
contract_no |
number6 |
0 |
1 |
Contains the contract number associated with this order. Not used in RWMS. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
pickup_loc |
varchar2250 |
0 |
1 |
Contains the location at which the order will be picked up, if the order is a 'Pickup' order. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
pickup_no |
varchar225 |
0 |
1 |
Contains the reference number for the Pickup order. Not used in RWMS. |
n/a |
n/a |
* |
* |
No |
Not used in RWMS. |
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'. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
app_datetime |
xs:dateTime |
0 |
1 |
This column will hold the date and time of the receiving appointment at the warehouse. |
n/a |
n/a |
RIBDate |
* |
No |
Not used by RWMS. |
comment_desc |
varchar22000 |
0 |
1 |
Miscellaneous comments attached to the purchase order. |
po |
po_comments |
varchar2 |
2000 |
No |
Populates po_comments in PO table |
cust_order_nbr |
varchar248 |
0 |
1 |
This field holds the master customer order number from OMS. |
NA |
NA |
NA |
NA |
NA |
NA |
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. |
NA |
NA |
NA |
NA |
NA |
NA |
PODtl
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|