EOATT_CONFIG_IDEOATT_FLDNAMEA=Attachment
C=Comment
T=Transaction
Prompt Table: EOATT_FLBL_VW
L=Long
S=Short
T=Static Text
Default Value: L
Y/N Table Edit
Y/N Table Edit
Y/N Table Edit
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. |