BI_INTFCCMP_FVW(SQL View) |
Index Back |
|---|---|
billing interface complettions |
| SELECT a.INTFC_ID , a.intfc_line_num , a.GROSS_EXTENDED_AMT , a.BI_CURRENCY_CD FROM ps_intfc_bi_cmp a WHERE (a.TRANS_TYPE_BI = 'LINE' OR a.TRANS_TYPE_BI = 'AHDR') AND EXISTS ( SELECT 'x' FROM PS_BI_INTFCERR_FVW b WHERE a.intfc_id = b.intfc_id) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INTFC_ID | Number(8,0) | INTEGER NOT NULL | Interface ID |
| 2 | INTFC_LINE_NUM | Number(8,0) | INTEGER NOT NULL | Interface Line Number |
| 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 |