GPCH_AL_MSG_CAT

(SQL Table)
Index Back

GPCH LAW Messages

GPCH LAW Messages

  • Related Language Record: GPCH_AL_MCT_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPCH_RC_REPORTNAME Character(8) VARCHAR2(8) NOT NULL Print Class

    Prompt Table: GPCH_BL_PR_RPT

    2 GPCH_AL_MSG_NBR Number(5,0) INTEGER NOT NULL Swiss Message Number

    Default Value: 1

    3 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

    Prompt Table: %RECNAME_EDIT

    4 ENTRY_TYPE_ELEM Character(3) VARCHAR2(3) NOT NULL entry type element

    Prompt Table: GPCH_ENT_BL_VW

    5 ACM_PRD_OPTN Character(1) VARCHAR2(1) NOT NULL Accumulator Period
    1=Segment
    2=Calendar Period
    3=Month to Date
    4=Quarter to Date
    5=Year to Date
    6=Custom Period

    Default Value: GP_ACCUMULATOR.ACM_PRD_OPTN

    6 GPCH_TX_CANTON Character(2) VARCHAR2(2) NOT NULL Canton

    Prompt Table: GPCH_TX_CANT_VW

    7 OVRD_IND_PYE Character(1) VARCHAR2(1) NOT NULL Payee Level Override Indicator

    Y/N Table Edit

    8 GPCH_AL_MSG_CHK Character(1) VARCHAR2(1) NOT NULL Always Generate

    Y/N Table Edit

    9 GPCH_AL_CCAT_AMT Character(1) VARCHAR2(1) NOT NULL Concatenate Amount

    Y/N Table Edit

    10 GPCH_AL_MSG_TXT Character(100) VARCHAR2(100) NOT NULL Message Text This field refers to the Text for a particular Message Number in the Swiss Message Catalog
    11 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP NOT NULL Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

    Default Value: %date

    12 DESCRLONG Long Character CLOB Long Description