BI_ENT_RSN_DBVW

(SQL View)
 Index Back

BI Entry Type Reason Cd Prompt


SELECT a.setid ,a.entry_type ,a.entry_reason ,b.descr ,b.descrshort FROM PS_ITEM_REASON_TBL a ,ps_entry_reasn_tbl b WHERE a.setid = b.setid AND a.entry_type = b.entry_type AND a.entry_reason = b.entry_reason AND %EffdtCheck(item_reason_tbl a1, a, %CurrentDateIn)

  • Related Language Record: BI_ENTRSNDV_LNG

  • Parent record: ENTRY_TYPE_TBL

    • # 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: SETID_TBL

    2 ENTRY_TYPE_DB Character(5) VARCHAR2(5) NOT NULL Debit Entry Type
    3 ENTRY_REASON Character(5) VARCHAR2(5) NOT NULL "Specifies an entry reason that further qualifies the entry type associated with a pending item. For example an entry reason for a credit memo might be ""Pricing Error"" or ""Shipping Error""."

    Prompt Table: ENTRY_REASN_TBL

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description