BUSINESS_UNIT_TOTO_CSTTYPETO_COST_VERSIONE=Engineering
P=Production
S=Simulation
CE_VERSION3_VW(SQL View) |
Index Back |
|---|---|
Cost Version ViewThis cost version view looks for to_cost_version field on panel versus cost_version. |
| select business_unit, ce_cost_type, cost_version, eg_version, descr from PS_CE_VERSION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_TO |
Character(5) | VARCHAR2(5) NOT NULL | 04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT |
| 2 | TO_CSTTYPE |
Character(4) | VARCHAR2(4) NOT NULL | To Cost Type |
| 3 | TO_COST_VERSION |
Character(10) | VARCHAR2(10) NOT NULL | To 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 |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |