EX_APPRVR(SQL Table) |
Index Back |
---|---|
ApproversApprovers. This record stores approver assignments. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table: SP_BU_GL_NONVW |
2 | APPROVER_PROFILE | Character(15) | VARCHAR2(15) NOT NULL |
Approver profile name
Prompt Table:
EX_PROF_APPR_VW
|
3 | APPROVER_OPRID | Character(30) | VARCHAR2(30) NOT NULL |
Approver Oprid
Prompt Table: EX_OPRID_VW |
4 | CHARTFIELD_FROM | Character(30) | VARCHAR2(30) NOT NULL |
Starting chartfield
Prompt Table: %EDITTABLECF |
5 | CHARTFIELD_TO | Character(30) | VARCHAR2(30) NOT NULL |
Ending chartfield
Prompt Table: %EDITTABLECF |