OPRIDGRID_FLAGC=Change Grid
S=Search Grid
ROW_NUMRECNAMEPrompt Table: BI_REC_IM_VW
FIELDNAMEPrompt Table: BI_LINE_IM_VW
Prompt Table: %EDITTABLE
BI_IM_CHG_VW(SQL View) |
Index Back |
|---|---|
Invoice Maintenance Chng ViewView to maintain the Change parameters grid on the Invoice Maintenance component. |
| SELECT A.OPRID , A.GRID_FLAG , A.ROW_NUM , A.RECNAME , A.FIELDNAME , A.FIELD_VALUE100 FROM PS_BI_IM_SAVE_SRCH A WHERE A.GRID_FLAG = 'C' |
| # | 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 | GRID_FLAG |
Character(1) | VARCHAR2(1) NOT NULL |
Grid type indicator to distinguish Search parameters from Change parameters.
C=Change Grid S=Search Grid |
| 3 | ROW_NUM |
Number(3,0) | SMALLINT NOT NULL | Row Number |
| 4 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: BI_REC_IM_VW |
| 5 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: BI_LINE_IM_VW |
| 6 | FIELD_VALUE100 | Character(100) | VARCHAR2(100) NOT NULL |
The value of a field. This could be used for Selecting a specific field value, or identifying the new value of the field.
Prompt Table: %EDITTABLE |