[Home] [Help]
View: PSP_PAYROLL_LINES_C_V
Product: | PSP - Labor Distribution |
Description: | Shows payroll lines that are for credit |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT A.PAYROLL_LINE_ID
, A.PAYROLL_CONTROL_ID
, A.PERSON_ID
, A.ASSIGNMENT_ID
, A.ELEMENT_TYPE_ID
, B.PAYROLL_SOURCE_CODE
, B.SOURCE_TYPE
, B.TIME_PERIOD_ID
, B.BATCH_NAME
, A.PAY_AMOUNT
, B.BUSINESS_GROUP_ID
, B.SET_OF_BOOKS_ID
FROM PSP_PAYROLL_LINES A
, PSP_PAYROLL_CONTROLS B
WHERE A.PAYROLL_CONTROL_ID = B.PAYROLL_CONTROL_ID
AND A.DR_CR_FLAG = 'C'
Columns
Name |
PAYROLL_LINE_ID |
PAYROLL_CONTROL_ID |
PERSON_ID |
ASSIGNMENT_ID |
ELEMENT_TYPE_ID |
PAYROLL_SOURCE_CODE |
SOURCE_TYPE |
TIME_PERIOD_ID |
BATCH_NAME |
PAY_AMOUNT |
BUSINESS_GROUP_ID |
SET_OF_BOOKS_ID |