XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for VdrDelvCriVo 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 |
store_id |
number10 |
1 |
1 |
Include only deliveries for this store. |
DSD |
STORE_ID |
NUMBER |
10 |
Yes |
store identifier |
from_date |
xs:dateTime |
0 |
1 |
Include only deliveries with the date related to their status either at or after this date. |
DSD |
UPDATE_DATE |
DATE |
|
No |
Update date |
to_date |
xs:dateTime |
0 |
1 |
Include only deliveries with the date related to their status either at or before this date. |
DSD |
UPDATE_DATE |
DATE |
|
No |
update date |
purchase_order_ext_id |
varchar2128 |
0 |
1 |
Include only deliveries for the purchase order with this external identifier. |
PURCHASE_ORDER, DSD_LINE_ITEM |
EXTERNAL_ID, PURCHASE_ORDER_EXT_ID |
VARCHAR2 |
128 |
No |
purchase order external identifier |
origin_type |
origin_cri_type |
1 |
1 |
Include only deliveries matching this origin type. Valid values are ASN, DEXNEX, MANUAL, PO, NO_VALUE, UNKNOWN. |
DSD |
ORIGIN_TYPE |
NUMBER |
2 |
Yes |
Indicate DSD Origin type, 0 -ASN 1 - PO, 2 - DEX-NEX, 3 - on the fly |
invoice_number |
varchar2128 |
0 |
1 |
Include only deliveries with this invoice number. |
DSD |
INVOICE_ID |
VARCHAR2 |
128 |
No |
invoice number |
asn |
varchar2128 |
0 |
1 |
Include only deliveries with this ASN external identifier. |
DSD |
ASN_ID |
VARCHAR2 |
128 |
No |
ASN external identifier |
item_id |
varchar225 |
0 |
1 |
Include only deliveries containing this item SKU. |
DSD_LINE_ITEM |
ITEM_ID |
VARCHAR2 |
25 |
No |
SKU |
customer_order_id |
varchar2128 |
0 |
1 |
Include only deliveries for the customer order with this external identifier. |
DSD, DSD_LINE_ITEM |
CUST_ORDER_ID |
VARCHAR2 |
128 |
No |
customer order external identifier |
fulfillment_order_id |
varchar2128 |
0 |
1 |
Include only deliveries for the fulfillment order with this external identifier. |
DSD, DSD_LINE_ITEM |
FUL_ORD_EXTERNAL_ID |
VARCHAR2 |
128 |
No |
fulfillment order external identifier |
any_customer_order |
xs:boolean |
1 |
1 |
Include only deliveries for any fulfillment order. Ignored if customer/fulfillment order external identifiers are set. |
|
|
|
|
No |
|
supplier_id |
number10 |
0 |
1 |
Include only deliveries for this supplier. |
DSD |
SUPPLIER_ID |
NUMBER |
10 |
No |
supplier identifier |
status |
dsd_cri_status |
1 |
1 |
Include only deliveries matching this status. Valid values are NEW, IN_PROGRESS, RECEIVED, CANCELED, REJECTED, ACTIVE, NO_VALUE, UNKNOWN. |
DSD |
STATUS |
NUMBER |
4 |
Yes |
"The current status of the direct delivery.
The valid values: 0 - New, 1 - In Progress, 2 - Received, 3 - Canceled, 4 : Rejected |
last_user |
varchar2128 |
0 |
1 |
Include only deliveries last updated by this user. |
DSD |
UPDATE_USER |
VARCHAR2 |
128 |
No |
last update user |