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 |