Ledger
Retrieve Ledger Details.
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 Ledger WHERE TaxType LIKE '%GST%' SELECT * FROM Ledger WHERE GSTType != 'Applicable' SELECT * FROM Ledger WHERE GSTTypeofSupply = 'Goods' AND GSTDutyHead = 'Central Tax' SELECT * FROM Ledger WHERE Parent = 'Sales Accounts' OR Parent = 'Bank Accounts' SELECT * FROM Ledger WHERE IsChequePrintingEnabled > 'No' SELECT * FROM Ledger ORDER BY Guid Desc
Columns
| Name | Type | Description |
| Name | String | The Name value of the Ledger. |
| StartingFrom | Date | The StartingFrom value of the Ledger. |
| STRegDate | Date | The STRegDate value of the Ledger. |
| LBTRegnDate | Date | The LBTRegnDate value of the Ledger. |
| SamplingDateOneFactor | Date | The SamplingDateOneFactor value of the Ledger. |
| SamplingDateTwoFactor | Date | The SamplingDateTwoFactor value of the Ledger. |
| ActiveFrom | Date | The ActiveFrom value of the Ledger. |
| ActiveTo | Date | The ActiveTo value of the Ledger. |
| CreatedDate | Date | The CreatedDate value of the Ledger. |
| AlteredOn | Date | The AlteredOn value of the Ledger. |
| VATApplicableDate | Date | The VATApplicableDate value of the Ledger. |
| ExciseRegistrationDate | Date | The ExciseRegistrationDate value of the Ledger. |
| PANApplicableFrom | Date | The PANApplicableFrom value of the Ledger. |
| PayInsRunningFileDate | Date | The PayInsRunningFileDate value of the Ledger. |
| VATTaxExemptionDate | Date | The VATTaxExemptionDate value of the Ledger. |
| Guid | String | The Guid value of the Ledger. |
| CurrencyName | String | The CurrencyName value of the Ledger. |
| String | The Email value of the Ledger. | |
| StateName | String | The StateName value of the Ledger. |
| PINCode | String | The PINCode value of the Ledger. |
| Website | String | The Website value of the Ledger. |
| IncomeTaxNumber | String | The IncomeTaxNumber value of the Ledger. |
| SalesTaxNumber | String | The SalesTaxNumber value of the Ledger. |
| InterStateSTNumber | String | The InterStateSTNumber value of the Ledger. |
| VATTINNumber | String | The VATTINNumber value of the Ledger. |
| CountryName | String | The CountryName value of the Ledger. |
| ExciseRange | String | The ExciseRange value of the Ledger. |
| ExciseDivision | String | The ExciseDivision value of the Ledger. |
| ExciseCommissionerate | String | The ExciseCommissionerate value of the Ledger. |
| LBTRegnNo | String | The LBTRegnNo value of the Ledger. |
| LBTZone | String | The LBTZone value of the Ledger. |
| ExportImportCode | String | The ExportImportCode value of the Ledger. |
| GSTRegistrationType | String | The GSTRegistrationType value of the Ledger. |
| VATDealerType | String | The VATDealerType value of the Ledger. |
| PriceLevel | String | The PriceLevel value of the Ledger. |
| UploadLastRefresh | String | The UploadLastRefresh value of the Ledger. |
| Parent | String | The Parent value of the Ledger. |
| SamplingMethod | String | The SamplingMethod value of the Ledger. |
| SamplingStrOneFactor | String | The SamplingStrOneFactor value of the Ledger. |
| IFSCode | String | The IFSCode value of the Ledger. |
| Narration | String | The Narration value of the Ledger. |
| RemoteGUID | String | The RemoteGUID value of the Ledger. |
| RemoteAltGUID | String | The RemoteAltGUID value of the Ledger. |
| RequestorRule | String | The RequestorRule value of the Ledger. |
| GrpDebitParent | String | The GrpDebitParent value of the Ledger. |
| GrpCreditParent | String | The GrpCreditParent value of the Ledger. |
| SysDebitParent | String | The SysDebitParent value of the Ledger. |
| SysCreditParent | String | The SysCreditParent value of the Ledger. |
| TDSApplicable | String | The TDSApplicable value of the Ledger. |
| TCSApplicable | String | The TCSApplicable value of the Ledger. |
| GSTApplicable | String | The GSTApplicable value of the Ledger. |
| CreatedBy | String | The CreatedBy value of the Ledger. |
| AlteredBy | String | The AlteredBy value of the Ledger. |
| TaxClassificationName | String | The TaxClassificationName value of the Ledger. |
| TaxType | String | The TaxType value of the Ledger. |
| BillCreditPeriod | String | The BillCreditPeriod value of the Ledger. |
| BankDetails | String | The BankDetails value of the Ledger. |
| BankBranchName | String | The BankBranchName value of the Ledger. |
| BankBSRCode | String | The BankBSRCode value of the Ledger. |
| DeducteeType | String | The DeducteeType value of the Ledger. |
| BusinessType | String | The BusinessType value of the Ledger. |
| TypeOfNotification | String | The TypeOfNotification value of the Ledger. |
| MSMERegNumber | String | The MSMERegNumber value of the Ledger. |
| CountryofResidence | String | The CountryofResidence value of the Ledger. |
| RelatedPartyId | String | The RelatedPartyId value of the Ledger. |
| RelPartyIssuingAuthority | String | The RelPartyIssuingAuthority value of the Ledger. |
| ImporterExporterCode | String | The ImporterExporterCode value of the Ledger. |
| EMailCC | String | The EMailCC value of the Ledger. |
| Description | String | The Description value of the Ledger. |
| LedAddlAllocType | String | The LedAddlAllocType value of the Ledger. |
| TransporterId | String | The TransporterId value of the Ledger. |
| LedgerPhone | String | The LedgerPhone value of the Ledger. |
| LedgerFax | String | The LedgerFax value of the Ledger. |
| LedgerContact | String | The LedgerContact value of the Ledger. |
| LedgerMobile | String | The LedgerMobile value of the Ledger. |
| RelationType | String | The RelationType value of the Ledger. |
| MailingNameNative | String | The MailingNameNative value of the Ledger. |
| StateNameNative | String | The StateNameNative value of the Ledger. |
| CountryNameNative | String | The CountryNameNative value of the Ledger. |
| BasicTypeOfDuty | String | The BasicTypeOfDuty value of the Ledger. |
| GSTType | String | The GSTType value of the Ledger. |
| ExemptionType | String | The ExemptionType value of the Ledger. |
| AppropriateFor | String | The AppropriateFor value of the Ledger. |
| SubTaxType | String | The SubTaxType value of the Ledger. |
| STXNatureOfParty | String | The STXNatureOfParty value of the Ledger. |
| NameOnPAN | String | The NameOnPAN value of the Ledger. |
| UsedForTaxType | String | The UsedForTaxType value of the Ledger. |
| eCommMerchantID | String | The eCommMerchantID value of the Ledger. |
| PartyGSTIN | String | The PartyGSTIN value of the Ledger. |
| GSTDutyHead | String | The GSTDutyHead value of the Ledger. |
| GSTAppropriateTo | String | The GSTAppropriateTo value of the Ledger. |
| GSTTypeofSupply | String | The GSTTypeofSupply value of the Ledger. |
| GSTNatureofSupply | String | The GSTNatureofSupply value of the Ledger. |
| CessValuationMethod | String | The CessValuationMethod value of the Ledger. |
| PayType | String | The PayType value of the Ledger. |
| PayslipName | String | The PayslipName value of the Ledger. |
| AttendanceType | String | The AttendanceType value of the Ledger. |
| LeaveType | String | The LeaveType value of the Ledger. |
| CalculationPeriod | String | The CalculationPeriod value of the Ledger. |
| RoundingMethod | String | The RoundingMethod value of the Ledger. |
| ComputationType | String | The ComputationType value of the Ledger. |
| CalculationType | String | The CalculationType value of the Ledger. |
| PayStatType | String | The PayStatType value of the Ledger. |
| ProfessionalTaxNumber | String | The ProfessionalTaxNumber value of the Ledger. |
| UserDefinedCalenderType | String | The UserDefinedCalenderType value of the Ledger. |
| ITNature | String | The ITNature value of the Ledger. |
| ITComponent | String | The ITComponent value of the Ledger. |
| NotificationNumber | String | The NotificationNumber value of the Ledger. |
| RegistrationNumber | String | The RegistrationNumber value of the Ledger. |
| ServiceCategory | String | The ServiceCategory value of the Ledger. |
| AbatementNotificationNo | String | The AbatementNotificationNo value of the Ledger. |
| STXDutyHead | String | The STXDutyHead value of the Ledger. |
| STXClassification | String | The STXClassification value of the Ledger. |
| NotificationSlNo | String | The NotificationSlNo value of the Ledger. |
| ServiceTaxApplicable | String | The ServiceTaxApplicable value of the Ledger. |
| ExciseLedgerClassification | String | The ExciseLedgerClassification value of the Ledger. |
| ExciseRegistrationNumber | String | The ExciseRegistrationNumber value of the Ledger. |
| ExciseAccountHead | String | The ExciseAccountHead value of the Ledger. |
| ExciseDutyType | String | The ExciseDutyType value of the Ledger. |
| ExciseDutyHeadCode | String | The ExciseDutyHeadCode value of the Ledger. |
| ExciseAllocType | String | The ExciseAllocType value of the Ledger. |
| ExciseDutyHead | String | The ExciseDutyHead value of the Ledger. |
| NatureOfSales | String | The NatureOfSales value of the Ledger. |
| ExciseNotificationNo | String | The ExciseNotificationNo value of the Ledger. |
| ExciseImportsRegistartionNo | String | The ExciseImportsRegistartionNo value of the Ledger. |
| ExciseApplicability | String | The ExciseApplicability value of the Ledger. |
| ExciseTypeofBranch | String | The ExciseTypeofBranch value of the Ledger. |
| ExciseDefaultRemoval | String | The ExciseDefaultRemoval value of the Ledger. |
| ExciseNotificationSlNo | String | The ExciseNotificationSlNo value of the Ledger. |
| TypeOfTariff | String | The TypeOfTariff value of the Ledger. |
| ExciseRegNo | String | The ExciseRegNo value of the Ledger. |
| ExciseNatureofPurchase | String | The ExciseNatureofPurchase value of the Ledger. |
| TDSDeducteeTypeMst | String | The TDSDeducteeTypeMst value of the Ledger. |
| TdsRateName | String | The TdsRateName value of the Ledger. |
| TDSDeducteeSectionNumber | String | The TDSDeducteeSectionNumber value of the Ledger. |
| PANStatus | String | The PANStatus value of the Ledger. |
| DeducteeReference | String | The DeducteeReference value of the Ledger. |
| TDSDeducteeType | String | The TDSDeducteeType value of the Ledger. |
| ITExemptApplicable | String | The ITExemptApplicable value of the Ledger. |
| TaxIdentificationNo | String | The TaxIdentificationNo value of the Ledger. |
| LedgerFBTCategory | String | The LedgerFBTCategory value of the Ledger. |
| BranchCode | String | The BranchCode value of the Ledger. |
| ClientCode | String | The ClientCode value of the Ledger. |
| BankingConfigBank | String | The BankingConfigBank value of the Ledger. |
| BankingConfigBankID | String | The BankingConfigBankID value of the Ledger. |
| BankAccHolderName | String | The BankAccHolderName value of the Ledger. |
| UseForPOSType | String | The UseForPOSType value of the Ledger. |
| PaymentGateway | String | The PaymentGateway value of the Ledger. |
| TypeOfInterestOn | String | The TypeOfInterestOn value of the Ledger. |
| BankConfigIFSC | String | The BankConfigIFSC value of the Ledger. |
| BankConfigMICR | String | The BankConfigMICR value of the Ledger. |
| BankConfigShortCode | String | The BankConfigShortCode value of the Ledger. |
| PymtInstoutputName | String | The PymtInstoutputName value of the Ledger. |
| ProductCodeType | String | The ProductCodeType value of the Ledger. |
| SalaryPymtProductCode | String | The SalaryPymtProductCode value of the Ledger. |
| OtherPymtProductCode | String | The OtherPymtProductCode value of the Ledger. |
| PaymentInstLocation | String | The PaymentInstLocation value of the Ledger. |
| EncrptionLocation | String | The EncrptionLocation value of the Ledger. |
| NewIMFLocation | String | The NewIMFLocation value of the Ledger. |
| ImportedIMFLocation | String | The ImportedIMFLocation value of the Ledger. |
| BankNewStatements | String | The BankNewStatements value of the Ledger. |
| BankImportedStatements | String | The BankImportedStatements value of the Ledger. |
| BankMICR | String | The BankMICR value of the Ledger. |
| CorporateUserNoECS | String | The CorporateUserNoECS value of the Ledger. |
| CorporateUserNoACH | String | The CorporateUserNoACH value of the Ledger. |
| CorporateUserName | String | The CorporateUserName value of the Ledger. |
| IMFName | String | The IMFName value of the Ledger. |
| PayInsBatchName | String | The PayInsBatchName value of the Ledger. |
| LastUsedBatchName | String | The LastUsedBatchName value of the Ledger. |
| PayInsFileNumPeriod | String | The PayInsFileNumPeriod value of the Ledger. |
| EncryptedBy | String | The EncryptedBy value of the Ledger. |
| EncryptedId | String | The EncryptedId value of the Ledger. |
| ISOCurrencyCode | String | The ISOCurrencyCode value of the Ledger. |
| BankCapsuleID | String | The BankCapsuleID value of the Ledger. |
| SalesTaxCessApplicable | String | The SalesTaxCessApplicable value of the Ledger. |
| BankIBAN | String | The BankIBAN value of the Ledger. |
| VATTaxExemptionNature | String | The VATTaxExemptionNature value of the Ledger. |
| VATTaxExemptionNumber | String | The VATTaxExemptionNumber value of the Ledger. |
| LedStateName | String | The LedStateName value of the Ledger. |
| VATApplicable | String | The VATApplicable value of the Ledger. |
| PartyBusinessType | String | The PartyBusinessType value of the Ledger. |
| PartyBusinessStyle | String | The PartyBusinessStyle value of the Ledger. |
| IsBillWiseOn | String | The IsBillWiseOn value of the Ledger. |
| IsCostCentresOn | String | The IsCostCentresOn value of the Ledger. |
| IsInterestOn | String | The IsInterestOn value of the Ledger. |
| AllowinMobile | String | The AllowinMobile value of the Ledger. |
| IsCostTrackingOn | String | The IsCostTrackingOn value of the Ledger. |
| IsBeneficiaryCodeOn | String | The IsBeneficiaryCodeOn value of the Ledger. |
| IsMstFromSync | String | The IsMstFromSync value of the Ledger. |
| IsUpdatingTargetId | String | The IsUpdatingTargetId value of the Ledger. |
| AsOriginal | String | The AsOriginal value of the Ledger. |
| IsCondensed | String | The IsCondensed value of the Ledger. |
| AffectsStock | String | The AffectsStock value of the Ledger. |
| IsRateInclusiveVAT | String | The IsRateInclusiveVAT value of the Ledger. |
| ForPayroll | String | The ForPayroll value of the Ledger. |
| IsABCEnabled | String | The IsABCEnabled value of the Ledger. |
| IsCreditDaysChkOn | String | The IsCreditDaysChkOn value of the Ledger. |
| InterestonBillwise | String | The InterestonBillwise value of the Ledger. |
| OverrideInterest | String | The OverrideInterest value of the Ledger. |
| OverrideAdvInterest | String | The OverrideAdvInterest value of the Ledger. |
| UseForVAT | String | The UseForVAT value of the Ledger. |
| IgnoreTDSExempt | String | The IgnoreTDSExempt value of the Ledger. |
| IsTCSApplicable | String | The IsTCSApplicable value of the Ledger. |
| IsTDSApplicable | String | The IsTDSApplicable value of the Ledger. |
| IsFBTApplicable | String | The IsFBTApplicable value of the Ledger. |
| IsGSTApplicable | String | The IsGSTApplicable value of the Ledger. |
| IsExciseApplicable | String | The IsExciseApplicable value of the Ledger. |
| IsTDSExpense | String | The IsTDSExpense value of the Ledger. |
| IsEDLIApplicable | String | The IsEDLIApplicable value of the Ledger. |
| IsRelatedParty | String | The IsRelatedParty value of the Ledger. |
| UseForESIEligibility | String | The UseForESIEligibility value of the Ledger. |
| IsInterestInclLastDay | String | The IsInterestInclLastDay value of the Ledger. |
| AppropriateTaxValue | String | The AppropriateTaxValue value of the Ledger. |
| IsBehaveAsDuty | String | The IsBehaveAsDuty value of the Ledger. |
| InterestInclDayOfAddition | String | The InterestInclDayOfAddition value of the Ledger. |
| InterestInclDayOfDeduction | String | The InterestInclDayOfDeduction value of the Ledger. |
| IsOthTerritoryAssessee | String | The IsOthTerritoryAssessee value of the Ledger. |
| OverRideCreditLimit | String | The OverRideCreditLimit value of the Ledger. |
| IsAgainstFormC | String | The IsAgainstFormC value of the Ledger. |
| IsChequePrintingEnabled | String | The IsChequePrintingEnabled value of the Ledger. |
| IsPayUpLoad | String | The IsPayUpLoad value of the Ledger. |
| IsPayBatchOnlySAL | String | The IsPayBatchOnlySAL value of the Ledger. |
| IsBNFCodeSupported | String | The IsBNFCodeSupported value of the Ledger. |
| AllowExportWithErrors | String | The AllowExportWithErrors value of the Ledger. |
| ConsiderPurchaseforExport | String | The ConsiderPurchaseforExport value of the Ledger. |
| IsTransporter | String | The IsTransporter value of the Ledger. |
| UseForNotionalITC | String | The UseForNotionalITC value of the Ledger. |
| IseCommOperator | String | The IseCommOperator value of the Ledger. |
| ShowinPayslip | String | The ShowinPayslip value of the Ledger. |
| UseForGratuity | String | The UseForGratuity value of the Ledger. |
| IsTDSProjected | String | The IsTDSProjected value of the Ledger. |
| ForServiceTax | String | The ForServiceTax value of the Ledger. |
| IsInputCredit | String | The IsInputCredit value of the Ledger. |
| IsExempted | String | The IsExempted value of the Ledger. |
| IsAbatementApplicable | String | The IsAbatementApplicable value of the Ledger. |
| IsSTXParty | String | The IsSTXParty value of the Ledger. |
| IsSTXNonRealizedType | String | The IsSTXNonRealizedType value of the Ledger. |
| IsUsedForCVD | String | The IsUsedForCVD value of the Ledger. |
| LedBelongsToNonTaxable | String | The LedBelongsToNonTaxable value of the Ledger. |
| IsExciseMerchantExporter | String | The IsExciseMerchantExporter value of the Ledger. |
| IsPartyExempted | String | The IsPartyExempted value of the Ledger. |
| IsSEZParty | String | The IsSEZParty value of the Ledger. |
| TDSDeducteeIsSpecialRate | String | The TDSDeducteeIsSpecialRate value of the Ledger. |
| IseChequeSupported | String | The IseChequeSupported value of the Ledger. |
| IseDDSupported | String | The IseDDSupported value of the Ledger. |
| HaseChequeDeliveryMode | String | The HaseChequeDeliveryMode value of the Ledger. |
| HaseChequeDeliveryTo | String | The HaseChequeDeliveryTo value of the Ledger. |
| HaseChequePrintLocation | String | The HaseChequePrintLocation value of the Ledger. |
| HaseChequePayableLocation | String | The HaseChequePayableLocation value of the Ledger. |
| HaseChequeBankLocation | String | The HaseChequeBankLocation value of the Ledger. |
| HaseDDDeliveryMode | String | The HaseDDDeliveryMode value of the Ledger. |
| HaseDDDeliveryTo | String | The HaseDDDeliveryTo value of the Ledger. |
| HaseDDPrintLocation | String | The HaseDDPrintLocation value of the Ledger. |
| HaseDDPayableLocation | String | The HaseDDPayableLocation value of the Ledger. |
| HaseDDBankLocation | String | The HaseDDBankLocation value of the Ledger. |
| IseBankingEnabled | String | The IseBankingEnabled value of the Ledger. |
| IsExportFileEncrypted | String | The IsExportFileEncrypted value of the Ledger. |
| IsBatchEnabled | String | The IsBatchEnabled value of the Ledger. |
| IsProductCodeBased | String | The IsProductCodeBased value of the Ledger. |
| HaseDDCity | String | The HaseDDCity value of the Ledger. |
| HaseChequeCity | String | The HaseChequeCity value of the Ledger. |
| IsFileNameFormatSupported | String | The IsFileNameFormatSupported value of the Ledger. |
| HasClientCode | String | The HasClientCode value of the Ledger. |
| PayInsIsBatchApplicable | String | The PayInsIsBatchApplicable value of the Ledger. |
| PayInsIsFileNumApp | String | The PayInsIsFileNumApp value of the Ledger. |
| IsSalaryTransGroupedForBRS | String | The IsSalaryTransGroupedForBRS value of the Ledger. |
| IseBankingSupported | String | The IseBankingSupported value of the Ledger. |
| IsSCBUAE | String | The IsSCBUAE value of the Ledger. |
| IsBankStatusApp | String | The IsBankStatusApp value of the Ledger. |
| IsSalaryGrouped | String | The IsSalaryGrouped value of the Ledger. |
| UseForPurchaseTax | String | The UseForPurchaseTax value of the Ledger. |
| Audited | String | The Audited value of the Ledger. |
| SamplingNumOneFactor | Decimal | The SamplingNumOneFactor value of the Ledger. |
| SamplingNumTwoFactor | Decimal | The SamplingNumTwoFactor value of the Ledger. |
| SortPosition | Decimal | The SortPosition value of the Ledger. |
| Alterid | Decimal | The Alterid value of the Ledger. |
| RemoteAlterID | Decimal | The RemoteAlterID value of the Ledger. |
| DefaultLanguage | Decimal | The DefaultLanguage value of the Ledger. |
| RateofTaxCalculation | Decimal | The RateofTaxCalculation value of the Ledger. |
| GratuityMonthDays | Decimal | The GratuityMonthDays value of the Ledger. |
| GratuityLimitMonths | Decimal | The GratuityLimitMonths value of the Ledger. |
| CalculationBasis | Decimal | The CalculationBasis value of the Ledger. |
| RoundingLimit | Decimal | The RoundingLimit value of the Ledger. |
| AbatementPercentage | Decimal | The AbatementPercentage value of the Ledger. |
| TDSDeducteeSpecialRate | Decimal | The TDSDeducteeSpecialRate value of the Ledger. |
| BeneficiaryCodeMaxLength | Decimal | The BeneficiaryCodeMaxLength value of the Ledger. |
| eChequePrintLocationVersion | Decimal | The eChequePrintLocationVersion value of the Ledger. |
| eChequePayableLocationVersion | Decimal | The eChequePayableLocationVersion value of the Ledger. |
| eDDPrintLocationVersion | Decimal | The eDDPrintLocationVersion value of the Ledger. |
| eDDPayableLocationVersion | Decimal | The eDDPayableLocationVersion value of the Ledger. |
| PayInsRunningFileNum | Decimal | The PayInsRunningFileNum value of the Ledger. |
| TransactionTypeVersion | Decimal | The TransactionTypeVersion value of the Ledger. |
| PayInsFileNumLength | Decimal | The PayInsFileNumLength value of the Ledger. |
| SamplingAmtOneFactor | String | The SamplingAmtOneFactor value of the Ledger. |
| SamplingAmtTwoFactor | String | The SamplingAmtTwoFactor value of the Ledger. |
| OpeningBalance | Decimal | The OpeningBalance value of the Ledger. |
| CreditLimit | String | The CreditLimit value of the Ledger. |
| GratuityLimitAmount | String | The GratuityLimitAmount value of the Ledger. |
| ODLimit | String | The ODLimit value of the Ledger. |
| tempGSTCGSTRate | Decimal | The tempGSTCGSTRate value of the Ledger. |
| tempGSTSGSTRate | Decimal | The tempGSTSGSTRate value of the Ledger. |
| tempGSTIGSTRate | Decimal | The tempGSTIGSTRate value of the Ledger. |
| tempGSTStateCessRate | Decimal | The tempGSTStateCessRate value of the Ledger. |
| tempIsVATfieldsEdited | String | The tempIsVATfieldsEdited value of the Ledger. |
| tempApplDate | Date | The tempApplDate value of the Ledger. |
| tempClassification | String | The tempClassification value of the Ledger. |
| tempNature | String | The tempNature value of the Ledger. |
| tempPartyEntity | String | The tempPartyEntity value of the Ledger. |
| tempBusinessNature | String | The tempBusinessNature value of the Ledger. |
| tempVATRate | Decimal | The tempVATRate value of the Ledger. |
| tempAddlTax | Decimal | The tempAddlTax value of the Ledger. |
| tempCessOnVat | Decimal | The tempCessOnVat value of the Ledger. |
| tempTaxType | String | The tempTaxType value of the Ledger. |
| tempMajorCommodityName | String | The tempMajorCommodityName value of the Ledger. |
| tempCommodityName | String | The tempCommodityName value of the Ledger. |
| tempCommodityCode | String | The tempCommodityCode value of the Ledger. |
| tempSubCommodityCode | String | The tempSubCommodityCode value of the Ledger. |
| tempUOM | String | The tempUOM value of the Ledger. |
| tempTypeofGoods | String | The tempTypeofGoods value of the Ledger. |
| tempTradeName | String | The tempTradeName value of the Ledger. |
| tempGoodsNature | String | The tempGoodsNature value of the Ledger. |
| tempSchedule | String | The tempSchedule value of the Ledger. |
| tempScheduleslNo | String | The tempScheduleslNo value of the Ledger. |
| tempIsInvDetailsEnable | String | The tempIsInvDetailsEnable value of the Ledger. |
| tempLocalVATRate | Decimal | The tempLocalVATRate value of the Ledger. |
| tempValuationType | String | The tempValuationType value of the Ledger. |
| tempIsCalcOnQty | String | The tempIsCalcOnQty value of the Ledger. |
| tempIsSaletoLocalCitizen | String | The tempIsSaletoLocalCitizen value of the Ledger. |
| LEDIsTDSApplicableCurrLiab | String | The LEDIsTDSApplicableCurrLiab value of the Ledger. |
| IsProductCodeEdited | String | The IsProductCodeEdited value of the Ledger. |
| Address | String | The Address value of the Ledger. |
| MailingName | String | The MailingName value of the Ledger. |
| TargetRemoteId | String | The TargetRemoteId value of the Ledger. |
| AddressNative | String | The AddressNative value of the Ledger. |
| BankUserLoginID | String | The BankUserLoginID value of the Ledger. |
| OldAuditEntryIds | Decimal | The OldAuditEntryIds value of the Ledger. |
| Closingbalance | Decimal | The Closingbalance value of the Ledger. |
| Address1 | String | The Address1 value of the Ledger. |
| Address2 | String | The Address2 value of the Ledger. |
| Address3 | String | The Address3 value of the Ledger. |
| Address4 | String | The Address4 value of the Ledger. |
| Address5 | String | The Address5 value of the Ledger. |
| Primarygroup | String | The Primarygroup value of the Ledger. |
| Overduebills | Decimal | The Overduebills value of the Ledger. |
| Onaccountvalue | String | The Onaccountvalue value of the Ledger. |
| Cashinflow | Decimal | The Cashinflow value of the Ledger. |
| Cashoutflow | Decimal | The Cashoutflow value of the Ledger. |
| Performance | Decimal | The Performance value of the Ledger. |
| Drinterest | Decimal | The Drinterest value of the Ledger. |
| Crinterest | String | The Crinterest value of the Ledger. |
| Lastinterestdate | Date | The Lastinterestdate value of the Ledger. |
| Thisyearbalance | Decimal | The Thisyearbalance value of the Ledger. |
| Prevyearbalance | String | The Prevyearbalance value of the Ledger. |
| Thisquarterbalance | Decimal | The Thisquarterbalance value of the Ledger. |
| Prevquarterbalance | String | The Prevquarterbalance value of the Ledger. |
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. |