PriceList
Retrieve PriceList.
Table Specific Information
Select
The add-in 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 add-in.
- 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. |
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 |
| 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. |