BI_ADDRSEQ_VW

(SQL View)
Index Back

Customer Address Header


SELECT S.CUST_ID , S.SETID , S.ADDRESS_SEQ_NUM , 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 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' )

  • Related Language Record: CUST_ADDRSQ_LNG
  • Parent record: CUSTOMER
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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

    2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    3 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

    Prompt Table: BI_ADDRSEQ_VW

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 BILL_TO_ADDR Character(1) VARCHAR2(1) NOT NULL Bill To Address

    Y/N Table Edit

    Default Value: N

    6 SHIP_TO_ADDR Character(1) VARCHAR2(1) NOT NULL Ship To Address

    Y/N Table Edit

    Default Value: N

    7 SOLD_TO_ADDR Character(1) VARCHAR2(1) NOT NULL Sold To Address

    Y/N Table Edit

    Default Value: N

    8 CRSPD_TO_ADDR Character(1) VARCHAR2(1) NOT NULL Correspondence Address

    Y/N Table Edit

    Default Value: N

    9 BROKER_ADDR Character(1) VARCHAR2(1) NOT NULL Broker Address

    Y/N Table Edit

    Default Value: N

    10 INDIRECT_ADDR Character(1) VARCHAR2(1) NOT NULL Indirect Customer Address

    Y/N Table Edit

    Default Value: N

    11 RFID_ENABLED Character(1) VARCHAR2(1) NOT NULL RFID_ENABLED

    Y/N Table Edit

    Default Value: N