RMA_EIP_HEADER(SQL Table) |
Index Back |
---|---|
RMA header EIP stage table |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EIP_CTL_ID | Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |
2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_FS_NONVW |
3 | RMA_ID | Character(10) | VARCHAR2(10) NOT NULL | RMA Number |
4 | RMA_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
RMA Status
C=Closed O=Open P=Pending X=Canceled |
5 | ADDRESS_SEQ_SHIP | Number(5,0) | INTEGER NOT NULL |
Primary Address - Ship To
Prompt Table: RMA_RETFROM_VW |
6 | RMA_DATE | Date(10) | DATE | RMA Date |
7 | RETURN_FROM_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Return From Option
E=External Customer I=Internal Location |
8 | RETURN_FROM_LOC | Character(10) | VARCHAR2(10) NOT NULL |
Return From Location
Prompt Table: RMA_LOCATION_VW |
9 | RETURN_FR_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Return From Cust ID
Prompt Table: CUST_SHPINV_VW |
10 | RETURN_TYPE_CD | Character(10) | VARCHAR2(10) NOT NULL | Return Type Code |
11 | REASON_CD | Character(10) | VARCHAR2(10) NOT NULL |
Reason Code
Prompt Table: RMA_REASON_VW |
12 | RETURN_TO_IBU | Character(5) | VARCHAR2(5) NOT NULL |
Return To IBU
Prompt Table: SP_BU_FS_NONVW |
13 | EST_RETURN_DTTM | DateTime(26) | TIMESTAMP | Estimated Return DateTime |
14 | DISTRIB_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
Distrib. Type
Prompt Table:
DISTR_IBU_VW
|
15 | RMA_APPROVED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Approval Required
Y/N Table Edit Default Value: Y |
16 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
17 | IN_PROCESS_FLG | Character(1) | VARCHAR2(1) NOT NULL | In process flag |
18 | AUDIT_ACTN | Character(1) | VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values |
19 | ADDR_OVRD_LEVEL | Character(1) | VARCHAR2(1) NOT NULL |
Address Override Level
D=Demand Line H=Header L=Line S=Schedule |
20 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Analysis Type |