BI_INTFC_ERR_VW

(SQL View)
 Index Back

Srch Rec for Mass Update Comp

Mass Update - List of errors available for Mass Update

SELECT error_status_bi ,intfc_id , business_unit_ca , contract_type , contract_num , business_unit_pc , project_id , bill_to_cust_id , business_unit , billing_specialist , bi_currency_cd FROM ps_intfc_bi WHERE load_status_bi = 'ERR' AND error_status_bi IN ( SELECT intfc_err_stat_bi FROM PS_BI_MC_TMPL_HDR WHERE bi_action_flg = 'Y')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ERROR_STATUS_BI Character(4) VARCHAR2(4) NOT NULL Error Status
2 INTFC_ID Number(8,0) INTEGER NOT NULL Interface ID

Prompt Table: BI_INTFC_ID_DVW

3 BUSINESS_UNIT_CA Character(5) VARCHAR2(5) NOT NULL Contracts Business Unit

Prompt Table: BI_CNRCT_BU_VW

4 CONTRACT_TYPE Character(15) VARCHAR2(15) NOT NULL Contract Type

Prompt Table: BI_CNRCT_TYP_VW
Set Control Field: BUSINESS_UNIT_CA

5 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

Prompt Table: BI_CNRCT_NUM_VW
Set Control Field: BUSINESS_UNIT_CA

6 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Prompt Table: BI_PRJCT_BU_VW

7 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: BI_PRJCT_ID_VW
Set Control Field: BUSINESS_UNIT_PC

8 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer

Prompt Table: BI_CUSTMR_ID_VW

9 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BI_BU_FILTER_VW

10 BILLING_SPECIALIST Character(8) VARCHAR2(8) NOT NULL Billing Specialist

Prompt Table: BI_SPCLST_ID_VW
Set Control Field: BUSINESS_UNIT

11 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code

Prompt Table: CURRENCY_CD_TBL