EO_CCR_CNV_F_VW

(SQL View)
 Index Back

Rule Conversion Fld View


SELECT PROC_GRP_ID , PROD_ID , RULE_INSTNC_NBR , FLD_INSTNC_NBR , FIELD_CATEGORY , AMT_FLDNAME , CURR_FLDNAME , RT_MULT_FLDNAME , RT_DIV_FLDNAME , CURR_DIRECTION , ADDTL_KEY_FLDNAME , RECON_RECNAME , RECON_FLDNAME , RECON_METHOD , ADJUST_METHOD , FIELD_SQLID FROM PS_EO_CCR_CNV_FLDS

  • Parent record: EO_CURRCNV_RULE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROC_GRP_ID Character(10) VARCHAR2(10) NOT NULL Uniquely identifies a Currency Conversion Process Group
    2 PROD_ID Character(2) VARCHAR2(2) NOT NULL This is an XLAT field listing all PeopleSoft 7.5 Product codes.
    3 RULE_INSTNC_NBR Number(3,0) SMALLINT NOT NULL Rule Occurrence Number
    4 FLD_INSTNC_NBR Number(3,0) SMALLINT NOT NULL Conversion Field Instance Nbr
    5 FIELD_CATEGORY Character(1) VARCHAR2(1) NOT NULL Field Category
    A=Amount
    C=Currency
    R=Rate Mult/Div
    6 AMT_FLDNAME Character(18) VARCHAR2(18) NOT NULL Amount Field Name
    7 CURR_FLDNAME Character(18) VARCHAR2(18) NOT NULL Currency Field Name
    8 RT_MULT_FLDNAME Character(18) VARCHAR2(18) NOT NULL Rate Multiplier Field Name
    9 RT_DIV_FLDNAME Character(18) VARCHAR2(18) NOT NULL Rate Divisor Field Name
    10 CURR_DIRECTION Character(1) VARCHAR2(1) NOT NULL Currency Direction
    F=FROM Currency Being Converted
    T=TO Currency Being Converted
    11 ADDTL_KEY_FLDNAME Character(18) VARCHAR2(18) NOT NULL Additional Key Field
    12 RECON_RECNAME Character(15) VARCHAR2(15) NOT NULL Reconciliation Record Name
    13 RECON_FLDNAME Character(18) VARCHAR2(18) NOT NULL Reconciliation Field Name
    14 RECON_METHOD Character(2) VARCHAR2(2) NOT NULL Reconciliation Method
    1=Convert and Adjust
    5=Adjust Only
    6=Sum-Based Value
    7=Sum-Based, Reverse Sign
    8=No Reconciliation
    15 ADJUST_METHOD Character(2) VARCHAR2(2) NOT NULL Adjustment Method
    1=First in Series
    2=Last in Series
    3=Smallest Amount
    4=Largest Amount
    5=Smallest Absolute Value
    6=Largest Absolute Value
    16 FIELD_SQLID Character(23) VARCHAR2(23) NOT NULL Field SQLID