BI_CUST_CNCT_VW(SQL View) |
Index Back |
---|---|
Curr Eff Dated Contacts/Addres |
select a.setid, a.cust_id, a.cntct_seq_num, a.address_seq_num, a.name1, a.title from PS_CUST_CONTACT a where a.effdt = (select max(effdt) from PS_CUST_CONTACT where setid=a.setid and cust_id=a.cust_id and cntct_seq_num=a.cntct_seq_num and effdt <= %currentdatein) and a.eff_status='A' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
2 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table: CUSTOMER |
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 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
6 | TITLE | Character(35) | VARCHAR2(35) NOT NULL | Title |