BUSINESS_UNITDefault Value: OPR_DEF_TBL_RB.BUSINESS_UNIT
Prompt Table: SP_BU_RC_NONVW
RMA_IDPrompt Table: RF_RMA_PRPT_VW
Prompt Table: RF_CNAME_PR_VW2
Prompt Table: RF_RMA_PRPT_VW4
RF_RMA_SRCH_VW(SQL View) |
Index Back |
|---|---|
RMA Search ViewThis is the Search view for the RF_RMA component. |
| SELECT A.BUSINESS_UNIT , A.RMA_ID , A.BO_ID_CUST , C.SETID , C.CUST_ID , B.BO_NAME_DISPLAY , B.BO_NAME_AC , A.CASE_ID FROM PS_RF_RMA_HDR A , PS_BO_NAME B , PS_BC C WHERE C.BO_ID = A.BO_ID_CUST AND B.BO_ID = C.BO_ID AND B.PRIMARY_IND = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_RB.BUSINESS_UNIT Prompt Table: SP_BU_RC_NONVW |
| 2 | RMA_ID |
Character(10) | VARCHAR2(10) NOT NULL |
RMA Number
Prompt Table: RF_RMA_PRPT_VW |
| 3 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 4 | SETID_CUSTOMER | Character(5) | VARCHAR2(5) NOT NULL | Customer SetID |
| 5 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Customer ID
Prompt Table: RF_CNAME_PR_VW2 |
| 6 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
| 7 | BO_NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 8 | CASE_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.
Prompt Table: RF_RMA_PRPT_VW4 |