XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for XOrderDesc 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 |
order_no |
varchar212 |
1 |
1 |
The unique identifier for the order. |
ordhead |
order_no |
number |
12 |
Yes |
The unique identifier for the order. |
supplier |
varchar210 |
0 |
1 |
The identifier of the supplier from which the order will be sourced. This cannot be modified if details exist for the PO. |
ordhead |
supplier |
varchar2 |
10 |
Yes |
The identifier of the supplier from which the order will be sourced. This cannot be modified if details exist for the PO. |
currency_code |
varchar23 |
0 |
1 |
The code of the order's currency. If not populated, the supplier's currency will be used. This field can be modified if the order status is worksheet or approved and the order has not been shipped. |
ordhead |
currency_code |
varchar2 |
3 |
No |
Indicates the order's currency. If not populated, the supplier's currency is used. This field can be modified if the order status is worksheet or approved and the order has not been shipped. |
terms |
varchar215 |
0 |
1 |
The sales terms of the order. If not populated on the create message, will default to the supplier's terms. This can be modified in worksheet or approved status. |
ordhead |
terms |
varchar2 |
15 |
No |
The sales terms of the order. If not populated on the create message, it will default to the supplier's terms. This can be modified in Worksheet or Approved status. |
not_before_date |
xs:dateTime |
0 |
1 |
The first date that delivery will be accepted. This can be modified in worksheet or approved status. |
ordhead |
not_before_date |
RIBDate |
* |
No |
The first date that delivery will be accepted. This can be modified in worksheet or approved status. |
not_after_date |
xs:dateTime |
0 |
1 |
The last date that delivery will be accepted. This can be modified in worksheet or approved status. |
ordhead |
not_after_date |
RIBDate |
* |
No |
The last date on which delivery will be accepted. This can be modified in Worksheet or Approved status. |
otb_eow_date |
xs:dateTime |
0 |
1 |
The end of week date of the OTB bucket used. This can be modified in worksheet or approved status. |
ordhead |
otb_eow_date |
RIBDate |
* |
No |
The end of week date of the OTB bucket used. This can be modified in Worksheet or Approved status. |
dept |
number4 |
0 |
1 |
The department in which are all the items on the order. This field is required if the system enforces single department ordering. This cannot be modified if details exist for the PO. |
ordhead |
dept |
number |
4 |
No |
The department to which all the items on the order belong. This field is required if the system enforces single department ordering. This cannot be modified if details exist for the PO. |
status |
varchar21 |
0 |
1 |
The code for the status of the order. Valid values are 'W' worksheet and 'A' approved for PO creation. It is also possible to modify the status to 'C' closed. |
ordhead |
status |
null |
null |
No |
The status of the order. Valid values are W (worksheet) and A (approved) for PO creation. It is also possible to modify the status to C (closed). |
exchange_rate |
number20_10 |
0 |
1 |
The rate of exchange for the PO used between the order and primary currencies. This field can be modified if the order status is worksheet or approved and the order has not been shipped.. |
ordhead |
exchange_rate |
number |
20 |
No |
The rate of exchange for the PO used between the order and primary currencies. This field can be modified if the order status is Worksheet or Approved and the order has not been shipped. |
include_on_ord_ind |
varchar21 |
0 |
1 |
Indicates if the order should be included in on-order calculations. This can be modified in worksheet or approved status. |
ordhead |
include_on_ord_ind |
varchar2 |
1 |
No |
Indicates whether the order should be included in on-order calculations. This can be modified in Worksheet or Approved status. |
written_date |
xs:dateTime |
0 |
1 |
The date the order was created. If this field is not populated on the message it will default to the time of creation in RMS. It cannot be modified. |
ordhead |
written_date |
RIBDate |
* |
No |
The date the order was created. If this field is not populated on the message it will default to the time of creation in RMS. It cannot be modified. |
XOrderDtl
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
orig_ind |
varchar21 |
0 |
1 |
Indicates where the order originated. Valid values include: 2 - Manual, 6 - AIP generated order, 7 , 8. |
ordhead |
orig_ind |
null |
2 - Manual, 6 - AIP generated order, 7 , 8. |
Yes |
Indicates where the order originated. |
edi_po_ind |
varchar21 |
0 |
1 |
Indicates whether or not the order will be transmitted to the supplier via an Electronic Data Exchange transaction. Valid values are: Y = Submit via EDI, N = Do not use EDI. |
ordhead |
edi_po_ind |
null |
Y = Submit via EDI, N = Do not use EDI. |
No |
Indicates whether the order will be transmitted to the supplier through an Electronic Data Exchange transaction. |
pre_mark_ind |
varchar21 |
0 |
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_marked_ind |
null |
null |
No |
Indicates whether a supplier has agreed to break an order into separate boxes so that the boxes can be sent directly to stores. |
user_id |
varchar230 |
0 |
1 |
Indicates where the order was approved. It will be the user ID of the person approving the order. |
ordhead |
orig_approval_id |
null |
null |
No |
Indicates where the order was approved. It will be the user ID of the person approving the order. |
comment_desc |
varchar22000 |
0 |
1 |
Any comments pertaining to the order. |
ordhead |
comment_desc |
null |
null |
No |
Comments pertaining to the order. |
attempt_rms_load |
varchar26 |
0 |
1 |
This field indicates if the order will be created in RMS or the staging tables. Valid values are RMS or STG. If not defined, the default is STG. |
svc_process_tracker |
destination |
varchar2 |
6 |
No |
This will indicated if the order should be loaded into RMS or to the staging tables. Valid values are 'RMS' or 'STG'. If incoming value is NULL, then defaulted to RMS. |