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

TABLE: PSA.PSA_XLA_DIST_LINKS_LOGS

Object Details
Object Name: PSA_XLA_DIST_LINKS_LOGS
Object Type: TABLE
Owner: PSA
Subobject Name:
Status: VALID


This table stores information from xla_distribution_links which would have otherwise got lost after session expiry. The table is populated if the following conditions are met:


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Yes Internal Id of the application
EVENT_ID NUMBER (15) Yes Event Id
AE_HEADER_ID NUMBER (15) Yes Subledger journal entry identifier
AE_LINE_NUM NUMBER (38) Yes Subledger journal entry line number
SOURCE_DISTRIBUTION_TYPE VARCHAR2 (30) Yes Source distribution type
SOURCE_DISTRIBUTION_ID_CHAR_1 VARCHAR2 (240)
Flexible source distribution id (Char)
SOURCE_DISTRIBUTION_ID_CHAR_2 VARCHAR2 (240)
Flexible source distribution id (Char)
SOURCE_DISTRIBUTION_ID_CHAR_3 VARCHAR2 (240)
Flexible source distribution id (Char)
SOURCE_DISTRIBUTION_ID_CHAR_4 VARCHAR2 (240)
Flexible source distribution id (Char)
SOURCE_DISTRIBUTION_ID_CHAR_5 VARCHAR2 (240)
Flexible source distribution id (Char)
SOURCE_DISTRIBUTION_ID_NUM_1 NUMBER (38)
Transaction source distribution identifer (Number)
SOURCE_DISTRIBUTION_ID_NUM_2 NUMBER (38)
Transaction source distribution identifer (Number)
SOURCE_DISTRIBUTION_ID_NUM_3 NUMBER (38)
Transaction source distribution identifer (Number)
SOURCE_DISTRIBUTION_ID_NUM_4 NUMBER (38)
Transaction source distribution identifer (Number)
SOURCE_DISTRIBUTION_ID_NUM_5 NUMBER (38)
Transaction source distribution identifer (Number)
TAX_LINE_REF_ID NUMBER (15)
Detail Tax Line Reference
TAX_SUMMARY_LINE_REF_ID NUMBER (15)
Summary Tax Line Reference
TAX_REC_NREC_DIST_REF_ID NUMBER (15)
Detail Tax Distribution Reference
STATISTICAL_AMOUNT NUMBER

Statistical amount
REF_AE_HEADER_ID NUMBER (15) Yes Reversed subledger journal entry header identifier.
REF_TEMP_LINE_NUM NUMBER

Reversed suledger journal entry temporary line number
ACCOUNTING_LINE_CODE VARCHAR2 (30)
Accounting line type code
ACCOUNTING_LINE_TYPE_CODE VARCHAR2 (1)
Accounting line type code
MERGE_DUPLICATE_CODE VARCHAR2 (1) Yes Indicates how duplicate subledger journal lines are merged. The possible values are 'A' - Merge all lines 'W' - All matching debit lines will be merged and all matching credit lines will be merged to produce a single debit and/or a single credit line. 'N' - Do not merge matching lines.
TEMP_LINE_NUM NUMBER (15) Yes It is the intermediary line number generated by the accounting engine when the entries are in most detail form
REF_EVENT_ID NUMBER (15)
Reference EVENT_ID. For a reversal row it is the EVENT_ID from the actual AE line reversed otherwise it is NULL
LINE_DEFINITION_OWNER_CODE VARCHAR2 (30)
Journal lines definition owner code
LINE_DEFINITION_CODE VARCHAR2 (30)
Journal lines definition code
EVENT_CLASS_CODE VARCHAR2 (30)
Event class code
EVENT_TYPE_CODE VARCHAR2 (30)
Event type code
UPG_BATCH_ID NUMBER (15)
Upgrade batch identifier
CALCULATE_ACCTD_AMTS_FLAG VARCHAR2 (1)
Indicates whether the accounted amounts are calculated by SLA or passed through transaction objects. Y - indicates that accounted amounts are calculated by the accounting program. N- indicates that accounted amounts were passed through the extract.
CALCULATE_G_L_AMTS_FLAG VARCHAR2 (1)
Indicates whether the gain/loss amounts is calculated by the accounting engine. Y - indicates that gain/loss amounts are calculated by the accounting program. N- indicates that gain/loss amounts were passed through the extract.
GAIN_OR_LESS_REF VARCHAR2 (240)
Used to group entry lines together when calculating gain/loss.
ROUNDING_CLASS_CODE VARCHAR2 (30)
The accounting class associated to the journal line. It is used as the grouping criteria for rounding. Accounting Program uses this field and the document_rounding_level together to group lines together to perform rounding.
DOCUMENT_ROUNDING_LEVEL VARCHAR2 (30)
Indicates the document identifier for which the accounting engine must perform the rounding. Accounting Program uses this field and the rounding_class_code together to group lines together to perform rounding.
UNROUNDED_ENTERED_DR NUMBER

Unrounded Entered Debit Amount for the journal line
UNROUNDED_ENTERED_CR NUMBER

Unrounded Entered Credit Amount for the journal line
DOC_ROUNDING_ENTERED_AMT NUMBER

The rounding amount for entered amount calculated by the accounting engine for the document
DOC_ROUNDING_ACCTD_AMT NUMBER

The rounding amount for accounted amount calculated by the accounting engine for the document
UNROUNDED_ACCOUNTED_CR NUMBER

Unrounded accounted cr
UNROUNDED_ACCOUNTED_DR NUMBER

Unrounded accounted dr
ALLOC_TO_APPLICATION_ID NUMBER (15)
Application identifier of the entry to which the transaction is being allocated
ALLOC_TO_ENTITY_CODE VARCHAR2 (30)
Entity code of the entry to which the transaction is being allocated
ALLOC_TO_SOURCE_ID_NUM_1 NUMBER (15)
System transaction identifier of the entry to which the transaction is being allocated
ALLOC_TO_SOURCE_ID_NUM_2 NUMBER (15)
System transaction identifier of the entry to which the transaction is being allocated
ALLOC_TO_SOURCE_ID_NUM_3 NUMBER (15)
System transaction identifier of the entry to which the transaction is being allocated
ALLOC_TO_SOURCE_ID_NUM_4 NUMBER (15)
System transaction identifier of the entry to which the transaction is being allocated
ALLOC_TO_SOURCE_ID_CHAR_1 VARCHAR2 (30)
System transaction identifier of the entry to which the transaction is being allocated
ALLOC_TO_SOURCE_ID_CHAR_2 VARCHAR2 (30)
System transaction identifier of the entry to which the transaction is being allocated
ALLOC_TO_SOURCE_ID_CHAR_3 VARCHAR2 (30)
System transaction identifier of the entry to which the transaction is being allocated
ALLOC_TO_SOURCE_ID_CHAR_4 VARCHAR2 (30)
System transaction identifier of the entry to which the transaction is being allocated
ALLOC_TO_DISTRIBUTION_TYPE VARCHAR2 (30)
Distribution type of the entity to which the transaction is being allocated
ALLOC_TO_DIST_ID_NUM_1 NUMBER (15)
Distribution identifier of the entity to which the transaction is being allocated
ALLOC_TO_DIST_ID_NUM_2 NUMBER (15)
Distribution identifier of the entity to which the transaction is being allocated
ALLOC_TO_DIST_ID_NUM_3 NUMBER (15)
Distribution identifier of the entity to which the transaction is being allocated
ALLOC_TO_DIST_ID_NUM_4 NUMBER (15)
Distribution identifier of the entity to which the transaction is being allocated
ALLOC_TO_DIST_ID_NUM_5 NUMBER (15)
Distribution identifier of the entity to which the transaction is being allocated
ALLOC_TO_DIST_ID_CHAR_1 VARCHAR2 (30)
Distribution identifier of the entity to which the transaction is being allocated
ALLOC_TO_DIST_ID_CHAR_2 VARCHAR2 (30)
Distribution identifier of the entity to which the transaction is being allocated
ALLOC_TO_DIST_ID_CHAR_3 VARCHAR2 (30)
Distribution identifier of the entity to which the transaction is being allocated
ALLOC_TO_DIST_ID_CHAR_4 VARCHAR2 (30)
Distribution identifier of the entity to which the transaction is being allocated
ALLOC_TO_DIST_ID_CHAR_5 VARCHAR2 (30)
Distribution identifier of the entity to which the transaction is being allocated
APPLIED_TO_APPLICATION_ID NUMBER

Applied to application id
APPLIED_TO_ENTITY_CODE VARCHAR2 (240)
Applied to Entity code
APPLIED_TO_ENTITY_ID VARCHAR2 (240)
Applied to Entity id
APPLIED_TO_SOURCE_ID_NUM_1 NUMBER

Applied to Transaction source distribution identifier
APPLIED_TO_SOURCE_ID_NUM_2 NUMBER

Applied to Transaction source distribution identifier
APPLIED_TO_SOURCE_ID_NUM_3 NUMBER

Applied to Transaction source distribution identifier
APPLIED_TO_SOURCE_ID_NUM_4 NUMBER

Applied to Transaction source distribution identifier
APPLIED_TO_SOURCE_ID_CHAR_1 VARCHAR2 (240)
Applied to Flexible source distribution Id (Char)
APPLIED_TO_SOURCE_ID_CHAR_2 VARCHAR2 (240)
Applied to Flexible source distribution Id (Char)
APPLIED_TO_SOURCE_ID_CHAR_3 VARCHAR2 (240)
Applied to Flexible source distribution Id (Char)
APPLIED_TO_SOURCE_ID_CHAR_4 VARCHAR2 (240)
Applied to Flexible source distribution Id (Char)
APPLIED_TO_DISTRIBUTION_TYPE VARCHAR2 (240)
Applied to Distribution type
APPLIED_TO_DIST_ID_NUM_1 NUMBER

Applied to Transaction Distribution Identifier
APPLIED_TO_DIST_ID_NUM_2 NUMBER

Applied to Transaction Distribution Identifier
APPLIED_TO_DIST_ID_NUM_3 NUMBER

Applied to Transaction Distribution Identifier
APPLIED_TO_DIST_ID_NUM_4 NUMBER

Applied to Transaction Distribution Identifier
APPLIED_TO_DIST_ID_NUM_5 NUMBER

Applied to Transaction Distribution Identifier
APPLIED_TO_DIST_ID_CHAR_1 VARCHAR2 (240)
Applied to Transaction Distribution Identifier(char)
APPLIED_TO_DIST_ID_CHAR_2 VARCHAR2 (240)
Applied to Transaction Distribution Identifier(char)
APPLIED_TO_DIST_ID_CHAR_3 VARCHAR2 (240)
Applied to Transaction Distribution Identifier(char)
APPLIED_TO_DIST_ID_CHAR_4 VARCHAR2 (240)
Applied to Transaction Distribution Identifier(char)
APPLIED_TO_DIST_ID_CHAR_5 VARCHAR2 (240)
Applied to Transaction Distribution Identifier(char)
PHASE VARCHAR2 (240)
Phase
CREATION_DATE DATE

Creation Date
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT APPLICATION_ID
,      EVENT_ID
,      AE_HEADER_ID
,      AE_LINE_NUM
,      SOURCE_DISTRIBUTION_TYPE
,      SOURCE_DISTRIBUTION_ID_CHAR_1
,      SOURCE_DISTRIBUTION_ID_CHAR_2
,      SOURCE_DISTRIBUTION_ID_CHAR_3
,      SOURCE_DISTRIBUTION_ID_CHAR_4
,      SOURCE_DISTRIBUTION_ID_CHAR_5
,      SOURCE_DISTRIBUTION_ID_NUM_1
,      SOURCE_DISTRIBUTION_ID_NUM_2
,      SOURCE_DISTRIBUTION_ID_NUM_3
,      SOURCE_DISTRIBUTION_ID_NUM_4
,      SOURCE_DISTRIBUTION_ID_NUM_5
,      TAX_LINE_REF_ID
,      TAX_SUMMARY_LINE_REF_ID
,      TAX_REC_NREC_DIST_REF_ID
,      STATISTICAL_AMOUNT
,      REF_AE_HEADER_ID
,      REF_TEMP_LINE_NUM
,      ACCOUNTING_LINE_CODE
,      ACCOUNTING_LINE_TYPE_CODE
,      MERGE_DUPLICATE_CODE
,      TEMP_LINE_NUM
,      REF_EVENT_ID
,      LINE_DEFINITION_OWNER_CODE
,      LINE_DEFINITION_CODE
,      EVENT_CLASS_CODE
,      EVENT_TYPE_CODE
,      UPG_BATCH_ID
,      CALCULATE_ACCTD_AMTS_FLAG
,      CALCULATE_G_L_AMTS_FLAG
,      GAIN_OR_LESS_REF
,      ROUNDING_CLASS_CODE
,      DOCUMENT_ROUNDING_LEVEL
,      UNROUNDED_ENTERED_DR
,      UNROUNDED_ENTERED_CR
,      DOC_ROUNDING_ENTERED_AMT
,      DOC_ROUNDING_ACCTD_AMT
,      UNROUNDED_ACCOUNTED_CR
,      UNROUNDED_ACCOUNTED_DR
,      ALLOC_TO_APPLICATION_ID
,      ALLOC_TO_ENTITY_CODE
,      ALLOC_TO_SOURCE_ID_NUM_1
,      ALLOC_TO_SOURCE_ID_NUM_2
,      ALLOC_TO_SOURCE_ID_NUM_3
,      ALLOC_TO_SOURCE_ID_NUM_4
,      ALLOC_TO_SOURCE_ID_CHAR_1
,      ALLOC_TO_SOURCE_ID_CHAR_2
,      ALLOC_TO_SOURCE_ID_CHAR_3
,      ALLOC_TO_SOURCE_ID_CHAR_4
,      ALLOC_TO_DISTRIBUTION_TYPE
,      ALLOC_TO_DIST_ID_NUM_1
,      ALLOC_TO_DIST_ID_NUM_2
,      ALLOC_TO_DIST_ID_NUM_3
,      ALLOC_TO_DIST_ID_NUM_4
,      ALLOC_TO_DIST_ID_NUM_5
,      ALLOC_TO_DIST_ID_CHAR_1
,      ALLOC_TO_DIST_ID_CHAR_2
,      ALLOC_TO_DIST_ID_CHAR_3
,      ALLOC_TO_DIST_ID_CHAR_4
,      ALLOC_TO_DIST_ID_CHAR_5
,      APPLIED_TO_APPLICATION_ID
,      APPLIED_TO_ENTITY_CODE
,      APPLIED_TO_ENTITY_ID
,      APPLIED_TO_SOURCE_ID_NUM_1
,      APPLIED_TO_SOURCE_ID_NUM_2
,      APPLIED_TO_SOURCE_ID_NUM_3
,      APPLIED_TO_SOURCE_ID_NUM_4
,      APPLIED_TO_SOURCE_ID_CHAR_1
,      APPLIED_TO_SOURCE_ID_CHAR_2
,      APPLIED_TO_SOURCE_ID_CHAR_3
,      APPLIED_TO_SOURCE_ID_CHAR_4
,      APPLIED_TO_DISTRIBUTION_TYPE
,      APPLIED_TO_DIST_ID_NUM_1
,      APPLIED_TO_DIST_ID_NUM_2
,      APPLIED_TO_DIST_ID_NUM_3
,      APPLIED_TO_DIST_ID_NUM_4
,      APPLIED_TO_DIST_ID_NUM_5
,      APPLIED_TO_DIST_ID_CHAR_1
,      APPLIED_TO_DIST_ID_CHAR_2
,      APPLIED_TO_DIST_ID_CHAR_3
,      APPLIED_TO_DIST_ID_CHAR_4
,      APPLIED_TO_DIST_ID_CHAR_5
,      PHASE
,      CREATION_DATE
FROM PSA.PSA_XLA_DIST_LINKS_LOGS;

Dependencies

[top of page]

PSA.PSA_XLA_DIST_LINKS_LOGS does not reference any database object

PSA.PSA_XLA_DIST_LINKS_LOGS is referenced by following:

SchemaPSA
ViewPSA_XLA_DIST_LINKS_LOGS#