GM_PC_IVC_VW (SQL View)	Index Back
Grants Proj Rsrc Invoice View This view gives DISTINCT invoices for an Award in Proj Resource. A count is then done on this in gmivcrou.sqc to apply a sequence number to an invoice.

GM_PC_IVC_VW

(SQL View)

Grants Proj Rsrc Invoice View

This view gives DISTINCT invoices for an Award in Proj Resource. A count is then done on this in gmivcrou.sqc to apply a sequence number to an invoice.

SELECT DISTINCT B.CONTRACT_NUM ,B.INVOICE ,B.INVOICE_DT ,B.INVOICE_TYPE ,B.BILL_STATUS FROM PS_BI_HDR B WHERE B.CONTRACT_NUM <> ' ' AND B.INVOICE_TYPE IN ('REG','RAD')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

2 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice

3 INVOICE_DT Date(10) DATE Invoice Date

4 INVOICE_TYPE Character(3) VARCHAR2(3) NOT NULL Invoice Type
ACR=Credit Bill
ADJ=Adjustment Only bill
ARB=Rebill Bill
PRF=Pro Forma Invoice
RAD=Regular bill with adjustments
REG=Regular Bill

5 BILL_STATUS Character(3) VARCHAR2(3) NOT NULL Bill Status
CAN=Canceled
FNL=Finalized Bill
HLD=Hold Bill
INV=Invoiced Bill
NEW=New Bill
PND=Pending Approval
RDY=Ready to Invoice
TMP=Temporary Bill
TMR=Temporary Ready Bill

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
2	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
3	INVOICE_DT	Date(10)	DATE	Invoice Date
4	INVOICE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Invoice Type ACR=Credit Bill ADJ=Adjustment Only bill ARB=Rebill Bill PRF=Pro Forma Invoice RAD=Regular bill with adjustments REG=Regular Bill
5	BILL_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Bill Status CAN=Canceled FNL=Finalized Bill HLD=Hold Bill INV=Invoiced Bill NEW=New Bill PND=Pending Approval RDY=Ready to Invoice TMP=Temporary Bill TMR=Temporary Ready Bill