EB_STMT_CUST(SQL Table) |
Index Back |
|---|---|
Customer Statement Header |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETCS_NONVW |
|
| 2 | Character(15) | VARCHAR2(15) NOT NULL |
Correspondence Customer
Prompt Table: CRSPD_CUST_D_VW |
|
| 3 | Number(8,0) | INTEGER NOT NULL |
Statement Number
Prompt Table: STMT_CUST |
|
| 4 | ST_DT | Date(10) | DATE | Specifies the date a statement (Receivables) is generated. This date is maintained by the Statements SQR. |