BI_BILL_PND_VW(SQL View) |
Index Back |
|---|---|
BI bill status vw |
| SELECT H.BUSINESS_UNIT , H.INVOICE , H.DATE_ADDED , H.BI_CURRENCY_CD , H.BILL_STATUS_APPRV , 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 , CASE WHEN (H.BI_APPROVAL_STATUS = '2' OR H.BI_APPROVAL_STATUS = '4' OR H.BI_APPROVAL_STATUS = '5') THEN O.OPRDEFNDESC ELSE ' ' END FROM PS_BI_PEND_VW1 H LEFT OUTER JOIN PS_BI_AW_XREF A INNER JOIN PS_EOAW_STEPINST B ON (A.EOAWTHREAD_ID=B.EOAWTHREAD_ID AND A.EOAWPRCS_ID=B.EOAWPRCS_ID AND A.EOAWDEFN_ID=B.EOAWDEFN_ID) LEFT OUTER JOIN PS_EOAW_USERINST C ON (B.EOAWSTEP_INSTANCE = C.EOAWSTEP_INSTANCE AND C.EOAWSTEP_STATUS = 'P') INNER JOIN PSOPRDEFN O ON (C.OPRID = O.OPRID ) ON (H.BUSINESS_UNIT = A.BUSINESS_UNIT AND H.INVOICE = A.INVOICE) |
| # | 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 |
| 15 | APPROVER_NAME | Character(50) | VARCHAR2(50) NOT NULL | Approver |