SUB_RULE_DEAL

(SQL View)
 Index Back

Sub Rule Defn for Deals Prompt

Substitution Rule Definition for Deals Prompt Table

SELECT SETID , SUB_RULE_ID , DESCR60 FROM PS_SUB_RULE_DEFN WHERE SOURCE_TYPE = 'D' AND STATUS = 'A'

  • Related Language Record: SUB_RULE_LANG

    • # 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 SUB_RULE_ID Character(20) VARCHAR2(20) NOT NULL The unique key identifier for a given accounting template substitution rule.
    3 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description