Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For XOrderDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
order_no |
varchar210 |
1 |
1 |
The unique identifier for the order. |
ordhead |
order_no |
varchar2 |
10 |
Yes |
The unique identifier for the order. |
supplier |
varchar210 |
1 |
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 |
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. |
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, 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 that 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 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. |
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 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. |
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 if 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 |
null |
Yes |
Indicates where the order originated. Valid values include: 2 - Manual, 6 - AIP generated order, 7 , 8. |
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 |
null |
No |
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. |
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 |
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. |
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 |
Any comments pertaining to the order. |
ExtOfXOrderDesc:ExtOfXOrderDesc
|
*
|
0
|
1
|
Provide an extension hook to customize XOrderDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|