PYMNT_VCHR_VWLG

(SQL View)
Index Back

Pymnt Vchr Vw Lg


SELECT a.business_unit , a.voucher_id , a.remit_setid , a.remit_vendor , a.vndr_loc , a.remit_addr_seq_num , d.language_cd , %subrec(address_sbr,b) , d.name1 , d.name2 FROM ps_pymnt_vchr_xref a , PS_VENDOR_ADDR b , ps_vendor c , ps_vendor_lang d WHERE a.remit_setid = b.setid AND a.remit_vendor = b.vendor_id AND a.remit_addr_seq_num = b.address_seq_num AND b.effdt = ( SELECT MAX(b1.effdt) FROM PS_VENDOR_ADDR b1 WHERE b.setid = b1.setid AND b.vendor_id = b1.vendor_id AND b.address_seq_num = b1.address_seq_num AND b1.eff_status = 'A' AND b1.effdt <= %CurrentDateIn) AND a.remit_setid = c.setid AND a.remit_vendor = c.vendor_id AND c.setid = d.setid AND c.vendor_id = d.vendor_id

  • Related Language Record for PYMNT_VCHRFL_VW PYMNT_VCHR_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
    3 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID
    4 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
    5 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    6 REMIT_ADDR_SEQ_NUM Number(5,0) INTEGER NOT NULL Remitting Location
    7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

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

    Prompt Table: STATE_TBL

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

    Y/N Table Edit

    25 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    26 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2