RBT_ACTION

(SQL Table)
 Index Back

Actions Table

This table is used to store the actions that can be taken on products.

  • Related Language Record: RBT_ACTION_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Prompt Table: SP_SETID_NONVW

    2 RBTACTION_ID Character(15) VARCHAR2(15) NOT NULL Holds Action ID.
    3 RBTACTION_CODE Character(5) VARCHAR2(5) NOT NULL Action Code used for Service Management transactions.
    4 RBTACTION_NAME Character(30) VARCHAR2(30) NOT NULL Action Name
    5 RBTACTION_TYPE Character(1) VARCHAR2(1) NOT NULL Action Type
    B=Business Project
    E=Energy
    I=Insurance
    P=Pre-Order Qualification
    S=Service Management
    6 RBTACTION_REF Character(30) VARCHAR2(30) NOT NULL Action Reference
    7 ACTION_APPL_TYPE Character(1) VARCHAR2(1) NOT NULL Action Application Type
    A=Application Form
    B=Branch Script
    C=Configurator
    8 SCRIPT_ID Number(12,0) DECIMAL(12) NOT NULL Script ID

    Prompt Table: RC_BSCRIPT_VW

    9 FORM_ID Character(15) VARCHAR2(15) NOT NULL The unique identifier of App form

    Prompt Table: RBF_APPFORM_HDR

    10 CFG_SCHEMA_ID Character(18) VARCHAR2(18) NOT NULL Schema ID displayed on several pages of Configurator

    Prompt Table: CFG_SCHEMA_TBL

    11 REQUOTE Character(1) VARCHAR2(1) NOT NULL Re quote

    Y/N Table Edit

    Default Value: N

    12 BILLING_FLAG Character(1) VARCHAR2(1) NOT NULL Do Not Publish to Billing
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    13 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    14 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    15 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    16 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    17 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    18 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time