CT_CORE_FIN_BI_INVOICE
       Purpose of Query
       Billing Invoice – Billing Invoice Information. Query prompts on business unit, customer 
       ID and accounting date range.
       Folder
       AR
       Tables
       CTW_BI_INVOICE - Bill Invoice Rpt 
       Prompts
       BUSINESS_UNIT - Unit – (Equal to)
       BILL_TO_CUST_ID - Customer ID like (%) – (Wildcar enabled)
       ACCOUNTING_DT - Accounting Date From / ACCOUNTING_DT - Accounting Date To 
       – (Between condition)  
       Sample Results:
       Criteria
       No hard coded criteria
       Note: Runtime prompts are included as criteria.
       Fields
              Col         Record.Fieldname           Format    Ord    XLA Agg       Heading Text
                                                                       T
                1 A.BUSINESS_UNIT - Business Unit   Char5                         Unit
                2 A.ACCOUNTING_DT - Accounting      Date                          Acctg Date
                   Date
                3 A.INVOICE - Invoice               Char22                        Invoice
                4 A.INVOICE_LINE - Invoice Line     Num5.0                        Line
                5 A.LINE_SEQ_NUM - Sequence         Num5.0                        Line Seq Num
                6 A.LINE_DST_SEQ_NUM - Revenue      Num3.0                        Rev Seq Num
                   Sequence Number
                7 A.BILL_TO_CUST_ID - Customer      Char15                        Bill To Cust ID
                8 A.CT_BILL_CUST_DESCR - Bill       Char40                        Customer Name
                   Customer Description
                9 A.PERCENTAGE - Percentage         SNm5.2                        Percent
               10 A.AMOUNT - Amount                 SNm25.3                       Amount
               11 A.ACCOUNT - Account               Char10                        Acct
               12 A.DEPTID - Department             Char10                        DeptID
               13 A.FUND_CODE - Fund Code           Char5                         Fund
               14 A.CLASS_FLD - Class Field         Char5                         Class
               15 A.PROGRAM_CODE - Program          Char5                         Program
                   Code
               16 A.BUDGET_REF - Budget             Char8                         Bud Ref
                   Reference
               17 A.CHARTFIELD1 - Chartfield 1      Char10                        Chartfield 1
               18 A.PROJECT_ID - Project            Char15                        Project
               19 A.UNIT_OF_MEASURE - Unit of       Char3                         UOM
                   Measure
               20 A.QTY - Quantity                  SNm13.4                       Qty
               21 A.UNIT_AMT - Unit Price           SNm13.4                       Unit Price
               22 A.INVOICE_AMOUNT - Invoice        SNm25.3                       Invoice Amt
                   Amount
               23 A.TOT_LINE_DST_PCT - Total        SNm5.2                        Total Rev Percent
                   Revenue Percent
               24 A.TOT_LINE_DST_AMT - Total Line   SNm25.3                       Total Line Dst 
                   Dist Amount                                                    Amount
               25 A.BILL_STATUS - Bill Status       Char3            N            Bill Status
               26 A.FINAL_FF_EXT_IND - Final Run    Char1                         Final 
                   Indicator 
               27 A.TARGET_PYMT_DT - Target         Date                          Target Date 
                   Payment Date