BI_LC_IV_ACT_VW(SQL View) |
Index Back |
---|---|
LOC Process InstanceLetter 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 |