CE_VERSION2_VW(SQL View) |
Index Back |
---|---|
Engineering Cost Versions09/02/97 wtk cn#RTNT128-M399W : Created 2/11/98 CEL cn#en800-6.0 modified the where clause to be eg_version = 'E' instead of = 'Y' since new values are E, P or S. |
SELECT business_unit , ce_cost_type , cost_version , eg_version FROM PS_CE_VERSION WHERE eg_version = 'E' |
# | 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 |