RE_SLSCAT_LG

(SQL View)
 Index Back

Sales Categories Lang


SELECT SETID , TXN_GRP , CHG_GRP_CD , EFFDT , LANGUAGE_CD , INSTANCE_NAME , INSTANCE_DESCR FROM PS_RE_CHGGRP_LG WHERE TXN_GRP = '5'

  • Related Language Record for RE_SLS_CAT

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

    Prompt Table: SP_SETID_NONVW

    2 TXN_GRP Character(1) VARCHAR2(1) NOT NULL Transaction Group
    1=Base Rent
    2=Security Deposit
    3=Straightline Accounting
    4=Operating Expense
    5=Percent Rent
    6=Miscellaneous Rent
    7=Manual Fee
    8=Lease Obligation
    9=Lease Interest Expense
    A=Prior Period Lease Obligation
    B=Prior Period Lease Interest
    C=Rent Expense
    D=Lease Incentive

    Default Value: 5

    3 CHG_GRP_CD Character(10) VARCHAR2(10) NOT NULL This field holds the Charge Group Code for the Transaction Groups.
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 INSTANCE_NAME Character(60) VARCHAR2(60) NOT NULL Name
    7 INSTANCE_DESCR Character(150) VARCHAR2(150) NOT NULL Generic Description Field for Instances of Generic Entities