COMPANIES

0 rows


Description

Company details

Columns

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

The Hub record ID
COMPANY_ID int 4 √ null
ACCOUNT_CREDIT_HISTORY.COMPANY_ID Defined in XML R
AR_SCHEDULED_DETAILS.PAYER_COMPANY_ID Defined in XML R
AR_SCHEDULED_DETAILS.TRANSACTION_COMPANY_ID Defined in XML R
AR_SCHEDULED_HEADERS.PAYER_COMPANY_ID Defined in XML R
COMPANIES.PARENT_COMPANY_ID Defined in XML R
COMPANY_AUTHORIZED_AGENTS.COMPANY_ID Defined in XML R
COUPON_QUALIFICATIONS.COMPANY_ID Defined in XML R
COUPON_USAGE.COMPANY_ID Defined in XML R
CREDIT_CARD_PROCESSING_LOG.COMPANY_ID Defined in XML R
CUSTOMER_THIRD_PARTY_BILLINGS.PAYER_COMPANY_ID Defined in XML R
DEFERRED_REVENUE_PROJECTIONS.COMPANY_ID Defined in XML R
FACILITY_RESERVATION.COMPANY_ID Defined in XML R
GIFT_CARDS.COMPANY_ID Defined in XML R
INSTRUCTORS.COMPANY_ID Defined in XML R
LEAGUE_CONTACTS.COMPANY_ID Defined in XML R
MEMBERSHIPS.TPB_COMPANY_ID Defined in XML R
PERMITS.COMPANY_ID Defined in XML R
POS_PRODUCTS.LAST_VENDOR_COMPANY_ID Defined in XML R
PRELIMINARY_DRAFTS.PAYER_COMPANY_ID Defined in XML R
RECEIPT_PAYMENTS.COMPANY_ID Defined in XML R
SAVED_CREDIT_CARD_HISTORY.COMPANY_ID Defined in XML R
SAVED_CREDIT_CARDS.COMPANY_ID Defined in XML R
TEAM_CONTACTS.COMPANY_ID Defined in XML R
TRANSACTIONS.COMPANY_ID Defined in XML R

Company’s ID
COMPANY_NAME varchar 255 √ null

Company’s name
PARENT_COMPANY_ID int 4 √ null
COMPANIES.COMPANY_ID Defined in XML R

Parent company’s ID
ADDRESS1 varchar 255 √ null

Company’s address 1
ADDRESS2 varchar 255 √ null

Company’s address 2
CITY varchar 255 √ null

Company’s address city
STATE_PROVINCE varchar 255 √ null

Company’s address state or province
ZIP_POSTALCODE varchar 255 √ null

Company’s zip or postal code
COUNTY varchar 255 √ null

Company’s county
COUNTRY varchar 255 √ null

Company’s country
PHONE1 varchar 255 √ null

Company’s first phone
PHONE2 varchar 255 √ null

Company’s second phone
PHONE3 varchar 255 √ null

Company’s third phone
EMAIL varchar 255 √ null

Company’s email address
WEBSITE varchar 255 √ null

Company’s web site address
SPECIAL_HANDLING varchar 5 √ null

Whether the company needs special handling (Yes / No)
ALLOW_THIRD_PARTY_BILLING varchar 5 √ null

Whether the company can be used for third party billing (Yes / No)
IS_VENDOR varchar 5 √ null

Whether the company is a vendor (Yes / No)
PAYMENT_TERMS varchar 255 √ null

Company’s payment terms
LIGHTING_PIN varchar 255 √ null

Company’s PIN for lighting integration
AGREE_RECEIVE_EMAIL varchar 5 √ null

Whether the company agreed to receive emails
AGREE_RECEIVE_POSTAL_MAIL varchar 5 √ null

Whether the company agreed to receive postal mail
RETIRED_STATUS varchar 7 √ null

Company’s retired status (Retired / Active)
LAST_SYNC_TIME datetime 16,3 (getdate())

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

The Hub sync process ID
ORG_ID int 4 √ null

Your organization’s unique identifier in the Active Net system
BALANCE_DUE money 21,4 √ null

The current balance due for this company.
CUSTOMER_TYPE_ID int 4 √ null
CUSTOMER_TYPES.CUSTOMER_TYPE_ID Defined in XML R

The customer type ID of the company
GEOGRAPHIC_AREA_ID int 4 √ null
GEOGRAPHIC_AREAS.GEOGRAPHIC_AREA_ID Defined in XML R

The geographic area ID of the company
SITE_ID int 4 √ null
SITES.SITE_ID Defined in XML R

The site ID to which the company belongs
ROW_VERSION binary 8 √ null

System timestamp (for internal use)

Indexes

Constraint Name Type Sort Column(s)
COMPANIES_ACTIVE_HUB_KEY_PK Primary key Asc ACTIVE_HUB_KEY
COMPANIES_COMPANY_ID_ORG_ID_UQ Must be unique Asc/Asc COMPANY_ID + ORG_ID
COMPANIES_CUSTOMER_TYPE_ID_IX Performance Asc CUSTOMER_TYPE_ID
COMPANIES_GEOGRAPHIC_AREA_ID_IX Performance Asc GEOGRAPHIC_AREA_ID
COMPANIES_PARENT_COMPANY_ID_IX Performance Asc PARENT_COMPANY_ID
COMPANIES_ROW_VERSION_IX Performance Asc ROW_VERSION
COMPANIES_SITE_ID_IX Performance Asc SITE_ID

Relationships

Close relationships within degrees of separation