GPCH_AL_MSG_CAT(SQL Table) |
Index Back |
---|---|
GPCH LAW MessagesGPCH LAW Messages |
# | 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 |