EM_USR_FLDS_VW(SQL View) |
Index Back |
|---|---|
User's line level flds summaryUsed for displaying summary of invoice line routing/authorization |
| SELECT OPRID , FIELDNAME , HOW_FIELD_SPECIFY , SELECT_VALUE , RTE_TO_VALUE , AUTO_ASSIGN , USE_ROUTE_FLAG FROM PS_EM_USR_FLD_VAL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPR_DEF_TBL_FS |
| 2 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: EM_USRLN_FLD_VW |
| 3 | HOW_FIELD_SPECIFY |
Character(1) | VARCHAR2(1) NOT NULL |
How Specified
1=All Detail Values 2=Selected Detail Values 3=Detail - Selected Parents 4=Selected Tree Nodes 5=Children at a Level 6=All Nodes at Selected Levels 7=Selected Summary ChrtFld Nodes 9=Value Mask A=Account Type R=Range of Values |
| 4 | SELECT_VALUE |
Character(30) | VARCHAR2(30) NOT NULL | Select Value |
| 5 | RTE_TO_VALUE | Character(30) | VARCHAR2(30) NOT NULL | To Value |
| 6 | AUTO_ASSIGN | Character(1) | VARCHAR2(1) NOT NULL | Automatic Assigned |
| 7 | USE_ROUTE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Determines whether route functionality will be used for a business unit.
Y/N Table Edit |