SITES

0 rows


Description

Organization’s sites. Can be used in various joins E.g. Activity Site, Revenue Site, Transaction Site

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ACTIVE_HUB_KEY int 4 null

The Hub record ID
SITE_ID int 4 √ null
ACCOUNT_CREDIT_HISTORY.SITE_ID Defined in XML R
ACTIVITIES.SITE_ID Defined in XML R
ACTIVITY_PRIVATE_LESSONS.TRANSACTION_SITE_ID Defined in XML R
AR_SCHEDULED_DETAILS.REVENUE_SITE_ID Defined in XML R
AR_SCHEDULED_DETAILS.TRANSACTION_SITE_ID Defined in XML R
AR_SCHEDULED_HEADERS.SITE_ID Defined in XML R
CAMPAIGNS.SITE_ID Defined in XML R
CENTERS.SITE_ID Defined in XML R
CHARGE_QUALIFICATION_LINKS.ACTIVITY_SITE_ID Defined in XML R
CHARGES.SITE_ID Defined in XML R
CHILD_WATCH_REGISTRATIONS.SITE_ID Defined in XML R
CHILD_WATCH_ROOMS.SITE_ID Defined in XML R
COMPANIES.SITE_ID Defined in XML R
CREDIT_CARD_PROCESSING_LOG.SITE_ID Defined in XML R
CUSTOM_QUESTIONS.SITE_ID Defined in XML R
CUSTOMER_NOTES.SITE_ID Defined in XML R
CUSTOMERS.SITE_ID Defined in XML R
DEFERRED_REVENUE_PROJECTIONS.REVENUE_SITE_ID Defined in XML R
DEFERRED_REVENUE_PROJECTIONS.TRANSACTION_SITE_ID Defined in XML R
DISCLAIMERS.SITE_ID Defined in XML R
EQUIPMENT_CATEGORIES.SITE_ID Defined in XML R
EVENT_TYPES.SITE_ID Defined in XML R
FACILITY_RESERVATION.SITE_ID Defined in XML R
FACILITY_RESERVATION.TRANSACTION_SITE_ID Defined in XML R
FACILITY_TYPES.SITE_ID Defined in XML R
FROM_EMAIL_ADDRESSES.SITE_ID Defined in XML R
GIFT_CARD_TYPE_SITES.SITE_ID Defined in XML R
GLACCOUNTS.SITE_ID Defined in XML R
INSTRUCTORS.SITE_ID Defined in XML R
LEAGUES.SITE_ID Defined in XML R
LOCKER_SCHEDULES.SITE_ID Defined in XML R
MEMBERSHIP_AUDIT_LOG.SITE_ID Defined in XML R
MEMBERSHIP_USAGE.SITE_ID Defined in XML R
MEMBERSHIPS.PACKAGE_SITE_ID Defined in XML R
OFFICIALS.SITE_ID Defined in XML R
PACKAGES.SITE_ID Defined in XML R
PERMITS.SITE_ID Defined in XML R
POS_PRODUCTS.SITE_ID Defined in XML R
POS_PRODUCTS_CENTER_QUANTITY.SITE_ID Defined in XML R
POS_SALES_DETAILS.PRODUCT_SITE_ID Defined in XML R
POS_SALES_DETAILS.TRANSACTION_SITE_ID Defined in XML R
PRELIMINARY_DRAFTS.REVENUE_SITE_ID Defined in XML R
PREP_CODES.SITE_ID Defined in XML R
PROGRAMS.SITE_ID Defined in XML R
RECEIPT_DETAILS.REVENUE_SITE_ID Defined in XML R
RECEIPT_DETAILS.TRANSACTION_SITE_ID Defined in XML R
RECEIPT_GL_POSTINGS.REVENUE_SITE_ID Defined in XML R
RECEIPT_GL_POSTINGS.TRANSACTION_SITE_ID Defined in XML R
RECEIPT_HEADERS.SITE_ID Defined in XML R
RECEIPT_PAYMENTS.SITE_ID Defined in XML R
REPORT_DEFINITIONS.SITE_ID Defined in XML R
RESERVATION_GROUPS.SITE_ID Defined in XML R
SEASONS.SITE_ID Defined in XML R
SESSIONS.SITE_ID Defined in XML R
SKIP_DATES.SITE_ID Defined in XML R
STAGES.SITE_ID Defined in XML R
STANDARD_CHARGES.SITE_ID Defined in XML R
SUPERVISORS.SITE_ID Defined in XML R
TRANSACTIONS.REVENUE_SITE_ID Defined in XML R
TRANSACTIONS.TRANSACTION_SITE_ID Defined in XML R
UPLOADED_FILES.SITE_ID Defined in XML R
USAGE_FEES.SITE_ID Defined in XML R
WORKSTATIONS.SITE_ID Defined in XML R

Site ID
SITE_NAME varchar 255 √ null

Site Name
ADDRESS1 varchar 255 √ null

The first address line of the site.
ADDRESS2 varchar 255 √ null

The second address line of the site.
CITY varchar 255 √ null

The city of the site.
STATE varchar 255 √ null

The state of the site.
ZIPCODE varchar 255 √ null

The zip code of the site.
LAST_SYNC_TIME datetime 16,3 null

Date and time Hub record was last modified
ACTIVE_HUB_PROCESS_ID bigint 8 √ null

The Hub sync process ID
GEOGRAPHIC_AREA varchar 80 √ null

Geographic Area description
ORG_ID int 4 √ null

Your organization’s unique identifier in the Active Net system
GEOGRAPHIC_AREA_ID int 4 √ null
GEOGRAPHIC_AREAS.GEOGRAPHIC_AREA_ID Defined in XML R

Geographic Area ID
EMAIL_FROM_ADDRESS varchar 50 √ null

From email address
PHONE1 varchar 50 √ null

Primary phone number
PHONE2 varchar 50 √ null

Secondary phone number
PHONE3 varchar 50 √ null

Fax phone number
TAX_NAME_1 varchar 100 √ null

Tax name for tax 1
TAX_NAME_2 varchar 100 √ null

Tax name for tax 2
TAX_NAME_3 varchar 100 √ null

Tax name for tax 3
TAX_NAME_4 varchar 100 √ null

Tax name for tax 4
TAX_NAME_5 varchar 100 √ null

Tax name for tax 5
TAX_NAME_6 varchar 100 √ null

Tax name for tax 6
TAX_NAME_7 varchar 100 √ null

Tax name for tax 7
TAX_NAME_8 varchar 100 √ null

Tax name for tax 8
TAX_RATE_1 money 21,4 √ null

Tax rate for tax 1
TAX_RATE_2 money 21,4 √ null

Tax rate for tax 2
TAX_RATE_3 money 21,4 √ null

Tax rate for tax 3
TAX_RATE_4 money 21,4 √ null

Tax rate for tax 4
TAX_RATE_5 money 21,4 √ null

Tax rate for tax 5
TAX_RATE_6 money 21,4 √ null

Tax rate for tax 6
TAX_RATE_7 money 21,4 √ null

Tax rate for tax 7
TAX_RATE_8 money 21,4 √ null

Tax rate for tax 8
TAX_GLACCOUNT_ID_1 int 4 √ null
GLACCOUNTS.GLACCOUNT_ID Defined in XML R

GL Account ID for tax 1
TAX_GLACCOUNT_ID_2 int 4 √ null
GLACCOUNTS.GLACCOUNT_ID Defined in XML R

GL Account ID for tax 2
TAX_GLACCOUNT_ID_3 int 4 √ null
GLACCOUNTS.GLACCOUNT_ID Defined in XML R

GL Account ID for tax 3
TAX_GLACCOUNT_ID_4 int 4 √ null
GLACCOUNTS.GLACCOUNT_ID Defined in XML R

GL Account ID for tax 4
TAX_GLACCOUNT_ID_5 int 4 √ null
GLACCOUNTS.GLACCOUNT_ID Defined in XML R

GL Account ID for tax 5
TAX_GLACCOUNT_ID_6 int 4 √ null
GLACCOUNTS.GLACCOUNT_ID Defined in XML R

GL Account ID for tax 6
TAX_GLACCOUNT_ID_7 int 4 √ null
GLACCOUNTS.GLACCOUNT_ID Defined in XML R

GL Account ID for tax 7
TAX_GLACCOUNT_ID_8 int 4 √ null
GLACCOUNTS.GLACCOUNT_ID Defined in XML R

GL Account ID for tax 8
TAX_ABSORBED_1 varchar 5 √ null

Whether tax 1 is included in the fee (Yes/No)
TAX_ABSORBED_2 varchar 5 √ null

Whether tax 2 is included in the fee (Yes/No)
TAX_ABSORBED_3 varchar 5 √ null

Whether tax 3 is included in the fee (Yes/No)
TAX_ABSORBED_4 varchar 5 √ null

Whether tax 4 is included in the fee (Yes/No)
TAX_ABSORBED_5 varchar 5 √ null

Whether tax 5 is included in the fee (Yes/No)
TAX_ABSORBED_6 varchar 5 √ null

Whether tax 6 is included in the fee (Yes/No)
TAX_ABSORBED_7 varchar 5 √ null

Whether tax 7 is included in the fee (Yes/No)
TAX_ABSORBED_8 varchar 5 √ null

Whether tax 8 is included in the fee (Yes/No)
TAX_ORIGIN_1 varchar 50 √ null

The origin of the state/province for tax 1
TAX_ORIGIN_2 varchar 50 √ null

The origin of the state/province for tax 2
TAX_ORIGIN_3 varchar 50 √ null

The origin of the state/province for tax 3
TAX_ORIGIN_4 varchar 50 √ null

The origin of the state/province for tax 4
TAX_ORIGIN_5 varchar 50 √ null

The origin of the state/province for tax 5
TAX_ORIGIN_6 varchar 50 √ null

The origin of the state/province for tax 6
TAX_ORIGIN_7 varchar 50 √ null

The origin of the state/province for tax 7
TAX_ORIGIN_8 varchar 50 √ null

The origin of the state/province for tax 8
TAX_TABLE_ID_1 int 4 √ null

The ID from the tax table for tax 1
TAX_TABLE_ID_2 int 4 √ null

The ID from the tax table for tax 2
TAX_TABLE_ID_3 int 4 √ null

The ID from the tax table for tax 3
TAX_TABLE_ID_4 int 4 √ null

The ID from the tax table for tax 4
TAX_TABLE_ID_5 int 4 √ null

The ID from the tax table for tax 5
TAX_TABLE_ID_6 int 4 √ null

The ID from the tax table for tax 6
TAX_TABLE_ID_7 int 4 √ null

The ID from the tax table for tax 7
TAX_TABLE_ID_8 int 4 √ null

The ID from the tax table for tax 8

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views