COMPANYPrompt Table: COMPANY_TBL
BPS_BUSINESS_NODefault Value: BUSINESS_NUM_VW.BPS_BUSINESS_NO
Prompt Table: BUSINESS_NUM_VW
BPS_CONTACT_CAN(SQL Table) |
Index Back |
|---|---|
BPS Business and Contact Info.Defines business and contact information for BPS reporting. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 2 | BPS_BUSINESS_NO |
Character(9) | VARCHAR2(9) NOT NULL |
Business Number
Default Value: BUSINESS_NUM_VW.BPS_BUSINESS_NO Prompt Table: BUSINESS_NUM_VW |
| 3 | BPS_BUSINESS_NAME | Character(25) | VARCHAR2(25) NOT NULL | Legal Name of Business |
| 4 | BPS_CONTACT_NAME | Character(15) | VARCHAR2(15) NOT NULL | Contact Name |
| 5 | BPS_PHONE_NO | Character(12) | VARCHAR2(12) NOT NULL | Telephone Number |
| 6 | BPS_FAX_NO | Character(12) | VARCHAR2(12) NOT NULL | Fax Number |
| 7 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |