GPCH_AL_MSG_VW(SQL View) |
Index Back |
|---|---|
Tax Statment Messages NR ViewTax Statment Messages NR View |
| SELECT GPCH_RC_REPORTNAME ,GPCH_AL_MSG_NBR ,PIN_NUM+50000000 ,ENTRY_TYPE_ELEM ,ACM_PRD_OPTN ,GPCH_TX_CANTON ,GPCH_AL_MSG_CHK ,OVRD_IND_PYE ,GPCH_AL_CCAT_AMT ,GPCH_AL_MSG_TXT ,LAST_UPDATE_DTTM ,DESCRLONG FROM PS_GPCH_AL_MSG_CAT |
| # | 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 | GPCH_AL_MSG_CHK | Character(1) | VARCHAR2(1) NOT NULL |
Always Generate
Y/N Table Edit |
| 8 | OVRD_IND_PYE | Character(1) | VARCHAR2(1) NOT NULL | Payee Level Override Indicator |
| 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 |