XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for SODtlRef 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 |
N/A |
TSF_ALLOCATION |
STORE_ID |
Number |
10 |
Yes |
the unique identifier of the store where this item is will be delivered to. |
loc_type |
varchar21 |
0 |
1 |
N/A |
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 |
N/A |
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 |
N/A |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
values are either "Y" or "N" |
item_id |
varchar225 |
1 |
1 |
N/A |
TSF_ALLOCATION |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
the unique identifier of the item that this allocation is for. |