DW_NS_Partner_D
This table contains details about Partner entity.
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. | ||||
| altname | VARCHAR2 | 999 | Partner | ||||
| class | NUMBER | 38 | 0 | Class | |||
| comments | VARCHAR2 | 999 | Comments | ||||
| companyname | VARCHAR2 | 256 | Company Name | ||||
| datecreated | TIMESTAMP | Date Created | |||||
| defaultbillingaddress | NUMBER | 38 | 0 | Default Billing Address | DW_NS_EntityAddress_D | nkey | |
| defaultshippingaddress | NUMBER | 38 | 0 | Default Shipping Address | DW_NS_EntityAddress_D | nkey | |
| department | NUMBER | 38 | 0 | Department | DW_NS_department_D | id | |
| duplicate | VARCHAR2 | 16 | Duplicate | ||||
| VARCHAR2 | 512 | Partner Email | |||||
| emailpreference | VARCHAR2 | 16 | Email Preference | DW_NS_EmailPreferenceType_D | id | ||
| entityid | VARCHAR2 | 256 | Entity ID | ||||
| entitytitle | VARCHAR2 | 512 | Partner Id | ||||
| fax | VARCHAR2 | 128 | Fax | ||||
| isinactive | VARCHAR2 | 16 | Partner Is Inactive | ||||
| isperson | VARCHAR2 | 16 | Is Individual | ||||
| lastmodifieddate | TIMESTAMP | Last Modified Date | |||||
| location | NUMBER | 38 | 0 | Location | DW_NS_location_D | id | |
| parent | NUMBER | 38 | 0 | SubPartner of | DW_NS_Partner_D | id | |
| partnercode | VARCHAR2 | 512 | Partner Code | ||||
| phone | VARCHAR2 | 128 | Phone | ||||
| url | VARCHAR2 | 256 | URL | ||||
| contact | NUMBER | 38 | 0 | Primary Contact | DW_NS_Contact_D | id |