[Home] [Help] [Dependency Information]
Object Name: | AX_SLE_HEADERS_ARCH |
---|---|
Object Type: | TABLE |
Owner: | AX |
FND Design Data: | AX.AX_SLE_HEADERS_ARCH |
Subobject Name: | |
Status: | VALID |
This table stores the rows purged from the AX_SLE_HEADERS table by the Subledger Archive and Purge program.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AX_SLE_HEADERS_ARCH_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
SET_OF_BOOKS_ID
JOURNAL_SEQUENCE_ID SLE_HEADER_ID |
Table | |
Foreign Table | Foreign Key Column | AX_SLE_HEADERS_ARCH | AX_EVENTS | AX_SLE_HEADERS_ARCH EVENT_ID | AX_SLE_LINES_ARCH | AX_SLE_HEADERS_ARCH |
AX_SLE_LINES_ARCH
SET_OF_BOOKS_ID
AX_SLE_LINES_ARCH JOURNAL_SEQUENCE_ID AX_SLE_LINES_ARCH SLE_HEADER_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
JOURNAL_SEQUENCE_ID | NUMBER | (15) | Yes | Journal sequence identifier |
SLE_HEADER_ID | NUMBER | Yes | Value of the journal sequence | |
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 | Standard Who column | ||
REQUEST_ID | NUMBER | Extended Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Extended Who column | ||
PROGRAM_ID | NUMBER | Extended Who column | ||
PROGRAM_UPDATE_DATE | DATE | Extended Who column | ||
SET_OF_BOOKS_ID | NUMBER | Yes | Set of books identifier | |
APPLICATION_ID | NUMBER | Yes | Application identifier | |
EVENT_ID | NUMBER | Event identifier | ||
EFFECTIVE_DATE | DATE | Accounting date | ||
PERIOD_NAME | VARCHAR2 | (15) | Yes | Period name |
CURRENCY_CODE | VARCHAR2 | (15) | Transaction currency | |
CURRENCY_CONVERSION_DATE | DATE | Currency conversion date (no longer used) | ||
CURRENCY_CONVERSION_RATE | NUMBER | Currency conversion rate (no longer used) | ||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency conversion type (no longer used) | |
REFERENCE_1 | VARCHAR2 | (255) | Character reference column | |
REFERENCE_2 | VARCHAR2 | (255) | Character reference column | |
REFERENCE_3 | VARCHAR2 | (255) | Character reference column | |
REFERENCE_4 | VARCHAR2 | (255) | Character reference column | |
REFERENCE_5 | VARCHAR2 | (255) | Character reference column | |
ORG_ID | NUMBER | (15) | Organization identifier | |
LEGAL_SEQUENCE_ID | NUMBER | (15) | Gapless sequence identifier | |
LEGAL_SEQUENCE_VALUE | NUMBER | (15) | Gapless sequence value | |
TRANSACTION_DATE | DATE | Trading partner accounting date for which tax is reported (for future use) | ||
REFERENCE_NUM1 | NUMBER | Numeric reference column | ||
REFERENCE_NUM2 | NUMBER | Numeric reference column | ||
REFERENCE_NUM3 | NUMBER | Numeric reference column | ||
REFERENCE_NUM4 | NUMBER | Numeric reference column | ||
REFERENCE_NUM5 | NUMBER | Numeric reference column | ||
REFERENCE_DATE1 | DATE | Date reference column | ||
REFERENCE_DATE2 | DATE | Date reference column | ||
REFERENCE_DATE3 | DATE | Date reference column | ||
REFERENCE_DATE4 | DATE | Date reference column | ||
REFERENCE_DATE5 | DATE | Date reference column | ||
DESCRIPTION | VARCHAR2 | (255) | Subledger accounting header description | |
DOC_SEQUENCE_ID | NUMBER | (15) | document sequence identifier (for future use) | |
DOC_SEQUENCE_NUMBER | NUMBER | (15) | document sequence value (for future use) | |
GL_TRANSFER_FLAG | VARCHAR2 | (1) | GL Transfer Flag | |
GL_TRANSFER_DATE | DATE | GL Transfer Date | ||
GL_TRANSFER_RUN_ID | NUMBER | GL Transfer run id | ||
GL_CATEGORY | VARCHAR2 | (30) | GL Category | |
ACCOUNTING_SEQUENCE_ID | NUMBER | Yes | Final accounting sequence id |
Cut, paste (and edit) the following text to query this object:
SELECT JOURNAL_SEQUENCE_ID
, SLE_HEADER_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, SET_OF_BOOKS_ID
, APPLICATION_ID
, EVENT_ID
, EFFECTIVE_DATE
, PERIOD_NAME
, CURRENCY_CODE
, CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_TYPE
, REFERENCE_1
, REFERENCE_2
, REFERENCE_3
, REFERENCE_4
, REFERENCE_5
, ORG_ID
, LEGAL_SEQUENCE_ID
, LEGAL_SEQUENCE_VALUE
, TRANSACTION_DATE
, REFERENCE_NUM1
, REFERENCE_NUM2
, REFERENCE_NUM3
, REFERENCE_NUM4
, REFERENCE_NUM5
, REFERENCE_DATE1
, REFERENCE_DATE2
, REFERENCE_DATE3
, REFERENCE_DATE4
, REFERENCE_DATE5
, DESCRIPTION
, DOC_SEQUENCE_ID
, DOC_SEQUENCE_NUMBER
, GL_TRANSFER_FLAG
, GL_TRANSFER_DATE
, GL_TRANSFER_RUN_ID
, GL_CATEGORY
, ACCOUNTING_SEQUENCE_ID
FROM AX.AX_SLE_HEADERS_ARCH;
AX.AX_SLE_HEADERS_ARCH does not reference any database object
AX.AX_SLE_HEADERS_ARCH is referenced by following:
|
|
|