Trx_Number in Ar_payment_schedules_all is not same as trx_number in Ra_customer_trx_all
Hi ,
from ra_customer_trx_all ract, ar_payment_schedules_all psa
where ract.customer_trx_id =psa.customer_trx_id
and to_char(ract.DOC_SEQUENCE_VALUE) =psa.TRX_NUMBER
and ract.customer_trx_id =2492913 The above query returned the below values:
F70296 243968 F70296 is RA_CUSTOMER_TRX_ALL.TRX_NUMBER 243968 is same as RA_CUSTOMER_TRX_ALL.DOC_SEQUENCE_VALUE Can any one help me why the trx_number in ra_customer_trx_all and ar_payment_schedules_all are not same.
I have a AR Transaction for which the Trx_number in Ar_payment_schdules_all is not same as trx_number in Ra_customer_trx_all.
select ract.trx_number ,psa.trx_numberfrom ra_customer_trx_all ract, ar_payment_schedules_all psa
where ract.customer_trx_id =psa.customer_trx_id
and to_char(ract.DOC_SEQUENCE_VALUE) =psa.TRX_NUMBER
and ract.customer_trx_id =2492913 The above query returned the below values:
F70296 243968 F70296 is RA_CUSTOMER_TRX_ALL.TRX_NUMBER 243968 is same as RA_CUSTOMER_TRX_ALL.DOC_SEQUENCE_VALUE Can any one help me why the trx_number in ra_customer_trx_all and ar_payment_schedules_all are not same.
0