TRANSACTIONS

0 rows


Description

Posted transaction data

Columns

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

The Hub record ID
TRANSACTION_ID int 4 √ null
ACTIVITY_ENROLLMENTS.REGISTRATION_TRANSACTION_ID Defined in XML R
ACTIVITY_ENROLLMENTS.ROOT_TRANSACTION_ID Defined in XML R
ACTIVITY_ENROLLMENTS.TRANSACTION_ID Defined in XML R
ACTIVITY_PRIVATE_LESSONS.ROOT_TRANSACTION_ID Defined in XML R
ACTIVITY_PRIVATE_LESSONS.TRANSACTION_ID Defined in XML R
COUPON_USAGE.TRANSACTION_ID Defined in XML R
CUSTOM_QUESTION_ANSWERS.ROOT_TRANSACTION_ID Defined in XML R
CUSTOM_QUESTION_ANSWERS.TRANSACTION_ID Defined in XML R
CUSTOMER_THIRD_PARTY_BILLING_LINKS.TRANSACTION_ID Defined in XML R
DEFERRED_REVENUE_PROJECTIONS.ORIGINAL_TRANSACTION_ID Defined in XML R
LOCKER_SCHEDULES.TRANSACTION_ID Defined in XML R
MEMBERSHIP_AUDIT_LOG.TRANSACTION_ID Defined in XML R
POS_SALES_DETAILS.TRANSACTION_ID Defined in XML R
PROGRAM_REGISTRATIONS.TRANSACTION_ID Defined in XML R
RECEIPT_DETAILS.ORIGINAL_TRANSACTION_ID Defined in XML R
RECEIPT_DETAILS.TRANSACTION_ID Defined in XML R
RECEIPT_GL_POSTINGS.TRANSACTION_ID Defined in XML R
TEAM_PLAYERS.TRANSACTION_ID Defined in XML R
TEAMS.TRANSACTION_ID Defined in XML R
TRANSACTION_STAGES.TRANSACTION_ID Defined in XML R
TRANSACTIONS.ADDITIONAL_TRANSACTION_ID Defined in XML R
TRANSACTIONS.LINKED_TRANSACTION_ID Defined in XML R
TRANSACTIONS.ORIGINAL_TRANSACTION_ID Defined in XML R
TRANSACTIONS.ROLLOVER_TRANSACTION_ID Defined in XML R
TRANSACTIONS.ROOT_TRANSACTION_ID Defined in XML R

Transaction ID
RECEIPT_HEADER_ID int 4 √ null
RECEIPT_HEADERS.RECEIPT_HEADER_ID Defined in XML R

ID of the receipt header that the transaction belongs to
CREATION_DATE_TIME datetime 16,3 √ null

Date and time that the transaction was created
LAST_UPDATED_DATE_TIME datetime 16,3 √ null

Date and time that the transaction was last updated
TRANSACTION_SITE_ID int 4 √ null
SITES.SITE_ID Defined in XML R

ID of the site where the transaction was created
REVENUE_SITE_ID int 4 √ null
SITES.SITE_ID Defined in XML R

ID of the site for the item that the transaction is for
WORKSTATION_ID int 4 √ null
WORKSTATIONS.WORKSTATION_ID Defined in XML R

ID of the workstation where the transaction was created
SYSTEMUSER_ID int 4 √ null
SYSTEM_USERS.SYSTEMUSER_ID Defined in XML R

ID of the user who created the transaction
CASH_SUMMARY_SHEET_ID int 4 √ null

ID of the cash summary sheet that was active on the workstation when the transaction was created
MODULE_NAME varchar 20 √ null

The system module that the transaction belongs to
TRANSACTION_TYPE_ID int 4 √ null

The transaction type ID of the transaction
ORIGINAL_TRANSACTION_TYPE_ID int 4 √ null

The original transaction type ID of the transaction
ORIGINAL_TRANSACTION_ID int 4 √ null
TRANSACTIONS.TRANSACTION_ID Defined in XML R

The original transaction ID for a series of transactions
ROOT_TRANSACTION_ID int 4 √ null
TRANSACTIONS.TRANSACTION_ID Defined in XML R

The root transaction ID for a chain of transactions
LINKED_TRANSACTION_ID int 4 √ null
TRANSACTIONS.TRANSACTION_ID Defined in XML R

A linked transaction ID for a related transaction if applicable
ADDITIONAL_TRANSACTION_ID int 4 √ null
TRANSACTIONS.TRANSACTION_ID Defined in XML R

An additional transaction ID for a related transaction if applicable
CUSTOMER_ID int 4 √ null
CUSTOMERS.CUSTOMER_ID Defined in XML R

ID of the customer who is the participant of the transaction
COMPANY_ID int 4 √ null
COMPANIES.COMPANY_ID Defined in XML R

ID of the company who is the owner of the transaction if applicable
APPLIED_AMOUNT money 21,4 √ null

The total payment amount applied to the transaction
CREDIT_CARD_AMOUNT money 21,4 √ null

The credit card payment amount applied to the transaction
ECP_AMOUNT money 21,4 √ null

The electronic check processing payment amount applied to the transaction
PREFUND_AMOUNT_USED money 21,4 √ null

Total prefund amount used for this transaction
QUANTITY int 4 √ null

The quantity applicable to this transaction
EVENT_NAME varchar 200 √ null

The event or item description for this transaction
STAFF_NOTES varchar 8000 √ null

Staff notes entered for this transaction
CUSTOMER_NOTES varchar 8000 √ null

Customer notes entered for this transaction
EFFECTIVE_DATE_TIME datetime 16,3 √ null

The effective date and time related to this transaction
PRORATE_EFFECTIVE_DATE date 20 √ null

The proration date applied to this transaction
ACTIVITY_ID int 4 √ null
ACTIVITIES.ACTIVITY_ID Defined in XML R

The activity ID if this transaction is related to an activity
WAITLIST_RANK int 4 √ null

The customer’s waitlist rank for waitlist transactions
PRIVATE_LESSON_GROUP_ID int 4 √ null

The private lesson group ID for the enrollment
MAX_PRIVATE_LESSON_BOOKINGS int 4 √ null

The number of private lessons included in the enrollment
RESERVATION_PERIOD_UNIT varchar 20 √ null

Default reservation period (Use Default / Minute / Hour / Day / Week / Month / Defined Date Range / Rental Block / Overnight)
PASS_OR_FAIL varchar 4 √ null

The pass or fail status if a grade has been entered that designates pass or fail (pass / fail)
PASS_OR_FAIL_DATE date 20 √ null

The date that the pass or fail status was entered
PASS_OR_FAIL_PERCENTAGE money 21,4 √ null

The pass or fail percentage if one has been entered
PASS_OR_FAIL_GRADE_ID int 4 √ null
ACTIVITY_PASS_FAIL_GRADES.ACTIVITY_PASS_FAIL_GRADE_ID Defined in XML R

The pass or fail grade ID that has been entered
DEPOSIT_PAYOFF_AMOUNT money 21,4 √ null

The amount required to pay off a specified deposit
ROLLOVER_TRANSACTION_ID int 4 √ null
TRANSACTIONS.TRANSACTION_ID Defined in XML R

The transaction ID created when this enrollment was rolled over
PROGRAM_ID int 4 √ null
PROGRAMS.PROGRAM_ID Defined in XML R

The program ID if this transaction is related to a daycare program
SESSION_ID int 4 √ null
SESSIONS.SESSION_ID Defined in XML R

The session ID if this transaction is related to a daycare program session
PACKAGE_ID int 4 √ null
PACKAGES.PACKAGE_ID Defined in XML R

The package ID if this transaction is related to a membership
MEMBERSHIP_ID int 4 √ null

The membership ID if this transaction is related to a membership
EXPIRATION_DATE date 20 √ null

The expiration date if this transaction is related to a membership sale or renewal
MAX_USES int 4 √ null

The max uses purchased for a punch pass membership package
FACILITY_ID int 4 √ null
FACILITIES.FACILITY_ID Defined in XML R

The facility ID if this transaction is related to a reservation or private lesson
PERMIT_ID int 4 √ null
PERMITS.PERMIT_ID Defined in XML R

The permit ID if this transaction is related to a reservation
RESERVATION_TYPE varchar 10 √ null

The reservation type (Regular / Continuous)
EVENT_TYPE_ID int 4 √ null
EVENT_TYPES.EVENT_TYPE_ID Defined in XML R

The event type ID if this transaction is related to a reservation
SCHEDULE_TYPE_ID int 4 √ null
SCHEDULE_TYPES.SCHEDULE_TYPE_ID Defined in XML R

The schedule type ID if this transaction is related to a reservation
PREP_CODE_ID int 4 √ null
PREP_CODES.PREP_CODE_ID Defined in XML R

The prep code ID if this transaction is related to a reservation
NON_EXCLUSIVE_EVENT varchar 5 √ null

Whether the reservation associated with this transaction is a non-exclusive event (Yes/No)
LOCKER_ID int 4 √ null

The locker ID if this transaction is related to a locker reservation
COMBINATION_LOCK_ID int 4 √ null

The combination lock ID if this transaction is related to a locker reservation
LOCKER_COMBINATION varchar 10 √ null

The locker combination if this transaction is related to a locker reservation
POSPRODUCT_ID int 4 √ null
POS_PRODUCTS.POSPRODUCT_ID Defined in XML R

The POS product ID if this is a point of sale transaction
POS_FEATURE_1 varchar 100 √ null

The feature 1 option selected during a point of sale transaction
POS_FEATURE_2 varchar 100 √ null

The feature 2 option selected during a point of sale transaction
REFUND_TO_INVENTORY_QUANTITY int 4 √ null

The quantity to be returned to inventory during a point of sale refund
LEAGUE_SCHEDULE_ID int 4 √ null
LEAGUE_SCHEDULES.LEAGUE_SCHEDULE_ID Defined in XML R

The league schedule ID if this transaction is related to a league
TEAM_ID int 4 √ null
TEAMS.TEAM_ID Defined in XML R

The team ID if this transaction is related to a league and a specific team
CAMPAIGN_ID int 4 √ null
CAMPAIGNS.CAMPAIGN_ID Defined in XML R

The campaign ID if this transaction is related to a donation
GIFT_CARD_ID int 4 √ null
GIFT_CARDS.GIFT_CARD_ID Defined in XML R

The gift certificate ID if this transaction is related to a gift certificate
REFUND_TYPE varchar 50 √ null

The type of refund processed
REFUND_RETAIN_OWED_PERCENT money 21,4 √ null

The percentage of the fee retained during a refund
REFUND_RETAIN_AMOUNT money 21,4 √ null

The amount of the fee retained during a refund
WITHDRAW_REASON varchar 8000 √ null

The reason for withdrawal
CANCEL_REASON_ID int 4 √ null
REASONS.REASON_ID Defined in XML R

The ID of the reason selected during a refund or cancellation transaction
TRANSACTION_FEE_AMOUNT money 21,4 √ null

Amount of transaction fee
CREDIT_CARD_FEE_AMOUNT money 21,4 √ null

Amount of credit card fee
CREDIT_CARD_FEE_SURCHARGE_AMOUNT money 21,4 √ null

Amount of credit card fee that is a surcharge
CONVENIENCE_FEE_AMOUNT money 21,4 √ null

Amount of convenience fee
CONVENIENCE_FEE_ABSORBED_AMOUNT money 21,4 √ null

Amount of convenience fee that was absorbed
CONVENIENCE_FEE_DISCOUNT_AMOUNT money 21,4 √ null

Amount of convenience fee discount
CONVENIENCE_FEE_ABSORBED_DISCOUNT_AMOUNT money 21,4 √ null

Amount of convenience fee discount that was absorbed
IS_RETIRED varchar 5 √ null

Whether the transaction has been marked as retired to hide it from display (Yes/No)
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
ROW_VERSION binary 8 √ null

System timestamp (for internal use)
VOIDED bit 1 ((0))

Whether the transaction has been voided (1 = voided / 0 = not voided)
VOIDED_BY int 4 √ null

The ID of the system user who voided the transaction
VOIDED_DATE_TIME datetime 16,3 √ null

The date and time that the transaction was voided
CUSTOMQUESTIONANSWER_TRANSACTION_ID int 4 √ null

The transaction ID for custom question answers that apply to this transaction

Indexes

Constraint Name Type Sort Column(s)
TRANSACTIONS_ACTIVE_HUB_KEY_PK Primary key Asc ACTIVE_HUB_KEY
TRANSACTIONS_ACTIVITY_ID_IX Performance Asc ACTIVITY_ID
TRANSACTIONS_CAMPAIGN_ID_VOIDED_IX Performance Asc/Asc CAMPAIGN_ID + VOIDED
TRANSACTIONS_CANCEL_REASON_ID_IX Performance Asc CANCEL_REASON_ID
TRANSACTIONS_CASH_SUMMARY_SHEET_ID_IX Performance Asc CASH_SUMMARY_SHEET_ID
TRANSACTIONS_COMPANY_ID_IX Performance Asc COMPANY_ID
TRANSACTIONS_CREATION_DATE_TIME_VOIDED_IX Performance Asc/Asc CREATION_DATE_TIME + VOIDED
TRANSACTIONS_CUSTOMER_ID_IX Performance Asc/Asc/Asc CUSTOMER_ID + ORG_ID + TRANSACTION_ID
TRANSACTIONS_CUSTOMQUESTIONANSWER_TRANSACTION_ID_IX Performance Asc CUSTOMQUESTIONANSWER_TRANSACTION_ID
TRANSACTIONS_EVENT_TYPE_ID_IX Performance Asc EVENT_TYPE_ID
TRANSACTIONS_FACILITY_ID_IX Performance Asc FACILITY_ID
TRANSACTIONS_MEMBERSHIP_ID_IX Performance Asc MEMBERSHIP_ID
TRANSACTIONS_nc_cs_ix Performance Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc ACTIVITY_ID + CANCEL_REASON_ID + CASH_SUMMARY_SHEET_ID + COMPANY_ID + CREATION_DATE_TIME + CUSTOMER_ID + EVENT_TYPE_ID + FACILITY_ID + MEMBERSHIP_ID + ORIGINAL_TRANSACTION_ID + PACKAGE_ID + PERMIT_ID + POSPRODUCT_ID + PROGRAM_ID + RECEIPT_HEADER_ID + REVENUE_SITE_ID + ROOT_TRANSACTION_ID + SCHEDULE_TYPE_ID + SESSION_ID + SYSTEMUSER_ID + TRANSACTION_ID + TRANSACTION_SITE_ID + TRANSACTION_TYPE_ID + VOIDED + VOIDED_BY + VOIDED_DATE_TIME + WORKSTATION_ID
TRANSACTIONS_ORIGINAL_TRANSACTION_ID_IX Performance Asc ORIGINAL_TRANSACTION_ID
TRANSACTIONS_PACKAGE_ID_IX Performance Asc PACKAGE_ID
TRANSACTIONS_PERMIT_ID_IX Performance Asc PERMIT_ID
TRANSACTIONS_POSPRODUCT_ID_IX Performance Asc POSPRODUCT_ID
TRANSACTIONS_PROGRAM_ID_IX Performance Asc PROGRAM_ID
TRANSACTIONS_RECEIPT_HEADER_ID_IX Performance Asc RECEIPT_HEADER_ID
TRANSACTIONS_REVENUE_SITE_ID_IX Performance Asc REVENUE_SITE_ID
TRANSACTIONS_ROOT_TRANSACTION_ID_IX Performance Asc ROOT_TRANSACTION_ID
TRANSACTIONS_ROW_VERSION_IX Performance Asc ROW_VERSION
TRANSACTIONS_SCHEDULE_TYPE_ID_IX Performance Asc SCHEDULE_TYPE_ID
TRANSACTIONS_SESSION_ID_IX Performance Asc SESSION_ID
TRANSACTIONS_SYSTEMUSER_ID_IX Performance Asc SYSTEMUSER_ID
TRANSACTIONS_TRANSACTION_ID_ORG_ID_UQ Must be unique Asc/Asc TRANSACTION_ID + ORG_ID
TRANSACTIONS_TRANSACTION_SITE_ID_IX Performance Asc TRANSACTION_SITE_ID
TRANSACTIONS_TRANSACTION_TYPE_ID_IX Performance Asc TRANSACTION_TYPE_ID
TRANSACTIONS_VOIDED_IX Performance Asc/Asc VOIDED + VOIDED_DATE_TIME
TRANSACTIONS_WORKSTATION_ID_IX Performance Asc WORKSTATION_ID

Relationships

Close relationships within degrees of separation