BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUIN_NONVW
CE_COST_TYPEPrompt Table: CE_TYPE
COST_VERSIONE=Engineering
P=Production
S=Simulation
Default Value: %date
A=Approved
D=Denied
P=Pending
Default Value: P
CE_VERSION(SQL Table) |
Index Back |
|---|---|
Cost Versions |
| # | 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_BUIN_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 |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 7 | DATE_ADDED | Date(10) | DATE |
Date Added
Default Value: %date |
| 8 | CE_APPROVAL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Approval Status
A=Approved D=Denied P=Pending Default Value: P |