CAPTURE_IDUID20UID20_1Prompt Table: RO_DEFN_LNSTAT
OCD_LINEST_VW(SQL View) |
Index Back |
|---|---|
Definition of line containerThis is an order management dashboard view of the instance of a line container. |
| SELECT A.CAPTURE_ID ,A.UID20 ,A.UID20_1 ,A.QTY_ORDERED ,R.SETID ,A.STATUS_CODE FROM PS_RO_LINE_STATUS A , PS_RO_HEADER B , PS_SET_CNTRL_REC R WHERE A.CAPTURE_ID=B.CAPTURE_ID AND R.SETCNTRLVALUE = B.BUSINESS_UNIT AND R.RECNAME='RO_DEFN_LNSTAT' |
| # | 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 | UID20_1 |
Character(20) | VARCHAR2(20) NOT NULL | UID................................................................................. |
| 4 | QTY_ORDERED | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Order Quantity |
| 5 | SETID_STATUS | Character(5) | VARCHAR2(5) NOT NULL | MOC SETID Field |
| 6 | STATUS_CODE | Number(5,0) | INTEGER NOT NULL |
Status Code
Prompt Table: RO_DEFN_LNSTAT |