SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETVC_NONVW
VENDOR_IDDefault Value: NEXT
VENDOR_PERSISTENCEO=One Time
P=Permanent
R=Regular
S=Single Payment Supplier
Default Value: R
VENDOR_ADD_VW(SQL View) |
Index Back |
|---|---|
Supplier Search RecordSearch Record on the Supplier Record |
| SELECT a.setid , a.vendor_id , a.vendor_persistence FROM PS_VENDOR a |
| # | 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_SETVC_NONVW |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Default Value: NEXT |
| 3 | VENDOR_PERSISTENCE |
Character(1) | VARCHAR2(1) NOT NULL |
Persistence
O=One Time P=Permanent R=Regular S=Single Payment Supplier Default Value: R |