# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
3 |
REQ_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Requisition ID
|
4 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
5 |
DUE_DT |
Date(10) |
DATE |
Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
|
6 |
REQUESTOR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Requestor id
|
7 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
8 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|