DW_NS_VendorSubsidiaryRelationship_G
This table contains link information between vendor and subsidiary.
Details
Module:
Key Columns
id
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| id | NUMBER | 38 | 0 | True | |||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. This is source record id column. | ||||
| entity | NUMBER | 38 | 0 | Vendor | DW_NS_vendor_D | id | |
| isprimarysub | VARCHAR2 | 16 | Is Primary Subsidiary | ||||
| name | VARCHAR2 | 999 | Name | ||||
| subsidiary | NUMBER | 38 | 0 | Subsidiary | |||
| lastmodifieddate | TIMESTAMP | Last Modified Date |