Application
|
Retail Merchandizing System
|
Target Name Space
|
http://www.oracle.com/retail/integration/base/bo/ASNInDesc/v1
|
Version
|
1.1
|
Description
|
This is root element of this document which contains name space definitions for the document elements.
|
|
|
|
XML-Schema Name:ASNInDesc
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For ASNInDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
schedule_nbr |
number8 |
0 |
1 |
Contains the Schedule identifier number |
n/a |
n/a |
null |
null |
Yes |
Contains the Schedule identifier number used for RFM. |
auto_receive |
varchar21 |
0 |
1 |
Contains the flag to enable auto_receiving at SIM |
n/a |
n/a |
null |
null |
Yes |
Not used by RMS. |
to_location |
varchar210 |
1 |
1 |
Not used in RWMS |
shipment |
to_loc |
varchar2 |
10 |
Yes |
Contains the location to which the shipment will be delivered. |
from_location |
varchar210 |
1 |
1 |
Not used in RWMS |
n/a |
n/a |
null |
null |
Yes |
Not used by RMS. |
asn_nbr |
varchar230 |
1 |
1 |
Description is not available. |
shipment |
asn |
varchar2 |
30 |
Yes |
Holds the advance shipping notice number associated with a shipment. |
asn_type |
varchar21 |
1 |
1 |
This field is used to determine the ship origin. If asn_type is 'C', ship_origin will be set to '6' (ASN UCC-128) upon insert to the SHIPMENT table. Otherwise, SHIP_ORIGIN is defaulted to '0' (ASN Shipment). |
n/a |
n/a |
null |
null |
Yes |
This field is used to determine the ship origin. If asn_type is C, ship_origin is set to 6 (ASN UCC-128) when inserted in the SHIPMENT table. Otherwise, SHIP_ORIGIN defaults to 0 (ASN Shipment). |
container_qty |
number6 |
1 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
Yes |
Not used by RMS. |
bol_nbr |
varchar217 |
0 |
1 |
Holds the transaction sequence number on the input message from the receiving PO or transfer process. |
shipment |
ext_ref_no_in |
varchar2 |
17 |
No |
Holds the transaction sequence number on the input message from the receiving PO or transfer process. |
shipment_date |
xs:dateTime |
1 |
1 |
Not used in RWMS. |
shipment |
ship_date |
RIBDate |
* |
Yes |
This field contains the date the transfer or PO was shipped. |
est_arr_date |
xs:dateTime |
0 |
1 |
This field contains the estimated arrival date of a vendor PO shipment. It is updated by EDIUP856. It is used for vendor/lead time analysis. |
shipment |
est_arr_date |
RIBDate |
|
No |
This field contains the estimated arrival date of a vendor PO shipment. It is updated by EDIUP856. It is used for vendor/lead time analysis. |
ship_address1 |
varchar2240 |
0 |
1 |
Not used in RWMS. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
ship_address2 |
varchar2240 |
0 |
1 |
Not used in RWMS. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
ship_address3 |
varchar2240 |
0 |
1 |
Not used in RWMS. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
ship_address4 |
varchar2240 |
0 |
1 |
Not used in RWMS. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
ship_address5 |
varchar2240 |
0 |
1 |
Not used in RWMS. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
ship_city |
varchar2120 |
0 |
1 |
Not used in RWMS. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
ship_state |
varchar23 |
0 |
1 |
Not used in RWMS. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
ship_zip |
varchar230 |
0 |
1 |
Not used in RWMS. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
ship_country_id |
varchar23 |
0 |
1 |
Not used in RWMS. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
trailer_nbr |
varchar212 |
0 |
1 |
Not used in RWMS. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
seal_nbr |
varchar212 |
0 |
1 |
Not used in RWMS. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
carrier_code |
varchar24 |
0 |
1 |
Description is not available. |
shipment |
courier |
varchar2 |
4 |
No |
Contains the courier that will deliver the shipment. |
vendor_nbr |
varchar210 |
1 |
1 |
This element is used to validate the order number(s) in ASNInPO (ASNInPO.po_nbr). The order number must be in the table ORDHEAD, in either the ORDER_NO column or VENDOR_ORDER_NO column. |
ordhead |
supplier |
null |
null |
Yes |
This element is used to validate the order numbers in ASNInPO (ASNInPO.po_nbr). The order number must be in the table ORDHEAD, in either the ORDER_NO column or VENDOR_ORDER_NO column. |
ship_pay_method |
varchar22 |
0 |
1 |
Used to validate the order number(s) in ASNInPO (ASNInPO.po_nbr). The ship_pay_method in the message must match the value of the order's SHIP_PAY_METHOD in RMS (ORDHEAD table.) If the message field is blank, the ORDHEAD value must be NULL. |
ordhead |
ship_pay_method |
varchar2 |
2 |
No |
Used to validate the order number(s) in ASNInPO (ASNInPO.po_nbr). The ship_pay_method in the message must match the value of the order's SHIP_PAY_METHOD in RMS (ORDHEAD table.) If the message field is blank, the ORDHEAD value must be NULL. |
ASNInPO
|
*
|
1
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
comments |
varchar22000 |
0 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
ExtOfASNInDesc:ExtOfASNInDesc
|
*
|
0
|
1
|
Provide an extension hook to customize ASNInDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
LocOfASNInDesc:LocOfASNInDesc
|
*
|
0
|
1
|
Provide an extension hook to localize ASNInDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ASNInPO
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For ASNInPO |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
po_nbr |
varchar210 |
1 |
1 |
Identifies the order number which relates to the goods delivered in the shipment. Validated against the ORDHEAD table, and also the SHIPMENT table if the message applies to an existing shipment. |
shipment |
order_no |
varchar2 |
10 |
Yes |
Identifies the order number that relates to the goods delivered in the shipment. Validated against the ORDHEAD table and the SHIPMENT table (if the message applies to an existing shipment). |
doc_type |
varchar21 |
1 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
Yes |
Not used by RMS. |
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. |
comments |
varchar22000 |
0 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
ASNInCtn
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
ASNInItem
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
ExtOfASNInDesc:ExtOfASNInPO
|
*
|
0
|
1
|
Provide an extension hook to customize ASNInPO.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
LocOfASNInDesc:LocOfASNInPO
|
*
|
0
|
1
|
Provide an extension hook to localize ASNInPO.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ASNInCtn
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For ASNInCtn |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
final_location |
varchar210 |
1 |
1 |
This will be the final destination of the carton. For a cross-dock order this will be the allocation location, otherwise it will be the direct to order location. |
carton |
location |
varchar2 |
10 |
Yes |
This is the final destination of the carton. For a cross-dock order, this is the allocation location; otherwise, it is the direct to order location. |
container_id |
varchar220 |
1 |
1 |
Description is not available. |
carton |
carton |
varchar2 |
20 |
Yes |
Holds the UCC-128 carton number. |
container_weight |
number12_4 |
0 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
container_length |
number12_4 |
0 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
container_width |
number12_4 |
0 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
container_height |
number12_4 |
0 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
container_cube |
number12_2 |
0 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
expedite_flag |
varchar21 |
0 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
in_store_date |
xs:dateTime |
0 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
rma_nbr |
varchar220 |
0 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
tracking_nbr |
varchar225 |
0 |
1 |
Not used in RWMS |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
freight_charge |
number12_4 |
0 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
master_container_id |
varchar220 |
0 |
1 |
Not used in RWMS |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
ASNInItem
|
*
|
1
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
comments |
varchar22000 |
0 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
ExtOfASNInDesc:ExtOfASNInCtn
|
*
|
0
|
1
|
Provide an extension hook to customize ASNInCtn.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
LocOfASNInDesc:LocOfASNInCtn
|
*
|
0
|
1
|
Provide an extension hook to localize ASNInCtn.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ASNInItem
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For ASNInItem |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
final_location |
varchar210 |
1 |
1 |
Required if the order's pre_mark_ind is 'Y'. Validated against the ALLOC_DETAIL table. There needs to be at least one allocation with the same ORDER_NO that is in the ASNIn message, and the same TO_LOC as the final_location. |
alloc_detail |
to_loc |
varchar2 |
10 |
Yes |
Required if the order's pre_mark_ind is Y. Validated against the ALLOC_DETAIL table. There must be at least one allocation with the same ORDER_NO that is in the ASNIn message, and the same TO_LOC as the final location. |
item_id |
varchar225 |
0 |
1 |
Unique identifier for the item. Either vpn, item_id, or ref_item must be specified in the message. |
shipsku |
item |
varchar2 |
25 |
Yes |
Unique identifier for the item; vpn, item_id, or ref_item must be specified in the message. |
unit_qty |
number12_4 |
1 |
1 |
Contains the number of items expected to be received based on the supplier's ASN for this Item/Shipment combination. |
shipsku |
qty_expected |
number |
12 |
Yes |
Contains the number of items expected to be received based on the supplier's ASN for this Item/Shipment combination. |
priority_level |
number1 |
0 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
vpn |
varchar230 |
0 |
1 |
Used to find the Retek item number, found on the ITEM_SUPPLIER table. Either vpn, item_id, or ref_item must be specified in the message. |
item_supplier |
vpn |
varchar2 |
30 |
No |
Used to find the item number, found on the ITEM_SUPPLIER table. The vpn, item_id, or ref_item must be specified in the message. |
order_line_nbr |
number4 |
0 |
1 |
Not used in RWMS. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
lot_nbr |
varchar212 |
0 |
1 |
Not used in RWMS. |
n/a |
n/a |
null |
null |
Yes |
Not used by RMS. |
ref_item |
varchar225 |
0 |
1 |
Contains a reference item to the item field. Either vpn, item_id, or ref_item must be specified in the message. |
shipsku |
ref_item |
varchar2 |
25 |
No |
Contains a reference item to the item field; vpn, item_id, or ref_item must be specified in the message. |
distro_nbr |
varchar210 |
1 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
Yes |
Not used by RMS. |
distro_doc_type |
varchar21 |
0 |
1 |
Not used in RWMS. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
container_qty |
number6 |
0 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
comments |
varchar22000 |
0 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
ExtOfASNInDesc:ExtOfASNInItem
|
*
|
0
|
1
|
Provide an extension hook to customize ASNInItem.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
LocOfASNInDesc:LocOfASNInItem
|
*
|
0
|
1
|
Provide an extension hook to localize ASNInItem.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ExtOfASNInItem
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For ExtOfASNInItem |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:LocOfASNInItem
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For LocOfASNInItem |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
InASNInDesc:InASNInItem
|
*
|
0
|
unbounded
|
India Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
BrASNInDesc:BrASNInItem
|
*
|
0
|
unbounded
|
Brazil Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ExtOfASNInCtn
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For ExtOfASNInCtn |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:LocOfASNInCtn
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For LocOfASNInCtn |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
InASNInDesc:InASNInCtn
|
*
|
0
|
unbounded
|
India Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
BrASNInDesc:BrASNInCtn
|
*
|
0
|
unbounded
|
Brazil Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ASNInItem
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For ASNInItem |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
final_location |
varchar210 |
1 |
1 |
Required if the order's pre_mark_ind is 'Y'. Validated against the ALLOC_DETAIL table. There needs to be at least one allocation with the same ORDER_NO that is in the ASNIn message, and the same TO_LOC as the final_location. |
alloc_detail |
to_loc |
varchar2 |
10 |
Yes |
Required if the order's pre_mark_ind is Y. Validated against the ALLOC_DETAIL table. There must be at least one allocation with the same ORDER_NO that is in the ASNIn message, and the same TO_LOC as the final location. |
item_id |
varchar225 |
0 |
1 |
Unique identifier for the item. Either vpn, item_id, or ref_item must be specified in the message. |
shipsku |
item |
varchar2 |
25 |
Yes |
Unique identifier for the item; vpn, item_id, or ref_item must be specified in the message. |
unit_qty |
number12_4 |
1 |
1 |
Contains the number of items expected to be received based on the supplier's ASN for this Item/Shipment combination. |
shipsku |
qty_expected |
number |
12 |
Yes |
Contains the number of items expected to be received based on the supplier's ASN for this Item/Shipment combination. |
priority_level |
number1 |
0 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
vpn |
varchar230 |
0 |
1 |
Used to find the Retek item number, found on the ITEM_SUPPLIER table. Either vpn, item_id, or ref_item must be specified in the message. |
item_supplier |
vpn |
varchar2 |
30 |
No |
Used to find the item number, found on the ITEM_SUPPLIER table. The vpn, item_id, or ref_item must be specified in the message. |
order_line_nbr |
number4 |
0 |
1 |
Not used in RWMS. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
lot_nbr |
varchar212 |
0 |
1 |
Not used in RWMS. |
n/a |
n/a |
null |
null |
Yes |
Not used by RMS. |
ref_item |
varchar225 |
0 |
1 |
Contains a reference item to the item field. Either vpn, item_id, or ref_item must be specified in the message. |
shipsku |
ref_item |
varchar2 |
25 |
No |
Contains a reference item to the item field; vpn, item_id, or ref_item must be specified in the message. |
distro_nbr |
varchar210 |
1 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
Yes |
Not used by RMS. |
distro_doc_type |
varchar21 |
0 |
1 |
Not used in RWMS. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
container_qty |
number6 |
0 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
comments |
varchar22000 |
0 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
No |
Not used by RMS. |
ExtOfASNInDesc:ExtOfASNInItem
|
*
|
0
|
1
|
Provide an extension hook to customize ASNInItem.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
LocOfASNInDesc:LocOfASNInItem
|
*
|
0
|
1
|
Provide an extension hook to localize ASNInItem.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ExtOfASNInItem
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For ExtOfASNInItem |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:LocOfASNInItem
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For LocOfASNInItem |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
InASNInDesc:InASNInItem
|
*
|
0
|
unbounded
|
India Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
BrASNInDesc:BrASNInItem
|
*
|
0
|
unbounded
|
Brazil Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ExtOfASNInPO
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For ExtOfASNInPO |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:LocOfASNInPO
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For LocOfASNInPO |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
InASNInDesc:InASNInPO
|
*
|
0
|
unbounded
|
India Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
BrASNInDesc:BrASNInPO
|
*
|
0
|
unbounded
|
Brazil Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ExtOfASNInDesc
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For ExtOfASNInDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:LocOfASNInDesc
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For LocOfASNInDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
InASNInDesc:InASNInDesc
|
*
|
0
|
unbounded
|
India Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
BrASNInDesc:BrASNInDesc
|
*
|
0
|
unbounded
|
Brazil Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|