BI_INTFC_DTL_VW

(SQL View)
Index Back

Drill down to Interface table

Mass Update - INTFC_BI detail information in the drill down

SELECT DISTINCT INTFC_ID ,INTFC_LINE_NUM ,TRANS_TYPE_BI ,TRANS_TYPE_BI_SEQ ,BUSINESS_UNIT ,BILL_TO_CUST_ID ,ADDRESS_SEQ_NUM ,SYSTEM_SOURCE ,BILL_SOURCE_ID ,BILL_TYPE_ID ,BILLING_SPECIALIST ,BILLING_AUTHORITY ,PO_REF ,PROJECT_ID ,CONTRACT_NUM ,' ' ,GROSS_EXTENDED_AMT , BI_CURRENCY_CD FROM PS_INTFC_BI

# 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 TRANS_TYPE_BI Character(4) VARCHAR2(4) NOT NULL Transaction Type
AE=Accounting Entry
AHDR=Adjustment Header
DDS=Deferred Discount/Surcharge
DS=Discount/Surcharge
EXSD=Indian Excise/Sales Tax Detail
LINE=Chargeable Line
NOTE=Note/Comment
TAX=Sales/Use Tax Detail
4 TRANS_TYPE_BI_SEQ Number(3,0) SMALLINT NOT NULL Transaction Type Seq
010=Invalid Transaction Type
020=Too many charge lines
030=No charge line for activity
040=Invalid Business Unit
050=Invalid bill-to customer
060=Invalid Billing Address
070=Invalid bill-to contact
080=No Bill Source provided
090=Invalid Bill Source
100=Invalid Bill Type
110=Invalid Bill Cycle
120=Invalid Payment Term
130=Invalid Tax Code
140=Invalid Unit of measure
200=Invalid Standard Note Code
210=No Note Code or Text exists
300=Both Amount & Percentage are 0
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
6 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer

Prompt Table: BI_BILL_TO_VW

7 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
8 SYSTEM_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
9 BILL_SOURCE_ID Character(10) VARCHAR2(10) NOT NULL Bill Source
10 BILL_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Bill Type Identifier
11 BILLING_SPECIALIST Character(8) VARCHAR2(8) NOT NULL Billing Specialist
12 BILLING_AUTHORITY Character(8) VARCHAR2(8) NOT NULL Billing Authority
13 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.
14 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
15 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

Prompt Table: BI_CNRCT_NUM_VW

16 BI_COUNT Number(9,0) DECIMAL(9) NOT NULL BILLING COUNT
17 GROSS_EXTENDED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Extended
18 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code

Prompt Table: CURRENCY_CD_TBL