GL_PE_07_PRS(SQL Table) |
Index Back |
|---|---|
Actual vs. Budget PrsnaliztionActual vs. Budget Personalization |
| # | 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 | INQUIRY | Character(10) | VARCHAR2(10) NOT NULL | Inquiry Name |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_GL_NONVW |
| 4 | COMMITMENT_CNTL | Character(1) | VARCHAR2(1) NOT NULL |
Enable Commitment Control
Y/N Table Edit Default Value: Y |
| 5 | LEDGER_TYPE_KK_L2 | Character(1) | VARCHAR2(1) NOT NULL |
Include Encumbrance
Y/N Table Edit Default Value: N |
| 6 | LEDGER_TYPE_KK_L3 | Character(1) | VARCHAR2(1) NOT NULL |
Include Pre-Encumbrance
Y/N Table Edit Default Value: N |
| 7 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL |
Ledger Group
Prompt Table: SP_BULGPK_NONVW |
| 8 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL |
Ledger
Prompt Table: SP_BUBUDL_NONVW |
| 9 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 10 | LEDGER_2 | Character(10) | VARCHAR2(10) NOT NULL |
Ledger
Prompt Table: SP_BUACTL_NONVW |
| 11 | RECNAME_2 | Character(15) | VARCHAR2(15) NOT NULL | Record 2 Name |
| 12 | NBR_DAYS_EXPIRED | Number(4,0) | SMALLINT NOT NULL | Projects Expire in (days) |
| 13 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CUR_CD_ALL_VW |
| 14 | STATISTICS_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Statistics Code
Prompt Table: STAT_ALL_VW |
| 15 | AMT_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Amount Field Name
Prompt Table: INQ_AMT_FLD_VW |
| 16 | SORT_PROJECT_BY | Character(1) | VARCHAR2(1) NOT NULL |
Show Projects
A=with Most Unbilled Amounts D=Expiring the Earliest Default Value: A |