SF_PAYMENT

(SQL Table)
 Index Back

SF electronic payments

Holds all unprocessed SF electronic payments.

  • Parent Record Of SSF_PAYMENT_CVV SSF_PAYMENT_TKN

    • # 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 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    3 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
    4 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
    O=Organization
    P=Person
    5 SF_PAYMENT_STATUS Character(2) VARCHAR2(2) NOT NULL Payment Status
    A=Authorization Successful
    B=Payment Completed
    C=Refunded
    D=Declined
    E=Edit Error
    I=Payment Initiated
    M=Manually Approved/Settled
    N=Payment Cancelled
    P=Credit Pending
    R=Refund Cancelled
    S=Payment Submitted
    6 SF_POST_STATUS Character(1) VARCHAR2(1) NOT NULL Posting Status
    E=Errors Encountered.
    P=Pending
    S=Successfully Posted

    Default Value: P

    7 INSTITUTION_SET Character(5) VARCHAR2(5) NOT NULL Institution Set

    Prompt Table: INSTITUTION_SET

    8 PAYMENT_AMT Number(19,3) DECIMAL(18,3) NOT NULL Payment Amount
    9 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_VAL_TBL

    10 DUE_DT Date(10) DATE Due Date
    11 CR_CARD_EXPMO Character(2) VARCHAR2(2) NOT NULL Card Expiration Month
    01=01
    02=02
    03=03
    04=04
    05=05
    06=06
    07=07
    08=08
    09=09
    10=10
    11=11
    12=12
    12 CR_CARD_EXPYR Character(4) VARCHAR2(4) NOT NULL Card Expiration Year
    13 CR_CARD_FNAME Character(40) VARCHAR2(40) NOT NULL Credit Card First Name
    14 CR_CARD_LNAME Character(40) VARCHAR2(40) NOT NULL Credit Card Last Name
    15 CR_CARD_NBR Character(44) VARCHAR2(44) NOT NULL Credit Card Number
    16 CR_CARD_TYPE Character(2) VARCHAR2(2) NOT NULL Credit Card Type

    Prompt Table: CR_CARD_TYPE_VW

    17 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: SCC_CNT_ADFMTVW

    18 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    19 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    20 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    21 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    22 CITY Character(30) VARCHAR2(30) NOT NULL City
    23 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    24 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    25 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    26 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    27 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    28 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    29 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    30 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    31 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    32 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    33 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    34 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
    35 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    36 CR_CARD_AUTH_CD Character(10) VARCHAR2(10) NOT NULL Credit Card Authorization Code
    37 CR_CARD_AUTH_DT Date(10) DATE Auth Date
    38 CR_CARD_RQST_ID Character(30) VARCHAR2(30) NOT NULL Credit Card Request ID
    39 CR_CARD_A_DTTM Character(20) VARCHAR2(20) NOT NULL Credit Card Authorization DTTM
    40 CR_CARD_AUTH_REPLY Character(15) VARCHAR2(15) NOT NULL Authorization Reply
    41 CR_CARD_TRANS_LAST Character(2) VARCHAR2(2) NOT NULL Transaction Requested
    1=Authorize
    2=Authorize and Capture
    3=Capture
    4=Credit
    5=eCheck Debit
    6=eCheck Credit
    91=Request Token
    92=Authorize and Capture
    93=Hosted Payment Credit
    42 CR_CARD_AVS_CD Character(1) VARCHAR2(1) NOT NULL Credit Card AVS Return Code
    43 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    44 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    45 SF_PAYMENT_SPLIT Character(1) VARCHAR2(1) NOT NULL Payment Allocated

    Y/N Table Edit

    Default Value: N

    46 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    47 CR_CARD_DIGITS Character(4) VARCHAR2(4) NOT NULL Card Number's Last Four Digits
    48 SF_REVERSAL_IND Character(1) VARCHAR2(1) NOT NULL Reversal Indicator
    49 POSTED_DATE Date(10) DATE Date Posted
    50 POSTED_DATETIME DateTime(26) TIMESTAMP Posted Date & Time
    51 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
    52 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    53 SSF_ERROR_WARN Character(1) VARCHAR2(1) NOT NULL Field to hold translate values for Message Types - Error/Warning/Message
    E=Error
    M=Message
    W=Warning
    54 BUSINESS_UNIT_ERR Character(5) VARCHAR2(5) NOT NULL Business Unit
    55 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    56 BATCH_ID Character(12) VARCHAR2(12) NOT NULL Batch ID
    57 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    58 REFUND_NBR Number(12,0) DECIMAL(12) NOT NULL Refund Nbr
    59 LINE_SEQ_NBR Number(3,0) SMALLINT NOT NULL Line Sequence Nbr
    60 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
    61 REVERSAL_STAT_SF Character(1) VARCHAR2(1) NOT NULL Reversal Status
    E=Errors were encountered
    S=Successful
    62 CASHIER_OFFICE Character(8) VARCHAR2(8) NOT NULL Cashier's Office
    63 SF_REGISTER Character(5) VARCHAR2(5) NOT NULL Cash Register
    64 RECEIPT_NBR Number(12,0) DECIMAL(12) NOT NULL Receipt Number
    65 SF_MERCHANT_ID Character(12) VARCHAR2(12) NOT NULL SF Merchant ID

    Prompt Table: MERCHANT_TBL

    66 RECEIPT_LINE_NBR Number(3,0) SMALLINT NOT NULL Receipt Line Number
    67 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr
    68 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    69 ADM_APPL_CTR Character(4) VARCHAR2(4) NOT NULL Application Center
    70 CR_CARD_SRVC_PROV Character(2) VARCHAR2(2) NOT NULL Credit Card Service Provider
    01=Cybersource
    02=TouchNet
    99=Unsupported
    71 TRANS_REF_NO Character(60) VARCHAR2(60) NOT NULL Transaction Reference Nbr
    72 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

    73 BANK_ACCT_TYP Character(1) VARCHAR2(1) NOT NULL Bank Account Type
    C=Checking
    S=Savings
    74 BANK_CD Character(11) VARCHAR2(11) NOT NULL Bank ID
    75 SSF_BNK_ACCT_NUM Character(44) VARCHAR2(44) NOT NULL Bank Account Number
    76 EC_SETTLE_METHOD Character(1) VARCHAR2(1) NOT NULL Settlement Method
    A=Automated Clearing House
    B=Best possible
    F=Facsimile draft
    77 EC_VERIFICATION Character(1) VARCHAR2(1) NOT NULL Verification Level
    1=Validation
    2=Verification
    78 SSF_AGREEMENT_NBR Character(12) VARCHAR2(12) NOT NULL Agreement Number
    79 SCC_EPAY_SESSIONID Character(254) VARCHAR2(254) NOT NULL Session ID
    80 SCC_EPAY_CVRESULT Character(22) VARCHAR2(22) NOT NULL Credit Verification Result
    81 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    82 SCC_EPAY_RET_MSG Character(254) VARCHAR2(254) NOT NULL Return Message
    83 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

    Default Value: A

    84 SSF_EXT_TRANS_REF Character(50) VARCHAR2(50) NOT NULL External Transaction Reference
    85 SSF_PMT_SRC_STATUS Character(1) VARCHAR2(1) NOT NULL Payment Source Update Status
    P=Pending Update
    S=Successful Update

    Default Value: P

    86 SCC_PMT_APPL Character(15) VARCHAR2(15) NOT NULL Payment Application

    Prompt Table: SSF_ELEC_PMTS

    87 SCC_TEMP_ID Number(16,0) DECIMAL(16) NOT NULL Temp Constituent ID