Statement

Attribute Details

• UIDGuid (36)
• Unique guid identifier for the bank statement.
• StatementDateDateTime
• Date when the BankStatement was pulled into AccountRight, format YYYY-MM-DD HH:MM:SS { 'StatementDate': '2014-09-10 13:33:02' }
• DateDateTime
• Transaction date, format YYYY-MM-DD HH:MM:SS { 'Date': '2014-09-10 13:33:02' }
• DescriptionString
• Description text for the transaction.
• Account
• The following set of information pulls through details for an Account
• • UIDGuid (36)
  • Foreign Key: Unique identifier for the account in the form of a guid.
  • NameString (30)
  • Account name belonging to the account record.
  • DisplayIDString (6)
  • Account code format includes separator ie 1-1100{ 'DisplayID': '1-1100' }
  • URIString
  • Uniform resource identifier associated with the account object.
• AmountDecimal (13.2)
• Dollar amount of the withdrawal or deposit.
• IsCreditBoolean
• True indicates a credit into account.
  False indicates a withdrawal from account.
• SourceTransactionsString
• Source transaction.
• • UIDGuid (36)
  • Foreign Key: Unique identifier for the source transaction in the form of a guid.
  • TransactionTypeString (30)
  • Transaction types consist of the following:
    Bill
    Invoice
    SupplierPayment
    CustomerPayment
    SpendMoneyTxn
    ReceiveMoneyTxn
    TransferMoneyTxn
    GeneralJournal
    InventoryAdjustment
    CreditRefund
    CreditSettlement
    DebitRefund
    DebitSettlement
    
  • URIString
  • Uniform resource identifier associated with the transaction object.
• Status String
• Status can consist of the following:
  Uncoded
  Coded
  Hidden
• ReferenceString
• Additionl reference field for the transaction
• URIString
• Uniform resource identifier encompasses all types of names and addresses that refer to objects on the web.
• RowVersionString
• Incrementing number that can be used for change control but does does not preserve a date or a time.

Paging: default page size is set to 400 with a maximum of 1000 results.