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. |