| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SO_REQUIRED |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to specify whether or not a service order is required.
Y/N Table Edit
Default Value: N
|
| 2 |
INST_PRD_ASN_IFLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether or not an installed product can be created from a shipping notification (ASN).
Y/N Table Edit
Default Value: N
|
| 3 |
INST_PRD_ASN_ISTAT |
Character(3) |
VARCHAR2(3) NOT NULL |
Default installed product status when creating a new installed product from an ASN.
INS=Installed
PND=Pending
SHP=Shipped
|
| 4 |
INST_PRD_ASN_UFLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether or not an installed product can be updated from a shipping notification (ASN).
Y/N Table Edit
Default Value: N
|
| 5 |
INST_PRD_ASN_USTAT |
Character(3) |
VARCHAR2(3) NOT NULL |
Default installed product status when updating an existing installed product from an ASN (shipping notification).
INS=Installed
PND=Pending
SHP=Shipped
|
| 6 |
INST_PRD_MTL_IFLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether or not an installed product can be created from Material Management, which can only be created from a service order.
Y/N Table Edit
Default Value: N
|
| 7 |
INST_PRD_MTL_ISTAT |
Character(3) |
VARCHAR2(3) NOT NULL |
Default installed product status when creating a new installed product from Manage Material (Service Order).
INS=Installed
PND=Pending
SHP=Shipped
|
| 8 |
INST_PRD_MTL_UFLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether or not an installed product can updated from Material Management, which can only be created from a service order.
Y/N Table Edit
Default Value: N
|
| 9 |
INST_PRD_MTL_USTAT |
Character(3) |
VARCHAR2(3) NOT NULL |
Default installed product status when updating an existing installed product from Manage Material (Service Order).
INS=Installed
PND=Pending
SHP=Shipped
|
| 10 |
INST_PRD_ORD_IFLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether or not an installed product can be inserted from Order Capture.
Y/N Table Edit
Default Value: N
|
| 11 |
INST_PRD_ORD_ISTAT |
Character(3) |
VARCHAR2(3) NOT NULL |
Default installed product status when creating a new installed product from Order Capture.
INS=Installed
PND=Pending
SHP=Shipped
|
| 12 |
PROD_TEMP_SERV |
Character(1) |
VARCHAR2(1) NOT NULL |
Field to allow temporary installation of a service
Y/N Table Edit
Default Value: N
|
| 13 |
PROD_DIS_RES_OPT |
Character(4) |
VARCHAR2(4) NOT NULL |
Field to determine how to handle external systems with a temporary service
CHST=Change Service Status
EXTN=Wait for External Notification
ORDR=Create Order for Change
Default Value: ORDR
|