BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_BI_NONVW
INVOICEBI_HDR_ERR_VW(SQL View) |
Index Back |
|---|---|
BI Header error view |
| SELECT BUSINESS_UNIT , INVOICE , ERROR_STATUS_BI , PROCESS_INSTANCE FROM PS_BI_HDR WHERE ERROR_STATUS_BI <> ' ' AND BILL_STATUS <> 'CAN' |
| # | 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 |
| 3 | ERROR_STATUS_BI | Character(4) | VARCHAR2(4) NOT NULL | Error Status |
| 4 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |