SETIDVENDOR_IDADDRESS_SEQ_NUMA=Active
I=Inactive
Default Value: A
FO_VEND_ADDR_VW(SQL View) |
Index Back |
|---|---|
Supplier AddressSupplier Address |
| SELECT A.setid , A.vendor_id , A.address_seq_num , A.eff_status , A.name1 , A.name2 , A.emailid FROM PS_VENDOR_ADDR A WHERE %EffdtCheck(VENDOR_ADDR B, A, %currentdatein) AND A.eff_status = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | ADDRESS_SEQ_NUM |
Number(5,0) | INTEGER NOT NULL | Address Sequence Number |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 6 | NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Name 2 |
| 7 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |