RBF_ACNT

(SQL Table)
 Index Back

FSI Product/ArrangemenContract

This record used to define Contracts based on based on FSI product/arrangement

  • Related Language Record: RBF_ACNT_LNG

  • Parent Record Of RBF_ACNT_ATTR RBF_ACNT_ATTR_L

    • # 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.

    Default Value: OPR_DEF_TBL_RB.SETID

    Prompt Table: SP_SETID_NONVW

    2 ACNT_ID Character(18) VARCHAR2(18) NOT NULL Contract ID

    Default Value: NEXT

    3 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    4 START_DATE Date(10) DATE NOT NULL Start Date

    Default Value: %Date

    5 END_DATE Date(10) DATE NOT NULL End date field to store an end date.
    6 BUS_CONTACT_TYPE Character(3) VARCHAR2(3) NOT NULL Business Contact Type for Arrangement for FSI
    ALT=Alternate Capacity
    COM=Company
    PTN=Partnership

    Default Value: COM

    7 BUS_CONTACT_ID Number(31,0) DECIMAL(31) NOT NULL Business Contact Id
    8 PRODUCT_ID_RELATED Character(18) VARCHAR2(18) NOT NULL Field used to store related product ID

    Prompt Table: RBF_PRD_DF_SRCH

    9 ARRANGEMENT_FLAG Character(1) VARCHAR2(1) NOT NULL This field is to indicate whether an arrnagement is avilable on the product.
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    10 PRODUCT_ID_ORIG Character(18) VARCHAR2(18) NOT NULL Product ID Original
    11 RAISE_PCT Number(6,2) DECIMAL(5,2) NOT NULL This field is used to store the raise percentage for arrangement contracts.
    12 REDUCTION_PCT Number(6,2) DECIMAL(5,2) NOT NULL Thsi field is used to define the reduction percentage in arrangement contracts.
    13 CON_FEE_WAIVE_FLAG Character(1) VARCHAR2(1) NOT NULL This field indicates whether to wave contract fee.

    Y/N Table Edit

    Default Value: N

    14 ATTRIBUTE_CATEGORY Character(30) VARCHAR2(30) NOT NULL This field defines the acategory of attributes in product.

    Prompt Table: RBF_ACNT

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