Master Card Data Load in Expenses 9.2
We are just starting our upgrade to Release 9.2 Expenses, and we noticed that the transaction number is now loaded to EX_TRANS.TRANS_NBR in a different format. EX_DATA_LOAD used to take the transaction number as it was from our bank, but now it appears to be loading the last four digits of the credit card number, plus the transaction date in YYYYMMDD format instead. If there is more than one transaction on that date, it increments the Sequence Number field. We have other programs which depend on the trans_nbr to be unique, so we are wondering if there is any way to
1