PO_SPND_DSP_LVW

(SQL View)
 Index Back

PO Spend Distrib View

PO Spend History Distribution View

SELECT B.OPRID , A.REPORT_ENTITY , A.BUYER_ID , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.BUSINESS_UNIT , A.PO_ID , A.LINE_NBR , A.SCHED_NBR , A.DST_ACCT_TYPE , A.DISTRIB_LINE_NUM , A.FISCAL_YEAR , A.ACCOUNTING_PERIOD , A.CURRENCY_CD , E.LANGUAGE_CD , E.OPRDEFNDESC , G.VENDOR_NAME_SHORT , F.OPRDEFNDESC FROM PS_PO_SPEND_DIST A , PS_OPR_DEF_RPT_VW B , PS_PO_EVT_THRESH C , PS_PO_TILE_USER D , PSOPRDEFN_LANG E , PSOPRDEFN_LANG F ,PS_VENDOR_LANG G WHERE A.REPORT_ENTITY = B.REPORT_ENTITY AND A.REPORT_ENTITY = C.REPORT_ENTITY AND B.OPRID = D.OPRID AND D.REPORT_ENTITY = B.REPORT_ENTITY AND E.OPRID = A.BUYER_ID AND F.OPRID = A.REQUESTOR_ID AND G.SETID = A.VENDOR_SETID AND G.VENDOR_ID = A.VENDOR_ID AND C.TILE_EVENT_ID = 'POBCKVOL' AND D.TILE_ID = 'SWL' AND A.DAYS_AGED >= C.L1_THRESH_DAYS - D.DAYS_POBACKORD AND A.BACKORDER_AMT > 0

  • Related Language Record for PO_SPND_DSUP_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 REPORT_ENTITY Character(5) VARCHAR2(5) NOT NULL Reporting Entity ID
    3 PO_BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
    4 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    6 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    8 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
    9 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
    10 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
    11 DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment

    Default Value: DST

    12 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line

    Default Value: 1

    13 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
    14 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
    15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    16 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    17 BUYER_NAME Character(30) VARCHAR2(30) NOT NULL Buyer Desc
    18 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    19 PO_REQUESTOR_NAME Character(50) VARCHAR2(50) NOT NULL Requestor