VNDR_RGN_LOC_VW(SQL View) |
Index Back |
|---|---|
Sourcing Region Supplier LocatProvides Supplier Location for Supplier within Sourcing Region |
| SELECT VENDOR_SETID , VENDOR_ID , VNDR_LOC , SETID , REGION_CD FROM PS_REGION_VNDR_LOC |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: VNDR_SECPNL_WRK.SETID Prompt Table: SP_SETID_NONVW |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Default Value: VNDR_SECPNL_WRK.VENDOR_ID Prompt Table: VENDOR_VW1 |
| 3 | VNDR_LOC |
Character(10) | VARCHAR2(10) NOT NULL |
Vendor Location
Default Value: VENDOR_LOC.VNDR_LOC Prompt Table: VENDOR_LOC_VW3 |
| 4 | SETID_REGION |
Character(5) | VARCHAR2(5) NOT NULL |
Region SetID
Default Value: OPR_DEF_TBL_FS.SETID |
| 5 | REGION_CD |
Character(10) | VARCHAR2(10) NOT NULL |
Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
Prompt Table: REGION_CD_PO_VW |