[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:
|
|
|