BI_LC_IV_ACT_VW

(SQL View)
Index Back

LOC Process Instance

Letter of Credit Process Instance for Extract Rows from Summary table

SELECT DISTINCT FieldValue , xlatlongname FROM PSXLATITEM WHERE FieldName = 'INVOICE_ACTION' AND FieldValue <> 'C'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INVOICE_ACTION Character(1) VARCHAR2(1) NOT NULL Invoice Action
C=Reprint
I=Invoice
P=Pro Forma
2 LOC_INVOICE_ACTION Character(20) VARCHAR2(20) NOT NULL Invoice Action