XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for PODesc in SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
doc_type |
varchar21 |
1 |
1 |
Indicates the type of document this message is for. Valid value is 'P' for purchase order. |
|
|
|
|
No |
Not used in SIM |
order_no |
varchar212 |
1 |
1 |
Contains the number to uniquely identify an order within the system. |
PURCHASE_ORDER |
EXTERNAL_ID |
VARCHAR2 |
128 |
Yes |
Unique Identifier of the purchase order |
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. |
NA |
NA |
NA |
NA |
NA |
NA |
order_type_desc |
varchar2250 |
1 |
1 |
The description for the order type. Not used in RWMS. |
|
|
|
|
null |
Not used in SIM. |
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. |
|
|
|
|
No |
Not used in SIM |
dept_name |
varchar2120 |
0 |
1 |
Not used in RWMS. |
|
|
|
|
No |
Not used in SIM |
buyer |
number4 |
0 |
1 |
Contains the number associated with the buyer for the order. |
|
|
|
|
null |
Not used in SIM. |
buyer_name |
varchar2120 |
0 |
1 |
Contains the name of the authorized buyer. |
|
|
|
|
null |
Not used in SIM. |
supplier |
varchar210 |
1 |
1 |
Contains the vendor number who will provide the merchandise specified in the order. |
PURCHASE_ORDER |
SUPPLIER_ID |
VARCHAR2 |
128 |
Yes |
The supplier ID of the order or where the inventory will be coming from. |
promotion |
number10 |
0 |
1 |
Contains the ad number associated with the order to provide a link between the order dialog and the promotions dialog. |
|
|
|
|
null |
Not used in SIM. |
prom_desc |
varchar2160 |
0 |
1 |
Contains a description of the promotion. This value comes from RPM. |
|
|
|
|
null |
Not used in SIM. |
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'. |
|
|
|
|
null |
Not used in SIM. |
not_before_date |
xs:dateTime |
0 |
1 |
Contains the first date that delivery of the order will be accepted. |
RK_ORDERS |
NOT_BEFORE_DATE |
Date |
|
No |
The date before which the items on the purchase order can not be delivered by the supplier. |
not_after_date |
xs:dateTime |
0 |
1 |
Contains the last date that delivery of the order will be accepted. |
PURCHASE_ORDER |
NOT_AFTER_DATE |
Date |
|
No |
latest date that the inventory would arrive at the store for the order. |
otb_eow_date |
xs:dateTime |
0 |
1 |
This field contains the OTB budget bucket the order amount should be placed into. |
|
|
|
|
null |
Not used in SIM. |
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. |
|
|
|
|
null |
Not used in SIM |
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. |
|
|
|
|
null |
Not used in SIM |
close_date |
xs:dateTime |
0 |
1 |
Contains the date when the order is closed. |
PURCHASE_ORDER |
COMPLETE_DATE |
DATE |
|
No |
the date of when all items were received on the order. |
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. |
|
|
|
|
null |
Not used in SIM. |
terms_code |
varchar250 |
1 |
1 |
Indicates the Alphanumeric representation of Term Name which acts as the Term code in Oracle Financials. |
|
|
|
|
null |
Not used in SIM. |
freight_terms |
varchar230 |
0 |
1 |
Description is not available. |
|
|
|
|
null |
Not used in SIM |
cust_order |
varchar21 |
1 |
1 |
This field indicates whether or not the order is generated for a customer. |
|
|
|
|
No |
Not used in SIM |
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). |
|
|
|
|
null |
Not used in SIM. |
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. |
|
|
|
|
null |
Not used in SIM. |
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 |
|
|
|
|
null |
Not used in SIM. |
backhaul_type_desc |
varchar2250 |
0 |
1 |
The description of the backhaul type. Not used in RWMS. |
|
|
|
|
null |
Not used in SIM. |
backhaul_allowance |
number20_4 |
0 |
1 |
This field contains the backhaul allowance value. Not used in RWMS. |
|
|
|
|
null |
Not used in SIM. |
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. |
|
|
|
|
null |
Not used in SIM. |
ship_method_desc |
varchar2250 |
0 |
1 |
Contains the description for the shipping method. |
|
|
|
|
null |
Not used in SIM. |
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). |
|
|
|
|
null |
Not used in SIM. |
purchase_type_desc |
varchar2250 |
0 |
1 |
Contains the description for the purchase type. |
|
|
|
|
null |
Not used in SIM. |
status |
varchar21 |
1 |
1 |
Indicates the current status of the order. Valid values include 'W' - Worksheet, 'S' - Submitted, 'A' - Approved, 'C' - Closed |
PURCHASE_ORDER |
STATUS |
NUMBER |
4 |
Yes |
the status of the purchase order.valid values 0 = unknown 100 = approved 1000 = 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. |
|
|
|
|
null |
Not used in SIM. |
ship_pay_method_desc |
varchar2250 |
0 |
1 |
Contains the description of the given shipment payment method. Not used in RWMS. |
|
|
|
|
null |
Not used in SIM. |
fob_trans_res |
varchar22 |
0 |
1 |
Contains the code indicating the type of the location that is responsible for the transportation of the order. |
|
|
|
|
null |
Not used in SIM |
fob_trans_res_code_desc |
varchar2250 |
0 |
1 |
Not used in RWMS. |
|
|
|
|
null |
Not used in SIM |
fob_trans_res_desc |
varchar2250 |
0 |
1 |
User entered field describing the code for the location responsible for the transportation of the order. |
|
|
|
|
null |
Not used in SIM |
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. |
|
|
|
|
null |
Not used in SIM |
fob_title_pass_code_desc |
varchar2250 |
0 |
1 |
Contains the description for fob_title_pass_code. Not used in RWMS. |
|
|
|
|
null |
Not used in SIM |
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. |
|
|
|
|
null |
Not used in SIM |
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. |
NA |
NA |
NA |
NA |
NA |
NA |
exchange_rate |
number20_10 |
0 |
1 |
The rate of exchange used for the purchase order between the order and primary currencies. |
|
|
|
|
null |
Not used in SIM |
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. |
|
|
|
|
null |
Not used in SIM |
factory_desc |
varchar2240 |
0 |
1 |
Contains the description of the factory. Not used in RWMS. |
|
|
|
|
null |
Not used in SIM |
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. |
|
|
|
|
null |
Not used in SIM. |
agent_desc |
varchar2240 |
0 |
1 |
Not used in RWMS. |
|
|
|
|
null |
Not used in SIM. |
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. |
|
|
|
|
null |
Not used in SIM |
discharge_port_desc |
varchar2150 |
0 |
1 |
Contains the description of the discharge port. Not used in RWMS. |
|
|
|
|
No |
Not used in SIM |
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. |
|
|
|
|
null |
Not used in SIM |
lading_port_desc |
varchar2150 |
0 |
1 |
Contains the description of the lading port. Not used in RWMS. |
|
|
|
|
null |
Not used in SIM |
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'. |
|
|
|
|
null |
Not used in SIM. |
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. |
|
|
|
|
null |
Not used in SIM |
po_type |
varchar24 |
0 |
1 |
Contains the value associated with the PO_TYPE for the order. Not used in RWMS. |
|
|
|
|
null |
Not used in SIM. |
po_type_desc |
varchar2120 |
0 |
1 |
Contains a description for the specific PO_TYPE. |
|
|
|
|
null |
Not used in SIM. |
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. |
|
|
|
|
null |
Not used in SIM. |
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. |
|
|
|
|
Yes |
This is used to calculated Unit Cost for the Item. |
contract_no |
number6 |
0 |
1 |
Contains the contract number associated with this order. Not used in RWMS. |
|
|
|
|
null |
Not used in SIM. |
pickup_loc |
varchar2250 |
0 |
1 |
Contains the location at which the order will be picked up, if the order is a 'Pickup' order. |
|
|
|
|
null |
Not used in SIM. |
pickup_no |
varchar225 |
0 |
1 |
Contains the reference number for the Pickup order. Not used in RWMS. |
|
|
|
|
null |
Not used in SIM. |
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'. |
|
|
|
|
null |
Not used in SIM. |
app_datetime |
xs:dateTime |
0 |
1 |
This column will hold the date and time of the receiving appointment at the warehouse. |
|
|
|
|
null |
Not used in SIM. |
comment_desc |
varchar22000 |
0 |
1 |
Miscellaneous comments attached to the purchase order. |
PURCHASE_ORDER |
COMMENTS |
VARCHAR2 |
2000 |
No |
description and/or comments associated with the purchase order as defined by the user. |
cust_order_nbr |
varchar248 |
0 |
1 |
This field holds the master customer order number from OMS. |
PURCHASE_ORDER |
CUST_ORDER_ID |
VARCHAR2 |
128 |
No |
Customer order external identifier |
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. |
PURCHASE_ORDER |
FUL_ORD_EXTERNAL_ID |
VARCHAR2 |
128 |
No |
Fulfillment order external identifier |
PODtl
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|