[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CZ_END_USERS |
|---|---|
| Object Type: | TABLE |
| Owner: | CZ |
| FND Design Data: |  CZ.CZ_END_USERS
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
| Tablespace: |  APPS_TS_ARCHIVE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| CZ_END_USERS_PK | NORMAL | UNIQUE |
APPS_TS_ARCHIVE
|
 END_USER_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| END_USER_ID | NUMBER | (9) | Yes | Designates an SPX identifier for the user |
| DBMS_ID | NUMBER | (15) | Not currently used | |
| TITLE | VARCHAR2 | (48) | Designates a title for referring to the end user | |
| LASTNAME | VARCHAR2 | (48) | Contains the end user's last name | |
| FIRSTNAME | VARCHAR2 | (48) | Records the first name of the end user | |
| MI | VARCHAR2 | (1) | Contains the middle initial of the end user | |
| ALLOWABLE_DISCOUNT | NUMBER | (16) | Percentage of discount that can be allowed to this user | |
| DESC_TEXT | VARCHAR2 | (255) | Descriptive text | |
| ADDR_LINE1 | VARCHAR2 | (150) | Contains end user's first line address | |
| ADDR_LINE2 | VARCHAR2 | (150) | Contains end user's second line address | |
| CITY | VARCHAR2 | (56) | Contains end user's city name | |
| STATE | VARCHAR2 | (8) | Contains end user's state name | |
| PROVINCE | VARCHAR2 | (56) | Contains end user's province name | |
| COUNTY | VARCHAR2 | (56) | Contains end user's county name | |
| ZIP | VARCHAR2 | (24) | Contains end user's zip code | |
| COUNTRY | VARCHAR2 | (56) | Contains end user's country name | |
| PHONE | VARCHAR2 | (48) | Contains end user's contact phone number | |
| FAX | VARCHAR2 | (48) | Contains end user's FAX number | |
| PAGER | VARCHAR2 | (48) | Contains end user's pager number | |
| CELLULAR | VARCHAR2 | (48) | Contains end user's cellular phone number | |
| EMAIL_ADDR | VARCHAR2 | (150) | Contains end user's e-mail ID | |
| REPLICATE_FLAG | VARCHAR2 | (1) | Not currently used | |
| LAST_REPLICATION | DATE | Last replication date | ||
| END_USER_ORG_ID | NUMBER | Identifier of the organization the user belongs to. | ||
| FND_USER_ID | NUMBER | (9) | Not currently used | |
| ORIG_SYS_REF | VARCHAR2 | (255) | Unique identification of a record in this table | |
| NAME | VARCHAR2 | (255) | Contains name of the end user | |
| LOGIN_NAME | VARCHAR2 | (48) | Designates the name by which the end user logs in to the SellingPoint application backbone data warehouse | |
| USER_NUM01 | NUMBER | (16) | Numeric user expansion field | |
| USER_NUM02 | NUMBER | (16) | Numeric user expansion field | |
| USER_NUM03 | NUMBER | (16) | Numeric user expansion field | |
| USER_NUM04 | NUMBER | (16) | Numeric user expansion field | |
| USER_STR01 | VARCHAR2 | (255) | Textual user expansion field | |
| USER_STR02 | VARCHAR2 | (255) | Textual user expansion field | |
| USER_STR03 | VARCHAR2 | (255) | Textual user expansion field | |
| USER_STR04 | VARCHAR2 | (255) | Textual user expansion field | |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| DELETED_FLAG | VARCHAR2 | (1) | Yes | Indicates ('1'/'0') that this record has been deleted |
| EFF_FROM | DATE | Not currently used | ||
| EFF_TO | DATE | Not currently used | ||
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| SECURITY_MASK | VARCHAR2 | (40) | Not currently used | |
| EFF_MASK | VARCHAR2 | (40) | Not currently used | |
| CHECKOUT_USER | VARCHAR2 | (40) | Not currently used | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT END_USER_ID
, DBMS_ID
, TITLE
, LASTNAME
, FIRSTNAME
, MI
, ALLOWABLE_DISCOUNT
, DESC_TEXT
, ADDR_LINE1
, ADDR_LINE2
, CITY
, STATE
, PROVINCE
, COUNTY
, ZIP
, COUNTRY
, PHONE
, FAX
, PAGER
, CELLULAR
, EMAIL_ADDR
, REPLICATE_FLAG
, LAST_REPLICATION
, END_USER_ORG_ID
, FND_USER_ID
, ORIG_SYS_REF
, NAME
, LOGIN_NAME
, USER_NUM01
, USER_NUM02
, USER_NUM03
, USER_NUM04
, USER_STR01
, USER_STR02
, USER_STR03
, USER_STR04
, CREATION_DATE
, LAST_UPDATE_DATE
, DELETED_FLAG
, EFF_FROM
, EFF_TO
, CREATED_BY
, LAST_UPDATED_BY
, SECURITY_MASK
, EFF_MASK
, CHECKOUT_USER
, LAST_UPDATE_LOGIN
FROM CZ.CZ_END_USERS;
CZ.CZ_END_USERS does not reference any database object
CZ.CZ_END_USERS is referenced by following:
APPS
CZ_END_USERS
CZ_END_USERS_T1
|
|
|
|