BI_PEND_VW1

(SQL View)
Index Back

BI bill status vw


SELECT H.BUSINESS_UNIT , H.INVOICE , %DatePart(H.ADD_DTTM) , H.BI_CURRENCY_CD , CASE WHEN (H.BI_APPROVAL_STATUS = '1' OR H.BI_APPROVAL_STATUS = '2' OR H.BI_APPROVAL_STATUS = '4' OR H.BI_APPROVAL_STATUS = '5') THEN 'RDA' ELSE H.BILL_STATUS END , H.INVOICE_AMOUNT , H.INVOICE_TYPE , H.BILL_TO_CUST_ID , H.BILL_SOURCE_ID , H.BILL_TYPE_ID , H.BILLING_SPECIALIST , H.CONTRACT_NUM , H.PROJECT_ID , H.BI_APPROVAL_STATUS FROM PS_BI_HDR H WHERE H.CONSOL_HDR IN ('N', ' ') AND H.CONSOL_INVOICE = ' ' AND H.TEMPLATE_IVC_FLG = 'N' AND (( (H.BILL_STATUS IN ('HLD', 'NEW', 'PND', 'RDY') OR (H.BILL_STATUS IN ( 'TMP', 'TMR' ) AND (H.PC_DISTRIB_STATUS <> 'I')) ) ) )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_BI_NONVW

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

Default Value: NEXT

Prompt Table: BI_HDR_IVC_VW

3 DATE_ADDED Date(10) DATE Date Added
4 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code
5 BILL_STATUS_APPRV Character(3) VARCHAR2(3) NOT NULL Bill Status with approval
HLD=Hold Bill
NEW=New Bill
PND=Pending
RDA=Ready to Approve
RDY=Ready to Invoice
TMP=Temporary Bill
TMR=Temporary Ready Bill
6 INVOICE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
7 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
8 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer

Prompt Table: CUST_BI_A2_VW

9 BILL_SOURCE_ID Character(10) VARCHAR2(10) NOT NULL Bill Source
10 BILL_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Bill Type Identifier
11 BILLING_SPECIALIST Character(8) VARCHAR2(8) NOT NULL Billing Specialist
12 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
13 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
14 BI_APPROVAL_STATUS Character(1) VARCHAR2(1) NOT NULL Approval Status
0=Not Required
1=Initial
2=Pending
3=Approved
4=Denied
5=Canceled