EOATT_CONFIG_IDEOATT_SERVER_TYPED=Database server
F=FTP server
U=URL Server
Default Value: U
Y/N Table Edit
Default Value: Y
EOATT_CFG_A_VW(SQL View) |
Index Back |
|---|
| SELECT EOATT_CONFIG_ID , EOATT_SERVER_TYPE , EOATT_DFLT_SERVER , EOATT_FTPSRV_LOGIN , EOATT_FTPSRV_PWD , EOATT_ATT_SRV_NAME , EOATT_SERVER_PATH , EOATT_URL_ID FROM PS_EOATT_CFG_A_DTL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOATT_CONFIG_ID |
Character(20) | VARCHAR2(20) NOT NULL | Configuration ID |
| 2 | EOATT_SERVER_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
One of type ftp or DB, marks each registered attachment server.
D=Database server F=FTP server U=URL Server Default Value: U |
| 3 | EOATT_DFLT_SERVER | Character(1) | VARCHAR2(1) NOT NULL |
Default Server
Y/N Table Edit Default Value: Y |
| 4 | EOATT_FTPSRV_LOGIN | Character(24) | VARCHAR2(24) NOT NULL | Login name for attachment ftp servers |
| 5 | EOATT_FTPSRV_PWD | Character(100) | VARCHAR2(100) NOT NULL | Password for attachment ftp servers |
| 6 | EOATT_ATT_SRV_NAME | Character(254) | VARCHAR2(254) NOT NULL | Name of attachment server, if it is an ftp server; name of the database record which holds attached files, if attachments are to be stored in the database |
| 7 | EOATT_SERVER_PATH | Character(254) | VARCHAR2(254) NOT NULL | For attached files already uploaded to an ftp server, the path under the ftp root directory in which the file is to be found. |
| 8 | EOATT_URL_ID | Character(30) | VARCHAR2(30) NOT NULL | URL Identifier |