XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StrAdjItmMod in SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
line_id |
number12 |
0 |
1 |
Unique Identifier. If left null, indicates a new line item, otherwise indicates the line item to modify. |
INV_ADJUST_LINE_ITEM |
ID |
VARCHAR2 |
25 |
Yes |
The item identifier. |
item_id |
varchar225 |
1 |
1 |
Sku number of the item. This value can not be altered on update. |
INV_ADJUST_LINE_ITEM |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
The item identifier. |
reason_id |
number12 |
1 |
1 |
Store adjustment reason identifier. This value can not be altered on update. |
INV_ADJUST_LINE_ITEM |
INV_ADJUST_REASON_ID |
NUMBER |
12,0 |
Yes |
The identifier of the associated inventory adjustment reason code. |
quantity |
number20_4 |
1 |
1 |
Quantity of the adjustment. This value is in standard units. |
INV_ADJUST_LINE_ITEM |
QUANTITY |
NUMBER |
20,4 |
Yes |
The quantity of the item. |
case_size |
number10_2 |
1 |
1 |
Case size associated with the item on this line item. |
INV_ADJUST_LINE_ITEM |
CASE_SIZE |
NUMBER |
10,2 |
Yes |
A case size of the item. |
added_uin_col |
varchar2128 |
0 |
100 |
Unique Identifier Numbers to add to the line item. |
|
|
|
|
Yes |
Serial numbers to add to line item |
removed_uin_col |
varchar2128 |
0 |
1000 |
Unique Identifier Numbers to remove from the line item. |
|
|
|
|
Yes |
Removed Serail numbers |
StrInvExtAttDesc:StrInvExtAttDesc
|
*
|
0
|
1000
|
Collection of extended attributes associated to the line item, either added or updated external attributes.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
removed_ext_att_col |
varchar2128 |
0 |
1000 |
Contains barcodes associated to the extended attribute scan to be deleted. All occurrences will be deleted. |
NA |
NA |
NA |
NA |
NA |
NA |