BI_SS_CUSEQ_VW

(SQL View)
 Index Back

Self Serv Address Seq


SELECT CS.CUST_ID , CS.SETID , CS.ADDRESS_SEQ_NUM , CS.DESCR , CS.BILL_TO_ADDR , CS.SHIP_TO_ADDR , CS.SOLD_TO_ADDR , CS.CRSPD_TO_ADDR , CS.BROKER_ADDR , CS.INDIRECT_ADDR , CS.RFID_ENABLED , CS.LAST_MAINT_OPRID , CS.DATE_LAST_MAINT FROM PS_CUST_ADDR_SEQ CS , PS_CUST_ADDRESS CA WHERE CS.SETID = CA.SETID AND CS.CUST_ID = CA.CUST_ID AND CS.ADDRESS_SEQ_NUM = CA.ADDRESS_SEQ_NUM AND CS.BILL_TO_ADDR = 'Y' AND %EffdtCheck(CUST_ADDRESS CB, CA, %CurrentDateIn) AND CA.EFF_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
    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

    12 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
    13 DATE_LAST_MAINT Date(10) DATE Date Last Maintained