I'm trying to locate the "manual style code" in the database with crystal reports so I can use it as a filter on an report. Does anyone know the location of the table containing this?

Thank you
Doug

Hi Doug,

If you mean the manual style code that you can assign to 'master' records such as customers, vendors, or items, it is stored on the table for the master item record, such as ARW90 Customer Information, for AR customers. Typically the Manual and Automatic Style code fields will be near the bottom of the field list because they are relatively new fields in the customer data structure.

If you are having a problem with a specific record type (say you can't find it for items), please indicate which table you are looking at. It may be that you are using an older table that does have the field updates.

Thanks for the speedy reply!
Ok, I see those one you listed. The one I'm looking for is the manual style code for Orders/Invoices/Credit Notes in Order Entry. I have been looking in:

OEW65 Orders and Invoice Headers
OEW65 Sales Order Header Ext
and a lots of other ones that I can think of!

Doug

Hi Doug,

It doesn't look like the OE crystal table has been updated with the Style code fields. It would appear in the Sales Order Header Ext table when it is available. I will pass on what you found to development.

ok, thanks again.

Doug

If you are using Adagio ODBCV2 to access the Adagio Database with Crystal Reports 2012/2013 then using AO80DHEM in the DSN Table Selection will give you the information.

Ordinal Name Offset Type Length
172 Manual Style Code 830 CHAR 20
173 Automatic Style Code 850 CHAR 20