Knowledge Base

Version 12/12.2 Data Files


Membership
 
ATDATA Attendance Detail
ATDATAC Attendance Additional Present Counts
BGCHECK Background Check history
CCSYNC Constant Contact Sync history
CCSYNCD Constant Contact Sync history details
MA Family Mailing List
MACODES Family Mailing List codes
MAINFO Family Mailing List preferences
MAMINFO 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
MEMINFO Personal Profile preferences
MI Ministry Services
MICODES Service Types
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
APCODES Accounts Payable vendor types
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
ARAPPLY Accounts Receivable credit memo applications
ARAUTO Accounts Receivable repeating items
ARAUTOD Accounts Receivable repeating items detail
ARCODES Accounts Receivable customer types
ARCREDIT Accounts Receivable credit memos
ARCUST Accounts Receivable customers
ARINFO Accounts Receivable preferences
ARINV Accounts Receivable invoices
ARINVD Accounts Receivable invoice details
ARITEMS Accounts Receivable defined items
ARMINFO Accounts Receivable preferences
ARPMT Accounts Receivable payments
ARPMTD Accounts Receivable payment details
ARPMTMETH Accounts Receivable payment methods
ARPOST Accounts Receivable posting details
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
PRMINFO Payroll preferences
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
PRW3 Payroll W3 reference
 
Contributions
 
CO Posted Contributions
COAUTO Repeating contributions
COCODES Contributions codes
COFUND Contribution fund descriptions
COINFO Contribution preferences
COMEM Contribution designations
COMINFO Contribution preferences
COO Online contributions providers
COOENV Online contributions envelope links
COOFUND Online contribution fund links
COOPP Not used
COOTRANS Vanco transactions in progress
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
EVMINFO 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
EDINFO Education Library preferences
EQ Equipment Inventory descriptions
EQCODES Equipment Inventory codes
EQD Equipment Inventory item details
EQINFO Equipment Inventory preferences
MU Music Library
MUCODES Music Library codes
MUINFO Music Library preferences
SE Sermon Filer
SEINFO Sermon Filer preferences
 
System Files
 
PCAUTO Autocomplete entries (all modules)
PCDICT Spellcheck dictionary (all modules)
PCINFO System preferences
PCINFO1 System preferences
PCINFO2 System preferences
PCINFO3 System preferences
PCMINFO System preferences
PCQTASK Quick Task menus
PCQTASKD Quick Task menu items
PCUINFO User preferences
PCUMINFO User preferences
PCUSERLINK Link user to Personal Profile
 
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/30/2017
Last updated: 07/25/2021