CRSPD_SETIDCRSPD_CUST_IDDUN_ID_NUMDUN_SRCH_VW(SQL View) |
Index Back |
|---|---|
Dunning Delete Search View |
| select distinct crspd_setid, crspd_cust_id, dun_id_num, dun_dt, address_seq_num from PS_AR33000_TMP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CRSPD_SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CRSPD_CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Correspondence Customer |
| 3 | DUN_ID_NUM |
Number(8,0) | INTEGER NOT NULL | Dunning Number |
| 4 | DUN_DT | Date(10) | DATE | Specifies the date that a dunning letter is sent. This date is generated by the Dunning SQR. |
| 5 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Address Sequence Number |