INTFC_IDBI_INTFC_CRR_VW(SQL View) |
Index Back |
|---|---|
Pending Transactions ViewPending Transactions View |
| SELECT DISTINCT intfc_id , COUNT(intfc_line_num) , SUM(gross_extended_amt) , bi_currency_cd FROM PS_INTFC_BI WHERE intfc_id NOT IN ( SELECT DISTINCT intfc_id FROM PS_INTFC_BI WHERE system_source NOT IN('BBI',' ') OR load_status_bi IN ('ERR','UPD','DON') ) GROUP BY intfc_id, bi_currency_cd |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INTFC_ID |
Number(8,0) | INTEGER NOT NULL | Interface ID |
| 2 | BI_COUNT | Number(9,0) | DECIMAL(9) NOT NULL | BILLING COUNT |
| 3 | GROSS_EXTENDED_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Extended |
| 4 | BI_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Billing Currency Code |