RO_HDR_SOLD_VW(SQL View) |
Index Back |
|---|---|
Capture Sold CustomerSold To Customer - lists the original and merged bo id's for the sold to customer on the order. |
| SELECT HDR.CAPTURE_ID , SLD.BO_ID , SLD.PROFILE_CM_SEQ , SLD.BO_ID_EIP , SLD.PROFILE_CM_SEQ_EIP , SLD.ROLE_TYPE_ID FROM PS_RO_HEADER HDR , PS_RO_BOID SLD WHERE HDR.CAPTURE_ID=SLD.CAPTURE_ID AND HDR.UID20F_SOLD=SLD.UID20 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CAPTURE_ID | Character(20) | VARCHAR2(20) NOT NULL | Field use to store the capture ID in order capture. |
| 2 | BO_ID_SOLD | Number(31,0) | DECIMAL(31) NOT NULL | Sole To Business Object ID |
| 3 | PROFILE_CM_SEQ_SLD | Number(31,0) | DECIMAL(31) NOT NULL | Profile Contact Method Sequence Number for the Sold To Address |
| 4 | BO_ID_EIP_SLD | Signed Number(32,0) | DECIMAL(31) NOT NULL | This is the integration bo id, this BO ID field is used in the OC eip's to send the BO_Id to other systems |
| 5 | PRO_CM_SEQ_EIP_SLD | Number(31,0) | DECIMAL(31) NOT NULL | The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables. |
| 6 | ROLE_TYPE_ID_CUST | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the customer |