TRA_DEAL_CAL_VW

(SQL View)
 Index Back

Deal Amt Calc Type Prompt Tbl


SELECT %Substring(A.FIELDVALUE,1,4) , A.EFFDT , A.EFF_STATUS , A.XLATLONGNAME FROM PSXLATITEM A WHERE A.FIELDNAME = 'AMOUNT_CALC_TYPE' AND FIELDVALUE NOT IN ('19','70','71','72','73','74','75','76','77') AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PSXLATITEM B WHERE A.FIELDNAME = B.FIELDNAME AND A.FIELDVALUE = B.FIELDVALUE AND B.EFF_STATUS = 'A' AND B.EFFDT <= %CurrentDateIn)

  • Related Language Record: TRA_HDG_CAL_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AMOUNT_CALC_TYPE Character(4) VARCHAR2(4) NOT NULL Represents the formula by which an accounting entry monetary amount is calculated for a given accounting template
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name