OPRIDCOUNTRYPrompt Table: GP_USER_CNTR_VW
PI_MNL_TEMPLATE_IDGP_PI_BKTMPL_VW(SQL View) |
Index Back |
|---|---|
PI template search viewView used to search Bulk PI template |
| SELECT B.OPRID ,A.COUNTRY ,A.PI_MNL_TEMPLATE_ID ,A.DESCR ,A.CURRENCY_CD FROM PS_GP_PI_MNL_TMPLT A , PS_GP_OPR_RULE_PRF B WHERE B.COUNTRY = A.COUNTRY OR A.COUNTRY='ALL' OR B.USED_BY='A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: GP_USER_CNTR_VW |
| 3 | PI_MNL_TEMPLATE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Template ID for GP bulk Positive Input |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |