REPL_RULE_FIELD

(SQL Table)
 Index Back

Replacement Rule Field

This table specifies how to replace a set of field values with another set of field values for cash forecasting. For example to replace one bank with another bank, specify bank setid, bank and bank account in the set of REPL_RULE_FIELD rows associted with a replacement group.

  • Parent record: REPL_RULE_GROUP

    • # 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 CSH_FCST_RULE_ID Character(20) VARCHAR2(20) NOT NULL Uniquely identifies a Cash Forecasting Rule. The identifier is manually entered by the user and not automatically generated by the system.
    3 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    4 ALIAS_NAME Character(30) VARCHAR2(30) NOT NULL "A user defined synonym

    Prompt Table: CSH_FCST_GRP_VW

    5 INPUT_VALUE Character(40) VARCHAR2(40) NOT NULL Input Value

    Prompt Table: %EDITTABLE

    6 OUTPUT_VALUE Character(40) VARCHAR2(40) NOT NULL Output Value

    Prompt Table: %EDITTABLE