xMatix
Sign in Request demo
xMatix
PRODUCTS
SalesField Sales & SFACRMRewardsClaimsInventoryProcurementWarehouse ManagementField ServiceServiceSupportTelephony & MessagingFinance & AccountingPayrollExpense ManagementCommercePortalsAnalytics & ReportingData StudioMobile AppSee all products →
PLATFORM
Platform overviewApp BuilderAutomationIntegrationsSecurity & GovernanceChange ManagementDevelopers
SENSE AI
Sense AI overviewSense AssistSense ControlSense VisionAI StudioTrust & governanceIn Claude & ChatGPTUse cases
SOLUTIONS
Auto DMSConsumer Goods DMSSales Force Automation (SFA) FMCG & DistributionManufacturing & Dealer NetworksAutomotive & DealershipsPharma & HealthcareConsumer DurablesAgri-InputsBuilding MaterialsService NetworksWarehousing & 3PLFinancial AccountingERP SoftwareIndia GST ComplianceUAE VAT & e-InvoicingSaudi ZATCA & VATAll solutions →
RESOURCES
Knowledge CenterDeveloper & CLIBlogGuidesWhat is xMatix?Company facts
COMPANY
AboutCareersPartnersEventsContactAuthorsLegal
Sign in Request demo
Home/Docs/Entity Reference/TDS Transaction — entity reference
REFERENCE · Last reviewed

TDS Transaction — entity reference

One row of the withholding register: a TDS deduction or TCS collection written by posting a bill, invoice, payment, receipt application, credit note or debit note that carries a TDS section (or a withheld tax amount on a receipt). Posting also posts the withholding journal and links it in GL. Monthly challans draft Computed rows with positive tax, quarterly returns are computed from rows that are not Reversed, and certificates stamp their numbers back. Rows are system-written; hand edits are not validated and recompute nothing. TDS that customers deducted from the company is stored with Nature TDS and Source Entity Name Invoice, and challan drafting and return computation do not separate it from TDS the company deducted.

Fields

FieldLabelTypeRequiredWhat it does
BranchIdBranchLookup → BranchBranch of the source document.
BusinessUnitIdBusiness UnitLookup → BusinessUnitNot filled by posting and on no form.
CertificateNumberCertificate NumberTextChallan name, written on deposit when empty; replaced by the certificate number when Generate Certificates runs on a filed return. A value here blocks a bill's TDS override re-post.
CreatedByIdCreated ByLookup → UserAccountYes
CreatedDateTimeCreated OnDateAndTimeYes
DeductionDateDeduction DateDateAndTimeWhen the tax was deducted or recognised. Equal to Document Date on bill, payment and note rows; the invoice or receipt posting date on rows for TDS a customer deducted. Used for challan interest.
DocumentDateDocument DateDateAndTimeDate the row counts in: the posting date of the bill, payment or note that deducted it, or the invoice date for TDS a customer deducted. Decides the challan month and the return quarter.
DocumentNumberDocument NumberTextReference of the source document: for bills the supplier's invoice number when present, otherwise the document name.
FiscalPeriodIdFiscal PeriodLookup → FiscalPeriodNot filled by posting; nothing reads it.
FiscalYearIdFiscal YearLookup → FiscalYearThe company's fiscal year covering the posting date. Annual threshold totals are per fiscal year.
GLIdGLLookup → JournalThe withholding journal posted with the row. For TCS collected through a Document Tax Slot it is the invoice's own journal; empty on nil-certificate rows.
IdIdGuidYes
LdcCertificateIdLower Deduction CertificateLookup → LowerDeductionCertificateThe lower deduction certificate applied, set with remarks A or B. The return copies the certificate number from it.
ModifiedByIdModified ByLookup → UserAccountYes
NameNameTextYesNumber from the TDS Transaction document name setting (series TT, the save date and a six-digit number).
NatureNaturePickListTDS or TCS, copied from the section (credit and debit note reversals are always TDS). Decides the control account and the return the row goes to: TDS to Form 140, TCS to Form 143. Values: TDS — deducted on payables, TCS — collected on receivables.
OwnerIdOwnerLookup → UserAccountYes
PanAvailablePAN AvailableBooleanWhether the party's account had a PAN when the row was posted. Off means the section's no-PAN rate could apply (remarks code C).
PartnerAccountIdPartner AccountLookup → AccountThe company that withheld. Challans, returns and threshold totals are per company.
PartyAccountIdParty AccountLookup → AccountThe vendor or customer the tax was deducted from or collected from.
PartyPanParty PANTextPAN held on the party's account at posting. The quarterly return reports this value, so a wrong PAN on a posted deduction is fixed by editing it here and recomputing the return.
PaymentCodePayment CodeNumberPayment code copied from the section row. Monthly challans are grouped by it.
RateRateCurrencyRate applied, in percent: the section rate, the no-PAN rate or a certificate's rate. On rows from a bill's TDS amount override it is the effective rate (tax divided by base).
RecordTypeIdRecord TypeGuid, hidden
RemarksCodeRemarks CodePickListReturn remarks: A when a lower deduction certificate's rate applied, B for a nil certificate (zero tax, no journal), C when the no-PAN rate applied. Empty means the normal rate. Values: A — Lower deduction (s.395), B — Nil deduction (s.395), C — Higher rate (PAN missing).
SectionCodeSection CodeTextSection code copied from the section row. The party's annual threshold total adds up rows by this code.
SourceEntityNameSource Entity NameTextThe kind of document that wrote the row: Bill, Invoice, CreditNote or DebitNote. Invoice rows with Nature TDS are TDS a customer deducted from the company.
SourceRecordIdSource RecordGuidId of the source document named in Source Entity Name.
StatusStatusPickListComputed when written; Deposited when Deposit Challan runs on the challan holding the row; Reversed when a bill override re-post replaces it or an invoice cancel or receipt reversal reverses TCS or receipt-withheld rows. Nothing sets a row back to Computed. Credit and debit notes add negative rows instead of changing the status. Values: Computed, Deposited, Reversed.
TaxableBaseTaxable BaseCurrencyPart of the amount that was taxed: the whole amount, or only the excess over the annual threshold for sections taxed on the excess. Also what a lower deduction certificate's consumption adds up.
TaxAmountTax AmountCurrencyTax deducted or collected. Negative on credit and debit note rows; zero on nil-certificate rows. Only rows with tax above zero are drafted onto challans.
TdsSectionIdTDS SectionLookup → TdsSectionThe section row actually used, which can differ from the line's section when a same-code row was chosen for the date or the party's deductee type. Empty on rows from a receipt's withheld tax amount.
TransactionAmountTransaction AmountCurrencyDocument amount assessed for the section. Counts towards the party's annual threshold total; negative on credit and debit note rows.
UIPropsUI PropsText
UpdatedDateTimeUpdated OnDateAndTimeYes

Actions

ActionLabelTypeWhat it does
CloneCloneServerAction (Clone)Create a copy of this record
DeleteDeleteDeleteDelete
EditEditEditInlineEdit
NewNewNewNew