OM_RETURN_VW(SQL View) |
Index Back |
|---|---|
Order Returns |
| SELECT RL.RMA_ID ,RL.PRODUCT_ID , RH.SOLD_TO_CUST_ID ,RL.RETURN_TO_IBU ,RL.REASON_CD ,RH.RMA_STATUS , RH.RMA_DATE FROM PS_RMA_HEADER RH , PS_RMA_LINE RL WHERE RH.BUSINESS_UNIT = RL.BUSINESS_UNIT AND RH.RMA_ID = RL.RMA_ID AND RH.RMA_TYPE = 'O' AND RL.PRODUCT_ID <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RMA_ID | Character(10) | VARCHAR2(10) NOT NULL | RMA Number |
| 2 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 3 | SOLD_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Sold To Customer |
| 4 | RETURN_TO_IBU | Character(5) | VARCHAR2(5) NOT NULL | Return To IBU |
| 5 | REASON_CD | Character(10) | VARCHAR2(10) NOT NULL | Reason Code |
| 6 | RMA_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
RMA Status
C=Closed O=Open P=Pending X=Canceled Prompt Table: XLATTABLE_VW |
| 7 | RMA_DATE | Date(10) | DATE | RMA Date |