SPF_INVSTAT_VW2

(SQL View)
 Index Back

Invoice Status View 2

This view returns the invoice status translate values for status <> '4'

SELECT %Substring(X1.FIELDVALUE, 1, 2) , X1.XLATLONGNAME FROM PSXLATITEM X1 WHERE X1.FIELDNAME= 'INVOICE_STATUS' AND X1.FIELDVALUE <> '4' AND %EffdtCheck(PSXLATITEM X2, X1, %CurrentDateIn) AND X1.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SPF_INV_STATUS Character(2) VARCHAR2(2) NOT NULL Invoice Status
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description