IN_TX_TP_BRA_VW

(SQL View)
 Index Back

Income Tax Type Abroad BRA vw

Income Tax Type Abroad BRA view.

SELECT A.INC_TAX_TP_CD_BRA, A.DESCR100, A.EFF_STATUS FROM PS_INC_TAX_TP_BRA A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_INC_TAX_TP_BRA A1 WHERE A1.INC_TAX_TP_CD_BRA = A.INC_TAX_TP_CD_BRA AND A1.EFFDT <= %CurrentDateIn)

  • Related Language Record: INTXTP_BRA_VLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INC_TAX_TP_CD_BRA Character(2) VARCHAR2(2) NOT NULL Income Tax Type Abroad Code.
    2 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    3 EFF_STATUS_BRA Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive