C360_DS_INVS_VW (SQL View)	Index Back
Bill Header View Used for Customer 360 Billing grid

C360_DS_INVS_VW

(SQL View)

Bill Header View

Used for Customer 360 Billing grid

SELECT S.SETID , A.BILL_TO_CUST_ID ,A.BUSINESS_UNIT ,A.INVOICE ,A.BILLING_SPECIALIST ,A.BILL_BY_ID , A.BILL_STATUS , A.ADD_DTTM ,A.INVOICE_TYPE , A.INVOICE_AMOUNT ,A.BI_CURRENCY_CD ,A. DT_INVOICED ,A.DUE_DT FROM PS_BI_HDR A , PS_SET_CNTRL_REC S WHERE S.SETCNTRLVALUE = A.BUSINESS_UNIT AND S.RECNAME = 'CUSTOMER' AND A.TEMPLATE_IVC_FLG = 'N' AND A.CONSOL_HDR <> 'Y' AND A.CONSOL_INVOICE = ' ' AND (A.BILL_STATUS NOT IN ('TMP','TMR') OR (A.BILL_STATUS IN ('TMP','TMR') AND A.PC_DISTRIB_STATUS <> 'I'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SP_SETID_NONVW

2 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_BI_NONVW

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

5 BILLING_SPECIALIST Character(8) VARCHAR2(8) NOT NULL Billing Specialist

6 BILL_BY_ID Character(10) VARCHAR2(10) NOT NULL Bill By Identifier

7 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

8 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added

9 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

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

11 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code

12 DT_INVOICED Date(10) DATE Date Invoiced

13 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
2	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_BI_NONVW
4	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
5	BILLING_SPECIALIST	Character(8)	VARCHAR2(8) NOT NULL	Billing Specialist
6	BILL_BY_ID	Character(10)	VARCHAR2(10) NOT NULL	Bill By Identifier
7	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
8	ADD_DTTM	DateTime(26)	TIMESTAMP	Date Time Added
9	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
10	INVOICE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Amount
11	BI_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Billing Currency Code
12	DT_INVOICED	Date(10)	DATE	Date Invoiced
13	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.