CC_VNDR_CARD_VW(SQL View) |
Index Back |
|---|---|
ProCard - Supplier Card |
| SELECT A.EMPLID , A.CREDIT_CARD_VENDOR , A.CRDMEM_ACCT_NBR , B.SETID , B.VENDOR_ID , B.VNDR_LOC , B.EFFDT , B.CC_ACCEPT_CC , B.CC_DISP_OPTION , B.CC_ALLOW_OVERRIDE , B.CC_SECURITY_ID , B.CC_USE_FLAG FROM PS_CC_CARD_DATA_EX A , PS_VENDOR_LOC B WHERE A.CC_VENDOR_CARD = 'Y' AND A.CC_SECURITY_ID = B.CC_SECURITY_ID AND B.EFF_STATUS = 'A' AND %EffdtCheck(VENDOR_LOC B1, B, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | CREDIT_CARD_VENDOR |
Character(5) | VARCHAR2(5) NOT NULL | Corporate Card Vendor |
| 3 | CRDMEM_ACCT_NBR |
Character(44) | VARCHAR2(44) NOT NULL | Cardmember Number |
| 4 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL |
Vendor SetID
Prompt Table: SP_SETID_NONVW |
| 5 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: CC_VNDR_NOVC_VW |
| 6 | VNDR_LOC |
Character(10) | VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table: CC_VNDR_LOC1_VW |
| 7 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 8 | CC_ACCEPT_CC | Character(1) | VARCHAR2(1) NOT NULL |
Accept Procurement Card
Y/N Table Edit Default Value: N |
| 9 | CC_DISP_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
ProCard Dispatch Option
A=Default B=Include Masked Card Info C=Contact Buyer D=Contact Cardholder E=Charge to Card on File F=No Reference Default Value: A |
| 10 | CC_ALLOW_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL |
Allow Override Vendor Card
Y/N Table Edit Default Value: N |
| 11 | CC_SECURITY_ID | Number(10,0) | DECIMAL(10) NOT NULL | Procurement Card Number |
| 12 | CC_USE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Use Procurement Card
Y/N Table Edit Default Value: N |