StockItem
Retrieve StockItems.
Table Specific Information
Select
The connector will use the Tally API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector.
- String supports the '=, !=,<, <=, >, >=, LIKE, ORDER BY' comparisons.
For example these queries are processed server side:
SELECT * FROM StockItem WHERE Narration LIKE 'Item%' SELECT * FROM StockItem WHERE GSTApplicable != NULL SELECT * FROM StockItem WHERE ValuationMethod = 'Default' AND CostingMethod = 'Avg. Cost' SELECT * FROM StockItem WHERE LastSaleParty = 'OutState Party [GST Test]' OR OutwardQuantity = '0 Nos' SELECT * FROM StockItem WHERE IsBatchWiseOn > 'No' SELECT * FROM StockItem ORDER BY RemoteAltGUID Desc
Columns
| Name | Type | Description |
| Name | String | The Name value of the StockItem. |
| ActiveFrom | Date | The ActiveFrom value of the StockItem. |
| ActiveTo | Date | The ActiveTo value of the StockItem. |
| PriceLevelDate | Date | The PriceLevelDate value of the StockItem. |
| Guid | String | The Guid value of the StockItem. |
| PriceLevel | String | The PriceLevel value of the StockItem. |
| Parent | String | The Parent value of the StockItem. |
| Category | String | The Category value of the StockItem. |
| Narration | String | The Narration value of the StockItem. |
| RemoteGUID | String | The RemoteGUID value of the StockItem. |
| RemoteAltGUID | String | The RemoteAltGUID value of the StockItem. |
| RequestorRule | String | The RequestorRule value of the StockItem. |
| TDSApplicable | String | The TDSApplicable value of the StockItem. |
| TCSApplicable | String | The TCSApplicable value of the StockItem. |
| GSTApplicable | String | The GSTApplicable value of the StockItem. |
| TaxClassificationName | String | The TaxClassificationName value of the StockItem. |
| Description | String | The Description value of the StockItem. |
| GSTTypeofSupply | String | The GSTTypeofSupply value of the StockItem. |
| ServiceTaxApplicable | String | The ServiceTaxApplicable value of the StockItem. |
| ExciseApplicability | String | The ExciseApplicability value of the StockItem. |
| SalesTaxCessApplicable | String | The SalesTaxCessApplicable value of the StockItem. |
| VATApplicable | String | The VATApplicable value of the StockItem. |
| LedgerName | String | The LedgerName value of the StockItem. |
| CostingMethod | String | The CostingMethod value of the StockItem. |
| ValuationMethod | String | The ValuationMethod value of the StockItem. |
| BaseUnits | String | The BaseUnits value of the StockItem. |
| AdditionalUnits | String | The AdditionalUnits value of the StockItem. |
| ExciseTaxType | String | The ExciseTaxType value of the StockItem. |
| NatureofItem | String | The NatureofItem value of the StockItem. |
| ExciseItemClassification | String | The ExciseItemClassification value of the StockItem. |
| OldBasicTariffType | String | The OldBasicTariffType value of the StockItem. |
| TCSCategory | String | The TCSCategory value of the StockItem. |
| BasicTariffType | String | The BasicTariffType value of the StockItem. |
| VatCommodity | String | The VatCommodity value of the StockItem. |
| EntryTaxCommodity | String | The EntryTaxCommodity value of the StockItem. |
| VatBaseUnit | String | The VatBaseUnit value of the StockItem. |
| VatTrailUnit | String | The VatTrailUnit value of the StockItem. |
| ReOrderPeriod | String | The ReOrderPeriod value of the StockItem. |
| ReOrderRoundType | String | The ReOrderRoundType value of the StockItem. |
| MinOrderPeriod | String | The MinOrderPeriod value of the StockItem. |
| MinOrderRoundType | String | The MinOrderRoundType value of the StockItem. |
| GSTRepUoM | String | The GSTRepUoM value of the StockItem. |
| GSTConvUnit | String | The GSTConvUnit value of the StockItem. |
| IsCostCentresOn | String | The IsCostCentresOn value of the StockItem. |
| IsBatchWiseOn | String | The IsBatchWiseOn value of the StockItem. |
| IsPerishableOn | String | The IsPerishableOn value of the StockItem. |
| IsEntryTaxApplicable | String | The IsEntryTaxApplicable value of the StockItem. |
| IsCostTrackingOn | String | The IsCostTrackingOn value of the StockItem. |
| IsMstFromSync | String | The IsMstFromSync value of the StockItem. |
| IsUpdatingTargetId | String | The IsUpdatingTargetId value of the StockItem. |
| AsOriginal | String | The AsOriginal value of the StockItem. |
| IsRateInclusiveVAT | String | The IsRateInclusiveVAT value of the StockItem. |
| IgnorePhysicalDifference | String | The IgnorePhysicalDifference value of the StockItem. |
| IgnoreNegativeStock | String | The IgnoreNegativeStock value of the StockItem. |
| TreatSalesasManufactured | String | The TreatSalesasManufactured value of the StockItem. |
| TreatPurchasesasConsumed | String | The TreatPurchasesasConsumed value of the StockItem. |
| TreatRejectsasScrap | String | The TreatRejectsasScrap value of the StockItem. |
| HasMfgDate | String | The HasMfgDate value of the StockItem. |
| AllowUseofExpiredItems | String | The AllowUseofExpiredItems value of the StockItem. |
| IgnoreBatches | String | The IgnoreBatches value of the StockItem. |
| IgnoreGodowns | String | The IgnoreGodowns value of the StockItem. |
| CalcOnMRP | String | The CalcOnMRP value of the StockItem. |
| ExcludeJrnlForValuation | String | The ExcludeJrnlForValuation value of the StockItem. |
| IsMRPInclOfTax | String | The IsMRPInclOfTax value of the StockItem. |
| IsAddlTaxExempt | String | The IsAddlTaxExempt value of the StockItem. |
| IsSupplementryDutyOn | String | The IsSupplementryDutyOn value of the StockItem. |
| GVATIsExciseAppl | String | The GVATIsExciseAppl value of the StockItem. |
| ReOrderAsHigher | String | The ReOrderAsHigher value of the StockItem. |
| MinOrderAsHigher | String | The MinOrderAsHigher value of the StockItem. |
| IsExciseCalculateonMRP | String | The IsExciseCalculateonMRP value of the StockItem. |
| InclusiveTax | String | The InclusiveTax value of the StockItem. |
| GSTCalcSlabOnMRP | String | The GSTCalcSlabOnMRP value of the StockItem. |
| ModifyMRPRate | String | The ModifyMRPRate value of the StockItem. |
| SortPosition | Decimal | The SortPosition value of the StockItem. |
| Alterid | Decimal | The Alterid value of the StockItem. |
| RemoteAlterID | Decimal | The RemoteAlterID value of the StockItem. |
| Denominator | Decimal | The Denominator value of the StockItem. |
| Conversion | Decimal | The Conversion value of the StockItem. |
| RateofMRP | Decimal | The RateofMRP value of the StockItem. |
| BasicRateOfExcise | Decimal | The BasicRateOfExcise value of the StockItem. |
| RateOfEntryTax | Decimal | The RateOfEntryTax value of the StockItem. |
| RateofVAT | Decimal | The RateofVAT value of the StockItem. |
| RateofSAT | Decimal | The RateofSAT value of the StockItem. |
| VatBaseNo | Decimal | The VatBaseNo value of the StockItem. |
| VatTrailNo | Decimal | The VatTrailNo value of the StockItem. |
| VatActualRatio | Decimal | The VatActualRatio value of the StockItem. |
| ReOrderPeriodLength | Decimal | The ReOrderPeriodLength value of the StockItem. |
| ReOrderRoundLimit | Decimal | The ReOrderRoundLimit value of the StockItem. |
| MinOrderPeriodLength | Decimal | The MinOrderPeriodLength value of the StockItem. |
| MinOrderRoundLimit | Decimal | The MinOrderRoundLimit value of the StockItem. |
| GSTItemUnits | Decimal | The GSTItemUnits value of the StockItem. |
| GSTRepUnits | Decimal | The GSTRepUnits value of the StockItem. |
| OpeningBalance | String | The OpeningBalance value of the StockItem. |
| OpeningValue | Decimal | The OpeningValue value of the StockItem. |
| BasicValue | String | The BasicValue value of the StockItem. |
| BasicQty | String | The BasicQty value of the StockItem. |
| ReorderBase | String | The ReorderBase value of the StockItem. |
| MinimumOrderBase | String | The MinimumOrderBase value of the StockItem. |
| OpeningRate | String | The OpeningRate value of the StockItem. |
| tempGSTCGSTRate | Decimal | The tempGSTCGSTRate value of the StockItem. |
| tempGSTSGSTRate | Decimal | The tempGSTSGSTRate value of the StockItem. |
| tempGSTIGSTRate | Decimal | The tempGSTIGSTRate value of the StockItem. |
| tempGSTStateCessRate | Decimal | The tempGSTStateCessRate value of the StockItem. |
| tempIsVATfieldsEdited | String | The tempIsVATfieldsEdited value of the StockItem. |
| tempApplDate | Date | The tempApplDate value of the StockItem. |
| tempClassification | String | The tempClassification value of the StockItem. |
| tempNature | String | The tempNature value of the StockItem. |
| tempPartyEntity | String | The tempPartyEntity value of the StockItem. |
| tempBusinessNature | String | The tempBusinessNature value of the StockItem. |
| tempVATRate | Decimal | The tempVATRate value of the StockItem. |
| tempAddlTax | Decimal | The tempAddlTax value of the StockItem. |
| tempCessOnVat | Decimal | The tempCessOnVat value of the StockItem. |
| tempTaxType | String | The tempTaxType value of the StockItem. |
| tempMajorCommodityName | String | The tempMajorCommodityName value of the StockItem. |
| tempCommodityName | String | The tempCommodityName value of the StockItem. |
| tempCommodityCode | String | The tempCommodityCode value of the StockItem. |
| tempSubCommodityCode | String | The tempSubCommodityCode value of the StockItem. |
| tempUOM | String | The tempUOM value of the StockItem. |
| tempTypeofGoods | String | The tempTypeofGoods value of the StockItem. |
| tempTradeName | String | The tempTradeName value of the StockItem. |
| tempGoodsNature | String | The tempGoodsNature value of the StockItem. |
| tempSchedule | String | The tempSchedule value of the StockItem. |
| tempScheduleslNo | String | The tempScheduleslNo value of the StockItem. |
| tempIsInvDetailsEnable | String | The tempIsInvDetailsEnable value of the StockItem. |
| tempValuationType | String | The tempValuationType value of the StockItem. |
| tempIsCalcOnQty | String | The tempIsCalcOnQty value of the StockItem. |
| tempMRPRate | String | The tempMRPRate value of the StockItem. |
| tempMRPApplDate | Date | The tempMRPApplDate value of the StockItem. |
| MailingName | String | The MailingName value of the StockItem. |
| TargetRemoteId | String | The TargetRemoteId value of the StockItem. |
| OldAuditEntryIds | Decimal | The OldAuditEntryIds value of the StockItem. |
| Closingbalance | String | The Closingbalance value of the StockItem. |
| Inwardquantity | String | The Inwardquantity value of the StockItem. |
| Outwardquantity | String | The Outwardquantity value of the StockItem. |
| Closingvalue | Decimal | The Closingvalue value of the StockItem. |
| Inwardvalue | String | The Inwardvalue value of the StockItem. |
| Outwardvalue | Decimal | The Outwardvalue value of the StockItem. |
| Closingrate | String | The Closingrate value of the StockItem. |
| Lastsaledate | Date | The Lastsaledate value of the StockItem. |
| Lastsaleparty | String | The Lastsaleparty value of the StockItem. |
| Lastsaleprice | String | The Lastsaleprice value of the StockItem. |
| Lastsaleqty | String | The Lastsaleqty value of the StockItem. |
| Lastpurcdate | Date | The Lastpurcdate value of the StockItem. |
| Lastpurcparty | String | The Lastpurcparty value of the StockItem. |
| Lastpurcprice | String | The Lastpurcprice value of the StockItem. |
| Lastpurccost | String | The Lastpurccost value of the StockItem. |
| Lastpurcqty | String | The Lastpurcqty value of the StockItem. |
| Consumption | Decimal | The Consumption value of the StockItem. |
| Thisyearbalance | Decimal | The Thisyearbalance value of the StockItem. |
| Prevyearbalance | Decimal | The Prevyearbalance value of the StockItem. |
| Thisquarterbalance | Decimal | The Thisquarterbalance value of the StockItem. |
| Prevquarterbalance | Decimal | The Prevquarterbalance value of the StockItem. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Company | String | Name of the Company whose data need to be fetched. Please make sure it is selected and unlocked atleast once in the Tally tool after the tool is launched. It need not be in the selected state at the moment. |