RD_COMPANY_2_VW

(SQL View)
Index Back

CRM Company

The Company table holds information relative to a Business Organization.

SELECT BO_ID , SETID , COMPANYID , DUNS_NUMBER , COUNTRY , STATE_INCORPORATED , TAXPAYER_ID , CUSTOMER_TYPE , CONSOL_BUS_UNIT , BO_ID_PARENT , WEB_URL , SIC_TYPE , SIC_CODE , INDUSTRY_ID , INDUSTRY_ID2 , LOC_TYPE , BUSINESS , EMPL_TOTAL , SOURCE_IND , LEGAL_STRUCTURE , OWNERSHIP , YEAR_STARTED , YEAR_INCORPORATED , MINORITY_OWNED_IND , PARTNER_IND , %subrec(RD_FINANCL_SBR, PS_RD_COMPANY) , %subrec(RB_MARKET_SBR, PS_RD_COMPANY) , %subrec(RB_AUDIT_SBR, PS_RD_COMPANY) FROM PS_RD_COMPANY

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

3 COMPANYID Character(15) VARCHAR2(15) NOT NULL Company ID

Default Value: NEXT

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
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