Accounting View
- Devan Robertson
Name | AccountingView |
|---|---|
Type | View |
Description | Includes all accounting entries just like the Accounting table, as well as additional columns from various other tables that are relevant in the context of accounting entries. |
Â
Data Category | Event Field/Column Name | Data Type | Description | Applicability | Sample Value | Notes |
|---|---|---|---|---|---|---|
Key | TenantId | VARCHAR(32) | ALWAYS | qvo-stg | Â | |
Key | Tenant | VARCHAR(64) |
| ALWAYS | Default | Â |
Key | ClientId | VARCHAR(64) | ALWAYS | Default | Â | |
Key | Client | VARCHAR(64) |
| ALWAYS | Default | Â |
Claim Details | ClaimType | VARCHAR(64) | CONDITIONAL | Card-Pinless | Â | |
Claim Details | ClaimCategory | VARCHAR(64) | CONDITIONAL | Fraud | Â | |
Claim Details | ClaimReason | VARCHAR(64) | CONDITIONAL | Stolen | Â | |
Card Details | CardType | VARCHAR(16) |
| CONDITIONAL | Debit | Â |
Card Details | BIN | VARCHAR(8) | CONDITIONAL | 412356, 41235678 | Â | |
Claim Details | ClaimStatusSummary | VARCHAR | ALWAYS | Open | Â | |
Key | ClaimId | VARCHAR(32) | ALWAYS | 2306060014C | Â | |
Key | DisputeId | VARCHAR(32) | ALWAYS | 2306060014D | Â | |
Accounting Details | EntryCategory | VARCHAR(64) | ALWAYS | GL Entry | Â | |
Accounting Details | DebitCredit | VARCHAR | ALWAYS | Â | Â | |
Accounting Details | Collection | VARCHAR(64) | ALWAYS | Accountholder, Merchant, Loss, Suspense | Â | |
Accounting Details | Account | VARCHAR(128) | Account number associated with the account being debited or credited. Will be obfuscated it the account number is a full card number. | CONDITIONAL | 123456789 | Available in 24.01.03. |
Accounting Details | Reason | VARCHAR(64) | ALWAYS | Provisional Credit | Â | |
Accounting Details | Amount | NUMBER(9,2) | Amount of the accounting entry performed. | ALWAYS | 123.23 | Â |
Accounting Details | PerformedOn | TIMESTAMP_NTZ(9) | ALWAYS | 2023-09-09 21:00:00 | Â | |
Accounting Details | PerformedBy | VARCHAR | ALWAYS | D. Robertson | Â | |
Accounting Details | ExecutedOn | TIMESTAMP_NTZ(9) | ALWAYS | 2023-09-09 21:00:00 | Â | |
Accounting Details | ExecutedBy | VARCHAR | ALWAYS | D. Robertson | Â | |
Accounting Details | Method | VARCHAR(32) | ALWAYS | AUTO | Â | |
Accounting Details | IsManualEntry | BOOLEAN | CONDITIONAL | TRUE | Available in 24.01.03. | |
Transaction Details | TransactionDate | TIMESTAMP_NTZ(9) | ALWAYS | 2023-09-09 21:00:00 | Â | |
Transaction Details | TransactionPostingDate | TIMESTAMP_NTZ(9) | ALWAYS | 2023-09-09 21:00:00 | Â | |
Transaction Details | MCC | VARCHAR | CONDITIONAL | 5532 | Â | |
Transaction Details | MerchantName | VARCHAR | CONDITIONAL | AMAZON | Â | |
Transaction Details | AcquirerReferenceNumber | VARCHAR | CONDITIONAL | 24055233349083742325779 | Â |
Change Log
Date | Change Summary |
|---|---|
12/10/2024 | Timestamp columns converted from NTZ to TZ format for compatibility. |