RBF_SALES_ENTRY

(SQL Table)
 Index Back

Sales Entry / Quote

This is record used to store FSI Sales process data

  • Related Language Record: RBF_SALES_EN_LN

  • Parent Record Of RBI_QUOTE_LINE RO_INS_QUOTE_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SALES_ENTRY_ID Character(15) VARCHAR2(15) NOT NULL sales entry id

    Default Value: NEXT

    2 SALES_ENTRY_TYPE Character(4) VARCHAR2(4) NOT NULL Sales Entry Type
    ORDR=Order
    QUOT=Quote
    3 SALES_ENTRY_STATUS Character(3) VARCHAR2(3) NOT NULL sales entry status
    C=Closed
    O=Open
    4 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
    5 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
    6 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
    7 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
    8 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

    9 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

    Prompt Table: PROD_ITEM

    10 RC_BS_INSTANCE Number(15,0) DECIMAL(15) NOT NULL RC_BS_INSTANCE
    11 FORM_INSTANCE_ID Number(15,0) DECIMAL(15) NOT NULL App Form Instance
    12 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
    13 ACNT_ID Character(18) VARCHAR2(18) NOT NULL Contract ID
    14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.
    15 IS_QUOTE Character(1) VARCHAR2(1) NOT NULL Is Quote

    Y/N Table Edit

    Default Value: N

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