Power BI Connector for Tally

Build 20.0.7654

PriceList

Retrieve PriceList.

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 PriceList WHERE Guid LIKE '%4da0-b84f5%'

SELECT * FROM PriceList WHERE RemoteGUID != NULL

SELECT * FROM PriceList WHERE GSTApplicable = 'Applicable' AND CostingMethod = 'Avg. Cost'

SELECT * FROM PriceList WHERE Parent = 'Ashok Leyland' OR Parent = 'Maruti Limited'

SELECT * FROM PriceList WHERE IsBatchWiseOn > 'No'

SELECT * FROM PriceList ORDER BY Guid Asc

Columns

Name Type Description
Name String The Name value of the PriceList.
ActiveFrom Date The ActiveFrom value of the PriceList.
ActiveTo Date The ActiveTo value of the PriceList.
Guid String The Guid value of the PriceList.
Parent String The Parent value of the PriceList.
Narration String The Narration value of the PriceList.
RemoteGUID String The RemoteGUID value of the PriceList.
RemoteAltGUID String The RemoteAltGUID value of the PriceList.
RequestorRule String The RequestorRule value of the PriceList.
TDSApplicable String The TDSApplicable value of the PriceList.
TCSApplicable String The TCSApplicable value of the PriceList.
GSTApplicable String The GSTApplicable value of the PriceList.
CostingMethod String The CostingMethod value of the PriceList.
ValuationMethod String The ValuationMethod value of the PriceList.
BaseUnits String The BaseUnits value of the PriceList.
AdditionalUnits String The AdditionalUnits value of the PriceList.
ExciseTaxType String The ExciseTaxType value of the PriceList.
IsBatchWiseOn String The IsBatchWiseOn value of the PriceList.
IsPerishableOn String The IsPerishableOn value of the PriceList.
IsAddable String The IsAddable value of the PriceList.
IsMstFromSync String The IsMstFromSync value of the PriceList.
IsUpdatingTargetId String The IsUpdatingTargetId value of the PriceList.
AsOriginal String The AsOriginal value of the PriceList.
IgnorePhysicalDifference String The IgnorePhysicalDifference value of the PriceList.
IgnoreNegativeStock String The IgnoreNegativeStock value of the PriceList.
TreatSalesasManufactured String The TreatSalesasManufactured value of the PriceList.
TreatPurchasesasConsumed String The TreatPurchasesasConsumed value of the PriceList.
TreatRejectsasScrap String The TreatRejectsasScrap value of the PriceList.
HasMfgDate String The HasMfgDate value of the PriceList.
AllowUseofExpiredItems String The AllowUseofExpiredItems value of the PriceList.
IgnoreBatches String The IgnoreBatches value of the PriceList.
IgnoreGodowns String The IgnoreGodowns value of the PriceList.
SortPosition Decimal The SortPosition value of the PriceList.
Alterid Decimal The Alterid value of the PriceList.
RemoteAlterID Decimal The RemoteAlterID value of the PriceList.
Denominator Decimal The Denominator value of the PriceList.
Conversion Decimal The Conversion value of the PriceList.
tempGSTCGSTRate Decimal The tempGSTCGSTRate value of the PriceList.
tempGSTSGSTRate Decimal The tempGSTSGSTRate value of the PriceList.
tempGSTIGSTRate Decimal The tempGSTIGSTRate value of the PriceList.
tempGSTStateCessRate Decimal The tempGSTStateCessRate value of the PriceList.
tempIsVATfieldsEdited String The tempIsVATfieldsEdited value of the PriceList.
tempApplDate Date The tempApplDate value of the PriceList.
tempClassification String The tempClassification value of the PriceList.
tempNature String The tempNature value of the PriceList.
tempPartyEntity String The tempPartyEntity value of the PriceList.
tempBusinessNature String The tempBusinessNature value of the PriceList.
tempVATRate Decimal The tempVATRate value of the PriceList.
tempAddlTax Decimal The tempAddlTax value of the PriceList.
tempCessOnVat Decimal The tempCessOnVat value of the PriceList.
tempTaxType String The tempTaxType value of the PriceList.
tempMajorCommodityName String The tempMajorCommodityName value of the PriceList.
tempCommodityName String The tempCommodityName value of the PriceList.
tempCommodityCode String The tempCommodityCode value of the PriceList.
tempSubCommodityCode String The tempSubCommodityCode value of the PriceList.
tempUOM String The tempUOM value of the PriceList.
tempTypeofGoods String The tempTypeofGoods value of the PriceList.
tempTradeName String The tempTradeName value of the PriceList.
tempGoodsNature String The tempGoodsNature value of the PriceList.
tempSchedule String The tempSchedule value of the PriceList.
tempScheduleslNo String The tempScheduleslNo value of the PriceList.
tempIsInvDetailsEnable String The tempIsInvDetailsEnable value of the PriceList.
tempValuationType String The tempValuationType value of the PriceList.
tempIsCalcOnQty String The tempIsCalcOnQty value of the PriceList.
tempMRPRate String The tempMRPRate value of the PriceList.
tempMRPApplDate Date The tempMRPApplDate value of the PriceList.
TargetRemoteId String The TargetRemoteId value of the PriceList.
Closingbalance String The Closingbalance value of the PriceList.
Inwardquantity String The Inwardquantity value of the PriceList.
Outwardquantity String The Outwardquantity value of the PriceList.
Closingvalue String The Closingvalue value of the PriceList.
Inwardvalue String The Inwardvalue value of the PriceList.
Outwardvalue String The Outwardvalue value of the PriceList.
Closingrate String The Closingrate value of the PriceList.
Lastsaledate String The Lastsaledate value of the PriceList.
Lastsaleparty String The Lastsaleparty value of the PriceList.
Lastsaleprice String The Lastsaleprice value of the PriceList.
Lastsaleqty String The Lastsaleqty value of the PriceList.
Lastpurcdate String The Lastpurcdate value of the PriceList.
Lastpurcparty String The Lastpurcparty value of the PriceList.
Lastpurcprice String The Lastpurcprice value of the PriceList.
Lastpurccost String The Lastpurccost value of the PriceList.
Lastpurcqty String The Lastpurcqty value of the PriceList.
Consumption String The Consumption value of the PriceList.
Thisyearbalance String The Thisyearbalance value of the PriceList.
Prevyearbalance String The Prevyearbalance value of the PriceList.
Thisquarterbalance String The Thisquarterbalance value of the PriceList.
Prevquarterbalance String The Prevquarterbalance value of the PriceList.
Baseunits String The Baseunits value of the PriceList.
Additionalunits String The Additionalunits value of the PriceList.
Conversion Decimal The Conversion value of the PriceList.
Openingbalance String The Openingbalance value of the PriceList.
Credittotals String The Credittotals value of the PriceList.
Debittotals String The Debittotals value of the PriceList.
Openingvalue String The Openingvalue value of the PriceList.
Denominator Decimal The Denominator value of the PriceList.

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