Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AR_TRANSACTION_ID | int | 4 | null |
|
|
Unique ID of the table |
||
| ORIGINAL_TRANSACTION_ID | int | 4 | √ | null |
|
|
The original AR transaction ID for a series of transactions |
|
| RECEIPT_HEADER_ID | int | 4 | √ | null |
|
|
ID of the receipt header that the transaction belongs to |
|
| AR_SCHEDULE_HEADER_ID | int | 4 | √ | null |
|
|
The AR schedule header ID identifying the payment plan |
|
| RECEIPT_DETAIL_ID | int | 4 | √ | null |
|
|
The AR schedule detail ID identifying the payment plan charge |
|
| CUSTOMER_ID | int | 4 | √ | null |
|
|
ID of the customer who is the participant of the transaction |
|
| CUSTOMER_NAME | varchar | 511 | null |
|
|
Customer Name |
||
| COMPANY_ID | int | 4 | √ | null |
|
|
ID of the company who is the owner of the transaction if applicable |
|
| COMPANY_NAME | varchar | 255 | √ | null |
|
|
Company Name |
|
| TRANSACTION_CUSTOMER_ID | int | 4 | √ | null |
|
|
The ID of the transacted customer |
|
| TRANSACTION_CUSTOMER_NAME | varchar | 511 | √ | null |
|
|
The name of the transacted customer |
|
| TRANSACTION_COMPANY_ID | int | 4 | √ | null |
|
|
The ID of the transacted company |
|
| TRANSACTION_COMPANY_NAME | varchar | 255 | √ | null |
|
|
The name of the transacted company |
|
| SITE_ID | int | 4 | √ | null |
|
|
The ID of the site that the transaction occurred at |
|
| SITE_NAME | varchar | 255 | √ | null |
|
|
Name of the site where the transaction was done |
|
| SYSTEMUSER_ID | int | 4 | √ | null |
|
|
ID of the user who created the transaction |
|
| SYSTEM_USER_NAME | varchar | 511 | null |
|
|
Name of the user who created the transaction |
||
| TRANSACTION_TYPE_ID | smallint | 2 | √ | null |
|
|
The transaction type ID of the transaction |
|
| TRANSACTION_TYPE | varchar | 200 | √ | null |
|
|
The transaction type description of the transaction |
|
| AMOUNT | money | 21,4 | √ | null |
|
|
Total charged amount for the transaction |
|
| DESCRIPTION | varchar | 200 | √ | null |
|
|
The charge description of this AR transaction |
|
| DATEDUE | datetime | 16,3 | √ | null |
|
|
The date that the payment plan charge will be or was due on |
|
| DATESTAMP | datetime | 16,3 | √ | null |
|
|
The date and time that the transaction was created |
|
| 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 | int | 4 | null |
|
|
The ID value from the Active Net system |
||
| VOIDED | varchar | 3 | null |
|
|
Whether this transaction has been voided |
||
| VOIDED_BY | int | 4 | √ | null |
|
|
The ID of the system user who voided the transaction |
|
| VOIDED_BY_USER_NAME | varchar | 511 | null |
|
|
The name of the system user who voided the transaction |
||
| VOIDED_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The date and time that the transaction was voided |
|
| VOIDED_DATE_ONLY | date | 20 | √ | null |
|
|
The date that the transaction was voided (date only) |