DW_NS_customer_D
This table contains information about the customer 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. | ||||
| companyname | VARCHAR2 | 256 | Company Name | ||||
| firstname | VARCHAR2 | 64 | First Name | ||||
| lastname | VARCHAR2 | 64 | Last Name | ||||
| altname | VARCHAR2 | 999 | Last Name | ||||
| datecreated | TIMESTAMP | Date Created | |||||
| startdate | TIMESTAMP | Start Date | |||||
| enddate | TIMESTAMP | End Date | |||||
| firstorderdate | TIMESTAMP | Internal Column -Do not use.First Sales Order Date | |||||
| firstsaledate | TIMESTAMP | Internal Column -Do not use.First Sale Date | |||||
| lastorderdate | TIMESTAMP | Internal Column -Do not use.Last Sales Order Date | |||||
| lastsaledate | TIMESTAMP | Internal Column -Do not use.Last Sales Date | |||||
| faxtransactions | VARCHAR2 | 16 | Fax Transactions | ||||
| isbudgetapproved | VARCHAR2 | 16 | Budget Approved | ||||
| isinactive | VARCHAR2 | 16 | Inactive | ||||
| isperson | VARCHAR2 | 16 | Is Individual | ||||
| oncredithold | VARCHAR2 | 16 | Internal Column -Do not use. On Credit Hold | ||||
| emailpreference | VARCHAR2 | 16 | Email Preference | DW_NS_EmailPreferenceType_D | id | ||
| emailtransactions | VARCHAR2 | 16 | Email Transactions | ||||
| creditholdoverride | VARCHAR2 | 16 | Credit Hold | ||||
| accountnumber | VARCHAR2 | 256 | Account Number | ||||
| billingschedule | NUMBER | 38 | 0 | Billing Schedule | DW_NS_billingSchedule_D | id | |
| comments | VARCHAR2 | 999 | Comments | ||||
| currency | NUMBER | 38 | 0 | Currency | DW_NS_currency_D | id | |
| defaultbillingaddress | NUMBER | 38 | 0 | Default Billing Address | DW_NS_EntityAddress_D | nkey | |
| defaultshippingaddress | NUMBER | 38 | 0 | Default Shipping Address | DW_NS_EntityAddress_D | nkey | |
| VARCHAR2 | 512 | ||||||
| entityid | VARCHAR2 | 256 | Entity ID | ||||
| entitystatus | NUMBER | 38 | 0 | Status (Customer) | DW_NS_EntityStatus_D | key | |
| entitytitle | VARCHAR2 | 512 | Vendor ID | ||||
| fax | VARCHAR2 | 128 | Fax | ||||
| lastmodifieddate | TIMESTAMP | Last Modified Date | |||||
| phone | VARCHAR2 | 128 | Phone | ||||
| pricelevel | NUMBER | 38 | 0 | Price Level | DW_NS_priceLevel_D | id | |
| salesrep | NUMBER | 38 | 0 | Primary Sales Rep (Entity) | DW_NS_entity_D | id | |
| salesrep_employee | NUMBER | 38 | 0 | Primary Sales Rep (Employee) | DW_NS_employee_D | id | |
| salesrep_entity_group | NUMBER | 38 | 0 | Primary Sales Rep (Sales Group) | DW_NS_entityGroup_D | id | |
| shippingcarrier | VARCHAR2 | 16 | Carrier | ||||
| terms | NUMBER | 38 | 0 | Terms | DW_NS_term_D | id | |
| creditlimit | NUMBER | Credit Limit | |||||
| estimatedbudget | NUMBER | Estimated Budget | |||||
| url | VARCHAR2 | 256 | URL | ||||
| partner | NUMBER | 38 | 0 | Primary Partner | DW_NS_Partner_D | id | |
| representingsubsidiary | NUMBER | 38 | 0 | Represents Subsidiary | DW_NS_subsidiary_D | id | |
| isautogeneratedrepresentingentity | VARCHAR2 | 16 | Is Autogenerated Representing Entity | ||||
| category | NUMBER | 38 | 0 | Category | DW_NS_customerCategory_D | id | |
| parent | NUMBER | 38 | 0 | Parent | DW_NS_customer_D | id | |
| contact | NUMBER | 38 | 0 | Primary Contact | DW_NS_Contact_D | id | |
| groupinvoices | VARCHAR2 | 16 | |||||
| defaultorderpriority | NUMBER |