Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ARTRANSACTION_ID | int | 4 | null |
|
|
Unique ID of the table |
||
| ORIGINALARTRANSACTION_ID | int | 4 | √ | null |
|
|
The original AR transaction ID for a series of transactions |
|
| RECEIPTHEADER_ID | int | 4 | √ | null |
|
|
ID of the receipt header that the transaction belongs to |
|
| ARSCHEDULEHEADER_ID | int | 4 | √ | null |
|
|
The AR schedule header ID identifying the payment plan |
|
| RECEIPTDETAIL_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 |
|
| COMPANY_ID | int | 4 | √ | null |
|
|
ID of the company who is the owner of the transaction if applicable |
|
| TRANSACTIONCUSTOMER_ID | int | 4 | √ | null |
|
|
The ID of the customer that the payment plan charge is for |
|
| TRANSACTIONCOMPANY_ID | int | 4 | √ | null |
|
|
The ID of the company that the payment plan charge is for |
|
| SITE_ID | int | 4 | √ | null |
|
|
The ID of the site that the transaction occurred at |
|
| SYSTEMUSER_ID | int | 4 | √ | null |
|
|
ID of the user who created the transaction |
|
| TRANSACTIONTYPE | smallint | 2 | √ | null |
|
|
The transaction type 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 |
|
| VOIDED | smallint | 2 | √ | null |
|
|
Whether the transaction has been voided (1 = voided / 0 = not voided) |
|
| VOIDEDBY | int | 4 | √ | null |
|
|
The ID of the system user who voided the transaction |
|
| VOIDEDON | datetime | 16,3 | √ | null |
|
|
The date and time that the transaction was voided |
|
| ROW_VERSION | binary | 8 | √ | null |
|
|
System timestamp (for internal use) |
|
| ORG_ID | int | 4 | null |
|
|
Your organization’s unique identifier in the Active Net system |
||
| 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 |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| ARTRANSACTIONS_ARTRANSACTION_ID_ORG_ID_PK | Primary key | Asc/Asc | ARTRANSACTION_ID + ORG_ID |