[Home] [Help] [Dependency Information]
Object Name: | JL_CO_GL_NIT_ACCTS |
---|---|
Object Type: | TABLE |
Owner: | JL |
FND Design Data: | JL.JL_CO_GL_NIT_ACCTS |
Subobject Name: | |
Status: | VALID |
This table contains all the GL account segment values entered for the GL Account Segment values set. The values are copied by the Control Accounts window. The rows are initially created with the column NIT_REQUIRED equal to NULL. The user will use the Control Account window to specify for each account segment value whether or not Third Party information is required for all GL code combinations that contain the value.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JL_CO_GL_NIT_ACCTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ACCOUNT_CODE
CHART_OF_ACCOUNTS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CHART_OF_ACCOUNTS_ID | NUMBER | (15) | Yes | GL Chart of accounts ID |
FLEX_VALUE_ID | NUMBER | (15) | Yes | Flex values ID |
ACCOUNT_CODE | VARCHAR2 | (25) | Yes | GL natural account segment value |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CREATION_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
NIT_REQUIRED | VARCHAR2 | (1) | 'Y' - all GL code combinations which contains this natural account segment value will require third party balances. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure defining Column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Column |
Cut, paste (and edit) the following text to query this object:
SELECT CHART_OF_ACCOUNTS_ID
, FLEX_VALUE_ID
, ACCOUNT_CODE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, NIT_REQUIRED
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM JL.JL_CO_GL_NIT_ACCTS;
JL.JL_CO_GL_NIT_ACCTS does not reference any database object
JL.JL_CO_GL_NIT_ACCTS is referenced by following:
|
|
|