Application
|
Store Inventory Management
|
Target Name Space
|
http://www.oracle.com/retail/integration/base/bo/ASNInDesc/v1
|
Version
|
1.0
|
Description
|
This is root element of this document which contains name space definitions for the document elements.
|
|
|
|
XML-Schema Name:ASNInDesc
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ASNInDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
to_location |
varchar210 |
1 |
1 |
Not used in RWMS |
DO_CTL_INV |
ID_PRTY_TO_ICD |
VARCHAR2 |
128 |
No |
Not Yet Available |
from_location |
varchar210 |
1 |
1 |
Not used in RWMS |
DO_CTL_INV |
ID_PRTY_FM_ICD |
VARCHAR2 |
128 |
No |
Not Yet Available |
asn_nbr |
varchar230 |
1 |
1 |
Description is not available. |
DO_CTL_INV |
ASN_NUM |
VARCHAR2 |
128 |
No |
Not Yet Available |
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). |
|
null |
null |
null |
null |
null |
container_qty |
number6 |
1 |
1 |
Description is not available. |
|
null |
null |
null |
null |
null |
bol_nbr |
varchar217 |
0 |
1 |
Holds the transaction sequence number on the input message from the receiving PO or transfer process. |
|
null |
varchar2 |
17 |
null |
null |
shipment_date |
xs:dateTime |
1 |
1 |
Not used in RWMS. |
DO_CTL_INV |
TS_CRT_ICD |
RIBDate |
* |
No |
Not Yet Available |
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. |
DO_CTL_INV |
DC_DV_EXP_ICD |
RIBDate |
* |
No |
Not Yet Available |
ship_address1 |
varchar2240 |
0 |
1 |
Not used in RWMS. |
|
null |
null |
null |
null |
null |
ship_address2 |
varchar2240 |
0 |
1 |
Not used in RWMS. |
|
null |
null |
null |
null |
null |
ship_address3 |
varchar2240 |
0 |
1 |
Not used in RWMS. |
|
null |
null |
null |
null |
null |
ship_address4 |
varchar2240 |
0 |
1 |
Not used in RWMS. |
|
null |
null |
null |
null |
null |
ship_address5 |
varchar2240 |
0 |
1 |
Not used in RWMS. |
|
null |
null |
null |
null |
null |
ship_city |
varchar2120 |
0 |
1 |
Not used in RWMS. |
|
null |
null |
null |
null |
null |
ship_state |
varchar23 |
0 |
1 |
Not used in RWMS. |
|
null |
null |
null |
null |
null |
ship_zip |
varchar230 |
0 |
1 |
Not used in RWMS. |
|
null |
null |
null |
null |
null |
ship_country_id |
varchar23 |
0 |
1 |
Not used in RWMS. |
|
null |
null |
null |
null |
null |
trailer_nbr |
varchar212 |
0 |
1 |
Not used in RWMS. |
|
null |
null |
null |
null |
null |
seal_nbr |
varchar212 |
0 |
1 |
Not used in RWMS. |
|
null |
null |
null |
null |
null |
carrier_code |
varchar24 |
0 |
1 |
Description is not available. |
|
null |
varchar2 |
4 |
null |
null |
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. |
DO_CTL_INV |
ID_PRTY_FM_ICD |
VARCHAR2 |
128 |
No |
Not Yet Available |
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. |
|
null |
varchar2 |
2 |
null |
null |
ASNInPO
|
*
|
1
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
comments |
varchar22000 |
0 |
1 |
Description is not available. |
DO_CTL_INV |
COMMENT_DESC |
VARCHAR2 |
300 |
No |
Not Yet Available |
ExtOfASNInDesc:ExtOfASNInDesc
|
*
|
0
|
1
|
Provide an extension hook to customize ASNInDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ASNInPO
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim 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. |
DO_CTL_INV |
ORDER_ID/REFERENCE_ID_ICD |
VARCHAR2 |
128 |
No |
Not Yet Available |
doc_type |
varchar21 |
1 |
1 |
Description is not available. |
DO_CTL_INV |
ID_ORGR_ICD |
VARCHAR2 |
128 |
No |
Not Yet Available |
not_after_date |
xs:dateTime |
0 |
1 |
Description is not available. |
|
null |
RIBDate |
* |
null |
null |
comments |
varchar22000 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
null |
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
|
|
|
XML-Schema Name:ASNInCtn
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim 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. |
|
null |
varchar2 |
10 |
null |
null |
container_id |
varchar220 |
1 |
1 |
Description is not available. |
RK_SHIP_CONT_ICD |
CONTAINER_ID |
VARCHAR2 |
128 |
No |
Not Yet Available |
container_weight |
number12_4 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
null |
container_length |
number12_4 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
null |
container_width |
number12_4 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
null |
container_height |
number12_4 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
null |
container_cube |
number12_2 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
null |
expedite_flag |
varchar21 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
null |
in_store_date |
xs:dateTime |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
null |
rma_nbr |
varchar220 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
null |
tracking_nbr |
varchar225 |
0 |
1 |
Not used in RWMS |
|
null |
null |
null |
null |
null |
freight_charge |
number12_4 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
null |
master_container_id |
varchar220 |
0 |
1 |
Not used in RWMS |
|
null |
null |
null |
null |
null |
ASNInItem
|
*
|
1
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
comments |
varchar22000 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
null |
ExtOfASNInDesc:ExtOfASNInCtn
|
*
|
0
|
1
|
Provide an extension hook to customize ASNInCtn.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ASNInItem
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim 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. |
|
null |
varchar2 |
10 |
null |
null |
item_id |
varchar225 |
0 |
1 |
Unique identifier for the item. Either vpn, item_id, or ref_item must be specified in the message. |
TR_LTM_ICD_MR |
ID_ITM |
VARCHAR2 |
128 |
Yes |
Not Yet Available |
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. |
TR_LTM_ICD_MR |
QU_ITM |
NUMBER |
20,4 |
No |
Not Yet Available |
priority_level |
number1 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
null |
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. |
|
null |
varchar2 |
30 |
null |
null |
order_line_nbr |
number4 |
0 |
1 |
Not used in RWMS. |
|
null |
null |
null |
null |
null |
lot_nbr |
varchar212 |
0 |
1 |
Not used in RWMS. |
|
null |
null |
null |
null |
null |
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. |
|
null |
varchar2 |
25 |
null |
null |
distro_nbr |
varchar210 |
1 |
1 |
Description is not available. |
|
null |
null |
null |
null |
null |
distro_doc_type |
varchar21 |
0 |
1 |
Not used in RWMS. |
|
null |
null |
null |
null |
null |
container_qty |
number6 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
null |
comments |
varchar22000 |
0 |
1 |
Description is not available. |
TR_LTM_ICD_MR |
COMMENT_DESC |
VARCHAR2 |
300 |
No |
Not Yet Available |
ExtOfASNInDesc:ExtOfASNInItem
|
*
|
0
|
1
|
Provide an extension hook to customize ASNInItem.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ExtOfASNInItem
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ExtOfASNInItem |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:ExtOfASNInCtn
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ExtOfASNInCtn |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:ASNInItem
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim 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. |
|
null |
varchar2 |
10 |
null |
null |
item_id |
varchar225 |
0 |
1 |
Unique identifier for the item. Either vpn, item_id, or ref_item must be specified in the message. |
TR_LTM_ICD_MR |
ID_ITM |
VARCHAR2 |
128 |
Yes |
Not Yet Available |
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. |
TR_LTM_ICD_MR |
QU_ITM |
NUMBER |
20,4 |
No |
Not Yet Available |
priority_level |
number1 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
null |
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. |
|
null |
varchar2 |
30 |
null |
null |
order_line_nbr |
number4 |
0 |
1 |
Not used in RWMS. |
|
null |
null |
null |
null |
null |
lot_nbr |
varchar212 |
0 |
1 |
Not used in RWMS. |
|
null |
null |
null |
null |
null |
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. |
|
null |
varchar2 |
25 |
null |
null |
distro_nbr |
varchar210 |
1 |
1 |
Description is not available. |
|
null |
null |
null |
null |
null |
distro_doc_type |
varchar21 |
0 |
1 |
Not used in RWMS. |
|
null |
null |
null |
null |
null |
container_qty |
number6 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
null |
comments |
varchar22000 |
0 |
1 |
Description is not available. |
TR_LTM_ICD_MR |
COMMENT_DESC |
VARCHAR2 |
300 |
No |
Not Yet Available |
ExtOfASNInDesc:ExtOfASNInItem
|
*
|
0
|
1
|
Provide an extension hook to customize ASNInItem.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ExtOfASNInItem
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ExtOfASNInItem |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:ExtOfASNInPO
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ExtOfASNInPO |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:ExtOfASNInDesc
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ExtOfASNInDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|