SF_PAYMENT_ADD2(SQL View) |
Index Back |
|---|---|
SF electronic payments - AddSearch record for SF electronic payments |
| SELECT SF_PMT_REF_NBR , COMMON_ID , TENDER_CATEGORY , INSTITUTION_SET FROM PS_SF_PAYMENT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SF_PMT_REF_NBR |
Character(12) | VARCHAR2(12) NOT NULL |
Reference Nbr
Default Value: 0 |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 3 | TENDER_CATEGORY |
Character(3) | VARCHAR2(3) NOT NULL |
Tender Category
CC=Credit Card CCI=Credit Card In CCO=Credit Card Out CK=Check CKI=Check In CKO=Check Out CS=Cash CSI=Cash In CSO=Cash Out DB=Debit Card DBI=Debit Card In DBO=Debit Card Out DD=Direct Deposit DDI=Direct Debit DDO=Direct Deposit EC=Electronic Check TP=Third Party Check TPI=Third Party Check In WIR=Wire Transfer Default Value: CC |
| 4 | INSTITUTION_SET | Character(5) | VARCHAR2(5) NOT NULL |
Institution Set
Prompt Table: INSTITUTION_SET |