XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ASNOutDesc in RWMS application. |
RWMS's Table Name |
RWMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RWMS's Column Length |
Is Column Required in RWMS's API? |
RWMS's API Description |
schedule_nbr |
number8 |
0 |
1 |
Contains the Schedule identifier number. |
NA |
NA |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Populated with NULL |
auto_receive |
varchar21 |
0 |
1 |
Contains the flag to enable auto_receiving at SIM |
NA |
NA |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Populated with NULL |
to_location |
varchar210 |
0 |
1 |
Contains the location that the shipment will be delivered to. |
ship_dest = manifest |
dest_id |
varchar2 |
10 |
Yes |
* |
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. |
calculated |
Fill table column name. |
varchar2 |
1 |
Yes |
based on ship_dest.dest_id. Warehouse, Store or Finisher. |
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. |
ship_dest |
store_type |
varchar2 |
'C' = company store, 'F' = franchise store. RWMS publishes data on this field but does not use it. |
Yes |
Indicates the store type of the to_location. This will only be populated if to_loc_type is 'S'.
Valid values are |
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. |
ship_dest |
stockholding_ind |
varchar2 |
'Y' = yes, 'N' = no. RWMS publishes data on this field but does not use it. |
Yes |
Only populated if to_loc_type is 'S'. |
from_location |
varchar210 |
1 |
1 |
For transfer and allocation shipments, this field will hold the location from which the shipment was sourced. |
transshipment_setup |
dc_dest_id |
varchar2 |
10 |
Yes |
Gets dc_dest_id from transshipment_setup table |
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. |
NA |
NA |
varchar2 |
1 |
Yes |
Always W |
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. |
NA |
NA |
varchar2 |
1 |
Yes |
Populated with NULL |
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. |
NA |
NA |
varchar2 |
1 |
Yes |
Populated with NULL |
asn_nbr |
varchar230 |
0 |
1 |
Holds the bill of lading number associated with a shipment. |
computed |
* |
varchar2 |
30 |
Yes |
bol_to_upload.bol_nbr concatenated with transshipment.dc_dest_id |
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. |
calculated |
* |
varchar2 |
1 |
No |
C or T |
container_qty |
number6 |
0 |
1 |
Contains the number of boxes associated with the shipment. |
container_item |
container_qty |
number |
6 |
No |
Number of containers of this unit. Will be 1 normally, but greater than 1 to represent unlabeled containers. E.g. unit_qty= 100, container qty= 10 means 10 unlabeled (not in the container table) containers of casepack 10. |
bol_nbr |
varchar217 |
1 |
1 |
Holds the transaction sequence number on the message from the transfer shipment confirmation process. |
bol_to_upload |
bol_nbr |
varchar2 |
17 |
Yes |
Gets the bol_nbr from bol_to_upload table. |
shipment_date |
xs:dateTime |
0 |
1 |
This field contains the date the transfer or PO was shipped. |
manifest |
ship_ts |
RIBDate |
* |
No |
* |
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. |
ship_dest |
lead_time |
RIBDate |
Currently system date + (ship_dest.lead_time/24) |
Yes |
Calculated |
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). |
ship_dest |
address1 |
varchar2 |
240 |
No |
* |
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). |
ship_dest |
address2 |
varchar2 |
240 |
No |
* |
ship_address3 |
varchar2240 |
0 |
1 |
Not used by RMS. |
n/a |
n/a |
varchar2 |
240 |
No |
Populated with NULL |
ship_address4 |
varchar2240 |
0 |
1 |
Not used by RMS. |
n/a |
n/a |
varchar2 |
240 |
No |
Populated with NULL |
ship_address5 |
varchar2240 |
0 |
1 |
Not used by RMS. |
n/a |
n/a |
varchar2 |
240 |
No |
Populated with NULL |
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). |
ship_dest |
city |
varchar2 |
120 |
No |
* |
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). |
ship_dest |
state |
varchar2 |
3 |
No |
* |
ship_zip |
varchar230 |
0 |
1 |
Not used by RMS. |
ship_dest |
zip |
varchar2 |
30 |
No |
* |
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). |
ship_dest |
country_code |
varchar2 |
3 |
No |
* |
trailer_nbr |
varchar212 |
0 |
1 |
Not used by RMS. |
manifest |
trailer_id |
varchar2 |
12 |
Yes |
* |
seal_nbr |
varchar212 |
0 |
1 |
Not used by RMS. |
manifest |
seal_nbr |
varchar2 |
12 |
No |
* |
transshipment_nbr |
varchar230 |
0 |
1 |
Not used by RMS. |
manifest |
transshipment_nbr |
varchar2 |
30 |
No |
* |
ASNOutDistro
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
comments |
varchar22000 |
0 |
1 |
Contains any miscellaneous comments about the shipment. |
n/a |
n/a |
varchar2 |
2000 |
No |
Not used by RWMS. |
carrier_code |
varchar24 |
0 |
1 |
Contains the courier that will deliver the shipment. |
container or trailer |
carrier_code |
varchar2 |
4 |
Yes |
If trailer nbr = NA then container.carrier_code otherwise trailer.carrier code |
carrier_service_code |
varchar26 |
0 |
1 |
Contains the service level code for the courier that will deliver the shipment. |
container |
service_code |
varchar2 |
6 |
Yes |
If trailer nbr = NA the container.service_code otherwise NULL |