DW_NS_itemVendor_D
This table contains the mapping information items and associated vendors.
Details
Module:
Key Columns
item, vendor, subsidiary
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 |