FO_CONT_HISTORY(SQL View) |
Index Back |
|---|---|
Front Office HistoryAll Front Office History Data |
| SELECT HISTORY_ID , CUSTOMER_SETID , CUST_ID , CONTACT_SETID , CONTACT_ID , BUSINESS_UNIT , SO_ID , EVENT_TYPE ,DATETIME_ADDED , OFFER_RESULT , COMMENTS_2000 FROM %Table(FO_HISTORY) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  HISTORY_ID |
Number(15,0) | DECIMAL(15) NOT NULL |
History ID
Default Value: 999999999999999 |
| 2 | CUSTOMER_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Customer SetID
Prompt Table: SP_SETID_NONVW |
| 3 | 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_CUSTOMER_SR |
| 4 | CONTACT_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Contact SetID
Prompt Table: SP_SETID_NONVW |
| 5 | CONTACT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Contact Identifier for Treasury Contacts
Prompt Table: FO_CNTCT_SR |
| 6 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PC_NONVW |
| 7 | SO_ID | Character(15) | VARCHAR2(15) NOT NULL |
Service Order ID
Prompt Table: FO_ORDR_SRCH_VW |
| 8 | EVENT_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
Event Type
Prompt Table: FO_EVENT_DST_VW |
| 9 | DATETIME_STAMP | DateTime(26) | TIMESTAMP | DateTime Stamp |
| 10 | OFFER_RESULT | Character(1) | VARCHAR2(1) NOT NULL |
Confidential Order
C=Considering D=Declined E=Accepted O=Other S=Assigned |
| 11 | COMMENTS_2000 | Long Character | CLOB | Comment Text |