Is crt_date an indexed column in the CST_INV_TRANSACTIONS table? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Is crt_date an indexed column in the CST_INV_TRANSACTIONS table?

Is crt_date an indexed column in the CST_INV_TRANSACTIONS table? We want to rely on this column for the latest transaction in the system hence the question.

We have an extension that updates standard cost based on BPA cost changes and Work Order completion. This started as an issue with the cost transactions not inserting date in the table based on the primary key sequence so we switch to use crt_date but have concern we will have similar issue in future if this data is not indexed. Thanks, John

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!