# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
RO_VALUE_NAME |
Character(64) |
VARCHAR2(64) NOT NULL |
This field contains the Order Capture Agreement Codes
|
2 |
RO_VALUE_NAMEIP |
Character(64) |
VARCHAR2(64) NOT NULL |
This field contains the Installed Product description for an Agreement.
|
3 |
RO_VALUE_DESC |
Character(64) |
VARCHAR2(64) NOT NULL |
Description lookup for Display of External Solution
|
4 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
|
5 |
SITE_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
|
6 |
INSTALLED_DATE |
Date(10) |
DATE |
Field used for storing Installed Date of Installed product
|