XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for InvAdjustDtl in RWMS application. |
RWMS's Table Name |
RWMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RWMS's Column Length |
Is Column Required in RWMS's API? |
RWMS's API Description |
item_id |
varchar225 |
1 |
1 |
Description is not available. |
inv_adjustment_to_upload |
item_id |
varchar2 |
25 |
Yes |
Uniquely identifies the item. May consist of some combination of SKU, style, color, size, etc. |
adjustment_reason_code |
number4 |
0 |
1 |
Contains the reason for inventory
adjustment. This field will only have a value for saleable
inventory types. |
inv_adjustment_to_upload |
adjustment_reason_code |
number |
2 |
Yes |
Identifies the type of inventory adjustments that was performed |
unit_qty |
number12_4 |
1 |
1 |
Description is not available. |
inv_adjustment_to_upload |
unit_qty |
number |
12,4 |
Yes |
Number of individual units. |
transshipment_nbr |
varchar230 |
0 |
1 |
Description is not available. |
inv_adjustment_to_upload |
transshipment_nbr |
varchar2 |
30 |
Yes |
Transshipment number on the inventory. |
from_disposition |
varchar24 |
0 |
1 |
Used to fetch the inv_status. Also used
to determine if the adjustment quantity is negative or positive. |
inv_adjustment_to_upload |
from_disposition |
varchar2 |
4 |
Yes |
From Disposition Inventory Code |
to_disposition |
varchar24 |
0 |
1 |
Used to fetch the inv_status. Also used
to determine if the adjustment quantity is negative or positive. |
inv_adjustment_to_upload |
to_disposition |
varchar2 |
4 |
Yes |
To Disposition Inventory Code |
from_trouble_code |
varchar29 |
0 |
1 |
Description is not available. |
inv_adjustment_to_upload |
from_trouble_code |
varchar2 |
9 |
Yes |
* |
to_trouble_code |
varchar29 |
0 |
1 |
Description is not available. |
inv_adjustment_to_upload |
to_trouble_code |
varchar2 |
9 |
Yes |
* |
from_wip_code |
varchar29 |
0 |
1 |
Description is not available. |
inv_adjustment_to_upload |
from_wip_code |
varchar2 |
9 |
Yes |
* |
to_wip_code |
varchar29 |
0 |
1 |
Description is not available. |
inv_adjustment_to_upload |
to_wip_code |
varchar2 |
9 |
Yes |
* |
transaction_code |
number4 |
0 |
1 |
Description is not available. |
inv_adjustment_to_upload |
transaction_code |
number |
4 |
Yes |
Indicates the positive/negative orientation of the upload |
user_id |
varchar230 |
1 |
1 |
Description is not available. |
inv_adjustment_to_upload |
user_id |
varchar2 |
30 |
Yes |
A unique identifier for a user of the WMS. |
create_date |
xs:dateTime |
1 |
1 |
Description is not available. |
inv_adjustment_to_upload |
create_date |
RIBDate |
Date |
Yes |
Date and Time record created |
po_nbr |
varchar212 |
0 |
1 |
Either a PO or transfer associated to the
inventory adjustment based on the doc_type. |
inv_adjustment_to_upload |
po_nbr |
varchar2 |
12 |
Yes |
PO number associated with adjustment |
doc_type |
varchar21 |
0 |
1 |
Description is not available. |
po |
doc_type |
varchar2 |
1 |
Yes |
Document Type |
aux_reason_code |
varchar24 |
0 |
1 |
Description is not available. |
inv_adjustment_to_upload |
aux_reason_code |
varchar2 |
4 |
Yes |
Auxilliary Reason Code |
weight |
number12_4 |
0 |
1 |
Description is not available. |
inv_adjustment_to_upload |
weight_adjustment |
number |
12,4 |
No |
The weight adjustment of an item |
weight_uom |
varchar24 |
0 |
1 |
Description is not available. |
* |
* |
varchar2 |
4 |
No |
If weight_adjustment is NOT NULL uses SCP sys_weight_uom value. |
unit_cost |
number20_4 |
0 |
1 |
Contains the current unit cost of the
item |
* |
* |
* |
* |
Yes |
* |
InvAdjustUin
|
*
|
0
|
unbounded
|
Collection of UIN(s) associated to the item.
|
|
|
|
|
|
|