Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ASNOutDesc |
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 |
Contains the location that the shipment will be delivered to. |
TRANSFER, RETURN |
RECEIVING_STORE_ID, SOURCE_ID |
VARCHAR2 |
128 |
Yes |
Contains the location to which the shipment will be delivered. |
from_location |
varchar210 |
1 |
1 |
For transfer and allocation shipments, this field will hold the location from which the shipment was sourced. |
TRANSFER, RETURN |
SENDING_STORE_ID, STORE_ID |
NUMBER |
10 |
Yes |
For transfer and return to warehouse/external finisher shipments, this field holds the location from which the shipment was sourced. |
asn_nbr |
varchar230 |
0 |
1 |
Holds the bill of lading number associated with a shipment. |
TRANSFER, RETURN |
ID, EXTERNAL_ID |
NUMBER |
12 |
No |
Unique identifier of a return/transfer OR external identifier. |
asn_type |
varchar21 |
0 |
1 |
Not used by RMS. Set to C for container when ship to location is a store, T for tare when ship to location is a warehouse. |
|
|
|
|
No |
SIM specifies the ASN type as C (container) |
container_qty |
number6 |
0 |
1 |
Contains the number of boxes associated with the shipment. |
|
|
|
|
No |
Contains the number of boxes associated with the shipment. SIM sets the constant value 1. |
bol_nbr |
varchar217 |
1 |
1 |
Holds the transaction sequence number on the message from the transfer shipment confirmation process. |
TRANSFER, RETURN |
ID, EXTERNAL_ID |
NUMBER |
12 |
No |
Unique identifier of a return/transfer OR external identifier. |
shipment_date |
xs:dateTime |
0 |
1 |
This field contains the date the transfer or PO was shipped. |
TRANSFER, RETURN |
SHIP_DATE |
DATE |
|
No |
This field contains the date on which the transfer or return 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. |
|
|
|
|
No |
Populated by SIM with a null value. |
ship_address1 |
varchar2240 |
0 |
1 |
Value of addr.add_1 for store/warehouse number in addr.key_value_1 and addr.module 'ST' (if to_loc_type is store) or 'WH' (if to_loc_type is warehouse) |
ADDRESS_DETAIL |
ADD_1 |
VARCHAR2 |
240 |
Yes |
First Address. |
ship_address2 |
varchar2240 |
0 |
1 |
Value of addr.add_2 for store/warehouse number in addr.key_value_1 and addr.module 'ST' (if to_loc_type is store) or 'WH' (if to_loc_type is warehouse) |
|
|
|
|
No |
Populated by SIM with an empty value. |
ship_address3 |
varchar2240 |
0 |
1 |
Not used by RMS. |
|
|
|
|
No |
Populated by SIM with an empty value. |
ship_address4 |
varchar2240 |
0 |
1 |
Not used by RMS. |
|
|
|
|
No |
Populated by SIM with an empty value. |
ship_address5 |
varchar2240 |
0 |
1 |
Not used by RMS. |
|
|
|
|
No |
Populated by SIM with an empty value. |
ship_city |
varchar2120 |
0 |
1 |
Value of addr.city for store/warehouse number in addr.key_value_1 and addr.module 'ST' (if to_loc_type is store) or 'WH' (if to_loc_type is warehouse) |
ADDRESS_DETAIL |
CITY |
VARCHAR2 |
120 |
Yes |
|
ship_state |
varchar23 |
0 |
1 |
Value of addr.state for store/warehouse number in addr.key_value_1 and addr.module 'ST' (if to_loc_type is store) or 'WH' (if to_loc_type is warehouse) |
ADDRESS_DETAIL |
STATE |
VARCHAR2 |
3 |
No |
|
ship_zip |
varchar230 |
0 |
1 |
Not used by RMS. |
|
|
|
|
No |
Populated by SIM with an NULL value. |
ship_country_id |
varchar23 |
0 |
1 |
Value of addr.country_id for store/warehouse number in addr.key_value_1 and addr.module 'ST' (if to_loc_type is store) or 'WH' (if to_loc_type is warehouse) |
ADDRESS_DETAIL |
COUNTRY_ID |
VARCHAR2 |
3 |
Yes |
|
trailer_nbr |
varchar212 |
1 |
1 |
Not used by RMS. |
|
|
|
|
No |
Populated by SIM with an empty value. |
seal_nbr |
varchar212 |
0 |
1 |
Not used by RMS. |
|
|
|
|
No |
Populated by SIM with an empty value. |
carrier_code |
varchar24 |
1 |
1 |
Contains the courier that will deliver the shipment. |
|
|
|
|
No |
Populated by SIM with an empty value. |
transshipment_nbr |
varchar230 |
0 |
1 |
Not used by RMS. |
|
|
|
|
No |
Populated by SIM with an empty value. |
ASNOutDistro
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
comments |
varchar22000 |
0 |
1 |
Contains any miscellaneous comments about the shipment. |
TRANSFER, RETURN |
COMMENTS, TRANSFER_COMMENTS |
VARCHAR2 |
2000, 255 |
No |
Comment or short description entered by the creator or processor of the return/transfer. |
ExtOfASNOutDesc:ExtOfASNOutDesc
|
*
|
0
|
1
|
Provide an extension hook to customize ASNOutDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
LocOfASNOutDesc:LocOfASNOutDesc
|
*
|
0
|
1
|
Provide an extension hook to localize ASNOutDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|