INST_PROD_IDN=NO
Y=YES
Default Value: N
RC_CASE_IP_DISP(SQL Table) |
Index Back |
|---|---|
Installed Asset DisplayUsed to display the results of the Installed Asset search for an employee on an IT HelpDesk case. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INST_PROD_ID |
Character(20) | VARCHAR2(20) NOT NULL | This field is used to represent the installed product ID (key field) |
| 2 | SELECTED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Selected Flag
N=NO Y=YES Default Value: N |
| 3 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 4 | BO_ID_CONTACT | Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |
| 5 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 6 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | This field is used to represent the Serial ID of an item or installed product |
| 7 | DEPTID | Character(15) | VARCHAR2(15) NOT NULL | Department |
| 8 | LOCATION | Character(15) | VARCHAR2(15) NOT NULL | This field stores the Location Code. |
| 9 | ASSETTAG | Character(40) | VARCHAR2(40) NOT NULL | Asset Tag |