PV_RNCTL_TRN_VW

(SQL View)
 Index Back

PV Transact Run Control


SELECT OPRID , RUN_CNTL_ID , PV_PRCS_TR_TYPE , PV_REQ_OPTN , PV_PO_OPTN , PV_RECV_OPTN , PV_VCHR_OPTN , PV_DBLINK , PV_DBLINK_REQ , PV_DBLINK_PO , PV_DBLINK_RECV , PV_DBLINK_VCHR , SERVER , BUSINESS_UNIT , BUSINESS_UNIT_REQ , BUSINESS_UNIT_PO , BUSINESS_UNIT_RECV , PO_ID , PO_ID_FROM , PO_ID_TO , PO_STATUS , FROMDATE , PV_FROMDATE_REQ , PV_FROMDATE_PO , PV_FROMDATE_RECV , THRU_DATE , PV_THRU_DT_REQ , PV_THRU_DT_PO , PV_THRU_DT_RECV , VENDOR_ID , PV_VENDOR_ID_REQ , PV_VENDOR_ID_PO , PV_VENDOR_ID_RECV , BUYER_ID , PV_BUYER_ID_REQ , PV_BUYER_ID_PO , PV_BUYER_ID_RECV , ORIGIN , PV_ORIGIN_REQ , ORIGIN_PO , ORIGIN_RECV , RECEIVER_ID , PV_RECVR_ID_FROM , PV_RECVR_ID_TO , RECV_STATUS , REQ_ID , REQ_ID_FROM , REQ_ID_TO , REQ_STATUS , PV_TR_ERP_PO , PV_TR_ERP_REQ FROM PS_PV_RUN_CTL_TRNS

  • Parent record: PV_RUN_CTL_TRNS

    • # 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 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
    4 PV_REQ_OPTN Character(1) VARCHAR2(1) NOT NULL Process Requisitions?

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Default Value: E

    9 PV_DBLINK_REQ Character(1) VARCHAR2(1) NOT NULL Link Type
    E=FDM
    H=HRMS
    O=Other
    10 PV_DBLINK_PO Character(1) VARCHAR2(1) NOT NULL Link Type
    E=FDM
    H=HRMS
    O=Other
    11 PV_DBLINK_RECV Character(1) VARCHAR2(1) NOT NULL Link Type
    E=FDM
    H=HRMS
    O=Other
    12 PV_DBLINK_VCHR Character(1) VARCHAR2(1) NOT NULL Link Type
    E=FDM
    H=HRMS
    O=Other
    13 SERVER Character(254) VARCHAR2(254) NOT NULL Server Address
    14 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_PM_NONVW

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

    Prompt Table: SP_BU_PM_NONVW

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

    Prompt Table: SP_BU_PM_NONVW

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

    Prompt Table: SP_BU_PM_NONVW

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

    Prompt Table: PO_HDR

    19 PO_ID_FROM Character(10) VARCHAR2(10) NOT NULL From/To
    20 PO_ID_TO Character(10) VARCHAR2(10) NOT NULL PO_ID in a range
    21 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
    22 FROMDATE Date(10) DATE From Date
    23 PV_FROMDATE_REQ Date(10) DATE From Date
    24 PV_FROMDATE_PO Date(10) DATE From Date
    25 PV_FROMDATE_RECV Date(10) DATE From Date
    26 THRU_DATE Date(10) DATE Through Date
    27 PV_THRU_DT_REQ Date(10) DATE Through Date
    28 PV_THRU_DT_PO Date(10) DATE Through Date
    29 PV_THRU_DT_RECV Date(10) DATE Through Date
    30 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VENDOR_PO_VW

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

    Prompt Table: VENDOR_PO_VW

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

    Prompt Table: VENDOR_PO_VW

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

    Prompt Table: VENDOR_PO_VW

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

    Prompt Table: BUYER_TBL

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

    Prompt Table: BUYER_TBL

    36 PV_BUYER_ID_PO Character(30) VARCHAR2(30) NOT NULL Buyer Name

    Prompt Table: BUYER_TBL

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

    Prompt Table: BUYER_TBL

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

    Prompt Table: ORIGIN_PO

    39 PV_ORIGIN_REQ Character(3) VARCHAR2(3) NOT NULL Origin

    Prompt Table: ORIGIN_PO

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

    Prompt Table: ORIGIN_PO

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

    Prompt Table: ORIGIN_PO

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

    Prompt Table: RECV_HDR

    43 PV_RECVR_ID_FROM Character(10) VARCHAR2(10) NOT NULL Receipt Number
    44 PV_RECVR_ID_TO Character(10) VARCHAR2(10) NOT NULL Receipt Number
    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
    48 REQ_ID_TO Character(10) VARCHAR2(10) NOT NULL Requisition ID To
    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 PV_TR_ERP_PO Character(1) VARCHAR2(1) NOT NULL Bring new POs from Backbone

    Y/N Table Edit

    Default Value: Y

    51 PV_TR_ERP_REQ Character(1) VARCHAR2(1) NOT NULL Update Sourced Reqs from ERP

    Y/N Table Edit

    Default Value: Y