RD_COMPANY_SRCH (SQL View)	Index Back
CRM Company The Company table holds information relative to a Business Organization.

RD_COMPANY_SRCH

(SQL View)

CRM Company

The Company table holds information relative to a Business Organization.

SELECT SETID ,COMPANYID ,BO_ID ,COUNTRY ,TAXPAYER_ID ,CUSTOMER_TYPE ,CONSOL_BUS_UNIT ,BO_ID_PARENT ,WEB_URL ,STOCK_SYMBOL ,INDUSTRY_ID ,LOC_TYPE ,BUSINESS ,REVENUE ,REVENUE_GEN ,EMPL_TOTAL FROM PS_RD_COMPANY

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

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 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

5 TAXPAYER_ID Character(14) VARCHAR2(14) NOT NULL Taxpayer ID

6 CUSTOMER_TYPE Character(1) VARCHAR2(1) NOT NULL Customer Type
1=User 1
2=User 2
3=User 3
4=User 4

7 CONSOL_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Specifies the Billing business unit associated with a consolidated bill.

8 BO_ID_PARENT Number(31,0) DECIMAL(31) NOT NULL Business Object ID of the Parent Company.

9 WEB_URL Character(130) VARCHAR2(130) NOT NULL URL of a customer's website.

10 STOCK_SYMBOL Character(10) VARCHAR2(10) NOT NULL This field is used to store the Stock Symbol

11 INDUSTRY_ID Character(30) VARCHAR2(30) NOT NULL Industry ID.
Prompt Table: RSF_INDUSTRY

12 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

13 BUSINESS Character(4) VARCHAR2(4) NOT NULL Business

14 REVENUE Character(4) VARCHAR2(4) NOT NULL Revenue

15 REVENUE_GEN Number(27,3) DECIMAL(26,3) NOT NULL Total Revenue generated by the customer.

16 EMPL_TOTAL Number(9,0) DECIMAL(9) NOT NULL Total number of employees. Holds up to 9 integer positions.

#	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.
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	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
5	TAXPAYER_ID	Character(14)	VARCHAR2(14) NOT NULL	Taxpayer ID
6	CUSTOMER_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Customer Type 1=User 1 2=User 2 3=User 3 4=User 4
7	CONSOL_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Specifies the Billing business unit associated with a consolidated bill.
8	BO_ID_PARENT	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID of the Parent Company.
9	WEB_URL	Character(130)	VARCHAR2(130) NOT NULL	URL of a customer's website.
10	STOCK_SYMBOL	Character(10)	VARCHAR2(10) NOT NULL	This field is used to store the Stock Symbol
11	INDUSTRY_ID	Character(30)	VARCHAR2(30) NOT NULL	Industry ID. Prompt Table: RSF_INDUSTRY
12	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
13	BUSINESS	Character(4)	VARCHAR2(4) NOT NULL	Business
14	REVENUE	Character(4)	VARCHAR2(4) NOT NULL	Revenue
15	REVENUE_GEN	Number(27,3)	DECIMAL(26,3) NOT NULL	Total Revenue generated by the customer.
16	EMPL_TOTAL	Number(9,0)	DECIMAL(9) NOT NULL	Total number of employees. Holds up to 9 integer positions.