EOTP_PARTNER_L(SQL Table) |
Index Back |
|---|---|
Partner (lang related)Partner VR on June 2013, Bug 14806591 -Created as language related. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EOTP_PARTNERID |
Number(15,0) | DECIMAL(15) NOT NULL |
Partner ID
Default Value: 999999999999999 |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | EOTP_PARTNERSTAT | Character(1) | VARCHAR2(1) NOT NULL |
New for Trading Partner Management 8.8
P=Pending R=Partner X=Ended Partnership Default Value: P |
| 4 | EOTP_COMPNAME | Character(30) | VARCHAR2(30) NOT NULL | Company Name |
| 5 | DESCRLONG | Long Character | CLOB | Long Description |
| 6 | EOTP_COMPURL | Character(254) | VARCHAR2(254) NOT NULL | Partner URL |
| 7 | EOTP_INDUSTRY | Character(20) | VARCHAR2(20) NOT NULL | Industry |
| 8 | EOTP_STKSYMBOL | Character(10) | VARCHAR2(10) NOT NULL | Stock Symbol |
| 9 | EOTP_REVENUE | Character(1) | VARCHAR2(1) NOT NULL |
Partner Revenue
A=$1 Billion and Above B=$300 Million - $1 Billion C=$100 Million - $300 Million D=Less than $100 Million N=Not Applicable |
| 10 | EOTP_EMPLCOUNT | Number(15,0) | DECIMAL(15) NOT NULL | Employee Count |
| 11 | EOTP_MINOWNED | Character(1) | VARCHAR2(1) NOT NULL |
Minority Owned
Y/N Table Edit Default Value: N |
| 12 | EOTP_FEMOWNED | Character(1) | VARCHAR2(1) NOT NULL |
Woman Owned
Y/N Table Edit Default Value: N |
| 13 | EOTP_EEODATE | Date(10) | DATE | EEO Certification Date |
| 14 | EOTP_HUBZONE | Character(1) | VARCHAR2(1) NOT NULL |
HUB Zone
Y/N Table Edit Default Value: N |