BI_BILL_DTL_VW

(SQL View)
 Index Back

Billing Detail View


SELECT a.business_unit ,b.invoice_id ,b.common_id ,b.item_nbr ,b.item_line ,a.emplid ,a.account_nbr ,a.posted_date ,a.item_effective_dt ,a.billing_dt ,a.actual_billing_dt ,a.due_dt ,a.ref1_descr ,a.line_amt ,a.posted_datetime ,a.line_status ,a.line_action ,a.line_reason_cd ,a.aging_dt ,a.gl_posting_dttm FROM PS_ITEM_LINE_SF a ,ps_bi_billing_line b WHERE a.business_unit = b.business_unit AND a.common_id = b.common_id AND a.sa_id_type = b.sa_id_type AND a.sa_id_type = 'P' AND a.item_nbr = b.item_nbr AND a.line_seq_nbr= b.item_line

  • Parent record: ITEM_SF

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

    Prompt Table: SP_BU_SF_NONVW

    2 INVOICE_ID Character(22) VARCHAR2(22) NOT NULL Invoice Number
    3 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
    4 ITEM_NBR Character(15) VARCHAR2(15) NOT NULL Item Nbr
    5 ITEM_LINE Number(3,0) SMALLINT NOT NULL Item Line
    6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    7 ACCOUNT_NBR Character(10) VARCHAR2(10) NOT NULL Account Nbr
    8 POSTED_DATE Date(10) DATE Date Posted
    9 ITEM_EFFECTIVE_DT Date(10) DATE Item Effective Date
    10 BILLING_DT Date(10) DATE Billing Date
    11 ACTUAL_BILLING_DT Date(10) DATE Actual Billing Date
    12 DUE_DT Date(10) DATE Due Date
    13 REF1_DESCR Character(30) VARCHAR2(30) NOT NULL Reference Nbr
    14 LINE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Line Amount
    15 POSTED_DATETIME DateTime(26) TIMESTAMP Posted Date & Time
    16 LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Line Status
    A=Active
    C=Contingent
    D=Disputed
    H=Hold
    R=Reversed
    17 LINE_ACTION Character(3) VARCHAR2(3) NOT NULL Line Action
    APP=Application Generated
    BCK=Backing Out Term Fees
    CCP=Credit Card Payment
    CRV=Charge Reversal
    CSH=Cashiering
    GRP=Group Posting
    INT=Multi Year Interest Calc
    LAT=Late Fee Processing
    NRA=Tax Calculations
    PAY=Payment Posted
    PMT=Excess Payment
    QBK=Quick Post Back Up
    QCK=Posting Page
    REF=Refund Processing
    SSP=Self service payment
    SYS=System Generated
    TAX=Tax Adjustment Page
    TPA=Third Party - Online
    TUI=Tuition Calculation
    WRO=Writeoff Processing
    18 LINE_REASON_CD Character(4) VARCHAR2(4) NOT NULL Line Reason Code
    19 AGING_DT Date(10) DATE Aging Date
    20 GL_POSTING_DTTM DateTime(26) TIMESTAMP GL Posting Date Time