Gets reconcilation transaction detail
get
/service/v1/getReconTmData
This endpoint is used to gets reconcilation transaction detail from Tm Table.
Request
Supported Media Types
- application/json
- application/xml
Query Parameters
-
reconTxnRefNo: string
Request parameter
Header Parameters
-
appId: string
Application id
-
branchCode: string
Branch Code
-
userId: string
User id
Response
Supported Media Types
- application/json
- application/xml
200 Response
Successfully received invoicesPayments details
Root Schema : ReconTxnDto
Type:
object
each recon txn deatail
Show Source
-
allocBasis(optional):
string
-
allocPayReconDtoList(optional):
array allocPayReconDtoList
-
authDtStamp(optional):
string
-
authId(optional):
string
-
branchCode(optional):
string
-
corporateId(optional):
string
-
expDrCrPayReconDtoList(optional):
array expDrCrPayReconDtoList
-
finPayReconDtoList(optional):
array finPayReconDtoList
-
id(optional):
number
-
lhsEntity(optional):
string
-
makerDtStamp(optional):
string
-
makerId(optional):
string
-
obReconInvCnTxnTwDtoList(optional):
array obReconInvCnTxnTwDtoList
-
obReconInvPmtTxnTwDtoList(optional):
array obReconInvPmtTxnTwDtoList
-
reconAction(optional):
string
-
reconCategory(optional):
string
-
reconDate(optional):
string
-
reconRule(optional):
string
-
reconRuleDefinitionDTO(optional):
object ReconRuleDefinitionDTO
-
reconRuleType(optional):
string
-
reconRuleVersion(optional):
number
-
reconTxnRefNo(optional):
string
-
reconType(optional):
string
-
rhsEntity(optional):
string
-
stage(optional):
string
-
totalAllocatedAmt(optional):
number
-
transactionStatus(optional):
string
Nested Schema : allocPayReconDtoList
Type:
Show Source
array
-
Array of:
object AllocPayReconDto
Object for Allocation Payment
Nested Schema : expDrCrPayReconDtoList
Type:
Show Source
array
-
Array of:
object ExpDrCrPayReconDto
Object for ExpectedDebitCredit Payment Recon.
Nested Schema : finPayReconDtoList
Type:
Show Source
array
-
Array of:
object FinPayReconDto
Object for Finance Payment Recon.
Nested Schema : obReconInvCnTxnTwDtoList
Type:
Show Source
array
-
Array of:
object ReconInvCnDto
invoice and credit note detail
Nested Schema : obReconInvPmtTxnTwDtoList
Type:
Show Source
array
-
Array of:
object ReconInvPmtDto
invoice and payment detail
Nested Schema : ReconRuleDefinitionDTO
Type:
Show Source
object
-
allocationBasis(optional):
string
Allocation Basis
-
approverRemarks(optional):
string
Approver Remarks
-
authStatus(optional):
string
Authorization Status
-
baseEntity(optional):
string
Base Entity
-
baseOnAttr(optional):
string
Base on attribute
-
checkerDateStamp(optional):
string(date)
Checker Date Stamp
-
checkerId(optional):
string
Checker Id
-
corporateId(optional):
string
-
doerRemarks(optional):
string
Doer Remarks
-
genericCriteria(optional):
string
Generic Criteria
-
groupsAndConditions(optional):
array groupsAndConditions
-
keyId(optional):
string
Key Id
-
makerDateStamp(optional):
string(date)
Maker Date Stamp
-
makerId(optional):
string
Maker Id
-
modNo(optional):
number
Mod Number
-
onceAuth(optional):
string
Once Auth
-
reconAllocationDTO(optional):
array reconAllocationDTO
-
reconCategory(optional):
string
Recon Category
-
reconType(optional):
string
Recon Type
-
recordStatus(optional):
string
Record Status
-
ruleDescription(optional):
string
Rule Description
-
ruleId(optional):
string
Rule Id
-
txnControllerRefNo(optional):
string
Transaction Controller Reference Number
Nested Schema : AllocPayReconDto
Type:
object
Object for Allocation Payment
Show Source
-
accOwner(optional):
string
-
allocatedAmt(optional):
number
-
allocationPct(optional):
number
-
allocAttributes(optional):
string
-
allocBasis(optional):
string
-
allocEntity(optional):
string
-
allocStatus(optional):
string
-
allocVirtualAccNo(optional):
string
-
beneCode(optional):
string
-
beneficiaryCode(optional):
string
-
beneficiaryId(optional):
string
-
beneficiaryName(optional):
string
-
beneVirtualAccNo(optional):
string
-
corporateId(optional):
string
-
corporateName(optional):
string
-
counterpartyCode(optional):
string
-
counterpartyId(optional):
string
-
counterpartyName(optional):
string
-
creditAccNo(optional):
string
-
dcIndicator(optional):
string
-
extPmtRefNo(optional):
string
-
flag(optional):
string
-
id(optional):
number
-
isPmtAccVA(optional):
string
-
obdxRefNo(optional):
string
-
obvamRefNo(optional):
string
-
partyPaymentCode(optional):
string
-
paymentAmount(optional):
number
-
paymentBusinessDate(optional):
string
-
paymentCcy(optional):
string
-
paymentDate(optional):
string
-
paymentMode(optional):
string
-
paymentPartyId(optional):
string
-
paymentPartyName(optional):
string
-
paymentRefNo(optional):
string
-
paySeqNo(optional):
integer(int64)
-
pmtAllocatedAmt(optional):
number
-
pmtAllocationStatus(optional):
string
-
pmtReconStatus(optional):
string
-
pmtUnallocatedAmt(optional):
number
-
pmtUnmatchedAmt(optional):
number
-
programCode(optional):
string
-
reconAction(optional):
string
-
reconciledPmtAmt(optional):
number
-
reconDate(optional):
string
-
reconId(optional):
string
-
reconTxnRefNo(optional):
string
-
reconType(optional):
string
-
relationshipCode(optional):
string
-
remarks(optional):
string
-
remitterAccNo(optional):
string
Nested Schema : ExpDrCrPayReconDto
Type:
object
Object for ExpectedDebitCredit Payment Recon.
Show Source
-
accOwner(optional):
string
-
actualDate(optional):
string
-
allocationRequired(optional):
string
-
allocPayReconDtoList(optional):
array allocPayReconDtoList
-
amtMatched(optional):
number
-
applicationName(optional):
string
-
beneCode(optional):
string
-
beneficiaryId(optional):
string
-
beneName(optional):
string
-
beneVirtualAccNo(optional):
string
-
cashflowType(optional):
string
-
channel(optional):
string
-
corporateId(optional):
string
-
corporateName(optional):
string
-
counterpartyId(optional):
string
-
counterpartyName(optional):
string
-
customerRefNo(optional):
string
-
dcIndicator(optional):
string
-
exchRate(optional):
number
-
expDrcrAmt(optional):
number
-
expDrcrBankAccNumber(optional):
string
-
expDrcrCcy(optional):
string
-
expDrcrCode(optional):
string
-
expDrcrCodeDesc(optional):
string
-
expDrcrDate(optional):
string
-
expDrcrIndicator(optional):
string
-
expDrcrNarration(optional):
string
-
expDrcrRefNo(optional):
string
-
expDrcrVirtualAccNo(optional):
string
-
expectedNetInvAmt(optional):
number
-
externalAccNo(optional):
string
-
externalDrcrRefNo(optional):
string
-
externalPmtRefNo(optional):
string
-
extSysRefNo(optional):
string
-
flag(optional):
string
-
id(optional):
number
-
isPmtAccVA(optional):
string
-
matchSeqNo(optional):
string
-
partyName(optional):
string
-
partyPaymentCode(optional):
string
-
payCounterpartyCode(optional):
string
-
payCounterpartyId(optional):
string
-
payCounterpartyName(optional):
string
-
paymentAmount(optional):
number
-
paymentBusinessDate(optional):
string
-
paymentCcy(optional):
string
-
paymentDate(optional):
string
-
paymentMode(optional):
string
-
paymentPartyId(optional):
string
-
paymentPartyName(optional):
string
-
paymentRefNo(optional):
string
-
paySeqNo(optional):
integer(int64)
-
pmtProgramCode(optional):
string
-
pmtRelationshipCode(optional):
string
-
pmtStatus(optional):
string
-
reconciledPmtAmt(optional):
number
-
reconDate(optional):
string
-
reconStatus(optional):
string
-
reconTxnRefNo(optional):
string
-
reconType(optional):
string
-
remarks(optional):
string
-
remitterAccNo(optional):
string
-
revisedDrcrDate(optional):
string
-
udfTxt1(optional):
string
-
udfTxt10(optional):
string
-
udfTxt2(optional):
string
-
udfTxt3(optional):
string
-
udfTxt4(optional):
string
-
udfTxt5(optional):
string
-
udfTxt6(optional):
string
-
udfTxt7(optional):
string
-
udfTxt8(optional):
string
-
udfTxt9(optional):
string
Nested Schema : allocPayReconDtoList
Type:
Show Source
array
-
Array of:
object AllocPayReconDto
Object for Allocation Payment
Nested Schema : FinPayReconDto
Type:
object
Object for Finance Payment Recon.
Show Source
-
allocationRequired(optional):
string
Allocation Required
-
allocationStatus(optional):
boolean
Allocation Status
-
allocPayReconDtoList(optional):
array allocPayReconDtoList
-
amtMatched(optional):
number
-
anchorId(optional):
string
-
anchorName(optional):
string
-
beneCode(optional):
string
-
beneName(optional):
string
-
beneVirtualAccNo(optional):
string
-
counterpartyId(optional):
string
-
counterpartyName(optional):
string
-
exchRate(optional):
number
-
finAmt(optional):
number
-
finBuyerId(optional):
string
-
finBuyerName(optional):
string
-
finCcy(optional):
string
-
finEndDt(optional):
string
-
finOsAmt(optional):
number
-
finPastDueDt(optional):
string
-
finProgramCode(optional):
string
-
finRefNo(optional):
string
-
finSeqNo(optional):
string
-
finStartDt(optional):
string
-
finSupplierId(optional):
string
-
finSupplierName(optional):
string
-
id(optional):
number
-
intOsAmt(optional):
number
-
matchSeqNo(optional):
string
-
overdueIntOsAmt(optional):
number
-
paymentAmount(optional):
number
-
paymentCcy(optional):
string
-
paymentDate(optional):
string
-
paymentMode(optional):
string
-
paymentPartyId(optional):
string
-
paymentPartyName(optional):
string
-
paymentRefNo(optional):
string
-
paySeqNo(optional):
integer(int64)
-
penIntOsAmt(optional):
number
-
pmtProgramCode(optional):
string
-
pmtStatus(optional):
string
-
reconcileBy(optional):
string
-
reconciledPmtAmt(optional):
number
-
reconDate(optional):
string
-
reconStatus(optional):
string
-
reconTxnRefNo(optional):
string
-
totIntOsAmt(optional):
number
Nested Schema : allocPayReconDtoList
Type:
Show Source
array
-
Array of:
object AllocPayReconDto
Object for Allocation Payment
Nested Schema : ReconInvCnDto
Type:
object
invoice and credit note detail
Show Source
-
accountNumber(optional):
string
-
accountOwner(optional):
string
-
amtMatched(optional):
number
-
cnBaseAmount(optional):
number
-
cnBuyerCode(optional):
string
-
cnBuyerDivCode(optional):
string
-
cnBuyerId(optional):
string
-
cnBuyerName(optional):
string
-
cnCurrency(optional):
string
-
cnDate(optional):
string
-
cnExpiryDate(optional):
string
-
cnInternalId(optional):
string
-
cnNumber(optional):
string
-
cnProgramCode(optional):
string
-
cnReconStatus(optional):
string
-
cnRelationCode(optional):
string
-
cnSeqNo(optional):
integer(int64)
-
cnSupplierCode(optional):
string
-
cnSupplierDivCode(optional):
string
-
cnSupplierId(optional):
string
-
cnSupplierName(optional):
string
-
corporateId(optional):
string
-
deReconFlag(optional):
string
-
exchRate(optional):
number
-
extInvRefNo(optional):
string
-
extSysRefNo(optional):
string
-
filler1(optional):
string
-
filler10(optional):
string
-
filler2(optional):
string
-
filler3(optional):
string
-
filler4(optional):
string
-
filler5(optional):
string
-
filler6(optional):
string
-
filler7(optional):
string
-
filler8(optional):
string
-
filler9(optional):
string
-
id(optional):
number
-
importFactorId(optional):
string
-
importFactorName(optional):
string
-
insuranceCoId(optional):
string
-
insuranceCoName(optional):
string
-
intInvRefNo(optional):
string
-
invBaseAmt(optional):
number
-
invBuyerId(optional):
string
-
invBuyerName(optional):
string
-
invCcy(optional):
string
-
invDate(optional):
string
-
invDueDate(optional):
string
-
invFinanced(optional):
string
-
invOsAmt(optional):
number
-
invProgramCode(optional):
string
-
invRelationCode(optional):
string
-
invSeqNo(optional):
integer(int64)
-
invSupplierId(optional):
string
-
invSupplierName(optional):
string
-
invVirtualAccNo(optional):
string
-
isCnAccVa(optional):
string
-
isInvAccVa(optional):
string
-
linkedDeReconTxnRef(optional):
string
-
netCnAmount(optional):
number
-
netInvAmt(optional):
number
-
paymentDueDate(optional):
string
-
paymentParty(optional):
string
-
procBranchCode(optional):
string
-
procBranchDate(optional):
string
-
reconciledCnAmt(optional):
number
-
reconDate(optional):
string
-
reconStatus(optional):
string
-
reconTxnRefNo(optional):
string
-
reconType(optional):
string
-
remarks(optional):
string
-
remitterAccNo(optional):
string
-
seqNo(optional):
number
-
varianceAmount(optional):
number
Nested Schema : ReconInvPmtDto
Type:
object
invoice and payment detail
Show Source
-
accountNo(optional):
string
-
accOwner(optional):
string
-
allocationRequired(optional):
string
-
allocPayReconDtoList(optional):
array allocPayReconDtoList
-
amtMatched(optional):
number
-
beneCode(optional):
string
-
beneficiaryId(optional):
string
-
beneName(optional):
string
-
beneVirtualAccNo(optional):
string
-
corporateId(optional):
string
-
counterpartyCode(optional):
string
-
dateReferenceBasis(optional):
string
-
dcIndicator(optional):
string
-
exchRate(optional):
number
-
extInvRefNo(optional):
string
-
extPmtRefNo(optional):
string
-
extSysRefNo(optional):
string
-
flag(optional):
string
-
id(optional):
number
-
importFactorId(optional):
string
-
importFactorName(optional):
string
-
indicator(optional):
string
-
insuranceCoId(optional):
string
-
insuranceCoName(optional):
string
-
intInvRefNo(optional):
string
-
invBaseAmt(optional):
number
-
invBuyerId(optional):
string
-
invBuyerName(optional):
string
-
invCcy(optional):
string
-
invDate(optional):
string
-
invDueDate(optional):
string
-
invFinanced(optional):
string
-
invOsAmt(optional):
number
-
invProgramCode(optional):
string
-
invRelationCode(optional):
string
-
invSeqNo(optional):
integer(int64)
-
invSupplierId(optional):
string
-
invSupplierName(optional):
string
-
invVirtualAccNo(optional):
string
-
isIndirectPayment(optional):
string
-
isInvAccVa(optional):
string
-
isPmtAccVA(optional):
string
-
isPUA(optional):
string
-
matchSeqNo(optional):
string
-
netInvAmt(optional):
number
-
paidAmount(optional):
number
-
partyPaymentCode(optional):
string
-
payCounterpartyId(optional):
string
-
payCounterpartyName(optional):
string
-
paymentAmount(optional):
number
-
paymentBusinessDate(optional):
string
-
paymentCcy(optional):
string
-
paymentDate(optional):
string
-
paymentDueDate(optional):
string
-
paymentMode(optional):
string
-
paymentParty(optional):
string
-
paymentPartyId(optional):
string
-
paymentPartyName(optional):
string
-
paymentRefNo(optional):
string
-
paySeqNo(optional):
integer(int64)
-
pmtProgramCode(optional):
string
-
pmtRelationshipCode(optional):
string
-
pmtStatus(optional):
string
-
reconcileBy(optional):
string
-
reconciledPmtAmt(optional):
number
-
reconDate(optional):
string
-
reconPmtAmount(optional):
number
-
reconPmtAmountCcy(optional):
string
-
reconStatus(optional):
string
-
reconTxnRefNo(optional):
string
-
reconType(optional):
string
-
remarks(optional):
string
-
remitterAccNo(optional):
string
-
varianceAmount(optional):
number
Nested Schema : allocPayReconDtoList
Type:
Show Source
array
-
Array of:
object AllocPayReconDto
Object for Allocation Payment
Nested Schema : RuleElementsDTO
Type:
Show Source
object
-
connectingOperator(optional):
string
Logical Operator applied between all groups, this is the connecting operator
-
groupsAndConditions(optional):
array groupsAndConditions
-
id(optional):
string
Unique identifier for a group or condition
-
isGroup(optional):
boolean
Boolean value to identify whether this child is a group or condition
-
level(optional):
number
This helps to identify the nesting level.
-
matchingCriteria(optional):
string
Matching Criteria
-
patternTypeLHS(optional):
object PatternTypeDTO
-
patternTypeRHS(optional):
object PatternTypeDTO
-
reconEntityAttribLHS(optional):
string
Will be provided if Single entity is LHS entity or if single entity is N. Attribute which user wants to use for recon
-
reconEntityAttribRHS(optional):
string
Will be provided if Single entity is RHS entity or if single entity is N. Attribute which user wants to use for recon
-
reconEntityLHS(optional):
string
Should be null or not present if isGroup is true
-
reconEntityRHS(optional):
string
Should be null or not present if isGroup is true
Nested Schema : PatternTypeDTO
Type:
Show Source
object
-
inputValue1(optional):
string
Input Value1
-
inputValue2(optional):
string
Input Value2
-
type(optional):
string
Type
Nested Schema : ReconAllocationDTO
Type:
Show Source
object
-
action(optional):
string
Action
-
allocationParameter(optional):
string
Allocation Parameter
-
customerId(optional):
string
-
id(optional):
string
Id
-
percentage(optional):
number
Percentage
-
reconRuleDefinitionId(optional):
string
Recon Rule Definition Id
400 Response
Malformed syntax.
401 Response
Request does not have sufficient credentials.
403 Response
Request is not authorized.
405 Response
Invalid input
500 Response
Internal error