XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for SOStatusDtl 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 |
dest_id |
varchar210 |
1 |
1 |
Contains the location number of the stock order receiving location. |
TSF_ALLOCATION |
STORE_ID |
Number |
10 |
Yes |
the unique identifier of the store where this item is will be delivered to. |
loc_type |
varchar21 |
1 |
1 |
Type of location in the dest_id field. Valid values are: S = Store, W = Warehouse, E = Finisher. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
possible value LOC_TYPE_STORE("S"), |
store_type |
varchar21 |
0 |
1 |
Indicates the store type of the dest_id store. Only populated if loc_type is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
values are STORE_TYPE_COMPANY("C"),
STORE_TYPE_FRANCHISE("F"), |
stockholding_ind |
varchar21 |
0 |
1 |
Indicates if the dest_id store is stockholding or not. Only populated if loc_type is 'S'. Valid values are: 'Y' = yes, 'N' = no. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
possible values "Y" or "N" |
item_id |
varchar225 |
1 |
1 |
Unique identifier for the item. |
TSF_ALLOCATION |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
the unique identifier of the item that this allocation is for. |
original_item_id |
varchar225 |
0 |
1 |
The ID of the item being replaced. Populated only when this record is for a substitute item on a customer order. |
FUL_ORD_LINE_ITEM |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
Item identifier for this line item. |
order_line_nbr |
number3 |
1 |
1 |
Derived as ROWNUM. |
n/a |
n/a |
null |
null |
No |
Not used by SIM |
unit_qty |
number12_4 |
1 |
1 |
The difference beween the number of ITEM units shipped versus the receiving count for the given ITEM. This is subtracted from the document-line-item-unit-count to yield an over/under variance between what a supplier said was shipped and what was counted and received at by the store's staff. |
TSF_ALLOCATION |
QUANTITY |
Number |
20,4 |
No |
this is the quantity of the item in this allocation. |
status |
varchar22 |
1 |
1 |
The status of the stock order. Valid values are: 'DS' - Details Selected, 'DU' - Details Un-Selected, 'NI' - Line Cancellation, 'PP' - Distributed, 'PU' - Un-Distributed, 'RS' - Return To Stock, 'EX' - Expired, 'SR' - Store Reassign, 'SC' - Store Cancellation. |
n/a |
n/a |
null |
'DS' - Details Selected, 'DU' - Details Un-Selected, 'NI' - Line Cancellation, 'PP' - Distributed, 'PU' - Un-Distributed, 'RS' - Return To Stock, 'EX' - Expired, 'SR' - Store Reassign, 'SC' - Store Cancellation. |
Yes |
The status of the stock order. Valid values are SI (stock order status stock increase) SD(Stock order status stock decrease) |
user_id |
varchar230 |
0 |
1 |
Description is not available. |
n/a |
n/a |
null |
null |
No |
Not used by SIM. |
updated_date |
xs:dateTime |
0 |
1 |
Description is not available. |
TSF_ALLOCATION |
DELIVERY_DATE |
DATE |
Fill column length. |
No |
the date that the allocation is expected to be delivered from the warehouse. |