SPF_INVSTAT_VW1

(SQL View)
 Index Back

Invoice Status View 1

This view return the invoice status translate values with status equal to '1','2','3','5','6', '10','11'

SELECT %Substring(X1.FIELDVALUE, 1, 2) , X1.XLATLONGNAME FROM PSXLATITEM X1 WHERE X1.FIELDNAME= 'INVOICE_STATUS' AND X1.FIELDVALUE IN ('1','10','11','2','3','5','6') 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