SETIDDefault Value: OPR_DEF_TBL_RB.SETID
Prompt Table: SP_SETID_NONVW
INST_PROD_TYPE001=Asset
002=Product
003=Service
004=Agreement
005=Commitment
Default Value: 002
INST_PROD_STATUSPrompt Table: RF_ISTATXLT3_VW
RF_PROD_RST_DFL(SQL Table) |
Index Back |
|---|---|
Prod Registration dflt statusStores the possible installed product statuses that will be displayed when registering the product. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SP_SETID_NONVW |
| 2 | INST_PROD_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
This field is used by the Installed Product component to determine the type of product that is being registered for the Customer, Site, Department or Employee. There are four allowable types: 1) Product, which designates a product assigned to an external customer; 2) Service 3) Asset, which designates a product assigned to an internal employee or department; and 4)Agreement, which designates an Installed Agreement Product (used in Order Capture integration with Agreements).
001=Asset 002=Product 003=Service 004=Agreement 005=Commitment Default Value: 002 |
| 3 | INST_PROD_STATUS |
Character(4) | VARCHAR2(4) NOT NULL |
Status of an installed product.
Prompt Table: RF_ISTATXLT3_VW |