# Stock Item
## Stock Item's Database
| UI Name | Database | Type | Remarks |
|---|
| Item Code | ItemCode
| String | E.g.: Item-Code-01 |
| UOM | UOM
| String | E.g.: UNIT |
| Rate | Rate
| Integer | E.g.: 1 |
| Description | Description
| String | E.g.: Description |
| Description 2 | Desc2
| String | E.g.: Description2 |
| Item Group | ItemGroup
| String | E.g.: ItemGroup |
| Item Type | ItemType
| String | E.g.: ItemType |
| Lead Time | LeadTime
| String | E.g.: LeadTime |
| Duty Rate | Duty Rate
| String | E.g.: Duty Rate |
| Supply Tax Code | TaxCode
| String | E.g.: Tax Code |
| Purchase Tax Code | PurchaseTaxCode
| String | E.g.: PurchaseTaxCode |
| Tariff Code | Tariff Code
| String | E.g.: Tariff Code |
| Shelf | Shelf
| String | E.g.: Shelf |
| Price 1 | Price
| Decimal | E.g.: 1.00 |
| Price 2 | Price2
| Decimal | E.g.: 1.00 |
| Price3 | Price3
| Decimal | E.g.: 1.00 |
| Price 4 | Price4
| Decimal | E.g.: 1.00 |
| Price 5 | Price5
| Decimal | E.g.: 1.00 |
| Price 6 | Price6
| Decimal | E.g.: 1.00 |
| Standard Cost | Cost
| Integer | E.g.: 1.8 |
| Min. Selling Price | MinSalePrice
| Decimal | E.g.: 1.00 |
| Max. Selling Price | MaxSalePrice
| Decimal | E.g.: 1.00 |
| Min. Purchase Price | MinPurchasePrice
| Decimal | E.g.: 1.00 |
| Max. Purchase Price | MaxPurchasePrice
| Decimal | E.g.: 1.00 |
| Balance Qty | BalQty
| Integer | E.g.: 100 |
| Min. Qty | MinQty
| Decimal | E.g.: 1.00 |
| Max. Qty | MaxQty
| Decimal | E.g.: 1.00 |
| Normal Level | NormalLevel
| Decimal | E.g.: 1.00 |
| Re-order Level | ReOLevel
| Decimal | E.g.: 1.00 |
| Re-order Qty | ReOQty
| Decimal | E.g.: 1.00 |
## Stock Item's Sample Code
{% hint style="warning" %}
Remember to change to the **correct field** before proceeding to run **ANY** script.
{% endhint %}
{% tabs %}
{% tab title="Logic Script" %}
{% hint style="info" %}
To find `{fieldName}`, you are required to have access to **Alpha** or use **Network** in Developer Tools `[F12]`.
{% endhint %}
{% code fullWidth="true" %}
```python
debug("test")
moduleName = "{YOUR-MODULE-NAME}"
inistateKeyField = "DocumentId"
keyField = "Doc"
modifiedDateField = "LastModified"
fields = [["DocumentId", "Doc"], ["LastModified", "LastModified"]]
inistateFields = []
result = list(inputs["list"]).ToList()
for item in result:
entry = Module(moduleName).find({
"$and": [
{"Dynamic.Extension.{fieldName}": item["{YOUR-ITEM-CODE}"],
{"Dynamic.Extension.{fieldName}": item["{YOUR-UOM}"]
]
})
debug('entry' + item['ItemCode'].ToString(),entry)
form = Module(moduleName).execute("sync", entry)
debug('form',form)
form["Item Code"] = item["{YOUR-ITEM-CODE}"]
form["UOM"] = item["{YOUR-UOM}"]
form["Rate"] = item["{YOUR-RATE}"]
form["Description"] = item["{YOUR-DESCRIPTION}"]
form["Description 2"] = item["{YOUR-DESCRIPTION-2}"]
form["Item Group"] = item["{YOUR-ITEM-GROUP}"]
form["Item Type"] = item["{YOUR-ITEM-TYPE}"]
form["Lead Time"] = item["{YOUR-LEAD-TIME}"]
form["Duty Rate"] = item["{YOUR-DUTY-RATE}"]
form["Supply Tax Code"] = item["{YOUR-SUPPLY-TAX-CODE}"]
form["Purchase Tax Code"] = item["{YOUR-PURCHASE-TAX-CODE}"]
form["Tariff Code"] = item["{YOUR-TARIFF-CODE}"]
form["Shelf"] = item["{YOUR-SHELF}"]
form["Price 1"] = item["{YOUR-PRICE-1}"]
form["Price 2"] = item["{YOUR-PRICE-2}"]
form["Price 3"] = item["{YOUR-PRICE-3}"]
form["Price 4"] = item["{YOUR-PRICE-4}"]
form["Price 5"] = item["{YOUR-PRICE-5}"]
form["Price 6"] = item["{YOUR-PRICE-6}"]
form["Standard Cost"] = item["{YOUR-STANDARD-COST}"]
form["Min. Selling Price"] = item["{YOUR-MIN-SELLING-PRICE}"]
form["Max. Selling Price"] = item["{YOUR-MAX-SELLING-PRICE}"]
form["Min. Purchase Price"] = item["{YOUR-MIN-PURCHASE-PRICE}"]
form["Max. Purchase Price"] = item["{YOUR-MAX-PURCHASE-PRICE}"]
form["Balance Qty"] = item["{YOUR-BALANCE-QTY}"]
form["Min. Qty"] = item["{YOUR-MIN-QTY}"]
form["Max. Qty"] = item["{YOUR-MAX-QTY}"]
form["Normal Level"] = item["{YOUR-NORMAL-LEVEL}"]
form["Re-order Level"] = item["{YOUR-REORDER-LEVEL}"]
form["Re-order Qty"] = item["{YOUR-REORDER-QTY}"]
debug("form "+ item['ItemCode'].ToString(), form)
Module(moduleName).submit(entry, form)
```
{% endcode %}
{% endtab %}
{% tab title="SQL Script" %}
{% hint style="danger" %}
This is a sample SQL, may not be as same as your database.\
\*DECLARE @date DATETIME = '2025-01-01 00:00:00';
{% endhint %}
```sql
;WITH TopItems AS (
SELECT TOP (10)
i.ItemCode
FROM Item AS i
WHERE i.LastModified > @date
ORDER BY i.LastModified ASC
)
SELECT
i.DocKey,
i.ItemCode,
u.UOM,
u.Rate,
i.Description,
i.Desc2,
i.ItemGroup,
i.ItemType,
i.LeadTime,
i.DutyRate,
i.TaxCode,
i.PurchaseTaxCode,
i.TariffCode,
u.Shelf,
u.Price,
u.Price2,
u.Price3,
u.Price4,
u.Price5,
u.Price6,
u.Cost,
u.MinSalePrice,
u.MaxSalePrice,
u.MinPurchasePrice,
u.MaxPurchasePrice,
b.BalQty,
u.MinQty,
u.MaxQty,
u.NormalLevel,
u.ReOLevel,
u.ReOQty,
i.LastModified
FROM Item AS i
INNER JOIN itemUOM AS u
ON i.ItemCode = u.ItemCode
LEFT JOIN ItemBatchBalQty AS b
ON i.ItemCode = b.ItemCode
AND u.UOM = b.UOM
INNER JOIN TopItems AS t
ON i.ItemCode = t.ItemCode
ORDER BY i.LastModified DESC;
```
{% endtab %}
{% tab title="jobs.json" %}
{% hint style="warning" %}
In order to sync, you must include **`LastModified`** in **`SELECT`**
{% endhint %}
```json
"SQLSync": [
{
"name": "SyncBackStockItem",
"enabled": true,
"connectionString": "Data Source={YOUR-SERVER-NAME};Initial Catalog={YOUR-DATABASE-NAME};User Id=sa2;Password=sa2;",
"hook": "https://api.inistate.com/api/automationHook/hook/{MODULE-ID}-{LOGIC-NAME}",
"sql": ";WITH TopItems AS ( SELECT TOP(10) i.ItemCode FROM Item AS i WHERE i.LastModified > @date ORDER BY i.LastModified ASC ) SELECT i.DocKey, i.ItemCode, u.UOM, u.Rate, i.Description, i.Desc2, i.ItemGroup, i.ItemType, i.LeadTime, i.DutyRate, i.TaxCode, i.PurchaseTaxCode, i.TariffCode, u.Shelf, u.Price, u.Price2, u.Price3, u.Price4, u.Price5, u.Price6, u.Cost, u.MinSalePrice, u.MaxSalePrice, u.MinPurchasePrice, u.MaxPurchasePrice, b.BalQty, u.MinQty, u.MaxQty, u.NormalLevel, u.ReOLevel, u.ReOQty, i.LastModified FROM Item AS i INNER JOIN itemUOM AS u ON i.ItemCode = u.ItemCode LEFT JOIN ItemBatchBalQty AS b ON i.ItemCode = b.ItemCode AND u.UOM = b.UOM INNER JOIN TopItems t ON i.ItemCode = t.ItemCode ORDER BY i.LastModified DESC;",
"debug": false,
"lastSync": "{LAST-SYNC-DATE-TIME}",
"start": null
}
]
```
{% endtab %}
{% endtabs %}
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://inistate.gitbook.io/home/advanced/integration/accounting-1/stock-item.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.