Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| PAYMENT_CHARGEBACK_ID | int | 4 | √ | null |
|
|
ID used to uniquely identify a chargeback daily status row (for internal use) |
||||
| CLIENT_TRANSACTION_ID | varchar | 50 | √ | null |
|
|
Client transaction ID for the charged back payment |
||||
| RECEIPT_PAYMENT_ID | int | 4 | √ | null |
|
|
Original receipt payment ID for the charged back payment |
||||
| COMPANY_ID | int | 4 | √ | null |
|
|
ID of the company who made the payment |
||||
| COMPANY_NAME | varchar | 255 | √ | null |
|
|
Name of the company who made the payment |
||||
| CUSTOMER_ID | int | 4 | √ | null |
|
|
ID of the customer who made the payment |
||||
| CUSTOMER_NAME | varchar | 511 | null |
|
|
Name of the customer who made the payment |
|||||
| RECEIPT_HEADER_ID | int | 4 | √ | null |
|
|
Original receipt header ID for the charged back payment |
||||
| RECEIPT_NUMBER | nvarchar | 8000 | √ | null |
|
|
Original receipt number for the charged back payment |
||||
| AMS_TRANSACTION_ID | varchar | 50 | √ | null |
|
|
The AMS transaction ID for the charged back payment |
||||
| ORIGINAL_TRANSACTION_DATE_TIME | datetime | 16,3 | √ | null |
|
|
Date and time the original payment transaction occurred as recorded in the payment processing system, and is presented in the time zone of that system which may differ from your local time zone |
||||
| ORIGINAL_TRANSACTION_DATE_ONLY | date | 20 | √ | null |
|
|
Date the original payment transaction occurred as recorded in the payment processing system, and is presented in the time zone of that system which may differ from your local time zone (date only) |
||||
| ORIGINAL_TRANSACTION_AMOUNT | money | 21,4 | √ | null |
|
|
Amount of the original payment transaction as recorded in the payment processing system |
||||
| MERCHANT_DESCRIPTOR | varchar | 50 | √ | null |
|
|
Merchant Descriptor of the organization for which an order was taken. This descriptor is sent to the payment processor and may show on CC statements. |
||||
| ORDER_DESCRIPTOR | varchar | 100 | √ | null |
|
|
Descriptor providing some information about the order from which the charged back payment originated |
||||
| ORDER_REFERENCE | varchar | 100 | √ | null |
|
|
Order reference from the source application for which the payment transaction occurred |
||||
| CC_CARDHOLDER_NAME | varchar | 100 | √ | null |
|
|
Name of the cardholder for which the chargeback was initiated |
||||
| CC_ACCOUNT_TYPE | varchar | 50 | √ | null |
|
|
Type of credit card that was used for the payment being charged back |
||||
| CC_ACCOUNT_LAST_FOUR | varchar | 4 | √ | null |
|
|
Last 4 digits of the credit card number used as payment for the transaction being charged back |
||||
| ORIGINAL_CHARGEBACK_DATE | date | 20 | √ | null |
|
|
Date a chargeback for the transaction was first received. May be different than the current chargeback date if the chargeback was submitted more than once |
||||
| CHARGEBACK_DATE | date | 20 | √ | null |
|
|
Date the chargeback for the transaction was initiated |
||||
| CHARGEBACK_DUE_DATE | date | 20 | √ | null |
|
|
Date by which supporting documentation must be presented to protest a chargeback |
||||
| LAST_CHARGEBACK_ACTIVITY_DATE | date | 20 | √ | null |
|
|
Last date chargeback activity occurred. Corresponds to the date that the current chargeback category was set |
||||
| CHARGEBACK_CATEGORY | varchar | 200 | √ | null |
|
|
Identifies the last activity that occurred regarding the chargeback |
||||
| CHARGEBACK_REASON | varchar | 200 | √ | null |
|
|
Identifies the reason that the chargeback was initiated |
||||
| PRESENTMENT_CURRENCY | varchar | 3 | √ | null |
|
|
The three-character ISO code identifying the currency in which presentment amounts are displayed |
||||
| PRESENTMENT_AMOUNT | money | 21,4 | √ | null |
|
|
The amount of this chargeback at the time it was received from the issuer, expressed in the cardholder’s Presentment Currency |
||||
| CURRENT_ACTION_PRESENTMENT_AMOUNT | money | 21,4 | √ | null |
|
|
The value of the current action, as indicated by the Category, for the item included in this Data Record and indicated in the merchant’s presentment currency |
||||
| SETTLEMENT_CURRENCY | varchar | 3 | √ | null |
|
|
The three-character ISO code identifying the currency in which settlement amounts are displayed |
||||
| SETTLEMENT_AMOUNT | money | 21,4 | √ | null |
|
|
The amount of this chargeback, expressed in the merchant’s settlement currency, at the time it was received from the issuer |
||||
| CURRENT_ACTION_SETTLEMENT_AMOUNT | money | 21,4 | √ | null |
|
|
The value of the items included in a Data Record expressed in the merchant’s settlement funding currency |
||||
| DISPUTE_STATUS | varchar | 25 | √ | null |
|
|
Dispute status, options include WIN, LOSS and PENDING. A status of WIN means that the cardholder’s dispute of the charge has been rejected, while a status of LOSS means that the cardholder’s dispute of the charge has been upheld. |
||||
| IS_FINAL | varchar | 5 | √ | null |
|
|
Indicates whether or not this chargeback is considered to be in a final state. At this point the status should be WIN or LOSS with enough time passed since the outcome that it is unlikely to be challenged (Yes/No) |
||||
| FINALIZATION_DATE | date | 20 | √ | null |
|
|
Date the chargeback was considered finalized |
||||
| MODIFIED_DATE_TIME | datetime | 16,3 | √ | null |
|
|
Date and Time the record was last modified |
||||
| MODIFIED_DATE_ONLY | date | 20 | √ | null |
|
|
Date the record was last modified (date only) |
||||
| INVOICE_NUMBER | varchar | 80 | √ | null |
|
|
The identifying number of the invoice generated for reimbursement of the chargeback amount |
||||
| INVOICE_BILLED_AMOUNT | money | 21,4 | √ | null |
|
|
The amount of the generated invoice |
||||
| INVOICE_PROCESSED_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The date and time that the invoice was processed |
||||
| INVOICE_PROCESSED_DATE_ONLY | date | 20 | √ | null |
|
|
The date that the invoice was processed (date only) |
||||
| INVOICE_EMAIL_ADDRESSES | varchar | 800 | √ | null |
|
|
The email distribution list to be notified regarding the invoice |
||||
| INVOICE_MANUALLY_ADJUSTED | varchar | 5 | √ | null |
|
|
Whether the invoice amount has been manually adjusted (Yes/No) |
||||
| INVOICE_STATUS | varchar | 50 | √ | null |
|
|
The status of the invoice for this chargeback |
||||
| ACTIVE_HUB_KEY | int | 4 | null |
|
|
The Hub record ID |
|||||
| 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 | varchar | 50 | √ | null |
|
|
The ID value from the Active Net system |