- Terms descriptions (text description) -> Link to the ARRTA table for the description.

- Order status description - not in the database. Need to create your own description list.

- Date invoiced - the order header INVDATE doesn't appear to be updated with the correct Invoice date. Read the OEINVH table.

Thank you. On the order status description there is a grayed status on the header to the right of the PO number field. it shows a description (ex: order confirmed printed). Any suggestions on where to find that information?

OEORDH.PRINTSTAT:
1 =
2 = Quote printed
3 = Picking slip printed
0 = Internet
-1 = Electronic Commerce

I suggest you download the AOM: support.na.sage.com/.../viewdocument.do

Thanks again. I do have the AOM but did not see the "order confirmed printed" status anywhere. I assume it is number 1 on this list.

Browse the OEORDH table and check which field it is, then check the AOM. Not all the field values are in the AOM.

Hello again, the OEINVH table has invoice dates for sales orders but does not seem to have a field that I can use to link that date to the orders' line items. As the line items can be invoiced separately we need to be able to determine the invoice date per line. Any suggestions? Thanks.

use the OEINVD for the details then. that way you are looking at the items on each invoice and then go backwards to pull information from the order it originated from.