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) |