AccountIndex
Indexes for querying Accounts. To optimize query performance and apply desired filters, choose the appropriate index.
Values
ACCOUNT_ID | Index by accountId field. Must supply an accountId: { eq: <id> } filter to the where object. |
NAME | Index by name field. Use to apply query filters on the value of name . |
CODE | Index by code field. Use to apply query filters on the value of code . |
STATUS | Index by status field. Use to apply query filters on the value of status . |
EXTERNAL_ID | Index by externalId field. Must supply an externalId: { eq: <id> } filter to the where object. |
CUSTOM | Use a custom-defined index. Must supply a custom filter to the where object. |
SEARCH | Use eventually consisent search. Must supply a search filter to the where object. |
CODE_UNIQUE | Index 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_ID | Index by accountSetId field. Must supply an accountSetId: { eq: <id> } filter to the where object. |
NAME | Index by name field. Use to apply query filters on the value of name . |
CUSTOM | Use a custom-defined index. Must supply a custom filter to the where object. |
SEARCH | Use eventually consisent search. Must supply a search filter to the where object. |
AccountSetMemberType
Account set members can be of type Account or AccountSet.
Values
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
ACTIVE | ACTIVE = Account is open for posting. |
LOCKED | LOCKED = Account is locked and will block posting. |
BalanceIndex
Indexes for querying Balances. To optimize query performance and apply desired filters, choose the appropriate index.
Values
ACCOUNT_ID | Index by accountId field. Must supply an accountId: { eq: <id> } filter to the where object. |
CALCULATION | Index by calculationId and dimension fields in addition to account. |
CUSTOM | Use a custom-defined index. Must supply a custom filter to the where object. |
SEARCH | Use eventually consisent search. Must supply a search filter to the where object. |
BalanceLimitType
Values
AVAILABLE | Limit based on available balance at a particular layer. |
BalanceType
On concurrent enabled accounts and account sets, multiple isolation levels for balance read operations are available. Each level provides differing consistency and latency characteristics.
Values
FINAL | Return the latest committed balance record for the account. This balance is eventually consistent and offers the lowest latency. |
PREPARED | Return the latest committed 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. |
PROVISIONAL | Return the latest committed 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
CREATED | Execution is created but not yet started. |
IN_PROGRESS | Execution is in progress. |
COMPLETE | Execution is complete and results are available to download. |
ERROR | There was an error that prevented execution. |
CalculationBackfillStatus
Values
COMPLETE | Calculation is completely backfilled or was created before backfill support. |
IN_PROGRESS | Backfill is in progress. |
ERROR | There was an error in the backfill. |
CalculationIndex
Values
CALCULATION_ID | Index by calculationId field. Must supply calculationId: { eq: <id> } filter to the where object. |
CODE | Index by code field. Must supply code: { eq: <id> } filter to the where object. |
STATUS | Index by status field. Must supply status: { eq: <id> } filter to the where object. |
CurrencyDisplay
Defines how to render the currency indicator.
Values
SYMBOL | Show the symbol for the currency. @example('$1.23') @example('€1.23') |
CODE | Show the currency code. @example('USD') @example('EUR') |
NONE | Don't show the code or symbol for the currency. |
DebitOrCredit
Debit or credit? Sometimes these are abbreviated to DR and CR.
Values
EndpointIndex
Values
ENDPOINT_ID | Index by endpointId field. Must supply an endpointId: { eq: <id> } filter to the where object. |
STATUS | Index by status field. Must supply an status: { eq: <status> } filter to the where object. |
EndpointStatus
Values
EndpointType
Values
EntryIndex
Indexes for querying Entries. To optimize query performance and apply desired filters, choose the appropriate index.
Values
ENTRY_ID | Index by entryId field. Must supply an entryId: { eq: <id> } filter to the where object. |
TRANSACTION_ID | Index by transactionId field. Must supply an transactionId: { eq: <id> } filter to the where object. |
CUSTOM | Use a custom-defined index. Must supply a custom filter to the where object. |
SEARCH | Use 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
JournalIndex
Indexes for querying Journals. To optimize query performance and apply desired filters, choose the appropriate index.
Values
JOURNAL_ID | Index by JOURNAL_ID field. Must supply a journalId: { eq: <id> } filter to the where object. |
NAME | Index by name field. Use to apply query filters on the value of name . |
STATUS | Index by status field. Use to apply query filters on the value of status . |
CODE | Index 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
OpensearchSchemaBooleanMappingType
Values
OpensearchSchemaDateMappingType
Values
OpensearchSchemaNumericMappingType
Values
BYTE | |
DOUBLE | |
FLOAT | |
HALF_FLOAT | |
INTEGER | |
LONG | |
UNSIGNED_LONG | |
SHORT | |
OpensearchSchemaObjectMappingType
Values
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
PolicyEffect
Values
RoundingMode
Defines the rounding behavior when formatting units.
Values
HALF_DOWN | Rounds up if the next digit is > 5, otherwise rounds down. |
HALF_UP | Rounds up if the next digit is >= 5, otherwise rounds down. |
DOWN | Rounds towards 0, truncating extra digits. |
UP | Rounds away from 0. |
SQLField_Type
Values
IS_NULL | |
BYTES | |
BOOL | |
DOUBLE | |
INT | |
STRING | |
SortOrder
ASC
(ascending) or DESC
(descending).
Values
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
TranCodeIndex
Indexes for querying TranCodes. To optimize query performance and apply desired filters, choose the appropriate index.
Values
TRAN_CODE_ID | Index by tranCodeId field. Must supply a tranCodeId: { eq: <id> } filter to the where object. |
CODE | Index by code field. Use to apply query filters on the value of code . |
STATUS | Index by status field. Use to apply query filters on the value of status . |
CUSTOM | Use a custom-defined index. Must supply a custom filter to the where object. |
SEARCH | Use 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_ID | Index by TRANSACTION_ID field. Must supply a transactionId: { eq: <id> } filter to the where object. |
CORRELATION_ID | Index by CORRELATION_ID field. Must supply a correlationId: { eq: <id> } filter to the where object. |
EXTERNAL_ID | Index by EXTERNAL_ID field. Must supply an externalId: { eq: <id> } filter to the where object. |
CUSTOM | Use a custom-defined index. Must supply a custom filter to the where object. |
SEARCH | Use eventually consisent search. Must supply a search filter to the where object. |
TRANSACTION_IDS | Retrieve 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_ID | Index by velocityControlId field. Must supply an velocityControlId: { eq: <id> } filter to the where object. |
NAME | Index by name field. Use to apply query filters on the value of name . |
ACCOUNT_ID | Index by accountId attached to velocity control. Must supply an accountId: { eq: <id> } filter to the where object. |
VELOCITY_LIMIT_ID | |
VelocityEnforcementAction
Values
WARN | Returns a selectable exception on postTransaction.exceptions, but allows transaction to be posted. |
VOID | Returns a selectable exception on postTransaction.exceptions, and voids offending transaction. |
REJECT | Returns an exception as an error, aborting entire request. |
VelocityLimitIndex
Values
VELOCITY_LIMIT_ID | Index by velocityLimitId field. Must supply an velocityLimitId: { eq: <id> } filter to the where object. |
NAME | Index by name field. Use to apply query filters on the value of name . |