BI_LC_IV_ACT_VW (SQL View)	Index Back
LOC Process Instance Letter of Credit Process Instance for Extract Rows from Summary table

BI_LC_IV_ACT_VW

(SQL View)

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

#	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