ROT_CUST_ORD_VW(SQL View) |
Index Back |
|---|---|
OrderThis record is a view used for cutomers order |
| SELECT b.BO_ID ,b.ROLE_TYPE_ID , c.BO_ID ,c.ROLE_TYPE_ID ,a.BUSINESS_UNIT ,a.CAPTURE_ID ,a.CAPTURE_DATE ,a.STATUS_CODE FROM PS_RO_HEADER a , PS_RO_BOID b , PS_RO_BOID c WHERE a.CAPTURE_ID = b.CAPTURE_ID AND a.UID20F_BILL = b.UID20 AND a.CAPTURE_ID = c.CAPTURE_ID AND a.UID20F_BILLC= c.UID20 AND a.CAPTURE_TYPE_CD = 'SO' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 2 | ROLE_TYPE_ID_CUST | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the customer |
| 3 | BO_ID_CONTACT | Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |
| 4 | ROLE_TYPE_ID_CNTCT | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the contact |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | CAPTURE_ID | Character(20) | VARCHAR2(20) NOT NULL | Field use to store the capture ID in order capture. |
| 7 | CAPTURE_DATE | Date(10) | DATE | Order capture date used for orders and quotes |
| 8 | STATUS_CODE | Number(5,0) | INTEGER NOT NULL |
Status Code
Prompt Table: RO_DEFN_HDSTAT |