BI_ITEM_ORG_VW

(SQL View)
 Index Back

Billing Item View Org


SELECT A.BUSINESS_UNIT , A.COMMON_ID , A.ITEM_NBR , A.EXT_ORG_ID , A.ACCOUNT_NBR , A.ACCOUNT_TERM , A.ITEM_BALANCE , B.ACCOUNT_TYPE_SF , A.ACAD_YEAR , C.POSTED_DATETIME , C.POSTED_DATE , C.SESSION_CODE , C.DUE_DT , C.LINE_REASON_CD , C.REF1_DESCR , C.ITEM_TERM , C.DESCR , A.ITEM_TYPE , A.ITEM_TYPE_CD , C.LINE_SEQ_NBR , C.LINE_AMT ,A.APPLIED_AMT ,A.ITEM_AMT-A.APPLIED_AMT ,A.CONTRACT_EMPLID ,' ' ,A.CONTRACT_NUM FROM PS_ITEM_SF A , PS_ACCOUNT_ORG_SF B , PS_ITEM_LINE_SF C WHERE C.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.COMMON_ID = A.COMMON_ID AND C.SA_ID_TYPE = A.SA_ID_TYPE AND A.SA_ID_TYPE = 'O' AND A.ACCOUNT_NBR = B.ACCOUNT_NBR AND A.ACCOUNT_TERM=B.ACCOUNT_TERM AND C.ITEM_NBR = A.ITEM_NBR AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.COMMON_ID = B.EXT_ORG_ID

  • Related Language Record: BIITEMORGVWLNG

    • # 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 ITEM_NBR Character(15) VARCHAR2(15) NOT NULL Item Nbr
    4 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    5 ACCOUNT_NBR Character(10) VARCHAR2(10) NOT NULL Account Nbr
    6 ACCOUNT_TERM Character(4) VARCHAR2(4) NOT NULL Account Term
    7 ITEM_BALANCE Signed Number(18,2) DECIMAL(16,2) NOT NULL Item Balance
    8 ACCOUNT_TYPE_SF Character(3) VARCHAR2(3) NOT NULL Account Type
    9 ACAD_YEAR Character(4) VARCHAR2(4) NOT NULL Academic Year
    10 POSTED_DATETIME DateTime(26) TIMESTAMP Posted Date & Time
    11 POSTED_DATE Date(10) DATE Date Posted
    12 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
    13 DUE_DT Date(10) DATE Due Date
    14 LINE_REASON_CD Character(4) VARCHAR2(4) NOT NULL Line Reason Code
    15 REF1_DESCR Character(30) VARCHAR2(30) NOT NULL Reference Nbr
    16 ITEM_TERM Character(4) VARCHAR2(4) NOT NULL Item Term
    17 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    18 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type
    19 ITEM_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Item Type Code
    A=Application Fee
    B=Billing Only
    C=Charge
    D=Deposit
    F=Financial Aid
    G=GL Interface Only
    H=Withholding
    I=Interest
    L=Pre-Paid Tuition
    P=Payment
    R=Refund
    T=Transfers
    V=Contributor Relations
    W=Waiver
    X=Write-off
    Z=Pay Plan Credit
    20 LINE_SEQ_NBR Number(3,0) SMALLINT NOT NULL Line Sequence Nbr
    21 LINE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Line Amount
    22 APPLIED_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Applied Amount
    23 BALANCE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Charge Balance
    24 CONTRACT_EMPLID Character(11) VARCHAR2(11) NOT NULL Contract ID
    25 NAME Character(50) VARCHAR2(50) NOT NULL Name
    26 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number