BI_INTFC_DTL_VW(SQL View) |
Index Back |
---|---|
Drill down to Interface tableMass 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 |