Application
|
Store Inventory Management
|
Target Name Space
|
http://www.oracle.com/retail/integration/base/bo/TsfDelvCtnModVo/v1
|
Version
|
1.0
|
Description
|
|
XSD Structure
|
|
|
XML-Schema Name:TsfDelvCtnModVo
|
Version:16.0.030
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for TsfDelvCtnModVo 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 |
delivery_id |
number15 |
1 |
1 |
Transfer delivery unique identifier. |
TSF_DELV_CARTON |
TSF_DELV_ID |
NUMBER |
15 |
Yes |
Transfer delivery unique identifier. |
store_id |
number10 |
1 |
1 |
Store unique identifier. |
TSF_DELV_CARTON |
STORE_ID |
NUMBER |
10 |
Yes |
Store unique identifier. |
carton_id |
number15 |
1 |
1 |
The unique identifier for the transfer delivery container. |
TSF_DELV_CARTON |
ID |
NUMBER |
15 |
Yes |
Container unique identifier. |
external_id |
varchar2128 |
0 |
1 |
Container external identifier. |
TSF_DELV_CARTON |
EXTERNAL_ID |
VARCHAR2 |
128 |
No |
The external carton identifier |
reference_id |
varchar2128 |
0 |
1 |
The reference identifier. |
TSF_DELV_CARTON |
REFERENCE_ID |
VARCHAR2 |
128 |
No |
A reference identifier. |
damaged_reason |
varchar2128 |
0 |
1 |
The reason for container damage. |
TSF_DELV_CARTON |
DAMAGED_REASON |
VARCHAR2 |
128 |
No |
The reason for container damage. |
serial_code |
number18 |
0 |
1 |
Serial code. |
TSF_DELV_CARTON |
SERIAL_CODE |
NUMBER |
18 |
No |
A Serial code associated to the container. |
tracking_number |
varchar2128 |
0 |
1 |
A tracking number for the container. |
TSF_DELV_CARTON |
TRACKING_NUMBER |
VARCHAR2 |
128 |
No |
The Tracking number for the container. |
damage_remaining |
xs:boolean |
1 |
1 |
Indicates all remaining quantities should be damaged on final receipt. |
TSF_DELV_CARTON |
DAMAGE_REMAINING |
VARCHAR2 |
1 |
Yes |
Indicates all remaining quantities should be damaged on final receipt. |
receive_shopfloor |
xs:boolean |
1 |
1 |
Y indicates if the stock would be received at shop floor otherwise it is received in back room. |
TSF_DELV_CARTON |
RECEIVE_AT_SHOP_FLOOR |
VARCHAR2 |
1 |
Yes |
True indicates the stock should be received at shop floor, false indicates it should be received in a back room. |
TsfDelvCtnItmMod
|
*
|
0
|
5000
|
Collection of items within the container.
|
|
|
|
|
|
|
TsfDelvCtnModNote
|
*
|
0
|
1000
|
Notes associated to the vendor delivery.
|
|
|
|
|
|
|
|
|
XML-Schema Name:TsfDelvCtnItmMod
|
Version:16.0.030
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for TsfDelvCtnItmMod 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 |
line_id |
number15 |
0 |
1 |
Line item unique identifier. If left blank, the item will be added to the delivery container. |
TSF_DELV_LINE_ITEM |
ID |
NUMBER |
15 |
Yes |
transfer delivery Line item identifier |
item_id |
varchar225 |
1 |
1 |
SKU number. |
TSF_DELV_LINE_ITEM |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
SKU number. |
case_size |
number10_2 |
0 |
1 |
Case size associated with the item. |
TSF_DELV_LINE_ITEM |
CASE_SIZE |
NUMBER |
10,2 |
No |
Case size associated with the item. |
quantity_received |
number20_4 |
0 |
1 |
The total number of units received in this transfer delivery. |
TSF_DELV_LINE_ITEM |
QUANTITY_RECEIVED |
NUMBER |
20,4 |
Yes |
The total number of units received in this transfer delivery. |
quantity_damaged |
number20_4 |
0 |
1 |
The total number of units that were damaged when the transfer delivery was received. |
TSF_DELV_LINE_ITEM |
QUANTITY_DAMAGED |
NUMBER |
20,4 |
No |
The total number of units that were damaged when the transfer delivery was received. |
TsfDelvUinMod
|
*
|
0
|
5000
|
Collection of all the Unique Identification Numbers associated with the line item.
|
|
|
|
|
|
|
StrInvExtAttDesc:StrInvExtAttDesc
|
*
|
0
|
1000
|
Collection of extended attributes associated with the line item, either added or updated external attributes.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
removed_ext_att_col |
varchar2128 |
0 |
1000 |
Collection of extended attributes associated with the line item to be removed. |
TSF_DELV_LINE_ITEM_ATT |
BARCODE |
VARCHAR2 |
128 |
Yes |
Extended attribute barcode. |
|
|
XML-Schema Name:TsfDelvUinMod
|
Version:16.0.030
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for TsfDelvUinMod 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 |
uin |
varchar2128 |
1 |
1 |
Unique serial number. |
ITEM_UIN |
UIN |
VARCHAR2 |
128 |
Yes |
Unique serial number |
received |
xs:boolean |
1 |
1 |
Indicates if the item is received. |
TSF_DELV_LINE_ITEM_UIN |
RECEIVED |
VARCHAR2 |
1 |
Yes |
Indicates if the item is received. |
damaged |
xs:boolean |
1 |
1 |
Indicates if the item is damaged. |
TSF_DELV_LINE_ITEM_UIN |
DAMAGED |
VARCHAR2 |
1 |
No |
Indicates if the item is damaged. |
|
|
XML-Schema Name:StrInvExtAttDesc
|
Version:16.0.030
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StrInvExtAttDesc 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 |
barcode |
varchar2128 |
1 |
1 |
Barcode data representation of the associated GS1 international code standards and their values. |
TSF_SHIP_LINE_ITEM_ATT,TSF_DELV_LINE_ITEM_ATT,STOCK_COUNT_LINE_ITEM_ATT,RTV_SHIP_LINE_ITEM_ATT,INV_ADJUST_LINE_ITEM_ATT,FUL_ORD_DLV_LINE_ITEM_ATT,DSD_LINE_ITEM_ATT |
BARCODE |
VARCHAR2 |
128 |
Yes |
Extended attribute barcode. |
quantity |
number10 |
1 |
1 |
Number of occurrences of the extended attribute scanned on the line item. |
TSF_SHIP_LINE_ITEM_ATT,TSF_DELV_LINE_ITEM_ATT,STOCK_COUNT_LINE_ITEM_ATT,RTV_SHIP_LINE_ITEM_ATT,INV_ADJUST_LINE_ITEM_ATT,FUL_ORD_DLV_LINE_ITEM_ATT,DSD_LINE_ITEM_ATT |
QUANTITY |
NUMBER |
12 |
Yes |
Extended attribute quantity. |
StrInvCodVal
|
*
|
0
|
10
|
Collection of code-value pairs that contains the broken out information from within the barcode.
|
|
|
|
|
|
|
|
|
XML-Schema Name:TsfDelvCtnModNote
|
Version:16.0.030
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for TsfDelvCtnModNote 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 |
note |
varchar22000 |
1 |
1 |
Note associated to the transfer delivery. |
NOTES |
TEXT |
VARCHAR2 |
2000 |
No |
Note associated to the transfer delivery. |
|
|