CUSTTMP_ADDR_VW

(SQL View)
 Index Back

Customer Address Detail

View of Address detail on the customer record for copy function.

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_SBR2, A) , %subrec(BUS_PHONE_SBR, A) , A.PHYSICAL_NATURE , A.VAT_SVC_PERFRM_FLG , A.LAST_EXP_CHK_DTTM , A.URL_LONG FROM PS_CUST_ADDRESS A , PS_CUSTOMER C WHERE %Join(COMMON_KEYS, CUST_ADDRESS A, CUSTOMER C) AND C.CUST_STATUS = 'T'

  • Parent record: CUST_ADDR_SEQ

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Project Template
    3 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    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

    Default Value: PSOPTIONS.LANGUAGE_CD

    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: STATE_TBL

    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 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
    G=Goods
    S=Services
    32 VAT_SVC_PERFRM_FLG Character(1) VARCHAR2(1) NOT NULL Where VAT Services Physically Performed Flag
    1=Ship To Location
    2=Ship From Location
    3=Buyer's Location
    4=Supplier's Location
    33 LAST_EXP_CHK_DTTM DateTime(26) TIMESTAMP Last Date/Time Export Comp Chk
    34 URL_LONG Character(130) VARCHAR2(130) NOT NULL URL Long Address