| XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ASNOutDesc in SIM application. |
| SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and BDI) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
| schedule_nbr |
number8 |
0 |
1 |
Contains the Schedule identifier number. |
|
|
|
|
No |
Not used by SIM. |
| auto_receive |
varchar21 |
0 |
1 |
Contains the flag to enable auto_receiving at SIM |
|
|
|
|
No |
Not used by SIM. |
| to_location |
varchar210 |
0 |
1 |
Contains the location that the shipment will be delivered to. |
TSF_SHIP, FUL_ORD |
TSF_SHIP.DESTINATION_ID, FUL_ORD.CUSTOMER_ID |
NUMBER, VARCHAR2 |
(10,0), 14 |
Yes |
Contains the location to which the shipment will be delivered. |
| to_loc_type |
varchar21 |
0 |
1 |
This field contains the location type of the to_location field. Valid values are 'S' = store, 'E' = finisher, and 'W' = warehouse. RWMS publishes data on this field but does not use it. |
|
|
|
|
Yes |
Populated by SIM with values depending on the destination type:
C - Customer Order
W (Warehouse) / E (Finisher) / S (Store) - Transfer Shipment |
| to_store_type |
varchar21 |
0 |
1 |
Indicates the store type of the to_location. This will only be populated if to_loc_type is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. RWMS publishes data on this field but does not use it. |
|
|
|
|
Yes |
for Delivery sim sets empty value and for transfer shipment value set as "C" if destination is store other wise empty |
| to_stockholding_ind |
varchar21 |
0 |
1 |
Indicates if the to_location is stockholding or not. Only populated if to_loc_type is 'S'. Valid values are: 'Y' = yes, 'N' = no. RWMS publishes data on this field but does not use it. |
|
|
|
|
Yes |
possibles value are "Y" (Transfer Shipment) and "N" (Customer Order Delivery) |
| from_location |
varchar210 |
1 |
1 |
For transfer and allocation shipments, this field will hold the location from which the shipment was sourced. |
FUL_ORD_DLV,TSF_SHIP |
STORE_ID |
NUMBER |
10 |
Yes |
the identifier of the store that will send the items on the Delivery/Transfer. |
| from_loc_type |
varchar21 |
0 |
1 |
This field contains the location type of the from_location field. Valid values are 'S' = store and 'W' = warehouse. RWMS publishes data on this field but does not use it. |
|
|
|
|
Yes |
Possible value LOC_TYPE_STORE "S" |
| from_store_type |
varchar21 |
0 |
1 |
Indicates the store type of the from_location. This will only be populated if from_location is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. Publications from RWMS will always be NULL for this field. RWMS publishes data on this field but does not use it. |
|
|
|
|
Yes |
possible value STORE_TYPE_COMPANY "C" |
| from_stockholding_ind |
varchar21 |
0 |
1 |
Indicates if the from_location is stockholding or not. Only populated if from_location is 'S'. Valid values are: 'Y' = yes, 'N' = no. Publications from RWMS will always be NULL for this field. RWMS publishes data on this field but does not use it. |
|
|
|
|
Yes |
SIM populates this field as "Y" |
| asn_nbr |
varchar230 |
0 |
1 |
Holds the bill of lading number associated with a shipment. |
FUL_ORD_DLV,TSF_SHIP |
ID |
NUMBER |
12,15 |
Yes |
Identifiers for Customer Order Delivery / Transfer Shipment |
| 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. |
|
|
|
|
Yes |
SIM specifies the ASN type as C (container) |
| container_qty |
number6 |
0 |
1 |
Contains the number of boxes associated with the shipment. |
|
|
|
|
Yes |
Contains the number of boxes associated with the shipment. |
| bol_nbr |
varchar217 |
1 |
1 |
Holds the transaction sequence number on the message from the transfer shipment confirmation process. |
FUL_ORD_DLV,TSF_SHIP |
ID |
NUMBER |
12, 15 |
No |
Unique identifier of a Customer order delivery / transfer |
| shipment_date |
xs:dateTime |
0 |
1 |
This field contains the date the transfer or PO was shipped. |
FUL_ORD_DLV, TSF_SHIP |
DISPATCH_DATE |
DATE |
|
Yes |
The date this delivery was dispatched/ship date of a return/the date the transfer 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 |
Not used by SIM. |
| 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 |
ADDRESS_LINE_1 |
VARCHAR2 |
240 |
No |
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). |
ADDRESS |
ADDRESS_LINE_2 |
VARCHAR2 |
240 |
No |
Address for the destination entity. |
| ship_address3 |
varchar2240 |
0 |
1 |
Not used by RMS. |
ADDRESS |
ADDRESS_LINE_3 |
VARCHAR2 |
240 |
No |
Address for the destination entity |
| ship_address4 |
varchar2240 |
0 |
1 |
Not used by RMS. |
|
|
|
|
No |
Not used by SIM. |
| ship_address5 |
varchar2240 |
0 |
1 |
Not used by RMS. |
|
|
|
|
No |
Not used by SIM. |
| 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 |
CITY |
VARCHAR2 |
120 |
No |
city of the destination |
| 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 |
STATE |
VARCHAR2 |
3 |
No |
state for destination |
| ship_zip |
varchar230 |
0 |
1 |
Not used by RMS. |
ADDRESS |
POSTAL_CODE |
VARCHAR2 |
30 |
No |
Postal code of destination entity |
| 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 |
COUNTRY_ID |
VARCHAR2 |
3 |
No |
country id for the destination address |
| trailer_nbr |
varchar212 |
0 |
1 |
Not used by RMS. |
|
|
|
|
No |
Not used by SIM. |
| seal_nbr |
varchar212 |
0 |
1 |
Not used by RMS. |
|
|
|
|
No |
Not used by SIM. |
| transshipment_nbr |
varchar230 |
0 |
1 |
Not used by RMS. |
|
|
|
|
No |
Not used by SIM. |
|
ASNOutDistro
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
| comments |
varchar22000 |
0 |
1 |
Contains any miscellaneous comments about the shipment. |
FUL_ORD |
COMMENTS |
VARCHAR2 |
2000 |
No |
Comments are alter to 256 character for payload if exceeds the size. No comments are added for transfer shipment. |
| carrier_code |
varchar24 |
0 |
1 |
Contains the courier that will deliver the shipment. |
SHIPMENT_BOL,SHIPMENT_CARRIER |
SHIPMENT_BOL.THIRD_PARTY_NAME,SHIPMENT_CARRIER.CODE |
VARCHAR2 |
240,4 |
Yes |
this field contains the name of the third party/Unique code identifier for a carrier |
| carrier_service_code |
varchar26 |
0 |
1 |
Contains the service level code for the courier that will deliver the shipment. |
SHIPMENT_CARRIER_SERVICE |
CODE |
VARCHAR2 |
6 |
Yes |
Unique identifier that represents the delivery service |
