PC_BILLS_VW (SQL View)	Index Back
Project Billing Project Billing view

PC_BILLS_VW

(SQL View)

Project Billing

Project Billing view

SELECT B.BUSINESS_UNIT_PC , B.PROJECT_ID , B.ACTIVITY_ID , B.ANALYSIS_TYPE , B.BUSINESS_UNIT_CA , B.CONTRACT_NUM , B.CONTRACT_LINE_NUM , A.BUSINESS_UNIT , B.INVOICE , B.LINE_SEQ_NUM , A.INVOICE_DT , A.BILL_TO_CUST_ID , A.BILL_STATUS , A.BILLING_SPECIALIST , B.NET_EXTENDED_AMT , B.BI_CURRENCY_CD , B.NET_EXTENDED_BSE , B.BASE_CURRENCY FROM PS_BI_HDR A , PS_BI_LINE B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.INVOICE = B.INVOICE AND B.BUSINESS_UNIT_PC <> ' ' AND B.PROJECT_ID <> ' ' AND B.ACTIVITY_ID <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

3 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

4 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

5 BUSINESS_UNIT_CA Character(5) VARCHAR2(5) NOT NULL Contracts Business Unit

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

7 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num

8 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit

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

10 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence

11 INVOICE_DT Date(10) DATE Invoice Date

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

13 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

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

15 NET_EXTENDED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Extended Amt

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

17 NET_EXTENDED_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Extended Amount

18 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
3	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
4	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
5	BUSINESS_UNIT_CA	Character(5)	VARCHAR2(5) NOT NULL	Contracts Business Unit
6	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
7	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
8	BUSINESS_UNIT_BI	Character(5)	VARCHAR2(5) NOT NULL	Billing Business Unit
9	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
10	LINE_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Sequence
11	INVOICE_DT	Date(10)	DATE	Invoice Date
12	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer
13	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
14	BILLING_SPECIALIST	Character(8)	VARCHAR2(8) NOT NULL	Billing Specialist
15	NET_EXTENDED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Net Extended Amt
16	BI_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Billing Currency Code
17	NET_EXTENDED_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Net Extended Amount
18	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "