CNTCT_CADDR_VW

(SQL View)
Index Back

Contact customer address

Contact customer address

SELECT a.setid , a.cust_id , a.address_seq_num , a.effdt , a.eff_status , a.alt_name1 , a.alt_name2 , a.language_cd , a.tax_cd , %subrec(address_sbr, a) , %subrec(bus_phone_sbr, a) , c.name1 FROM PS_CUST_ADDRESS a , ps_customer c WHERE a.setid = c.setid AND a.cust_id = c.cust_id

  • Parent record: CUST_ADDR_SEQ
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
    3 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
    4 EFFDT Date(10) DATE Effective Date
    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    6 ALT_NAME1 Character(40) VARCHAR2(40) NOT NULL Alternate Name 1
    7 ALT_NAME2 Character(40) VARCHAR2(40) NOT NULL Alternate Name 2
    8 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    9 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code
    10 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

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

    Prompt Table: %EDIT_STATE

    24 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    25 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    26 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    27 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix
    28 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    29 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone Extension
    30 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
    31 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1