RF_INDUSTRY_CFG

(SQL Table)
 Index Back

Industry Options

Stores Service Order Configuration data.

  • Related Language Record: RF_INDUSTRY_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INDUSTRY_TEMPL Character(4) VARCHAR2(4) NOT NULL This field stores the Template values.
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 AGREEMENT_FLAG Character(1) VARCHAR2(1) NOT NULL Indicates whether or not the service can be used on an agreement.
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: Y

    4 ALLOW_ANUSER_FLAG Character(1) VARCHAR2(1) NOT NULL Allow Anonymous User
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: Y

    5 BILLING_FLAG Character(1) VARCHAR2(1) NOT NULL Show Billing Information
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: Y

    6 RF_VT_OPT_INCDADDR Character(1) VARCHAR2(1) NOT NULL Used to display the Address Display Options on the service order configuration.

    Y/N Table Edit

    Default Value: Y

    7 RF_VT_OPT_INSTPRDS Character(1) VARCHAR2(1) NOT NULL Used to display the Product Display Options on the service order configuration.
    A=Show Product & Serial #
    I=Show Installed Prod & Serial #
    N=Hide All Product Information
    P=Show Product Only

    Default Value: A

    8 RC_VT_OPT_PINSIN Character(1) VARCHAR2(1) NOT NULL Show SIN

    Y/N Table Edit

    Default Value: Y

    9 ALLOW_EXPENSE Character(1) VARCHAR2(1) NOT NULL This flag is used to control the display of expense information on service orders.

    Y/N Table Edit

    Default Value: Y

    10 ALLOW_PRIORITY Character(1) VARCHAR2(1) NOT NULL This flag controls the display of priority on the service order line. If it is 'No', then the service order line priority is not displayed.

    Y/N Table Edit

    Default Value: Y

    11 APPROVAL_SW Character(1) VARCHAR2(1) NOT NULL Auto Approval Status

    Y/N Table Edit

    Default Value: N

    12 APPROVAL_LINE Character(1) VARCHAR2(1) NOT NULL This flag indicates if approvals are to be enforced on the service order line.

    Y/N Table Edit

    Default Value: N

    13 BILLING_MY_SO Character(1) VARCHAR2(1) NOT NULL Used to control the display of the billable flag on My Service Order.

    Y/N Table Edit

    Default Value: Y

    14 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    15 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    16 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    17 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    18 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.
    19 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time