BI_SUM_IVC_SRCH(SQL View) |
Index Back |
|---|---|
Correct Sum Inv Search ViewCorrect Summarization template Search View |
| SELECT H.BUSINESS_UNIT , H.INVOICE , H.INVOICE_TYPE , H.BILL_TYPE_ID , H.BILL_SOURCE_ID , H.BILL_TO_CUST_ID , H.INVOICE_AMOUNT FROM PS_BI_HDR H WHERE H.CONSOL_HDR <> 'Y' AND H.PROCESS_INSTANCE = 0 AND H.BILL_STATUS = 'INV' |
| # | 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
Prompt Table: BI_SUM_IVC_SRCH |
| 3 | 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 |
| 4 | BILL_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL | Bill Type Identifier |
| 5 | BILL_SOURCE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Bill Source
Prompt Table: BI_SRC |
| 6 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer |
| 7 | INVOICE_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Amount |