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
Set Control Field: BUSINESS_UNIT

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