ERROR_STATUS_BIINTFC_IDBI_CURRENCY_CDBI_MC_WC_VW(SQL View) |
Index Back |
|---|---|
Work Center Search ViewBilling Interface search record for accessing the Mass Update component from the Work Center |
| SELECT DISTINCT error_status_bi ,intfc_id ,bi_currency_cd FROM ps_intfc_bi WHERE load_status_bi <> 'DON' AND load_status_bi = 'ERR' AND error_status_bi IN ( SELECT intfc_err_stat_bi FROM PS_BI_MC_TMPL_HDR) |
| # | 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 |
| 3 | BI_CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Billing Currency Code |