RD_COMPANY_2_VW(SQL View) |
Index Back |
---|---|
CRM CompanyThe 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 |