VCHR_APRVL_PARM

(SQL Table)
 Index Back

Voucher Approval Run Control

Voucher Approval Run Control Parameters

  • Parent record: VCHR_APPRVL_RUN

    • # 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: VCHR_APPRVL_RUN.OPRID

    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

    Default Value: VCHR_APPRVL_RUN.RUN_CNTL_ID

    3 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID

    Default Value: VCHR_APPRVL_RUN.REQUEST_ID

    4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_AP_NONVW

    5 ORIGIN_SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    6 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin

    Prompt Table: ORIGIN_AP_VW1

    7 GRP_AP_ID Character(10) VARCHAR2(10) NOT NULL Control Group ID

    Prompt Table: GRP_AP

    8 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

    Prompt Table: SP_SETID_NONVW

    9 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VNDR_ACT_VW

    10 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

    Prompt Table: VCHR_APPRV_LST

    11 VCHR_SRC Character(4) VARCHAR2(4) NOT NULL Voucher Source