DBA Data[Home] [Help] [Dependency Information]

TABLE: AX.AX_SLE_HEADERS_ARCH

Object Details
Object Name: AX_SLE_HEADERS_ARCH
Object Type: TABLE
Owner: AX
FND Design Data: TableAX.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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: AX_SLE_HEADERS_ARCH_PK
  1. ColumnSET_OF_BOOKS_ID
  2. ColumnJOURNAL_SEQUENCE_ID
  3. ColumnSLE_HEADER_ID
Indexes
Index Type Uniqueness Tablespace Column
AX_SLE_HEADERS_ARCH_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSET_OF_BOOKS_ID
ColumnJOURNAL_SEQUENCE_ID
ColumnSLE_HEADER_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
AX_SLE_HEADERS_ARCH AX_SLE_HEADERS_ARCH_FK1 TableAX_EVENTS AX_SLE_HEADERS_ARCH EVENT_ID
TableAX_SLE_LINES_ARCH AX_SLE_LINES_ARCH_FK1 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
Columns
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
Query Text

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;

Dependencies

[top of page]

AX.AX_SLE_HEADERS_ARCH does not reference any database object

AX.AX_SLE_HEADERS_ARCH is referenced by following:

SchemaAX
ViewAX_SLE_HEADERS_ARCH#