CUST_CRED_SRCH(SQL View) |
Index Back |
---|---|
Available Credit Search RecICE 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' ) |
# | 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 |