Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RECEIPT_DETAIL_ID | int | 4 | √ | null |
|
|
Receipt detail ID |
|||||||||||||||||||||||||
| TRANSACTION_ID | int | 4 | √ | null |
|
|
ID of the transaction that the receipt detail item belongs to |
|||||||||||||||||||||||||
| ORIGINAL_RECEIPT_DETAIL_ID | int | 4 | √ | null |
|
|
The original receipt detail ID for a series of transactions |
|||||||||||||||||||||||||
| ROOT_RECEIPT_DETAIL_ID | int | 4 | √ | null |
|
|
The root receipt detail ID for a chain of transactions |
|||||||||||||||||||||||||
| ORIGINAL_TRANSACTION_ID | int | 4 | √ | null |
|
|
The original transaction ID for a series of transactions |
|||||||||||||||||||||||||
| 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 charged item that the transaction is for |
|||||||||||||||||||||||||
| REVENUE_SITE_NAME | varchar | 255 | √ | null |
|
|
Name of the site for the charged 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 |
||||||||||||||||||||||||||
| POSPRODUCT_ID | int | 4 | √ | null |
|
|
The POS product ID associated with this receipt item |
|||||||||||||||||||||||||
| PRODUCT_NAME | varchar | 100 | √ | null |
|
|
The POS product name associated with this receipt item |
|||||||||||||||||||||||||
| GLACCOUNT_ID | int | 4 | √ | null |
|
|
ID of the GL account related to this charge item |
|||||||||||||||||||||||||
| GL_ACCOUNT_NAME | varchar | 200 | √ | null |
|
|
The GL account name related to this charge item |
|||||||||||||||||||||||||
| GL_ACCOUNT_NUMBER | varchar | 200 | √ | null |
|
|
The GL account number related to this charge item |
|||||||||||||||||||||||||
| CHARGE_ID | int | 4 | √ | null |
|
|
The charge ID associated with this receipt detail item |
|||||||||||||||||||||||||
| CHARGE_NAME | varchar | 50 | √ | null |
|
|
The name of the charge associated with this receipt detail item |
|||||||||||||||||||||||||
| STANDARD_CHARGE_ID | int | 4 | √ | null |
|
|
The facility standard charge ID associated with this receipt detail item |
|||||||||||||||||||||||||
| STANDARD_CHARGE_NAME | varchar | 50 | √ | null |
|
|
The name of the facility standard charge 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 |
|||||||||||||||||||||||||
| DISCOUNT_POSPRODUCT_ID | int | 4 | √ | null |
|
|
The POS discount product ID associated with this discount receipt item |
|||||||||||||||||||||||||
| DISCOUNT_PRODUCT_NAME | varchar | 100 | √ | null |
|
|
The POS discount product name associated with this discount receipt item |
|||||||||||||||||||||||||
| 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 |
|||||||||||||||||||||||||
| COUPON_ID | int | 4 | √ | null |
|
|
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 |
|
|
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 |
|||||||||||||||||||||||||
| CUSTOMER_SCHOLARSHIP_ID | int | 4 | √ | null |
|
|
Customer scholarship ID |
|||||||||||||||||||||||||
| 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 |
|||||||||||||||||||||||||
| VOIDED | varchar | 2 | null |
|
|
Whether the receipt detail has been voided (Yes/No) |
||||||||||||||||||||||||||
| 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 |