BI_DST_IUALL_VW

(SQL View)
Index Back

IU- All Distrib Codes View

This view is used in Bill Entry and Interunit Control Panels. In Bill Entry Panels, record level set control field is used. In Interunit Control panels, field level set control field is used on BI_LINE_IU_EXP and BI_LINE_IU_PAY.

SELECT A.SETID ,A.DST_ID ,A.EFFDT ,A.EFF_STATUS ,A.DESCR ,A.DESCRSHORT FROM PS_DST_CODE_TBL A

  • Related Language Record: BI_DST_IA_LG_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 DST_ID Character(10) VARCHAR2(10) NOT NULL Distribution Code
    3 EFFDT Date(10) DATE Effective Date
    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description