RD_COMPANY

(SQL Table)
 Index Back

CRM Company

The Company table holds information relative to a Business Organization.

  • Parent Record Of RB_CONS_NOTE_VW RB_CUST_CGROUP RB_CUST_NOTE_LN RB_CUST_NOTE_VW RB_NOTES_LIST RB_NOTES_LST_LN RB_NOTE_FLT_WRK RB_SITE_NOTE_LN RB_SITE_NOTE_VW RD_COMPANY_ATTR

    • # 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 COMPANYID Character(15) VARCHAR2(15) NOT NULL Company ID

    Default Value: NEXT

    3 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
    4 DUNS_NUMBER Character(20) VARCHAR2(20) NOT NULL DUNS Number
    5 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    6 STATE_INCORPORATED Character(6) VARCHAR2(6) NOT NULL State Incorporated.

    Prompt Table: STATE_TBL

    7 TAXPAYER_ID Character(14) VARCHAR2(14) NOT NULL Taxpayer ID
    8 CUSTOMER_TYPE Character(1) VARCHAR2(1) NOT NULL Customer Type
    1=User 1
    2=User 2
    3=User 3
    4=User 4
    9 CONSOL_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Specifies the Billing business unit associated with a consolidated bill.
    10 BO_ID_PARENT Number(31,0) DECIMAL(31) NOT NULL Business Object ID of the Parent Company.

    Prompt Table: RD_NAME_SRCH_VW

    11 WEB_URL Character(130) VARCHAR2(130) NOT NULL URL of a customer's website.
    12 SIC_TYPE Character(10) VARCHAR2(10) NOT NULL SIC Type.

    Prompt Table: SIC_TYPE

    13 SIC_CODE Character(10) VARCHAR2(10) NOT NULL Standard Industry Code

    Prompt Table: SIC_CODE

    14 INDUSTRY_ID Character(30) VARCHAR2(30) NOT NULL Industry ID.

    Prompt Table: RSF_INDUSTRY_VW

    15 INDUSTRY_ID2 Character(30) VARCHAR2(30) NOT NULL Secondary Industry.

    Prompt Table: RSF_INDUSTRY_VW

    16 LOC_TYPE Character(4) VARCHAR2(4) NOT NULL Location type. For example: Subsidiary, Division, Branch, Heaquarters, Single Location.
    01=Subsidiary
    02=Division
    03=Branch
    04=Headquarters
    05=Single Location
    17 BUSINESS Character(4) VARCHAR2(4) NOT NULL Business
    18 EMPL_TOTAL Number(9,0) DECIMAL(9) NOT NULL Total number of employees. Holds up to 9 integer positions.
    19 SOURCE_IND Character(4) VARCHAR2(4) NOT NULL EIP Source Indicator
    CRM=CRM
    EBS=EBIZ Suite
    EXT=External
    HRMS=HCM
    SCM=SCM

    Default Value: CRM

    20 LEGAL_STRUCTURE Character(1) VARCHAR2(1) NOT NULL Legal Structure.
    1=Corporation
    2=Partnership, LLC
    3=Sole Proprietorship
    21 OWNERSHIP Character(4) VARCHAR2(4) NOT NULL Ownership type. e.g., Public or Private.
    01=Public
    02=Private
    22 YEAR_STARTED Number(4,0) SMALLINT NOT NULL State Incorporated.
    23 YEAR_INCORPORATED Number(4,0) SMALLINT NOT NULL Year Incorporated.
    24 MINORITY_OWNED_IND Character(1) VARCHAR2(1) NOT NULL Minority Owned Indicator.

    Y/N Table Edit

    25 PARTNER_IND Character(1) VARCHAR2(1) NOT NULL Partner Indicator.
    N=No
    Y=Yes

    Default Value: N

    26 FISCAL_YEAR_END Date(10) DATE Fiscal Year End.
    27 STATEMENT_IND Character(1) VARCHAR2(1) NOT NULL Statement Indiocator.
    1=Actual
    2=Estimate
    28 STATEMENT_DT Date(10) DATE Used for the Statement Date for Order document self service component
    29 AUDIT_IND Character(1) VARCHAR2(1) NOT NULL Audit Indicator.
    1=Audited
    2=Unaudited
    30 AUDITOR_NAME Character(50) VARCHAR2(50) NOT NULL Auditor.
    31 STOCK_SYMBOL Character(10) VARCHAR2(10) NOT NULL This field is used to store the Stock Symbol
    32 STOCK_EXCHANGE Character(10) VARCHAR2(10) NOT NULL Stock Exchange.
    33 STOCK_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL Stock Price
    34 MARKET_CAP Signed Number(28,3) DECIMAL(26,3) NOT NULL Market Capitalization.
    35 QUOTE_DT Date(10) DATE Quote Date.
    36 NET_INCOME Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Income.
    37 TOTAL_ASSETS Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Assets.
    38 TOTAL_LIABILITIES Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Liabilities.
    39 ACCTS_PAYABLE Signed Number(28,3) DECIMAL(26,3) NOT NULL Accounts Payable.
    40 ACCTS_RECEIVABLE Signed Number(28,3) DECIMAL(26,3) NOT NULL Accounts Receivable.
    41 NET_WORTH Signed Number(30,4) DECIMAL(28,4) NOT NULL Net Worth of A Client in Wealth Management,
    42 CREDIT_RATING Character(4) VARCHAR2(4) NOT NULL Credit Rating
    43 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

    Prompt Table: CURRENCY_CD_TBL

    44 REVENUE Character(4) VARCHAR2(4) NOT NULL Revenue
    45 REVENUE_GEN Number(27,3) DECIMAL(26,3) NOT NULL Total Revenue generated by the customer.
    46 MARKET Character(3) VARCHAR2(3) NOT NULL Market
    47 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    48 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    49 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    50 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    51 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.
    52 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time