CUSTOMER_SETIDDefault Value: OPR_DEF_TBL.SETID
Prompt Table: SP_SETID_NONVW
CUST_IDPrompt Table: FO_CUST_AL_SRCH
CONTACT_SETIDDefault Value: OPR_DEF_TBL.SETID
Prompt Table: SP_SETID_NONVW
CONTACT_IDPrompt Table: FO_CNTCT_SET_VW
FO_RECENT_SRC(SQL View) |
Index Back |
|---|---|
Recent Call Reports Search |
| SELECT DISTINCT A.CUSTOMER_SETID ,A.CUST_ID ,A.CONTACT_SETID ,A.CONTACT_ID FROM PS_FO_AGENDA_DTL A WHERE (NOT (A.CUST_ID IS NULL )) AND (NOT (A.CONTACT_ID IS NULL)) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CUSTOMER_SETID |
Character(5) | VARCHAR2(5) NOT NULL |
Customer SetID
Default Value: OPR_DEF_TBL.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: FO_CUST_AL_SRCH |
| 3 | CONTACT_SETID |
Character(5) | VARCHAR2(5) NOT NULL |
Contact SetID
Default Value: OPR_DEF_TBL.SETID Prompt Table: SP_SETID_NONVW |
| 4 | CONTACT_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Contact Identifier for Treasury Contacts
Prompt Table: FO_CNTCT_SET_VW |