Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| CUSTOMER_THIRD_PARTY_BILLING_LINK_ID | int | 4 | null |
|
|
The customer third-party billing link ID |
|||||
| CUSTOMER_THIRD_PARTY_BILLING_ID | int | 4 | √ | null |
|
|
The customer third-party billing ID |
||||
| PAYER_COMPANY_ID | int | 4 | √ | null |
|
|
The ID of the third-party payer company |
||||
| PAYER_COMPANY_NAME | varchar | 255 | √ | null |
|
|
The name of the third-party payer company |
||||
| AMOUNT | money | 21,4 | √ | null |
|
|
The amount that has been billed to the third party |
||||
| TRANSACTION_CUSTOMER_ID | int | 4 | √ | null |
|
|
The ID of the customer whose transaction charge has been billed to the third party |
||||
| TRANSACTION_CUSTOMER_NAME | varchar | 511 | √ | null |
|
|
The name of the customer whose transaction charge has been billed to the third party |
||||
| RECEIPT_HEADER_ID | int | 4 | √ | null |
|
|
The ID of the receipt that contains the customer charge that has been billed to the third party |
||||
| RECEIPT_NUMBER | nvarchar | 8000 | √ | null |
|
|
The number of the receipt that contains the customer charge that has been billed to the third party |
||||
| TRANSACTION_ID | int | 4 | √ | null |
|
|
The ID of the transaction that contains the customer charge that has been billed to the third party |
||||
| ROOT_TRANSACTION_ID | int | 4 | √ | null |
|
|
The root transaction ID for a chain of transactions |
||||
| TRANSACTION_MODULE_NAME | varchar | 20 | √ | null |
|
|
The system module that the transaction belongs to |
||||
| TRANSACTION_EVENT_NAME | varchar | 200 | √ | null |
|
|
The event or item description for this transaction |
||||
| RECEIPT_DETAIL_ID | int | 4 | √ | null |
|
|
The ID of the receipt detail that contains the customer charge that has been billed to the third party |
||||
| RECEIPT_DETAIL_DESCRIPTION | varchar | 150 | √ | null |
|
|
The description of the receipt detail that contains the customer charge that has been billed to the third party |
||||
| TRANSACTION_SITE_ID | int | 4 | √ | null |
|
|
The site ID where the customer transaction was created |
||||
| TRANSACTION_SITE_NAME | varchar | 255 | √ | null |
|
|
The site name where the customer transaction was created |
||||
| REVENUE_SITE_ID | int | 4 | √ | null |
|
|
The site ID for the item that the customer transaction is for |
||||
| REVENUE_SITE_NAME | varchar | 255 | √ | null |
|
|
The site name for the item that the customer transaction is for |
||||
| FACILITY_ID | int | 4 | √ | null |
|
|
The facility ID for the customer transaction |
||||
| FACILITY_NAME | varchar | 255 | √ | null |
|
|
The facility name for the customer transaction |
||||
| PROGRAM_ID | int | 4 | √ | null |
|
|
The program ID for the customer transaction |
||||
| PROGRAM_NAME | varchar | 255 | √ | null |
|
|
The program name for the customer transaction |
||||
| PERMIT_ID | int | 4 | √ | null |
|
|
The ID of the permit for the customer transaction |
||||
| PERMIT_NUMBER | int | 4 | √ | null |
|
|
The permit number for the customer transaction |
||||
| MEMBERSHIP_ID | int | 4 | √ | null |
|
|
The ID of the membership for the customer transaction |
||||
| PACKAGE_ID | int | 4 | √ | null |
|
|
The package ID for the customer transaction |
||||
| PACKAGE_NAME | varchar | 255 | √ | null |
|
|
The package name for the customer transaction |
||||
| ACTIVITY_ID | int | 4 | √ | null |
|
|
The activity ID for the customer transaction |
||||
| ACTIVITY_NAME | varchar | 100 | √ | null |
|
|
The activity name for the customer transaction |
||||
| ACTIVITY_NUMBER | varchar | 20 | √ | null |
|
|
The activity number for the customer transaction |
||||
| POSPRODUCT_ID | int | 4 | √ | null |
|
|
The POS product ID for the customer transaction |
||||
| PRODUCT_NAME | varchar | 100 | √ | null |
|
|
The POS product name for the customer transaction |
||||
| AR_SCHEDULED_HEADER_ID | int | 4 | √ | null |
|
|
The ID of the AR schedule header for the payment plan that contains the billed charge |
||||
| AR_SCHEDULED_DETAIL_ID | int | 4 | √ | null |
|
|
The ID of the AR schedule detail for the payment plan that contains the billed charge |
||||
| CREATION_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The date and time that the amount was billed to the third party |
||||
| CREATION_DATE_ONLY | date | 20 | √ | null |
|
|
The date that the amount was billed to the third party (date only) |
||||
| CREATION_WORKSTATION_ID | int | 4 | √ | null |
|
|
The ID of the workstation that generated the third-party billing |
||||
| CREATION_WORKSTATION_NAME | varchar | 45 | √ | null |
|
|
The name of the workstation that generated the third-party billing |
||||
| 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 |