Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Multiexcerpt macro
hiddenfalse
nameFields
fallbackfalse

Data Category

Event Field/Column Name

Data Type

Description

Applicability

Sample Value

Notes

Key

TenantId

VARCHAR(32)

glossary_descriptionfalse

ALWAYS

qvo-stg

Key

ClientId

VARCHAR(64)

glossary_descriptionfalse

ALWAYS

Default

Key

ClaimId

VARCHAR(32)

glossary_descriptionfalse

ALWAYS

2306060014C

Key

DisputeId

VARCHAR(32)

glossary_descriptionfalse

ALWAYS

2306050001D

Key

ENTRYIDENTIFIER

VARCHAR(64)

glossary_descriptionfalse

ALWAYS

e5199543-c6b2-4cb6-937e-b278ca95979b

Key

StepIdentifier

VARCHAR(64)

glossary_descriptionfalse

ALWAYS

cb7f68e3-1fb1-49e8-a683-5232cf6992ce

Accounting Details

AMOUNT

NUMBER(9,2)

Amount of the accounting entry performed.

ALWAYS

123.23

Accounting Details

REASON

VARCHAR(64)

glossary_descriptionfalse

ALWAYS

Provisional Credit

Accounting Details

DEBITCREDIT

VARCHAR(16)

168a5d47-cc7d-4afe-859a-d32dcfda4015glossary_descriptionfalse

ALWAYS

Debit, Credit

Accounting Details

COLLECTIONNAME

VARCHAR(64)

glossary_descriptionfalse

ALWAYS

Accountholder, Merchant, Loss, Suspense

Accounting Details

PERFORMEDBYOPERATORID

VARCHAR(128)

12b0df20-31b4-40de-8ffd-59f2151179feglossary_descriptionfalse

ALWAYS

devan.robertson@quavo.com

Metadata

PERFORMEDON

TIMESTAMP_NTZ(9)

glossary_descriptionfalse

ALWAYS

2023-09-09 21:00:00

Accounting Details

EXECUTEDBYOPERATORID

VARCHAR(128)

glossary_descriptionfalse

CONDITIONAL

devan.robertson@quavo.com

Will be populated once accounting entry has been executed.

Accounting Details

EXECUTEDON

TIMESTAMP_NTZ(9)

glossary_descriptionfalse

CONDITIONAL

2023-08-16 17:48:47.709

Will be populated once accounting entry has been executed.

Accounting Details

ExecutionMethod

VARCHAR(32)

glossary_descriptionfalse

CONDITIONAL

AutoAUTO, BATCH, ManualMANUAL, Tracking OnlyTrackingOnly

Will be populated once accounting entry has been executed.

Accounting Details

AccountNumber

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

Applicability depends on accounting plan configuration.

Accounting Details

IsManualEntry

BOOLEAN

c683dd99-4952-42c9-8008-b9e76d7184e1glossary_descriptioneJyLjgUAARUAuQ==false

CONDITIONAL

TRUE

Applicable when the accounting entry is entered by a user instead of generated by the system.

Metadata

EventDateTime

TIMESTAMP_NTZ(9)

glossary_descriptionfalse

ALWAYS

2023-09-09 21:00:00

Metadata

EventIdentifier

VARCHAR(64)

glossary_descriptionfalse

ALWAYS

70b1c86d-d06f-4c93-bab2-0e938a4ef768

Metadata

EventItemId

VARCHAR(64)

glossary_descriptionfalse

ALWAYS

qvo-stg|cb7f68e3-1fb1-49e8-a683-5232cf6992ce