SSIS Components for Tally

Build 20.0.7656

StockItem

Retrieve StockItems.

Table Specific Information

Select

The {i 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 {i.

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

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7656