RO_EMAIL_LIT_VW(SQL View) |
Index Back |
|---|---|
Order Capture Search VWUsed to search for Capture Records |
| SELECT A.CAPTURE_ID , C.DESCR , A.LINE_NBR , A.PRICE , A.PRODUCT_ID , A.QTY_ORDERED , A.STATUS_CODE , A.UNIT_OF_MEASURE FROM PS_RO_LINE A , PS_SET_CNTRL_REC B , PS_PROD_ITEM C , PS_PROD_PGRP_LNK D WHERE A.BUSINESS_UNIT = B.SETCNTRLVALUE AND B.RECNAME = 'PROD_ITEM' AND B.SETID= C.SETID AND C.SETID = D.SETID AND C.PRODUCT_ID = D.PRODUCT_ID AND C.PRODUCT_ID = A.PRODUCT_ID AND D.PROD_GRP_TYPE = 'LIT' |
| # | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | This field represents the integer Order Line Number. |
| 4 | PRICE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | This is price per unit for calculating the service charge. |
| 5 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 6 | QTY_ORDERED | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Order Qty |
| 7 | STATUS_CODE | Number(5,0) | INTEGER NOT NULL |
Status Code
Default Value: 1000 |
| 8 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
CS=Case EA=Each MHR=Muti Hourly PER=Percentage SQF=Square Footage |