CDT_INVCSUM_VW (SQL View)	Index Back
CDT Invoice Summary

CDT_INVCSUM_VW

(SQL View)

CDT Invoice Summary

SELECT BILL_TO_CUST_ID , INVOICE , DT_INVOICED , business_Unit , bill_status , bi_currency_cd , invoice_amount , invoice_amount + forward_bal_amt - paid_amt FROM PS_BI_HDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer

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

3 DT_INVOICED Date(10) DATE Date Invoiced

4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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

6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

7 INVOICE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount

8 NET_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL The resulting net amount related to settlement cash flows subject to counterparty netting agreements.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer
2	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
3	DT_INVOICED	Date(10)	DATE	Date Invoiced
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
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
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
7	INVOICE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Amount
8	NET_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The resulting net amount related to settlement cash flows subject to counterparty netting agreements.