BO

(SQL Table)
 Index Back

Business Objecta

Business Object is the main record that establishes the Customer Data Model.

  • Parent Record Of BCM_NOTE BCM_NOTE_LANG BC_NOTE BC_NOTE_CI_LVW BC_NOTE_CI_VW BC_NOTE_LANG BC_NOTE_SBR BO_NAME BO_NAME_BILL_VW BO_NAME_CNTC_VW BO_NAME_PRIM_VW BO_NAME_PRI_VW1 BO_NAME_PRI_VW2 BO_NAME_VW BO_NOTE_VW DERIVED_COMP_NM FL_NAME_AET RBF_ALCP_ADD_VW RBF_ALCP_CIS_VW RBF_ALCP_GS_VW RBF_ALCP_SRH_VW RBF_ARRA_ALT_VW RBF_ARRA_COM_VW RBF_SRVLC_GS_VW RBF_SRVLG_CLSVW RBF_SRVLG_OPRVW RBF_SRVL_GS_VW RBF_SRVL_GS_VW1 RB_CMP_SRCH_VW2 RB_COMP_ADD_VW RB_COMP_ADD_VW2 RB_COMP_NAME_VW RB_COMP_SRCH_VW RB_DUP_NAME RB_SITE_P_NM_VW RC_CSSUM_CST_VW RC_PTNR_EMPTYVW RC_PTNR_SRCH_VW RDFSITE_ADD_VW RDFSITE_CISL_V1 RDFSITE_SL_P_LA RDFSITE_SL_P_VW RDFSITE_SL_SH_L RDFSITE_SL_SRCH RDFSITE_ST_SRCH RDF_SITEG_CLSVW RDF_SITEG_OPRVW RDF_SITE_GS_VW RD_ALCPG_CLSVW RD_ALCPG_OPRVW RD_ALCP_SRCH_VW RD_COMPG_CLSVW RD_COMPG_OPRVW RD_COMP_GS_VW RD_COMP_GS_VW2 RD_COMP_SRCH_VW RD_NAME_SRCH_VW RD_PARENT_NAME RD_PTNRG_CLSVW RD_PTNRG_OPRVW RD_PTNR_SRCH_VW RD_SITE_ADD_VW RD_SITE_MOBL_VW RD_SITE_SRCH_VW RF_COMP_SRCH_VW RF_PTNR_SRCH_VW RSFM_COMPANY_VW RSF_BO_CONT_VW RSF_BO_NAME_VW RSF_BO_OP_NM_VW RSF_LE_CUST_V2 RSF_LE_CUST_VW RSF_NAME_BO_VW RSF_OPP_CUST_V2 RSF_OPP_CUST_VW RSF_RFRD_BY_VW RSF_WM_RFRDBY_V UPG_BO_NAME_TAO

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
    2 BO_TYPE_ID Number(6,0) INTEGER NOT NULL ID Type

    Default Value: 1

    Prompt Table: BO_TYPE

    3 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
    4 BO_NAME_SHORT Character(10) VARCHAR2(10) NOT NULL Short Name of Business Object
    5 MERGE_STATUS Character(1) VARCHAR2(1) NOT NULL This field is used to indicate the BO status, for example, when it is in process of being merged.
    A=Active
    I=Inactive
    M=Merge In Progress

    Default Value: A

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