Application
|
Store Inventory Management
|
Target Name Space
|
http://www.oracle.com/retail/integration/base/bo/TsfShipCtnModVo/v1
|
Version
|
1.0
|
Description
|
|
XSD Structure
|
|
|
XML-Schema Name:TsfShipCtnModVo
|
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 TsfShipCtnModVo 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 |
tsf_ship_carton_id |
number15 |
1 |
1 |
The unique transfer shipment container identifier. |
TSF_SHIP_CARTON |
ID |
NUMBER |
15 |
Yes |
The unique identifier for the shipment carton/container |
external_id |
varchar2128 |
0 |
1 |
The external identifier. |
TSF_SHIP_CARTON |
EXTERNAL_ID |
VARCHAR2 |
128 |
No |
Fill this description. |
hierarchy_level |
tsf_hierarchy_level |
1 |
1 |
The container restricted hierarchy level. Valid values are NONE, DEPT, CLASS, SUBCLASS. |
TSF_SHIP_CARTON |
RESTRICTION_LEVEL |
NUMBER |
4 |
Yes |
The hierarchy restriction level for items in a container |
TsfShipCtnSizeMod
|
*
|
0
|
1
|
The container size.
|
|
|
|
|
|
|
weight |
number20_4 |
0 |
1 |
The weight of the container. |
TSF_SHIP_CARTON |
WEIGHT |
NUMBER |
12,4 |
No |
The weight of the container |
tracking_number |
varchar2128 |
0 |
1 |
The tracking number for the container. |
TSF_SHIP_CARTON |
TRACKING_NUMBER |
VARCHAR2 |
128 |
No |
The Tracking number for the container |
use_available |
xs:boolean |
1 |
1 |
True if container uses only available inventory, false otherwise. |
TSF_SHIP_CARTON |
USE_AVAILABLE |
VARCHAR2 |
1 |
Yes |
value of Y indicates carton will use only available inventory, N means carton will use unavailable inventory |
TsfShipCtnItmMod
|
*
|
0
|
1000
|
Collection of line items.
|
|
|
|
|
|
|
removed_line_id_col |
number12 |
0 |
1000 |
Collection of carton item identifiers to remove from the carton. |
TSF_SHIP_LINE_ITEM |
ID |
NUMBER |
15 |
Yes |
The unique identifier for the line item |
TsfShipCtnModNote
|
*
|
0
|
1000
|
Collection of transfer shipment notes that will be added to the transfer shipment.
|
|
|
|
|
|
|
|
|
XML-Schema Name:TsfShipCtnSizeMod
|
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 TsfShipCtnSizeMod 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 |
id |
number15 |
1 |
1 |
The unique carton size identifier. |
SHIPMENT_CARTON_DIM |
ID |
NUMBER |
12 |
Yes |
shipment carton dimension unique identifier |
store_id |
number10 |
0 |
1 |
The unique store identifier. |
SHIPMENT_CARTON_DIM |
STORE_ID |
NUMBER |
10 |
Yes |
Store identifier. |
description |
varchar2128 |
0 |
1 |
The description of the dimensions. |
SHIPMENT_CARTON_DIM |
DESCRIPTION |
VARCHAR2 |
120 |
Yes |
The carton dimensions description |
height |
number20_4 |
0 |
1 |
The height of the carton. |
SHIPMENT_CARTON_DIM |
HEIGHT |
NUMBER |
12,4 |
Yes |
The height of the carton. |
width |
number20_4 |
0 |
1 |
The width of the carton. |
SHIPMENT_CARTON_DIM |
WIDTH |
NUMBER |
12,4 |
Yes |
Width of the container. |
length |
number20_4 |
0 |
1 |
The length of the carton. |
SHIPMENT_CARTON_DIM |
LENGTH |
NUMBER |
12,4 |
Yes |
length of the shipment carton |
unit_of_measure |
varchar2128 |
1 |
1 |
Unit of measure for the measurements. |
SHIPMENT_CARTON_DIM |
UOM |
VARCHAR2 |
4 |
Yes |
Unit of measure. |
|
|
XML-Schema Name:TsfShipCtnItmMod
|
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 TsfShipCtnItmMod 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_item_id |
number15 |
0 |
1 |
The unique line item identifier. If not included, means attempt to add a new line item, otherwise this will replace a current existing line item. |
TSF_SHIP_LINE_ITEM |
ID |
NUMBER |
15 |
Yes |
The unique identifier for the line item |
item_id |
varchar225 |
1 |
1 |
The unique identifier of the sku. |
TSF_SHIP_LINE_ITEM |
ITEM_ID |
NUMBER |
25 |
Yes |
The item identifier |
case_size |
number10_2 |
0 |
1 |
Case size of the item. |
QUANTITY |
CASE_SIZE |
NUMBER |
12,4 |
No |
Pack size of the item |
quantity |
number10 |
1 |
1 |
Quantity to be shipped. |
TSF_SHIP_LINE_ITEM |
QUANTITY |
NUMBER |
20,4 |
Yes |
Quantity to be shipped |
shipment_reason_id |
number15 |
0 |
1 |
The identifier of the reason for the item shipment. |
TSF_SHIP_LINE_ITEM |
SHIPMENT_REASON_ID |
NUMBER |
15 |
No |
The shipment reason identifier |
transfer_id |
number12 |
0 |
1 |
The document id associated with this item and quantity. If this is empty, the item will be added to the adhoc document. |
TSF |
ID |
NUMBER |
15 |
No |
Fill this description. |
uin_col |
varchar2128 |
0 |
5000 |
Collection of all the unique identifiers/serial numbers associated with the line item. |
ITEM_UIN |
UIN |
VARCHAR2 |
128 |
Yes |
Unique Identification Number |
removed_uin_col |
varchar2128 |
0 |
5000 |
Collection of unique identifier numbers to remove from the line item. |
ITEM_UIN |
UIN |
VARCHAR2 |
128 |
Yes |
Unique identification number. |
StrInvExtAttDesc:StrInvExtAttDesc
|
*
|
0
|
5000
|
Collection of extended attributes associated with the line item.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
removed_ext_att_col |
varchar2128 |
0 |
5000 |
Collection of extended attributes associated with the line item to be removed. |
TSF_SHIP_LINE_ITEM_ATT |
BARCODE |
VARCHAR2 |
128 |
Yes |
Extended attribute barcode. |
|
|
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:TsfShipCtnModNote
|
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 TsfShipCtnModNote 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 |
0 |
1 |
Note associated to the vendor shipment. |
NOTES. |
TEXT |
VARCHAR2 |
2000 |
No |
Notes / Comments added to shipment. |
|
|