USF_UEIDUSF_EFT_INDUSF_CST_XREF_VW(SQL View) |
Index Back |
|---|---|
Customer Cross Reference |
| SELECT MAX( CASE STD_ID_NUM_QUAL WHEN 'UEI' THEN %TrimSubstr(STD_ID_NUM,1,12) ELSE ' ' END ) , MAX( CASE STD_ID_NUM_QUAL WHEN 'EEI' THEN %TrimSubstr(STD_ID_NUM,1,4) ELSE ' ' END ) , MAX( CASE STD_ID_NUM_QUAL WHEN 'DNS' THEN %TrimSubstr(STD_ID_NUM,1,9) ELSE ' ' END ) , MAX( CASE STD_ID_NUM_QUAL WHEN 'DOD' THEN %TrimSubstr(STD_ID_NUM,1,9) ELSE ' ' END ) , SETID , CUST_ID FROM PS_CUST_ID_NBRS WHERE STD_ID_NUM_QUAL IN ('DNS', 'DP4', 'DOD','UEI','EEI') GROUP BY SETID, CUST_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | USF_UEID |
Character(12) | VARCHAR2(12) NOT NULL | Unique Entity Identifier |
| 2 | USF_EFT_IND |
Character(4) | VARCHAR2(4) NOT NULL | Entity EFT Indicator |
| 3 | DUNS_NUMBER | Character(9) | VARCHAR2(9) NOT NULL | DUNS Number |
| 4 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 5 | CUST_SETID | Character(5) | VARCHAR2(5) NOT NULL | Customer SetID |
| 6 | 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. |