RO_HDR_BOID_VW

(SQL View)
Index Back

Search View

This 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.