| item_id |
TR_LTM_ICD_MR |
ID_ITM |
Yes |
Identifies the
item on the inventory adjustment |
| adjustment_reason_code |
TR_LTM_ICD_MR |
RC_CHN |
No |
Contains the
reason for inventory adjustment. This field will only have a value for
saleable inventory types. |
| unit_qty |
TR_LTM_ICD_MR |
QU_ITM |
Yes |
Contains the
quantity the inventory was adjusted by. |
| transshipment_nbr |
n/a |
n/a |
No |
Populated with
an empty value by SIM |
| from_disposition |
n/a |
n/a |
No |
Used to
determine if the adjustment quantity is negative or positive. |
| to_disposition |
n/a |
n/a |
No |
Used to
determine if the adjustment quantity is negative or positive. |
| from_trouble_code |
n/a |
n/a |
No |
Populated with
an empty value by SIM |
| to_trouble_code |
n/a |
n/a |
No |
Populated with
an empty value by SIM |
| from_wip_code |
n/a |
n/a |
No |
Populated with
an empty value by SIM |
| to_wip_code |
n/a |
n/a |
No |
Populated with
an empty value by SIM |
| transaction_code |
n/a |
n/a |
Yes |
Populated with 0
by SIM |
| user_id |
n/a |
n/a |
Yes |
Contains the
user id for the user making the inventory adjustme |
| create_date |
DO_CTL_INV |
TS_CRT_ICD |
Yes |
Contains the
date on which the inventory adjustment occurred |
| po_nbr |
n/a |
n/a |
No |
Populated with
an empty value by SIM |
| doc_type |
n/a |
n/a |
No |
Populated with
an empty value by SIM |
| aux_reason_code |
n/a |
n/a |
No |
Populated with
an empty value by SIM |
| weight |
n/a |
n/a |
No |
Not used by
SIM |
| weight_uom |
n/a |
n/a |
No |
Not used by
SIM |
