GP_GL_NO_ACC_VW

(SQL View)
 Index Back

GP GL DATA w/o account no

Used to display to user GL transactions that were not assigned account numbers

SELECT CAL_RUN_ID ,PAY_ENTITY ,BUSINESS_UNIT ,GROUPING_CODE ,PIN_CHART1_VAL ,PIN_CHART2_VAL ,PIN_CHART3_VAL ,PIN_CHART4_VAL ,PIN_CHART5_VAL ,PIN_CHART6_VAL ,PIN_CHART7_VAL ,PIN_CHART8_VAL ,SUM(CALC_RSLT_VAL) ,CURRENCY_CD FROM PS_GP_GL_DATA WHERE ACCOUNT = ' ' GROUP BY CAL_RUN_ID,PAY_ENTITY,BUSINESS_UNIT,GROUPING_CODE,PIN_CHART1_VAL,PIN_CHART2_VAL ,PIN_CHART3_VAL ,PIN_CHART4_VAL ,PIN_CHART5_VAL ,PIN_CHART6_VAL ,PIN_CHART7_VAL ,PIN_CHART8_VAL,CURRENCY_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
2 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 GROUPING_CODE Character(15) VARCHAR2(15) NOT NULL Identifier (name) used to group a number of elements (earnings or deductions) that can be treated equally (posted to the same account) for GL purposes.
5 PIN_CHART1_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value
6 PIN_CHART2_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value
7 PIN_CHART3_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value`
8 PIN_CHART4_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value
9 PIN_CHART5_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value
10 PIN_CHART6_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value
11 PIN_CHART7_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value
12 PIN_CHART8_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value
13 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code