ITEM_LINE_VW

(SQL View)
 Index Back

Item line View


SELECT business_unit , common_id , common_id , item_nbr , line_seq_nbr , account_nbr , account_term , posted_date , item_effective_dt , billing_dt , actual_billing_dt , due_dt , ref1_descr , line_amt , due_amt , dispute_amt , dispute_dt , acad_career , stdnt_car_nbr , item_term , session_code , class_nbr , finance_charge , encumbrance_dt , encumbered_amt , fee_cd , sel_group , posted_datetime , oprid , line_status , line_action , line_reason_cd , aging_dt , payment_id_nbr , aging_flg , due_date_by , descr , original_acct_term , refund_emplid , gl_posting_dttm , ' ' FROM PS_ITEM_LINE_SF WHERE sa_id_type = 'P'

  • Related Language Record: ITEMLINEVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    4 ITEM_NBR Character(15) VARCHAR2(15) NOT NULL Item Nbr
    5 LINE_SEQ_NBR Number(3,0) SMALLINT NOT NULL Line Sequence Nbr
    6 ACCOUNT_NBR Character(10) VARCHAR2(10) NOT NULL Account Nbr
    7 ACCOUNT_TERM Character(4) VARCHAR2(4) NOT NULL Account Term
    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 DUE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Due Amount
    16 DISPUTE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Dispute Amount
    17 DISPUTE_DT Date(10) DATE Dispute Date
    18 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine
    19 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
    20 ITEM_TERM Character(4) VARCHAR2(4) NOT NULL Item Term
    21 SESSION_CODE Character(3) VARCHAR2(3) NOT NULL Session
    1=Regular Academic Session
    10W=10 Week
    12W=Twelve Week
    4W1=Four Week - First
    4W2=Four Week - Second
    4W3=Four Week - Third
    4W4=Four Week - Fourth
    6W1=Six Week - First
    6W2=Six Week - Second
    8W1=Eight Week - First
    8W2=Eight Week - Second
    A11=Medical Period 1, 4 Weeks
    A12=Medical Period 1, 8 Weeks
    A13=Medical Pd 1, 12 Weeks
    A21=Medical Period 2, 4 Weeks
    A22=Medical Period 2, 8 Weeks
    A23=Medical Period 2, 12 Week
    FYR=Full Year
    MIN=Mini Session
    OEE=Open Entry/Open Exit
    SM1=Semester 1
    SM2=Semester 2
    22 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
    23 FINANCE_CHARGE Character(8) VARCHAR2(8) NOT NULL Finance Charge
    24 ENCUMBRANCE_DT Date(10) DATE Encumbrance Date
    25 ENCUMBERED_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Amount Encumbered
    26 FEE_CD Character(6) VARCHAR2(6) NOT NULL Fee Code
    27 SEL_GROUP Character(10) VARCHAR2(10) NOT NULL Tuition Group
    28 POSTED_DATETIME DateTime(26) TIMESTAMP Posted Date & Time
    29 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    30 LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Line Status
    A=Active
    C=Contingent
    D=Disputed
    H=Hold
    R=Reversed
    31 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
    32 LINE_REASON_CD Character(4) VARCHAR2(4) NOT NULL Line Reason Code
    33 AGING_DT Date(10) DATE Aging Date
    34 PAYMENT_ID_NBR Number(12,0) DECIMAL(12) NOT NULL Payment ID Nbr
    35 AGING_FLG Character(1) VARCHAR2(1) NOT NULL Aging Flag
    36 DUE_DATE_BY Character(3) VARCHAR2(3) NOT NULL Due Date Enter By
    GNR=Generated by Billing
    GRP=Group Post Program
    QCK=Quick Post Program
    TUI=Tuition Calc Program
    37 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    38 ORIGINAL_ACCT_TERM Character(4) VARCHAR2(4) NOT NULL Original Account Term
    39 REFUND_EMPLID Character(11) VARCHAR2(11) NOT NULL Refund ID
    40 GL_POSTING_DTTM DateTime(26) TIMESTAMP GL Posting Date Time
    41 REV_LBL Character(1) VARCHAR2(1) NOT NULL Reverse