Database
Tax
SAL_TaxDeductor_Master

SAL_TaxDeductor_Master

Documentation for the SAL_TaxDeductor_Master database schema.

Fields

FieldData TypeUsage
anyIdObjectIdUnique reference to any.
deductionIdStringUnique reference to deduction.
nameOfDeductorStringThe name or title of the sal_taxdeductor_master.
branchOfDeductorStringStores the branch of deductor data.
flatNumberDeductorStringTimestamp/Date for flatNumberDeductor.
buildingNameDeductorStringThe name or title of the sal_taxdeductor_master.
streetDeductorStringStores the street deductor data.
areaDeductorStringStores the area deductor data.
stateDeductorStringTimestamp/Date for stateDeductor.
pinCodeDeductorStringStores the pin code deductor data.
changeAddressDeductorStringStores the change address deductor data.
phoneDeductorStringContact phone number.
stdCodeDeductorStringStores the std code deductor data.
faxDeductorStringStores the fax deductor data.
emailDeductorStringPrimary email address.
sexResponsiblePersonStringStores the sex responsible person data.
nameResponsiblePersonStringThe name or title of the sal_taxdeductor_master.
designationResponsiblePersonStringTimestamp/Date for designationResponsiblePerson.
fatherNameResponsiblePersonStringThe name or title of the sal_taxdeductor_master.
flatNumberResponsiblePersonStringTimestamp/Date for flatNumberResponsiblePerson.
buildingNameResponsiblePersonStringThe name or title of the sal_taxdeductor_master.
streetResponsiblePersonStringStores the street responsible person data.
areaResponsiblePersonStringStores the area responsible person data.
stateResponsiblePersonStringTimestamp/Date for stateResponsiblePerson.
pinCodeResponsiblePersonStringStores the pin code responsible person data.
changeAddressResponsiblePersonStringStores the change address responsible person data.
phoneResponsiblePersonStringContact phone number.
stdCodeResponsiblePersonStringStores the std code responsible person data.
faxResponsiblePersonStringStores the fax responsible person data.
emailResponsiblePersonStringPrimary email address.
panNumberStringStores the pan number data.
existingTdsAccessStringStores the existing tds access data.
startFinancialYearStringStores the start financial year data.
endFinancialYearStringStores the end financial year data.
tanNumberStringStores the tan number data.
returnTypeStringStores the return type data.
startAssessmentYearStringStores the start assessment year data.
endAssessmentYearStringStores the end assessment year data.
approvedStringStores the approved data.
officerCodeStringStores the officer code data.
statusStringTimestamp/Date for status.
taxDeductedFromStringStores the tax deducted from data.
insertedUserIdObjectIdUnique reference to inserted User.
updatedUserIdObjectIdUnique reference to updated User.
insertedDateIdObjectIdUnique reference to inserted Date.
updatedDateIdObjectIdUnique reference to updated Date.