| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
FILENAME |
Character(80) |
VARCHAR2(80) NOT NULL |
File Name
|
| 3 |
FILE_EXTENSION |
Character(4) |
VARCHAR2(4) NOT NULL |
File Extension
|
| 4 |
DOC_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
|
| 5 |
ATTACH_DESCR |
Character(100) |
VARCHAR2(100) NOT NULL |
A description of the file being attached. This field is provided as a convenience to app developers and customers. The attachment utility does not interpret its value in any way, simply storing it as set by the application.
|
| 6 |
ATTACHUSERFILE |
Character(64) |
VARCHAR2(64) NOT NULL |
Attached File
|
| 7 |
SCM_ATTACH_ID |
Character(64) |
VARCHAR2(64) NOT NULL |
The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications.
|
| 8 |
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.
|