RMA_EIP_ADDR

(SQL Table)
Index Back

RMA Address 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: BUS_UNIT_TBL_OM

3 RMA_ID Character(10) VARCHAR2(10) NOT NULL RMA Number
4 RMA_LINE_NBR Number(5,0) INTEGER NOT NULL RMA Line Number
5 CUST_ADDR_TYPE Character(1) VARCHAR2(1) NOT NULL Customer Address Type
H=Ship To Customer
S=Sold To Customer
6 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

7 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
8 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
9 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
10 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
11 CITY Character(30) VARCHAR2(30) NOT NULL City
12 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
13 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
14 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer
15 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
16 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
17 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
18 COUNTY Character(30) VARCHAR2(30) NOT NULL County
19 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: %EDIT_STATE

20 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
21 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
22 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

23 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix
24 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
25 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone Extension
26 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
27 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
28 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

Default Value: PSOPTIONS.LANGUAGE_CD

29 CUST_NAME Character(40) VARCHAR2(40) NOT NULL Name
30 CNTCT_NAME1 Character(40) VARCHAR2(40) NOT NULL Contact Name1
31 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
32 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
33 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added
34 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
35 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag
36 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