XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for VdrDelvCtnItmMod 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 |
line_id |
number15 |
0 |
1 |
Vendor delivery detail line internal identifier. If left empty, indicates adding a new delivery item. |
DSD_LINE_ITEM |
ID |
NUMBER |
12 |
Yes |
Vendor delivery detail line internal identifier. |
item_id |
varchar225 |
1 |
1 |
Item SKU. This value cannot be altered on update. |
DSD_LINE_ITEM |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
Item SKU |
purchase_order_id |
number12 |
0 |
1 |
Purchase order identifier. |
DSD_LINE_ITEM |
PURCHASE_ORDER_ID |
NUMBER |
12,0 |
No |
Purchase order identifier |
case_size |
number10_2 |
0 |
1 |
Case size for the line item. |
DSD_LINE_ITEM |
CASE_SIZE |
NUMBER |
10,2 |
No |
Case size for the line item. |
unit_cost_override |
number12_4 |
0 |
1 |
Amount of the unit cost override for the line item. |
DSD_LINE_ITEM |
OVERRIDE_UNIT_COST_VALUE |
NUMBER |
12,4 |
No |
Amount of the unit cost for the line item. |
unit_cost_override_currency |
varchar23 |
0 |
1 |
Currency code of the unit cost for the line item. |
DSD_LINE_ITEM |
OVERRIDE_UNIT_COST_CURRENCY |
VARCHAR2 |
3 |
No |
The override unit cost currency. |
quantity_received |
number20_4 |
0 |
1 |
Received quantity for the line item in units. |
DSD_LINE_ITEM |
QUANTITY_RECEIVED |
NUMBER |
20,4 |
No |
Received quantity for the line item in units. |
quantity_damaged |
number20_4 |
0 |
1 |
Damaged quantity for the line item in units. |
DSD_LINE_ITEM |
QUANTITY_DAMAGED |
NUMBER |
20,4 |
No |
Damaged quantity for the line item in units. |
removed_uin_col |
varchar2128 |
0 |
1000 |
Collection of unique identifier numbers to remove from the line item. |
ITEM_UIN |
UIN |
ITEM_UIN |
128 |
Yes |
UIN to be removed from the delivery. |
VdrDvCtnItmUinMod
|
*
|
0
|
1000
|
Collection of unique identifier numbers to add or update for the line item.
|
|
|
|
|
|
|
StrInvExtAttDesc:StrInvExtAttDesc
|
*
|
0
|
1000
|
Collection of extended attributes associated to the line item, either added or updated external attributes.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
removed_ext_att_col |
varchar2128 |
0 |
1000 |
Contains barcodes associated to the extended attribute scan to be deleted. All occurrences will be deleted. |
DSD_LINE_ITEM_ATT |
BARCODE |
VARCHAR2 |
128 |
Yes |
Extended attribute barcode. |