RMA_ADDR_FS

(SQL View)
 Index Back

RMA Addresses

This table holds the over-ride address associated with a Quotation or Sales Order. If a user elects to enter a "one-time" address on the header or schedule, the address will be stored in this record.

select A.BUSINESS_UNIT, A.RMA_ID, A.RMA_LINE_NBR, A.CUST_ADDR_TYPE, %SUBREC(ADDRESS_SBR,A), %SUBREC(BUS_PHONE_SBR,A), A.EMAILID, A.CUST_NAME, A.CNTCT_NAME1 from PS_RMA_ADDR A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 RMA_ID Character(10) VARCHAR2(10) NOT NULL RMA Number
3 RMA_LINE_NBR Number(5,0) INTEGER NOT NULL RMA Line Number
4 CUST_ADDR_TYPE Character(1) VARCHAR2(1) NOT NULL Customer Address Type
H=Ship To Customer
S=Sold To Customer
5 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

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

Prompt Table: %EDIT_STATE

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

Y/N Table Edit

22 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix
23 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
24 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone Extension
25 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
26 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
27 CUST_NAME Character(40) VARCHAR2(40) NOT NULL Name
28 CNTCT_NAME1 Character(40) VARCHAR2(40) NOT NULL Contact Name1