| item_id |
inv_adj |
item_id |
Yes |
Unique
identifier for the item. |
| adjustment_reason_code |
inv_adj |
reason |
No |
Contains the
reason for inventory adjustment. This field will only have a value for
saleable inventory types. |
| unit_qty |
inv_adj |
adj_qty |
Yes |
Contains the
quantity the inventory was adjusted by. |
| transshipment_nbr |
n/a |
n/a |
No |
Not used by
RMS. |
| from_disposition |
inv_status_codes |
inv_status_code |
No |
Used to fetch
the inv_status. Also used to determine if the adjustment quantity is
negative or positive. |
| to_disposition |
inv_status_codes |
inv_status_code |
No |
Used to fetch
the inv_status. Also used to determine if the adjustment quantity is
negative or positive. |
| from_trouble_code |
n/a |
n/a |
No |
Not used by
RMS. |
| to_trouble_code |
n/a |
n/a |
No |
Not used by
RMS. |
| from_wip_code |
n/a |
n/a |
No |
Not used by
RMS. |
| to_wip_code |
n/a |
n/a |
No |
Not used by
RMS. |
| transaction_code |
n/a |
n/a |
No |
Not used by
RMS. |
| user_id |
inv_adj |
user_id |
Yes |
Contains the
user id for the user making the inventory adjustment. |
| create_date |
inv_adj |
adj_date |
Yes |
Contains the
date on which the inventory adjustment occurred. |
| po_nbr |
ordhead, tsfhead |
order_no, tsf_no |
No |
Either a PO or
transfer associated to the inventory adjustment based on the
doc_type. |
| doc_type |
n/a |
n/a |
No |
Indicates if the
document is a Purchase Order (P) or a Transfer (T). |
| aux_reason_code |
n/a |
n/a |
No |
Not used by
RMS. |
| weight |
n/a |
n/a |
No |
Actual weight of
the inventory that was adjusted. |
| weight_uom |
n/a |
n/a |
No |
Unit of measure
for weight (e.g. pounds, kilograms) |
