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 |
||||
| AMOUNT | money | 21,4 | √ | null |
|
|
The amount that has been billed to the third party |
||||
| CREATION_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The date and time that the amount was billed to the third party |
||||
| CREATION_WORKSTATION_ID | int | 4 | √ | null |
|
|
The ID of the workstation that generated the third-party billing |
||||
| TRANSACTION_CUSTOMER_ID | int | 4 | √ | null |
|
|
The ID 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 |
||||
| TRANSACTION_ID | int | 4 | √ | null |
|
|
The ID of the transaction that contains the customer charge that has been billed to the third party |
||||
| 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 |
||||
| 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 |
||||
| ROW_VERSION | binary | 8 | √ | null |
|
|
System timestamp (for internal use) |
||||
| 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 |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| CUSTOMER_THIRD_PARTY_BILLING_LINKS_CUSTOMER_THIRD_PARTY_BILLING_LINK_ID_ORG_ID_PK | Primary key | Asc/Asc | CUSTOMER_THIRD_PARTY_BILLING_LINK_ID + ORG_ID |
| CUSTOMER_THIRD_PARTY_BILLING_LINKS_AR_SCHEDULED_DETAIL_ID_IX | Performance | Asc | AR_SCHEDULED_DETAIL_ID |
| CUSTOMER_THIRD_PARTY_BILLING_LINKS_AR_SCHEDULED_HEADER_ID_IX | Performance | Asc | AR_SCHEDULED_HEADER_ID |
| CUSTOMER_THIRD_PARTY_BILLING_LINKS_CREATION_WORKSTATION_ID_IX | Performance | Asc | CREATION_WORKSTATION_ID |
| CUSTOMER_THIRD_PARTY_BILLING_LINKS_CUSTOMER_THIRD_PARTY_BILLING_ID_IX | Performance | Asc | CUSTOMER_THIRD_PARTY_BILLING_ID |
| CUSTOMER_THIRD_PARTY_BILLING_LINKS_RECEIPT_DETAIL_ID_IX | Performance | Asc | RECEIPT_DETAIL_ID |
| CUSTOMER_THIRD_PARTY_BILLING_LINKS_RECEIPT_HEADER_ID_IX | Performance | Asc | RECEIPT_HEADER_ID |
| CUSTOMER_THIRD_PARTY_BILLING_LINKS_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |
| CUSTOMER_THIRD_PARTY_BILLING_LINKS_TRANSACTION_CUSTOMER_ID_IX | Performance | Asc | TRANSACTION_CUSTOMER_ID |
| CUSTOMER_THIRD_PARTY_BILLING_LINKS_TRANSACTION_ID_IX | Performance | Asc | TRANSACTION_ID |