Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| GL_LEDGER_ID | int | 4 | null |
|
|
GL ledger ID |
|||||
| RECEIPT_DETAIL_ID | int | 4 | √ | null |
|
|
The receipt detail ID that the GL posting is related to. May be null for postings related to cash payment rounding |
||||
| TRANSACTION_ID | int | 4 | √ | null |
|
|
The transaction ID that the GL posting is related to. May be null for postings related to cash payment rounding |
||||
| RECEIPT_PAYMENT_ID | int | 4 | √ | null |
|
|
The receipt payment ID that the GL posting is related to, if the postings is for cash payment rounding |
||||
| GLACCOUNT_ID | int | 4 | √ | null |
|
|
GL account ID |
||||
| GL_ACCOUNT_NAME | varchar | 200 | √ | null |
|
|
GL account name |
||||
| GL_ACCOUNT_NUMBER | varchar | 200 | √ | null |
|
|
GL account number |
||||
| AMOUNT | money | 21,4 | √ | null |
|
|
Total amount posted to the GL, where positive amounts are debits and negative amounts are credits |
||||
| CHARGE_ID | int | 4 | √ | null |
|
|
ID of the related charge record |
||||
| CHARGE_NAME | varchar | 150 | √ | null |
|
|
The receipt charge name |
||||
| TRANSACTION_SITE_ID | int | 4 | √ | null |
|
|
ID of the transaction site |
||||
| TRANSACTION_SITE_NAME | varchar | 255 | √ | null |
|
|
Name of the transaction site |
||||
| REVENUE_SITE_ID | int | 4 | √ | null |
|
|
ID of the site where the revenue is recognized |
||||
| REVENUE_SITE_NAME | varchar | 255 | √ | null |
|
|
Name of the site where the revenue is recognized |
||||
| WORKSTATION_ID | int | 4 | √ | null |
|
|
ID of the workstation where the transaction occurred |
||||
| WORKSTATION_NAME | varchar | 45 | √ | null |
|
|
Name of the workstation where the transaction occurred |
||||
| TRANSACTION_DATE_TIME | datetime | 16,3 | √ | null |
|
|
Transaction date and time |
||||
| TRANSACTION_DATE_ONLY | date | 20 | √ | null |
|
|
Transaction date (date only) |
||||
| RECEIPT_HEADER_ID | int | 4 | √ | null |
|
|
ID of the receipt header |
||||
| RECEIPT_NUMBER | nvarchar | 8000 | √ | null |
|
|
Number of the receipt |
||||
| ACTIVITY_ID | int | 4 | √ | null |
|
|
ID of the activity that this posting is related to |
||||
| ACTIVITY_NAME | varchar | 100 | √ | null |
|
|
Name of the activity that this posting is related to |
||||
| ACTIVITY_NUMBER | varchar | 20 | √ | null |
|
|
Number of the activity that this posting is related to |
||||
| SEASON_ID | int | 4 | √ | null |
|
|
ID of the parent activity season that this posting is related to |
||||
| SEASON_NAME | varchar | 40 | √ | null |
|
|
Name of the parent activity season that this posting is related to |
||||
| CHILD_SEASON_ID | int | 4 | √ | null |
|
|
ID of the child activity season that this posting is related to |
||||
| CHILD_SEASON_NAME | varchar | 40 | √ | null |
|
|
Name of the child activity season that this posting is related to |
||||
| PROGRAM_ID | int | 4 | √ | null |
|
|
ID of the program that this posting is related to |
||||
| PROGRAM_NAME | varchar | 255 | √ | null |
|
|
Name of the program that this posting is related to |
||||
| SESSION_ID | int | 4 | √ | null |
|
|
ID of the program session that this posting is related to |
||||
| SESSION_NAME | varchar | 255 | √ | null |
|
|
Name of the program session that this posting is related to |
||||
| PACKAGE_ID | int | 4 | √ | null |
|
|
ID of the package that this posting is related to |
||||
| PACKAGE_NAME | varchar | 255 | √ | null |
|
|
Name of the package that this posting is related to |
||||
| FACILITY_ID | int | 4 | √ | null |
|
|
ID of the facility or resource that this posting is related to |
||||
| FACILITY_NAME | varchar | 255 | √ | null |
|
|
Name of the facility or resource that this posting is related to |
||||
| PERMIT_ID | int | 4 | √ | null |
|
|
ID of the permit that this posting is related to |
||||
| PERMIT_NUMBER | int | 4 | √ | null |
|
|
Number of the permit that this posting is related to |
||||
| POSPRODUCT_ID | int | 4 | √ | null |
|
|
ID of the POS product that this posting is related to |
||||
| PRODUCT_NAME | varchar | 100 | √ | null |
|
|
Name of the POS product that this posting is related to |
||||
| CAMPAIGN_ID | int | 4 | √ | null |
|
|
ID of the fundraising campaign that this posting is related to |
||||
| CAMPAIGN_NAME | varchar | 50 | √ | null |
|
|
Name of the fundraising campaign that this posting is related to |
||||
| CUSTOMER_ID | int | 4 | √ | null |
|
|
Customer ID |
||||
| CUSTOMER_FIRST_NAME | varchar | 255 | √ | null |
|
|
Customer’s first name |
||||
| CUSTOMER_LAST_NAME | varchar | 255 | √ | null |
|
|
Customer’s last name |
||||
| COMPANY_ID | int | 4 | √ | null |
|
|
Company ID |
||||
| COMPANY_NAME | varchar | 255 | √ | null |
|
|
Company name |
||||
| SYSTEMUSER_ID | int | 4 | √ | null |
|
|
ID of the system user who created the transaction |
||||
| SYSTEM_USER_NAME | varchar | 511 | null |
|
|
Name of the system user who created the transaction |
|||||
| STAFF_NOTES | varchar | 8000 | √ | null |
|
|
Staff notes added at the time of transaction |
||||
| CUSTOMER_SCHOLARSHIP_ID | int | 4 | √ | null |
|
|
Customer scholarship ID |
||||
| EXPENSE_ID | int | 4 | √ | null |
|
|
The ID of the expense that this posting is related to |
||||
| VOIDED | varchar | 2 | null |
|
|
Whether the GL posting has been voided (Yes/No) |
|||||
| 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 |
|||||
| source_id | int | 4 | null |
|
|
The ID value from the Active Net system |
|||||
| ACCOUNT_TYPE | varchar | 100 | √ | null |
|
|
Type name of the GL account |
||||
| SYSTEM_ACCOUNT | smallint | 2 | √ | null |
|
|
System GL account number |
||||
| SYSTEM_ACCOUNT_NAME | varchar | 100 | √ | null |
|
|
System GL account name |