CAPTURE_IDUID20Prompt Table: CARRIER_VW
Prompt Table: SP_BU_RO_NONVW
OCD_DEST_VW(SQL View) |
Index Back |
|---|---|
View of DestinationsThis is an order management view of destinations. |
| SELECT A.CAPTURE_ID , A.UID20 , R1.SETID , A.CARRIER , A.REQ_ARRIVAL_DATE , A.REQ_SHIP_DATE , A.SCHED_ARRV_DATE , A.SCHED_SHIP_DATE , C.BO_ID_SOLD_TO_CUST , B.BUSINESS_UNIT , R2.SETID , B.STATUS_CODE FROM PS_RO_DEST A , PS_RO_HEADER B , PS_SET_CNTRL_REC R1 , PS_SET_CNTRL_REC R2 , PS_OCD_SOLD_VW C WHERE A.CAPTURE_ID=B.CAPTURE_ID AND R1.SETCNTRLVALUE = B.BUSINESS_UNIT AND R1.RECNAME='CARRIER_TBL' AND B.CAPTURE_ID = C.CAPTURE_ID AND R2.SETCNTRLVALUE = B.BUSINESS_UNIT AND R2.RECNAME='RO_DEFN_HDSTAT' |
| # | 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 | UID20 |
Character(20) | VARCHAR2(20) NOT NULL | This field is for UID of 20 characters long. |
| 3 | SETID_CARRIER | Character(5) | VARCHAR2(5) NOT NULL | Carrier Setid |
| 4 | CARRIER | Character(10) | VARCHAR2(10) NOT NULL |
Carrier or preferred carrier. Also used for Shipping Method.
Prompt Table: CARRIER_VW |
| 5 | REQ_ARRIVAL_DATE | Date(10) | DATE | Requested Arrival Date |
| 6 | REQ_SHIP_DATE | Date(10) | DATE | Requested Ship Date |
| 7 | SCHED_ARRV_DATE | Date(10) | DATE | Sch Arr Dt/Tm |
| 8 | SCHED_SHIP_DATE | Date(10) | DATE | Sch Shp Dt/Tm |
| 9 | BO_ID_SOLD_TO_CUST | Number(31,0) | DECIMAL(31) NOT NULL | BO ID for the sold to customer |
| 10 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_RO_NONVW |
| 11 | SETID_HDSTAT | Character(5) | VARCHAR2(5) NOT NULL | This field is for setid for header status |
| 12 | STATUS_CD_HDR | Number(5,0) | INTEGER NOT NULL | This field contains the header status for work order statuses in FMS. |