HPIP_ADMIN_GL(SQL Table) |
Index Back |
|---|---|
GL Business Unit PIP ConfigGL Business Unit configuration for PIP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT_GL |
Character(5) | VARCHAR2(5) NOT NULL |
General Ledger Unit
Prompt Table: HPIP_GL_BU2_VW |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | APPL_JRNL_ID | Character(10) | VARCHAR2(10) NOT NULL |
Journal Template
Prompt Table: JRNLGEN_APPL_ID |
| 4 | SETID_GL_ACCT | Character(5) | VARCHAR2(5) NOT NULL |
GL Setid for Accounts
Prompt Table: SETID_TBL |
| 5 | HPIP_CLR_AC | Character(10) | VARCHAR2(10) NOT NULL |
Clearing Account
Prompt Table: HPIP_AC_VW |
| 6 | HPIP_SUSP_AC | Character(10) | VARCHAR2(10) NOT NULL |
Suspense Account
Prompt Table: %EDITTABLE |
| 7 | MSGNODENAME | Character(30) | VARCHAR2(30) NOT NULL |
Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
Prompt Table: HPIP_TGT_SYS_GL |
| 8 | HPYP_CNTRL_AREA | Character(5) | VARCHAR2(5) NOT NULL |
Controlling Area
Prompt Table: HPYP_CNTRL_AREA |
| 9 | HPYP_CC_ID | Character(12) | VARCHAR2(12) NOT NULL |
Cost Center ID.
Prompt Table: HPYP_CC_TBL |