BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUMGOP_NONVW
CE_COST_TYPEPrompt Table: CE_TYPE
COST_VERSIONE=Engineering
P=Production
S=Simulation
Y/N Table Edit
Default Value: N
CE_VERSION4_VW(SQL View) |
Index Back |
|---|---|
Non-eng Cost Versions09/02/97 wtk cn#RTNT128-M399W : Created 2/1999 CEL cn#en800-6.0 Modified where clause for eg_version = 'P' since values change from Y/N to E/P/S. |
| SELECT business_unit , ce_cost_type , cost_version , eg_version FROM PS_CE_VERSION WHERE (EG_VERSION = 'P' OR EG_VERSION = 'S') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUMGOP_NONVW |
| 2 | CE_COST_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Cost Type
Prompt Table: CE_TYPE |
| 3 | COST_VERSION |
Character(10) | VARCHAR2(10) NOT NULL | Cost Version |
| 4 | EG_VERSION | Character(1) | VARCHAR2(1) NOT NULL |
10/8/98 WTK (CN#EN800-6.0) - Changed description to Version Type from Engineering Version. Added translate values, Engineering, Production, and Simulation.
E=Engineering P=Production S=Simulation Y/N Table Edit Default Value: N |