I am writing a custom report where the user keys in a shipper/asn number, and I report a combination of data from the abs_mstr and various edi_ecommerce files (e.g.: edmfr_mstr).
I know I can get at it using edmfr_mft_idx edmfr_mft_idx_val, but these are not indexed in the table, so this access is SLOW, especially for a single-ASN inquiry.
I also know I can get to the batch number using abs_export_batch on the "s" level abs_mstr record.
Any tips? Thanks,
Joe
PS: This client is running EB 2.1, Linux.
I know I can get at it using edmfr_mft_idx edmfr_mft_idx_val, but these are not indexed in the table, so this access is SLOW, especially for a single-ASN inquiry.
I also know I can get to the batch number using abs_export_batch on the "s" level abs_mstr record.
Any tips? Thanks,
Joe
PS: This client is running EB 2.1, Linux.