AUC_AW_CNTCT_VW(SQL View) |
Index Back |
|---|---|
Contact HeaderUsed to store Contact information |
| SELECT setid , bidder_id , contact_seq_num AS cntct_seq_num , addr_seq_num AS address_seq_num , descr1 , first_name , last_name , %TrimSubstr(%trimsubstr(first_name, 1, 30) %Concat ' ' %Concat last_name, 1, 50) , title , title , emailid , phone , extension , fax ,contact_type FROM PS_AUC_CONTACT_HDR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | BIDDER_ID |
Character(15) | VARCHAR2(15) NOT NULL | Bidder ID |
| 3 | CNTCT_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Contact Sequence Number |
| 4 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Address Sequence Number |
| 5 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 6 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 7 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 8 | CONTACT_NAME | Character(50) | VARCHAR2(50) NOT NULL | The individual contact name associated with a given bank/counterparty. |
| 9 | CONTACT_TITLE | Character(35) | VARCHAR2(35) NOT NULL | The professional title for a given bank/counterparty contact person. |
| 10 | TITLE | Character(35) | VARCHAR2(35) NOT NULL | Title |
| 11 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 12 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 13 | EXTENSION | Character(6) | VARCHAR2(6) NOT NULL | Phone Extension |
| 14 | FAX | Character(24) | VARCHAR2(24) NOT NULL | Fax Number |
| 15 | CONTACT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
An attribute that describes the specific purpose of a given bank/counterparty contact person.
B=Billing Contact C=Contract Collaborator D=Commercial Paper Contact E=External Contact F=Cash Forecast G=General I=Internal Corporate Contact L=Line of Credit Contact M=Executive Management O=Investment Pool Contact P=Accounts Payable R=Broker S=Sales Contact V=Service Contact W=Warehousing/Shipping Contact |