DUN_CUST(SQL Table) |
Index Back |
|---|---|
Customer Dunning Letter Header |
| # | 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 | CRSPD_CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Correspondence Customer
Prompt Table: CRSPD_CUST_D_VW |
| 3 | DUN_ID_NUM |
Number(8,0) | INTEGER NOT NULL |
Dunning Number
Prompt Table: DUN_CUST |
| 4 | DUN_ID | Character(5) | VARCHAR2(5) NOT NULL | Dunning ID |
| 5 | DUN_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Dunning Sequence Number |
| 6 | LC_AMT | Number(6,2) | DECIMAL(5,2) NOT NULL | Dunning Letter Charge Amount |
| 7 | LETTER_CD | Character(3) | VARCHAR2(3) NOT NULL |
Specifies a type of correspondence used for follow-up letters or dunning notices. A letter code is associated with a customizable template to facilitate form letters.
Prompt Table: LETTER_CD_TBL |
| 8 | DUN_DT | Date(10) | DATE | Specifies the date that a dunning letter is sent. This date is generated by the Dunning SQR. |
| 9 | CNTCT_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Contact Sequence Number |
| 10 | MODIFIED_DT | Date(10) | DATE |
Date Last Modification
Default Value: %date |
| 11 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW |
| 12 | DELETE_LETTER | Character(1) | VARCHAR2(1) NOT NULL |
Used as a push button to allow deleting a dunning letter on line.
M=Letter Modified N=No Delete Letter Y=Letter Deleted Y/N Table Edit Default Value: N |
| 13 | DUN_TEXT | Long Character(1000) | VARCHAR2(1000) | Dunning letter text |