RO_LINE_BOID_VW(SQL View) |
Index Back |
|---|---|
Line BOIDThis view contains the deatils of Line BOID |
| SELECT LIN.CAPTURE_ID , LIN.LINE_NBR , SHP.BO_ID , SHP.PROFILE_CM_SEQ , SHR.BO_ID , SHR.PROFILE_CM_SEQ FROM PS_RO_LINE LIN , PS_RO_DEST DSS , PS_RO_BOID SHP , PS_RO_BOID SHR WHERE LIN.CAPTURE_ID=DSS.CAPTURE_ID AND LIN.UID20F=DSS.UID20 AND DSS.CAPTURE_ID=SHP.CAPTURE_ID AND DSS.UID20F_SHIP=SHP.UID20 AND DSS.CAPTURE_ID=SHR.CAPTURE_ID AND DSS.UID20F_SHIPC=SHR.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 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | This field represents the integer Order Line Number. |
| 3 | BO_ID_SHIP | Number(31,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 4 | PROFILE_CM_SEQ_SHP | Number(31,0) | DECIMAL(31) NOT NULL | Profile Sequence |
| 5 | BO_ID_SHIPR | Number(31,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 6 | PROFILE_CM_SQ_SHPR | Number(31,0) | DECIMAL(31) NOT NULL | Profile Sequence |