VENDOR_SPRO_VW2(SQL View) |
Index Back |
|---|---|
Services Supplier Info ViewSELECT B.SETID , B.VENDOR_ID , A.NAME1 , B.SUPPLIER_LOC , B.PYMT_TERMS_CD FROM PS_VENDOR A , PS_VENDOR_SPRO B WHERE A.SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_VENDOR_SPRO B_ED WHERE B.SETID = B_ED.SETID AND B.VENDOR_ID = B_ED.VENDOR_ID AND B_ED.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A' AND A.VENDOR_STATUS = 'A' AND A.VENDOR_CLASS = 'R' |
| SELECT B.SETID , B.VENDOR_ID , A.NAME1 , B.SUPPLIER_LOC , B.PYMT_TERMS_CD , B.SPB_SUPPLIER_TYPE ,XLATLONGNAME FROM PS_VENDOR A , PS_VENDOR_SPRO B ,PSXLATITEM E WHERE A.SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND E.FIELDNAME ='SPB_SUPPLIER_TYPE' AND B.SPB_SUPPLIER_TYPE=E.FIELDVALUE AND E.EFF_STATUS ='A' AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_VENDOR_SPRO B_ED WHERE B.SETID = B_ED.SETID AND B.VENDOR_ID = B_ED.VENDOR_ID AND B_ED.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A' AND A.VENDOR_STATUS = 'A' AND A.VENDOR_CLASS = 'R' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: VENDOR_SP_VW2 |
| 3 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 4 | SUPPLIER_LOC | Character(10) | VARCHAR2(10) NOT NULL |
Remit To
Prompt Table:
SPM_REM_LOC_VW
|
| 5 | PYMT_TERMS_CD | Character(5) | VARCHAR2(5) NOT NULL |
Payment Terms Code
30=Due in 30 days after invoice 45=Due in 45 days after invoice IMM=Due Immediately Prompt Table: PAYTRMS_SPF_VW |
| 6 | SPB_SUPPLIER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Supplier Type
B=Both D=Deliverable R=Resource |
| 7 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |