XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for VdrDelvCtnDesc 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 |
carton_id |
number12 |
1 |
1 |
Carton identifier. |
DSD_CARTON |
ID |
NUMBER |
12 |
Yes |
Carton identifier. |
store_id |
number10 |
1 |
1 |
Store identifier. |
DSD_CARTON |
STORE_ID |
NUMBER |
10 |
Yes |
Store identifier |
external_id |
varchar2128 |
0 |
1 |
Carton external identifier. |
DSD_CARTON |
EXTERNAL_ID |
VARCHAR2 |
128 |
No |
Carton external identifier. |
reference_id |
varchar2128 |
0 |
1 |
Carton reference identifier. |
DSD_CARTON |
REFERENCE_ID |
VARCHAR2 |
128 |
No |
Carton reference identifier. |
delivery_id |
number12 |
1 |
1 |
Delivery identifier. |
DSD_CARTON |
DSD_ID |
NUMBER |
12 |
Yes |
Delivery identifier. |
status |
dsd_carton_status |
1 |
1 |
Status of the carton. Valid values are NEW, IN_PROGRESS, SUBMITTED, RECEIVED, DAMAGED, MISSING, NO_VALUE, UNKNOWN. |
DSD_CARTON |
STATUS |
NUMBER |
4 |
Yes |
carton status. 1 - New, 2 - In Progress, 3 - Submitted, 4 - Received, 5 - Damaged, 6 - Missing, 7 - Canceled |
customer_order_related |
order_related_type |
1 |
1 |
Carton is related to customer order. Valid values are YES, MIX, NO, NO_VALUE, UNKNOWN. |
DSD_CARTON |
CUSTOMER_ORDER_RELATED |
NUMBER |
4 |
Yes |
Indicate if carton contains customer order items. 1 - yes, 2 - mix; 3 - no |
damaged_reason |
varchar2128 |
0 |
1 |
Carton damaged reason. |
DSD_CARTON |
DAMAGED_REASON |
VARCHAR2 |
128 |
No |
Carton damaged reason. |
serial_code |
number18 |
0 |
1 |
Carton serial code. |
DSD_CARTON |
SERIAL_CODE |
NUMBER |
18 |
No |
Carton serial code. |
tracking_number |
varchar2128 |
0 |
1 |
Carton tracking number. |
DSD_CARTON |
TRACKING_NUMBER |
VARCHAR2 |
128 |
No |
Carton tracking number. |
create_date |
xs:dateTime |
1 |
1 |
The date the carton was created. |
DSD_CARTON |
CREATE_DATE |
DATE |
|
Yes |
The date the carton was created. |
create_user |
varchar2128 |
1 |
1 |
The user that created the carton. |
DSD_CARTON |
CREATE_USER |
VARCHAR2 |
128 |
Yes |
The user that created the carton. |
update_date |
xs:dateTime |
1 |
1 |
The date the carton was last updated. |
DSD_CARTON |
UPDATE_DATE |
DATE |
|
No |
The date the carton was last updated. |
update_user |
varchar2128 |
1 |
1 |
The user that last updated the carton. |
DSD_CARTON |
UPDATE_USER |
VARCHAR2 |
128 |
No |
The user that last updated the carton. |
received_date |
xs:dateTime |
0 |
1 |
The date the carton was received. |
DSD_CARTON |
RECEIVE_DATE |
DATE |
|
No |
The date the carton was received. |
received_user |
varchar2128 |
0 |
1 |
The user that received the carton. |
DSD_CARTON |
RECEIVE_USER |
VARCHAR2 |
128 |
No |
The user that received the carton. |
adjusted |
xs:boolean |
1 |
1 |
Indicates the carton is currently being adjusted. |
DSD_CARTON |
ADJUSTED |
VARCHAR2 |
1 |
Yes |
Indicates the carton is currently being adjusted |
external_created |
xs:boolean |
1 |
1 |
Indicates if carton was externally created. |
DSD_CARTON |
EXTERNAL_CREATE |
VARCHAR2 |
1 |
Yes |
Indicates if carton was externally created. |
quality_control |
xs:boolean |
1 |
1 |
Indicates quality control is still required for the carton. |
DSD_CARTON |
QUALITY_CONTROL |
VARCHAR2 |
1 |
Yes |
Indicates quality control is still required for the carton |
damage_remaining |
xs:boolean |
1 |
1 |
Indicates that all remaining quantities not received should be considered damage on confirmation. |
DSD_CARTON |
DAMAGE_REMAINING |
VARCHAR2 |
1 |
Yes |
Indicates that all remaining quantities not received should be considered damage on confirmation. |
receive_shopfloor |
xs:boolean |
1 |
1 |
Indicate if inventory should be received on shop floor. |
DSD_CARTON |
RECEIVE_AT_SHOP_FLOOR |
VARCHAR2 |
1 |
Yes |
Indicate if inventory should be received on shop floor. |
VdrDelvCtnItm
|
*
|
0
|
1000
|
Collection of line items in the container.
|
|
|
|
|
|
|