COMPANY_VW(SQL View) |
Index Back |
|---|---|
CRM CompanyThe Company table holds information relative to a Business Organization. |
| SELECT BO_ID , SETID , COMPANYID , 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 , MARKET , SOURCE_IND , ROW_LASTMANT_OPRID , ROW_LASTMANT_DTTM 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 |
| 3 | COMPANYID | Character(15) | VARCHAR2(15) NOT NULL |
Company ID
Default Value: NEXT |
| 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.
Prompt Table: RD_NAME_SRCH_VW |
| 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_VW |
| 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. |
| 17 | MARKET | Character(3) | VARCHAR2(3) NOT NULL | Market |
| 18 | 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 |
| 19 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 20 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |