| XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for InvAdjustDtl 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 |
| item_id |
varchar225 |
1 |
1 |
Description is not available. |
RMS.inv_adj |
item_id |
varchar2 |
25 |
Yes |
Unique identifier for the item. |
| adjustment_reason_code |
number4 |
0 |
1 |
Contains the reason for inventory
adjustment. This field will only have a value for saleable
inventory types. |
RMS.inv_adj |
reason |
number |
4 |
No |
Contains the reason for inventory adjustment. This field will only have a value for saleable inventory types. |
| unit_qty |
number12_4 |
1 |
1 |
Description is not available. |
RMS.inv_adj |
adj_qty |
number |
12 |
Yes |
Contains the quantity by which the inventory was adjusted. |
| transshipment_nbr |
varchar230 |
0 |
1 |
Description is not available. |
RMS.n/a |
n/a |
null |
null |
No |
Not used by RMS. |
| from_disposition |
varchar24 |
0 |
1 |
Used to fetch the inv_status. Also used
to determine if the adjustment quantity is negative or positive. |
RMS.inv_status_codes |
inv_status_code |
null |
null |
No |
Used to fetch the inv_status. Also used to determine if the adjustment quantity is negative or positive. |
| to_disposition |
varchar24 |
0 |
1 |
Used to fetch the inv_status. Also used
to determine if the adjustment quantity is negative or positive. |
RMS.inv_status_codes |
inv_status_code |
null |
null |
No |
Used to fetch the inv_status. Also used to determine if the adjustment quantity is negative or positive. |
| from_trouble_code |
varchar29 |
0 |
1 |
Description is not available. |
RMS.n/a |
n/a |
null |
null |
No |
Not used by RMS. |
| to_trouble_code |
varchar29 |
0 |
1 |
Description is not available. |
RMS.n/a |
n/a |
null |
null |
No |
Not used by RMS. |
| from_wip_code |
varchar29 |
0 |
1 |
Description is not available. |
RMS.n/a |
n/a |
null |
null |
No |
Not used by RMS. |
| to_wip_code |
varchar29 |
0 |
1 |
Description is not available. |
RMS.n/a |
n/a |
null |
null |
No |
Not used by RMS. |
| transaction_code |
number4 |
0 |
1 |
Description is not available. |
RMS.n/a |
n/a |
null |
null |
No |
Not used by RMS. |
| user_id |
varchar230 |
1 |
1 |
Description is not available. |
RMS.inv_adj |
user_id |
varchar2 |
30 |
Yes |
Contains the user ID for the user making the inventory adjustment. |
| create_date |
xs:dateTime |
1 |
1 |
Description is not available. |
RMS.inv_adj |
adj_date |
RIBDate |
* |
Yes |
Contains the date on which the inventory adjustment occurred. |
| po_nbr |
varchar212 |
0 |
1 |
Either a PO or transfer associated to the
inventory adjustment based on the doc_type. |
RMS.ordhead, tsfhead |
order_no, tsf_no |
number |
12 |
No |
Either a PO or transfer associated to the inventory adjustment based on the doc_type. |
| doc_type |
varchar21 |
0 |
1 |
Description is not available. |
RMS.n/a |
n/a |
null |
null |
No |
Indicates whether the document is a Purchase Order (P) or a Transfer (T). |
| aux_reason_code |
varchar24 |
0 |
1 |
Description is not available. |
RMS.n/a |
n/a |
null |
null |
No |
Not used by RMS. |
| weight |
number12_4 |
0 |
1 |
Description is not available. |
RMS.n/a |
n/a |
null |
null |
No |
Actual weight of the inventory that was adjusted. |
| weight_uom |
varchar24 |
0 |
1 |
Description is not available. |
RMS.n/a |
n/a |
null |
null |
No |
Unit of measure for weight (such as pounds or kilograms). |
| unit_cost |
number20_4 |
0 |
1 |
Contains the current unit cost of the
item |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
|
InvAdjustUin
|
*
|
0
|
unbounded
|
Collection of UIN(s) associated to the item.
|
|
|
|
|
|
|
