|
|
|
Application
|
Retail
Merchandising System
|
|
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.1
|
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
|
|
to_location
|
varchar210
|
1
|
1
|
Not used in RWMS
|
shipment
|
to_loc
|
varchar2
|
10
|
Yes
|
Contains the
location that the shipment will be delivered to.
|
|
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 will
be set to '6' (ASN UCC-128) upon insert to the SHIPMENT table. Otherwise,
SHIP_ORIGIN is defaulted 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 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.
|
|
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
|
|
|
|
XML-Schema
Name:ASNInPO
|
Version:13.1.1
|
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 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.
|
|
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
|
|
|
|
XML-Schema
Name:ASNInCtn
|
Version:13.1.1
|
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 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.
|
|
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
|
|
|
|
XML-Schema
Name:ASNInItem
|
Version:13.1.1
|
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 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.
|
|
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. Either
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 Retek item number, found on the
ITEM_SUPPLIER table. Either 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. Either 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
|
|
|
|
XML-Schema Name:ExtOfASNInItem
|
Version:13.1.1
|
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:ExtOfASNInCtn
|
Version:13.1.1
|
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:ASNInItem
|
Version:13.1.1
|
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 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.
|
|
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. Either
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 Retek item number, found on the
ITEM_SUPPLIER table. Either 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. Either 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
|
|
|
|
XML-Schema
Name:ExtOfASNInItem
|
Version:13.1.1
|
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:ExtOfASNInPO
|
Version:13.1.1
|
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:ExtOfASNInDesc
|
Version:13.1.1
|
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
|
|
|
