Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| GL_LEDGER_ID | int | 4 | null |
|
|
The GL ledger ID |
|||||
| RECEIPT_DETAIL_ID | int | 4 | √ | null |
|
|
The receipt detail ID that the GL posting is related to. May be null for postings related to cash payment rounding |
||||
| TRANSACTION_ID | int | 4 | √ | null |
|
|
The transaction ID that the GL posting is related to. May be null for postings related to cash payment rounding |
||||
| RECEIPT_HEADER_ID | int | 4 | √ | null |
|
|
The receipt header ID that the GL posting is related to |
||||
| RECEIPT_PAYMENT_ID | int | 4 | √ | null |
|
|
The receipt payment ID that the GL posting is related to, if the postings is for cash payment rounding |
||||
| TRANSACTION_SITE_ID | int | 4 | √ | null |
|
|
The ID of the site that the transaction was generated at |
||||
| REVENUE_SITE_ID | int | 4 | √ | null |
|
|
The ID of the site that the revenue was generated for |
||||
| TRANSACTION_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The date and time that the GL postings were generated |
||||
| GLACCOUNT_ID | int | 4 | √ | null |
|
|
The GL account ID |
||||
| AMOUNT | money | 21,4 | √ | null |
|
|
The GL posting amount, where positive amounts are debits and negative amounts are credits |
||||
| SYSTEMUSER_ID | int | 4 | √ | null |
|
|
The ID of the system user who performed the transaction |
||||
| WORKSTATION_ID | int | 4 | √ | null |
|
|
The ID of the workstation where the transaction was created |
||||
| VOIDED | bit | 1 | √ | null |
|
|
Whether the GL posting has been voided (1 = voided / 0 = not voided) |
||||
| VOIDED_BY | int | 4 | √ | null |
|
|
The ID of the system user who voided the GL posting |
||||
| VOIDED_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The date and time that the GL posting was voided |
||||
| ROW_VERSION | binary | 8 | √ | null |
|
|
System timestamp (for internal use) |
||||
| 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 |
||||
| ORG_ID | int | 4 | null |
|
|
Your organization’s unique identifier in the Active Net system |
|||||
| EXPENSE_ID | int | 4 | √ | null |
|
|
The ID of the expense that this posting is related to |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| RECEIPT_GL_POSTINGS_GL_LEDGER_ID_ORG_ID_PK | Primary key | Asc/Asc | GL_LEDGER_ID + ORG_ID |
| RECEIPT_GL_POSTINGS_EXPENSE_ID_IX | Performance | Asc | EXPENSE_ID |
| RECEIPT_GL_POSTINGS_GLACCOUNT_ID_ORG_ID_VOIDED_IX | Performance | Asc/Asc/Asc | GLACCOUNT_ID + ORG_ID + VOIDED |
| RECEIPT_GL_POSTINGS_nc_cs_ix | Performance | Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc | GL_LEDGER_ID + GLACCOUNT_ID + RECEIPT_DETAIL_ID + RECEIPT_HEADER_ID + RECEIPT_PAYMENT_ID + REVENUE_SITE_ID + SYSTEMUSER_ID + TRANSACTION_DATE_TIME + TRANSACTION_ID + TRANSACTION_SITE_ID + VOIDED + VOIDED_BY + VOIDED_DATE_TIME + WORKSTATION_ID |
| RECEIPT_GL_POSTINGS_RECEIPT_DETAIL_ID_IX | Performance | Asc | RECEIPT_DETAIL_ID |
| RECEIPT_GL_POSTINGS_RECEIPT_HEADER_ID_IX | Performance | Asc | RECEIPT_HEADER_ID |
| RECEIPT_GL_POSTINGS_RECEIPT_PAYMENT_ID_IX | Performance | Asc | RECEIPT_PAYMENT_ID |
| RECEIPT_GL_POSTINGS_REVENUE_SITE_ID_IX | Performance | Asc | REVENUE_SITE_ID |
| RECEIPT_GL_POSTINGS_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |
| RECEIPT_GL_POSTINGS_SYSTEMUSER_ID_IX | Performance | Asc | SYSTEMUSER_ID |
| RECEIPT_GL_POSTINGS_TRANSACTION_DATE_TIME_IX | Performance | Asc | TRANSACTION_DATE_TIME |
| RECEIPT_GL_POSTINGS_TRANSACTION_ID_IX | Performance | Asc | TRANSACTION_ID |
| RECEIPT_GL_POSTINGS_TRANSACTION_SITE_ID_IX | Performance | Asc | TRANSACTION_SITE_ID |
| RECEIPT_GL_POSTINGS_VOIDED_IX | Performance | Asc/Asc | VOIDED + VOIDED_DATE_TIME |
| RECEIPT_GL_POSTINGS_WORKSTATION_ID_IX | Performance | Asc | WORKSTATION_ID |