PROCESS_INSTANCEA=All Business Units
S=Single Business Unit
RF_IP_PM_2_AET(SQL Table) |
Index Back |
|---|---|
Second Pass AET for PMState record for preventive maintenace process. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | BU_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Used to determine whether a process should be run for all business units or a single business unit.
A=All Business Units S=Single Business Unit |
| 6 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 7 | INST_PROD_ID | Character(20) | VARCHAR2(20) NOT NULL | This field is used to represent the installed product ID (key field) |
| 8 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 9 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 10 | ROLE_TYPE_ID_CUST | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the customer |
| 11 | BO_ID_CONTACT | Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |
| 12 | ROLE_TYPE_ID_CNTCT | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the contact |
| 13 | 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. |
| 14 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | This field is used to represent the Serial ID of an item or installed product |
| 15 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 16 | SETID_AGREEMENT | Character(5) | VARCHAR2(5) NOT NULL | This field is used to represent the SETID of the Agreement |
| 17 | AGREEMENT_CODE | Character(30) | VARCHAR2(30) NOT NULL | This field represents the agreement code (name) for an agreement |
| 18 | AGR_RENEWAL_NUM | Number(4,0) | SMALLINT NOT NULL | This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal) |
| 19 | AGREEMENT_LINE | Character(10) | VARCHAR2(10) NOT NULL | This field records the value for the agreement line number |
| 20 | SETID_SERVICE | Character(5) | VARCHAR2(5) NOT NULL | This field is used to represent the SETID of the Service |
| 21 | SERVICE_ID | Character(20) | VARCHAR2(20) NOT NULL | Service ID |
| 22 | SO_ID | Character(10) | VARCHAR2(10) NOT NULL | Service Order ID |
| 23 | PM_DATE | Date(10) | DATE | Date for the customer's next Preventive Maintenance. |
| 24 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 25 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |