| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 3 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
|
| 4 |
REQ_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Requisition ID
|
| 5 |
REQ_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Requisition Line Number
|
| 6 |
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.
|
| 7 |
ATT_VERSION |
Number(3,0) |
SMALLINT NOT NULL |
The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files.
|
| 8 |
PV_ATTACH_NUM |
Number(5,0) |
INTEGER NOT NULL |
Attachment Number
|
| 9 |
EMAILID |
Character(70) |
VARCHAR2(70) NOT NULL |
A user's E-mail address
|
| 10 |
ATTACHSYSFILENAME |
Character(128) |
VARCHAR2(128) NOT NULL |
Unique Sys Filename
|
| 11 |
ATTACHUSERFILE |
Character(64) |
VARCHAR2(64) NOT NULL |
Attached File
|