LineItems
Create, update, delete, and query line items in SuiteCRM
Table Specific Information
Select
You can query the Line Items table using any criteria in the WHERE clause. The add-in will use the SuiteCRM API to filter the results.
SELECT * FROM [Line Items] WHERE [Cost Price] > 0 AND [Cost Price] < 500
Insert
Create a Line Item by specifying any writable column.
INSERT INTO [Line Items] (Name, [Part Number], [Cost Price], [group_id]) VALUES ('Leather shoes', 2, 10, 'lineItemGroup2')
Update
You can update any Line Item entry column that is writable, by specifying the Id.
UPDATE [Line Items] SET Quantity = 100 WHERE Id = 'Test123'
Delete
Delete a Line Item by specifying the Id.
DELETE FROM [Line Items] WHERE Id = '10003'
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | String | False |
The unique identifier of the line item. |
| Assignedto | String | False |
The user name of the user assigned to the record. |
| AssignedUserId | String | False |
The Id of the user assigned to the record. |
| CostPrice | Double | False |
The line item's cost price |
| CostPrice(DefaultCurrency) | Double | True |
The line item's cost price in the system's default currency |
| CreatedById | String | True |
The Id of the user who created the record. |
| CreatedByName | String | True |
The name of the user who created the record. |
| Currency | String | False |
Id of the currency used for currency values |
| DateCreated | Datetime | True |
The date the record was created. |
| DateModified | Datetime | True |
The date the record was last modified. |
| Deleted | Bool | False |
The record deletion indicator. |
| Description | String | False |
Description for the item |
| Discount | Double | False |
The line item's product discount |
| Discount(DefaultCurrency) | Double | True |
The line item's product discount in the system's default currency |
| DiscountAmount | Double | False |
The line item's discount amount |
| DiscountAmount(DefaultCurrency) | Double | True |
The line item's discount amount in the system's default currency |
| DiscountType | String | False |
The type of discount for the item |
| Group | String | False |
Group name the line item belongs to |
| group_id | String | False |
Group Id the line item belongs to |
| ListPrice | Double | False |
The line item's list price |
| ListPrice(DefaultCurrency) | Double | True |
The line item's list price in the system's default currency |
| ModifiedById | String | True |
The Id of the user who last modified the record. |
| ModifiedByName | String | True |
The name of the user who last modified the record. |
| Name | String | False |
Name assigned to the line item |
| Note | String | False |
Description for the line item |
| Number | Int | False |
Number assigned to the line item |
| ParentID | String | False |
Id of the line item's parent |
| Relatedto | String | False |
Parent name the line item is related to |
| ParentType | String | False |
Id of the line item's parent |
| PartNumber | String | False |
Part number assigned to the line items group |
| ProductID | String | False |
Id assigned to the line item product |
| Quantity | String | False |
Quantity of the line item |
| Tax | String | False |
The line item's VAT |
| TaxAmount | Double | False |
The line item's VAT amount |
| TaxAmount(DefaultCurrency) | Double | True |
The line item's VAT amount in the system's default currency |
| TotalPrice | Double | False |
The line item's total price |
| TotalPrice(DefaultCurrency) | Double | True |
The line item's total price in the system's default currency |
| UnitPrice | Double | False |
The line item's unit price |
| UnitPrice(DefaultCurrency) | Double | True |
The line item's unit price in the system's default currency |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Rows@Next | String |
Identifier for the next page of results. Do not set this value manually. |