EM_VCHR_DISP_LG

(SQL View)
Index Back

Voucher Display RLR


SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , D.EFFDT , CL.LANGUAGE_CD , CL.NAME1 , %subrec(address_sbr2,DL) , EL.DESCR , %subrec(addr_dsply_sbr,EL) , HL.DESCR FROM PS_VOUCHER A , PS_VENDOR C , PS_VENDOR_LANG CL , PS_VENDOR_ADDR D , PS_VENDOR_ADDR_LNG DL , PS_AP_BU_ADDR_VW E , PS_AP_BU_ADDRVW_LG EL , PS_CURR_TXN_VW H , PS_CURR_TXN_VW_LG HL , PS_VENDOR_LOC B , PS_PYMNT_VCHR_XREF F WHERE B.SETID = C.SETID AND B.VENDOR_ID = C.VENDOR_ID AND C.SETID = CL.SETID AND C.VENDOR_ID = CL.VENDOR_ID AND C.SETID = D.SETID AND C.VENDOR_ID = D.VENDOR_ID AND B.PRIM_ADDR_SEQ_NUM = D.ADDRESS_SEQ_NUM AND D.EFFDT = ( SELECT MAX(D_ED.EFFDT) FROM PS_VENDOR_ADDR D_ED WHERE D.SETID = D_ED.SETID AND D.VENDOR_ID = D_ED.VENDOR_ID AND D.ADDRESS_SEQ_NUM = D_ED.ADDRESS_SEQ_NUM AND D_ED.EFFDT <= %CurrentDateIn ) AND D.SETID = DL.SETID AND D.VENDOR_ID = DL.VENDOR_ID AND D.ADDRESS_SEQ_NUM = DL.ADDRESS_SEQ_NUM AND D.EFFDT = DL.EFFDT AND A.BUSINESS_UNIT = E.BUSINESS_UNIT AND E.BUSINESS_UNIT = EL.BUSINESS_UNIT AND H.TXN_CURRENCY_CD = A.TXN_CURRENCY_CD AND H.EFFDT = ( SELECT MAX(H_ED.EFFDT) FROM PS_CURR_TXN_VW H_ED WHERE H.TXN_CURRENCY_CD = H_ED.TXN_CURRENCY_CD AND H_ED.EFFDT <= %CurrentDateIn) AND H.TXN_CURRENCY_CD = HL.TXN_CURRENCY_CD AND H.EFFDT = HL.EFFDT AND B.SETID = A.VENDOR_SETID AND B.VENDOR_ID = A.VENDOR_ID AND B.VNDR_LOC = A.VNDR_LOC AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_VENDOR_LOC B_ED WHERE B.SETID = B_ED.SETID AND B.VENDOR_ID = B_ED.VENDOR_ID AND B.VNDR_LOC = B_ED.VNDR_LOC AND B_ED.EFFDT <= %CurrentDateIn) AND A.BUSINESS_UNIT = F.BUSINESS_UNIT AND A.VOUCHER_ID = F.VOUCHER_ID AND F.PYMNT_CNT = 1

  • Related Language Record for EM_VCHR_QV_DISP EM_VOUCHER_DISP
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: BUS_UNIT_TBL_AP

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

    Default Value: NEXT

    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    6 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    7 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    8 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    9 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    10 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    11 CITY Character(30) VARCHAR2(30) NOT NULL City
    12 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    13 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    14 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat
    WW=Trailer
    15 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    16 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    17 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    18 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    19 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    20 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    21 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    22 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    23 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    24 ADDRESS1_SHIPTO Character(55) VARCHAR2(55) NOT NULL Ship to Address Line 1
    25 ADDRESS2_SHIPTO Character(55) VARCHAR2(55) NOT NULL Ship To Address Line 2
    26 ADDRESS3_SHIPTO Character(55) VARCHAR2(55) NOT NULL Ship To Address Line 3
    27 ADDRESS4_SHIPTO Character(55) VARCHAR2(55) NOT NULL Ship To Address Line 4
    28 CITY_SHIPTO Character(30) VARCHAR2(30) NOT NULL Ship To City
    29 NUM1_OTHER Character(6) VARCHAR2(6) NOT NULL Number 1 Other
    30 NUM2_OTHER Character(6) VARCHAR2(6) NOT NULL Number 2 Other
    31 HOUSE_TYPE_OTHER Character(2) VARCHAR2(2) NOT NULL House Type Other
    AB=House Boat Reference
    WW=House Trailer Reference
    32 IN_CITY_LMT_OTHER Character(1) VARCHAR2(1) NOT NULL In City Limit Other
    33 COUNTY_OTHER Character(30) VARCHAR2(30) NOT NULL County Other
    34 STATE_SHIPTO Character(6) VARCHAR2(6) NOT NULL Ship to State
    35 GEO_CODE_OTHER Character(11) VARCHAR2(11) NOT NULL Geo Code Other
    36 POSTAL_SHIPTO Character(12) VARCHAR2(12) NOT NULL Ship to Postal Code
    37 COUNTRY_SHIPTO Character(3) VARCHAR2(3) NOT NULL Ship to Country
    38 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr