AGENDA_IDPrompt Table: FO_EVENT_DST_VW
Y/N Table Edit
Default Value: N
Prompt Table: SP_SETID_NONVW
Prompt Table: FO_CUSTOMER_SR
Prompt Table: SP_SETID_NONVW
Prompt Table: FO_CNTCT_SR
FO_CONT_AGENDA(SQL View) |
Index Back |
|---|---|
Agenda DetailAgenda Detail Record. |
| SELECT AGENDA_ID , FO_DATE , START_TIME , BUSINESS_UNIT , SO_ID , EVENT_TYPE , COMPLETED , CUSTOMER_SETID , CUST_ID , CONTACT_SETID , CONTACT_ID , COMMENTS_2000 FROM %Table(FO_AGENDA_DTL) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | AGENDA_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Agenda ID |
| 2 | FO_DATE | Date(10) | DATE NOT NULL | Date |
| 3 | START_TIME | Time(15) | TIMESTAMP NOT NULL | Start of Shift |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | SO_ID | Character(15) | VARCHAR2(15) NOT NULL | Service Order ID |
| 6 | EVENT_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
Event Type
Prompt Table: FO_EVENT_DST_VW |
| 7 | COMPLETED | Character(1) | VARCHAR2(1) NOT NULL |
Completed
Y/N Table Edit Default Value: N |
| 8 | CUSTOMER_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Customer SetID
Prompt Table: SP_SETID_NONVW |
| 9 | 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 |
| 10 | CONTACT_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Contact SetID
Prompt Table: SP_SETID_NONVW |
| 11 | CONTACT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Contact Identifier for Treasury Contacts
Prompt Table: FO_CNTCT_SR |
| 12 | COMMENTS_2000 | Long Character | CLOB | Comment Text |