BI_ADDRCNTCT_VW

(SQL View)
 Index Back

Customer Address Eff dt vw

Customer Address Eff dt vw

SELECT S.SETID , S.CUST_ID , S.ADDRESS_SEQ_NUM , A.EFFDT , A.EFF_STATUS , S.DESCR , S.BILL_TO_ADDR , S.SHIP_TO_ADDR , S.SOLD_TO_ADDR , S.CRSPD_TO_ADDR , S.BROKER_ADDR , S.INDIRECT_ADDR , S.RFID_ENABLED , A.ALT_NAME1 , A.ALT_NAME2 , A.LANGUAGE_CD , A.TAX_CD , %subrec(ADDRESS_SBR,A) , %subrec(BUS_PHONE_SBR,A) , A.URL_LONG FROM %Table(CUST_ADDR_SEQ) S , %Table(CUST_ADDRESS) A WHERE S.BILL_TO_ADDR = 'Y' AND %Join(COMMON_KEYS, CUST_ADDR_SEQ S, CUST_ADDRESS A) AND %EffdtCheck(CUST_ADDRESS A2 , A, %CurrentDateIn) AND A.EFF_STATUS = 'A' AND EXISTS ( SELECT 'X' FROM %Table(CUSTOMER) C WHERE %Join(COMMON_KEYS, CUSTOMER C, CUST_ADDR_SEQ S) AND C.CUST_STATUS = 'A' )

  • Parent record: CUST_ADDR_SEQ

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

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    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.

    Prompt Table: CUSTOMER

    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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 BILL_TO_ADDR Character(1) VARCHAR2(1) NOT NULL Bill To Address
    8 SHIP_TO_ADDR Character(1) VARCHAR2(1) NOT NULL Ship To Address
    9 SOLD_TO_ADDR Character(1) VARCHAR2(1) NOT NULL Sold To Address
    10 CRSPD_TO_ADDR Character(1) VARCHAR2(1) NOT NULL Correspondence Address
    11 BROKER_ADDR Character(1) VARCHAR2(1) NOT NULL Broker Address
    12 INDIRECT_ADDR Character(1) VARCHAR2(1) NOT NULL Indirect Customer Address
    13 RFID_ENABLED Character(1) VARCHAR2(1) NOT NULL RFID_ENABLED
    14 ALT_NAME1 Character(40) VARCHAR2(40) NOT NULL Alternate Name 1
    15 ALT_NAME2 Character(40) VARCHAR2(40) NOT NULL Alternate Name 2
    16 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

    Default Value: PSOPTIONS.LANGUAGE_CD

    17 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code

    Prompt Table: TAX_SU_HDR_VW

    18 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    19 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    20 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    21 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    22 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    23 CITY Character(30) VARCHAR2(30) NOT NULL City
    24 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    25 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    26 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat
    WW=Trailer
    27 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    28 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    29 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    30 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    31 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: %EDIT_STATE

    32 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    33 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    34 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    35 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix
    36 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    37 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone Extension
    38 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
    39 URL_LONG Character(130) VARCHAR2(130) NOT NULL URL Long Address