DUNS_NUMBERCCR_DUNS_PLUS4CCR=CCR
EBL=eBill Contact Maintenance
FED=FED
PEN=Pension Customer
FED_CST_MAIN_VW(SQL View) |
Index Back |
|---|---|
FEDREG New Cust Master Info |
| SELECT DUNS_NUMBER , CCR_DUNS_PLUS4 , SOURCE_SYSTEM , %Substring(LEGAL_BUS_NAME, 1, 40) , %Substring(LEGAL_BUS_NAME, 41, 40) , %Substring(LEGAL_BUS_NAME, 81, 40) , ALC , DISBURSING_OFFICE , EXPIRATION_DATE FROM PS_CCR_VNDR_HDR WHERE SOURCE_SYSTEM = 'FED' AND FR_BUS_TYPE IN ('2','3') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DUNS_NUMBER |
Character(9) | VARCHAR2(9) NOT NULL | DUNS Number |
| 2 | CCR_DUNS_PLUS4 |
Character(4) | VARCHAR2(4) NOT NULL | DUNS Suffix |
| 3 | SOURCE_SYSTEM | Character(3) | VARCHAR2(3) NOT NULL |
Source System
CCR=CCR EBL=eBill Contact Maintenance FED=FED PEN=Pension Customer |
| 4 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 5 | NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Name 2 |
| 6 | NAME3 | Character(40) | VARCHAR2(40) NOT NULL | Name 3 |
| 7 | ALC | Character(8) | VARCHAR2(8) NOT NULL | Agency Location Code |
| 8 | DISBURSING_OFFICE | Character(5) | VARCHAR2(5) NOT NULL | Field used by Payables |
| 9 | EXPIRATION_DATE | Date(10) | DATE | Expiration Date |