VIEW: PSP.PSP_DISTRIBUTION_INTERFACE#

Source

View Text - Preformatted

select DISTRIBUTION_INTERFACE_ID DISTRIBUTION_INTERFACE_ID, PERSON_ID PERSON_ID, ASSIGNMENT_ID ASSIGNMENT_ID, ELEMENT_TYPE_ID ELEMENT_TYPE_ID, DISTRIBUTION_DATE DISTRIBUTION_DATE, DISTRIBUTION_AMOUNT DISTRIBUTION_AMOUNT, PAYROLL_ID PAYROLL_ID, TIME_PERIOD_ID TIME_PERIOD_ID, DR_CR_FLAG DR_CR_FLAG, SOURCE_CODE SOURCE_CODE, GL_CODE_COMBINATION_ID GL_CODE_COMBINATION_ID, PROJECT_ID PROJECT_ID, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, TASK_ID TASK_ID, AWARD_ID AWARD_ID, STATUS_CODE STATUS_CODE, BATCH_NAME BATCH_NAME, ERROR_CODE ERROR_CODE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, GL_POSTING_OVERRIDE_DATE GL_POSTING_OVERRIDE_DATE, GMS_POSTING_OVERRIDE_DATE GMS_POSTING_OVERRIDE_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, SUSPENSE_ORG_ACCOUNT_ID SUSPENSE_ORG_ACCOUNT_ID, CURRENCY_CODE CURRENCY_CODE, SUSPENSE_AUTO_GLCCID SUSPENSE_AUTO_GLCCID, SUSPENSE_AUTO_EXP_TYPE SUSPENSE_AUTO_EXP_TYPE from "PSP"."PSP_DISTRIBUTION_INTERFACE"

View Text - HTML Formatted

SELECT DISTRIBUTION_INTERFACE_ID DISTRIBUTION_INTERFACE_ID
, PERSON_ID PERSON_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, DISTRIBUTION_DATE DISTRIBUTION_DATE
, DISTRIBUTION_AMOUNT DISTRIBUTION_AMOUNT
, PAYROLL_ID PAYROLL_ID
, TIME_PERIOD_ID TIME_PERIOD_ID
, DR_CR_FLAG DR_CR_FLAG
, SOURCE_CODE SOURCE_CODE
, GL_CODE_COMBINATION_ID GL_CODE_COMBINATION_ID
, PROJECT_ID PROJECT_ID
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, TASK_ID TASK_ID
, AWARD_ID AWARD_ID
, STATUS_CODE STATUS_CODE
, BATCH_NAME BATCH_NAME
, ERROR_CODE ERROR_CODE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, GL_POSTING_OVERRIDE_DATE GL_POSTING_OVERRIDE_DATE
, GMS_POSTING_OVERRIDE_DATE GMS_POSTING_OVERRIDE_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, SUSPENSE_ORG_ACCOUNT_ID SUSPENSE_ORG_ACCOUNT_ID
, CURRENCY_CODE CURRENCY_CODE
, SUSPENSE_AUTO_GLCCID SUSPENSE_AUTO_GLCCID
, SUSPENSE_AUTO_EXP_TYPE SUSPENSE_AUTO_EXP_TYPE
FROM "PSP"."PSP_DISTRIBUTION_INTERFACE"