| XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ASNInDesc in IGS application. |
| IGS's Table Name |
IGS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
IGS's Column Length |
Is Column Required in IGS's API? |
IGS's API Description |
| schedule_nbr |
number8 |
0 |
1 |
Contains the Schedule identifier number. |
RMS.n/a |
n/a |
n/a |
n/a |
No |
Not used by RMS. |
| auto_receive |
varchar21 |
0 |
1 |
Contains the flag to enable auto receiving at SIM. |
RMS.n/a |
n/a |
n/a |
n/a |
No |
Not used by RMS. |
| to_location |
varchar210 |
0 |
1 |
Contains the location that the shipment will be delivered to. RWMS does not utilize this field. |
RMS.shipment |
to_loc |
varchar2 |
10 |
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 does not utilize this field. |
RMS.shipment |
to_loc_type |
varchar2 |
1 |
No |
This field contains the location type of the to_location field. Valid values are 'S' = store, 'E' = finisher, and 'W' = warehouse. RWMS does not utilize this field. |
| 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 does not utilize this field. |
RMS.n/a |
n/a |
n/a |
n/a |
No |
Not used by RMS. |
| 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 does not utilize this.
field. |
RMS.n/a |
n/a |
n/a |
n/a |
No |
Not used by RMS. |
| from_location |
varchar210 |
1 |
1 |
For transfer and allocation shipments, this field will hold the location from which the shipment was sourced. RWMS does not utilize this field. |
RMS.n/a |
n/a |
n/a |
n/a |
No |
Not used by RMS. |
| 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 does not utilize this field. |
RMS.n/a |
n/a |
n/a |
n/a |
No |
Not used by RMS. |
| 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. RWMS does not utilize this field. |
RMS.n/a |
n/a |
n/a |
n/a |
No |
Not used by RMS. |
| 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. RWMS does not utilize this field. |
RMS.n/a |
n/a |
n/a |
n/a |
No |
Not used by RMS. |
| asn_nbr |
varchar230 |
1 |
1 |
Holds the advance shipping notice number associated with a shipment. |
RMS.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). |
RMS.n/a |
n/a |
n/a |
n/a |
Yes |
This field is used to determine the ship origin. If asn_type is C, ship_origin is set to 6 (ASN UCC-128) when inserted in the SHIPMENT table. Otherwise, SHIP_ORIGIN defaults to 0 (ASN Shipment). |
| container_qty |
number6 |
1 |
1 |
Description is not available. |
RMS.n/a |
n/a |
n/a |
n/a |
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. |
RMS.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 |
This field contains the date the transfer or PO was shipped. |
RMS.shipment |
ship_date |
RIBDate |
Fill column length. |
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. |
RMS.shipment |
est_arr_date |
RIBDate |
Fill column length. |
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. |
RMS.n/a |
n/a |
n/a |
n/a |
No |
Not used by RMS. |
| ship_address2 |
varchar2240 |
0 |
1 |
Not used in RWMS. |
RMS.n/a |
n/a |
n/a |
n/a |
No |
Not used by RMS. |
| ship_address3 |
varchar2240 |
0 |
1 |
Not used in RWMS. |
RMS.n/a |
n/a |
n/a |
n/a |
No |
Not used by RMS. |
| ship_address4 |
varchar2240 |
0 |
1 |
Not used in RWMS. |
RMS.n/a |
n/a |
n/a |
n/a |
No |
Not used by RMS. |
| ship_address5 |
varchar2240 |
0 |
1 |
Not used in RWMS. |
RMS.n/a |
n/a |
n/a |
n/a |
No |
Not used by RMS. |
| ship_city |
varchar2120 |
0 |
1 |
Not used in RWMS. |
RMS.n/a |
n/a |
n/a |
n/a |
No |
Not used by RMS. |
| ship_state |
varchar23 |
0 |
1 |
Not used in RWMS. |
RMS.n/a |
n/a |
n/a |
n/a |
No |
Not used by RMS. |
| ship_zip |
varchar230 |
0 |
1 |
Not used in RWMS. |
RMS.n/a |
n/a |
n/a |
n/a |
No |
Not used by RMS. |
| ship_country_id |
varchar23 |
0 |
1 |
Not used in RWMS. |
RMS.n/a |
n/a |
n/a |
n/a |
No |
Not used by RMS. |
| trailer_nbr |
varchar212 |
0 |
1 |
Not used in RWMS. |
RMS.n/a |
n/a |
n/a |
n/a |
No |
Not used by RMS. |
| seal_nbr |
varchar212 |
0 |
1 |
Not used in RWMS. |
RMS.n/a |
n/a |
n/a |
n/a |
No |
Not used by RMS. |
| carrier_code |
varchar24 |
0 |
1 |
Contains the courier that will deliver the shipment. |
RMS.shipment |
courier |
varchar2 |
250 |
No |
Contains the courier that will deliver the shipment. |
| carrier_service_code |
varchar26 |
0 |
1 |
Contains the service level code for the courier that will deliver the shipment. |
RMS.n/a |
n/a |
n/a |
n/a |
No |
Not used in RMS. |
| vendor_nbr |
varchar210 |
1 |
1 |
Contains the supplier who will provide the merchandise specified in the order. 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. |
RMS.ordhead |
supplier |
varchar2 |
10 |
Yes |
Contains the supplier who will provide the merchandise specified in the order. This element is used to validate the order numbers 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 |
Indicates the payment terms for freight charges associated with the
order. 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. |
RMS.ordhead |
ship_pay_method |
varchar2 |
2 |
No |
Indicates the payment terms for freight charges associated with the
order. 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 |
Contains any comments about the shipment. |
RMS.n/a |
n/a |
n/a |
n/a |
No |
Not used by RMS. |
