AR_STMT_CUST(SQL Table) |
Index Back |
---|---|
Customer Dunning Letter HeaderCustomer 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 |
2 | CRSPD_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Correspondence Customer |
3 | ST_ID_NUM | Number(8,0) | INTEGER NOT NULL | Statement Number |
4 | ASSN_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the operator ID of the person who will enter items in a group. This is used when one person enters the control totals and another person enters the actual transactions. The assigned operator is also the person who processes the group and the person who is shown on group inquiry and processing panels. |
5 | DELIVERY_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Delivery Method
E=Email F=Fax P=Print |
6 | FAX | Character(24) | VARCHAR2(24) NOT NULL | Fax Number |
7 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
8 | PRINTER | Character(20) | VARCHAR2(20) NOT NULL | Printer Specification |