CUST_CRED_SRCH

(SQL View)
Index Back

Available Credit Search Rec

ICE 1880238000

SELECT C.SETID , C.CUST_ID , C.NAME1 , C.NAME2 , C.CORPORATE_SETID , C.CORPORATE_CUST_ID , C.PARENT_SETID , C.PARENT_CUST_ID FROM PS_CUSTOMER C WHERE C.BILL_TO_FLG = 'Y' OR (C.SETID = C.CORPORATE_SETID AND C.CUST_ID = C.CORPORATE_CUST_ID AND C.BILL_TO_FLG <> 'Y' )

  • Related Language Record: CUST_VW2_LNG
  • # 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 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: CUST_BI_VW

    3 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    4 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2
    5 CORPORATE_SETID Character(5) VARCHAR2(5) NOT NULL SetID
    6 CORPORATE_CUST_ID Character(15) VARCHAR2(15) NOT NULL Corporate Customer
    7 PARENT_SETID Character(5) VARCHAR2(5) NOT NULL Corporate SetID

    Prompt Table: SP_SETID_NONVW

    8 PARENT_CUST_ID Character(15) VARCHAR2(15) NOT NULL Corporate Cust ID

    Prompt Table: CUST_PARENT_VW