SETIDPrompt Table: SP_SETID_NONVW
VENDOR_IDVNDR_LOCEFFDTDefault Value: %date
CC_CARD_TYPEAMEX=American Express
CORP=Corporate Card
DEBT=Debit Card
MC=MasterCard
PHON=Phone Card
PRCR=Procurement Card
VISA=Visa
VENDOR_LOC_CCTP(SQL Table) |
Index Back |
|---|---|
Supplier Location ProCard Type |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | VNDR_LOC |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 4 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 5 | CC_CARD_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Credit Card Type (e.g Corporate Card, debit Card, Procurement Card, etc.)
AMEX=American Express CORP=Corporate Card DEBT=Debit Card MC=MasterCard PHON=Phone Card PRCR=Procurement Card VISA=Visa |