TRANSACTIONS

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

TRANSACTION_ID

int

√

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

√

null

RECEIPT_HEADERS.RECEIPT_HEADER_ID

Defined in XML

ID of the receipt header that the transaction belongs to

RECEIPT_NUMBER

nvarchar

8000

√

null

The receipt number that the transaction belongs to

CREATION_DATE_TIME

datetime

16,3

√

null

Date and time that the transaction was created

CREATION_DATE_ONLY

date

√

null

Date that the transaction was created (date only)

LAST_UPDATED_DATE_TIME

datetime

16,3

√

null

Date and time that the transaction was last updated

LAST_UPDATED_DATE_ONLY

date

√

null

Date that the transaction was last updated (date only)

TRANSACTION_SITE_ID

int

√

null

SITES.SITE_ID

Defined in XML

ID of the site where the transaction was created

TRANSACTION_SITE_NAME

varchar

255

√

null

Name of the site where the transaction was created

REVENUE_SITE_ID

int

√

null

SITES.SITE_ID

Defined in XML

ID of the site for the item that the transaction is for

REVENUE_SITE_NAME

varchar

255

√

null

Name of the site for the item that the transaction is for

WORKSTATION_ID

int

√

null

WORKSTATIONS.WORKSTATION_ID

Defined in XML

ID of the workstation where the transaction was created

WORKSTATION_NAME

varchar

√

null

Name of the workstation where the transaction was created

SYSTEMUSER_ID

int

√

null

SYSTEM_USERS.SYSTEMUSER_ID

Defined in XML

ID of the user who created the transaction

SYSTEM_USER_NAME

varchar

511

null

Name of the user who created the transaction

CASH_SUMMARY_SHEET_ID

int

√

null

ID of the cash summary sheet that was active on the workstation when the transaction was created

MODULE_NAME

varchar

√

null

The system module that the transaction belongs to

TRANSACTION_TYPE_ID

int

√

null

The transaction type ID of the transaction

TRANSACTION_TYPE

varchar

200

√

null

The transaction type of the transaction

ORIGINAL_TRANSACTION_TYPE_ID

int

√

null

The original transaction type ID of the transaction

ORIGINAL_TRANSACTION_TYPE

varchar

200

√

null

The original transaction type of the transaction

ORIGINAL_TRANSACTION_ID

int

√

null

TRANSACTIONS.TRANSACTION_ID

Defined in XML

The original transaction ID for a series of transactions

ROOT_TRANSACTION_ID

int

√

null

TRANSACTIONS.TRANSACTION_ID

Defined in XML

The root transaction ID for a chain of transactions

LINKED_TRANSACTION_ID

int

√

null

TRANSACTIONS.TRANSACTION_ID

Defined in XML

A linked transaction ID for a related transaction if applicable

ADDITIONAL_TRANSACTION_ID

int

√

null

TRANSACTIONS.TRANSACTION_ID

Defined in XML

An additional transaction ID for a related transaction if applicable

CUSTOMER_ID

int

√

null

CUSTOMERS.CUSTOMER_ID

Defined in XML

ID of the customer who is the participant of the transaction

CUSTOMER_NAME

varchar

511

null

Name of the customer who is the participant of the transaction

COMPANY_ID

int

√

null

COMPANIES.COMPANY_ID

Defined in XML

ID of the company who is the owner of the transaction if applicable

COMPANY_NAME

varchar

255

√

null

Name 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

√

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

EFFECTIVE_DATE_ONLY

date

√

null

The effective date related to this transaction (date only)

PRORATE_EFFECTIVE_DATE

date

√

null

The proration date applied to this transaction

ACTIVITY_ID

int

√

null

ACTIVITIES.ACTIVITY_ID

Defined in XML

The activity ID if this transaction is related to an activity

WAITLIST_RANK

int

√

null

The customer’s waitlist rank for waitlist transactions

PRIVATE_LESSON_GROUP_ID

int

√

null

The private lesson group ID for the enrollment

MAX_PRIVATE_LESSON_BOOKINGS

int

√

null

The number of private lessons included in the enrollment

RESERVATION_PERIOD_UNIT

varchar

√

null

Default reservation period (Use Default / Minute / Hour / Day / Week / Month / Defined Date Range / Rental Block / Overnight)

PASS_OR_FAIL

varchar

√

null

The pass or fail status if a grade has been entered that designates pass or fail (pass / fail)

PASS_OR_FAIL_DATE

date

√

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

√

null

ACTIVITY_PASS_FAIL_GRADES.ACTIVITY_PASS_FAIL_GRADE_ID

Defined in XML

The pass or fail grade ID that has been entered

PASS_OR_FAIL_GRADE_NAME

varchar

√

null

The pass or fail grade name that has been entered

DEPOSIT_PAYOFF_AMOUNT

money

21,4

√

null

The amount required to pay off a specified deposit

ROLLOVER_TRANSACTION_ID

int

√

null

TRANSACTIONS.TRANSACTION_ID

Defined in XML

The transaction ID created when this enrollment was rolled over

PROGRAM_ID

int

√

null

PROGRAMS.PROGRAM_ID

Defined in XML

The program ID if this transaction is related to a daycare program

PROGRAM_NAME

varchar

255

√

null

The program name if this transaction is related to a daycare program

SESSION_ID

int

√

null

SESSIONS.SESSION_ID

Defined in XML

The session ID if this transaction is related to a daycare program session

SESSION_NAME

varchar

255

√

null

The session name if this transaction is related to a daycare program session

PACKAGE_ID

int

√

null

PACKAGES.PACKAGE_ID

Defined in XML

The package ID if this transaction is related to a membership

PACKAGE_NAME

varchar

255

√

null

The package name if this transaction is related to a membership

MEMBERSHIP_ID

int

√

null

The membership ID if this transaction is related to a membership

EXPIRATION_DATE

date

√

null

The expiration date if this transaction is related to a membership sale or renewal

MAX_USES

int

√

null

The max uses purchased for a punch pass membership package

FACILITY_ID

int

√

null

FACILITIES.FACILITY_ID

Defined in XML

The facility ID if this transaction is related to a reservation or private lesson

FACILITY_NAME

varchar

255

√

null

The facility name if this transaction is related to a reservation or private lesson

PERMIT_ID

int

√

null

PERMITS.PERMIT_ID

Defined in XML

The permit ID if this transaction is related to a reservation

PERMIT_NUMBER

int

√

null

The permit number if this transaction is related to a reservation

RESERVATION_TYPE

varchar

√

null

The reservation type (Regular / Continuous)

EVENT_TYPE_ID

int

√

null

EVENT_TYPES.EVENT_TYPE_ID

Defined in XML

The event type ID if this transaction is related to a reservation

EVENT_TYPE

varchar

102

√

null

The event type name if this transaction is related to a reservation

SCHEDULE_TYPE_ID

int

√

null

SCHEDULE_TYPES.SCHEDULE_TYPE_ID

Defined in XML

The schedule type ID if this transaction is related to a reservation

SCHEDULE_TYPE

varchar

√

null

The schedule type name if this transaction is related to a reservation

PREP_CODE_ID

int

√

null

PREP_CODES.PREP_CODE_ID

Defined in XML

The prep code ID if this transaction is related to a reservation

PREP_CODE_NAME

varchar

√

null

The prep code ID if this transaction is related to a reservation

NON_EXCLUSIVE_EVENT

varchar

√

null

Whether the reservation associated with this transaction is a non-exclusive event (Yes/No)

LOCKER_ID

int

√

null

The locker ID if this transaction is related to a locker reservation

COMBINATION_LOCK_ID

int

√

null

The combination lock ID if this transaction is related to a locker reservation

LOCKER_COMBINATION

varchar

√

null

The locker combination if this transaction is related to a locker reservation

POSPRODUCT_ID

int

√

null

POS_PRODUCTS.POSPRODUCT_ID

Defined in XML

The POS product ID if this is a point of sale transaction

PRODUCT_NAME

varchar

100

√

null

The POS product name 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

√

null

The quantity to be returned to inventory during a point of sale refund

LEAGUE_SCHEDULE_ID

int

√

null

LEAGUE_SCHEDULES.LEAGUE_SCHEDULE_ID

Defined in XML

The league schedule ID if this transaction is related to a league

TEAM_ID

int

√

null

TEAMS.TEAM_ID

Defined in XML

The team ID if this transaction is related to a league and a specific team

CAMPAIGN_ID

int

√

null

CAMPAIGNS.CAMPAIGN_ID

Defined in XML

The campaign ID if this transaction is related to a donation

CAMPAIGN_NAME

varchar

√

null

The campaign name if this transaction is related to a donation

GIFT_CARD_ID

int

√

null

GIFT_CARDS.GIFT_CARD_ID

Defined in XML

The gift card ID if this transaction is related to the sale or refund of a gift card

CUSTOMQUESTIONANSWER_TRANSACTION_ID

int

√

null

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

REFUND_TYPE

varchar

√

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

√

null

REASONS.REASON_ID

Defined in XML

The ID of the reason selected during a refund or cancellation transaction

CANCEL_REASON

varchar

√

null

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

√

null

Whether the transaction has been marked as retired to hide it from display (Yes/No)

VOIDED

varchar

null

Whether the transaction has been voided (Yes/No)

GIFT_CERTIFICATE_ID

int

√

null

The gift certificate ID if this transaction is related to a gift certificate

ACTIVE_HUB_KEY

int

null

The Hub record ID

LAST_SYNC_TIME

datetime

16,3

null

Date and time Hub record was last modified

ACTIVE_HUB_PROCESS_ID

bigint

√

null

The Hub sync process ID

ORG_ID

int

√

null

Your organization’s unique identifier in the Active Net system

source_id

int

√

null

The ID value from the Active Net system

Relationships

Close relationships within degrees of separation

One
Two degrees

View Definition

CREATE VIEW dbo.TRANSACTIONS
AS
SELECT
    src.TRANSACTION_ID,
    src.RECEIPT_HEADER_ID,
    FORMAT(rh1.RECEIPT_NUMBER, '#.0000') AS RECEIPT_NUMBER,
    src.CREATION_DATE_TIME,
    CAST(src.CREATION_DATE_TIME AS DATE) AS CREATION_DATE_ONLY,
    src.LAST_UPDATED_DATE_TIME,
    CAST(src.LAST_UPDATED_DATE_TIME AS DATE) AS LAST_UPDATED_DATE_ONLY,
    src.TRANSACTION_SITE_ID,
    si1.SITE_NAME AS TRANSACTION_SITE_NAME,
    src.REVENUE_SITE_ID,
    si2.SITE_NAME AS REVENUE_SITE_NAME,
    src.WORKSTATION_ID,
    ws1.WORKSTATION_NAME,
    src.SYSTEMUSER_ID,
    CONCAT(su1.USER_FIRST_NAME, IIF(su1.USER_FIRST_NAME IS NOT NULL AND su1.USER_LAST_NAME IS NOT NULL, ' ', ''), su1.USER_LAST_NAME) AS SYSTEM_USER_NAME,
    src.CASH_SUMMARY_SHEET_ID,
    src.MODULE_NAME,
    src.TRANSACTION_TYPE_ID,
    rv4.REFERENCE_VALUE AS TRANSACTION_TYPE,
    src.ORIGINAL_TRANSACTION_TYPE_ID,
    rv5.REFERENCE_VALUE AS ORIGINAL_TRANSACTION_TYPE,
    src.ORIGINAL_TRANSACTION_ID,
    src.ROOT_TRANSACTION_ID,
    src.LINKED_TRANSACTION_ID,
    src.ADDITIONAL_TRANSACTION_ID,
    src.CUSTOMER_ID,
    CONCAT(cu1.CUSTOMER_FIRST_NAME, IIF(cu1.CUSTOMER_FIRST_NAME IS NOT NULL AND cu1.CUSTOMER_LAST_NAME IS NOT NULL, ' ', ''), cu1.CUSTOMER_LAST_NAME) AS CUSTOMER_NAME,
    src.COMPANY_ID,
    co1.COMPANY_NAME,
    src.APPLIED_AMOUNT,
    src.CREDIT_CARD_AMOUNT,
    src.ECP_AMOUNT,
    src.PREFUND_AMOUNT_USED,
    src.QUANTITY,
    src.EVENT_NAME,
    src.STAFF_NOTES,
    src.CUSTOMER_NOTES,
    src.EFFECTIVE_DATE_TIME,
    CAST(src.EFFECTIVE_DATE_TIME AS DATE) AS EFFECTIVE_DATE_ONLY,
    src.PRORATE_EFFECTIVE_DATE,
    src.ACTIVITY_ID,
    src.WAITLIST_RANK,
    src.PRIVATE_LESSON_GROUP_ID,
    src.MAX_PRIVATE_LESSON_BOOKINGS,
    src.RESERVATION_PERIOD_UNIT,
    src.PASS_OR_FAIL,
    src.PASS_OR_FAIL_DATE,
    src.PASS_OR_FAIL_PERCENTAGE,
    src.PASS_OR_FAIL_GRADE_ID,
    apfg.ACTIVITY_PASS_FAIL_GRADE_NAME AS PASS_OR_FAIL_GRADE_NAME,
    src.DEPOSIT_PAYOFF_AMOUNT,
    src.ROLLOVER_TRANSACTION_ID,
    src.PROGRAM_ID,
    pr1.PROGRAM_NAME,
    src.SESSION_ID,
    se1.SESSION_NAME,
    src.PACKAGE_ID,
    pa1.PACKAGE_NAME,
    src.MEMBERSHIP_ID,
    src.EXPIRATION_DATE,
    src.MAX_USES,
    src.FACILITY_ID,
    fa1.FACILITY_NAME,
    src.PERMIT_ID,
    pe1.PERMIT_NUMBER,
    src.RESERVATION_TYPE,
    src.EVENT_TYPE_ID,
    et1.EVENT_TYPE_NAME AS EVENT_TYPE,
    src.SCHEDULE_TYPE_ID,
    st1.SCHEDULE_TYPE_NAME AS SCHEDULE_TYPE,
    src.PREP_CODE_ID,
    pc1.PREP_CODE_NAME,
    src.NON_EXCLUSIVE_EVENT,
    src.LOCKER_ID,
    src.COMBINATION_LOCK_ID,
    src.LOCKER_COMBINATION,
    src.POSPRODUCT_ID,
    ppr.PRODUCT_NAME,
    src.POS_FEATURE_1,
    src.POS_FEATURE_2,
    src.REFUND_TO_INVENTORY_QUANTITY,
    src.LEAGUE_SCHEDULE_ID,
    src.TEAM_ID,
    src.CAMPAIGN_ID,
    ca1.CAMPAIGN_NAME,
    src.GIFT_CARD_ID,
    src.CUSTOMQUESTIONANSWER_TRANSACTION_ID,
    src.REFUND_TYPE,
    src.REFUND_RETAIN_OWED_PERCENT,
    src.REFUND_RETAIN_AMOUNT,
    src.WITHDRAW_REASON,
    src.CANCEL_REASON_ID,
    re1.DESCRIPTION AS CANCEL_REASON,
    src.TRANSACTION_FEE_AMOUNT,
    src.CREDIT_CARD_FEE_AMOUNT,
    src.CREDIT_CARD_FEE_SURCHARGE_AMOUNT,
    src.CONVENIENCE_FEE_AMOUNT,
    src.CONVENIENCE_FEE_ABSORBED_AMOUNT,
    src.CONVENIENCE_FEE_DISCOUNT_AMOUNT,
    src.CONVENIENCE_FEE_ABSORBED_DISCOUNT_AMOUNT,
    src.IS_RETIRED,
    'No' AS VOIDED,
    src.GIFT_CARD_ID AS GIFT_CERTIFICATE_ID,
    src.ACTIVE_HUB_KEY,
    src.LAST_SYNC_TIME,
    src.ACTIVE_HUB_PROCESS_ID,
    src.ORG_ID,
    src.TRANSACTION_ID AS source_id 
FROM 
    hub.TRANSACTIONS src
    LEFT JOIN hub.RECEIPT_HEADERS rh1 ON (rh1.ORG_ID = src.ORG_ID AND rh1.RECEIPT_HEADER_ID = src.RECEIPT_HEADER_ID)
    LEFT JOIN hub.SITES si1 ON (si1.ORG_ID = src.ORG_ID AND si1.SITE_ID = src.TRANSACTION_SITE_ID)
    LEFT JOIN hub.SITES si2 ON (si2.ORG_ID = src.ORG_ID AND si2.SITE_ID = src.REVENUE_SITE_ID)
    LEFT JOIN hub.SYSTEM_USERS su1 ON (su1.ORG_ID = src.ORG_ID AND su1.SYSTEMUSER_ID = src.SYSTEMUSER_ID)
    LEFT JOIN hub.CUSTOMERS cu1 ON (cu1.ORG_ID = src.ORG_ID AND cu1.CUSTOMER_ID = src.CUSTOMER_ID)
    LEFT JOIN hub.COMPANIES co1 ON (co1.ORG_ID = src.ORG_ID AND co1.COMPANY_ID = src.COMPANY_ID)
    LEFT JOIN hub.ACTIVITIES ac1 ON (ac1.ORG_ID = src.ORG_ID AND ac1.ACTIVITY_ID = src.ACTIVITY_ID)
    LEFT JOIN hub.FACILITIES fa1 ON (fa1.ORG_ID = src.ORG_ID AND fa1.FACILITY_ID = src.FACILITY_ID)
    LEFT JOIN hub.PROGRAMS pr1 ON (pr1.ORG_ID = src.ORG_ID AND pr1.PROGRAM_ID = src.PROGRAM_ID)
    LEFT JOIN hub.SESSIONS se1 ON (se1.ORG_ID = src.ORG_ID AND se1.SESSION_ID = src.SESSION_ID)
    LEFT JOIN hub.PACKAGES pa1 ON (pa1.ORG_ID = src.ORG_ID AND pa1.PACKAGE_ID = src.PACKAGE_ID)
    LEFT JOIN hub.PERMITS pe1 ON (pe1.ORG_ID = src.ORG_ID AND pe1.PERMIT_ID = src.PERMIT_ID)
    LEFT JOIN hub.POS_PRODUCTS ppr ON (ppr.ORG_ID = src.ORG_ID AND ppr.POSPRODUCT_ID = src.POSPRODUCT_ID)
    LEFT JOIN hub.CAMPAIGNS ca1 ON (ca1.ORG_ID = src.ORG_ID AND ca1.CAMPAIGN_ID = src.CAMPAIGN_ID)
    LEFT JOIN hub.REASONS re1 ON (re1.ORG_ID = src.ORG_ID AND re1.REASON_ID = src.CANCEL_REASON_ID)
    LEFT JOIN hub.WORKSTATIONS ws1 ON (ws1.ORG_ID = src.ORG_ID AND ws1.WORKSTATION_ID = src.WORKSTATION_ID)
    LEFT JOIN hub.PREP_CODES pc1 ON (pc1.ORG_ID = src.ORG_ID AND pc1.PREP_CODE_ID = src.PREP_CODE_ID)
    LEFT JOIN hub.SCHEDULE_TYPES st1 ON (st1.ORG_ID = src.ORG_ID AND st1.SCHEDULE_TYPE_ID = src.SCHEDULE_TYPE_ID)
    LEFT JOIN hub.EVENT_TYPES et1 ON (et1.ORG_ID = src.ORG_ID AND et1.EVENT_TYPE_ID = src.EVENT_TYPE_ID)
    LEFT JOIN hub.ACTIVITY_PASS_FAIL_GRADES apfg ON (apfg.ORG_ID = src.ORG_ID AND apfg.ACTIVITY_PASS_FAIL_GRADE_ID = src.PASS_OR_FAIL_GRADE_ID)
    LEFT JOIN hub.REFERENCE_VALUES rv4 ON (rv4.ORG_ID = src.ORG_ID AND rv4.REFERENCE_ID = src.TRANSACTION_TYPE_ID AND rv4.REFERENCE_TABLE = 'TRANSACTION_TYPES' AND rv4.REFERENCE_COLUMN = 'TITLE')
    LEFT JOIN hub.REFERENCE_VALUES rv5 ON (rv5.ORG_ID = src.ORG_ID AND rv5.REFERENCE_ID = src.ORIGINAL_TRANSACTION_TYPE_ID AND rv5.REFERENCE_TABLE = 'TRANSACTION_TYPES' AND rv5.REFERENCE_COLUMN = 'TITLE')
WHERE
    src.VOIDED = 0;

Description

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views