[Home] [Help] [Dependency Information]
Object Name: | GL_USSGL_TRANSACTION_CODES |
---|---|
Object Type: | TABLE |
Owner: | GL |
FND Design Data: | SQLGL.GL_USSGL_TRANSACTION_CODES |
Subobject Name: | |
Status: | VALID |
GL_USSGL_TRANSACTION_CODES stores user defined codes that tell Oracle General Ledger how to generate budgetary transactions from proprietary transactions. This allows Oracle General Ledger to support the requirements of the United States Standard General Ledger.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GL_USSGL_TRANSACTION_CODES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CHART_OF_ACCOUNTS_ID
USSGL_TRANSACTION_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CHART_OF_ACCOUNTS_ID | NUMBER | (15) | Yes | Key flexfield structure defining column |
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | Yes | Government transaction code |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Yes | Standard Who column | |
START_DATE_ACTIVE | DATE | Date after which government transaction code is valid | ||
END_DATE_ACTIVE | DATE | Date before which government transaction code is valid | ||
DESCRIPTION | VARCHAR2 | (240) | Government transaction code description | |
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 | |
CONTEXT | VARCHAR2 | (150) | Descriptive flexfield context | |
ASSOC_INTEREST_USSGL_CODE | VARCHAR2 | (30) | Interest transaction code | |
ASSOC_DISCOUNT_USSGL_CODE | VARCHAR2 | (30) | Discount transaction code |
Cut, paste (and edit) the following text to query this object:
SELECT CHART_OF_ACCOUNTS_ID
, USSGL_TRANSACTION_CODE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, DESCRIPTION
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CONTEXT
, ASSOC_INTEREST_USSGL_CODE
, ASSOC_DISCOUNT_USSGL_CODE
FROM GL.GL_USSGL_TRANSACTION_CODES;
GL.GL_USSGL_TRANSACTION_CODES does not reference any database object
GL.GL_USSGL_TRANSACTION_CODES is referenced by following:
|
|
|