BI_SPLST_VW1(SQL View) |
Index Back |
|---|---|
BI bill status vw |
| SELECT H.BUSINESS_UNIT , H.INVOICE , H.INVOICE_DT , H.ACCOUNTING_DT , %DatePart(H.ADD_DTTM) , H.BI_CURRENCY_CD , H.BILL_STATUS , H.INVOICE_AMOUNT , H.INVOICE_TYPE , C.SETID , H.BILL_TO_CUST_ID , H.BILL_SOURCE_ID , H.BILL_TYPE_ID , H.BILLING_SPECIALIST , H.CONTRACT_NUM , H.PROJECT_ID FROM PS_BI_HDR H , PS_CUSTOMER C WHERE C.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE RECNAME = 'CUSTOMER' AND SETCNTRLVALUE = H.BUSINESS_UNIT) AND H.BILL_TO_CUST_ID = C.CUST_ID AND (H.BILL_STATUS IN ('NEW', 'RDY', 'PND', 'HLD') OR ((H.BILL_STATUS = 'TMP' OR H.BILL_STATUS = 'TMR') AND (H.PC_DISTRIB_STATUS <> 'I')) ) AND H.CONSOL_HDR IN ('N', ' ') AND H.CONSOL_INVOICE = ' ' AND H.TEMPLATE_IVC_FLG = 'N' |
| # | 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 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 4 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 5 | DATE_ADDED | Date(10) | DATE | Date Added |
| 6 | BI_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Billing Currency Code |
| 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 | INVOICE_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Amount |
| 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 | CUST_SETID | Character(5) | VARCHAR2(5) NOT NULL | Customer SetID |
| 11 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Customer
Prompt Table: CUST_BI_A2_VW |
| 12 | BILL_SOURCE_ID | Character(10) | VARCHAR2(10) NOT NULL | Bill Source |
| 13 | BILL_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL | Bill Type Identifier |
| 14 | BILLING_SPECIALIST | Character(8) | VARCHAR2(8) NOT NULL | Billing Specialist |
| 15 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 16 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |