BI_INTFCERR_VW

(SQL View)
Index Back

interface erros

interface errors

SELECT INTFC_ID , INTFC_LINE_NUM , GROSS_EXTENDED_AMT , BI_CURRENCY_CD , BILL_SOURCE_ID , ERROR_STATUS_BI FROM PS_INTFC_BI WHERE (ERROR_STATUS_BI <> ' ' OR LOAD_STATUS_BI = 'ERR') AND (TRANS_TYPE_BI = 'LINE' OR TRANS_TYPE_BI = 'AHDR')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INTFC_ID Number(8,0) INTEGER NOT NULL Interface ID

Prompt Table: BI_INTFC_ID_DVW

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

Prompt Table: CURRENCY_CD_TBL

5 BILL_SOURCE_ID Character(10) VARCHAR2(10) NOT NULL Bill Source
6 ERROR_STATUS_BI Character(4) VARCHAR2(4) NOT NULL Error Status