VENDOR_IDOPRIDLANGUAGE_CDEM_BUY_OUTBLANG(SQL View) |
Index Back |
|---|---|
MP - Seller Balances ViewMP - Seller B |
| SELECT VEN.VENDOR_ID , SEC.OPRID , L.LANGUAGE_CD , V.BUSINESS_UNIT , VEN.NAME1 , V.VNDR_LOC , L.VENDOR_NAME_SHORT FROM PS_VOUCHER V , PS_SEC_BU_OPR SEC , PS_VENDOR VEN , PS_VENDOR_LANG L WHERE SEC.BUSINESS_UNIT=V.BUSINESS_UNIT AND (V.PROCESS_MAN_CLOSE = 'N' OR V.CLOSE_STATUS <> 'C') AND V.ENTRY_STATUS <> 'X' AND V.VENDOR_SETID = VEN.SETID AND V.VENDOR_ID = VEN.VENDOR_ID GROUP BY VEN.VENDOR_ID, SEC.OPRID, L.LANGUAGE_CD, V.BUSINESS_UNIT, VEN.NAME1, V.VNDR_LOC, L.VENDOR_NAME_SHORT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 6 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 7 | VENDOR_NAME_SHORT | Character(14) | VARCHAR2(14) NOT NULL | Short Vendor Name |