CRSPD_SETIDCRSPD_CUST_IDDUN_ID_NUMBAL_CURRENCYADDRESS_SEQ_NUMDUN_COMPCUR_VW(SQL View) |
Index Back |
|---|---|
Original Dunning by CurrencyCompares current item balances for a customer to the item balances on the dunning letter. |
| select distinct a.crspd_setid, a.crspd_cust_id, a.dun_id_num, a.bal_currency, a.address_seq_num from PS_DUN_CUST_DTL a |
| # | 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 | BAL_CURRENCY |
Character(3) | VARCHAR2(3) NOT NULL | Currency Code - Bal Amount |
| 5 | ADDRESS_SEQ_NUM |
Number(5,0) | INTEGER NOT NULL | Address Sequence Number |