These tables are copied nightly via BCP from the actual Core data into the ReportALTA database (Report Server).
Accounting
These tables stored all aspects of accounting and purchasing, including very detailed information in InvoiceOrder + LineItem + LineItemDetails.
- Accounts
- Balance
- Batch
- BatchSummary
- BusinessUnit
- Credit
- FiscalPeriod
- InvoiceOrder
- Ledger
- LineItem
- LineItemAmount
- Merchant
- Payment
- PaymentMethod
- Refund
App
These tables have all Custom Field and Note data. Custom Fields can be either "global" (one value per ind/org) or "itemized" (different values each "linked" to a specific product purchase).
- CustomField
- CustomFieldAvailableValue
- NoteCategory
- Notes
Crm
These tables contain the actual data for all constituent information, inds, orgs, relationships, etc.
- Award
- Category
- Certificants
- CommitteeMember
- ContactImage
- Country
- Currency
- CustomerActivityLog
- CustomerAddress
- CustomerCategory
- CustomerDescription
- CustomerEmail
- CustomerJobRole
- CustomerLanguage
- CustomerLink
- CustomerPhone
- CustomFieldValue
- CustomFieldValueLog
- Guest
- InactiveCertificants
- InactiveMembership
- Individual
- IndividualDesignation
- MembershipBenefit
- MembershipLog
- Organization
- RelatedContact
- Room
- SolicitationPermission
- SourceCode
- StateProvince
- Subscribers
- Venue
Purchase
These built in tables "flatten" booths and event registrations, but full details still must be pulled from Accounting.
- ExhibitorBooth
- RegistrationPurchase
Shopping
These tables contain all product information and details, all types, but not the actual purchase information.
- Cart
- Discount
- Event
- Exam
- Exhibit
- ExhibitBooth
- Fund
- Membership
- Merchandise
- Miscellaneous
- Price
- PriceSplit
- ProductCategory
- ProductEducationCredit
- ProductFileUrl
- Publication
- RegistrationProductVenue
- Session
- Shipping
- Sponsorship
- Subscription