EOATT_CFG_D1_VW

(SQL View)
Index Back

SELECT EOATT_CONFIG_ID ,EOATT_LEVELNO ,EOATT_FLDNAME ,EOATT_SEQNBR ,EOATT_FLDTYPE ,EOATT_FLDLBL ,EOATT_LBLTYPE ,EOATT_LABEL_TXT ,EOATT_KEY ,EOATT_DISPLAY ,EOATT_HEADER ,EOATT_MSGSET1 ,EOATT_MSGNUM1 FROM PS_EOATT_CFG_D_TBL WHERE EOATT_LEVELNO = 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOATT_CONFIG_ID Character(20) VARCHAR2(20) NOT NULL Configuration ID
2 EOATT_LEVELNO Number(3,0) SMALLINT NOT NULL Level
3 EOATT_FLDNAME Character(30) VARCHAR2(30) NOT NULL Field Name
4 EOATT_SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number
5 EOATT_FLDTYPE Character(1) VARCHAR2(1) NOT NULL Field Type
A=Attachment
C=Comment
T=Transaction
6 EOATT_FLDLBL Character(18) VARCHAR2(18) NOT NULL Field Label ID

Prompt Table: EOATT_FLBL_VW

7 EOATT_LBLTYPE Character(1) VARCHAR2(1) NOT NULL Label Type
L=Long
S=Short
T=Static Text

Default Value: L

8 EOATT_LABEL_TXT Character(30) VARCHAR2(30) NOT NULL Field Label
9 EOATT_KEY Character(1) VARCHAR2(1) NOT NULL Key Field

Y/N Table Edit

10 EOATT_DISPLAY Character(1) VARCHAR2(1) NOT NULL Display Field

Y/N Table Edit

11 EOATT_HEADER Character(1) VARCHAR2(1) NOT NULL Header Field

Y/N Table Edit

12 EOATT_MSGSET1 Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
13 EOATT_MSGNUM1 Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.