SETIDCUST_IDMEMRS_XS_CSACMPMEM(SQL View) |
Index Back |
|---|
| SELECT A.SETID , A.CUST_ID , %TrimSubstr(A.SETID,1,5) %Concat '' %Concat %TrimSubstr(A.CUST_ID,1,15) AS CUSTID , %TrimSubstr(B.ACCOMPLISHMENT,1,8) AS MEM , CASE WHEN B.WEIGHT_POINTS = 0 THEN 'Y' ELSE 'N' END AS REQ , CASE WHEN B.WEIGHT_POINTS = 0 THEN %TrimSubstr(B.ACCOMPLISHMENT,1,8) ELSE ' ' END AS RMEM FROM %Table(CUSTOMER) A , %Table(FO_CUST_ACMP_MB) B WHERE A.SETID = B.SETID AND A.CUST_ID = B.CUST_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 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. |
| 3 | SOID | Character(29) | VARCHAR2(29) NOT NULL | Service Order Line Key |
| 4 | MEM |
Character(32) | VARCHAR2(32) NOT NULL | Membership |
| 5 | REQ | Character(1) | VARCHAR2(1) NOT NULL | Purchasing |
| 6 | RMEM | Character(32) | VARCHAR2(32) NOT NULL | Required Membership |