Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For InvAdjustDtl |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
item_id |
varchar225 |
1 |
1 |
Description is not available. |
RK_INV_ADJUSTMENT |
ITEM_ID |
VARCHAR2 |
25 |
No |
Identifies the item on the inventory adjustment. |
adjustment_reason_code |
number4 |
0 |
1 |
Contains the reason for inventory adjustment. This field will only have a value for saleable inventory types. |
RK_INV_ADJUSTMENT |
RK_INV_ADJ_REASON_ID |
NUMBER |
12 |
No |
Contains the reason for the inventory adjustment. This field will have a value only for saleable inventory types. |
unit_qty |
number12_4 |
1 |
1 |
Description is not available. |
RK_INV_ADJUSTMENT |
QUANTITY |
NUMBER |
20 |
No |
Contains the quantity by which the inventory was adjusted. |
transshipment_nbr |
varchar230 |
0 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
No |
Populated by SIM with an empty value. |
from_disposition |
varchar24 |
0 |
1 |
Used to fetch the inv_status. Also used to determine if the adjustment quantity is negative or positive. |
n/a |
n/a |
null |
null |
No |
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. |
n/a |
n/a |
null |
null |
No |
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 |
Populated by SIM with an empty value. |
to_trouble_code |
varchar29 |
0 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
No |
Populated by SIM with an empty value. |
from_wip_code |
varchar29 |
0 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
No |
Populated by SIM with an empty value. |
to_wip_code |
varchar29 |
0 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
No |
Populated by SIM with an empty value. |
transaction_code |
number4 |
0 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
Yes |
Populated by SIM with 0. |
user_id |
varchar230 |
1 |
1 |
Description is not available. |
RK_INV_ADJUSTMENT |
CREATED_BY |
VARCHAR2 |
128 |
No |
Contains the user ID of the user making the inventory adjustment. |
create_date |
xs:dateTime |
1 |
1 |
Description is not available. |
RK_INV_ADJUSTMENT |
CREATE_DATE |
DATE |
|
No |
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. |
n/a |
n/a |
null |
null |
No |
Populated by SIM with an empty value. |
doc_type |
varchar21 |
0 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
No |
Populated by SIM with an empty value. |
aux_reason_code |
varchar24 |
0 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
No |
Populated by SIM with an empty value. |
weight |
number12_4 |
0 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
No |
Not used by SIM. |
weight_uom |
varchar24 |
0 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
No |
Not used by SIM. |
unit_cost |
number20_4 |
0 |
1 |
Contains the current unit cost of the item |
NA |
NA |
NA |
NA |
NA |
NA |
ExtOfInvAdjustDesc:ExtOfInvAdjustDtl
|
*
|
0
|
1
|
Provide an extension hook to customize InvAdjustDtl.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
LocOfInvAdjustDesc:LocOfInvAdjustDtl
|
*
|
0
|
1
|
Provide an extension hook to localize InvAdjustDtl.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|