DST_CODE_DFR_VW

(SQL View)
Index Back

Deferrd Rev Distribution Codes


SELECT setid ,A.dst_id ,A.descr FROM PS_DST_CODE_TBL A WHERE dst_use IN ('DRV','DDI','DSU') AND A.EFF_STATUS = 'A' AND %EffdtCheck(DST_CODE_TBL X, A, %CurrentDateIn)

  • Related Language Record: DST_CDDFRVW_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 DST_ID_DFR Character(10) VARCHAR2(10) NOT NULL Deferred Distribution Code

    Prompt Table: %EDITTABLE5

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description