Application
|
Store Inventory Management
|
Target Name Space
|
http://www.oracle.com/retail/integration/base/bo/StsTsfApvModVo/v1
|
Version
|
1.0
|
Description
|
|
XSD Structure
|
|
|
XML-Schema Name:StsTsfApvModVo
|
Version:16.0.21
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StsTsfApvModVo 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 |
tsf_id |
number15 |
1 |
1 |
Transfer Unique internal identifier. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
store_id |
number10 |
1 |
1 |
Identifier of store requesting the operation. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
StsTsfApvItmMod
|
*
|
0
|
5000
|
Collection of transfer request line items.
|
|
|
|
|
|
|
removed_line_id_col |
number12 |
0 |
5000 |
Collections of removed line items indicated by their identifiers. |
n/a |
n/a |
RIB or/and RSB |
n/a |
Yes |
Fill this description. |
StsTsfApvModNote
|
*
|
0
|
1000
|
Notes associated to the transfer.
|
|
|
|
|
|
|
|
|
XML-Schema Name:StsTsfApvItmMod
|
Version:16.0.21
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StsTsfApvItmMod 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. |
TRANSFER_LINE_ITEM |
ID |
number |
12,0 |
Yes |
unique identifier of the transfer line item |
item_id |
varchar225 |
1 |
1 |
Sku number of the item. This value can not be altered on update. |
TSF_LINE_ITEM |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
Sku number |
quantity |
number20_4 |
1 |
1 |
Quantity to be approved. This value is in standard units. |
TSF_LINE_ITEM |
QUANTITY_APPROVED |
NUMBER |
20,4 |
No |
Approved quantity |
case_size |
number10_2 |
1 |
1 |
Case size associated with the item on this line item. |
TRANSFER_LINE_ITEM |
CASE_SIZE |
number |
10,2 |
No |
pack size |
|
|
XML-Schema Name:StsTsfApvModNote
|
Version:16.0.21
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StsTsfApvModNote 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 |
note |
varchar22000 |
1 |
1 |
The contents of the note. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
|
|