EOATT_CFG_D_TBL

(SQL Table)
Index Back

Data Set Details

Comments and Attachments View only Framework Data set Record

# 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
7 EOATT_LBLTYPE Character(1) VARCHAR2(1) NOT NULL Label Type
L=Long
S=Short
T=Static Text
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

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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.