VCHR_MMT_RQS_HD

(SQL Table)
 Index Back

Voucher Mass Maint Request Hdr

  • Parent Record Of VMMT_REPLCE_TMP VMMT_SEARCH_TMP WM_FLEXSRCH_DTL WM_FLEXSRCH_TMP

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 REQUEST_DT Date(10) DATE NOT NULL Request Date

    Default Value: %Date

    3 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    4 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
    5 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
    6 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

    7 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    8 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

    9 TOTAL_SRCH_LINES Number(5,0) INTEGER NOT NULL Total Search Criteria Lines
    10 TOTAL_RPLC_LINES Number(5,0) INTEGER NOT NULL Total Replace Criteria Lines
    11 RECORD_COUNT Number(7,0) INTEGER NOT NULL Total Found
    12 UPDATE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Meta SQL
    13 WHERE_CLAUSE1 Character(254) VARCHAR2(254) NOT NULL Where Clause
    14 WHERE_CLAUSE2 Character(254) VARCHAR2(254) NOT NULL Where Clause
    15 ACCOUNTING_DT_IND Character(1) VARCHAR2(1) NOT NULL Accounting Date Indicator
    C=Use Current Date
    D=Business Unit Default
    P=Use Payment Date
    S=Use Specific Date
    16 ACCOUNTING_DT_RVRL Date(10) DATE Reversal Accounting Date
    17 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple