BI_HDR_EXPR_VW(SQL View) |
Index Back |
|---|---|
Bill Hdr w/o INV Bil Status vwThis view is adopted from BI_HDR_NOIVC_VW. It is used in Express Bill Entry. |
| SELECT business_unit , invoice , bill_type_id , bill_source_id , bill_to_cust_id , invoice_dt , accounting_dt FROM PS_BI_HDR |
| # | 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 |
| 3 | BILL_TYPE_ID |
Character(3) | VARCHAR2(3) NOT NULL |
Bill Type Identifier
Prompt Table: BI_TYPE |
| 4 | BILL_SOURCE_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Bill Source
Prompt Table: BI_SRC |
| 5 | BILL_TO_CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Customer
Prompt Table: CUST_BI_A2_VW |
| 6 | INVOICE_DT |
Date(10) | DATE | Invoice Date |
| 7 | ACCOUNTING_DT |
Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |