| XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for InvAdjustDtl in SIM application. |
| SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and BDI) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
| item_id |
varchar225 |
1 |
1 |
Description is not available. |
INV_ADJUST_LINE_ITEM, WAREHOUSE_ITEM |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
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. |
INV_ADJUST_REASON |
CODE |
NUMBER |
4 |
Yes |
contains a code to uniquely identify the reason for an inventory adjustment. |
| unit_qty |
number12_4 |
1 |
1 |
Description is not available. |
INV_ADJUST_LINE_ITEM, WAREHOUSE_ITEM |
QUANTITY, QUANTITY_TOTAL, QUANTITY_UNAVAILABLE, QUANTITY_RESERVED |
NUMBER |
(20,4), (12,4) |
Yes |
The quantity of the item. |
| transshipment_nbr |
varchar230 |
0 |
1 |
Description is not available. |
|
|
|
|
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. |
INV_ADJUST_REASON |
DISPOSITION |
NUMBER |
2 |
Yes |
the unique identifier of the disposition that is attached to the reason code. this will determine the from and to inventory dispositions. |
| to_disposition |
varchar24 |
0 |
1 |
Used to fetch the inv_status. Also used
to determine if the adjustment quantity is negative or positive. |
INV_ADJUST_REASON |
DISPOSITION |
NUMBER |
2 |
Yes |
the unique identifier of the disposition that is attached to the reason code. this will determine the from and to inventory dispositions |
| from_trouble_code |
varchar29 |
0 |
1 |
Description is not available. |
INV_ADJUST_REASON |
DISPOSITION |
NUMBER |
2 |
Yes |
the unique identifier of the disposition that is attached to the reason code. this will determine the from and to inventory dispositions. |
| to_trouble_code |
varchar29 |
0 |
1 |
Description is not available. |
|
|
|
|
No |
Populated by SIM with an empty value. |
| from_wip_code |
varchar29 |
0 |
1 |
Description is not available. |
|
|
|
|
No |
Populated by SIM with an empty value. |
| to_wip_code |
varchar29 |
0 |
1 |
Description is not available. |
|
|
|
|
No |
Populated by SIM with an empty value. |
| transaction_code |
number4 |
0 |
1 |
Description is not available. |
|
|
|
|
No |
Populated by SIM with 0. |
| user_id |
varchar230 |
1 |
1 |
Description is not available. |
INV_ADJUST |
APPROVE_USER |
VARCHAR2 |
128 |
No |
The user that approved the adjustment. |
| create_date |
xs:dateTime |
1 |
1 |
Description is not available. |
INV_ADJUST |
CREATE_DATE |
DATE |
|
Yes |
Current date when Inventory adjustment was created |
| po_nbr |
varchar212 |
0 |
1 |
Either a PO or transfer associated to the
inventory adjustment based on the doc_type. |
|
|
|
|
No |
Populated by SIM with an empty value. |
| doc_type |
varchar21 |
0 |
1 |
Description is not available. |
|
|
|
|
No |
Populated by SIM with an empty value. |
| aux_reason_code |
varchar24 |
0 |
1 |
Description is not available. |
|
|
|
|
No |
Not used by SIM. |
| weight |
number12_4 |
0 |
1 |
Description is not available. |
|
|
|
|
No |
Not used by SIM. |
| weight_uom |
varchar24 |
0 |
1 |
Description is not available. |
|
|
|
|
No |
Not used by SIM. |
| unit_cost |
number20_4 |
0 |
1 |
Contains the current unit cost of the
item |
|
|
|
|
No |
Not used by SIM. |
|
InvAdjustUin
|
*
|
0
|
unbounded
|
Collection of UIN(s) associated to the item.
|
|
|
|
|
|
|
