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