GP_NRP_GLSET_VW

(SQL View)
 Index Back

Package View - CostCenter CF

This non-rules package view will be used to move the GP_CC_SET record from one database to another using the Non Rules Packager.

SELECT PAY_ENTITY ,BUSINESS_UNIT ,EFFDT ,SEQNUM ,GP_CHFLD_IND ,PIN_NUM + 50000000 ,PIN_NM ,RECNAME FROM PS_GP_CC_SET

  • Parent record: GP_GL_CHART

    • # 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 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

    Prompt Table: GP_CF_SEQ_VW

    5 GP_CHFLD_IND Character(2) VARCHAR2(2) NOT NULL GP Chartfield Indicator
    1=Chartfield 1
    2=Chartfield 2
    3=Chartfield 3
    4=Chartfield 4
    5=Chartfield 5
    6=Chartfield 6
    7=Chartfield 7
    8=Chartfield 8

    Prompt Table: GP_CF_VW

    6 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    7 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
    8 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFN