Excel Add-In for Sage Business Cloud Accounting

Build 22.0.8479

OtherPaymentLineItem

Query OtherPaymentLineItem in Sage Business Cloud Accounting.

Table Specific Information

Query the available OtherPaymentLineItem

Select

The driver uses the Sage Accounting API to process search criteria that refer to BankAccountId,ContactId,DeletedSince,FromDate,HasAttachments,ToDate,TransactionTypeId,UpdatedOrCreatedSince columns. The driver processes other filters client-side within the driver.

  • BankAccountId supports the '=' operator.
  • ContactId supports the '=' operator.
  • DeletedSince supports the '=' operator.
  • FromDate supports the '=' operator.
  • HasAttachments supports the '=' operator.
  • ToDate supports the '=' operator.
  • TransactionTypeId supports the '=' operator.
  • UpdatedOrCreatedSince supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM OtherPaymentLineItem WHERE BankAccountId='abc'
SELECT * FROM OtherPaymentLineItem WHERE ContactId='abc'
SELECT * FROM OtherPaymentLineItem WHERE DeletedSince='2018-12-15'
SELECT * FROM OtherPaymentLineItem WHERE FromDate='2018-12-15'
SELECT * FROM OtherPaymentLineItem WHERE HasAttachments='abc'
SELECT * FROM OtherPaymentLineItem WHERE ToDate='abc'
SELECT * FROM OtherPaymentLineItem WHERE TransactionTypeId='abc'
SELECT * FROM OtherPaymentLineItem WHERE UpdatedOrCreatedSince='2018-12-15'

Columns

Name Type References Description
Id [KEY] String The unique identifier for the item
Details String The details of the payment line
DisplayedAs String The name of the resource
GstAmount String The gst or hst tax amount for the other payment
TradeOfAsset Bool Whether the line item is marked as trade of asset.
LedgerAccountId String

LedgerAccounts.Id

The unique identifier for the item
LegacyId Int The legacy ID for the item
TaxBreakdownAggregate String The tax breakdown for the payment line
IsPurchaseForResale Bool Identifies whether the line item is for resale. (Ireland only)
TaxRateId String

TaxRates.Id

The unique identifier for the item
PstAmount String The pst or qst tax amount for the other payment
TotalAmount String The total amount of the payment line
TaxAmount String The tax amount of the payment line
NetAmount String The net amount of the payment line
BaseId String Parent ID
BankAccountId String
ContactId String
DeletedSince Datetime
FromDate Datetime
HasAttachments String
ToDate String
TransactionTypeId String

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479