Knowledge Base

Version 11.5 Data Files


Membership
 
ATDATA Attendance
BGCHECK Background Check history
MA Family Mailing List
MACODES Family Mailing List codes
MAINFO Family Mailing List preferences
ME Personal Profiles
MECODES Personal Profile codes
MECONNECT Automated Messaging preferences (Version 11.55)
MECONTLOG Membership Contact Log
MECONTLOGD Contact Log Details
MECONTLOGE Contact Log Errors
MEINFO Personal Profile preferences
MI Ministry Services
SK Activities & Skills
SKCODES Activities & Skills codes
SKGCAL Google Calendar Sync reference
SKINFO Activities & Skills preferences
SKREF Activities & Skills descriptions
SKSERV Offices Served
VI Visitations
VICODES Visitations codes
 
Accounting
 
APAUTO Accounts Payable repeating items
APAUTOD Accounts Payable repeating items detail
APCHECK Accounts Payable open computer generated checks
APINFO Accounts Payable preferences
APOPEN Accounts Payable open items
APOPEND Accounts Payable open items detail
APPAID Accounts Payable posted items
APPAIDD Accounts Payable posted items detail
APVEND Accounts Payable vendors
ARAUTO Accounts Receivable repeating items
ARCUST Accounts Receivable customers
ARINFO Accounts Receivable preferences
ARITEMS Accounts Receivable defined items
AROPEN Accounts Receivable open items
ARPAID Accounts Receivable posted items
FAACCTS Fund Accounting - Fund specific accounts (9 digits)
FABUDGET Budget information
FAFUNDS Accounting Funds
FAINFO Fund Accounting preferences
FAMAJOR Major accounts (7 digits)
FAMSTR Posted transactions
FAMSTRD Posted transactions detail
FAPOST Posting reference
FAPREVYR Previous year balances
FAPRIOR Prior year balances
FARECON Bank reconciliation reference
FAREPEAT Repeating transactions
FAREPEATD Repeating transactions detail
FARSCTD Donor restrictions
FATRANS Unposted transactions
FATRANSD Unposted transactions detail
PRAP Payroll A/P reference
PRCODES Payroll codes
PRDESC Payroll item descriptions
PRDESCT Payroll item tax types
PREMPL Payroll employees
PRGROUP Payroll pay groups
PRHIST Payroll salary history
PRINFO Payroll preferences
PRITEMS Payroll employee pay items
PRLEAVE Payroll time off
PRPAID Payroll transactions
PRPAIDD Payroll transaction detail
PRPOST Payroll posting reference
PRPROC Payroll batch reference
PRTABLES Payroll tax tables
PRTAXES Payroll tax types
PRW2 Payroll W2 reference
 
Contributions
 
CO Posted Contributions
COAUTO Repeating contributions
COCODES Contributions codes
COFUND Contribution fund descriptions
COINFO Contribution preferences
COMEM Contribution designations
COO Online contributions providers
COOENV Online contributions envelope links
COOFUND Online contribution fund links
COOPP Online contributions - Paperless Payments
COPLED Pledges
COPOST Contribution postings
CORECEIPT Canadian Tax Receipt log
CORECEIPTD Canadian Tax Receipt detail
COSCAN Scanned check data
COTRANS Unposted Contributions
 
Events
 
EVCODES Events codes
EVDEFTASK Predefined tasks
EVEQLINK Links to Equipment Inventory
EVEVENTS Events
EVGCAL Events - Google Calendar sync reference
EVINFO Events preferences
EVOCC Event occurrences
EVROOMLAYOUT Room layouts
EVROOMLINK Link rooms to events
EVROOMS Rooms
EVSKLINK Link Activities & Skills to events
EVTASKLINK Links tasks to people
EVTASKS Events tasks
 
Record Keeping
 
ED Education Library
EQ Equipment Inventory descriptions
EQCODES Equipment Inventory codes
EQD Equipment Inventory item details
EQINFO Equipment Inventory preferences
MU Music Library
SE Sermon Filer
 
Check In
 
CKBAG Check In bags
CKHISTORY Check In details
CKIN Check Ins
CKINCIDENT Check In incident notes
CKINFO Check In preferences
CKLINK Check In bar code link
CKOUT Check Outs

Created: 10/10/2011
Last updated: 04/21/2015