OE sales history table layout
OE sales history table layout
(OP)
I have to extract OE sales history from macola and I was given a dump of the oelinhst_sql table without any field explanations.
Where can I find a list of field definitions?
Where can I find a list of field definitions?
RE: OE sales history table layout
RE: OE sales history table layout
In addition to oelinhst_sql, you may also wish to consider grabbing oehdrhst_sql and possibly your customer table (arcusfil_sql for Progression, cicmpy for ES) to get the most complete picture. When you join the history tables, make certain you join on ord_type, ord_no, and inv_no.
I actually create a view in my SQL database that joins everything together so I don't have to keep writing the same code over and over again.
Jen