COPY_PO_VW

(SQL View)
 Index Back

PO Header View

Date Initials Reference # Description 09/07/2009 SF 1916627002 Added a related language record COPY_PO_VW_L.

SELECT A.business_unit , A.PO_ID , A.po_status , A.vendor_setid , A.VENDOR_ID , A.VNDR_LOC , B.vendor_name_short , A.buyer_id , A.origin , A.disp_method , A.pymnt_terms_cd , A.cntct_seq_num , A.address_seq_num , A.sales_cntct_seq_n , A.bill_location , A.tax_exempt , A.tax_exempt_id , A.currency_cd , A.rt_type , A.po_ref , A.PO_DT , A.MATCH_CNTRL_ID , A.CURRENCY_CD_BASE , A.PRICE_SETID , A.PRICE_VENDOR , A.PRICE_LOC , A.RATE_MULT , A.RATE_DIV FROM PS_PO_HDR a , PS_VENDOR b WHERE a.VENDOR_SETID = b.SETID AND a.VENDOR_ID = b.VENDOR_ID

  • Related Language Record: COPY_PO_VW_L

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_PM_NONVW

    2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
    3 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
    4 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Default Value: VENDOR_SHRT_VW.VENDOR_ID

    Prompt Table: VENDOR_PO_VW

    6 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    7 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    8 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

    Prompt Table: BUYER_ACTIVE_VW

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

    Prompt Table: ORIGIN_PO

    10 DISP_METHOD Character(3) VARCHAR2(3) NOT NULL Dispatch Method
    EDX=Electronic Document Exchange
    EML=Email Dispatch
    FAX=Fax Transmission
    PHN=Phone Dispatch
    PRN=Print
    11 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
    12 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number
    13 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
    14 SALES_CNTCT_SEQ_N Number(3,0) SMALLINT NOT NULL Salesperson
    15 BILL_LOCATION Character(10) VARCHAR2(10) NOT NULL Billing Location
    16 TAX_EXEMPT Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag
    17 TAX_EXEMPT_ID Character(30) VARCHAR2(30) NOT NULL Tax Exempt ID
    18 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    19 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
    20 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.
    21 PO_DT Date(10) DATE Date
    22 MATCH_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Match Rule
    23 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
    24 PRICE_SETID Character(5) VARCHAR2(5) NOT NULL Price From Vendor SetID
    25 PRICE_VENDOR Character(10) VARCHAR2(10) NOT NULL Price Vendor ID
    26 PRICE_LOC Character(10) VARCHAR2(10) NOT NULL Price from Location
    27 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
    28 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor