EOATT_CFG_D_TBL(SQL Table) |
Index Back |
---|---|
Data Set DetailsComments 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. |