COST_TYPEEFFDTDefault Value: %date
PC_COST_TYPE_VW(SQL View) |
Index Back |
|---|---|
Asset Cost Type Definition |
| SELECT DISTINCT COST_TYPE , EFFDT , DESCR FROM PS_COST_TYPE_TBL A WHERE %EffdtCheck(COST_TYPE_TBL B, A, %CurrentDateIn) AND A.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COST_TYPE |
Character(1) | VARCHAR2(1) NOT NULL | Cost Type |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |