PO_SPND_DSUP_VW

(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 , A.CATEGORY_ID , A.BACKORDER_AMT , A.BUYER_DESCR , A.NAME1 , A.PO_DT , A.ITM_SETID , A.INV_ITEM_ID , A.DESCR254_MIXED , A.CATEGORY_CD , A.DUE_DT , A.SHIPTO_ID , A.SHIPTO_SETID , A.HOLD_STATUS , A.BUDGET_HDR_STATUS , A.PO_REF , A.DEPTID , A.DEPTID_SETID , A.REQUESTOR_ID , A.REQUESTOR_NAME , A.DAYS_AGED_CHAR , A.REQ_ID , A.MONTH_CHAR ,'DPO' FROM PS_PO_SPEND_DIST A , PS_OPR_DEF_RPT_VW B , PS_PO_EVT_THRESH C , PS_PO_TILE_USER D 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 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: PO_SPND_DSP_LVW
  • # 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 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
    17 PO_BACKORDER_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Backorder Amount
    18 BUYER_NAME Character(30) VARCHAR2(30) NOT NULL Buyer Desc
    19 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    20 PO_DT Date(10) DATE Date
    21 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
    22 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    23 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
    24 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code
    25 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
    26 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
    27 SHIPTO_SETID Character(5) VARCHAR2(5) NOT NULL ShipTo SetID
    28 HOLD_STATUS Character(1) VARCHAR2(1) NOT NULL Hold From Further Processing

    Y/N Table Edit

    Default Value: N

    29 BUDGET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Header Status
    E=Error in Budget Check
    I=Document In Processing
    N=Not Budget Checked
    P=Provisionally Valid
    V=Valid
    30 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.
    31 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    32 DEPTID_SETID Character(5) VARCHAR2(5) NOT NULL Department SetID
    33 PO_REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
    34 PO_REQUESTOR_NAME Character(50) VARCHAR2(50) NOT NULL Requestor
    35 DAYS_AGED_CHAR Character(14) VARCHAR2(14) NOT NULL Days Aged
    36 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
    37 PO_PERIOD_YEAR Character(15) VARCHAR2(15) NOT NULL Period/Year
    38 PRODSRCID Character(4) VARCHAR2(4) NOT NULL Chartfield Security: Source Product
    DBI=Billing
    DCM=Cost Management
    DIN=Inventory
    DMI=Mobile Inventory
    DOM=Order Management
    DPO=Purchasing
    DPV=eProcurement
    DSP=Service Procurement
    FAM=Asset Management
    FAP=Payables
    FAR=Receivables
    FCA=Contracts
    FEX=Expenses
    FGL=General Ledger
    FGM=Grants Management
    FPC=Project Costing
    FTR=Treasury
    KK=Commitment Control