COUNTRYRTO_PRC_IDRTO_MTHDC=Corrective
F=Forwarding
EFFDTPrompt Table: GP_PIN_FM2_VW
GP_NRP_RTOOV_VW(SQL View) |
Index Back |
|---|---|
Retro Process Override - ViewThis record contains the Retro Process Override definition. It contains the formula to be used for the override - Packaging View |
| SELECT COUNTRY ,RTO_PRC_ID ,RTO_MTHD ,EFFDT ,PIN_FRML_NUM + 50000000 FROM PS_GP_RTO_OVR_DEFN |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 2 | RTO_PRC_ID |
Character(10) | VARCHAR2(10) NOT NULL | Retro Process Definition ID |
| 3 | RTO_MTHD |
Character(1) | VARCHAR2(1) NOT NULL |
Default Retroactive Method
C=Corrective F=Forwarding |
| 4 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 5 | PIN_FRML_NUM | Number(8,0) | INTEGER NOT NULL |
Element number field
Prompt Table: GP_PIN_FM2_VW |