EM_USR_FLDROLVW(SQL View) |
Index Back |
|---|---|
LLA user's values & rolesUsed in invoice line level routing |
| SELECT E.BUSINESS_UNIT , A.OPRID , A.FIELDNAME , A.HOW_FIELD_SPECIFY , A.SELECT_VALUE , A.RTE_TO_VALUE , A.AUTO_ASSIGN , A.USE_ROUTE_FLAG , R.ROLENAME FROM PS_EM_USR_FLD_VAL A , PS_SEC_BU_OPR D , PS_EM_BUY_FLD_AUTH E , PSROLEUSER R , PS_EM_ROLE_CONFIG B WHERE A.OPRID=R.ROLEUSER AND D.OPRID=A.OPRID AND D.BUSINESS_UNIT = E.BUSINESS_UNIT AND E.FIELDNAME=A.FIELDNAME AND R.ROLENAME = B.EM_ROLENAME AND E.ROLENAME=R.ROLENAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: EM_USRLN_FLD_VW |
| 4 | 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 Default Value: 2 |
| 5 | SELECT_VALUE |
Character(30) | VARCHAR2(30) NOT NULL |
Select Value
Prompt Table: %EDITTABLE |
| 6 | RTE_TO_VALUE | Character(30) | VARCHAR2(30) NOT NULL |
To Value
Prompt Table: %EDITTABLE |
| 7 | AUTO_ASSIGN | Character(1) | VARCHAR2(1) NOT NULL |
Automatic Assigned
Y/N Table Edit Default Value: N |
| 8 | USE_ROUTE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Determines whether route functionality will be used for a business unit.
Y/N Table Edit Default Value: Y |
| 9 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |