Table and field to retrieve Contract_Number from Project module for an AR invoice
Summary:
Due to Japanese character set contract_number was getting truncated while flowing into ra_customer_trx_all table. In project module there was no issue hence it was showing complete contract_number but in AR side we are getting truncated contract_number. Please find the difference in field size below.
ra_customer_trx_all.interface_line_attribute1 -- size 30
okc_k_headers_b.contract_number -- size 120
So, we would like to know alternate way to retrieve the original contract number value from source module (Table & Field). We need this to print in AR invoice report.
Content (please ensure you mask any confidential information):
0