SSF_GL_TRANS_LN

(SQL Table)
 Index Back

Direct GL Transaction Line

  • Parent record: SSF_GL_TRANS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SSF_GL_TRANS_ID Character(12) VARCHAR2(12) NOT NULL GL Transaction ID
    2 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    3 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

    Prompt Table: ITEM_TYPE_TBL

    4 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
    5 ITEM_TERM Character(4) VARCHAR2(4) NOT NULL Item Term

    Prompt Table: TERM_VAL_TBL

    6 ITEM_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Item Amount
    7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    8 TRANS_REF_NO Character(60) VARCHAR2(60) NOT NULL Transaction Reference Nbr
    9 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    10 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    11 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    12 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time