RO_HDR_BOID_VW(SQL View) |
Index Back |
---|---|
Search ViewThis is the search view for order capture bo ids. |
SELECT HDR.CAPTURE_ID , SLD.BO_ID , SLD.PROFILE_CM_SEQ , SLR.BO_ID , SLR.PROFILE_CM_SEQ , BIL.BO_ID , BIL.PROFILE_CM_SEQ , BIR.BO_ID , BIR.PROFILE_CM_SEQ , SHP.BO_ID , SHP.PROFILE_CM_SEQ , SHR.BO_ID , SHR.PROFILE_CM_SEQ , PRT.BO_ID FROM PS_RO_HEADER HDR , PS_RO_BOID SLD , PS_RO_BOID SLR , PS_RO_BOID BIL , PS_RO_BOID BIR , PS_RO_DEST DSS , PS_RO_BOID SHP , PS_RO_DEST DSR , PS_RO_BOID SHR , PS_RO_BOID PRT WHERE HDR.CAPTURE_ID=SLD.CAPTURE_ID AND HDR.UID20F_SOLD=SLD.UID20 AND HDR.CAPTURE_ID=SLR.CAPTURE_ID AND HDR.UID20F_SOLDC=SLR.UID20 AND HDR.CAPTURE_ID=BIL.CAPTURE_ID AND HDR.UID20F_BILL=BIL.UID20 AND HDR.CAPTURE_ID=BIR.CAPTURE_ID AND HDR.UID20F_BILLC=BIR.UID20 AND HDR.CAPTURE_ID=DSS.CAPTURE_ID AND HDR.UID20F=DSS.UID20 AND DSS.CAPTURE_ID=SHP.CAPTURE_ID AND DSS.UID20F_SHIP=SHP.UID20 AND HDR.CAPTURE_ID=DSR.CAPTURE_ID AND HDR.UID20F=DSR.UID20 AND DSR.CAPTURE_ID=SHR.CAPTURE_ID AND DSR.UID20F_SHIPC=SHR.UID20 AND HDR.CAPTURE_ID=PRT.CAPTURE_ID AND HDR.UID20F_PARTNER=PRT.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_SOLDR | Number(31,0) | DECIMAL(31) NOT NULL | Business Object ID |
5 | PROFILE_CM_SQ_SLDR | Number(31,0) | DECIMAL(31) NOT NULL | Profile Sequence |
6 | BO_ID_BILL | Number(31,0) | DECIMAL(31) NOT NULL | Business Object ID |
7 | PROFILE_CM_SEQ_BIL | Number(31,0) | DECIMAL(31) NOT NULL | Profile Contact Method Sequence Number for Billing |
8 | BO_ID_BILLR | Number(31,0) | DECIMAL(31) NOT NULL | Business Object ID |
9 | PROFILE_CM_SQ_BILR | Number(31,0) | DECIMAL(31) NOT NULL | Profile Sequence |
10 | BO_ID_SHIP | Number(31,0) | DECIMAL(31) NOT NULL | Business Object ID |
11 | PROFILE_CM_SEQ_SHP | Number(31,0) | DECIMAL(31) NOT NULL | Profile Sequence |
12 | BO_ID_SHIPR | Number(31,0) | DECIMAL(31) NOT NULL | Business Object ID |
13 | PROFILE_CM_SQ_SHPR | Number(31,0) | DECIMAL(31) NOT NULL | Profile Sequence |
14 | BO_ID_PARTNER | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID of Partner Company. |