RECEIPT_DETAILS

0 rows


Description

Posted receipt detail data

Columns

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

The Hub record ID
RECEIPT_DETAIL_ID int 4 √ null
ACCOUNT_CREDIT_HISTORY.RECEIPT_DETAIL_ID Defined in XML R
COUPON_USAGE.RECEIPT_DETAIL_ID Defined in XML R
CUSTOMER_THIRD_PARTY_BILLING_LINKS.RECEIPT_DETAIL_ID Defined in XML R
DEFERRED_REVENUE_PROJECTIONS.ORIGINAL_RECEIPT_DETAIL_ID Defined in XML R
RECEIPT_DETAIL_PAYMENTS.RECEIPT_DETAIL_ID Defined in XML R
RECEIPT_DETAILS.ORIGINAL_RECEIPT_DETAIL_ID Defined in XML R
RECEIPT_DETAILS.ROOT_RECEIPT_DETAIL_ID Defined in XML R
RECEIPT_GL_POSTINGS.RECEIPT_DETAIL_ID Defined in XML R

Receipt detail ID
TRANSACTION_ID int 4 √ null
TRANSACTIONS.TRANSACTION_ID Defined in XML R

ID of the transaction that the receipt detail item belongs to
ORIGINAL_RECEIPT_DETAIL_ID int 4 √ null
RECEIPT_DETAILS.RECEIPT_DETAIL_ID Defined in XML R

The original receipt detail ID for a series of transactions
ROOT_RECEIPT_DETAIL_ID int 4 √ null
RECEIPT_DETAILS.RECEIPT_DETAIL_ID Defined in XML R

The root receipt detail ID for a chain of transactions
ORIGINAL_TRANSACTION_ID int 4 √ null
TRANSACTIONS.TRANSACTION_ID Defined in XML R

The original transaction ID for a series of transactions
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
GLACCOUNT_ID int 4 √ null
GLACCOUNTS.GLACCOUNT_ID Defined in XML R

ID of the GL account related to this charge item
CHARGE_ID int 4 √ null
CHARGES.CHARGE_ID Defined in XML R

The charge ID associated with this receipt detail item
STANDARD_CHARGE_ID int 4 √ null
STANDARD_CHARGES.STANDARD_CHARGE_ID Defined in XML R

The facility standard charge ID associated with this receipt detail item
DESCRIPTION varchar 150 √ null

The charge description of this receipt detail item
IS_PRIMARY_FEE varchar 5 √ null

Whether this charge item is a primary fee (Yes/No)
AMOUNT money 21,4 √ null

The amount of this charge item
APPLIED_AMOUNT money 21,4 √ null

The amount of this charge item that has a payment, refund or other charge applied against it
IS_DEPOSIT varchar 5 √ null

Whether this charge item is a deposit (Yes/No)
IS_DISCOUNT varchar 5 √ null

Whether this charge item is a discount (Yes/No)
DISCOUNT_TYPE varchar 10 √ null

The type of discount applied (Amount / Percent)
DISCOUNT_PERCENT money 21,4 √ null

The discount percentage applied
UNIT_FEE_AMOUNT money 21,4 √ null

The per unit fee amount
UNIT_OF_MEASURE varchar 40 √ null

The default unit of measure for the charge item amount
QUANTITY money 21,4 √ null

The quantity of the item charged in this receipt item
IS_DISCOUNTABLE varchar 5 √ null

Whether this charge item can be discounted (Yes/No)
APPLIED_DISCOUNT_AMOUNT money 21,4 √ null

The total amount of discounts that have been applied to this receipt item
DEPOSIT_PAYOFF_AMOUNT money 21,4 √ null

The deposit payoff amount that is associated with this receipt item
POSPRODUCT_ID int 4 √ null
POS_PRODUCTS.POSPRODUCT_ID Defined in XML R

The POS product ID associated with this receipt item
COUPON_ID int 4 √ null
COUPONS.COUPON_ID Defined in XML R

The coupon ID associated with this receipt item
IS_PAYMENT_PLAN_CHARGE varchar 5 √ null

Whether this charge item is a payment plan charge (Yes/No)
IS_EXTRA_BOOKING_FEE varchar 5 √ null

Whether this charge item is an extra booking fee (Yes/No)
OVERRIDE_INCLUDE_FLAG varchar 5 √ null

Whether the include flag was overridden for this charge item (Yes/No)
IS_CLAIM_CHARGE varchar 5 √ null

Whether this charge item is a claim charge fee (Yes/No)
EXCLUDE_FROM_PAYMENT_PLAN varchar 5 √ null

Whether this receipt item should be excluded from any payment plan (Yes/No)
APPLIES_TO_PRIMARY_FEE varchar 5 √ null

Whether this fee or discount applied to the primary fee (Yes/No)
FACILITY_SCHEDULE_ID int 4 √ null
FACILITY_RESERVATION.FACILITY_SCHEDULE_ID Defined in XML R

The facility schedule ID for the reservation associated with this receipt item
IS_NON_REFUNDABLE varchar 5 √ null

Whether this charge item is non-refundable (Yes/No)
PREFUND_AMOUNT_USED money 21,4 √ null

The prefund amount used for this receipt item
TAXABLE_BY_TAX_1 varchar 5 √ null

Whether tax 1 applies to this charge (Yes/No)
TAXABLE_BY_TAX_2 varchar 5 √ null

Whether tax 2 applies to this charge (Yes/No)
TAXABLE_BY_TAX_3 varchar 5 √ null

Whether tax 3 applies to this charge (Yes/No)
TAXABLE_BY_TAX_4 varchar 5 √ null

Whether tax 4 applies to this charge (Yes/No)
TAXABLE_BY_TAX_5 varchar 5 √ null

Whether tax 5 applies to this charge (Yes/No)
TAXABLE_BY_TAX_6 varchar 5 √ null

Whether tax 6 applies to this charge (Yes/No)
TAXABLE_BY_TAX_7 varchar 5 √ null

Whether tax 7 applies to this charge (Yes/No)
TAXABLE_BY_TAX_8 varchar 5 √ null

Whether tax 8 applies to this charge (Yes/No)
TAX_AMOUNT_1 money 21,4 √ null

The amount for tax 1 added to this charge
TAX_AMOUNT_2 money 21,4 √ null

The amount for tax 2 added to this charge
TAX_AMOUNT_3 money 21,4 √ null

The amount for tax 3 added to this charge
TAX_AMOUNT_4 money 21,4 √ null

The amount for tax 4 added to this charge
TAX_AMOUNT_5 money 21,4 √ null

The amount for tax 5 added to this charge
TAX_AMOUNT_6 money 21,4 √ null

The amount for tax 6 added to this charge
TAX_AMOUNT_7 money 21,4 √ null

The amount for tax 7 added to this charge
TAX_AMOUNT_8 money 21,4 √ null

The amount for tax 8 added to this charge
TAX_APPLIED_AMOUNT_1 money 21,4 √ null

The amount of tax 1 that has a payment, refund or other charge applied against it
TAX_APPLIED_AMOUNT_2 money 21,4 √ null

The amount of tax 2 that has a payment, refund or other charge applied against it
TAX_APPLIED_AMOUNT_3 money 21,4 √ null

The amount of tax 3 that has a payment, refund or other charge applied against it
TAX_APPLIED_AMOUNT_4 money 21,4 √ null

The amount of tax 4 that has a payment, refund or other charge applied against it
TAX_APPLIED_AMOUNT_5 money 21,4 √ null

The amount of tax 5 that has a payment, refund or other charge applied against it
TAX_APPLIED_AMOUNT_6 money 21,4 √ null

The amount of tax 6 that has a payment, refund or other charge applied against it
TAX_APPLIED_AMOUNT_7 money 21,4 √ null

The amount of tax 7 that has a payment, refund or other charge applied against it
TAX_APPLIED_AMOUNT_8 money 21,4 √ null

The amount of tax 8 that has a payment, refund or other charge applied against it
TAX_GLACCOUNT_ID_1 int 4 √ null

The GL account ID that was posted to for tax 1
TAX_GLACCOUNT_ID_2 int 4 √ null

The GL account ID that was posted to for tax 2
TAX_GLACCOUNT_ID_3 int 4 √ null

The GL account ID that was posted to for tax 3
TAX_GLACCOUNT_ID_4 int 4 √ null

The GL account ID that was posted to for tax 4
TAX_GLACCOUNT_ID_5 int 4 √ null

The GL account ID that was posted to for tax 5
TAX_GLACCOUNT_ID_6 int 4 √ null

The GL account ID that was posted to for tax 6
TAX_GLACCOUNT_ID_7 int 4 √ null

The GL account ID that was posted to for tax 7
TAX_GLACCOUNT_ID_8 int 4 √ null

The GL account ID that was posted to for tax 8
TAX_EXEMPTED_1 varchar 5 √ null

Whether the customer was tax exempt for tax 1 (Yes/No)
TAX_EXEMPTED_2 varchar 5 √ null

Whether the customer was tax exempt for tax 2 (Yes/No)
TAX_EXEMPTED_3 varchar 5 √ null

Whether the customer was tax exempt for tax 3 (Yes/No)
TAX_EXEMPTED_4 varchar 5 √ null

Whether the customer was tax exempt for tax 4 (Yes/No)
TAX_EXEMPTED_5 varchar 5 √ null

Whether the customer was tax exempt for tax 5 (Yes/No)
TAX_EXEMPTED_6 varchar 5 √ null

Whether the customer was tax exempt for tax 6 (Yes/No)
TAX_EXEMPTED_7 varchar 5 √ null

Whether the customer was tax exempt for tax 7 (Yes/No)
TAX_EXEMPTED_8 varchar 5 √ null

Whether the customer was tax exempt for tax 8 (Yes/No)
TAX_EXEMPTED_AMOUNT_1 money 21,4 √ null

The amount of tax that was exempted for tax 1
TAX_EXEMPTED_AMOUNT_2 money 21,4 √ null

The amount of tax that was exempted for tax 2
TAX_EXEMPTED_AMOUNT_3 money 21,4 √ null

The amount of tax that was exempted for tax 3
TAX_EXEMPTED_AMOUNT_4 money 21,4 √ null

The amount of tax that was exempted for tax 4
TAX_EXEMPTED_AMOUNT_5 money 21,4 √ null

The amount of tax that was exempted for tax 5
TAX_EXEMPTED_AMOUNT_6 money 21,4 √ null

The amount of tax that was exempted for tax 6
TAX_EXEMPTED_AMOUNT_7 money 21,4 √ null

The amount of tax that was exempted for tax 7
TAX_EXEMPTED_AMOUNT_8 money 21,4 √ null

The amount of tax that was exempted for tax 8
ELECTRONIC_PAYMENT_AMOUNT money 21,4 √ null

The total electronic payment amount that has been applied to this receipt item
CREDIT_CARD_FEE_AMOUNT money 21,4 √ null

Amount of credit card fee for this receipt item
CREDIT_CARD_FEE_SURCHARGE_AMOUNT money 21,4 √ null

Amount of credit card surcharge fee for this receipt item
TRANSACTION_FEE_AMOUNT money 21,4 √ null

Amount of transaction fee for this receipt item
CONVENIENCE_FEE_AMOUNT money 21,4 √ null

Amount of convenience fee for this receipt item
CONVENIENCE_FEE_ABSORBED_AMOUNT money 21,4 √ null

Amount of convenience fee that was absorbed for this receipt item
ROW_VERSION binary 8 √ null

System timestamp (for internal use)
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
VOIDED bit 1 ((0))

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

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

The date and time that the receipt detail was voided
TRANSACTION_STATUS int 4 ((0))

The status of this receipt detail item within the transaction (0 = Normal, 1 = Deleted, 2 = Pending)
CUSTOMER_SCHOLARSHIP_ID int 4 √ null
CUSTOMER_SCHOLARSHIPS.CUSTOMER_SCHOLARSHIP_ID Defined in XML R

Customer scholarship ID

Indexes

Constraint Name Type Sort Column(s)
RECEIPT_DETAILS_ACTIVE_HUB_KEY_PK Primary key Asc ACTIVE_HUB_KEY
RECEIPT_DETAILS_CHARGE_ID_IX Performance Asc CHARGE_ID
RECEIPT_DETAILS_COUPON_ID_IX Performance Asc COUPON_ID
RECEIPT_DETAILS_GLACCOUNT_ID_IX Performance Asc GLACCOUNT_ID
RECEIPT_DETAILS_nc_cs_ix Performance Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc CHARGE_ID + COUPON_ID + GLACCOUNT_ID + ORIGINAL_RECEIPT_DETAIL_ID + ORIGINAL_TRANSACTION_ID + POSPRODUCT_ID + RECEIPT_DETAIL_ID + REVENUE_SITE_ID + ROOT_RECEIPT_DETAIL_ID + STANDARD_CHARGE_ID + SYSTEMUSER_ID + TRANSACTION_ID + TRANSACTION_SITE_ID + TRANSACTION_STATUS + VOIDED + VOIDED_BY + VOIDED_DATE_TIME + WORKSTATION_ID
RECEIPT_DETAILS_ORIGINAL_RECEIPT_DETAIL_ID_IX Performance Asc ORIGINAL_RECEIPT_DETAIL_ID
RECEIPT_DETAILS_ORIGINAL_TRANSACTION_ID_IX Performance Asc ORIGINAL_TRANSACTION_ID
RECEIPT_DETAILS_POSPRODUCT_ID_IX Performance Asc POSPRODUCT_ID
RECEIPT_DETAILS_RECEIPT_DETAIL_ID_ORG_ID_UQ Must be unique Asc/Asc RECEIPT_DETAIL_ID + ORG_ID
RECEIPT_DETAILS_REVENUE_SITE_ID_IX Performance Asc REVENUE_SITE_ID
RECEIPT_DETAILS_ROOT_RECEIPT_DETAIL_ID_IX Performance Asc ROOT_RECEIPT_DETAIL_ID
RECEIPT_DETAILS_ROW_VERSION_IX Performance Asc ROW_VERSION
RECEIPT_DETAILS_STANDARD_CHARGE_ID_IX Performance Asc STANDARD_CHARGE_ID
RECEIPT_DETAILS_SYSTEMUSER_ID_IX Performance Asc SYSTEMUSER_ID
RECEIPT_DETAILS_TRANSACTION_ID_IX Performance Asc TRANSACTION_ID
RECEIPT_DETAILS_TRANSACTION_SITE_ID_IX Performance Asc TRANSACTION_SITE_ID
RECEIPT_DETAILS_TRANSACTION_STATUS_IX Performance Asc TRANSACTION_STATUS
RECEIPT_DETAILS_VOIDED_IX Performance Asc/Asc VOIDED + VOIDED_DATE_TIME
RECEIPT_DETAILS_WORKSTATION_ID_IX Performance Asc WORKSTATION_ID

Relationships

Close relationships within degrees of separation