Groups
FTP_CONNECTION
| Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | N | Primary key | |
| 2 | NAME | VARCHAR2 | 100 | Y | ||
| 3 | FTP_KEY | VARCHAR2 | 25 | Y | ||
| 4 | SERVER | VARCHAR2 | 50 | Y | ||
| 5 | PORT | NUMBER | 22 | Y | ||
| 6 | USERNAME | VARCHAR2 | 25 | Y | ||
| 7 | PASSWORD | VARCHAR2 | 25 | Y | ||
| 8 | REMOTE_UPLOAD_DIR | VARCHAR2 | 200 | Y | ||
| 9 | REMOTE_DOWNLOAD_DIR | VARCHAR2 | 200 | Y | ||
| 10 | LOCAL_INCOMING_DIR | VARCHAR2 | 200 | Y | ||
| 11 | LOCAL_PROCESSED_DIR | VARCHAR2 | 200 | Y | ||
| 12 | LOCAL_ERROR_DIR | VARCHAR2 | 200 | Y | ||
| 13 | LOCAL_OUTGOING_DIR | VARCHAR2 | 200 | Y | ||
| 14 | LOCAL_UPLOADED_DIR | VARCHAR2 | 200 | Y | ||
| 15 | USE_SECURE | CHAR | 1 | Y | ||
| 16 | CODE | VARCHAR2 | 128 | Y | ||
| 17 | PRIVATE_KEY_FILE | VARCHAR2 | 50 | Y | ||
| 18 | PRIVATE_KEY_PHRASE | VARCHAR2 | 50 | Y | ||
| 19 | CONNECT_MODE | VARCHAR2 | 10 | Y |
See also FTPS Connection