Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| TRANSACTION_ID | int | 4 | √ | null |
|
|
Transaction ID |
|
| RECEIPT_HEADER_ID | int | 4 | √ | null |
|
|
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 | 20 | √ | 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 | 20 | √ | null |
|
|
Date that the transaction was last updated (date only) |
|
| TRANSACTION_SITE_ID | int | 4 | √ | null |
|
|
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 | 4 | √ | null |
|
|
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 | 4 | √ | null |
|
|
ID of the workstation where the transaction was created |
|
| WORKSTATION_NAME | varchar | 45 | √ | null |
|
|
Name of the workstation where the transaction was created |
|
| SYSTEMUSER_ID | int | 4 | √ | null |
|
|
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 | 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 |
|
| TRANSACTION_TYPE | varchar | 200 | √ | null |
|
|
The transaction type of the transaction |
|
| ORIGINAL_TRANSACTION_TYPE_ID | int | 4 | √ | 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 | 4 | √ | null |
|
|
The original transaction ID for a series of transactions |
|
| ROOT_TRANSACTION_ID | int | 4 | √ | null |
|
|
The root transaction ID for a chain of transactions |
|
| LINKED_TRANSACTION_ID | int | 4 | √ | null |
|
|
A linked transaction ID for a related transaction if applicable |
|
| ADDITIONAL_TRANSACTION_ID | int | 4 | √ | null |
|
|
An additional transaction ID for a related transaction if applicable |
|
| CUSTOMER_ID | int | 4 | √ | null |
|
|
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 | 4 | √ | null |
|
|
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 | 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 |
|
| EFFECTIVE_DATE_ONLY | date | 20 | √ | null |
|
|
The effective date related to this transaction (date only) |
|
| PRORATE_EFFECTIVE_DATE | date | 20 | √ | null |
|
|
The proration date applied to this transaction |
|
| ACTIVITY_ID | int | 4 | √ | null |
|
|
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 |
|
|
The pass or fail grade ID that has been entered |
|
| PASS_OR_FAIL_GRADE_NAME | varchar | 20 | √ | 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 | 4 | √ | null |
|
|
The transaction ID created when this enrollment was rolled over |
|
| PROGRAM_ID | int | 4 | √ | null |
|
|
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 | 4 | √ | null |
|
|
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 | 4 | √ | null |
|
|
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 | 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 |
|
|
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 | 4 | √ | null |
|
|
The permit ID if this transaction is related to a reservation |
|
| PERMIT_NUMBER | int | 4 | √ | null |
|
|
The permit number if this transaction is related to a reservation |
|
| RESERVATION_TYPE | varchar | 10 | √ | null |
|
|
The reservation type (Regular / Continuous) |
|
| EVENT_TYPE_ID | int | 4 | √ | null |
|
|
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 | 4 | √ | null |
|
|
The schedule type ID if this transaction is related to a reservation |
|
| SCHEDULE_TYPE | varchar | 80 | √ | null |
|
|
The schedule type name if this transaction is related to a reservation |
|
| PREP_CODE_ID | int | 4 | √ | null |
|
|
The prep code ID if this transaction is related to a reservation |
|
| PREP_CODE_NAME | varchar | 30 | √ | null |
|
|
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 |
|
|
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 | 4 | √ | null |
|
|
The quantity to be returned to inventory during a point of sale refund |
|
| LEAGUE_SCHEDULE_ID | int | 4 | √ | null |
|
|
The league schedule ID if this transaction is related to a league |
|
| TEAM_ID | int | 4 | √ | null |
|
|
The team ID if this transaction is related to a league and a specific team |
|
| CAMPAIGN_ID | int | 4 | √ | null |
|
|
The campaign ID if this transaction is related to a donation |
|
| CAMPAIGN_NAME | varchar | 50 | √ | null |
|
|
The campaign name if this transaction is related to a donation |
|
| GIFT_CARD_ID | int | 4 | √ | null |
|
|
The gift card ID if this transaction is related to a gift card |
|
| CUSTOMQUESTIONANSWER_TRANSACTION_ID | int | 4 | √ | null |
|
|
The transaction ID for custom question answers that apply to this transaction as well |
|
| 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 |
|
|
The ID of the reason selected during a refund or cancellation transaction |
|
| CANCEL_REASON | varchar | 50 | √ | null |
|
|
The reason selected during a refund or cancellation transaction |
|
| IS_RETIRED | varchar | 5 | √ | null |
|
|
Whether the transaction has been marked as retired to hide it from display (Yes/No) |
|
| VOIDED | varchar | 3 | null |
|
|
Whether the transaction has been voided (Yes/No) |
||
| VOIDED_BY | int | 4 | √ | null |
|
|
The ID of the system user who voided the transaction |
|
| VOIDED_BY_USER_NAME | varchar | 511 | null |
|
|
The name of the system user who voided the transaction |
||
| VOIDED_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The date and time that the transaction was voided |
|
| VOIDED_DATE_ONLY | date | 20 | √ | null |
|
|
The date that the transaction was voided (date only) |
|
| ACTIVE_HUB_KEY | int | 4 | 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 | 8 | √ | null |
|
|
The Hub sync process ID |
|
| ORG_ID | int | 4 | √ | null |
|
|
Your organization’s unique identifier in the Active Net system |