SETIDPrompt Table: SP_SETID_NONVW
SITE_IDPrompt Table: RDFSITE_CUST_VW
N=No
Y=Yes
Prompt Table: RD_SITETYPE_TBL
RDFSITE_ST_SRCH(SQL View) |
Index Back |
|---|---|
Search record of FSI sitea view of FSI site only, with SERVICE_LOC_SW = 'N' |
| SELECT s.SETID , s.SITE_ID , n.BO_NAME , n.BO_NAME_AC , s.BO_ID_PARENT , b.CUST_ID , p.BO_NAME , n.PRIMARY_IND , s.SITE_TYP_ID FROM PS_RDFSITE_VW s , PS_BO_NAME n , PS_BO_NAME_PRIM_VW p , PS_BC b WHERE s.BO_ID = n.BO_ID AND s.MARKET = 'FIN' AND s.SERVICE_LOC_SW = 'N' AND s.BO_ID_PARENT = p.BO_ID AND b.BO_ID = p.BO_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Prompt Table: SP_SETID_NONVW |
| 2 | SITE_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. |
| 3 | BO_NAME | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 4 | BO_NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 5 | BO_ID_PARENT | Number(31,0) | DECIMAL(31) NOT NULL |
Business Object ID of the Parent Company.
Prompt Table: RDFSITE_CUST_VW |
| 6 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer ID |
| 7 | SITE_PARENT | Character(50) | VARCHAR2(50) NOT NULL | Parent Customer Name |
| 8 | PRIMARY_IND | Character(1) | VARCHAR2(1) NOT NULL |
Flag that indicates whether or not it is Primary
N=No Y=Yes |
| 9 | SITE_TYP_ID | Character(5) | VARCHAR2(5) NOT NULL |
Site Type identifier
Prompt Table: RD_SITETYPE_TBL |