RMA_EIP_ADDH_VW

(SQL View)
Index Back

RMA EIP HDR Address


SELECT A.EIP_CTL_ID ,A.BUSINESS_UNIT ,A.RMA_ID ,A.RMA_LINE_NBR ,A.CUST_ADDR_TYPE ,%subrec(ADDRESS_SBR,A) ,%subrec(BUS_PHONE_SBR,A) ,A.LANGUAGE_CD ,A.EMAILID ,A.CUST_NAME ,A.CNTCT_NAME1 ,A.LASTUPDDTTM ,A.LAST_MAINT_OPRID ,A.DATETIME_ADDED FROM PS_RMA_EIP_ADDR A WHERE A.CUST_ADDR_TYPE ='H' AND A.RMA_LINE_NBR = 0

# 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

Prompt Table: RMA_HEADER

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

Default Value: H

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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

Default Value: PSOPTIONS.LANGUAGE_CD

28 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
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