BUSINESS_UNIT_GLLM_PROJECT_IDLM_PROJECT_VW(SQL View) |
Index Back |
|---|---|
Active Project ValuesContains the Active Project Chart Field Values |
| SELECT BUSINESS_UNIT_GL , LM_PROJECT_ID , LM_CF_PROJ_DESCR , LM_CF_PROJ_SDESCR FROM PS_LM_CF_PROJECT WHERE LM_ACTIVE = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_GL |
Character(5) | VARCHAR2(5) NOT NULL | General Ledger Business Unit |
| 2 | LM_PROJECT_ID |
Character(20) | VARCHAR2(20) NOT NULL | Project Chart Field |
| 3 | LM_CF_PROJ_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Project Chart Field Description |
| 4 | LM_CF_PROJ_SDESCR | Character(10) | VARCHAR2(10) NOT NULL | Project Chart Field Short Description |