Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| 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 |
|
| SITE_NAME | varchar | 255 | √ | null |
|
|
Name of the workstation where the receipt was created |
|
| WORKSTATION_ID | int | 4 | √ | null |
|
|
ID of the workstation where the receipt was created |
|
| WORKSTATION_NAME | varchar | 45 | √ | null |
|
|
Name of the workstation where the receipt was created |
|
| SYSTEMUSER_ID | int | 4 | √ | null |
|
|
ID of the system user who created the receipt |
|
| SYSTEM_USER_NAME | varchar | 511 | null |
|
|
Name of the system user who created the receipt |
||
| RECEIPT_NUMBER | nvarchar | 8000 | √ | 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_CUSTOMER_NAME | varchar | 511 | null |
|
|
The name of the customer who created the online receipt |
||
| ONLINE_WAIVER_INITIALS | varchar | 4 | √ | null |
|
|
Waiver initials that were entered online for this receipt |
|
| IS_ABANDONED | varchar | 3 | null |
|
|
Whether the receipt header has been abandoned (Yes/No) |
||
| VOIDED | varchar | 3 | null |
|
|
Whether the receipt header has been voided (Yes/No) |
||
| VOIDED_BY | int | 4 | √ | null |
|
|
The ID of the system user who voided the receipt header |
|
| VOIDED_BY_USER_NAME | varchar | 511 | null |
|
|
The name 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 |
|
| VOIDED_DATE_ONLY | date | 20 | √ | null |
|
|
The date that the receipt header 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 |