GP_NRP_GLDTL_VW

(SQL View)
Index Back

GL Grouping Codes View

GL Grouping Codes - Packaging View

SELECT PAY_ENTITY ,BUSINESS_UNIT ,GROUPING_CODE ,PIN_NUM + 50000000 ,ENTRY_TYPE_ID FROM PS_GP_GL_GROUP_DTL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 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.
4 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
5 ENTRY_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Element Entry Type ID