BO_ID_CUSTROLE_TYPE_ID_CUSTBO_ID_CONTACTROLE_TYPE_ID_CNTCTSTATUS_CODEPrompt Table: RO_DEFN_HDSTAT
BUSINESS_UNITCAPTURE_IDQUO=Quote
SO=Order
RI_IQO_STATOVW(SQL View) |
Index Back |
|---|---|
Order View360-Degree View - Order View for Insurance Application by Operator ID |
| SELECT cust.BO_ID , cust.ROLE_TYPE_ID , contact.BO_ID , contact.ROLE_TYPE_ID ,9999999999999999999999999 ,ord.STATUS_CODE ,ord.BUSINESS_UNIT ,ord.CAPTURE_ID ,ord.CAPTURE_DATE ,ord.CAPTURE_TYPE_CD ,ord.QUOTE_EXPIRE_DT ,ord.FIN_ACCOUNT_ID ,ord.TOTAL_PRICE ,ord.DESCR50 , X.OPRID , partner.BO_ID , partner.ROLE_TYPE_ID , partcont.BO_ID , partcont.ROLE_TYPE_ID , %subrec(RB_AUDIT_SBR,ord) FROM PS_RO_HEADER ord , PS_RO_BOID contact , PS_RO_BOID cust , PS_RO_BOID partner , PS_RO_BOID partcont , PS_SEC_BU_OPR X WHERE ord.CAPTURE_ID = cust.CAPTURE_ID AND ord.UID20F_SOLD = cust.UID20 AND ord.BUSINESS_UNIT = X.BUSINESS_UNIT AND ord.CAPTURE_TYPE_CD = 'IQO' AND ord.CAPTURE_ID = contact.CAPTURE_ID(+) AND ord.UID20F_SOLDC = contact.UID20(+) AND ord.CAPTURE_ID = partner.CAPTURE_ID (+) AND ord.UID20F_PARTNER = partner.UID20 (+) AND ord.CAPTURE_ID = partcont.CAPTURE_ID (+) AND ord.UID20F_PARTNERC = partcont.UID20 (+) |
| # | 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 | BO_ID_SITE | Number(31,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 6 | STATUS_CODE |
Number(5,0) | INTEGER NOT NULL |
Status Code
Prompt Table: RO_DEFN_HDSTAT |
| 7 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 8 | CAPTURE_ID |
Character(20) | VARCHAR2(20) NOT NULL | Field use to store the capture ID in order capture. |
| 9 | CAPTURE_DATE | Date(10) | DATE | Order capture date used for orders and quotes |
| 10 | CAPTURE_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL |
Capture Type
QUO=Quote SO=Order |
| 11 | QUOTE_EXPIRE_DT | Date(10) | DATE | Quote Expire Date |
| 12 | FIN_ACCOUNT_ID | Character(20) | VARCHAR2(20) NOT NULL | Financial Account Number |
| 13 | TOTAL_PRICE | Signed Number(30,4) | DECIMAL(28,4) NOT NULL | Total Price |
| 14 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 15 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 16 | BO_ID_PARTNER | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID of Partner Company. |
| 17 | ROLE_TYPE_ID_PART | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the partner |
| 18 | BO_ID_PART_CONT | Signed Number(32,0) | DECIMAL(31) NOT NULL | This is the business object identifier for the partner contact. |
| 19 | ROLE_TYPE_ID_PARTC | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the partner contact |
| 20 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 21 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 22 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 23 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 24 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 25 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |