PROJ_TXN_TYP_LN

(SQL Table)
 Index Back

Project Transaction Types Line

Project Transaction Types Line

  • Related Language Record: PROJ_TXP_TYP_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    2 PROJ_TRANS_TYPE Character(3) VARCHAR2(3) NOT NULL Project Transaction Type
    3 EFFDT Date(10) DATE Effective Date
    4 PROJ_DIST_TYPE Character(2) VARCHAR2(2) NOT NULL Project Distribution Type
    AP=Accounts Payable Liability
    AR=Accounts Receivable
    AS=Fixed Asset
    CA=Contra Asset
    CG=Cost of Goods Sold
    CL=Contra Liability
    EX=Expense
    IF=Intercompany From
    IN=Inventory
    IT=Intercompany To
    RE=Revenue
    UE=Unearned Revenue
    UR=Unbilled Receivable
    WP=Work in Progress
    5 DEBIT_CREDIT Character(2) VARCHAR2(2) NOT NULL Debit / Credit Indicator
    CR=Credit
    DR=Debit

    Default Value: DR

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 INTERCOMPANY_SW Character(1) VARCHAR2(1) NOT NULL Intercompany Switch

    Y/N Table Edit

    Default Value: N

    8 FROM_TO_SW Character(1) VARCHAR2(1) NOT NULL From or To Switch
    F=From
    T=To

    Default Value: T

    9 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description