Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| CREDITCARD_UPDATE_ID | int | 4 | null |
|
|
|||
| AMS_SENT_ON | varchar | 30 | √ | null |
|
|
||
| CUSTOMER_ID | int | 4 | √ | null |
|
|
The ID of the customer that the payment or refund authorization request was for |
|
| CC_NUMBER | varchar | 20 | √ | null |
|
|
Last four of the old credit card |
|
| CC_EXPIRY | varchar | 10 | √ | null |
|
|
Expiry of the old credit card |
|
| CC_TYPE | varchar | 10 | √ | null |
|
|
Credit Card type |
|
| UPDATED_CC_NUMBER | varchar | 20 | √ | null |
|
|
Last four of the new credit card |
|
| UPDATED_CC_EXPIRY | varchar | 10 | √ | null |
|
|
Expiry of the new credit card |
|
| UPDATED_CC_TYPE | varchar | 10 | √ | null |
|
|
Updated credit card type |
|
| UPDATED_CC_TYPE_DESC | varchar | 50 | √ | null |
|
|
Description of the updated credit card type |
|
| UPDATED_ON | datetime | 16,3 | √ | null |
|
|
Status of the update |
|
| CUSTOMER_NAME | varchar | 511 | null |
|
|
Customer’s name |
||
| HOMEPHONE | varchar | 255 | √ | null |
|
|
Customer’s home phone |
|
| COMPANY_ID | int | 4 | √ | null |
|
|
The ID of the company that the payment or refund authorization request was for |
|
| PACKAGE_NAME | varchar | 255 | √ | null |
|
|
The name of the membership package. |
|
| EFFECTIVE_DATE | datetime | 16,3 | √ | null |
|
|
The effective date of the membership package. |
|
| EXPIRATION_DATE | datetime | 16,3 | √ | null |
|
|
The expiration date of the membership package. |