[Home] [Help] [Dependency Information]
Object Name: | AX_SLE_HEADERS# |
---|---|
Object Type: | VIEW |
Owner: | AX |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
JOURNAL_SEQUENCE_ID | NUMBER | (15) | Yes | |
SLE_HEADER_ID | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
SET_OF_BOOKS_ID | NUMBER | Yes | ||
APPLICATION_ID | NUMBER | Yes | ||
EVENT_ID | NUMBER | |||
EFFECTIVE_DATE | DATE | |||
PERIOD_NAME | VARCHAR2 | (15) | Yes | |
CURRENCY_CODE | VARCHAR2 | (15) | ||
CURRENCY_CONVERSION_DATE | DATE | |||
CURRENCY_CONVERSION_RATE | NUMBER | |||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
REFERENCE_1 | VARCHAR2 | (255) | ||
REFERENCE_2 | VARCHAR2 | (255) | ||
REFERENCE_3 | VARCHAR2 | (255) | ||
REFERENCE_4 | VARCHAR2 | (255) | ||
REFERENCE_5 | VARCHAR2 | (255) | ||
ORG_ID | NUMBER | (15) | ||
LEGAL_SEQUENCE_ID | NUMBER | (15) | ||
LEGAL_SEQUENCE_VALUE | NUMBER | (15) | ||
TRANSACTION_DATE | DATE | |||
REFERENCE_NUM1 | NUMBER | |||
REFERENCE_NUM2 | NUMBER | |||
REFERENCE_NUM3 | NUMBER | |||
REFERENCE_NUM4 | NUMBER | |||
REFERENCE_NUM5 | NUMBER | |||
REFERENCE_DATE1 | DATE | |||
REFERENCE_DATE2 | DATE | |||
REFERENCE_DATE3 | DATE | |||
REFERENCE_DATE4 | DATE | |||
REFERENCE_DATE5 | DATE | |||
DESCRIPTION | VARCHAR2 | (255) | ||
DOC_SEQUENCE_ID | NUMBER | (15) | ||
DOC_SEQUENCE_NUMBER | NUMBER | (15) | ||
GL_TRANSFER_FLAG | VARCHAR2 | (1) | ||
GL_TRANSFER_DATE | DATE | |||
GL_TRANSFER_RUN_ID | NUMBER | |||
GL_CATEGORY | VARCHAR2 | (30) | ||
ACCOUNTING_SEQUENCE_ID | NUMBER | Yes |
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#;
|
|
|