ADO.NET Provider for Sage Business Cloud Accounting

Build 22.0.8479

OtherPayments

Query OtherPayments in Sage Business Cloud Accounting.

Table Specific Information

Query the available OtherPayments

Select

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

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

For example, the following queries are processed server side:

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

Update

Updates are performed based on Id.

UPDATE OtherPayments SET TransactionTypeId='abc' WHERE Id='123'

Delete

You must specify the Id of the OtherPayments to delete it.

DELETE FROM OtherPayments WHERE id ='123' 

Columns

Name Type ReadOnly References Description
Id [KEY] String False

The unique identifier for the item

CreatedAt Datetime True

The datetime when the item was created

TransactionTypeDisplayedAs String False

The name of the resource

TransactionTypeLegacyId Int False

The legacy ID for the item

TransactionTypeId String False

The unique identifier for the item

NetAmount String False

The net amount of the payment

PaymentMethodId String False

PaymentMethods.Id

The unique identifier for the item

Deletable Bool False

Indicates whether or not the payment can be deleted

Reference String False

A reference of the payment

TotalAmount String False

The total amount of the payment

TaxAddressRegionDisplayedAs String False

The name of the resource

TaxAddressRegionLegacyId Int False

The legacy ID for the item

TaxAddressRegionId String False

The unique identifier for the item

WithholdingTaxRate String False

IRPF withheld tax rate

DeletedAt Datetime True

The datetime when the item was deleted

BankAccountId String False

The unique identifier for the item

Editable Bool False

Indicates whether or not the payment can be edited

DisplayedAs String False

The name of the resource

TaxAmount String False

The tax amount of the payment

ContactId String False

Contacts.Id

The unique identifier for the item

TransactionId String False

Transactions.Id

The unique identifier for the item

LegacyId Int False

The legacy ID for the item

Date Datetime True

The date of the payment

WithholdingTaxAmount String False

IRPF withheld tax amount

OtherPaymentLineItemAggregate String False

The payment lines of the payment

UpdatedAt Datetime True

The datetime when the item was last updated

DeletedSince Datetime True

FromDate Datetime True

HasAttachments String False

ToDate Datetime True

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