EM_USR_FLD_VAL(SQL Table) |
Index Back |
|---|---|
eS user's field valuesUsed in invoice line level routing |
| # | 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 | 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 Default Value: 2 |
| 4 | SELECT_VALUE |
Character(30) | VARCHAR2(30) NOT NULL |
Select Value
Prompt Table: %EDITTABLE |
| 5 | RTE_TO_VALUE | Character(30) | VARCHAR2(30) NOT NULL |
To Value
Prompt Table: %EDITTABLE |
| 6 | AUTO_ASSIGN | Character(1) | VARCHAR2(1) NOT NULL |
Automatic Assigned
Y/N Table Edit Default Value: N |
| 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 Default Value: Y |