# DW_NS_itemVendor_D

This table contains the mapping information items and associated vendors.

## Details

Module:

## Key Columns

item, vendor, subsidiary

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
item | NUMBER | 38 | 0 | True | Item | DW_NS_item_D | id
vendor | NUMBER | 38 | 0 | True | Vendor | DW_NS_vendor_D | id
subsidiary | NUMBER | 38 | 0 | True | Subsidiary | DW_NS_subsidiary_D | id
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. This is source record id column. |  |
preferredvendor | VARCHAR2 | 16 |  |  | Preferred |  |
vendorcode | VARCHAR2 | 512 |  |  | Code |  |

Copyright © 2019, 2026, Oracle and/or its affiliates.