VCHR_MMT_UPD_VW(SQL View) |
Index Back |
|---|---|
Vchr Mass Maint Updt Search Vw |
| SELECT OPRID , REQUEST_ID , VCHR_MMT_RQST_TYPE , VCHR_MMT_DATA_SRC , DESCR254 , REQUEST_DT , VCHR_MMT_RQST_STAT , PROCESS_INSTANCE FROM PS_VCHR_MMT_RQS_HD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_AP.OPRID Prompt Table: OPR_DEF_TBL_FS |
| 2 | REQUEST_ID |
Character(10) | VARCHAR2(10) NOT NULL | Request ID |
| 3 | VCHR_MMT_RQST_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Request Type
1=Field Value Replacement 2=Voucher Close 3=Voucher UnPost 4=Voucher Delete Default Value: 1 |
| 4 | VCHR_MMT_DATA_SRC |
Character(1) | VARCHAR2(1) NOT NULL |
Voucher Maintenance Source
O=Online Voucher Tables Q=Quick Invoice Tables S=Voucher Staging Tables Default Value: O |
| 5 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 6 | REQUEST_DT |
Date(10) | DATE |
Request Date
Default Value: %Date |
| 7 | VCHR_MMT_RQST_STAT |
Character(1) | VARCHAR2(1) NOT NULL |
Request Status
D=Deleted E=Error N=New Request P=Processed S=Saved (Pending) Default Value: N |
| 8 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |