Developer Programs

Learn

Docs

transaction_raw

Pipelined Data Sets > General Ledger > transaction_raw

Column nameDescriptionModeTypeLength
IdThe ID of the transaction set the transaction applies toREQUIREDSTRING
TransactionIdA unique ID of the transactionREQUIREDSTRING
AccountIdA unique ID for the accountREQUIREDSTRING
SequenceNumberThe unique sequence number to order the transactions in the transaction setREQUIREDINTEGER
DebitCreditDefines if the transaction debits or credits the accountREQUIREDINTEGER
AmountThe amount of the transactionREQUIREDNUMERIC
DescriptionThe description of the transactionREQUIREDSTRING
EffectiveDateThe date of the the transaction is effectiveREQUIREDDATE
BranchIdThe unique id of the branch's location the account belongs toREQUIREDSTRING
PostedDateThe system date the transaction postedNULLABLETIMESTAMP


Have a Question?

Did this page help you?

Last updated Wed Mar 4 2026