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

TABLE: PSP.PSP_PRE_GEN_DIST_LINES_HISTORY

Object Details
Object Name: PSP_PRE_GEN_DIST_LINES_HISTORY
Object Type: TABLE
Owner: PSP
FND Design Data: TablePSP.PSP_PRE_GEN_DIST_LINES_HISTORY
Subobject Name:
Status: VALID


PSP_PRE_GEN_DIST_LINES_HISTORY stores the pre-generated distribution
lines that are successfully transferred to General Ledger, Grants
Accounting, or Project Accounting.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PSP_PRE_GEN_DIST_LINES_HIST_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRE_GEN_DIST_LINE_ID
PSP_PRE_GEN_DIST_LINES_HIST_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAYROLL_CONTROL_ID
PSP_PRE_GEN_DIST_LINES_HIST_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUSPENSE_ORG_ACCOUNT_ID
PSP_PRE_GEN_DIST_LINES_HIST_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSIGNMENT_ID
ColumnPERSON_ID
ColumnDISTRIBUTION_DATE
PSP_PRE_GEN_DIST_LINES_HIST_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnADJUSTMENT_BATCH_NAME
PSP_PRE_GEN_DIST_LINES_HIST_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUMMARY_LINE_ID
PSP_PRE_GEN_DIST_LINES_HIST_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDISTRIBUTION_DATE
Columns
Name Datatype Length Mandatory Comments
PRE_GEN_DIST_LINE_ID NUMBER (10) Yes Pre-generated distribution line identifier
DISTRIBUTION_INTERFACE_ID NUMBER (10) Yes Distribution interface identifier
PERSON_ID NUMBER (9) Yes Person identifier
ASSIGNMENT_ID NUMBER (9) Yes Assignment identifier
ELEMENT_TYPE_ID NUMBER (9) Yes Element type identifier
DISTRIBUTION_DATE DATE
Yes Distribution date
EFFECTIVE_DATE DATE
Yes Accounting date for transferring to General Ledger and expenditure item date for transferring to Grants Accounting
DISTRIBUTION_AMOUNT NUMBER
Yes Distribution amount
DR_CR_FLAG VARCHAR2 (1) Yes D indicates that the distribution amount is a Debit and C indicates that it is a Credit.
PAYROLL_CONTROL_ID NUMBER (10) Yes Payroll control identifier
SOURCE_TYPE VARCHAR2 (1) Yes Source type
SOURCE_CODE VARCHAR2 (30) Yes Source code
TIME_PERIOD_ID NUMBER (15) Yes Time period identifier
BATCH_NAME VARCHAR2 (30) Yes Interface batch name
STATUS_CODE VARCHAR2 (1) Yes Indicates status of the pre-generated distribution lines. N indicates New, S indicates Summarized, and A indicates Accepted by General Ledger or Grants Accounting.
SET_OF_BOOKS_ID NUMBER (15) Yes Set of Books identifier
GL_CODE_COMBINATION_ID NUMBER (15)
General Ledger Code Combination identifier
PROJECT_ID NUMBER (15)
Project identifier
EXPENDITURE_ORGANIZATION_ID NUMBER (15)
Expenditure organization identifier
EXPENDITURE_TYPE VARCHAR2 (30)
Expenditure type
TASK_ID NUMBER (15)
Task identifier
AWARD_ID NUMBER (15)
Award identifier
SUSPENSE_ORG_ACCOUNT_ID NUMBER (9)
Suspense organization account identifier
SUSPENSE_REASON_CODE VARCHAR2 (50)
Reason code for using the suspense account
INCLUDE_IN_ER_FLAG VARCHAR2 (1)
Y indicates that the line is to be used in effort reporting. NULL or N indicates that it is not to be used in effort reporting.
EFFORT_REPORT_ID NUMBER (9)
Effort report identifier
VERSION_NUM NUMBER (2)
Effort report version number
SUMMARY_LINE_ID NUMBER (10)
Summary line identifier
REVERSAL_ENTRY_FLAG VARCHAR2 (1)
Y indicates that the record is created for sending balancing transactions to General Ledger. NULL or N indicates that it is a normal distribution line.
USER_DEFINED_FIELD VARCHAR2 (30)
User populates this field through user extension
ADJUSTMENT_BATCH_NAME VARCHAR2 (30)
Adjustment batch name
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ALL_ORGANIZATION_UNITS
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment column
SUSPENSE_AUTO_GLCCID NUMBER

GL Code id after applying autopop rules at suspense account level
SUSPENSE_AUTO_EXP_TYPE VARCHAR2 (30)
Exp Type after applying autopop rules at suspense account level
Query Text

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


SELECT PRE_GEN_DIST_LINE_ID
,      DISTRIBUTION_INTERFACE_ID
,      PERSON_ID
,      ASSIGNMENT_ID
,      ELEMENT_TYPE_ID
,      DISTRIBUTION_DATE
,      EFFECTIVE_DATE
,      DISTRIBUTION_AMOUNT
,      DR_CR_FLAG
,      PAYROLL_CONTROL_ID
,      SOURCE_TYPE
,      SOURCE_CODE
,      TIME_PERIOD_ID
,      BATCH_NAME
,      STATUS_CODE
,      SET_OF_BOOKS_ID
,      GL_CODE_COMBINATION_ID
,      PROJECT_ID
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_TYPE
,      TASK_ID
,      AWARD_ID
,      SUSPENSE_ORG_ACCOUNT_ID
,      SUSPENSE_REASON_CODE
,      INCLUDE_IN_ER_FLAG
,      EFFORT_REPORT_ID
,      VERSION_NUM
,      SUMMARY_LINE_ID
,      REVERSAL_ENTRY_FLAG
,      USER_DEFINED_FIELD
,      ADJUSTMENT_BATCH_NAME
,      BUSINESS_GROUP_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      SUSPENSE_AUTO_GLCCID
,      SUSPENSE_AUTO_EXP_TYPE
FROM PSP.PSP_PRE_GEN_DIST_LINES_HISTORY;

Dependencies

[top of page]

PSP.PSP_PRE_GEN_DIST_LINES_HISTORY does not reference any database object

PSP.PSP_PRE_GEN_DIST_LINES_HISTORY is referenced by following:

SchemaPSP
ViewPSP_PRE_GEN_DIST_LINES_HISTOR#