PO28 and Line Status

unknown

I am trying to use SQL to pull out the information on PO28.  I only want a line status of D.  I am using table POVAGRMTHD for my query and don't see this field.  Is it stored somewhere else?  TIA

dechevar

That is a form filter field only and not stored in the table. For SQL you would need to code the following from the POVAGRMTLN table to get the same result:



SELECT POVAGRMTLN.EXPIRE_DT, POVAGRMTLN.HOLD_FLAG, POVAGRMTLN.STATUS

FROM LSLMDB.ls_apps.POVAGRMTLN POVAGRMTLN

WHERE (POVAGRMTLN.EXPIRE_DT > calendar__gregorian__today__)

AND (POVAGRMTLN.HOLD_FLAG = 'N')

AND (POVAGRMTLN.STATUS ! = 3)