VNDR_HLOC_VW(SQL View) |
Index Back |
|---|---|
Current supplier location.Used as part of hover-over pages for purchasing. |
| SELECT L.SETID , L.VNDR_LOC , L.VENDOR_ID , L.REMIT_SETID , L.REMIT_VENDOR , L.REMIT_LOC , L.REMIT_ADDR_SEQ_NUM , L.ADDR_SEQ_NUM_ORDR , L.RETURN_VENDOR , L.RET_ADDR_SEQ_NUM FROM PS_VENDOR_LOC L WHERE L.EFF_STATUS = 'A' AND L.EFFDT = ( SELECT MAX(M.EFFDT) FROM PS_VENDOR_LOC M WHERE M.SETID = L.SETID AND M.VENDOR_ID = L.VENDOR_ID AND M.VNDR_LOC = L.VNDR_LOC AND M.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | VNDR_LOC |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 3 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 4 | REMIT_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Remit SetID
Prompt Table: SETID_TBL |
| 5 | REMIT_VENDOR | Character(10) | VARCHAR2(10) NOT NULL |
Remit Vendor
Prompt Table: VNDR_RETURN_VW |
| 6 | REMIT_LOC | Character(10) | VARCHAR2(10) NOT NULL |
Remit to Location
Prompt Table: VNDR_REM_LO2_VW |
| 7 | REMIT_ADDR_SEQ_NUM | Number(5,0) | INTEGER NOT NULL |
Remitting Location
Default Value: 1 Prompt Table: VNDR_REMADDR_VW |
| 8 | ADDR_SEQ_NUM_ORDR | Number(5,0) | INTEGER NOT NULL |
Ordering Location
Default Value: 1 Prompt Table: VNDR_ORDADDR_VW |
| 9 | RETURN_VENDOR | Character(10) | VARCHAR2(10) NOT NULL |
Return to Vendor
Prompt Table: VNDR_RETURN_VW |
| 10 | RET_ADDR_SEQ_NUM | Number(5,0) | INTEGER NOT NULL |
Return to Address
Default Value: 1 Prompt Table: VNDR_RETADDR_VW |