PROJ_TXP_TYP_LG

(SQL Table)
Index Back

Project Transaction Types Line

Project Transaction Types Line

  • Related Language Record for PROJ_TXN_TYP_LN
  • # 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

    Default Value: %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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description