GraphQL

Enum Types

Enum types define a set of predefined values that a field can take.

AccountIndex

Indexes for querying Accounts. To optimize query performance and apply desired filters, choose the appropriate index.

Values

ACCOUNT_IDIndex by accountId field. Must supply an accountId: { eq: <id> } filter to the where object.
NAMEIndex by name field. Use to apply query filters on the value of name.
CODEIndex by code field. Use to apply query filters on the value of code.
STATUSIndex by status field. Use to apply query filters on the value of status.
EXTERNAL_IDIndex by externalId field. Must supply an externalId: { eq: <id> } filter to the where object.
CUSTOMUse a custom-defined index. Must supply a custom filter to the where object.
SEARCHUse eventually consisent search. Must supply a search filter to the where object.
CODE_UNIQUEIndex by code field. Must supply an codeUnique: { eq: <id> } filter to the where object.

AccountSetIndex

Indexes for querying AccountSets. To optimize query performance and apply desired filters, choose the appropriate index.

Values

ACCOUNT_SET_IDIndex by accountSetId field. Must supply an accountSetId: { eq: <id> } filter to the where object.
NAMEIndex by name field. Use to apply query filters on the value of name.
CUSTOMUse a custom-defined index. Must supply a custom filter to the where object.
SEARCHUse eventually consisent search. Must supply a search filter to the where object.

AccountSetMemberType

Account set members can be of type Account or AccountSet.

Values

ACCOUNT
ACCOUNT_SET

AccountStatus

Account status determines whether the account is in active use or closed (locked). By default, all accounts are ACTIVE.

When account is LOCKED, it cannot be changed and any attempt to write a ledger entry to this account will raise an error.

Values

ACTIVEACTIVE = Account is open for posting.
LOCKEDLOCKED = Account is locked and will block posting.

AchFileProcessingStatus

Values

UNKNOWNFile Processing state is unknown.
NEWNewly created file processing state.
VALIDATINGFile is being validated.
PARTITIONINGFile is being partitioned for processing.
UPLOADEDFile has been uploaded and will begin processing shortly.
PROCESSINGFile is being processed and create webhooks are being actively sent for this file.
PROCESSEDAll create webhooks have been sent for this file and entries are awaiting settlement.
ERRORThe system encountered an unrecoverable error while processing the file. See processingDetail for more information.
INVALIDThe uploaded file failed validation. See processingDetail for more information.
ABORTEDThe processing of this file was aborted. See processingDetail for more information.
COMPLETEDAll entries from this file process have been either settled or queued for a return file.

AchFileType

Values

RDFI
RDFI_RETURN

BalanceIndex

Indexes for querying Balances. To optimize query performance and apply desired filters, choose the appropriate index.

Values

ACCOUNT_IDIndex by accountId field. Must supply an accountId: { eq: <id> } filter to the where object.
CALCULATIONIndex by calculationId and dimension fields in addition to account.
CUSTOMUse a custom-defined index. Must supply a custom filter to the where object.
SEARCHUse eventually consisent search. Must supply a search filter to the where object.

BalanceLimitType

Values

AVAILABLELimit based on available balance at a particular layer.

BalanceType

All operations in Twisp are strongly consistent and transactionally isolated. Both concurrent and non-concurrent enabled accounts provide the same strong consistency guarantee on balances, but concurrent enabled accounts can adjust their balance isolation levels and latency characteristics according to different user needs.

Values

FINALReturn the latest calculated balance record for the account. This balance may be slightly stale but offers the lowest latency.
PREPAREDReturn the latest calculated balance record plus any committed, but not yet FINAL, entries. This balance is transactionally consistent for the current snapshot and guaranteed to eventually match a FINAL balance record.
PROVISIONALReturn the latest calculated balance record plus any committed, but not yet FINAL, entries along with all in-flight uncommitted entries. This balance is provisional since uncommitted entries are not guaranteed to commit.

BulkQueryExecutionStatus

Values

CREATEDExecution is created but not yet started.
IN_PROGRESSExecution is in progress.
COMPLETEExecution is complete and results are available to download.
ERRORThere was an error that prevented execution.

CalculationBackfillStatus

Values

COMPLETECalculation is completely backfilled or was created before backfill support.
IN_PROGRESSBackfill is in progress.
ERRORThere was an error in the backfill.

CalculationIndex

Values

CALCULATION_IDIndex by calculationId field. Must supply calculationId: { eq: <id> } filter to the where object.
CODEIndex by code field. Must supply code: { eq: <id> } filter to the where object.
STATUSIndex by status field. Must supply status: { eq: <id> } filter to the where object.

CurrencyDisplay

Defines how to render the currency indicator.

Values

SYMBOLShow the symbol for the currency. @example('$1.23') @example('€1.23')
CODEShow the currency code. @example('USD') @example('EUR')
NONEDon't show the code or symbol for the currency.

DebitOrCredit

Debit or credit? Sometimes these are abbreviated to DR and CR.

Values

DEBIT
CREDIT

EndpointIndex

Values

ENDPOINT_IDIndex by endpointId field. Must supply an endpointId: { eq: <id> } filter to the where object.
STATUSIndex by status field. Must supply an status: { eq: <status> } filter to the where object.

EndpointStatus

Values

ENABLED
DISABLED

EndpointType

Values

WEBHOOK
ACH_PROCESSOR

EntryIndex

Indexes for querying Entries. To optimize query performance and apply desired filters, choose the appropriate index.

Values

ENTRY_IDIndex by entryId field. Must supply an entryId: { eq: <id> } filter to the where object.
TRANSACTION_IDIndex by transactionId field. Must supply an transactionId: { eq: <id> } filter to the where object.
CUSTOMUse a custom-defined index. Must supply a custom filter to the where object.
SEARCHUse eventually consisent search. Must supply a search filter to the where object.

IndexOnEnum

Record types which support custom indexes.

Values

Account
AccountSet
Balance
Transaction
TranCode
Entry

JobType

Values

SETTLE_WORKFLOW

JournalIndex

Indexes for querying Journals. To optimize query performance and apply desired filters, choose the appropriate index.

Values

JOURNAL_IDIndex by JOURNAL_ID field. Must supply a journalId: { eq: <id> } filter to the where object.
NAMEIndex by name field. Use to apply query filters on the value of name.
STATUSIndex by status field. Use to apply query filters on the value of status.
CODEIndex by code field. Use to apply query filters on the value of code.

Layer

The ledger can apply a entries to one of three layers: SETTLED, PENDING, and ENCUMBRANCE.

The SETTLED layer is what is actually fully settled.

The PENDING layer is what's settled but also includes holds and pending charges. This can be used to verify the account will have enough funds after the holds and pending transactions have cleared.

The ENCUMBRANCE layer allows us to add future transactions that are scheduled and also goals or budgeting tools to set money aside in the account.

Values

SETTLED
PENDING
ENCUMBRANCE

OpensearchSchemaBinaryMappingType

Values

BINARY

OpensearchSchemaBooleanMappingType

Values

BOOLEAN

OpensearchSchemaDateMappingType

Values

DATE
DATE_NANOS

OpensearchSchemaNumericMappingType

Values

BYTE
DOUBLE
FLOAT
HALF_FLOAT
INTEGER
LONG
UNSIGNED_LONG
SHORT

OpensearchSchemaObjectMappingType

Values

OBJECT

OpensearchSchemaStringMappingType

Values

KEYWORD
TEXT
MATCH_ONLY_TEXT
TOKEN_COUNT
WILDCARD

ParamDataType

Data type of a parameter.

Values

STRING
INTEGER
DECIMAL
BOOLEAN
UUID
DATE
TIMESTAMP
JSON

PolicyAction

Values

SELECT
INSERT
UPDATE
DELETE

PolicyEffect

Values

ALLOW
DENY

RoundingMode

Defines the rounding behavior when formatting units.

Values

HALF_DOWNRounds up if the next digit is > 5, otherwise rounds down.
HALF_UPRounds up if the next digit is >= 5, otherwise rounds down.
DOWNRounds towards 0, truncating extra digits.
UPRounds away from 0.

SQLField_Type

Values

IS_NULL
BYTES
BOOL
DOUBLE
INT
STRING

SortOrder

ASC (ascending) or DESC (descending).

Values

ASC
DESC

SqlStatementStatus

Values

ABORTED
ALL
FAILED
FINISHED
PICKED
STARTED
SUBMITTED

Status

Record status. All records are ACTIVE by default.

To avoid rewriting accounting history, most records are not deleted but simply marked LOCKED, indicating that they should not be used.

Values

ACTIVE
LOCKED

TranCodeIndex

Indexes for querying TranCodes. To optimize query performance and apply desired filters, choose the appropriate index.

Values

TRAN_CODE_IDIndex by tranCodeId field. Must supply a tranCodeId: { eq: <id> } filter to the where object.
CODEIndex by code field. Use to apply query filters on the value of code.
STATUSIndex by status field. Use to apply query filters on the value of status.
CUSTOMUse a custom-defined index. Must supply a custom filter to the where object.
SEARCHUse eventually consisent search. Must supply a search filter to the where object.

TransactionIndex

Indexes for querying Transactions. To optimize query performance and apply desired filters, choose the appropriate index.

Values

TRANSACTION_IDIndex by TRANSACTION_ID field. Must supply a transactionId: { eq: <id> } filter to the where object.
CORRELATION_IDIndex by CORRELATION_ID field. Must supply a correlationId: { eq: <id> } filter to the where object.
EXTERNAL_IDIndex by EXTERNAL_ID field. Must supply an externalId: { eq: <id> } filter to the where object.
CUSTOMUse a custom-defined index. Must supply a custom filter to the where object.
SEARCHUse eventually consisent search. Must supply a search filter to the where object.
TRANSACTION_IDSRetrieve a list of transactions by id. Must supply an ids filter to the where object.

UploadType

Values

BULK_GRAPHQL_VARIABLES
ACH

VelocityControlIndex

Values

VELOCITY_CONTROL_IDIndex by velocityControlId field. Must supply an velocityControlId: { eq: <id> } filter to the where object.
NAMEIndex by name field. Use to apply query filters on the value of name.
ACCOUNT_IDIndex by accountId attached to velocity control. Must supply an accountId: { eq: <id> } filter to the where object.
VELOCITY_LIMIT_ID

VelocityEnforcementAction

Values

WARNReturns a selectable exception on postTransaction.exceptions, but allows transaction to be posted.
VOIDReturns a selectable exception on postTransaction.exceptions, and voids offending transaction.
REJECTReturns an exception as an error, aborting entire request.

VelocityLimitIndex

Values

VELOCITY_LIMIT_IDIndex by velocityLimitId field. Must supply an velocityLimitId: { eq: <id> } filter to the where object.
NAMEIndex by name field. Use to apply query filters on the value of name.