REMIT_ADDR_VW

(SQL View)
 Index Back

Supplier Address View


select a.setid, a.vendor_id, b.address_seq_num, a.name1, a.name2, %subrec(address_sbr,b), b.name1, b.name2 from PS_VENDOR_ADDR b, ps_vendor a where a.vendor_id = b.vendor_id and a.setid = b.setid and b.eff_status = 'A' and b.effdt = (select max(c.effdt) from PS_VENDOR_ADDR c where c.effdt <= %currentdatein and c.eff_status = 'A' and c.setid = a.setid and c.vendor_id = a.vendor_id and b.address_seq_num = c.address_seq_num)

  • Related Language Record: REMIT_ADD_LG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID
    2 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
    3 REMIT_ADDR_SEQ_NUM Number(5,0) INTEGER NOT NULL Remitting Location
    4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    5 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2
    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: %EDIT_STATE

    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 ADDR_NAME1 Character(40) VARCHAR2(40) NOT NULL Address Name 1
    24 ADDR_NAME2 Character(40) VARCHAR2(40) NOT NULL Address Name 2