ITEM_LNDDT_VW

(SQL View)
 Index Back

Item Line Due Date (SF) View

Item Line Due Date (SF) View

SELECT DISTINCT A.BUSINESS_UNIT ,A.COMMON_ID ,A.COMMON_ID ,A.ACCOUNT_NBR ,A.ACCOUNT_TERM ,A.ITEM_NBR ,A.ITEM_TERM ,A.PAYMENT_ID_NBR ,B.DESCR ,B.LINE_AMT ,A.APPLIED_AMT ,A.ITEM_TYPE ,A.ITEM_TYPE_CD ,B.DUE_DT ,B.BILLING_DT ,B.ITEM_EFFECTIVE_DT ,B.POSTED_DATETIME ,B.POSTED_DATE ,B.ACTUAL_BILLING_DT ,B.LINE_STATUS ,B.LINE_ACTION ,B.LINE_REASON_CD ,B.LINE_SEQ_NBR FROM PS_ITEM_SF A ,PS_ITEM_LINE_SF 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.ITEM_NBR = B.ITEM_NBR AND A.SA_ID_TYPE = 'P'

  • Related Language Record: ITEMLNDDTVWLNG

    • # 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 ACCOUNT_NBR Character(10) VARCHAR2(10) NOT NULL Account Nbr
    5 ACCOUNT_TERM Character(4) VARCHAR2(4) NOT NULL Account Term
    6 ITEM_NBR Character(15) VARCHAR2(15) NOT NULL Item Number
    7 ITEM_TERM Character(4) VARCHAR2(4) NOT NULL Item Term
    8 PAYMENT_ID_NBR Number(12,0) DECIMAL(12) NOT NULL Payment ID Nbr
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    10 ITEM_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Item Amount
    11 APPLIED_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Applied Amount
    12 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type
    13 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
    14 DUE_DT Date(10) DATE Due Date
    15 BILLING_DT Date(10) DATE Billing Date
    16 ITEM_EFFECTIVE_DT Date(10) DATE Item Effective Date
    17 POSTED_DATETIME DateTime(26) TIMESTAMP Posted Date & Time
    18 POSTED_DATE Date(10) DATE Date Posted
    19 ACTUAL_BILLING_DT Date(10) DATE Actual Billing Date
    20 LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Line Status
    A=Active
    C=Contingent
    D=Disputed
    H=Hold
    R=Reversed
    21 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
    22 LINE_REASON_CD Character(4) VARCHAR2(4) NOT NULL Line Reason Code
    23 LINE_SEQ_NBR Number(3,0) SMALLINT NOT NULL Line Sequence Number