|
Tag Name
|
Type
|
Min Occurs
|
Max Occurs
|
Description
|
rms Mapping
For InvAdjustDtl
|
Table Name
|
Column Name
|
API Type
|
Column
Length
|
API
Required
|
API
Description
|
item_id
|
varchar225
|
1
|
1
|
Description is
not available.
|
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.
|
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.
|
inv_adj
|
adj_qty
|
number
|
12
|
Yes
|
Contains the
quantity the inventory was adjusted by.
|
transshipment_nbr
|
varchar230
|
0
|
1
|
Description is
not available.
|
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.
|
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.
|
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.
|
n/a
|
n/a
|
null
|
null
|
No
|
Not used by
RMS.
|
to_trouble_code
|
varchar29
|
0
|
1
|
Description is
not available.
|
n/a
|
n/a
|
null
|
null
|
No
|
Not used by
RMS.
|
from_wip_code
|
varchar29
|
0
|
1
|
Description is
not available.
|
n/a
|
n/a
|
null
|
null
|
No
|
Not used by
RMS.
|
to_wip_code
|
varchar29
|
0
|
1
|
Description is
not available.
|
n/a
|
n/a
|
null
|
null
|
No
|
Not used by
RMS.
|
transaction_code
|
number4
|
0
|
1
|
Description is
not available.
|
n/a
|
n/a
|
null
|
null
|
No
|
Not used by
RMS.
|
user_id
|
varchar230
|
1
|
1
|
Description is
not available.
|
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.
|
inv_adj
|
adj_date
|
RIBDate
|
*
|
Yes
|
Contains the
date on which the inventory adjustment occurred.
|
po_nbr
|
varchar210
|
0
|
1
|
Either a PO or
transfer associated to the inventory adjustment based on the doc_type.
|
ordhead,
tsfhead
|
order_no,
tsf_no
|
null
|
null
|
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.
|
n/a
|
n/a
|
null
|
null
|
No
|
Indicates if
the document is a Purchase Order (P) or a Transfer (T).
|
aux_reason_code
|
varchar24
|
0
|
1
|
Description is
not available.
|
n/a
|
n/a
|
null
|
null
|
No
|
Not used by
RMS.
|
weight
|
number12_4
|
0
|
1
|
Description is
not available.
|
n/a
|
n/a
|
null
|
null
|
No
|
Actual weight
of the inventory that was adjusted.
|
weight_uom
|
varchar24
|
0
|
1
|
Description is
not available.
|
n/a
|
n/a
|
null
|
null
|
No
|
Unit of
measure for weight (e.g. pounds, kilograms)
|
ExtOfInvAdjustDesc:ExtOfInvAdjustDtl
|
*
|
0
|
1
|
Provide an extension hook to
customize InvAdjustDtl.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|