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