[Home] [Help] [Dependency Information]
Object Name: | CN_IMP_HEADERS |
---|---|
Object Type: | TABLE |
Owner: | CN |
FND Design Data: | CN.CN_IMP_HEADERS |
Subobject Name: | |
Status: | VALID |
CN_IMP_HEADERS contains information for user imports.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CN_IMP_HEADERS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | IMP_HEADER_ID |
CN_IMP_HEADERS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX | NAME |
CN_IMP_HEADERS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | IMP_MAP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
IMP_HEADER_ID | NUMBER | (15) | Yes | Identifier |
NAME | VARCHAR2 | (30) | Yes | Import / Export Name |
DESCRIPTION | VARCHAR2 | (80) | Description | |
IMPORT_TYPE_CODE | VARCHAR2 | (30) | Yes | Import / Export Module Type code |
SERVER_FLAG | VARCHAR2 | (1) | Server Flag. Y for server side import, N for client side import. | |
USER_FILENAME | VARCHAR2 | (2000) | User Filename. The data file name user inputs. | |
DATA_FILENAME | VARCHAR2 | (2000) | Data Filename. The data file name located at server side. | |
TERMINATED_BY | VARCHAR2 | (30) | The character which terminated each column in data file. | |
ENCLOSED_BY | VARCHAR2 | (30) | The character which enclosed each column in data file. | |
HEADINGS_FLAG | VARCHAR2 | (1) | Headings Flag. Y if the data file contains header line. | |
PROCESSED_ROW | NUMBER | Total number of processed records. | ||
FAILED_ROW | NUMBER | Total number of failed records. | ||
STATUS_CODE | VARCHAR2 | (30) | Import status | |
IMP_MAP_ID | NUMBER | (15) | Foreign key | |
SOURCE_COLUMN_NUM | NUMBER | Source Column Num. The total number of columns in user data file. | ||
OBJECT_VERSION_NUMBER | NUMBER | Yes | Standard Who column | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
OPERATION | VARCHAR2 | (30) | Yes | Operation type, either Import or Export. |
STAGED_ROW | NUMBER | Total number of staged records. |
Cut, paste (and edit) the following text to query this object:
SELECT IMP_HEADER_ID
, NAME
, DESCRIPTION
, IMPORT_TYPE_CODE
, SERVER_FLAG
, USER_FILENAME
, DATA_FILENAME
, TERMINATED_BY
, ENCLOSED_BY
, HEADINGS_FLAG
, PROCESSED_ROW
, FAILED_ROW
, STATUS_CODE
, IMP_MAP_ID
, SOURCE_COLUMN_NUM
, OBJECT_VERSION_NUMBER
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, OPERATION
, STAGED_ROW
FROM CN.CN_IMP_HEADERS;
CN.CN_IMP_HEADERS does not reference any database object
CN.CN_IMP_HEADERS is referenced by following:
|
|
|