AP_WC_LC_RUN_VW

(SQL View)
 Index Back

Landed Cost Vchr Sel View


SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.VENDOR_SETID , A.VENDOR_ID , B.NAME1 , B.VENDOR_NAME_SHORT , A.INVOICE_ID , A.INVOICE_DT , A.ORIGIN , A.GRP_AP_ID , A.OPRID_LAST_UPDT , A.LAST_UPDATE_DTTM FROM PS_VOUCHER A , PS_VENDOR B WHERE A.ENTRY_STATUS IN ('O', 'P', 'S') AND A.CLOSE_STATUS = 'O' AND A.POST_STATUS_AP = 'P' AND ((A.MATCH_STATUS_VCHR = 'M') OR (A.VOUCHER_TYPE = 'T')) AND A.LC_EXTRCT_STATUS = 'N' AND A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID

  • Related Language Record: AP_WC_LC_RUN_LV

    • # 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_AP_NONVW

    2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

    Prompt Table: VCHR_FS

    3 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Default Value: VENDOR_SHRT_VW.VENDOR_ID

    Prompt Table: %EDITTABLE20

    5 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    6 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    7 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
    8 INVOICE_DT Date(10) DATE Invoice Date
    9 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
    10 GRP_AP_ID Character(10) VARCHAR2(10) NOT NULL Control Group ID
    11 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update

    Default Value: OPR_DEF_TBL_AP.OPRID

    12 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

    Default Value: %Datetime