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

RD_COMPANY_VW

(SQL View)

CRM Company

The Company table holds information relative to a Business Organization.

SELECT A.SETID , A.COMPANYID , A.COUNTRY , A.TAXPAYER_ID , A.CUSTOMER_TYPE , A.CONSOL_BUS_UNIT , A.BO_ID_PARENT , A.WEB_URL , A.STOCK_SYMBOL , A.INDUSTRY_ID , A.LOC_TYPE , A.BUSINESS , A.REVENUE , A.REVENUE_GEN , A.EMPL_TOTAL , A.BO_ID , B.BO_NAME , C.CUSTOMER_IND , C.CUST_STATUS , C.CUST_STATUS_DT , C.CUR_RT_TYPE , C.CURRENCY_CD , C.VAT_TXN_TYPE_CD , C.SINCE_DT , C.ADD_DT , C.SHIP_TO_FLG , C.BILL_TO_FLG , C.SEGMENT , C.DO_NOT_CONTACT , C.DO_NOT_EMAIL , C.DO_NOT_MAIL , C.DO_NOT_CALL , B.PRIMARY_IND FROM PS_RD_COMPANY A , PS_BO_NAME B , PS_BC_FLAGS_VW C WHERE A.BO_ID = B.BO_ID AND A.BO_ID =C.BO_ID AND B.PRIMARY_IND = 'Y'

# 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

3 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

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

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

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

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

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

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

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

11 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

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

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

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

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

16 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

17 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

18 CUSTOMER_IND Character(1) VARCHAR2(1) NOT NULL Customer Indicator for Business Contacts.
N=No
Y=Yes

19 CUST_STATUS Character(1) VARCHAR2(1) NOT NULL Customer Status Indicator. BC.CUST_STATUS
A=Active
I=Inactive

20 CUST_STATUS_DT Date(10) DATE The date that the status of a customer takes effect.

21 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type

22 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.
Prompt Table: CURRENCY_CD_TBL

23 VAT_TXN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.

24 SINCE_DT Date(10) DATE The customer has been a customer since this date.

25 ADD_DT Date(10) DATE The date the customer was added to the system.

26 SHIP_TO_FLG Character(1) VARCHAR2(1) NOT NULL A flag indicating that the customer or address is a valid Ship To customer or address.

27 BILL_TO_FLG Character(1) VARCHAR2(1) NOT NULL A boolean that flags whether or not the customer is a valid Bill To customer.

28 SEGMENT Character(4) VARCHAR2(4) NOT NULL Segment code for customer data

29 DO_NOT_CONTACT Character(1) VARCHAR2(1) NOT NULL DO_NOT_CONTACT is used to comply with the Telemarketing and Consumer Fraud and Abuse Prevention Act, 15 USC 6101, enacted in 1994.
N=Contact Permitted
Y=Do not contact

30 DO_NOT_EMAIL Character(1) VARCHAR2(1) NOT NULL Do Not Email
N=No
Y=Yes

31 DO_NOT_CALL Character(1) VARCHAR2(1) NOT NULL channel flag of privacy preference
N=No
Y=Yes

32 DO_NOT_MAIL Character(1) VARCHAR2(1) NOT NULL Do Not Mail
N=No
Y=Yes

33 PRIMARY_IND Character(1) VARCHAR2(1) NOT NULL Flag that indicates whether or not it is Primary
N=No
Y=Yes

#	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
3	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
4	TAXPAYER_ID	Character(14)	VARCHAR2(14) NOT NULL	Taxpayer ID
5	CUSTOMER_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Customer Type 1=User 1 2=User 2 3=User 3 4=User 4
6	CONSOL_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Specifies the Billing business unit associated with a consolidated bill.
7	BO_ID_PARENT	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID of the Parent Company.
8	WEB_URL	Character(130)	VARCHAR2(130) NOT NULL	URL of a customer's website.
9	STOCK_SYMBOL	Character(10)	VARCHAR2(10) NOT NULL	This field is used to store the Stock Symbol
10	INDUSTRY_ID	Character(30)	VARCHAR2(30) NOT NULL	Industry ID. Prompt Table: RSF_INDUSTRY
11	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
12	BUSINESS	Character(4)	VARCHAR2(4) NOT NULL	Business
13	REVENUE	Character(4)	VARCHAR2(4) NOT NULL	Revenue
14	REVENUE_GEN	Number(27,3)	DECIMAL(26,3) NOT NULL	Total Revenue generated by the customer.
15	EMPL_TOTAL	Number(9,0)	DECIMAL(9) NOT NULL	Total number of employees. Holds up to 9 integer positions.
16	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
17	BO_NAME	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
18	CUSTOMER_IND	Character(1)	VARCHAR2(1) NOT NULL	Customer Indicator for Business Contacts. N=No Y=Yes
19	CUST_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Customer Status Indicator. BC.CUST_STATUS A=Active I=Inactive
20	CUST_STATUS_DT	Date(10)	DATE	The date that the status of a customer takes effect.
21	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
22	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value. Prompt Table: CURRENCY_CD_TBL
23	VAT_TXN_TYPE_CD	Character(4)	VARCHAR2(4) NOT NULL	Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.
24	SINCE_DT	Date(10)	DATE	The customer has been a customer since this date.
25	ADD_DT	Date(10)	DATE	The date the customer was added to the system.
26	SHIP_TO_FLG	Character(1)	VARCHAR2(1) NOT NULL	A flag indicating that the customer or address is a valid Ship To customer or address.
27	BILL_TO_FLG	Character(1)	VARCHAR2(1) NOT NULL	A boolean that flags whether or not the customer is a valid Bill To customer.
28	SEGMENT	Character(4)	VARCHAR2(4) NOT NULL	Segment code for customer data
29	DO_NOT_CONTACT	Character(1)	VARCHAR2(1) NOT NULL	DO_NOT_CONTACT is used to comply with the Telemarketing and Consumer Fraud and Abuse Prevention Act, 15 USC 6101, enacted in 1994. N=Contact Permitted Y=Do not contact
30	DO_NOT_EMAIL	Character(1)	VARCHAR2(1) NOT NULL	Do Not Email N=No Y=Yes
31	DO_NOT_CALL	Character(1)	VARCHAR2(1) NOT NULL	channel flag of privacy preference N=No Y=Yes
32	DO_NOT_MAIL	Character(1)	VARCHAR2(1) NOT NULL	Do Not Mail N=No Y=Yes
33	PRIMARY_IND	Character(1)	VARCHAR2(1) NOT NULL	Flag that indicates whether or not it is Primary N=No Y=Yes