Profiles World > Gifts and Dues > Credit Card

More information

Credit Card

Storing Credit Card Numbers

To comply with Payment Card Industry Data Security Standards (PCI-DSS), complete credit card numbers cannot be stored in the Abila Millennium database. Instead, the numbers are stored in the Sage Exchange Vault, and the link to the vault entry is stored in the Abila Millennium database.

More...

Credit Card Data Display

The method of tender is displayed with the primary row, if the appropriate security has been established for the user who is viewing Giving information. The standard display incorporates the lines of Credit Card information into the display of the transaction (unless the display mode is set to Mini). To access the Credit Card information for editing, the display includes an Edit button to the left.

Credit Card Data Entry

Step-by-step instructions for entering a Gift, Dues, or Registration Fee transaction when tendered by credit card can be found in the Gift and Dues Tender Types topic.

Multiple Linked Credit Card Records

Each Gift or Dues Transaction record may have one or more linked Credit Card record, in combination with any other appropriate secondary rows (unless the transaction has a Type of Credit.). Only one Credit Card Row can be created at the time the Gift or Dues transaction is entered. To add another Credit Card row, place your mouse pointer over the edit button for the Gift or Dues transaction, place the pointer over Transactions, and select Add Credit Card.

Edit, Journal or Delete a Transaction Tendered by Credit Card

If a Credit Card row exists and you edit the transaction to a different Tender type, the Credit Card row will not be automatically deleted and it will still display with the Gift or Dues information; you must manually delete the Credit Card row after the transaction has been edited. If the new Tender Type is Securities, Gift in Kind, or Bank Draft, you will be prompted to create a new row of the corresponding type.
If a Credit Card row is linked to a transaction that is subsequently journaled, a flag (credjrnlfl) is automatically set on the Credit Card row so that such rows can be excluded from Credit Card reports. The date of the journal is also added to the Credit Card row (credjrnldt).
If you journal a Gift or Dues Transaction with an attached Credit Card row, and the Credit Card transaction itself has been processed through Sage Payment Solutions, you will be warned that the transaction has been processed through Sage Payment Solutions and will have to be reversed. Select OK to proceed. Abila Millennium will journal the Gift or Dues Transaction and automatically reverse the credit card charges. Select Cancel to return to the Journal insert form.
A Gift, Dues, or Event Income (Registration Fee) transaction tendered by credit card and successfully processed through Sage Payment Solutions cannot be deleted.

Update Credit Card Authorization Information

If you use Sage Payment Solutions to process credit card transactions, you can update the card expiration and account authorization information by using the Tools>SPS>Account Updater option. See

Customize Credit Card Data Display and Maintenance Forms

(Refer to the Custom Display Designer topic for complete instructions on customizing display and maintenance forms.)

Credit Card Linked to Giving or Dues

Using Internet Explorer as your browser, log on to the system as a Millennium system administrator.
Access the Profiles version of the Custom Display Designer by using Millennium Explorer, Tools>Display Design>Profiles.
Click the Profiles item on the Navigation Tool Bar to access the Display Designer's context menu. Point to the Giving menu item, point to the Credit Card menu item, and then click the Credit Card item.
Click Display Type and click on the desired Display Type menu item (for example, Long or Short).
Utilize the Custom Display Designer's editing tools to make your customizations.
Click Save to save and apply your changes.

Credit Card Linked to Event Income

Using Internet Explorer as your browser, log on to the system as a Millennium system administrator.
Access the Events version of the Custom Display Designer by using Millennium Explorer, Tools>Display Design>Events.
Click the Events item on the Navigation Tool Bar to access the Display Designer's context menu. Point to the Fees menu item and then click the Credit Card:Credit Card item.
Click Display Type and click on the desired Display Type menu item (for example, Long or Short).
Utilize the Custom Display Designer's editing tools to make your customizations.
Click Save to save and apply your changes.

Credit Card Field Descriptions

Credit Card data is stored in the creditcard data table. Secondary information for transactions tendered by bank draft are also stored in the creditcard data table. The following fields are included. The field labels and non-displaying designations that are listed here are those that the system uses by default. If you want to override these default settings, you must customize your display definition.

Note: Custom fields are included in the data table, and are available for any purpose that you want to define. These fields are not shown on the standard Display or standard Data Maintenance forms. If you want to make use of one or more of the custom fields, use the Custom Display Designer to edit the standard Display and Data Maintenance forms.

Field Name Field Label	Lookup Table	Type SQL/Oracle Length [Default] {Check}	Description
credkey non-displaying	none	numeric/number 13,0	The primary key field for all rows in all tables. This field holds a permanent "time stamp" of the precise time and date the row was created. This uniquely identifies a row within the table. (System field)
credid non-displaying	none	char 10	This field holds the ID number of the constituent who owns this row, providing a link between this row and all others in all other tables which also belong to the same constituent. (System field)
creddoc non-displaying	none	char 1 ['N']	This field holds a Y/N flag to indicate the existence of a linked document for this row. (System field)
creddate no label	none	datetime/date [getdate()]	The date that this Credit Card row was last updated. This field is automatically entered by the system. (System field)
creduserid no label	none	varchar/varchar2 30 [suser_sname()]	The User ID of the operator that last edited this Credit Card row. It is automatically entered by the system. (System field)
credugrp non-displaying	none	char 1 ['Z']	This field holds the Group letter that was associated with the User ID of the operator who last edited this row. (System field)
credcctype Type	Credit Card Type	char 6 [' ']	The kind of credit card used for the tender of the Transaction.
credccnum Number	none	char 240	If tender is 'bank', this field will hold the encrypted value of the bank account number.
credexpyr Exp Year	none	char 4	The year in which the card expires.
credexpmn Exp Month	none	char 2	The month in which the card expires.
credapprov Approval	none	char 15	The approval or authorization code given by the Credit Card company for the transaction.
credflag non-displaying	none	char 1 ['N'] {'N' or 'Y'}	This flag may be used in any way that your institution wants. (If this field is going to be used at your institution, your system administrator would need to edit the Insert, Update and Display templates involved.) (System field)
credlnkfil non-displaying	none	char 2	The number of the file (table) to which this Credit Card row is attached. Credit Card rows may be attached to Transactions or to Dues rows. (System field)
credlnkkey non-displaying	none	numeric/number 13,0 [0]	The key field from the row to which this Credit Card row is attached. (System field)
credsource Source	Source	char 6 [' ']	The source for the information in this row.
credcrdate non-displaying	none	datetime/date [getdate()]	The date that the row was created. (System field)
credfnum non-displaying	none	char 2 ['37'] {'37'}	The file (table) number for the Credit Card table. (System field)
credpoint non-displaying	none	numeric/number 10,0	This system-assigned field is no longer used or supported. (System field)
credcomm no label	none	varchar/varchar2 4000	A free text Comment that may be entered and displayed with this row only.
creddate1	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
creddate2	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
credmny1	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
credmny2	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
crednum1	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
crednum2	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
credyesno	none	char 1 ['N'] {'N' or 'Y'}	This custom field may be defined and used by your institution to flag this data row for any purpose.
credlook1	Credit Card Lookup1	char 6	This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row.
credlook2	Credit Card Lookup2	char 6	This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row.
credlook3	Credit Card Lookup3	char 6	This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row.
credtext	none	varchar/varchar2 255	This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.
credjrnlfl non-displaying	none	char 1 ['N'] {'Y', 'N'}	This system-generated field is a flag indicating whether the transaction to which this data row is linked has ('Y') or has not ('N') been journaled. (System field)
credjrnldt non-displaying	none	datetime/date	This system-generated field is used to hold the date on which the transaction to which this data row is linked was journaled (if ever). (System field)
credverif non-displaying	none	char 4	This field is not used at this time.
credccnm	none	varchar/varchar2 150	This field holds the name as it appears on the credit card account. (for example, Jeffrey R. Shure)
credguid non-displaying	none	char 32	Used by Sage Payment Solutions (SPS) - payment information stored in the ' Vault' is given a unique identifier to reference this stored data. This identifier is then recorded in this row. (System field)
credtender non-displaying	tender	char 6 [' ']	The tender of the transaction to which this credit card row is linked. (System field).
credroute Bank Routing Number	none	char 10	If tender of transaction is 'bank', this field holds the ABA bank routing number. On data entry, the format of the data for this field must conform to a valid ABA bank routing number.
credbnktype Account Type	bank_account_type	char 6 [' ']	If the tender of the transaction is 'bank', the bank account type (Commercial Checking, Commercial Savings, Personal Checking, Personal Savings)
credbanknm The Bank Name	none	varchar/varchar2 200	If the tender of the transaction is 'bank', the name of the banking institution from which this draft will be drawn. (for example, Bay Savings Bank)
credaddrl1 Address 1	none	varchar/varchar2 100	Line 1 of the billing address associated with this row.
credaddrl2 Address 2	none	varchar/varchar2 100	Line 2 of the billing address associated with this row.
credcity City	none	char 30	City of the billing address associated with this row.
credstate State	places	char 6 [' ']	State of the billing address associated with this row.
credcntry Country	countries	char 6 [' ']	Country of the billing address associated with this row.
credzip Zipcode	zipcodes	char 15 [' ']	Postal code of the billing address associated with this row.
credemail email	none	char 200	email address associated with this row.
credmethod Process Method	none	char 1 ['M'] {'B' ,'R', 'M', 'V'}	The Sage Payment Solutions (SPS) Process Method. Choose Vault Only if payment account information is entered for historical purposes, or the type of giving transaction associated with this row is a pledge. If the transaction associated with this row is a gift or pledge payment and your user has permission to use Real Time Sage Payment Solutions, Real Time will also be an available method from which to choose, and, in fact, will be the default method.
credprocdt non-displaying	none	datetime/date	The date this row was processed by Sage Payment Solutions (SPS). (System field)
credstatus non-displaying	none	char 1 [' '] {' ','P','N'}	The values of this field will depend on the Process Method (credmethod). If the Process Method is Real Time (R), then this field can be 'P' for Processed. (System field)
credsave Save for future use	none	char 1 ['N'] {'N' or 'Y'}	Check if you want to save this row's payment information for future use. Uncheck if you do not want to save this row's payment information for future use. This feature will be available only if the 'Allow accounts to be saved for future use' system option setting is set to 'Yes'. This box will be Checked by default. Payment information that is saved for future use is stored in the Sage Payment Solutions (SPS) 'Vault' and is assigned a unique identifier which will be stored in the credguid field of this row.
credlast4 Last 4 digits of Account	none	char 4	If tender of the transaction associated with this row is 'bank', this field holds the last 4 digits of the bank account number associated with the transaction linked to this row. If the tender is 'cc', this field holds the last 4 digits of the credit card number associated with the transaction linked to this row.
credacctty Bank Account Type	none	char 3 [' '] {'SAV', 'DDA',' '}	If tender of the transaction associated with this row is 'bank', is the account a checking account (DDA' is a Demand Deposit (checking) Account ) or a savings account ('SAV')?
credcustty Customer Type	none	char 3 [' '] {'TEL', 'ARC', 'RCK', 'WEB', 'PPD', 'CCD', ' '}	If tender of the transaction associated with this row is 'bank', this field holds the type of debit from the customer's bank account. ARC - Accounts Receivable Conversion - A debit entry created from a customer check processed in a lockbox, drop box, or other payment receivable processing environment. CCD - Cash Concentration or Disbursement - A debit entry to consolidate funds of that organization, from its branches, franchises or agents, or from other organizations; or to fund the accounts of its branches, franchises or agents, or of another organization PPD - Prearranged Payment and Deposit - A one time authorization from a customer, to effect an electronic funds transfer, to or from a customer's bank account. RCK - Returned Check Recovery - customer is re-presenting returned check (s) to the originating financial institution TEL - Telephone Initiated Entry - An electronic debit from a customer's bank account based on oral authorization by phone. WEB - An electronic debit from a customer's bank account created during a secure Internet session between a company and customer. reference: http://www.chasepaymentech.com/gloglow.do
credssnum Social Security #	none	char 240	The encrypted value of the Social Security number associated with this row.
creddstate Drivers License State	places	char 6	The code of the state in which the driver's license is issued.
creddlnum Drivers License Number	none	char 15	The driver license number associated with this row.
credbdate Birth Date	none	datetime/date	The birthday associated with this row.
credhphone Home Phone	none	char 15	The home phone number associated with this row.
credein Fed. Tax ID (EIN)	none	char 11	The Federal Tax ID (EIN) associated with this row.
credamount Amount	none	numeric/number 19, 4	This field holds the amount that will be charged to the credit card (if tender is 'cc') or debited to the bank account (if tender is 'bank').
credchckno Check No	none	char 12	If the tender of the transaction associated with this row is 'bank', this field holds the check number associated with this row.
credexdate	none	datetime/date	Formatted credit card expiration date. Generated by the system, using a user-input expiration month and a user-input expiration year, and an expiration day of 01. Note that this is not an actual credit card expiration date and is used for reporting purposes only.
credref non-displaying	none	char 10	Used by Sage Payment Solutions (SPS) - credit card and bank draft transactions that are successfully processed will be assigned this reference number by the system.
credmerid	none	char 12	Used by Sage Payment Solutions (SPS) - the id number for the merchant account associated with the purpose (from the Chart of Accounts) of the transaction to which this data row is linked.
credmerkey non-displaying	none	char 12	Used by Sage Payment Solutions (SPS) - the key for the merchant account associated with the purpose (from the Chart of Accounts) of the transaction to which this data row is linked.
credvoidfl non-displaying	none	char 1 {' ', 'v' ,'c'}	Used by Sage Payment Solutions (SPS) when this credit card or bank draft row has been successfully processed through SPS, and the transaction to which this data row is subsequently journaled (or journaled and corrected). This field will hold a 'v' or a 'c' to indicate that the credit card/bank draft charges have been reversed; if the constituent's credit card or bank account has already been debited, then the value of this field will be 'c'. If the credit card or bank account has yet to be debited, then the value of this field will be 'v'.
credvoiddt non-displaying	none	datetime/date	Used by Sage Payment Solutions (SPS) - if this credit card or bank draft row has been successfully processed through SPS, and the transaction to which this data row is subsequently journaled (or journaled and corrected) this field will hold the date on which the credit card/bank draft charges were reversed.
credvoidrf non-displaying	none	char 10	Used by Sage Payment Solutions (SPS) - if this credit card or bank draft row has been successfully processed through SPS, and the transaction to which this data row is subsequently journaled (or journaled and corrected), this field will hold the reference number that SPS assigned to the credit card/bank draft reversal transaction.
creddate3	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
creddate4	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
creddate5	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
creddate6	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
creddate7	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
creddate8	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
creddate9	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
creddte10	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
creddte11	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
creddte12	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
credmny3	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
credmny4	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
credmny5	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
credmny6	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
credmny7	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
credmny8	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
credmny9	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
credmny10	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
credmny11	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
credmny12	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
crednum3	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
crednum4	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
crednum5	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
crednum6	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
crednum7	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
crednum8	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
crednum9	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
crednum10	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
crednum11	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
crednum12	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
credchk1	none	char 1 ['N'] {'N' or 'Y'}	This custom field may be defined and used by your institution to flag this data row for any purpose.
credchk2	none	char 1 ['N'] {'N' or 'Y'}	This custom field may be defined and used by your institution to flag this data row for any purpose.
credchk3	none	char 1 ['N'] {'N' or 'Y'}	This custom field may be defined and used by your institution to flag this data row for any purpose.
credchk4	none	char 1 ['N'] {'N' or 'Y'}	This custom field may be defined and used by your institution to flag this data row for any purpose.
credchk5	none	char 1 ['N'] {'N' or 'Y'}	This custom field may be defined and used by your institution to flag this data row for any purpose.
credchk6	none	char 1 ['N'] {'N' or 'Y'}	This custom field may be defined and used by your institution to flag this data row for any purpose.
credchk7	none	char 1 ['N'] {'N' or 'Y'}	This custom field may be defined and used by your institution to flag this data row for any purpose.
credchk8	none	char 1 ['N'] {'N' or 'Y'}	This custom field may be defined and used by your institution to flag this data row for any purpose.
credchk9	none	char 1 ['N'] {'N' or 'Y'}	This custom field may be defined and used by your institution to flag this data row for any purpose.
credchk10	none	char 1 ['N'] {'N' or 'Y'}	This custom field may be defined and used by your institution to flag this data row for any purpose.
credtxt1	none	varchar/varchar2 255	This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.
credtxt2	none	varchar/varchar2 255	This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.
credtxt3	none	varchar/varchar2 255	This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.
credtxt4	none	varchar/varchar2 255	This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.
credtxt5	none	varchar/varchar2 255	This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.
credtxt6	none	varchar/varchar2 255	This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.
credtxt7	none	varchar/varchar2 255	This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.
credtxt8	none	varchar/varchar2 255	This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.
credtxt9	none	varchar/varchar2 255	This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.
credtxt10	none	varchar/varchar2 255	This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.
credfirst6	none	varchar	Used by Sage Payment Solutions (SPS) - the first six digits of the credit card.
credspsid	none	varchar	Used by Sage Payment Solutions (SPS) - the SPS ID.
credmasked	none	varchar	Used by Sage Payment Solutions (SPS) - the full, masked credit card number, including the first six and last four digits of the card, plus asterisks for the missing numbers.
credmkey	none	Numeric 13,9	Used by Sage Payment Solutions (SPS) - the SPS mkey associated with the row.
credinitum Initium Status	none	char 1 [null] {' ','O','V'}	This column displays the status of the address if your organization uses Initium Instant Address. It contains a single character that indicates whether the address has been validated or overridden, as follows: O - Overridden V - Validated Blank - no status
credinitds non-displaying	none	char 1 [''] {'','E','T','M','S', 'U','F','P'}	This field is available for use with Initium Instant Address. It contains a single character that describes the detail status of the address as follows: E - Exact T - Tentative M - Multiple S - Secondary U - Unmatched F - Foreign P - Primary Blank - No detail status
credindate Initium verification date	none	datetime	This field specifies the last date and time that the address was validated using Initium Instant Address.
credinitvr Initium verification Info	none	varchar 30	This field contains the verification information returned from Initium for the address, if any.

Field Name

Field Label

Lookup Table

Type SQL/Oracle

Length

[Default]

{Check}

Description

credkey

non-displaying

none

numeric/number

13,0

The primary key field for all rows in all tables. This field holds a permanent "time stamp" of the precise time and date the row was created. This uniquely identifies a row within the table. (System field)

credid

non-displaying

none

char

This field holds the ID number of the constituent who owns this row, providing a link between this row and all others in all other tables which also belong to the same constituent. (System field)

creddoc

non-displaying

none

char

['N']

This field holds a Y/N flag to indicate the existence of a linked document for this row. (System field)

creddate

no label

none

datetime/date

[getdate()]

The date that this Credit Card row was last updated. This field is automatically entered by the system. (System field)

creduserid

no label

none

varchar/varchar2

[suser_sname()]

The User ID of the operator that last edited this Credit Card row. It is automatically entered by the system. (System field)

credugrp

non-displaying

none

char

['Z']

This field holds the Group letter that was associated with the User ID of the operator who last edited this row. (System field)

credcctype

Type

Credit Card Type

char

[' ']

The kind of credit card used for the tender of the Transaction.

credccnum

Number

none

char

240

If tender is 'bank', this field will hold the encrypted value of the bank account number.

credexpyr

Exp Year

none

char

The year in which the card expires.

credexpmn

Exp Month

none

char

The month in which the card expires.

credapprov

Approval

none

char

The approval or authorization code given by the Credit Card company for the transaction.

credflag

non-displaying

none

char

['N']

{'N' or 'Y'}

This flag may be used in any way that your institution wants. (If this field is going to be used at your institution, your system administrator would need to edit the Insert, Update and Display templates involved.) (System field)

credlnkfil

non-displaying

none

char

The number of the file (table) to which this Credit Card row is attached. Credit Card rows may be attached to Transactions or to Dues rows. (System field)

credlnkkey

non-displaying

none

numeric/number

13,0

[0]

The key field from the row to which this Credit Card row is attached. (System field)

credsource

Source

char

[' ']

The source for the information in this row.

credcrdate

non-displaying

none

datetime/date

[getdate()]

The date that the row was created. (System field)

credfnum

non-displaying

none

char

['37']

{'37'}

The file (table) number for the Credit Card table. (System field)

credpoint

non-displaying

none

numeric/number

10,0

This system-assigned field is no longer used or supported. (System field)

credcomm

no label

none

varchar/varchar2

4000

A free text Comment that may be entered and displayed with this row only.

creddate1

none

datetime/date

This custom field may be defined and used by your institution to track any date information associated with this data row.

creddate2

none

datetime/date

This custom field may be defined and used by your institution to track any date information associated with this data row.

credmny1

none

money/number

(19,4)/(16,2)

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

credmny2

none

money/number

(19,4)/(16,2)

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

crednum1

none

numeric/number

10, 0

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

crednum2

none

numeric/number

10, 0

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

credyesno

none

char

['N']

{'N' or 'Y'}

This custom field may be defined and used by your institution to flag this data row for any purpose.

credlook1

Credit Card Lookup1

char

This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row.

credlook2

Credit Card Lookup2

char

This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row.

credlook3

Credit Card Lookup3

char

This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row.

credtext

none

varchar/varchar2

255

This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

credjrnlfl

non-displaying

none

char

['N']

{'Y', 'N'}

This system-generated field is a flag indicating whether the transaction to which this data row is linked has ('Y') or has not ('N') been journaled. (System field)

credjrnldt

non-displaying

none

datetime/date

This system-generated field is used to hold the date on which the transaction to which this data row is linked was journaled (if ever). (System field)

credverif

non-displaying

none

char

This field is not used at this time.

credccnm

none

varchar/varchar2

150

This field holds the name as it appears on the credit card account. (for example, Jeffrey R. Shure)

credguid

non-displaying

none

char

Used by Sage Payment Solutions (SPS) - payment information stored in the ' Vault' is given a unique identifier to reference this stored data. This identifier is then recorded in this row. (System field)

credtender

non-displaying

tender

char

[' ']

The tender of the transaction to which this credit card row is linked. (System field).

credroute

Bank Routing Number

none

char

If tender of transaction is 'bank', this field holds the ABA bank routing number. On data entry, the format of the data for this field must conform to a valid ABA bank routing number.

credbnktype

Account Type

bank_account_type

char

[' ']

If the tender of the transaction is 'bank', the bank account type (Commercial Checking, Commercial Savings, Personal Checking, Personal Savings)

credbanknm

The Bank Name

none

varchar/varchar2

200

If the tender of the transaction is 'bank', the name of the banking institution from which this draft will be drawn. (for example, Bay Savings Bank)

credaddrl1

Address 1

none

varchar/varchar2

100

Line 1 of the billing address associated with this row.

credaddrl2

Address 2

none

varchar/varchar2

100

Line 2 of the billing address associated with this row.

credcity

City

none

char

City of the billing address associated with this row.

credstate

State

places

char

[' ']

State of the billing address associated with this row.

credcntry

Country

countries

char

[' ']

Country of the billing address associated with this row.

credzip

Zipcode

zipcodes

char

[' ']

Postal code of the billing address associated with this row.

credemail

none

char

200

email address associated with this row.

credmethod

Process Method

none

char

['M']

{'B' ,'R', 'M', 'V'}

The Sage Payment Solutions (SPS) Process Method. Choose Vault Only if payment account information is entered for historical purposes, or the type of giving transaction associated with this row is a pledge.

If the transaction associated with this row is a gift or pledge payment and your user has permission to use Real Time Sage Payment Solutions, Real Time will also be an available method from which to choose, and, in fact, will be the default method.

credprocdt

non-displaying

none

datetime/date

The date this row was processed by Sage Payment Solutions (SPS). (System field)

credstatus

non-displaying

none

char

[' ']

{' ','P','N'}

The values of this field will depend on the Process Method (credmethod). If the Process Method is Real Time (R), then this field can be 'P' for Processed. (System field)

credsave

Save for future use

none

char

['N']

{'N' or 'Y'}

Check if you want to save this row's payment information for future use. Uncheck if you do not want to save this row's payment information for future use. This feature will be available only if the 'Allow accounts to be saved for future use' system option setting is set to 'Yes'. This box will be Checked by default.

Payment information that is saved for future use is stored in the Sage Payment Solutions (SPS) 'Vault' and is assigned a unique identifier which will be stored in the credguid field of this row.

credlast4

Last 4 digits of Account

none

char

If tender of the transaction associated with this row is 'bank', this field holds the last 4 digits of the bank account number associated with the transaction linked to this row. If the tender is 'cc', this field holds the last 4 digits of the credit card number associated with the transaction linked to this row.

credacctty

Bank Account Type

none

char

[' ']

{'SAV', 'DDA',' '}

If tender of the transaction associated with this row is 'bank', is the account a checking account (DDA' is a Demand Deposit (checking) Account ) or a savings account ('SAV')?

credcustty

Customer Type

none

char

[' ']

{'TEL', 'ARC', 'RCK', 'WEB', 'PPD', 'CCD', ' '}

If tender of the transaction associated with this row is 'bank', this field holds the type of debit from the customer's bank account.

ARC - Accounts Receivable Conversion - A debit entry created from a customer check processed in a lockbox, drop box, or other payment receivable processing environment.

CCD - Cash Concentration or Disbursement - A debit entry to consolidate funds of that organization, from its branches, franchises or agents, or from other organizations; or to fund the accounts of its branches, franchises or agents, or of another organization

PPD - Prearranged Payment and Deposit - A one time authorization from a customer, to effect an electronic funds transfer, to or from a customer's bank account.

RCK - Returned Check Recovery - customer is re-presenting returned check (s) to the originating financial institution

TEL - Telephone Initiated Entry - An electronic debit from a customer's bank account based on oral authorization by phone.

WEB - An electronic debit from a customer's bank account created during a secure Internet session between a company and customer.

reference: http://www.chasepaymentech.com/gloglow.do

credssnum

Social Security #

none

char

240

The encrypted value of the Social Security number associated with this row.

creddstate

Drivers License State

places

char

The code of the state in which the driver's license is issued.

creddlnum

Drivers License Number

none

char

The driver license number associated with this row.

credbdate

Birth Date

none

datetime/date

The birthday associated with this row.

credhphone

Home Phone

none

char

The home phone number associated with this row.

credein

Fed. Tax ID (EIN)

none

char

The Federal Tax ID (EIN) associated with this row.

credamount

Amount

none

numeric/number

19, 4

This field holds the amount that will be charged to the credit card (if tender is 'cc') or debited to the bank account (if tender is 'bank').

credchckno

Check No

none

char

If the tender of the transaction associated with this row is 'bank', this field holds the check number associated with this row.

credexdate

none

datetime/date

Formatted credit card expiration date. Generated by the system, using a user-input expiration month and a user-input expiration year, and an expiration day of 01. Note that this is not an actual credit card expiration date and is used for reporting purposes only.

credref

non-displaying

none

char

Used by Sage Payment Solutions (SPS) - credit card and bank draft transactions that are successfully processed will be assigned this reference number by the system.

credmerid

none

char

Used by Sage Payment Solutions (SPS) - the id number for the merchant account associated with the purpose (from the Chart of Accounts) of the transaction to which this data row is linked.

credmerkey

non-displaying

none

char

Used by Sage Payment Solutions (SPS) - the key for the merchant account associated with the purpose (from the Chart of Accounts) of the transaction to which this data row is linked.

credvoidfl

non-displaying

none

char

{' ', 'v' ,'c'}

Used by Sage Payment Solutions (SPS) when this credit card or bank draft row has been successfully processed through SPS, and the transaction to which this data row is subsequently journaled (or journaled and corrected). This field will hold a 'v' or a 'c' to indicate that the credit card/bank draft charges have been reversed; if the constituent's credit card or bank account has already been debited, then the value of this field will be 'c'. If the credit card or bank account has yet to be debited, then the value of this field will be 'v'.

credvoiddt

non-displaying

none

datetime/date

Used by Sage Payment Solutions (SPS) - if this credit card or bank draft row has been successfully processed through SPS, and the transaction to which this data row is subsequently journaled (or journaled and corrected) this field will hold the date on which the credit card/bank draft charges were reversed.

credvoidrf

non-displaying

none

char

Used by Sage Payment Solutions (SPS) - if this credit card or bank draft row has been successfully processed through SPS, and the transaction to which this data row is subsequently journaled (or journaled and corrected), this field will hold the reference number that SPS assigned to the credit card/bank draft reversal transaction.

creddate3

none

datetime/date

This custom field may be defined and used by your institution to track any date information associated with this data row.

creddate4

none

datetime/date

This custom field may be defined and used by your institution to track any date information associated with this data row.

creddate5

none

datetime/date

This custom field may be defined and used by your institution to track any date information associated with this data row.

creddate6

none

datetime/date

This custom field may be defined and used by your institution to track any date information associated with this data row.

creddate7

none

datetime/date

This custom field may be defined and used by your institution to track any date information associated with this data row.

creddate8

none

datetime/date

This custom field may be defined and used by your institution to track any date information associated with this data row.

creddate9

none

datetime/date

This custom field may be defined and used by your institution to track any date information associated with this data row.

creddte10

none

datetime/date

This custom field may be defined and used by your institution to track any date information associated with this data row.

creddte11

none

datetime/date

This custom field may be defined and used by your institution to track any date information associated with this data row.

creddte12

none

datetime/date

This custom field may be defined and used by your institution to track any date information associated with this data row.

credmny3

none

money/number

(19,4)/(16,2)

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

credmny4

none

money/number

(19,4)/(16,2)

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

credmny5

none

money/number

(19,4)/(16,2)

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

credmny6

none

money/number

(19,4)/(16,2)

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

credmny7

none

money/number

(19,4)/(16,2)

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

credmny8

none

money/number

(19,4)/(16,2)

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

credmny9

none

money/number

(19,4)/(16,2)

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

credmny10

none

money/number

(19,4)/(16,2)

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

credmny11

none

money/number

(19,4)/(16,2)

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

credmny12

none

money/number

(19,4)/(16,2)

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

crednum3

none

numeric/number

10, 0

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

crednum4

none

numeric/number

10, 0

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

crednum5

none

numeric/number

10, 0

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

crednum6

none

numeric/number

10, 0

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

crednum7

none

numeric/number

10, 0

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

crednum8

none

numeric/number

10, 0

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

crednum9

none

numeric/number

10, 0

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

crednum10

none

numeric/number

10, 0

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

crednum11

none

numeric/number

10, 0

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

crednum12

none

numeric/number

10, 0

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

credchk1

none

char

['N']

{'N' or 'Y'}

This custom field may be defined and used by your institution to flag this data row for any purpose.

credchk2

none

char

['N']

{'N' or 'Y'}

This custom field may be defined and used by your institution to flag this data row for any purpose.

credchk3

none

char

['N']

{'N' or 'Y'}

This custom field may be defined and used by your institution to flag this data row for any purpose.

credchk4

none

char

['N']

{'N' or 'Y'}

This custom field may be defined and used by your institution to flag this data row for any purpose.

credchk5

none

char

['N']

{'N' or 'Y'}

This custom field may be defined and used by your institution to flag this data row for any purpose.

credchk6

none

char

['N']

{'N' or 'Y'}

This custom field may be defined and used by your institution to flag this data row for any purpose.

credchk7

none

char

['N']

{'N' or 'Y'}

This custom field may be defined and used by your institution to flag this data row for any purpose.

credchk8

none

char

['N']

{'N' or 'Y'}

This custom field may be defined and used by your institution to flag this data row for any purpose.

credchk9

none

char

['N']

{'N' or 'Y'}

This custom field may be defined and used by your institution to flag this data row for any purpose.

credchk10

none

char

['N']

{'N' or 'Y'}

This custom field may be defined and used by your institution to flag this data row for any purpose.

credtxt1

none

varchar/varchar2

255

This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

credtxt2

none

varchar/varchar2

255

This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

credtxt3

none

varchar/varchar2

255

This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

credtxt4

none

varchar/varchar2

255

This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

credtxt5

none

varchar/varchar2

255

This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

credtxt6

none

varchar/varchar2

255

This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

credtxt7

none

varchar/varchar2

255

This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

credtxt8

none

varchar/varchar2

255

This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

credtxt9

none

varchar/varchar2

255

This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

credtxt10

none

varchar/varchar2

255

This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

credfirst6

none

varchar

Used by Sage Payment Solutions (SPS) - the first six digits of the credit card.

credspsid

none

varchar

Used by Sage Payment Solutions (SPS) - the SPS ID.

credmasked

none

varchar

Used by Sage Payment Solutions (SPS) - the full, masked credit card number, including the first six and last four digits of the card, plus asterisks for the missing numbers.

credmkey

none

Numeric

13,9

Used by Sage Payment Solutions (SPS) - the SPS mkey associated with the row.

credinitum

Initium Status

none

char

[null]

{' ','O','V'}

This column displays the status of the address if your organization uses Initium Instant Address. It contains a single character that indicates whether the address has been validated or overridden, as follows:

O - Overridden

V - Validated

Blank - no status

credinitds

non-displaying

none

char

['']

{'','E','T','M','S',
'U','F','P'}

This field is available for use with Initium Instant Address. It contains a single character that describes the detail status of the address as follows:

E - Exact

T - Tentative

M - Multiple

S - Secondary

U - Unmatched

F - Foreign

P - Primary

Blank - No detail status

credindate

Initium verification date

none

datetime

This field specifies the last date and time that the address was validated using Initium Instant Address.

credinitvr

Initium verification Info

none

varchar

This field contains the verification information returned from Initium for the address, if any.

Indices - Credit Card

Index	Primary	Unique	Fields	Sort
pk_creditcard	Y	Y	credkey	ASC
creditcard02			credid	ASC
creditcard03			credlnkfil, credlnkkey	ASC
credicard04			credguid	ASC
creditcard05			credref	ASC
creditcard06			credmerkey	ASC

Top of Page