ANL_DB_QRY_ESS

index back

PeopleSoft Field Name Field Type Column Type Description
ANALYSIS_DB_ID Character(15) VARCHAR2(15) NOT NULL Cube Instance ID
QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name

Prompt Table: QUERY_DIM_VW

RATE_CUBE_TIME Character(30) VARCHAR2(30) NOT NULL Rate Cube Time Dimension Field

Prompt Table: QRY_FLD_HDNG_VW

RATE_CUBE_CURR_NAM Character(30) VARCHAR2(30) NOT NULL Rate Country Name Dim Field

Prompt Table: QRY_FLD_HDNG_VW

RATE_CUBE_CURR_CAT Character(30) VARCHAR2(30) NOT NULL Rate Account Dim Field

Prompt Table: QRY_FLD_HDNG_VW

RATE_CUBE_CURR_TYP Character(30) VARCHAR2(30) NOT NULL Rate Currency Type

Prompt Table: QRY_FLD_HDNG_VW

RATE_CUBE_CURR_AMT Character(30) VARCHAR2(30) NOT NULL Rate Cube Curr Amount Field

Prompt Table: QRY_FLD_HDNG_VW

RATE_CURR_DEF_NAME Character(30) VARCHAR2(30) NOT NULL Default Currency Name

Default: US$

RATE_CURR_DEF_CAT Character(30) VARCHAR2(30) NOT NULL Default Currency Category
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19