[Home] [Help]
View: OKI_YOY_RENEWAL_AMT_V
Product: | OKI - Contracts Intelligence (Obsolete) |
Description: | Holds information about the value of renewed contracts on a historical basis. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT YOY.ID
, YOY.PERIOD_NAME
, YOY.PERIOD_SET_NAME
, YOY.PERIOD_TYPE
, YOY.AUTHORING_ORG_ID
, YOY.AUTHORING_ORG_NAME
, YOY.YEAR
, YOY.MONTH
, YOY.SCS_CODE
, YOY.BASE_CONTRACT_AMOUNT
, YOY.REQUEST_ID
, YOY.PROGRAM_APPLICATION_ID
, YOY.PROGRAM_ID
, YOY.PROGRAM_UPDATE_DATE
FROM OKI_YOY_RENEWAL_AMT YOY
Columns
Name |
ID |
PERIOD_NAME |
PERIOD_SET_NAME |
PERIOD_TYPE |
AUTHORING_ORG_ID |
AUTHORING_ORG_NAME |
YEAR |
MONTH |
SCS_CODE |
BASE_CONTRACT_AMOUNT |
REQUEST_ID |
PROGRAM_APPLICATION_ID |
PROGRAM_ID |
PROGRAM_UPDATE_DATE |