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 |
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 |