SSF_ELEC_PMTS(SQL Table) |
Index Back |
|---|---|
SF Electronic Payment Trans |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SCC_PMT_APPL |
Character(15) | VARCHAR2(15) NOT NULL |
Payment Application
Prompt Table: SCC_PMT_APPL |
| 2 | CR_CARD_TRANS_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Payment Transaction Source
A=Application Center C=Cashiering I=Contributor Relations M=Miscellaneous Fees P=Payment R=Refund V=Payment Reversal |
| 3 | SSF_POST_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Post Type indicates whether the transaction is posted to the SF Account or to the General Ledger
A=Account Posting E=External G=GL Posting |
| 4 | SCC_EPAY_INTG_ID | Character(20) | VARCHAR2(20) NOT NULL |
Payment Integration ID (points to a payment adapter/application class)
Prompt Table: SCC_EP_ADP_VW |
| 5 | SSF_GL_TRANS_SRC | Character(2) | VARCHAR2(2) NOT NULL |
GL Transaction Source
01=Admissions App Web Services 02=Official Transcript Fee |