Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int identity | 4 | √ | null |
|
|
The Hub record ID |
||||||||||||||||||||||||||||
| RECEIPT_HEADER_ID | int | 4 | √ | null |
|
|
Receipt header ID |
||||||||||||||||||||||||||||
| RECEIPT_TYPE | varchar | 25 | √ | null |
|
|
Type of receipt (Receipt / Refund Voucher / Non-Monetary Receipt / Permit Charges Summary / Contract Charges Summary) |
||||||||||||||||||||||||||||
| SITE_ID | int | 4 | √ | null |
|
|
ID of the workstation where the receipt was created |
||||||||||||||||||||||||||||
| WORKSTATION_ID | int | 4 | √ | null |
|
|
ID of the workstation where the receipt was created |
||||||||||||||||||||||||||||
| SYSTEMUSER_ID | int | 4 | √ | null |
|
|
ID of the system user who created the receipt |
||||||||||||||||||||||||||||
| RECEIPT_NUMBER | money | 21,4 | √ | null |
|
|
Receipt number |
||||||||||||||||||||||||||||
| RECEIPT_DATE_TIME | datetime | 16,3 | √ | null |
|
|
Date and time that the receipt was created |
||||||||||||||||||||||||||||
| RECEIPT_NOTES | varchar | 8000 | √ | null |
|
|
Receipt notes entered by the user |
||||||||||||||||||||||||||||
| PRINTED | varchar | 5 | √ | null |
|
|
Whether the receipt has been printed (Yes/No) |
||||||||||||||||||||||||||||
| TOTAL_FEE_AMOUNT | money | 21,4 | √ | null |
|
|
Total fee amount for this receipt |
||||||||||||||||||||||||||||
| PREFUND_AMOUNT_USED | money | 21,4 | √ | null |
|
|
Total prefund amount used on this receipt |
||||||||||||||||||||||||||||
| CREDIT_CARD_AMOUNT | money | 21,4 | √ | null |
|
|
Total credit card amount charged or refunded for this receipt |
||||||||||||||||||||||||||||
| IS_ONLINE_RECEIPT | varchar | 5 | √ | null |
|
|
Whether the receipt was created online (Yes/No) |
||||||||||||||||||||||||||||
| ONLINE_CUSTOMER_ID | int | 4 | √ | null |
|
|
The ID of the customer who created the online receipt |
||||||||||||||||||||||||||||
| ONLINE_WAIVER_INITIALS | varchar | 4 | √ | null |
|
|
Waiver initials that were entered online for this receipt |
||||||||||||||||||||||||||||
| 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_SURCHARGE_AMOUNT | money | 21,4 | √ | null |
|
|
Amount of convenience fee that is a surcharge |
||||||||||||||||||||||||||||
| CONVENIENCE_FEE_ABSORBED_DISCOUNT_AMOUNT | money | 21,4 | √ | null |
|
|
Amount of convenience fee discount that was absorbed |
||||||||||||||||||||||||||||
| CONVENIENCE_FEE_SURCHARGE_DISCOUNT_AMOUNT | money | 21,4 | √ | null |
|
|
Amount of convenience fee discount that is a surcharge |
||||||||||||||||||||||||||||
| RECEIPT_DETAIL_PAYMENT_GENERATED_DATE_TIME | datetime | 16,3 | √ | null |
|
|
Date and time that the payments were allocated to the receipt details for this receipt |
||||||||||||||||||||||||||||
| REVENUE_DISTRIBUTION_PROCESSED_DATE_TIME | datetime | 16,3 | √ | null |
|
|
Date and time that revenue distribution was processed for this receipt |
||||||||||||||||||||||||||||
| 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) |
||||||||||||||||||||||||||||
| IS_ABANDONED | bit | 1 | ((0)) |
|
|
Whether the receipt header has been abandoned (1 = abandoned / 0 = not abandoned) |
|||||||||||||||||||||||||||||
| VOIDED | bit | 1 | ((0)) |
|
|
Whether the receipt header has been voided (1 = voided / 0 = not voided) |
|||||||||||||||||||||||||||||
| VOIDED_BY | int | 4 | √ | null |
|
|
The ID of the system user who voided the receipt header |
||||||||||||||||||||||||||||
| VOIDED_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The date and time that the receipt header was voided |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| RECEIPT_HEADERS_ACTIVE_HUB_KEY_PK | Primary key | Asc | ACTIVE_HUB_KEY |
| RECEIPT_HEADERS_IS_ABANDONED_IX | Performance | Asc | IS_ABANDONED |
| RECEIPT_HEADERS_nc_cs_ix | Performance | Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc | IS_ABANDONED + ONLINE_CUSTOMER_ID + RECEIPT_DATE_TIME + RECEIPT_HEADER_ID + RECEIPT_NUMBER + SITE_ID + SYSTEMUSER_ID + VOIDED + VOIDED_BY + VOIDED_DATE_TIME + WORKSTATION_ID |
| RECEIPT_HEADERS_ONLINE_CUSTOMER_ID_IX | Performance | Asc | ONLINE_CUSTOMER_ID |
| RECEIPT_HEADERS_RECEIPT_DATE_TIME_IX | Performance | Asc | RECEIPT_DATE_TIME |
| RECEIPT_HEADERS_RECEIPT_HEADER_ID_ORG_ID_UQ | Must be unique | Asc/Asc | RECEIPT_HEADER_ID + ORG_ID |
| RECEIPT_HEADERS_RECEIPT_NUMBER_IX | Performance | Asc | RECEIPT_NUMBER |
| RECEIPT_HEADERS_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |
| RECEIPT_HEADERS_SITE_ID_IX | Performance | Asc | SITE_ID |
| RECEIPT_HEADERS_SYSTEMUSER_ID_IX | Performance | Asc | SYSTEMUSER_ID |
| RECEIPT_HEADERS_VOIDED_IX | Performance | Asc/Asc | VOIDED + VOIDED_DATE_TIME |
| RECEIPT_HEADERS_WORKSTATION_ID_IX | Performance | Asc | WORKSTATION_ID |