PV_RUN_CTL_TRNS

(SQL Table)
 Index Back

PV Transact Run Control

  • Parent Record Of PV_RNCTL_TRN_VW

    • # 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 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_PM_NONVW

    4 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit

    Prompt Table: SP_BU_PM_NONVW

    5 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit

    Prompt Table: SP_BU_PM_NONVW

    6 BUSINESS_UNIT_REQ Character(5) VARCHAR2(5) NOT NULL Requesting Business Unit

    Prompt Table: SP_BU_PM_NONVW

    7 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

    Prompt Table: BUYER_TBL

    8 FROMDATE Date(10) DATE From Date
    9 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin

    Prompt Table: ORIGIN_PO

    10 ORIGIN_PO Character(3) VARCHAR2(3) NOT NULL Origin

    Prompt Table: ORIGIN_PO

    11 ORIGIN_RECV Character(3) VARCHAR2(3) NOT NULL Origin

    Prompt Table: ORIGIN_PO

    12 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

    Prompt Table: PO_HDR

    13 PO_ID_FROM Character(10) VARCHAR2(10) NOT NULL From/To

    Prompt Table: PO_HDR

    14 PO_ID_TO Character(10) VARCHAR2(10) NOT NULL PO_ID in a range

    Prompt Table: PO_HDR

    15 PO_STATUS Character(2) VARCHAR2(2) NOT NULL PO Status
    A=Approved
    C=Complete
    D=Dispatched
    DA=Denied
    I=Initial
    LD=Line Denied
    O=Open
    PA=Pending Approval/Approved
    PX=Pending Cancel
    X=Canceled
    16 PV_BUYER_ID_PO Character(30) VARCHAR2(30) NOT NULL Buyer Name

    Prompt Table: BUYER_TBL

    17 PV_BUYER_ID_RECV Character(30) VARCHAR2(30) NOT NULL Buyer Name

    Prompt Table: BUYER_TBL_VW

    18 PV_BUYER_ID_REQ Character(30) VARCHAR2(30) NOT NULL Buyer Name

    Prompt Table: BUYER_TBL

    19 PV_DBLINK Character(1) VARCHAR2(1) NOT NULL Link Type
    E=FDM
    H=HRMS
    O=Other

    Default Value: E

    20 PV_DBLINK_PO Character(1) VARCHAR2(1) NOT NULL Link Type
    E=FDM
    H=HRMS
    O=Other
    21 PV_DBLINK_RECV Character(1) VARCHAR2(1) NOT NULL Link Type
    E=FDM
    H=HRMS
    O=Other
    22 PV_DBLINK_REQ Character(1) VARCHAR2(1) NOT NULL Link Type
    E=FDM
    H=HRMS
    O=Other
    23 PV_DBLINK_VCHR Character(1) VARCHAR2(1) NOT NULL Link Type
    E=FDM
    H=HRMS
    O=Other
    24 PV_FROMDATE_PO Date(10) DATE From Date
    25 PV_FROMDATE_RECV Date(10) DATE From Date
    26 PV_FROMDATE_REQ Date(10) DATE From Date
    27 PV_ORIGIN_REQ Character(3) VARCHAR2(3) NOT NULL Origin

    Prompt Table: ORIGIN_PO

    28 PV_PO_OPTN Character(1) VARCHAR2(1) NOT NULL Process Purchase Orders?

    Y/N Table Edit

    Default Value: N

    29 PV_PRCS_TR_TYPE Character(1) VARCHAR2(1) NOT NULL Transaction Type 1 = Purchase Orders 2 = Requisitions 3 = Receipts
    1=PO
    2=Reqs
    3=Receipts
    4=Vouchers

    Default Value: 1

    30 PV_RECV_OPTN Character(1) VARCHAR2(1) NOT NULL Process Receipts?

    Y/N Table Edit

    Default Value: N

    31 PV_RECVR_ID_FROM Character(10) VARCHAR2(10) NOT NULL Receipt Number

    Prompt Table: RECV_HDR

    32 PV_RECVR_ID_TO Character(10) VARCHAR2(10) NOT NULL Receipt Number

    Prompt Table: RECV_HDR

    33 PV_REQ_OPTN Character(1) VARCHAR2(1) NOT NULL Process Requisitions?

    Y/N Table Edit

    Default Value: N

    34 PV_THRU_DT_PO Date(10) DATE Through Date
    35 PV_THRU_DT_RECV Date(10) DATE Through Date
    36 PV_THRU_DT_REQ Date(10) DATE Through Date
    37 PV_TR_ERP_PO Character(1) VARCHAR2(1) NOT NULL Bring new POs from Backbone

    Y/N Table Edit

    Default Value: Y

    38 PV_TR_ERP_DSP_PO Character(1) VARCHAR2(1) NOT NULL Bring dispatched POs from BB
    39 PV_TR_ERP_REQ Character(1) VARCHAR2(1) NOT NULL Update Sourced Reqs from ERP

    Y/N Table Edit

    Default Value: Y

    40 PV_VCHR_OPTN Character(1) VARCHAR2(1) NOT NULL Process Vouchers?

    Y/N Table Edit

    Default Value: N

    41 PV_VENDOR_ID_PO Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VENDOR_PO_VW

    42 PV_VENDOR_ID_RECV Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VENDOR_PO_VW

    43 PV_VENDOR_ID_REQ Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VENDOR_PO_VW

    44 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number

    Prompt Table: RECV_HDR

    45 RECV_STATUS Character(1) VARCHAR2(1) NOT NULL Receipt Status
    C=Closed Receipt
    H=Hold Receipt
    M=Moved to Destination
    N=PO Not Received
    O=Open
    P=PO Partially Received
    R=Fully Received
    X=Canceled
    46 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID

    Prompt Table: REQ_HDR

    47 REQ_ID_FROM Character(10) VARCHAR2(10) NOT NULL Requisition ID From

    Prompt Table: REQ_HDR

    48 REQ_ID_TO Character(10) VARCHAR2(10) NOT NULL Requisition ID To

    Prompt Table: REQ_HDR

    49 REQ_STATUS Character(4) VARCHAR2(4) NOT NULL Req status
    A=Approved
    C=Complete
    D=Denied
    I=Initial
    LA=Line Approved
    O=Open
    P=Pending Approval
    V=Preview
    X=Canceled
    50 SERVER Character(254) VARCHAR2(254) NOT NULL Server Address
    51 THRU_DATE Date(10) DATE Through Date
    52 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VENDOR_PO_VW