|
Application
|
Store Inventory Management
|
|
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 |
sim 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 |
NA |
NA |
NA |
NA |
NA |
NA |
| auto_receive |
varchar21 |
0 |
1 |
Contains the flag to enable auto_receiving at SIM |
NA |
NA |
NA |
NA |
NA |
NA |
| to_location |
varchar210 |
1 |
1 |
Not used in RWMS |
RK_SHIPMENTS |
STORE_ID |
NUMBER |
10 |
Yes |
The unique identifier of the store that this shipment is for |
| from_location |
varchar210 |
1 |
1 |
Not used in RWMS |
RK_SHIPMENTS |
FROM_LOCATION_ID |
VARCHAR2 |
128 |
No |
The unique identifierof the location that shipped the items. This will be supplier, external finisher or warehouse. |
| asn_nbr |
varchar230 |
1 |
1 |
Description is not available. |
RK_SHIPMENTS |
ASN_ID |
VARCHAR2 |
128 |
No |
The Advanced Shipping Notification identifier that is associated with the 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). |
|
|
|
|
null |
Not used in SIM |
| container_qty |
number6 |
1 |
1 |
Description is not available. |
|
|
|
|
No |
Not used in SIM |
| bol_nbr |
varchar217 |
0 |
1 |
Holds the transaction sequence number on the input message from the receiving PO or transfer process. |
|
|
|
|
null |
Not used in SIM |
| shipment_date |
xs:dateTime |
1 |
1 |
Not used in RWMS. |
RK_SHIPMENTS |
CREATE_DATE |
DATE |
|
No |
The date the shipment record was created |
| 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. |
RK_SHIPMENTS |
EXPECTED_ARRIVAL_DATE |
DATE |
|
No |
The date the shipment is expected to arrive at the store |
| ship_address1 |
varchar2240 |
0 |
1 |
Not used in RWMS. |
|
|
|
|
null |
Not used in SIM |
| ship_address2 |
varchar2240 |
0 |
1 |
Not used in RWMS. |
|
|
|
|
null |
Not used in SIM |
| ship_address3 |
varchar2240 |
0 |
1 |
Not used in RWMS. |
|
|
|
|
null |
Not used in SIM |
| ship_address4 |
varchar2240 |
0 |
1 |
Not used in RWMS. |
|
|
|
|
null |
Not used in SIM |
| ship_address5 |
varchar2240 |
0 |
1 |
Not used in RWMS. |
|
|
|
|
null |
Not used in SIM |
| ship_city |
varchar2120 |
0 |
1 |
Not used in RWMS. |
|
null |
null |
null |
null |
Not used in SIM |
| ship_state |
varchar23 |
0 |
1 |
Not used in RWMS. |
|
null |
null |
null |
null |
Not used in SIM |
| ship_zip |
varchar230 |
0 |
1 |
Not used in RWMS. |
|
null |
null |
null |
null |
Not used in SIM |
| ship_country_id |
varchar23 |
0 |
1 |
Not used in RWMS. |
|
null |
null |
null |
null |
Not used in SIM |
| trailer_nbr |
varchar212 |
0 |
1 |
Not used in RWMS. |
|
null |
null |
null |
null |
Not used in SIM |
| seal_nbr |
varchar212 |
0 |
1 |
Not used in RWMS. |
|
|
|
|
null |
Not used in SIM |
| carrier_code |
varchar24 |
0 |
1 |
Description is not available. |
|
|
|
|
null |
Not used in SIM |
| 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. |
RK_SHIPMENTS |
FROM_LOCATION_ID |
VARCHAR2 |
128 |
No |
The unique identifierof the location that shipped the items. This will either supplier, external finisher or a warehouse |
| 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 |
Not used in SIM |
|
ASNInPO
|
*
|
1
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
| comments |
varchar22000 |
0 |
1 |
Description is not available. |
RK_SHIPMENTS |
COMMENT_DESC |
VARCHAR2 |
2000 |
No |
If <ASNInPO> is empty, then <ASNInDesc>/<comments> is stored in RK_SHIPMENTS table. Else <ASNInPO>/<comments> is stored in RK_SHIPMENTS table. |
|
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 |
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. |
RK_SHIPMENTS |
ORDER_ID |
VARCHAR2 |
128 |
No |
The unique identifier of the order that this shipment is associated to. |
| doc_type |
varchar21 |
1 |
1 |
Description is not available. |
RK_SHIPMENT_ITEM |
RECEIPT_DOC_TYPE |
VARCHAR2 |
128 |
No |
A code representing the type of receipt document associated to the shipment |
| not_after_date |
xs:dateTime |
0 |
1 |
Description is not available. |
|
|
|
|
null |
Not used in SIM |
| comments |
varchar22000 |
0 |
1 |
Description is not available. |
RK_SHIPMENTS |
COMMENT_DESC |
VARCHAR2 |
2000 |
No |
|
|
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 |
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 |
Not used in SIM |
| container_id |
varchar220 |
1 |
1 |
Description is not available. |
RK_SHIPMENT_CARTON |
CARTON_ID |
VARCHAR2 |
128 |
Yes |
The unique identifier of the Carton. This is also referred in RK_SHIPMENT_ITEM.CARTON_ID column. |
| container_weight |
number12_4 |
0 |
1 |
Description is not available. |
|
|
|
|
null |
Not used in SIM |
| container_length |
number12_4 |
0 |
1 |
Description is not available. |
|
|
|
|
null |
Not used in SIM |
| container_width |
number12_4 |
0 |
1 |
Description is not available. |
|
|
|
|
null |
Not used in SIM |
| container_height |
number12_4 |
0 |
1 |
Description is not available. |
|
|
|
|
null |
Not used in SIM |
| container_cube |
number12_2 |
0 |
1 |
Description is not available. |
|
|
|
|
null |
Not used in SIM |
| expedite_flag |
varchar21 |
0 |
1 |
Description is not available. |
|
|
|
|
null |
Not used in SIM |
| in_store_date |
xs:dateTime |
0 |
1 |
Description is not available. |
|
|
|
|
null |
Not used in SIM |
| rma_nbr |
varchar220 |
0 |
1 |
Description is not available. |
|
|
|
|
null |
Not used in SIM |
| tracking_nbr |
varchar225 |
0 |
1 |
Not used in RWMS |
|
|
|
|
null |
Not used in SIM |
| freight_charge |
number12_4 |
0 |
1 |
Description is not available. |
|
|
|
|
null |
Not used in SIM |
| master_container_id |
varchar220 |
0 |
1 |
Not used in RWMS |
|
|
|
|
null |
Not used in SIM |
|
ASNInItem
|
*
|
1
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
| comments |
varchar22000 |
0 |
1 |
Description is not available. |
|
|
|
|
null |
Not used by SIM |
|
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 |
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 |
Not used in SIM |
| item_id |
varchar225 |
0 |
1 |
Unique identifier for the item. Either vpn, item_id, or ref_item must be specified in the message. |
RK_SHIPMENT_ITEM |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
The unique identifier of the item that is contained in this carton |
| 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. |
RK_SHIPMENT_ITEM |
QUANTITY_EXPECTED |
NUMBER |
20,4 |
No |
The total number of units expected in this shipment |
| priority_level |
number1 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
Not used in SIM |
| 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 |
Not used in SIM |
| order_line_nbr |
number4 |
0 |
1 |
Not used in RWMS. |
|
null |
null |
null |
null |
Not used in SIM |
| lot_nbr |
varchar212 |
0 |
1 |
Not used in RWMS. |
|
|
|
|
null |
Not used in SIM |
| 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 |
Not used in SIM |
| distro_nbr |
varchar210 |
1 |
1 |
Description is not available. |
|
null |
null |
null |
null |
Not used in SIM |
| distro_doc_type |
varchar21 |
0 |
1 |
Not used in RWMS. |
|
null |
null |
null |
null |
Not used in SIM |
| container_qty |
number6 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
Not used in SIM |
| comments |
varchar22000 |
0 |
1 |
Description is not available. |
RK_SHIPMENT_ITEM |
COMMENT_DESC |
VARCHAR2 |
2000 |
No |
Any user defined comments for this item |
|
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 |
sim 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 |
sim 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 |
sim 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 |
sim 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 |
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 |
Not used in SIM |
| item_id |
varchar225 |
0 |
1 |
Unique identifier for the item. Either vpn, item_id, or ref_item must be specified in the message. |
RK_SHIPMENT_ITEM |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
The unique identifier of the item that is contained in this carton |
| 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. |
RK_SHIPMENT_ITEM |
QUANTITY_EXPECTED |
NUMBER |
20,4 |
No |
The total number of units expected in this shipment |
| priority_level |
number1 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
Not used in SIM |
| 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 |
Not used in SIM |
| order_line_nbr |
number4 |
0 |
1 |
Not used in RWMS. |
|
null |
null |
null |
null |
Not used in SIM |
| lot_nbr |
varchar212 |
0 |
1 |
Not used in RWMS. |
|
|
|
|
null |
Not used in SIM |
| 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 |
Not used in SIM |
| distro_nbr |
varchar210 |
1 |
1 |
Description is not available. |
|
null |
null |
null |
null |
Not used in SIM |
| distro_doc_type |
varchar21 |
0 |
1 |
Not used in RWMS. |
|
null |
null |
null |
null |
Not used in SIM |
| container_qty |
number6 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
Not used in SIM |
| comments |
varchar22000 |
0 |
1 |
Description is not available. |
RK_SHIPMENT_ITEM |
COMMENT_DESC |
VARCHAR2 |
2000 |
No |
Any user defined comments for this item |
|
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 |
sim 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 |
sim 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 |
sim 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 |
sim 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 |
sim 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 |
sim 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
|
|
|
