INTFC_BI_C_VW

(SQL View)
 Index Back

Billing Interface - Complete


select intfc_id, intfc_line_num, trans_type_bi, trans_type_bi_seq, business_unit, bill_to_cust_id, invoice, line_seq_num, bill_source_id, bill_type_id, ADJ_TRANS_TYPE, ADJ_DELTA_ACTION, INVOICE_TO_ADJ, LINE_SEQ_TO_ADJ from PS_INTFC_BI_CMP where load_status_bi = 'DON'

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

Prompt Table: INTFC_BI_C2_VW

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
7 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
8 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence
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 ADJ_TRANS_TYPE Character(5) VARCHAR2(5) NOT NULL Adjustment Transaction Type
12 ADJ_DELTA_ACTION Character(3) VARCHAR2(3) NOT NULL Adjustment Delta Action
ADD=Add
DEL=Delete
RPL=Replace
13 INVOICE_TO_ADJ Character(22) VARCHAR2(22) NOT NULL Invoice To Adjust
14 LINE_SEQ_TO_ADJ Number(5,0) INTEGER NOT NULL Line Sequence To Adjust