XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for SODesc 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 |
distro_nbr |
varchar212 |
1 |
1 |
mapped to DO_CTL_INV.ID_ICD as well.Not Yet Available |
TSF |
EXTERNAL_ID |
RIB or/and RSB |
VARCHAR2(128 BYTE) |
Yes |
Fill this description. |
document_type |
varchar21 |
1 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
dc_dest_id |
varchar210 |
1 |
1 |
mapped to DO_CTL_INV.ID_PRTY_TO_ICD as well. Not Yet Available |
TSF_ALLOCATION |
SOURCE_ID |
RIB or/and RSB |
NUMBER(10,0) |
No |
Contains the location number of the stock order receiving location. |
loc_type |
varchar21 |
1 |
1 |
Type of location in the dc_dest_id field. Valid values are: S = Store, W = Warehouse, E = Finisher. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
possible value LOC_TYPE_STORE("S"), |
store_type |
varchar21 |
0 |
1 |
Indicates the store type of the dc_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 |
Fill column length. |
Yes |
values are STORE_TYPE_COMPANY("C"),
STORE_TYPE_FRANCHISE("F"), |
stockholding_ind |
varchar21 |
0 |
1 |
Indicates if the dc_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 |
Fill column length. |
Yes |
values are "Y" or "N" |
order_type |
varchar29 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
pick_not_before_date |
xs:dateTime |
0 |
1 |
Not Yet Available |
null |
null |
null |
null |
No |
not used in SIM |
pick_not_after_date |
xs:dateTime |
0 |
1 |
Not Yet Available |
ALLOCATION,RETURN |
ALLOCATION.DELIVERY_DATE, RETURN.NOT_AFTER_DATE |
DATE |
Fill column length. |
No |
the date that the allocation is expected to be delivered from the warehouse/not after date for Return |
priority |
number4 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
event_code |
varchar26 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
event_description |
varchar21000 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
carrier_code |
varchar24 |
0 |
1 |
NA |
SHIPMENT_CARRIER |
CODE |
VARCHAR2 |
4 |
Yes |
Unique code identifier for a carrier |
carrier_service_code |
varchar26 |
0 |
1 |
NA |
SHIPMENT_CARRIER_SERVICE |
CODE |
VARCHAR2 |
6 |
Yes |
Unique identifier that represents the delivery service |
route |
varchar210 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
ship_address_desc |
varchar230 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
ship_address1 |
varchar2240 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
ship_address2 |
varchar2240 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
ship_address3 |
varchar2240 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
ship_address4 |
varchar2240 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
ship_address5 |
varchar2240 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
ship_city |
varchar2120 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
ship_state |
varchar23 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
ship_zip |
varchar230 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
ship_country_id |
varchar23 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
bill_address_desc |
varchar230 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
bill_address1 |
varchar2240 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
bill_address2 |
varchar2240 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
bill_address3 |
varchar2240 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
bill_address4 |
varchar2240 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
bill_address5 |
varchar2240 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
bill_city |
varchar2120 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
bill_state |
varchar23 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
bill_zip |
varchar230 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
bill_country_id |
varchar23 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
break_by_distro |
varchar21 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
rollback_allocation |
varchar21 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
cartonization |
varchar21 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
consumer_direct |
varchar21 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
message |
varchar22000 |
0 |
1 |
NA |
RETURN,TRANSFER |
RETURN.COMMENTS,TRANSFER.TRANSFER_COMMENT |
VARCHAR2 |
2000 |
No |
comment or short description entered by the creator or processor of the return/transfer |
chute_type |
varchar26 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
po_nbr |
varchar212 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
parent_customer_order |
varchar220 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
order_line_costs |
varchar21 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
container_type |
varchar26 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
amount1 |
number16_2 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
amount2 |
number16_2 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
amount3 |
number16_2 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
amount4 |
number16_2 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
amount5 |
number16_2 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
amount6 |
number16_2 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
sub_total |
number12 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
gift_cost_total |
number12 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
promotion_total |
number12 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
total |
number12 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
tax_total |
number12 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
shipping_total |
number12 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
order_uda1 |
varchar210 |
0 |
1 |
NA |
|
null |
null |
null |
null |
null |
order_uda2 |
varchar210 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
order_uda3 |
varchar210 |
0 |
1 |
NA |
|
null |
null |
null |
null |
null |
order_uda4 |
varchar210 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
order_uda5 |
varchar210 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
order_uda6 |
varchar220 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
order_uda7 |
varchar220 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
order_uda8 |
varchar220 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
order_uda9 |
varchar260 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
order_uda10 |
varchar260 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
dl_comment |
varchar230 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
ship_date |
xs:dateTime |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
SODtlDesc
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
not_after_date |
xs:dateTime |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
distro_parent_nbr |
varchar212 |
0 |
1 |
NA |
ALLOCATION |
DISTRIBUTION_PARENT_ID |
VARCHAR2 |
25 |
No |
A unique identifier of the parent transfer document that is associated to this allocation. |
exp_dc_date |
xs:dateTime |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
approval_id |
varchar230 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
approval_date |
xs:dateTime |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
from_loc_tsf_entity |
number10 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
to_loc_tsf_entity |
number10 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
inv_type |
varchar26 |
0 |
1 |
NA |
Fill application table name. |
Fill table column name. |
null |
null |
null |
used to determine unavailable in SIM which is used to find Return Reason |
so_status |
varchar21 |
0 |
1 |
NA |
Fill application table name. |
null |
null |
null |
null |
Not used in SIM |
delivery_date |
xs:dateTime |
0 |
1 |
NA |
TSF_ALLOCATION |
DELIVERY_DATE |
DATE |
Fill column length. |
No |
the date that the allocation is expected to be delivered from the warehouse. |
context_type |
varchar26 |
0 |
1 |
This field holds the functional area code to which the transfer relates to. Valid values are PROM and REPAIR. |
CODE_DETAIL, TSF_ALLOCATION, TSF |
CODE, CONTEXT_TYPE_ID |
VARCHAR2 |
PROM - Promotion,REPAIR - Repair |
Yes |
This field holds the functional area code to which the allocation relates to. For example promotions.
valid values are |
context_value |
varchar225 |
0 |
1 |
This field holds the value relating to the context type like Promotion number. |
TSF_ALLOCATION, TSF |
CONTEXT_VALUE |
VARCHAR2 |
25 |
No |
This field holds value relating to the context type, e.g promotion number. |
delivery_slot_id |
varchar215 |
0 |
1 |
Delivery Slot Id. |
TSF_ALLOCATION |
DELIVERY_SLOT_ID |
VARCHAR2 |
15 |
No |
delivery slot id |
delivery_slot_desc |
varchar2240 |
0 |
1 |
Delivery slot description. |
DELIVERY_SLOT |
DESCRIPTION |
RIB or/and RSB |
VARCHAR2(240 BYTE) |
Yes |
Fill this description. |
cust_order_nbr |
varchar248 |
0 |
1 |
Contains the customer order number reference for the transfer as provided by OMS. |
TSF |
CUST_ORDER_ID |
VARCHAR2 |
128 |
No |
Customer order external identifier |
fulfill_order_nbr |
varchar248 |
0 |
1 |
Contains the fulfillment order number for the transfer as provided by OMS.
One or more fulfillment orders could relate back to a single customer order in OMS. |
TSF |
FUL_ORD_EXTERNAL_ID |
VARCHAR2 |
128 |
No |
Fulfillment order external identifier |
partial_delivery_ind |
varchar21 |
0 |
1 |
Indicates if the customer order can be picked and shipped
partially (Y) or if it should be shipped only when complete (N). This will be mapped
to the PICK_COMPLETE indicator in RWMS. A value of Y for PARTIAL_DELIVERY_IND will
correspond to the value N for PICK_COMPLETE. |
TRANSFER |
ALLOW_PARTIAL_DELIVERY |
VARCHAR2 |
1 |
Yes |
Indicate if partial delivery is allowed |
consumer_delivery_date |
xs:dateTime |
0 |
1 |
Indicates the desired date the delivery is required by the customer. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
consumer_delivery_time |
xs:dateTime |
0 |
1 |
Indicates the desired time the delivery is required by the customer. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
ship_first_name |
varchar2120 |
0 |
1 |
Contains the first name for the delivery address on consumer-direct transfers. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Not used in SIM |
ship_phonetic_first |
varchar2120 |
0 |
1 |
Contains the phonetic first name for the delivery address on consumer-direct transfers. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Not Used By SIM |
ship_last_name |
varchar2120 |
0 |
1 |
Contains the last name for the delivery address on consumer-direct transfers. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Not used in SIM |
ship_phonetic_last |
varchar2120 |
0 |
1 |
Contains the phonetic last name for the delivery address on consumer-direct transfers. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Not Used By SIM |
ship_preferred_name |
varchar2120 |
0 |
1 |
Contains the preferred name for the delivery address on consumer-direct transfers. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Not Used By SIM |
ship_company_name |
varchar2120 |
0 |
1 |
Contains the company name for the delivery address on consumer-direct transfers. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Not used in SIM |
ship_county |
varchar2250 |
0 |
1 |
Contains the county name for the delivery address on consumer-direct transfers. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Not used in SIM |
ship_phone |
varchar220 |
0 |
1 |
Contains the phone number for the delivery address on consumer-direct transfers. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Not Used by SIM |
bill_first_name |
varchar2120 |
0 |
1 |
Contains the first name for the billing address on consumer-direct transfers
for inclusion on the packing slip. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
bill_phonetic_first |
varchar2120 |
0 |
1 |
Contains the phonetic first name for the billing address on consumer-direct transfers
for inclusion on the packing slip. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
bill_last_name |
varchar2120 |
0 |
1 |
Contains the last name for the billing address on consumer-direct transfers
for inclusion on the packing slip. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
bill_phonetic_last |
varchar2120 |
0 |
1 |
Contains the phonetic last name for the billing address on consumer-direct transfers
for inclusion on the packing slip. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
bill_preferred_name |
varchar2120 |
0 |
1 |
Contains the preferred name for the billing address on consumer-direct transfers
for inclusion on the packing slip. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
bill_company_name |
varchar2120 |
0 |
1 |
Contains the company name for the billing address on consumer-direct transfers
for inclusion on the packing slip. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
bill_phone |
varchar220 |
0 |
1 |
Contains the billing address phone number for customer-direct transfers
for inclusion on the packing slip. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
bill_county |
varchar2250 |
0 |
1 |
Contains the county name for the billing address on consumer-direct transfers
for inclusion on the packing slip. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |