Excel Add-In for Tally

Build 24.0.9062

Payhead

Retrieve Payhead Details.

Table Specific Information

Select

The 本製品 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 本製品.

  • String supports the '=, !=,<, <=, >, >=, LIKE, ORDER BY' comparisons.

For example these queries are processed server side:

SELECT * FROM PayHead WHERE Parent LIKE '%Maruti%'

SELECT * FROM PayHead WHERE RemoteAltGUID != NULL

SELECT * FROM PayHead WHERE TCSApplicable = 'True' AND OpeningValue > '0.00'

SELECT * FROM PayHead WHERE BaseUnits = 'Nos' OR BaseUnits = 'POS'

SELECT * FROM PayHead ORDER BY BaseUnits Desc

Columns

Name Type Description
StartingFrom String The StartingFrom value of the Payhead.
STRegDate String The STRegDate value of the Payhead.
LBTRegnDate String The LBTRegnDate value of the Payhead.
SamplingDateOneFactor String The SamplingDateOneFactor value of the Payhead.
SamplingDateTwoFactor String The SamplingDateTwoFactor value of the Payhead.
ActiveFrom String The ActiveFrom value of the Payhead.
ActiveTo String The ActiveTo value of the Payhead.
CreatedDate String The CreatedDate value of the Payhead.
AlteredOn String The AlteredOn value of the Payhead.
VATApplicableDate String The VATApplicableDate value of the Payhead.
ExciseRegistrationDate String The ExciseRegistrationDate value of the Payhead.
PANApplicableFrom String The PANApplicableFrom value of the Payhead.
PayInsRunningFileDate String The PayInsRunningFileDate value of the Payhead.
VATTaxExemptionDate String The VATTaxExemptionDate value of the Payhead.
Name String The Name value of the Payhead.
Address String The Address value of the Payhead.
GUID String The GUID value of the Payhead.
CurrencyName String The CurrencyName value of the Payhead.
EMail String The EMail value of the Payhead.
StateName String The StateName value of the Payhead.
PINCode String The PINCode value of the Payhead.
Website String The Website value of the Payhead.
IncomeTaxNumber String The IncomeTaxNumber value of the Payhead.
SalesTaxNumber String The SalesTaxNumber value of the Payhead.
InterStateSTNumber String The InterStateSTNumber value of the Payhead.
VATTINNumber String The VATTINNumber value of the Payhead.
CountryName String The CountryName value of the Payhead.
ExciseRange String The ExciseRange value of the Payhead.
ExciseDivision String The ExciseDivision value of the Payhead.
ExciseCommissionerate String The ExciseCommissionerate value of the Payhead.
LBTRegnNo String The LBTRegnNo value of the Payhead.
LBTZone String The LBTZone value of the Payhead.
ExportImportCode String The ExportImportCode value of the Payhead.
GSTRegistrationType String The GSTRegistrationType value of the Payhead.
VATDealerType String The VATDealerType value of the Payhead.
PriceLevel String The PriceLevel value of the Payhead.
UploadLastRefresh String The UploadLastRefresh value of the Payhead.
Parent String The Parent value of the Payhead.
MailingName String The MailingName value of the Payhead.
SamplingMethod String The SamplingMethod value of the Payhead.
SamplingStrOneFactor String The SamplingStrOneFactor value of the Payhead.
IFSCode String The IFSCode value of the Payhead.
Narration String The Narration value of the Payhead.
RemoteGUID String The RemoteGUID value of the Payhead.
RemoteAltGUID String The RemoteAltGUID value of the Payhead.
TargetRemoteId String The TargetRemoteId value of the Payhead.
RequestorRule String The RequestorRule value of the Payhead.
GrpDebitParent String The GrpDebitParent value of the Payhead.
GrpCreditParent String The GrpCreditParent value of the Payhead.
SysDebitParent String The SysDebitParent value of the Payhead.
SysCreditParent String The SysCreditParent value of the Payhead.
TDSApplicable String The TDSApplicable value of the Payhead.
TCSApplicable String The TCSApplicable value of the Payhead.
GSTApplicable String The GSTApplicable value of the Payhead.
CreatedBy String The CreatedBy value of the Payhead.
AlteredBy String The AlteredBy value of the Payhead.
TaxClassificationName String The TaxClassificationName value of the Payhead.
TaxType String The TaxType value of the Payhead.
BillCreditPeriod String The BillCreditPeriod value of the Payhead.
BankDetails String The BankDetails value of the Payhead.
BankBranchName String The BankBranchName value of the Payhead.
BankBSRCode String The BankBSRCode value of the Payhead.
DeducteeType String The DeducteeType value of the Payhead.
BusinessType String The BusinessType value of the Payhead.
TypeOfNotification String The TypeOfNotification value of the Payhead.
MSMERegNumber String The MSMERegNumber value of the Payhead.
CountryofResidence String The CountryofResidence value of the Payhead.
RelatedPartyId String The RelatedPartyId value of the Payhead.
RelPartyIssuingAuthority String The RelPartyIssuingAuthority value of the Payhead.
ImporterExporterCode String The ImporterExporterCode value of the Payhead.
EmailCC String The EmailCC value of the Payhead.
Description String The Description value of the Payhead.
LedAddlAllocType String The LedAddlAllocType value of the Payhead.
TransporterId String The TransporterId value of the Payhead.
LedgerPhone String The LedgerPhone value of the Payhead.
LedgerFax String The LedgerFax value of the Payhead.
LedgerContact String The LedgerContact value of the Payhead.
LedgerMobile String The LedgerMobile value of the Payhead.
RelationType String The RelationType value of the Payhead.
MailingNameNative String The MailingNameNative value of the Payhead.
AddressNative String The AddressNative value of the Payhead.
StateNameNative String The StateNameNative value of the Payhead.
CountryNameNative String The CountryNameNative value of the Payhead.
BasicTypeOfDuty String The BasicTypeOfDuty value of the Payhead.
GSTType String The GSTType value of the Payhead.
ExemptionType String The ExemptionType value of the Payhead.
AppropriateFor String The AppropriateFor value of the Payhead.
SubTaxType String The SubTaxType value of the Payhead.
STXNatureOfParty String The STXNatureOfParty value of the Payhead.
NameOnPAN String The NameOnPAN value of the Payhead.
UsedForTaxType String The UsedForTaxType value of the Payhead.
eCommMerchantID String The eCommMerchantID value of the Payhead.
PartyGSTIN String The PartyGSTIN value of the Payhead.
GSTDutyHead String The GSTDutyHead value of the Payhead.
GSTAppropriateTo String The GSTAppropriateTo value of the Payhead.
GSTTypeofSupply String The GSTTypeofSupply value of the Payhead.
GSTNatureofSupply String The GSTNatureofSupply value of the Payhead.
CessValuationMethod String The CessValuationMethod value of the Payhead.
PayType String The PayType value of the Payhead.
PayslipName String The PayslipName value of the Payhead.
AttendanceType String The AttendanceType value of the Payhead.
LeaveType String The LeaveType value of the Payhead.
CalculationPeriod String The CalculationPeriod value of the Payhead.
RoundingMethod String The RoundingMethod value of the Payhead.
ComputationType String The ComputationType value of the Payhead.
CalculationType String The CalculationType value of the Payhead.
PayStatType String The PayStatType value of the Payhead.
ProfessionalTaxNumber String The ProfessionalTaxNumber value of the Payhead.
UserDefinedCalenderType String The UserDefinedCalenderType value of the Payhead.
ITNature String The ITNature value of the Payhead.
ITComponent String The ITComponent value of the Payhead.
NotificationNumber String The NotificationNumber value of the Payhead.
RegistrationNumber String The RegistrationNumber value of the Payhead.
ServiceCategory String The ServiceCategory value of the Payhead.
AbatementNotificationNo String The AbatementNotificationNo value of the Payhead.
STXDutyHead String The STXDutyHead value of the Payhead.
STXClassification String The STXClassification value of the Payhead.
NotificationSlNo String The NotificationSlNo value of the Payhead.
ServiceTaxApplicable String The ServiceTaxApplicable value of the Payhead.
ExciseLedgerClassification String The ExciseLedgerClassification value of the Payhead.
ExciseRegistrationNumber String The ExciseRegistrationNumber value of the Payhead.
ExciseAccountHead String The ExciseAccountHead value of the Payhead.
ExciseDutyType String The ExciseDutyType value of the Payhead.
ExciseDutyHeadCode String The ExciseDutyHeadCode value of the Payhead.
ExciseAllocType String The ExciseAllocType value of the Payhead.
ExciseDutyHead String The ExciseDutyHead value of the Payhead.
NatureOfSales String The NatureOfSales value of the Payhead.
ExciseNotificationNo String The ExciseNotificationNo value of the Payhead.
ExciseImportsRegistartionNo String The ExciseImportsRegistartionNo value of the Payhead.
ExciseApplicability String The ExciseApplicability value of the Payhead.
ExciseTypeofBranch String The ExciseTypeofBranch value of the Payhead.
ExciseDefaultRemoval String The ExciseDefaultRemoval value of the Payhead.
ExciseNotificationSlNo String The ExciseNotificationSlNo value of the Payhead.
TypeOfTariff String The TypeOfTariff value of the Payhead.
ExciseRegNo String The ExciseRegNo value of the Payhead.
ExciseNatureofPurchase String The ExciseNatureofPurchase value of the Payhead.
TDSDeducteeTypeMst String The TDSDeducteeTypeMst value of the Payhead.
TDSRateName String The TDSRateName value of the Payhead.
TDSDeducteeSectionNumber String The TDSDeducteeSectionNumber value of the Payhead.
PANStatus String The PANStatus value of the Payhead.
DeducteeReference String The DeducteeReference value of the Payhead.
TDSDeducteeType String The TDSDeducteeType value of the Payhead.
ITExemptApplicable String The ITExemptApplicable value of the Payhead.
TaxIdentificationNo String The TaxIdentificationNo value of the Payhead.
LedgerFBTCategory String The LedgerFBTCategory value of the Payhead.
BranchCode String The BranchCode value of the Payhead.
ClientCode String The ClientCode value of the Payhead.
BankingConfigBank String The BankingConfigBank value of the Payhead.
BankingConfigBankID String The BankingConfigBankID value of the Payhead.
BankAccHolderName String The BankAccHolderName value of the Payhead.
UseForPOSType String The UseForPOSType value of the Payhead.
PaymentGateway String The PaymentGateway value of the Payhead.
TypeOfInterestOn String The TypeOfInterestOn value of the Payhead.
BankConfigIFSC String The BankConfigIFSC value of the Payhead.
BankConfigMICR String The BankConfigMICR value of the Payhead.
BankConfigShortCode String The BankConfigShortCode value of the Payhead.
PymtInstoutputName String The PymtInstoutputName value of the Payhead.
ProductCodeType String The ProductCodeType value of the Payhead.
SalaryPymtProductCode String The SalaryPymtProductCode value of the Payhead.
OtherPymtProductCode String The OtherPymtProductCode value of the Payhead.
PaymentInstLocation String The PaymentInstLocation value of the Payhead.
EncrptionLocation String The EncrptionLocation value of the Payhead.
NewIMFLocation String The NewIMFLocation value of the Payhead.
ImportedIMFLocation String The ImportedIMFLocation value of the Payhead.
BankNewStatements String The BankNewStatements value of the Payhead.
BankImportedStatements String The BankImportedStatements value of the Payhead.
BankMICR String The BankMICR value of the Payhead.
CorporateUserNoECS String The CorporateUserNoECS value of the Payhead.
CorporateUserNoACH String The CorporateUserNoACH value of the Payhead.
CorporateUserName String The CorporateUserName value of the Payhead.
BankUserLoginID String The BankUserLoginID value of the Payhead.
IMFName String The IMFName value of the Payhead.
PayInsBatchName String The PayInsBatchName value of the Payhead.
LastUsedBatchName String The LastUsedBatchName value of the Payhead.
PayInsFileNumPeriod String The PayInsFileNumPeriod value of the Payhead.
EncryptedBy String The EncryptedBy value of the Payhead.
EncryptedId String The EncryptedId value of the Payhead.
ISOCurrencyCode String The ISOCurrencyCode value of the Payhead.
BankCapsuleID String The BankCapsuleID value of the Payhead.
SalesTaxCessApplicable String The SalesTaxCessApplicable value of the Payhead.
BankIBAN String The BankIBAN value of the Payhead.
VATTaxExemptionNature String The VATTaxExemptionNature value of the Payhead.
VATTaxExemptionNumber String The VATTaxExemptionNumber value of the Payhead.
LedStateName String The LedStateName value of the Payhead.
VATApplicable String The VATApplicable value of the Payhead.
PartyBusinessType String The PartyBusinessType value of the Payhead.
PartyBusinessStyle String The PartyBusinessStyle value of the Payhead.
IsBillWiseOn String The IsBillWiseOn value of the Payhead.
IsCostCentresOn String The IsCostCentresOn value of the Payhead.
IsInterestOn String The IsInterestOn value of the Payhead.
AllowinMobile String The AllowinMobile value of the Payhead.
IsCostTrackingOn String The IsCostTrackingOn value of the Payhead.
IsBeneficiaryCodeOn String The IsBeneficiaryCodeOn value of the Payhead.
IsMstFromSync String The IsMstFromSync value of the Payhead.
IsUpdatingTargetId String The IsUpdatingTargetId value of the Payhead.
AsOriginal String The AsOriginal value of the Payhead.
IsCondensed String The IsCondensed value of the Payhead.
AffectsStock String The AffectsStock value of the Payhead.
IsRateInclusiveVAT String The IsRateInclusiveVAT value of the Payhead.
ForPayroll String The ForPayroll value of the Payhead.
IsABCEnabled String The IsABCEnabled value of the Payhead.
IsCreditDaysChkOn String The IsCreditDaysChkOn value of the Payhead.
InterestonBillwise String The InterestonBillwise value of the Payhead.
OverrideInterest String The OverrideInterest value of the Payhead.
OverrideAdvInterest String The OverrideAdvInterest value of the Payhead.
UseForVAT String The UseForVAT value of the Payhead.
IgnoreTDSExempt String The IgnoreTDSExempt value of the Payhead.
IsTCSApplicable String The IsTCSApplicable value of the Payhead.
IsTDSApplicable String The IsTDSApplicable value of the Payhead.
IsFBTApplicable String The IsFBTApplicable value of the Payhead.
IsGSTApplicable String The IsGSTApplicable value of the Payhead.
IsExciseApplicable String The IsExciseApplicable value of the Payhead.
IsTDSExpense String The IsTDSExpense value of the Payhead.
IsEDLIApplicable String The IsEDLIApplicable value of the Payhead.
IsRelatedParty String The IsRelatedParty value of the Payhead.
UseForESIEligibility String The UseForESIEligibility value of the Payhead.
IsInterestInclLastDay String The IsInterestInclLastDay value of the Payhead.
AppropriateTaxValue String The AppropriateTaxValue value of the Payhead.
IsBehaveAsDuty String The IsBehaveAsDuty value of the Payhead.
InterestInclDayOfAddition String The InterestInclDayOfAddition value of the Payhead.
InterestInclDayOfDeduction String The InterestInclDayOfDeduction value of the Payhead.
IsOthTerritoryAssessee String The IsOthTerritoryAssessee value of the Payhead.
OverRideCreditLimit String The OverRideCreditLimit value of the Payhead.
IsAgainstFormC String The IsAgainstFormC value of the Payhead.
IsChequePrintingEnabled String The IsChequePrintingEnabled value of the Payhead.
IsPayUpLoad String The IsPayUpLoad value of the Payhead.
IsPayBatchOnlySAL String The IsPayBatchOnlySAL value of the Payhead.
IsBNFCodeSupported String The IsBNFCodeSupported value of the Payhead.
AllowExportWithErrors String The AllowExportWithErrors value of the Payhead.
ConsiderPurchaseforExport String The ConsiderPurchaseforExport value of the Payhead.
IsTransporter String The IsTransporter value of the Payhead.
UseForNotionalITC String The UseForNotionalITC value of the Payhead.
IseCommOperator String The IseCommOperator value of the Payhead.
ShowinPayslip String The ShowinPayslip value of the Payhead.
UseForGratuity String The UseForGratuity value of the Payhead.
IsTDSProjected String The IsTDSProjected value of the Payhead.
ForServiceTax String The ForServiceTax value of the Payhead.
IsInputCredit String The IsInputCredit value of the Payhead.
IsExempted String The IsExempted value of the Payhead.
IsAbatementApplicable String The IsAbatementApplicable value of the Payhead.
IsSTXParty String The IsSTXParty value of the Payhead.
IsSTXNonRealizedType String The IsSTXNonRealizedType value of the Payhead.
IsUsedForCVD String The IsUsedForCVD value of the Payhead.
LedBelongsToNonTaxable String The LedBelongsToNonTaxable value of the Payhead.
IsExciseMerchantExporter String The IsExciseMerchantExporter value of the Payhead.
IsPartyExempted String The IsPartyExempted value of the Payhead.
IsSEZParty String The IsSEZParty value of the Payhead.
TDSDeducteeIsSpecialRate String The TDSDeducteeIsSpecialRate value of the Payhead.
IseChequeSupported String The IseChequeSupported value of the Payhead.
IseDDSupported String The IseDDSupported value of the Payhead.
HaseChequeDeliveryMode String The HaseChequeDeliveryMode value of the Payhead.
HaseChequeDeliveryTo String The HaseChequeDeliveryTo value of the Payhead.
HaseChequePrintLocation String The HaseChequePrintLocation value of the Payhead.
HaseChequePayableLocation String The HaseChequePayableLocation value of the Payhead.
HaseChequeBankLocation String The HaseChequeBankLocation value of the Payhead.
HaseDDDeliveryMode String The HaseDDDeliveryMode value of the Payhead.
HaseDDDeliveryTo String The HaseDDDeliveryTo value of the Payhead.
HaseDDPrintLocation String The HaseDDPrintLocation value of the Payhead.
HaseDDPayableLocation String The HaseDDPayableLocation value of the Payhead.
HaseDDBankLocation String The HaseDDBankLocation value of the Payhead.
IsEBankingEnabled String The IsEBankingEnabled value of the Payhead.
IsExportFileEncrypted String The IsExportFileEncrypted value of the Payhead.
IsBatchEnabled String The IsBatchEnabled value of the Payhead.
IsProductCodeBased String The IsProductCodeBased value of the Payhead.
HaseDDCity String The HaseDDCity value of the Payhead.
HaseChequeCity String The HaseChequeCity value of the Payhead.
IsFileNameFormatSupported String The IsFileNameFormatSupported value of the Payhead.
HasClientCode String The HasClientCode value of the Payhead.
PayInsIsBatchApplicable String The PayInsIsBatchApplicable value of the Payhead.
PayInsIsFileNumApp String The PayInsIsFileNumApp value of the Payhead.
IsSalaryTransGroupedForBRS String The IsSalaryTransGroupedForBRS value of the Payhead.
IseBankingSupported String The IseBankingSupported value of the Payhead.
IsSCBUAE String The IsSCBUAE value of the Payhead.
IsBankStatusApp String The IsBankStatusApp value of the Payhead.
IsSalaryGrouped String The IsSalaryGrouped value of the Payhead.
UseForPurchaseTax String The UseForPurchaseTax value of the Payhead.
Audited String The Audited value of the Payhead.
SamplingNumOneFactor String The SamplingNumOneFactor value of the Payhead.
SamplingNumTwoFactor String The SamplingNumTwoFactor value of the Payhead.
SortPosition String The SortPosition value of the Payhead.
AlterID String The AlterID value of the Payhead.
RemoteAlterID String The RemoteAlterID value of the Payhead.
DefaultLanguage String The DefaultLanguage value of the Payhead.
OldAuditEntryIds String The OldAuditEntryIds value of the Payhead.
RateOfTaxCalculation String The RateOfTaxCalculation value of the Payhead.
GratuityMonthDays String The GratuityMonthDays value of the Payhead.
GratuityLimitMonths String The GratuityLimitMonths value of the Payhead.
CalculationBasis String The CalculationBasis value of the Payhead.
RoundingLimit String The RoundingLimit value of the Payhead.
AbatementPercentage String The AbatementPercentage value of the Payhead.
TDSDeducteeSpecialRate String The TDSDeducteeSpecialRate value of the Payhead.
BeneficiaryCodeMaxLength String The BeneficiaryCodeMaxLength value of the Payhead.
eChequePrintLocationVersion String The eChequePrintLocationVersion value of the Payhead.
eChequePayableLocationVersion String The eChequePayableLocationVersion value of the Payhead.
eDDPrintLocationVersion String The eDDPrintLocationVersion value of the Payhead.
eDDPayableLocationVersion String The eDDPayableLocationVersion value of the Payhead.
PayInsRunningFileNum String The PayInsRunningFileNum value of the Payhead.
TransactionTypeVersion String The TransactionTypeVersion value of the Payhead.
PayInsFileNumLength String The PayInsFileNumLength value of the Payhead.
SamplingAmtOneFactor String The SamplingAmtOneFactor value of the Payhead.
SamplingAmtTwoFactor String The SamplingAmtTwoFactor value of the Payhead.
OpeningBalance String The OpeningBalance value of the Payhead.
CreditLimit String The CreditLimit value of the Payhead.
GratuityLimitAmount String The GratuityLimitAmount value of the Payhead.
ODLimit String The ODLimit value of the Payhead.
Closingbalance String The Closingbalance value of the Payhead.
Address1 String The Address1 value of the Payhead.
Address2 String The Address2 value of the Payhead.
Address3 String The Address3 value of the Payhead.
Address4 String The Address4 value of the Payhead.
Address5 String The Address5 value of the Payhead.
Primarygroup String The Primarygroup value of the Payhead.
Overduebills String The Overduebills value of the Payhead.
Onaccountvalue String The Onaccountvalue value of the Payhead.
Cashinflow String The Cashinflow value of the Payhead.
Cashoutflow String The Cashoutflow value of the Payhead.
Performance String The Performance value of the Payhead.
Drinterest String The Drinterest value of the Payhead.
Crinterest String The Crinterest value of the Payhead.
Lastinterestdate String The Lastinterestdate value of the Payhead.
Thisyearbalance String The Thisyearbalance value of the Payhead.
Prevyearbalance String The Prevyearbalance value of the Payhead.
Thisquarterbalance String The Thisquarterbalance value of the Payhead.
Prevquarterbalance String The Prevquarterbalance value of the Payhead.

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062