KK_LINEFIELD_VW(SQL View) |
Index Back |
---|---|
Line Fieldname Prompt VW |
SELECT RECNAME , FIELDNAME FROM PSRECFIELD WHERE FIELDNAME NOT IN ('KK_TRAN_ID', 'KK_TRAN_DT') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | KK_LINE_PROMPT_VW | Character(15) | VARCHAR2(15) NOT NULL | Source Line # Prompt View |
2 | KK_LINE_FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Source Line # Field Name |