CRSPD_SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETCS_NONVW
CRSPD_CUST_IDPrompt Table: CRSPD_CUST_D_VW
ST_ID_NUMPrompt Table: STMT_CUST
ARCHIVE_IDB=Bal Fwd
O=Open Item
A=BF Statement Active
I=BF Statement Inactivated
STMT_CNTL_ARCH(SQL Table) |
Index Back |
|---|---|
Statment Control Archive Table |
| # | 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 | ST_ID_NUM |
Number(8,0) | INTEGER NOT NULL |
Statement Number
Prompt Table: STMT_CUST |
| 4 | ARCHIVE_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID |
| 5 | ST_DT | Date(10) | DATE | Specifies the date a statement (Receivables) is generated. This date is maintained by the Statements SQR. |
| 6 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 7 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 8 | ST_ID_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Statement Type
B=Bal Fwd O=Open Item |
| 9 | ST_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Statement Status
A=BF Statement Active I=BF Statement Inactivated |