BI_CONS_IVC_VW

(SQL View)
 Index Back

Cons Ivc across Bus Units

Cons Ivc across Bus Units

SELECT a.business_unit , a.bill_to_cust_id , a.invoice , a.bi_currency_cd , a.consol_key , a.bill_status , a.bill_fss_status , a.ofac_status , a.invoice_form_id , b.print_form , b.invoice_layout_id , c.page_orientation , a.bill_to_media , a.contract_num , a.invoice_amt_pretax , a.invoice_amount , a.forward_bal_amt , a.paid_amt , a.bi_bu_tax_ind , a.SUMMARIZE_IVC_FLG FROM PS_BI_HDR a , ps_bi_ivc_form b , ps_bi_ivc_layout c WHERE a.process_instance = 0 AND (a.bill_status = 'PND' OR a.bill_status = 'CAN' OR a.bill_status = 'HLD' OR a.bill_status = 'NEW' OR a.bill_status = 'RDY') AND a.consol_hdr = 'Y' AND a.invoice_form_id = b.invoice_form_id AND b.invoice_layout_id = c.invoice_layout_id

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_BI_NONVW

2 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
3 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice

Default Value: NEXT

4 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code
5 CONSOL_KEY Character(22) VARCHAR2(22) NOT NULL Invoice Consolidation Key
6 BILL_STATUS Character(3) VARCHAR2(3) NOT NULL Bill Status
CAN=Canceled
FNL=Finalized Bill
HLD=Hold Bill
INV=Invoiced Bill
NEW=New Bill
PND=Pending Approval
RDY=Ready to Invoice
TMP=Temporary Bill
TMR=Temporary Ready Bill
7 BILL_FSS_STATUS Character(1) VARCHAR2(1) NOT NULL Confirmed
B=Blocked
C=Cleared
R=Review
V=Valid
8 OFAC_STATUS Character(1) VARCHAR2(1) NOT NULL OFAC Status
B=Blocked
C=Cleared
R=Review
V=Valid
9 INVOICE_FORM_ID Character(10) VARCHAR2(10) NOT NULL Invoice Form
10 PRINT_FORM Character(1) VARCHAR2(1) NOT NULL Print Form
11 INVOICE_LAYOUT_ID Character(10) VARCHAR2(10) NOT NULL Invoice Layout ID
12 PAGE_ORIENTATION Character(1) VARCHAR2(1) NOT NULL Layout Type
E=Crystal
L=SQR - Landscape
P=SQR - Portrait
X=XML Publisher
13 BILL_TO_MEDIA Character(1) VARCHAR2(1) NOT NULL Bill To Media
A=Email Invoice as Attachment
E=EDI
H=Federal Highway File
N=Email Notification
P=Print Copy
X=Electronic Invoice File
14 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
15 INVOICE_AMT_PRETAX Signed Number(28,3) DECIMAL(26,3) NOT NULL Pretax Invoice Amount
16 INVOICE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
17 FORWARD_BAL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Forwarding Balance
18 PAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount
19 BI_BU_TAX_IND Character(1) VARCHAR2(1) NOT NULL Billing Business Unit Tax Flag
0=PS standard taxes/VAT
1=Third-party tax supplier
2=India taxes
20 SUMMARIZE_IVC_FLG Character(1) VARCHAR2(1) NOT NULL Summarize Invoice Flag