[Home] [Help] [Dependency Information]
Object Name: | XLA_ACCT_PROG_SEQ_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | XLA.XLA_ACCT_PROG_SEQ_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view is used in assigning the completion based sequence numbers to the journal entries generated during a run of accounting program.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AE_HEADER_ID | NUMBER | (15) | Yes | Accounting entry id |
LEDGER_ID | NUMBER | (15) | Yes | Ledger id |
BALANCE_TYPE_CODE | VARCHAR2 | (1) | Yes | Balance type (Actual, Budget, or Encumbrance) |
JE_SOURCE_NAME | VARCHAR2 | (30) | Yes | General Ledger source name |
JE_CATEGORY_NAME | VARCHAR2 | (30) | Yes | General Ledger category name |
DOC_CATEGORY_CODE | VARCHAR2 | (30) | Document sequence category category code. It used as part of the subledger journal entry sequencing criteria. | |
ACCOUNTING_EVENT_TYPE_CODE | VARCHAR2 | (30) | Yes | Event type code |
ACCOUNTING_ENTRY_TYPE_CODE | VARCHAR2 | (30) | Yes | Accounting entry type code |
GL_DATE | DATE | Yes | Accounting date | |
COMPLETION_DATE | DATE | Subledger journal entry completion date | ||
COMPLETION_ACCT_SEQ_ASSIGN_ID | NUMBER | (15) | Journal entry completion sequence assignment identifier | |
COMPLETION_ACCT_SEQ_VERSION_ID | NUMBER | (15) | Subledger journal entry creation sequence Identifier | |
COMPLETION_ACCT_SEQ_VALUE | NUMBER | Subledger journal entry creation sequence Value | ||
APPLICATION_ID | NUMBER | (15) | Yes | Internal Id of the application |
Cut, paste (and edit) the following text to query this object:
SELECT AE_HEADER_ID
, LEDGER_ID
, BALANCE_TYPE_CODE
, JE_SOURCE_NAME
, JE_CATEGORY_NAME
, DOC_CATEGORY_CODE
, ACCOUNTING_EVENT_TYPE_CODE
, ACCOUNTING_ENTRY_TYPE_CODE
, GL_DATE
, COMPLETION_DATE
, COMPLETION_ACCT_SEQ_ASSIGN_ID
, COMPLETION_ACCT_SEQ_VERSION_ID
, COMPLETION_ACCT_SEQ_VALUE
, APPLICATION_ID
FROM APPS.XLA_ACCT_PROG_SEQ_V;
|
|
|