Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| CUSTOMER_THIRD_PARTY_BILLING_ID | int | 4 | null |
|
|
The customer third-party billing ID |
|||||
| CUSTOMER_ID | int | 4 | √ | null |
|
|
The ID of the customer |
||||
| PAYER_COMPANY_ID | int | 4 | √ | null |
|
|
The ID of the third-party payer company |
||||
| APPROVAL_DATE | date | 20 | √ | null |
|
|
The date of the approval if specified |
||||
| EFFECTIVE_DATE | date | 20 | √ | null |
|
|
The effective date of the third-party billing |
||||
| EXPIRY_DATE | date | 20 | √ | null |
|
|
The expiration date of the third-party billing |
||||
| RECEIVE_PERIOD_DURATION | varchar | 15 | √ | null |
|
|
The duration period for the third-party billing (None / Monthly / 3 Months / 6 Months / Annual / Until Expiry) |
||||
| RECEIVE_AMOUNT | money | 21,4 | √ | null |
|
|
The third-party billing amount to receive |
||||
| RECEIVE_PERCENT | money | 21,4 | √ | null |
|
|
The third-party billing percent to receive |
||||
| RECEIVE_TYPE | varchar | 25 | √ | null |
|
|
How the amount is to be calculated and billed to the third-party (Per Customer / Per Family / Per Month Per Customer / Percentage) |
||||
| ELIGIBILITY_REVIEW_PERIOD | varchar | 20 | √ | null |
|
|
The eligibility review period for the third-party billing (None / Monthly / 3 Months / 6 Months / Annual / Custom Review Date) |
||||
| ELIGIBILITY_REVIEW_DATE | date | 20 | √ | null |
|
|
The custom eligibility review date) |
||||
| 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_BILLINGS_CUSTOMER_THIRD_PARTY_BILLING_ID_ORG_ID_PK | Primary key | Asc/Asc | CUSTOMER_THIRD_PARTY_BILLING_ID + ORG_ID |
| CUSTOMER_THIRD_PARTY_BILLINGS_CUSTOMER_ID_IX | Performance | Asc | CUSTOMER_ID |
| CUSTOMER_THIRD_PARTY_BILLINGS_PAYER_COMPANY_ID_IX | Performance | Asc | PAYER_COMPANY_ID |
| CUSTOMER_THIRD_PARTY_BILLINGS_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |