Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| PRELIMINARY_DRAFT_ID | int | 4 | √ | null |
|
|
The preliminary draft ID |
||||
| DRAFT_DATE | date | 20 | √ | null |
|
|
The expected renewal date for the membership |
||||
| MEMBERSHIP_ID | int | 4 | √ | null |
|
|
The ID of the membership to be renewed |
||||
| PRIMARY_MEMBER_CUSTOMER_ID | int | 4 | √ | null |
|
|
The ID of the primary customer to which the membership to be renewed is assigned |
||||
| PRIMARY_MEMBER_CUSTOMER_NAME | varchar | 511 | √ | null |
|
|
The name of the primary customer to which the membership to be renewed is assigned |
||||
| PACKAGE_ID | int | 4 | √ | null |
|
|
The ID of the package for the membership to be renewed |
||||
| PACKAGE_NAME | varchar | 255 | √ | null |
|
|
The name of the package for the membership to be renewed |
||||
| MEMBERSHIP_EXPIRES_DATE | date | 20 | √ | null |
|
|
The current expiration date of the membership |
||||
| AMOUNT_NOT_INCLUDING_DISCOUNTS | money | 21,4 | √ | null |
|
|
The expected renewal amount excluding any discounts that may be applied |
||||
| AMOUNT_OF_SCHOLARSHIPS | money | 21,4 | √ | null |
|
|
The expected amount of scholarships to be applied at time of renewal |
||||
| AMOUNT_OF_DISCOUNTS | money | 21,4 | √ | null |
|
|
The expected amount of discounts to be applied at time of renewal |
||||
| AMOUNT_OF_USAGE_FEES | money | 21,4 | √ | null |
|
|
The expected amount of usage fees to be applied at time of renewal |
||||
| AMOUNT_OF_THIRD_PARTY_BILLINGS | money | 21,4 | √ | null |
|
|
The expected amount of third party billings to be applied at time of renewal |
||||
| PAYER_CUSTOMER_ID | int | 4 | √ | null |
|
|
The ID of customer to be set as payer for the renewal charges |
||||
| PAYER_CUSTOMER_NAME | varchar | 511 | √ | null |
|
|
The name of customer to be set as payer for the renewal charges |
||||
| PAYER_COMPANY_ID | int | 4 | √ | null |
|
|
The ID of company to be set as payer for the renewal charges |
||||
| PAYER_COMPANY_NAME | varchar | 255 | √ | null |
|
|
The name of company to be set as payer for the renewal charges |
||||
| AUTOMATIC_RENEWAL_TYPE | varchar | 20 | √ | null |
|
|
The payment method selected for the auto-renewal of the membership (Not Auto-Renewed / Credit Card / ECP / Manual Deduction / Payment Plan) |
||||
| CARD_TYPE | varchar | 50 | √ | null |
|
|
The card type of credit card to be used for the membership renewal payment |
||||
| CARD_NUMBER | varchar | 10 | √ | null |
|
|
The masked credit card number to be used for the membership renewal payment |
||||
| CARD_EXPIRATION | varchar | 10 | √ | null |
|
|
The credit card expiration date (mm/yyyy) to be used for the membership renewal payment |
||||
| BANK_ACCOUNT_NUMBER | varchar | 10 | √ | null |
|
|
The masked bank account number to be used for the membership renewal payment |
||||
| ACTIVE_HUB_KEY | int | 4 | null |
|
|
The Hub record ID |
|||||
| ACTIVE_HUB_PROCESS_ID | bigint | 8 | √ | null |
|
|
The Hub sync process ID |
||||
| CARD_TYPE_ID | Unknown | 0 | null |
|
|
||||||
| REVENUE_SITE_ID | int | 4 | √ | null |
|
|
The ID of the site that the membership renewal revenue will be posted to |
||||
| REVENUE_SITE_NAME | varchar | 255 | √ | null |
|
|
The name of the site that the membership renewal revenue will be posted to |
||||
| IS_ERROR_EXPECTED | varchar | 5 | √ | null |
|
|
Whether an error is expected for this membership renewal (Yes/No) |
||||
| ERROR_DESCRIPTION | varchar | 2000 | √ | null |
|
|
The error message that is expected for this membership renewal |
||||
| UPDATED_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The date and time that this membership draft was generated |
||||
| UPDATED_DATE_ONLY | date | 20 | √ | null |
|
|
The date that this membership draft was generated (date only) |
||||
| LAST_SYNC_TIME | datetime | 16,3 | null |
|
|
Date and time Hub record was last modified |
|||||
| ORG_ID | int | 4 | √ | null |
|
|
Your organization’s unique identifier in the Active Net system |