SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
VENDOR_IDPrompt Table: SP_SETID_NONVW
Prompt Table: CUST_VNDR_AR_VW
VENDOR_AR(SQL View) |
Index Back |
|---|---|
PS/AR Supplier ViewUsed as a search record for several supplier related panel groups |
| SELECT a.setid , a.vendor_id , a.name1 , a.vendor_name_short , a.cust_setid , a.cust_id , a.vndr_affiliate FROM PS_VENDOR a WHERE vendor_status = '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_SETID_NONVW |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 4 | VENDOR_NAME_SHORT | Character(14) | VARCHAR2(14) NOT NULL | Short Vendor Name |
| 5 | CUST_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Customer SetID
Prompt Table: SP_SETID_NONVW |
| 6 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table: CUST_VNDR_AR_VW |
| 7 | VNDR_AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL | Vendor Affiliate |