CRSPD_SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETCS_NONVW
BUSINESS_UNITDUN_ID_NUMPrompt Table: DUNID_SEARCH_VW
CRSPD_CUST_IDPrompt Table: CRSPD_CUST_D_VW
DUN_SEARCH_VW(SQL View) |
Index Back |
|---|---|
DUN_SEARCH_VW |
| SELECT CRSPD_SETID , BUSINESS_UNIT , DUN_ID_NUM , CRSPD_CUST_ID FROM PS_AR33000_TMP WHERE PRINT_COMP = 'N' GROUP BY CRSPD_SETID, BUSINESS_UNIT, DUN_ID_NUM, CRSPD_CUST_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CRSPD_SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETCS_NONVW |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | DUN_ID_NUM |
Number(8,0) | INTEGER NOT NULL |
Dunning Number
Prompt Table: DUNID_SEARCH_VW |
| 4 | CRSPD_CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Correspondence Customer
Prompt Table: CRSPD_CUST_D_VW |