# DW_NS_itemVendor_D

This table contains the mapping information items and associated vendors.

## Details

Module:

## Key Columns

vendor, item, subsidiary

## Columns

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

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