[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PSP_DISTRIBUTION_INTERFACE |
|---|---|
| Object Type: | TABLE |
| Owner: | PSP |
| FND Design Data: |  PSP.PSP_DISTRIBUTION_INTERFACE
|
| Subobject Name: | |
| Status: | VALID |
PSP_DISTRIBUTION_INTERFACE contains pregenerated labor distribution
lines to be summarized and transferred to General Ledger, Grants
Accounting, or Project Accounting. Information in this table is used for
integrating timecard data with labor distribution data. The data in this
table is at the distribution lines level and consists of employee and pay
information and financial accounts for particular time periods.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PSP_DISTRIBUTION_INTERFACE_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 BATCH_NAME
DISTRIBUTION_INTERFACE_ID
|
| PSP_DISTRIBUTION_INTERFACE_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
BATCH_NAME
BUSINESS_GROUP_ID
SET_OF_BOOKS_ID
|
| PSP_DISTRIBUTION_INTERFACE_N2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
DISTRIBUTION_DATE
BATCH_NAME
|
| PSP_DISTRIBUTION_INTERFACE_U2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
DISTRIBUTION_INTERFACE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| DISTRIBUTION_INTERFACE_ID | NUMBER | (10) | Yes | System-generated primary key |
| PERSON_ID | NUMBER | (9) | Yes | Employee Identifier.Foreign key to PER_PEOPLE_F |
| ASSIGNMENT_ID | NUMBER | (9) | Yes | Assignment Identifier. Foreign key to PER_ASSIGNMENTS_F |
| ELEMENT_TYPE_ID | NUMBER | (9) | Yes | Element Identifier. Foreign key to PSP_ELEMENT_TYPES_F |
| DISTRIBUTION_DATE | DATE | Yes | Date the amount is distributed. This is the default date used for summarizing transactions for posting to General Ledger, Grants Accounting and Projects. | |
| DISTRIBUTION_AMOUNT | NUMBER | Yes | Distribution amount | |
| PAYROLL_ID | NUMBER | (9) | Yes | Payroll Identifier. Foreign key to PAY_PAYROLLS_F |
| TIME_PERIOD_ID | NUMBER | (9) | Yes | Time Period Identifier. Foreign key to PER_TIME_PERIODS |
| DR_CR_FLAG | VARCHAR2 | (1) | Yes | Indicates whether distribution amount is debit or credit. D indicates Debit and C indicates Credit amount. |
| SOURCE_CODE | VARCHAR2 | (30) | Yes | Payroll Batch Source. Foreign key to PSP_PAYROLL_SOURCES |
| GL_CODE_COMBINATION_ID | NUMBER | (15) | General Ledger code identifier. Required if there is no Projects/Awards data entered. | |
| PROJECT_ID | NUMBER | (15) | Project identifier. Required if gl_code_combination_id is not entered. | |
| EXPENDITURE_ORGANIZATION_ID | NUMBER | (15) | Expenditure organization identifier. Required when gl_code_combination_id is not entered. | |
| EXPENDITURE_TYPE | VARCHAR2 | (30) | Expenditure type. Required when gl_code_combination_id is not entered. | |
| TASK_ID | NUMBER | (15) | Task identifier. Required when gl_code_combination_id is not entered. | |
| AWARD_ID | NUMBER | (15) | Award identifier. Required ifgl_code_combination_id is not entered and GMS charging is used. NOt required if using only Projects charging | |
| STATUS_CODE | VARCHAR2 | (1) | Yes | Indicates status of current distribution line. N indicates New, V indicates Valid, E indicates Error, and T indicates Transferred. |
| BATCH_NAME | VARCHAR2 | (30) | Yes | Batch name for current pre-generated distribution lines |
| ERROR_CODE | VARCHAR2 | (30) | Indicates error for current distribution line | |
| 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 | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who column |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| GL_POSTING_OVERRIDE_DATE | DATE | General Ledger override date for posting.If defined, this date overrides the distribution date for posting to General Ledger. | ||
| GMS_POSTING_OVERRIDE_DATE | DATE | Grants Accounting posting date to override. For future use. | ||
| BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Business Group Identifier. Foreign key to HR_ALL_ORGANIZATION_UNITS |
| SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Set of books Identifier. Foreign key to GL_SETS_OF_BOOKS |
| SUSPENSE_ORG_ACCOUNT_ID | NUMBER | (9) | Organization suspense account identifier. Foreign key to PSP_ORGANIZATION_ACCOUNTS. | |
| CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
| SUSPENSE_AUTO_GLCCID | NUMBER | GL Acct derived from Auto Pop rules at suspense level | ||
| SUSPENSE_AUTO_EXP_TYPE | VARCHAR2 | (30) | Exp Type derived from Auto Pop rules at suspense level |
Cut, paste (and edit) the following text to query this object:
SELECT DISTRIBUTION_INTERFACE_ID
, PERSON_ID
, ASSIGNMENT_ID
, ELEMENT_TYPE_ID
, DISTRIBUTION_DATE
, DISTRIBUTION_AMOUNT
, PAYROLL_ID
, TIME_PERIOD_ID
, DR_CR_FLAG
, SOURCE_CODE
, GL_CODE_COMBINATION_ID
, PROJECT_ID
, EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_TYPE
, TASK_ID
, AWARD_ID
, STATUS_CODE
, BATCH_NAME
, ERROR_CODE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, GL_POSTING_OVERRIDE_DATE
, GMS_POSTING_OVERRIDE_DATE
, BUSINESS_GROUP_ID
, SET_OF_BOOKS_ID
, SUSPENSE_ORG_ACCOUNT_ID
, CURRENCY_CODE
, SUSPENSE_AUTO_GLCCID
, SUSPENSE_AUTO_EXP_TYPE
FROM PSP.PSP_DISTRIBUTION_INTERFACE;
PSP.PSP_DISTRIBUTION_INTERFACE does not reference any database object
PSP.PSP_DISTRIBUTION_INTERFACE is referenced by following:
PSP
PSP_DISTRIBUTION_INTERFACE#
|
|
|
|