XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for VdrDelvDesc 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 |
delivery_id |
number12 |
1 |
1 |
Delivery identifier. |
DSD |
ID |
NUMBER |
12 |
Yes |
Delivery identifier. |
store_id |
number10 |
1 |
1 |
Store identifier. |
DSD |
STORE_ID |
NUMBER |
10 |
Yes |
Store identifier. |
supplier_id |
number10 |
1 |
1 |
Supplier identifier. |
DSD |
SUPPLIER_ID |
NUMBER |
10 |
Yes |
Supplier identifier. |
supplier_name |
varchar2240 |
0 |
1 |
Supplier name. |
SUPPLIER |
NAME |
VARCHAR2 |
240 |
No |
Supplier name. |
origin_type |
origin_type |
1 |
1 |
Originating type of delivery. Valid values are ASN, DEXNEX, MANUAL, PO, NO_VALUE, UNKNOWN. |
DSD |
ORIGIN_TYPE |
NUMBER |
2 |
Yes |
Originating type of delivery.0 -ASN 1 - PO, 2 - DEX-NEX, 3 - on the fly |
status |
dsd_status |
1 |
1 |
Status of the delivery. Valid values are NEW, IN_PROGRESS, RECEIVED, CANCELED, REJECTED, NO_VALUE, UNKNOWN. |
DSD |
STATUS |
NUMBER |
4 |
Yes |
status of the delivery |
asn |
varchar2128 |
0 |
1 |
External identifier of the ASN for the delivery. |
DSD |
ASN_ID |
VARCHAR2 |
128 |
No |
External identifier of the ASN for the delivery. |
purchase_order_id |
number12 |
0 |
1 |
Purchase order identifier. |
DSD |
PURCHASE_ORDER_ID |
NUMBER |
12,0 |
No |
the unique identifier of the purchase order that this direct delivery is associated to. |
purchase_order_ext_id |
varchar2128 |
0 |
1 |
Purchase Order External Identifier. |
PURCHASE_ORDER |
EXTERNAL_ID |
VARCHAR2 |
128 |
No |
purchase order external id for the delivery. |
customer_order_id |
varchar2128 |
0 |
1 |
Identifier of the customer order for the delivery. |
DSD |
CUST_ORDER_ID |
VARCHAR2 |
128 |
Yes |
Identifier of the customer order for the delivery. |
fulfillment_order_id |
varchar2128 |
0 |
1 |
Identifier of the fulfillment order for the delivery. |
DSD |
FUL_ORD_EXTERNAL_ID |
VARCHAR2 |
128 |
No |
Identifier of the fulfillment order for the delivery. |
invoice_number |
varchar2128 |
0 |
1 |
Invoice number for the delivery. |
DSD |
INVOICE_ID |
VARCHAR2 |
128 |
No |
Invoice number for the delivery |
invoice_date |
xs:dateTime |
0 |
1 |
Invoice date for the delivery. |
DSD |
INVOICE_DATE |
DATE |
|
No |
Invoice date for the delivery. |
invoice_cost |
number12_4 |
0 |
1 |
Invoice cost for the delivery. |
DSD |
INVOICE_COST_VALUE |
NUMBER |
12,4 |
No |
Invoice cost for the delivery. |
carrier_type |
dsd_carrier_type |
1 |
1 |
Carrier type of the delivery. Valid values are CORPORATE, THIRD_PARTY, NO_VALUE, UNKNOWN. |
DSD |
CARRIER_TYPE |
NUMBER |
2 |
No |
Indicate carrier type, 0 - Corporate, 1 - Third Party |
carrier_name |
varchar2128 |
0 |
1 |
Name of the carrier |
DSD |
CARRIER_ENTITY |
VARCHAR2 |
128 |
No |
Name of the carrier |
carrier_code |
varchar24 |
0 |
1 |
Carrier code of carrier responsible for vendor delivery |
DSD |
CARRIER_CODE |
VARCHAR2 |
4 |
No |
Carrier code of carrier responsible for vendor delivery |
license_plate |
varchar2128 |
0 |
1 |
License plate of the delivery |
DSD |
LICENSE_PLATE |
VARCHAR2 |
128 |
No |
License plate of the delivery |
source_address |
varchar21000 |
0 |
1 |
The address of source sending delivery. |
DSD |
SOURCE_ADDRESS |
VARCHAR2 |
1000 |
No |
The address of source sending delivery. |
freight_id |
varchar2128 |
0 |
1 |
The Freight identifier. |
DSD |
FREIGHT_ID |
VARCHAR2 |
128 |
No |
The Freight identifier. |
bol_external_id |
varchar2128 |
0 |
1 |
Bill of Lading external identifier. |
DSD |
BOL_EXTERNAL_ID |
VARCHAR2 |
128 |
No |
Bill of Lading external identifier. |
currency_code |
varchar23 |
0 |
1 |
Currency code of the unit cost for the line item. |
DSD |
CURRENCY_CODE |
VARCHAR2 |
3 |
No |
Currency code of the unit cost for the line item. |
country_code |
varchar23 |
0 |
1 |
The country code. |
DSD |
COUNTRY_CODE |
VARCHAR2 |
3 |
No |
The country code. |
expected_arrival_date |
xs:dateTime |
0 |
1 |
The date the delivery is expected to arrive. |
DSD |
EXPECTED_DATE |
DATE |
|
No |
The date the delivery is expected to arrive. |
create_date |
xs:dateTime |
1 |
1 |
The date the delivery was created. |
DSD |
CREATE_DATE |
DATE |
|
No |
The date the delivery was created. |
update_date |
xs:dateTime |
1 |
1 |
The date the delivery was last updated. |
DSD |
UPDATE_DATE |
DATE |
|
No |
The date the delivery was last updated. |
received_date |
xs:dateTime |
0 |
1 |
The date the delivery was received. |
DSD |
Fill table column name. |
DATE |
|
No |
The date the delivery was received. |
create_user |
varchar2128 |
1 |
1 |
The user that created the delivery. |
DSD |
CREATE_USER |
VARCHAR2 |
128 |
Yes |
The user that created the delivery. |
update_user |
varchar2128 |
1 |
1 |
The user that last updated the delivery. |
DSD |
UPDATE_USER |
VARCHAR2 |
128 |
No |
The user that last updated the delivery. |
received_user |
varchar2128 |
0 |
1 |
The user that received the delivery. |
DSD |
RECEIVED_USER |
VARCHAR2 |
128 |
No |
The user that received the delivery. |
total_cartons |
number10 |
1 |
1 |
Total number of cartons on the delivery. |
|
|
|
|
Yes |
Derived from number of container associated to the delivery. |
total_items |
number10 |
1 |
1 |
Total number of items on the delivery. |
|
|
|
|
No |
Derived from number of line items received on the delivery. |
total_documents |
number10 |
1 |
1 |
Total numbers of documents associated with delivery. |
|
|
|
|
No |
Derived from number of purchase order associated to the delivery. |
VdrDelvDescNote
|
*
|
0
|
1000
|
Notes associated to the vendor shipment.
|
|
|
|
|
|
|